Tagged Questions
2
votes
1answer
62 views
Calculating points in the USDA's Cropland Data Layer coordinate system
I need to integrate against the USDA's cropland data layer. They've got a demo and some API docs.
The important query I need to run is this, given an (x, y) of say (1551459.363, 1909201.537):
...
0
votes
1answer
200 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 ...
1
vote
4answers
305 views
Query Postgis Table with PHP
Would you be so kind as to help me with the following in OpenLayers. I need to be able to use the coordinates from a user click in a postgis query. To catch the coordinates of a click I built a click ...
3
votes
3answers
989 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,
0
votes
1answer
225 views
To get attribute data of polygon layer by giving Lat/Lon
Is anyone having an idea about how to get attribute data of a polygon layer by giving Coordinates with in that polygon. Here i have tried with these codes..
SELECT * FROM kar_bbmp_198 WHERE ...
4
votes
1answer
156 views
Spatial index vs two coordinates indexes
I have a table with two columns: latitude and longitude. I want to get all objects inside a "rectangular" (well, rectangular in a lat/lon coordinate metric) bounding box: min-max latitude and min-max ...
