Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 52856

PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.

2 votes
2 answers
1k views

How do I get all geometries within area using Google Maps API info?

lngE, latN: latN }; console.log(obj); Here's what obj can look like: { latN: 47.66808688012437, latS: 47.637501470799144, lngE: -117.40694335937502, lngW: -117.43440917968752, } I have PostGIS … How can I use the info from the Google Maps object to make a PostGIS query that returns rows within the map's north, east, south, and west points? …
Username's user avatar
  • 297
1 vote
2 answers
3k views

How do I use Django to execute PostGIS query to get polygons within four points?

Here's a sample PostGIS query I use to get geometries within four points: SELECT * FROM myTable WHERE ST_MakeEnvelope(-97.82381347656252, 30.250444940663296, -97.65901855468752, 30.29595835209862, 4326 …
Username's user avatar
  • 297
-3 votes
1 answer
173 views

Getting geometry with coordinates in PostGIS?

I have a latitude coordinate and longitude coordinate. I have a table with geometries. What function must I execute to use the coordinates to get a geometry containing the point made by these coordi …
Username's user avatar
  • 297