Skip to content

Instantly share code, notes, and snippets.

@joaofig

joaofig/match-trips_insert_geometry.py

Created June 18, 2023 14:50
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save joaofig/e5817b821fadd60049b8db0482f1d347 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save joaofig/e5817b821fadd60049b8db0482f1d347 to your computer and use it in GitHub Desktop.
Download ZIP
Inserts the geometry string
Raw
match-trips_insert_geometry.py
def insert_geometry(traj_id: int,
geometry: str) -> None:
db = TrajDb()
sql = "insert into traj_match (traj_id, geometry) values (?, ?)"
db.execute_sql(sql, [traj_id, geometry])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment