(1) abstract geometry; (2) storing geographic data in projected coordinates; (3) a generic ESRI term for vector features; a class for "geometry" objects.

learn more… | top users | synonyms

2
votes
3answers
266 views

Fastest way to join points table to polygons tables in ORACLE

I have two tables in 11g oracle db, one with points geometry, one with polygons. Currently I need to enrich the points table daily with the name of the polygon (country) that the point is inside, but ...
2
votes
2answers
162 views

OSM linestring shown as point

I have loaded the following file http://openstreetmapdata.com/data/coastlines to postgreSQL. In visual studio with gdal/ogr and geos enabled: SELECT geom FROM waterpoly WHERE geom IS NOT NULL LIMIT ...
2
votes
1answer
825 views

PostGIS Select Union of Polygons

I have a Postgres 8.4 PostGIS 2.0 enabled database and I've loaded it up with a bunch of shapefiles. I'm trying to get the database to do on-the-fly unions of geometries. Here is the query I'm ...
2
votes
1answer
304 views

GML - Multi-geometry validation

I'm doing the test to introduce multiple geometry in a WFS service using GML. For now the simple geometry is functional, but I still have some bugs with multiple geometry. I think it may come from my ...
2
votes
2answers
176 views

Is there Shape Metrics Toolbox or equivalent for ArcGIS 10?

I need to compute the geometric properties (e.g. contiguity index, dispersion index etc.) of a series of polygons and I would like to use the Shape Metrics Toolbox. I am using ArcGis 10 and the ...
2
votes
1answer
536 views

How to split zAware polyline by points programmatically with C#?

I'm trying to split a polyline by the boundaries of a polygon using IPolyCurve2.SplitAtPoints using C#. The polyline I'm trying to split is zAware and holds elevation values at a regular interval. ...
2
votes
2answers
160 views

Programmatically change geometry column in OpenLayers WFS layer

is there a way to programmatically change the geometry column on which a WFS layer is based and displayed? WFS (from GeoServer) is correctly returning me two geometry columns, I want to change "on ...
2
votes
1answer
384 views

Remove stale/obsolete geometry columns from the geometry_columns table

I understand that the function Populate_Geometry_Columns() inserts records in the geometry_columns table for geometry columns that are not yet listed there. However, an invocation of ...
2
votes
2answers
622 views

Updating polygon geometry: deleting inner rings with python

I've searched, but can't find clear explanations how can I simply delete inner rings from existing polygons with python or extract outter rings and overwrite the geometry. Seems GDAL/OGR should be the ...
2
votes
1answer
472 views

The minimum bounding circle of geometry that crosses the 180th meridian

Background: I've been given a task where I have to calculate the minimum bounding circle of Alaska (for the purpose of running a Roeck test). I'm using the Census' state level geometries available ...
2
votes
0answers
40 views

QGIS : cannot change the z-coordinate of a point shapefile using the wkb geometry format

I am using QGIS Desktop 2.5.0-Master with GDAL/OGR 1.11.0 on a windows 7. I am working on a little pyQGis script that should modify the z-coordinate of points in a vector shapefile based on a value ...
2
votes
1answer
59 views

Is a point within a polygon

I need help in this question. To explain briefly -- the question is: Whether a point with coordinates lng:-80.087535 lat: 42.054246 lies over or under line with coordinates: lng: -80.267831 ... ...
2
votes
0answers
30 views

Is there a way to eliminate duplicate 'point clusters' in SQL Server 2008 r2 spatial?

I am using the ST.Distance function to identify clusters of geometry data points. Each point has a unique reference number associated with it. I would like to eliminate duplicate clusters from the ...
2
votes
1answer
94 views

