Jump to content

SQL Server: How to create Wedge (ST_Geometry)


arso

Recommended Posts

I want to create a Wedge in SQL server without using any mapping tool like ArcMap, which will be visualized (only) in ArcGIS. Unfortunately, ST_Geometry is not supported in SQL Server and CircularString is not supported in ArcGIS. 


I assumed to create a buffer around a point but my actual requirement is just a wedge (partial circle with start and end angles). 


For Example, for parametric wedges in PostgreSQL/PostGIS


sde.st_geometry (x, y, z, m, startangleendangleouterradiusinnerradius, number_of_points, srid)


 


Is there anybody who can guide me to create this through any logic?


 


GUID-FB3F64A9-C7CD-4490-A9B4-0C6E288DBD3


Link to comment
Share on other sites

Python could be workaround. Try this,

https://github.com/ngageoint/wedge-maker-4-gis

The tool uses arcgis licenses and needs access to it's tools. Probably you'll have a  shapefile to view in arcgis which can also be stored in your database.  If you do not have the licenses try matplotlib

wedge = mpatches.Wedge(grid[2], 0.1, 30, 270, ec="none")
patches.append(wedge)
label(grid[2], "Wedge")
  • Like 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

Disable-Adblock.png

 

If you enjoy our contents, support us by Disable ads Blocker or add GIS-area to your ads blocker whitelist