Skip to content
Snippets Groups Projects

Resolve "Create a rule that gets the construction date from cadaster data for Tabula dataset."

All threads resolved!
Compare and Show latest version
1 file
+ 2
3
Compare changes
  • Side-by-side
  • Inline
@@ -44,9 +44,8 @@ class DateFromCadasterRule(AbstractRule):
sql_statement = f"""
SELECT construction_year
FROM Parcels
INNER JOIN cadaster_buildings
USING(parcel_id)
WHERE ST_Intersects({geometry}, p.geom)
INNER JOIN cadaster_buildings USING parcel_id
WHERE ST_Intersects({geometry}, p.geom)
"""
database.cursor.execute(sql_statement)
construction_year = database.cursor.fetchone()
Loading