Please help! I have a project using Sequelize, postgres and postgis (for gps). The schema (simplified) is: export default class Activity extends Model { static init(sequelize) { return super.init({ sequelize, tableName: 'activities', }) } static get modelAttributes() { return {…
I have a working SELECT statement but as SQL isn't my strong point I don't know how to make this into an UPDATE function. I have others that work but it appears to be JOIN's getting me here. I've tried…
I am using ST_Intersects to check if two polygons intersect. Relevant part of my query is: SELECT entity_number FROM coordinates WHERE ST_INTERSECTS($1, location) It works well to determine if one polygon scrosses the other's surface: I expected ST_Intersects to return…
How do you connect to specific Postgres schema using Sqlalchemy? So I've created a new schema called "rezerwacja_domkow". I can see it in Pgadmin4. But the whole schema system confuses me (so far I've played only with sqlite which was…
I want to save LineString like the below in Postgresql {"type": "FeatureCollection", "features": [{"type": "Feature", "properties": {"style": {"color": "#19f3e7", "weight": 2}}, "geometry": {"type": "LineString", "coordinates": [[50.998085021972656, 35.83528137207031, 1000.0, 1682083948.0], [50.99810028076172, 35.83527374267578, 1000.0, 1682083948.0], [50.998023986816406, 35.835289001464844, 1000.0, 1682083948.0]]}}]} [50.998085021972656, 35.83528137207031, 1682083948.0]…
I have a couple of tables in PostgreSQL 14.6, with indexes as stated here: # d uprn Table "public.uprn" Column | Type | Collation | Nullable | Default -----------+----------------------+-----------+----------+--------- uprn | text | | | postcode | text | |…
I changed name of PostGIS2.5 Schema from public to supervisor using QGIS 3.2.4; after that I discovered that my data was now unable to display geometry. If you check the geometry column in pgAdmin4, it now reads "supervisor.geometry" instead of…
I'd like to update the geometry definition to include a specific SRID CREATE MATERIALIZED VIEW published.ql_cmd_cruise_layer_web TABLESPACE pg_default AS SELECT ql_cmd_cruise_layer_web.cruise_id, ql_cmd_cruise_layer_web.cruise, ql_cmd_cruise_layer_web.shape_wgs84::geometry(4326) AS shape_wgs84, ql_cmd_cruise_layer_web.cruise_data_url FROM oracle_fdw.ql_cmd_cruise_layer_web WITH DATA; The geom column holds both polygons and multipolygons, so I…
The routed_way table has a column named way where the path of a vehicle is stored. The length of these paths can vary greatly, with some being short and others containing millions of points. Although the table only has thousands…
I have a PostGIS table that stores the locations a device has passed through in the following way: ts lat lon 2022/12/23 10:04 -3.2654 -79.9234 2022/12/23 10:14 -3.2654 -79.9234 2022/12/23 10:24 -2.95592 -79.6833 As the device is transmitting every 10…