Last active
September 27, 2018 15:18
-
-
Save pigreco/75ae641a5ecd455e77c9bd9593b35920 to your computer and use it in GitHub Desktop.
test velocità
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
time[secs] | programma | dataset | PC | Piattaforma | |
---|---|---|---|---|---|
52 | QGIS DEV 3.3 | sqlite + spatialindex 1M points | AMD 2.10 Ghz 8 gb RAM | Win 10 64b OSGeo4W | |
206 | QGIS DEV 3.3 | sqlite + spatialindex 5M points | AMD 2.10 Ghz 8 gb RAM | Win 10 64b OSGeo4W | |
93 | QGIS 3.2.3 | sqlite + spatialindex 1M points | AMD 2.10 Ghz 8 gb RAM | Win 10 64b OSGeo4W | |
352 | QGIS 3.2.3 | sqlite + spatialindex 5M points | AMD 2.10 Ghz 8 gb RAM | Win 10 64b OSGeo4W | |
87 | QGIS 2.18.24 | sqlite + spatialindex 1M points | AMD 2.10 Ghz 8 gb RAM | Win 10 64b OSGeo4W | |
311 | QGIS 2.18.24 | sqlite + spatialindex 5M points | AMD 2.10 Ghz 8 gb RAM | Win 10 64b OSGeo4W | |
61 | SpatiaLite_GUI 2.10 | sqlite + spatialindex 1M points | AMD 2.10 Ghz 8 gb RAM | Win 10 64b | |
72 | SpatiaLite_GUI 2.10 | sqlite + spatialindex 5M points | AMD 2.10 Ghz 8 gb RAM | Win 10 64b | |
562 | QGIS DEV 3.3 | GPKG 5M points | AMD 2.10 Ghz 8 gb RAM | Win 10 64b OSGeo4W | |
220 | QGIS DEV 3.3 | GPKG + spatialindex 5M points | AMD 2.10 Ghz 8 gb RAM | Win 10 64b OSGeo4W | |
12 | pgadmin3 | postgis + spatialindex 5M points | AMD 2.10 Ghz 8 gb RAM | Win 10 64b | |
97 | mapshaper | shp riga comando linux 5M points | AMD 2.10 Ghz 8 gb RAM | Win 10 64b | |
24 | R Studio | GPKG 5M points | AMD 2.10 Ghz 8 gb RAM | Win 10 64b |
PostGIS -https://postgis.net/
select r.id as rowid, count(*) as nro
from reticolo r, vertici p
where st_contains(r.geom, p.geom)
group by 1
order by 1
R + RStudio - https://www.r-project.org/
library(rgdal)
library(GISTools)
setwd("F:\\aiuti_QGIS\\dottorando")
layers <- ogrListLayers("dati.gpkg")
punti<-readOGR("dati.gpkg", layers[1])
reticolo<-readOGR("dati.gpkg", layers[2])
#### calcolo conteggio ########
conteggio<-poly.counts(punti, reticolo)
#### calcolo conteggio con misura tempo esecuzione #######
start.time <- Sys.time()
conteggio<-poly.counts(punti, reticolo)
end.time <- Sys.time()
time.taken <- end.time - start.time
time.taken
Output
QGIS 3.3 dev - https://qgis.org/it/site/
utilizzando le tabelle in postgresql/postgis con spatialindex
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Mapshaper - https://mapshaper.org/
wiki
output