I've decided to write a small webapp using Flask, postgresql and leaflet. I wanted to store coordinates (latitude and longitude) using PostGIS extender for postgresql. My flask application uses Fla...

For exammple, class Lake(Base): __tablename__ = 'lake' id = Column(Integer, primary_key=True) name = Column(String) geom = Column(Geometry('POLYGON')) point = Column(Geometry('Point')) lak...

I am using PostgreSQL, SQLAlchemy and GeoAlchemy2 libraries to store some geospatial coordinates in the database. I define the database column in my database as follows using Python: import sqlal...

I'm trying to create an in-memory SQLite database off of SQLAlchemy ORMs originally designed for a Postgres database. To allow the SQLite engine to convert postgres specific datatypes, I've relied ...

My problem is this. I'm creating a model for some data. class Cables(Base): __tablename__ = 'cables' id = Column(Integer, nullable=False) route = Column(Geometry(geometry_type='LINESTRING', sr...

I'm having difficulty with (I think) the ORM for geoalchemy2. My model is defined as follows: class Location(Model): point = Column(Geometry('POINT', dimension=3, srid=4326)) I later insert as ...

To extend my restfull api with GPS locations I decided to try geoalchemy. I already have a database going and I think it saves the points to my database already. However, everytime I try to print a...

I need to implement a query using GeoAlchemy to get all the Points that are near a given Point (for example, within a 10 meter radius). For storing points, i am using Geography fields in my PostGIS...