About populations and profiles for isochrones on self hosted ors instance

RaikoPipe · December 7, 2023, 12:48pm

Hi,

I’m hosting my own ors instance and use it for requesting isochrones. Now I’m facing two issues:

Some profiles like “cycling-electric” lead to a status 500 error response. Profiles like “driving-car” seem to work fine though. Even though my request has the “total_pop” attribute, the response doesn’t return it.

Any help would be appreciated! Thanks!

amandus · December 8, 2023, 12:32pm

Hi @RaikoPipe,

that’s probably an issue with your configuration.
Check if localhost:8082/ors/v2/status shows cycling-electric in the profiles (adjust port if needed).

Regarding population data see:

github.com/GIScience/openrouteservice

Missing documentation about population data setup with Docker

opened 09:25AM - 26 Mar 21 UTC

elpaso

documentation :book: docker

I'll see if I find the time to contribute that. for now, quick notes: ### …Prepare your data Source: https://data.jrc.ec.europa.eu/dataset/jrc-ghsl-ghs_pop_gpw4_globe_r2015a ### Crop your raster using a mask if you don't need the whole world I am using a shapefile with the USA boundaries in EPSG:54009 `usa_54009.shp` to clip the raster: ```bash gdalwarp -of GTiff -co "COMPRESS=LZW" -cutline usa_54009.shp -multi -r bilinear -wo NUM_THREADS=ALL_CPUS -overwrite -crop_to_cutline GHS_POP_E2015_GLOBE_R2019A_54009_250_V1_0.tif GHS_POP_E2015_GLOBE_R2019A_54009_250_V1_0_USA_LZW.tif gdaladdo GHS_POP_E2015_GLOBE_R2019A_54009_250_V1_0_USA_LZW.tif 2 4 8 16 32 64 ``` ### Import into postgis I am using the target DB `qgis_tests` ```bash raster2pgsql -s 954009 -t 1024x1024 -l 2,4,8,16,32 -I -C GHS_POP_E2015_GLOBE_R2019A_54009_250_V1_0_USA_LZW.tif ghs_pop_2015_esri54009 | psql qgis_tests ``` If your postgis is missing EPSG:54009 you can add it with: ```bash cat <<<_TXT_ INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 954009, 'esri', 54009, '+proj=moll +lon_0=0 +x_0=0 +y_0=0 +ellps=WGS84 +datum=WGS84 +units=m +no_defs ', 'PROJCS["World_Mollweide",GEOGCS["GCS_WGS_1984",DATUM["WGS_1984",SPHEROID["WGS_1984",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Mollweide"],PARAMETER["False_Easting",0],PARAMETER["False_Northing",0],PARAMETER["Central_Meridian",0],UNIT["Meter",1],AUTHORITY["EPSG","54009"]]'); _TXT_ | psql qgis_tests ``` ### Add to `app.config` `services.isochrones` section: ```json "statistics_providers": { "provider1": { "enabled": true, "provider_name": "postgresql", "provider_parameters": { "host": "[IP of local db]", "port": 5432, "db_name": "qgis_tests", "user": "my username", "password": "my passwor", "table_name": "ghs_pop_2015_esri54009", "geometry_column": "rast" }, "property_mapping": { "total_pop": "total_pop" }, "attribution": "European Commission, Joint Research Centre (JRC); Columbia University, Center for International Earth Science Information Network - CIESIN (2015): GHS population grid, derived from GPW4, multitemporal (1975, 1990, 2000, 2015). European Commission, Joint Research Centre (JRC) [Dataset] PID: http://data.europa.eu/89h/jrc-ghsl-ghs_pop_gpw4_globe_r2015a" } ```

That’s more or less what you need to do, but we currently don’t have documentation for that yet.

The correct location in the new ors-config.yml is probably endpoints.isochrones.statistics_provider (in yaml format instead of dot notation ofc).

Best regards

RaikoPipe · January 12, 2024, 4:42pm

Thanks for the help @amandus! Using your advice, I could address the issue regarding the missing profiles. Next, I will try your solution regarding the configuration of the population layer.

Best regards
Richard

zacki41 · March 12, 2024, 6:55pm

Dear all,

has anyone yet successfully implemented the population on a self hosted instance using docker compose and can share their approach ?
I wasn’t yet able to implement the github solution provided by elpaso.
Greetings
Florian