Continents/Countries borders in PostGIS (Polygon vs Linestring)

Posted by Joey on Stack Overflow See other posts from Stack Overflow or by Joey
Published on 2010-06-15T18:15:09Z Indexed on 2010/06/18 0:23 UTC
Read the original article Hit count: 537

Filed under:
|

Hello guys,

I would like to insert the polygon containing Europe in my PostGIS database.

I have the follwoing extremes points:

NW = NorthWest Border(lat=82.7021697 lon=-28.0371000)

NE = NorthEast Border(lat=82.7021697 lon=74.1357000)

SE = SouthEast Border(lat=33.8978000 lon=74.1357000)

SW = SouthWest Border(lat=33.8978000 lon=-28.0371000)

Is the following a valid polygon:

POLYGON((NWLon NWLat, NELon NELat, SELon SElat, SWLon SWLat, NWlon NWLat))

Is this a valid polygon?

I do see some polygon with the follwing format POLYGON((), ()) ? When are they used?

Why not a linestring?

Any help will be apreciated? This is getting me really confused.

Thanks

© Stack Overflow or respective owner

Related posts about postgresql

Related posts about postgis