Hi list,
I have a table with all sort of geometry errors - self-intersections, holes
outside polygon, etc. I have some recipes to tackle these problems, but I
have a doubt - is there an order or precedence by which I should tackle
them? I ask these because I have more than one kind of error in a s
Hello,
You might want to try this projection:
http://spatialreference.org/ref/sr-org/6842/postgis/
This the most accurate projections, despite the description on the spatial
reference site. I am doing related work and found this calculator at the
following url
http://landweb.nascom.nasa.gov/cgi-bi
Hello,
I am attempting to store some gps coordinates that i collected for a geospatial
db in precision ag. I created a table with a geometry column called
"Coordinates" using the command "Coordinates" geometry(Point,4326). I then
populated the column using the command
ST_SetSRID(ST_MakePoin
Evan, the internal geometry storage format cannot be changed.
You can query your database to get the "human" values with ST_AsText and
other functions for printing. This depends a lot on what you need to do.
On Mon, Jul 14, 2014 at 5:06 PM, Evan Phillippi
wrote:
> Hello,
>
> I am attempting to
Hello,I am attempting to store some gps coordinates that i collected for a geospatial db in precision ag. I created a table with a geometry column called "Coordinates" using the command "Coordinates" geometry(Point,4326). I then populated the column using the command ST_SetSRID(ST_MakePoint(-89.
Hello,I am attempting to store some gps coordinates that i collected for a geospatial db in precision ag. I created a table with a geometry column called "Coordinates" using the command "Coordinates" geometry(Point,4326). I then populated the column using the command ST_SetSRID(ST_MakePoint(-89.
Google the function st_astext . Should do what you want. Alternatively you
can use st_x and st_y.
Cheers
//JDS
On 14 Jul 2014 22:02, wrote:
> Hello,
>
> I am attempting to store some gps coordinates that i collected for a
> geospatial db in precision ag. I created a table with a geometry colum
There are many geometry output functions [1], such as
ST_AsLatLonText() [2], e.g.:
44°7'15.636"N 89°32'8.880"W
-Mike
[1] http://postgis.net/docs/reference.html#Geometry_Outputs
[2] http://postgis.net/docs/ST_AsLatLonText.html
On 15 July 2014 07:50, wrote:
> Hello,
>
> I am attempting to store
I tried tesselating a cube
NOTE:
SELECT ST_Dimension(ST_GeomFromText('POLYHEDRALSURFACE Z( ((0 0 0, 0 0 1, 0
1 1, 0 1 0, 0 0 0)),
((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0
1, 0 0 1, 0 0 0)),
((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),