Tag Info

New answers tagged

1

Since you've already got a list of dicts, you can use Shapely (to manage the geometry) and Fiona (to write the shape file). from shapely.geometry import mapping from shapely.wkt import loads from fiona import collection schema = {'geometry': 'Point', 'properties': {'atribute1':'value', 'atribute2':'value'}} with collection("output.shp", "w", "ESRI ...


0

First, if you don't have a geometry/geography column in the table yet, add it by converting WKT or WKB to geometry/geography using SQL Server Spatial (STLineFromText, STPOlyFromText, STPointFromWKT, similarily works from WKB). Then, simply connect to the database (Database Connection) and create a query layer. At this point, you'll have a layer in the ...


0

There are no known issues of performance degradation with upgrading to SQL SERVER 2008 R2. In the recent times the only bug that I can think of is [NIM082657:When working with an SQL Server 2012 geodatabase and Geometry or Geography type data, ArcMap drawing performance is slower than it was using SQL Server 2008. This affects all rendering and editing ...


0

The error is not very clear, but definitely not related to the number of users connecting to the database. (In such cases you get error - Unable to connect to database. Maximum number of connections to instance exceeded). I error message mentions STATE_ID, considering this I would recommend you to COMPRESS the database once (it is okay to compress even ...


0

I think this will work: Dim queryAddress As New StringBuilder() queryAddress.Append("http://maps.google.com/maps?q=") For i = 0 To Me.DataGridView1.RowCount - 1 If Me.DataGridView1.Rows(i).Cells(0).Value <> String.Empty Then lat = Me.DataGridView1.Rows(i).Cells(0).Value queryAddress.Append(lat + "%2C") ...


0

I started down a similar path with Shape2SQL, but now I am using the Natural Earth shape files - they are great and cover all countries down to an incredible level of detail (railroads!): http://www.naturalearthdata.com Laurent Dupuis has shared his amazing project which shreds ALL of the natural earth data (including all the dbf attributes) straight from ...


2

You may use ListWorkspaces method (once you make the connection) to list the existing databases within SDE: Lists all of the workspaces within the set workspace. Search conditions can be specified for the workspace name and workspace type to limit the list that is returned. workspaces = arcpy.ListWorkspaces("*", "SDE") for workspace in ...


4

Maybe check out the properties of Projected Coordinate Systems, to get a view into their utility? There are 3 aspects or properties presented in Projected Coordinate Systems that establish their utility and rationale. Any projection of 3D space on a 2D surface will of course exhibit distortion versus reality. Depending on your application, using a specific ...


7

There's a good answer over at Stack Overflow, which goes a little something like this: The geography type is a little bit more restrictive than geometry. It can't cross different hemispheres and the outer ring must be drawn counter-clockwise. The rest can be found here. Another article goes into some more detail: If you’re looking for the ...


0

The Microsoft Developer Network help docs seem promising. Here is an example from the help on to test for intersection: DECLARE @geom1 geometry; DECLARE @geom2 geometry; DECLARE @result geometry; SELECT @geom1 = GeomCol1 FROM SpatialTable WHERE id = 1; SELECT @geom2 = GeomCol1 FROM SpatialTable WHERE id = 2; SELECT @result = @geom1.STIntersection(@geom2); ...


0

You can use either Well-Known Text (WKT) or Well-Known Binary (WKB) as these can be read/written by both MapXtreme and SQL Server 2008. For MapXtreme you should be able to find utilities for doing so in the MapInfo.OGC namespace. From the MapXtreme 7.0 documentation: OGC Conversion for Geometries and Coordinate Systems The MapXtreme Extensible Data ...


1

ArcGIS is very sensitive to database names. You cannot restore data unless the database name is identical. You will need to use Feature Class to Feature Class or a copy/paste, or any of the other ways to copy data with Desktop or ArcPy (the list of options can be daunting). All transfers should be done as the data owner(s), not as the administrative 'sde' ...


1

The reason databases implement R-tree indexes for spatial is because they are faster than geohashes or searches on separate x and y indexes. The problem with geohashes, is that you have to search 9 quadrants, not just 1, to do proximity type searches -- see geohash limitations. They are useful in databases that lack R-trees, to allow the expression of an ...


1

The fix is defining a filterType parameter in the OpenLayers.Control.GetFeature constructor: new OpenLayers.Control.GetFeature({ filterType: OpenLayers.Filter.Spatial.INTERSECTS, ... The default filterType is OpenLayers.Filter.Spatial.BBOX that results correctly in an uncertain Filter() query in SQL Server, when a spatial index is set. If ...


6

No, you do not need ArcGIS Server to edit your MS SQL Server database. If you want to continue to interface with ArcMap/ArcCatalog without a ArcGIS Server license you do have at least one other (albeit non-free, but definitely cheaper than an ArcGIS Server License) option. I need to be able to connect to the ms sql server and import, export, create, and ...


5

To be able to work with a geodatabase stored in SQL Server you would need at least ArcGIS Server Basic Workgroup (see matrix here). You can work with simple features in ArcMap, but no geodatabase editing or alike will be available. Since you have ArcGIS Desktop (I assume you have Standard or Advanced), you get automatically access to geodatabase stored ...



Top 50 recent answers are included