GeoJSON URL failed to load

GAuber · December 8, 2021, 9:45am

Dear all,
I have an issue adding a new map from following URL:

gregoiredavid/france-geojson/blob/5d34ee6d0140c29f785fdb047d9329f1aab58833/departements/76-seine-maritime/communes-76-seine-maritime.geojson

{"type":"FeatureCollection","features":[{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[1.06525,49.72947],[1.06906,49.72691],[1.07229,49.72528],[1.07647,49.72606],[1.07846,49.72469],[1.0831,49.7233],[1.08384,49.72487],[1.08671,49.72413],[1.09284,49.72447],[1.09373,49.72258],[1.09749,49.72173],[1.0989,49.72043],[1.10192,49.71943],[1.10419,49.71982],[1.10535,49.72077],[1.10724,49.72012],[1.11187,49.72088],[1.11929,49.72344],[1.12253,49.72406],[1.12443,49.72372],[1.13017,49.72104],[1.13261,49.72014],[1.13536,49.71508],[1.13865,49.71632],[1.14277,49.71631],[1.14504,49.71732],[1.14665,49.71639],[1.14703,49.71509],[1.15523,49.71459],[1.15599,49.71195],[1.1546,49.71153],[1.15378,49.7085],[1.15234,49.70513],[1.14991,49.70481],[1.15055,49.70173],[1.15123,49.69985],[1.15271,49.69825],[1.14993,49.69597],[1.14716,49.6928],[1.14225,49.69247],[1.14101,49.69182],[1.13773,49.69171],[1.13502,49.6932],[1.13146,49.69426],[1.13122,49.69564],[1.12043,49.7012],[1.12451,49.7033],[1.12561,49.70952],[1.12254,49.7098],[1.12185,49.70733],[1.11968,49.71099],[1.11387,49.71299],[1.11349,49.71132],[1.1145,49.71004],[1.1145,49.7076],[1.11542,49.70613],[1.11069,49.70702],[1.11126,49.70896],[1.10797,49.71068],[1.10131,49.71596],[1.10019,49.71403],[1.09678,49.71408],[1.09674,49.71578],[1.09356,49.7152],[1.08848,49.71367],[1.08601,49.71252],[1.08555,49.71143],[1.0815,49.71192],[1.07987,49.71069],[1.07124,49.70687],[1.07071,49.71096],[1.0651,49.71089],[1.06412,49.71147],[1.06249,49.71281],[1.06249,49.71505],[1.06522,49.71963],[1.06173,49.72062],[1.06319,49.72288],[1.06363,49.72486],[1.06266,49.72535],[1.06424,49.72869],[1.06525,49.72947]]]},"properties":{"code":"76034","nom":"Auffay"}},{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[1.06526,49.7444],[1.06678,49.74388],[1.06816,49.74511],[1.07731,49.74116],[1.08459,49.74874],[1.08419,49.74906],[1.08994,49.75263],[1.09122,49.75081],[1.09345,49.75173],[1.09787,49.75154],[1.09976,49.75076],[1.10362,49.74791],[1.10663,49.74674],[1.11026,49.74609],[1.111,49.74477],[1.11379,49.74671],[1.11851,49.74631],[1.11879,49.7438],[1.12236,49.74217],[1.12762,49.74065],[1.12964,49.73951],[1.13196,49.73947],[1.13257,49.73678],[1.13609,49.7338],[1.13817,49.73267],[1.14203,49.73176],[1.13949,49.72873],[1.13818,49.72552],[1.13372,49.72354],[1.13232,49.72173],[1.13017,49.72104],[1.12443,49.72372],[1.12253,49.72406],[1.11929,49.72344],[1.11187,49.72088],[1.10724,49.72012],[1.10535,49.72077],[1.10419,49.71982],[1.10192,49.71943],[1.0989,49.72043],[1.09749,49.72173],[1.09373,49.72258],[1.09284,49.72447],[1.08671,49.72413],[1.08384,49.72487],[1.0831,49.7233],[1.07846,49.72469],[1.07647,49.72606],[1.07229,49.72528],[1.06906,49.72691],[1.06525,49.72947],[1.06748,49.73152],[1.06342,49.73292],[1.05481,49.73709],[1.05421,49.73833],[1.05305,49.7389],[1.05648,49.74124],[1.05872,49.74028],[1.06271,49.74122],[1.06526,49.7444]]]},"properties":{"code":"76360","nom":"Heugleville-sur-Scie"}},{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[1.13129,49.68427],[1.13268,49.68743],[1.12692,49.68929],[1.12826,49.69092],[1.12646,49.69199],[1.13042,49.69383],[1.13146,49.69426],[1.13502,49.6932],[1.13773,49.69171],[1.14101,49.69182],[1.14225,49.69247],[1.14716,49.6928],[1.14993,49.69597],[1.15271,49.69825],[1.15123,49.69985],[1.15055,49.70173],[1.16281,49.70221],[1.1656,49.70445],[1.16713,49.70383],[1.17215,49.70343],[1.18042,49.69951],[1.17955,49.69834],[1.17453,49.69608],[1.17688,49.69395],[1.181,49.68952],[1.18189,49.68982],[1.18338,49.68631],[1.18318,49.68474],[1.18149,49.68451],[1.17545,49.68027],[1.16977,49.68335],[1.16524,49.68155],[1.1623,49.68084],[1.16075,49.67853],[1.16316,49.67613],[1.16585,49.67234],[1.1673,49.67086],[1.16034,49.6668],[1.15376,49.66583],[1.1496,49.66823],[1.14543,49.67025],[1.144,49.67139],[1.13927,49.67279],[1.13762,49.67476],[1.13473,49.67984],[1.13129,49.68427]]]},"properties":{"code":"76449","nom":"Montreuil-en-Caux"}},{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[1.05772,49.68954],[1.05549,49.69137],[1.0513,49.68965],[1.04712,49.68848],[1.04727,49.69083],[1.04863,49.69385],[1.05111,49.69757],[1.04858,49.69857],[1.05084,49.69959],[1.05111,49.70282],[1.04983,49.7039],[1.04985,49.70569],[1.05136,49.70629],[1.05486,49.70763],[1.05609,49.71053],[1.05821,49.71216],[1.0614,49.70991],[1.06412,49.71147],[1.0651,49.71089],[1.07071,49.71096],[1.07124,49.70687],[1.07987,49.71069],[1.0815,49.71192],[1.08555,49.71143],[1.08601,49.71252],[1.08848,49.71367],[1.09356,49.7152],[1.09674,49.71578],[1.09678,49.71408],[1.10019,49.71403],[1.10131,49.71596],[1.10797,49.71068],[1.11126,49.70896],[1.11069,49.70702],[1.11542,49.70613],[1.1145,49.7076],[1.1145,49.71004],[1.11349,49.71132],[1.11387,49.71299],[1.11968,49.71099],[1.12185,49.70733],[1.12254,49.7098],[1.12561,49.70952],[1.12451,49.7033],[1.12043,49.7012],[1.13122,49.69564],[1.13146,49.69426],[1.13042,49.69383],[1.12664,49.69622],[1.12345,49.69592],[1.11913,49.69357],[1.11237,49.69751],[1.11513,49.69915],[1.1127

This file has been truncated. show original

I've check this file with geojson.io and it is correct.

Logs give me:
[6538d102-9330-44a6-a571-3f3c19f314c5] 2021-12-08T10:35:29+01:00 DEBUG metabase.server.middleware.log GET /api/geojson 400 78,0 ms (0 DB calls)
"GeoJSON URL failed to load"

and here is the config:
{
"browser-info": {
"language": "fr",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.55 Safari/537.36 Edg/96.0.1054.43",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.11+9-Ubuntu-0ubuntu2.18.04",
"java.vendor": "Ubuntu",
"java.vendor.url": "https://ubuntu.com/",
"java.version": "11.0.11",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.11+9-Ubuntu-0ubuntu2.18.04",
"os.name": "Linux",
"os.version": "4.15.0-163-generic",
"user.language": "fr",
"user.timezone": "Europe/Paris"
},
"metabase-info": {
"databases": [
"mysql",
"h2"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2021-12-02",
"tag": "v0.41.3.1",
"branch": "release-x.41.x",
"hash": "20f9097"
},
"settings": {
"report-timezone": "Europe/Paris"
}
}
}
and help to troublehsoot this would be appreciated

(edit: I have no other custom maps)

flamber · December 8, 2021, 10:02am

Hi @GAuber
You need to link to the actual GeoJSON file, not a website:
https://raw.githubusercontent.com/gregoiredavid/france-geojson/5d34ee6d0140c29f785fdb047d9329f1aab58833/departements/76-seine-maritime/communes-76-seine-maritime.geojson

GAuber · December 8, 2021, 10:20am

Hi @flamber! I've tried that too. Not working either. Same error.

flamber · December 8, 2021, 10:25am

@GAuber Okay, perhaps you have a firewall that is blocking, or problems with other networking.
It's working fine, when I test:

GAuber · December 8, 2021, 10:29am

ok, will look in that direction !

GAuber · December 8, 2021, 10:52am

@flamber, you rock ! That was it ! Thank you !!

Is there any way to use a local geojson file instead of getting this from Internet (something like some proposed: http://localhost/file.geojson) ? Our metabase server is for internal use only and is not normally connecter to Internet. Would love to have a different solution to display this geojson !

flamber · December 8, 2021, 2:17pm

@GAuber Currently not without you adding the GeoJSON to the JAR file (it's just a ZIP-archive) in the same location as the two built-in maps (World and US) in the path /frontend_client/app/assets/geojson/, which can then be referenced with the path http://localhost/app/assets/geojson/<your-file>.geojson

https://github.com/metabase/metabase/issues/5339 - upvote by clicking on the first post

deepesh_inin · June 4, 2024, 7:50am

Hey @flamber,

Trying to wrap my head around the geoJson upload. Every website providing me with the geoJSON of "West Bengal" state in India does not seem to work in Metabase.

Can you please try : IndiaStateTopojsonFiles/WestBengal.geojson at 97f271e17e078e337ed10ae34aa21d75d693fea3 · shuklaneerajdev/IndiaStateTopojsonFiles · GitHub

Thanks

deepesh_inin · June 4, 2024, 9:08am

I think the issue might be in the size of the GeoJson. I passed the above json through https://mapshaper.org/ and downloaded the converted one. Seems to work well. Thanks