EDIT: I have been using Postgres with PostGIS for a few months now, and I am satisfied. I need to analyze a few million geocoded records, each of which will have latitude and longitude. These records include data of at least three different types, and I will be trying to see if each set influences … Read more
I am trying to insert a row in a table that has a geometry column in Sequelize.js ORM.
I have latitude, longitude and altitude and need to convert it to a point first so I can Insert it as a geometry.
I have a problem with search including sort by distance from some point. Here is my code and what I’m trying to do. Thanks for help
Ubuntu 21.10 , PostgreSQL 13.
I have a table with three columns: two can be used to filter the table, and the last can be used to sort it:
Recently I’ve encountered a problem where I just had to use FromSqlRaw to my db to execute the function of one of Postgresql extensions. This function returns a single entry, and I want to get value of this entry somehow. However, for some reasons I can’t do it this way:
I’ve been trying to setup my windows computer such that I can have a local postgreSQL with PostGIS extension. With this installed I hope to be able to create a project with geodjango locally before putting it in the cloud. I have been working with Django for a little while now on my local machine with the SQLite DB, but since the next project will partly be based on coordinate based data I wanted to setup the right environment.