Skip to main content
Geographic Information Systems

Return to Question

Bumped by Community user
improved formatting
Source Link
edit approved May 19, 2021 at 12:15
menes
edit approved May 19, 2021 at 12:15
menes
  • 1.4k
  • 2
  • 7
  • 25

Based on the following tables:

Street

Street

Municipality

Municipality

I'd like to populate Street.NOM_ENTStreet.NOM_ENT with Municipality.NOM_ENTMunicipality.NOM_ENT and Street.NOM_MUNStreet.NOM_MUN with Municipality.NOMBREMunicipality.NOMBRE any time Street.geomStreet.geom is within Municipality.geomMunicipality.geom.

In other words, I have a table with all the streets in a country and I need to add to witchwhich state and county that street belongs.

I know how to check if Street.geomStreet.geom is within Municipality.geomMunicipality.geom, but I'm kind of new working with postgis/postgres and I'm not sure how to use this as a condition for an UPDATE query.

Based on the following tables:

Street

Street

Municipality

Municipality

I'd like to populate Street.NOM_ENT with Municipality.NOM_ENT and Street.NOM_MUN with Municipality.NOMBRE any time Street.geom is within Municipality.geom.

In other words, I have a table with all the streets in a country and I need to add to witch state and county that street belongs.

I know how to check if Street.geom is within Municipality.geom, but I'm kind of new working with postgis/postgres and I'm not sure how to use this as a condition for an UPDATE query.

Based on the following tables:

Street

Street

Municipality

Municipality

I'd like to populate Street.NOM_ENT with Municipality.NOM_ENT and Street.NOM_MUN with Municipality.NOMBRE any time Street.geom is within Municipality.geom.

In other words, I have a table with all the streets in a country and I need to add to which state and county that street belongs.

I know how to check if Street.geom is within Municipality.geom, but I'm kind of new working with postgis/postgres and I'm not sure how to use this as a condition for an UPDATE query.

naming
Link
Vince
Vince
  • 20.3k
  • 16
  • 48
  • 65

Can I use STWithinST_Within or STContainsST_Contains to update columns based on a geom being within another?

Source Link
Kurt Pelzer
Kurt Pelzer
  • 41
  • 2

Can I use STWithin or STContains to update columns based on a geom being within another?

Based on the following tables:

Street

Street

Municipality

Municipality

I'd like to populate Street.NOM_ENT with Municipality.NOM_ENT and Street.NOM_MUN with Municipality.NOMBRE any time Street.geom is within Municipality.geom.

In other words, I have a table with all the streets in a country and I need to add to witch state and county that street belongs.

I know how to check if Street.geom is within Municipality.geom, but I'm kind of new working with postgis/postgres and I'm not sure how to use this as a condition for an UPDATE query.