Skip to main content
naming
Source Link
Vince
  • 20.5k
  • 16
  • 49
  • 65

Using a front end Map UI, I have selected a polygon and received all the Lat/Long points from it. I want to send this data to a Postgres postGISPostgreSQL PostGIS database table that has rows which stores a geometry Point in a column. I need to select all the rows that are inside of the polygon. How do I put the external polygon points into the SQL statement and pull the correct data?

Using a front end Map UI, I have selected a polygon and received all the Lat/Long points from it. I want to send this data to a Postgres postGIS database table that has rows which stores a geometry Point in a column. I need to select all the rows that are inside of the polygon. How do I put the external polygon points into the SQL statement and pull the correct data?

Using a front end Map UI, I have selected a polygon and received all the Lat/Long points from it. I want to send this data to a PostgreSQL PostGIS database table that has rows which stores a geometry Point in a column. I need to select all the rows that are inside of the polygon. How do I put the external polygon points into the SQL statement and pull the correct data?

Source Link

Select Rows with a Point that fall within a set of points that form a polygon from outside the DB

Using a front end Map UI, I have selected a polygon and received all the Lat/Long points from it. I want to send this data to a Postgres postGIS database table that has rows which stores a geometry Point in a column. I need to select all the rows that are inside of the polygon. How do I put the external polygon points into the SQL statement and pull the correct data?