Tag Info

New answers tagged

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 ...


1

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 ...


1

Look into this article. It explains how to apply schema changes with replicas and sync those changes back to the parent. http://resources.arcgis.com/en/help/main/10.1/index.html#//003n000000t2000000


1

That data appears to be in the following coordinate system based on the files I found here. You need to reproject/transform all of your data to be in the same coordinate system, whether it be on the fly in GIS software, or permanently in the data itself. Clarke_1866_Albers Authority: Custom Projection: Albers, False_Easting: 0.0, ...


0

You need to increase the max number of connections allowed to the geodatabase. This can be achieved by altering the max number of connections row in the SDE.server_config table. There is a SDE command for doing this if you are uncomfortable modifying that value directly in the geodatabase. sdeconfig -o alter ...


0

You will have to create a database connection as your desired user with the matching schema. Any data loaded or created will use the schema of your connected user. This same idea applies if you want a user other than SDE or DBO to own the repository.


0

Having a large number of lineages definitely impacts performance. Every database query will be aware of each and every lineage. Effecting overall performance between ArcGIS and the geodatabase. This can be resolved by running a compress more frequently to shrink the lineage length and remove unreferenced states. This KB article describes the impact of a ...



Top 50 recent answers are included