New answers tagged sql-server
In order to determine the correct coordinate system for the input SQL Server data, I exported the data as a shapefile, and ran the following command on the prj file: gdalsrsinfo [table].prj This generated the following PROJ.4 string: +proj=tpeqd +lat_1=49 +lon_1=-110 +lat_2=49 +lon_2=-77 +x_0=0 +y_0=0 +datum=NAD83 +units=m +no_defs I then placed the ...
There is no built-in support in SQL Server 2008. If you want to do it in DB layer then you should use some CLR assembly that parses JSON (Json4sql, JsonSelect, etc.) In SQL Server 2016 you have OPENJSON function that can parse GeoJSON text http://blogs.msdn.com/b/sqlserverstorageengine/archive/2015/10/01/parsing-geojson-format-in-sql-server-2016.aspx
You can use arcpy.da walk function. Check the help doc for an example of how to print all FeatureClasses in a workspace. http://resources.arcgis.com/en/help/main/10.2/index.html#//018w00000023000000
I've tried a possible solution to the convex/concave polygon coordinate orientation, based on the left-hand rule (right-hand if required). Basically we can find the area of a polygon by adding the areas of the trapezoids defined by the polygons edge and a line corresponding to the min Y value of all the coordinates of the polygon. The min Y line is ...
I don't have a C# solution but here is how to do it in Java using JTS and GeoTools. But you should be able to recreate it in any language which provides some basic libraries/methods. The algorithm comes down to for each polygon do if outer ring is counter clockwise then reverse outer ring for each inner ring reverse it so in ...
Resolved. Didn't use geometry columns table or checkbox. Made the id field an int identity (1,1) primary key.
Top 50 recent answers are included