How do I use code (preferably c#) to clip all points within a shapefile that are not contained within a polygon?

So the task is simple: I want to take a point shapefile as input and remove all of the points that are not contained within a polygon. I'm using DotSpatial to do this, but the catch is that there are ...
2
votes
0answers
62 views

How to offset/displace overlapping lines in a web map?

I have a dataset of points representing a To/From status - something like distribution centres and delivery addresses. When the user clicks on a point I'd like to show the relationships between this ...
2
votes
0answers
59 views

PostGIS does not export shortest path to Shapefile

I am trying to draw a bunch of lines overlaying the globe map in a WGS84 projection. To this effect I have created a PostGIS DB with a table that has one column containing linestring data. My problem ...
2
votes
1answer
40 views

How to generate features to test different implementations of LinearRing?

I have some code that throws the following exception: Points of LinearRing do not form a closed linestring and I want to check if my code is calling this correctly by supplying some features that ...
2
votes
1answer
176 views

Calculating area [closed]

I have a polygon layer. I toggled to edit mode. I added a new column, while number (integer) and called it "area". I then use the field calculator - geometry - $area to populate the polygon area for ...
2
votes
0answers
71 views

Critera for geometry or geography

What criteria do you need to take account to before you choose geometry or geography map? Is there a book or page about it?
2
votes
0answers
164 views

how to convert lat and longitude into distance near poles?

I am trying to convert latitude and longitude into meters in polar regions. I am looking for higher accuracy upto 0.00 meters preferably. I tried the haversine formula but it doesnt seem to be ...
2
votes
1answer
690 views

Using MS SQL 2005 as the data store in GeoServer

In my project, I am trying to set up a simple WFS service in GeoServer in order to create a layer consisting of point features. I have succeeded doing so with the points being stored in a shapefile. ...
1
vote
2answers
3k views

How to initialize a WFS Layer?

Here is the code block (the layers are stored in Oracle database): var saveStrategy = new OpenLayers.Strategy.Save(); var adresspt_wfs = new OpenLayers.Layer.Vector("Address points WFS", ...
1
vote
2answers
145 views

Distance between latlongs varies in different projection systems?

I have shapefiles with correct projections. The SRS is EPSG 32735 (WGS 1984 UTM 35S) Now, I have these two coordinates from this projection system: (31.3751,-23.4388) and (31.3779,-23.4355). ...
1
vote
1answer
806 views

PostGIS and geometry column

I have a csv table. Each record includes a start node (lat1,lon1) and an end node (lat2,lon2). I have already imported the .csv into Postgresql 8.4. Now I would like set the geometry column. I tried ...
1
vote
2answers
1k views

what is the format of Geometry data type of SQLServer 2008

I want to know, In which format the Geographic data stored in geometry data type of SQLServer 2008.it looks like a long string,like 0xE6100010466DFEOA4089663524....... for one polygon. My second ...
1
vote
3answers
125 views

Geometry vs geography for line-to-polygon intersection

I have two WGS84 NAD83 shapefiles, one polygonal, the other containing lines: Geometry: Polygon Feature Count: 1294 Extent: (-79.761059, 44.991143) - (-57.105486, 62.582865) Layer SRS WKT: ...
1
vote
3answers
720 views

In ArcMap, what is the difference between Copy Parallel and Buffer?

To build an offset of a linear feature in ArcMap, what is the difference between Copy Parallel and Buffer? In terms of the resulting features and their linear differences from the source linear ...
1
vote
1answer
23 views

Is averaging the points for lines and multilines a valid method of getting the centroid?

I'm working with a SqlGeometry SqlServer DB and am a novice to GIS. I'm tasked with getting the centroid of a series of geometries from C#'s SqlGeometry object. This is fine as it has a GetCentroid ...
1
vote
2answers
155 views

Export polygon in geojson as multipolygon

Anyone knows if is there any way to export a polygon layer in geojson, as multipolygon? I have a multipolygon shapefile. But there are single and multi polygons. When I export it to geojson, I got ...
1
vote
1answer
108 views

How do I figure out the grid references (Eastings and Northings) necessary to create a circular 1 mile radius around one location?

How do I figure out the grid references necessary to create a circular 1 mile radius around one location? For instance: Grid Reference: SO 47904 87484 X (Eastings): 347904 Y (Northings): 287484 ...
1
vote
2answers
508 views

ST_DWithin uses Geometry or Geography type

assuming I use the following query to match the locations to a poi within 10km distance: SELECT poi.poi_id, h.loc_id, (ST_Distance(poi.geom,h.geom)*111.111) as distanceinkm FROM iut_poi_transl AS ...
1
vote
2answers
628 views

dealing with 2 different coordination systems in postGIS

I'm seeking a function that converts degrees to the following format: POINT(405115.926025391 4543389.4354248) I dont know this format's name, but is there any function to do so? Cheers, EDIT ...
1
vote
1answer
37 views

How to save changes in Feature-Geometry with GDAL/OGR and Python? (Segmentation fault)

I have a problem with my code: driver = ogr.GetDriverByName('ESRI Shapefile') dataSource = driver.Open('merge.shp', 0) if dataSource is None: print 'Could not open file' sys.exit(1) layer = ...
1
vote
1answer
39 views

Set default projection of geometry objects in arcpy

I have a script that creates a polyline geometry from scratch using some math to generate coordinate pairs. At the same time, there is a user-defined polygon shapefile that is used to "erase" the ...
1
vote
1answer
85 views

GeographyFromText and ST_SetSRID+ST_MakePoint different results?

Why am I getting different results? SELECT ST_DISTANCE( ST_GeographyFromText('SRID=4326;POINT(13.401111 52.383343)'), --berlin ST_GeographyFromText('SRID=4326;POINT(9.997559 53.533778)') ...
1
vote
1answer
129 views

Openlayers WMS getFeatureInfo get features with geometry attribute

I am displaying map using WMSlayer and implemented WMSGetFeatureInfo control on wms layer. Tap on a location and get the features using WMS getFeatureInfo service. This service is returning me all ...
1
vote
1answer
78 views

Locating 0-points multipart polygons using arcpy

By Running this piece of code: import arcpy arcpy.env.workspace = "C:\working\GEODATABASES\\tests.gdb" fcList = arcpy.ListFeatureClasses() for fc in fcList: with arcpy.da.SearchCursor(fc, ...
1
vote
1answer
347 views

Is it possible to get a binary geometry from PostGIS?

PostgreSQL (via C# Npgsql driver) returns geometry column (PostGIS) like a hex string (EWKB as I understand) for this query: SELECT ST_Transform(geometry, 4326) FROM myGeometries; Result (for ...
1
vote
2answers
175 views

Is there an average size for British postcodes?

Is there an average size for British postcodes? Or a method of determining the size for a particular British postcode? Thanks. Considering creating a related program and this would be valuable ...
1
vote
1answer
210 views

Get Polygon or IGeometry from Envelope in ArcObjects

I would like to create a Polygon Feature from the geometry of an IEnvelope in C# ArcObjects SDK 10. Is there an easy way how to do it?
1
vote
3answers
329 views

KML to Shapefile using GDAL (LIBKML) - MultiGeometry data not transforming

I am trying to convert a KML file to Shapefile using GDAL (ogr2ogr). Regular KML files convert fine but KML files containing MultiGeometry features (eg: Geometry containing both Point and Polygon) do ...
1
vote
1answer
75 views

PostGIS Geometry folder is missing

I have installed PostgreSQL 9.2 and PostGIS 2.0.3 from Stackbuilder. My template_postgis_20 does not have a geometry table only spatial_ref_sys table. Is that a problem? and if not how can i create ...
1
vote
1answer
66 views

ArcObjects- IBorder.GetGeometry() in Python

I am trying to get geometry of frame border trough IFrameElement.Border. I do receive IBorder object, which has .GetGeometry() method. How do I use this method to get geometry of the border? I can ...
1
vote
1answer
633 views

How to add constraints in PostGIS?

I have table that containing road network. Table structure is CREATE TABLE final_all_india_road_network ( gid serial NOT NULL, "name" character varying(254), code character varying(254), ...
1
vote
1answer
349 views

ESRI android SDK Calculate area in square meters from polygon geometry

Hello I have a Polygon object in ESRI Android SDK that I'm creating on a map, I would like to calculate that polygon object to square meters. currently I use double area=polygon.calculateArea2D(); ...
1
vote
1answer
1k views

How to create multipart line and polygon with interior ring in ArcGIS Python?

My objective is to swap X,Y coordinates of feature classes using Python and arcgisscripting. Based on help examples, I managed to write script which reads and writes all geometry types. The problem ...
1
vote
1answer
2k views

ArcGIS API for Silverlight - pass geometries to ESRI service

How would I test this service to find what it wants? ...
1
vote
1answer
290 views

Building orientation and simplification using Opencarto Java library

I need to find out orientation of buildings and perform simplification of sides of buildings with a tolerance. I came to know from StackExchange that OpenCarto has useful libraries for geometrical ...
1
vote
1answer
43 views

How to calculate distances in QGIS field calculator?

So I'm using qgis 2.6.0 and I have a csv (converted into a .shp) with two geometry columns, I want to create a new column with the distance between the two geometry: shot.lat shot.lon haul.lat ...
1
vote
1answer
30 views

How to import geometry data from csv file to postgres?

I have geometry file in *.xls file, but when I save in *.csv it say "some feature in your workbook might be lost if you save it as CSV (Comma delimited)" however I keep that file anyway and when I ...