The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
89 views

How to union polygons and add attribute values of combined output features

I have a layer containing 10 polygons all overlapping at various locations. Each polygon has a value of '1' in a column called "value" How do I Union the polygons (rows) together such that the ...
0
votes
1answer
192 views

SQL Geometry Query similar to Select by Centroid

Does anyone know if it's possible to query SQL geometry by something like 'centroid of polygon'...similar to ArcMap's select by location? I'm using SQL Server 2008 R2 as the DBMS. I have two polygon ...
3
votes
4answers
150 views

How to assign geometry to records in a table that contain an ID of a geometry point?

We are looking to map out 'incidents' at schools, but the incident table, which contains a few thousand records, only has a school number (plus the incident data). The table format is an Excel ...
1
vote
3answers
125 views

How to count points once with overlappying polygons?

All, We're using parcel data (polygon) to count student locations (point) based on parcel type. We're doing this using SQL and the ST_Intersects function. It works great, except the City and County ...
0
votes
1answer
49 views

Can distance be calculated to a destination feature based on an attribute in the source?

All, Is it possible to specify which destination point to calculate distance to based on an attribute in the source? STDistance will give me the distance each student (point) is to their closest ...
3
votes
2answers
374 views

Change polygon “handedness” for SQL 2008

I have a few hundred shapes (polygons and multipolygons) each consisting of tens of thousands of points that I am trying to get into SQL 2008. Unfortunately, the shapes I have tried to import are ...
3
votes
2answers
313 views

WMS layers don't draw in QGIS or ArcMap but do in OpenLayers

WMS Map was published by myself in AutoDesk Infrastructure Map Server 2013. I can connect and load detials (properties / metadata) in QGIS Browser, ArcCatelog. I can load the wms into QGIS desktop and ...
2
votes
0answers
124 views

How to do Spatial Tools Projections between different projection types

I am working with the SQL Spatial Tools from http://sqlspatialtools.codeplex.com/ And a variety of data sets, primarily from LINZ and Google. These involve working with projections for 4326 (WGS84?) ...
3
votes
3answers
923 views

SQL Spatial view using a Query Layer in ArcMap 10 is SLOW

We have a number of SQL Spatial views each made up of approximately 10 tables (so relatively complex views) and each including a table with a SQL Geometry column. A view could return up to 300-400 ...
6
votes
3answers
10k views

Create a geography/geometry column from x and y fields - SQL Server 2008

Hy guys, I'm new in SQL Server 2008 and I hope you will understand my question/need. Thus, I have a table which contains 3 fields (Name, Lat and Long) in my data base (spatial). I want to create a ...
3
votes
2answers
534 views

ArcGIS Server and SQL Spatial. Examples?

In-house we have an ArcGIS Server license that I am somewhat familiar with, and a license for SQL Server. I'm looking for some examples of existing web maps that use ArcGIS Server for the display of ...