1
vote
1answer
100 views

Insert geometric data to a column from coordinate values in double precision

Screenshot of database http://wp.me/aIW9p-i0 For table “households”, I want to create two new columns: 1) “Geom”, data type – geometry; 2) “WKT”, data type ‐ text; I am intending to do the following ...
2
votes
1answer
3k views

Make POINT from longitude/latitude coordinates from existing table in PostGIS

I would like to make a POINT using the longitude and latitude columns of an existing table. Here's a link to the documentation of ST_MakePoint. Here's my table: CREATE TABLE sysinst.bio ( oid ...
5
votes
1answer
272 views

How do you fix Overlapping Lines?

I have a line dataset that contains some lines where the "end points" are actually found in the middle of the line. In the image below, the nodes are shown in green and one of the end points in red. ...
8
votes
4answers
11k views

How to get coordinates from geometry in PostGIS?

This line: SELECT geom FROM myLayer.geom will return a hex value, i'm wondering how would it be possible to get decimal values, a result that look likes human-readable coordination? Regards,
2
votes
3answers
2k views

Convert coordinates to geometry (polygon) using QGIS

I have an Excel sheet with grid data including geographical coordinates. I know that the coordinates represent areas, i.e., a multi(polygon). However, the data lacks geometry information. I'm looking ...
0
votes
0answers
21 views

World country borders in polygon geometry format [duplicate]

Possible Duplicate: Where do I get territories data? Is there some source I can get all world countries polygon geometry points with latitude and longitude? I find it for USA states but ...
4
votes
2answers
1k views

How to update geometry in ArcObjects?

I'm just starting with ArcObjects and I want to update coordinates of geometry vertices. Specifically, I want to swap X, Y coordinates for each vertex of polygons (which can be multipart and have ...
0
votes
3answers
3k views

Get geometry from coordinates

I have a table with geometry column called point, saved in SRID 4326. I want to get the geometry by its coordinates, but something didn't work. I suspect database configuration or something. Here is ...
2
votes
1answer
1k views

How to make a predetermined Polygon (Circle) From 4 Coordinates, The Radius and Center Longitude and Latitude in Openlayers

I know how to make a predetermined Polygon in Openlayers (see below). Please have a look at http://studio.netnrg.co.za/dev/rnd/blake.loizides/openlayers var feature2 = new ...
3
votes
5answers
5k views

Calculate midpoint from a series of latitude and longitude coordinates

I've got a series of longitude and latitude coordinates which represent a building outline e.g. -0.5485381346101759,53.2285150736142 -0.5482220594232723,53.22842450827133 ...