*To:* postgis-users@lists.osgeo.org
*Sent:* Monday, March 23, 2015 12:09 AM
*Subject:* [postgis-users] Need help on basic concepts, I just need
really simple calculations
Hi,
I've been searching online for days. Trying to understand why SRID is
required. So I picked some random value.
Now I'm need
From: Aaron Lewis the.warl0ck.1...@gmail.com
To: postgis-users@lists.osgeo.org
Sent: Monday, March 23, 2015 12:09 AM
Subject: [postgis-users] Need help on basic concepts, I just need really
simple calculations
Hi,
I've been searching online for days. Trying to understand
Hi,
I've been searching online for days. Trying to understand why SRID is
required. So I picked some random value.
Now I'm need to retrieve POINTs within a circle range, e.g a circle at
(146.0, 138.19) with radius of 100 meters:
SELECT * FROM users
WHERE ST_DWithin (users.location,
Hi Aaron,
SRID is used to set a consistent coordinate system to the data. It refers
to an EPSG Coordinate Reference System (CRS). For instance, EPSG:2600: (
http://spatialreference.org/ref/epsg/2600/) is a metric CRS.
Coordinates (146.0, 138.19) are not valid in SRID 2600 (nor in lat/long
Hey,
I would sugger to read a little bit about geographical information
https://en.wikipedia.org/wiki/Spatial_reference_system before using
PostGIS.
The unit depend on the way you measure, which depends on the Spatial
Reference System.
If you want it is a bit like measuring the temperature in
, 100);
(I haven't tested it, but I think this should work)
Cheers
Bent Wood
From: Aaron Lewis the.warl0ck.1...@gmail.com
To: postgis-users@lists.osgeo.org
Sent: Monday, March 23, 2015 12:09 AM
Subject: [postgis-users] Need help on basic concepts, I just need really
simple calculations
From: Aaron Lewis the.warl0ck.1...@gmail.com
To: postgis-users@lists.osgeo.org
Sent: Monday, March 23, 2015 12:09 AM
Subject: [postgis-users] Need help on basic concepts, I just need really
simple calculations
Hi,
I've been searching online for days. Trying