I am trying to benchmark MongoDB using berlinMOD data and queries. To represent a single vehicle's trip (trajectory), I'm using multiple documents (point based representation). a Sample: [{ "_id": 3, "tripid": 11, "geom_lnglat": { "type": "Point", "coordinates": [ 4.306468999999999, 50.873466799999974…
I'm consistently having the project function in the terra R package (v1.7-29) crash in R (4.3.0). This happens via Terminal and in RStudio, and despite the terra package being installed without errors. Reprex: library(terra) # SPECIFY PROJECTIONS pt.proj <- "+proj=longlat…
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 am trying to insert Geo location into MySql database using spring data JPA. MySql Version : 5.7.17 For spring boot I have used 2.5.6 boot version and below dependency I have used <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId>…
Trying to edit a column of a table in MariaDB using PHPmyAdmin v5.1.1 gives me trouble. It saves the column as binary and I need to edit the whole row in order to be able to edit it as text.…
I am not an expert at Postgres/GIS subjects and I have an issue with a large database (over 20 million records) of geometries. First of all my set up looks like this: mmt=# select version(); -[ RECORD 1 ]------------------------------------------------------------------------------------------------------------- version…
I have a set of 1000 coordinates, with each representing the urban centres of a particular state. These towns belong to one of 20 counties and I know which towns belong to which county. I wish to shade a map…