Feature request #19754

Support for reading and processing JSON files

Added by Magnus Nilsson over 5 years ago. Updated over 5 years ago.

Status:Open
Priority:Normal
Assignee:-
Category:Data Provider
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:27579

Description

Hi
I have a lot of JSON (not GeoJSON) files with data, in some cases with coordinates. I would like to be able to use them in QGIS, specifically import and flatten them in a processing model.

History

#1 Updated by Giovanni Manghi over 5 years ago

  • Status changed from Open to Feedback

QGIS supportes json datasources, what is this request really for? https://www.gdal.org/drv_geojson.html

#2 Updated by Magnus Nilsson over 5 years ago

The files are not GeoJSON files. An example:

{
"meta" : {
"Version" : "1.0",
"Create time" : "2018-08-30 18:40:02 UTC"
},
"units" : [ {
"dn" : "ou=test,ou=Org,o=xyz",
"attributes" : {
"countryName" : "SE",
"createTimestamp" : "20180504113600Z",
"creatorsName" : "cn=improxy,ou=System,o=test",
"hsaCountyCode" : "14",
"hsaIdentity" : [ "test" ],
"hsaMunicipalityCode" : [ "1480" ],
"modifiersName" : "cn=admin,ou=System,o=test",
"modifyTimestamp" : "20180829082917Z",
"ou" : [ "xyz" ],
"vgrAo3kod" : [ "501" ],
"vgrModifyTimestamp" : "20180618080954Z",
"vgrModifyersName" : "cn=user,ou=Personal,o=test"
}
}, {

I don´t see a way of opening (and flattening) it in QGIS. How do I do that?

#3 Updated by Giovanni Manghi over 5 years ago

  • Status changed from Feedback to Open

This are the supported vector formats via OGR (there are other formats that have a native provider in QGIS);

https://www.gdal.org/ogr_formats.html

Magnus Nilsson wrote:

The files are not GeoJSON files. An example:

{
"meta" : {
"Version" : "1.0",
"Create time" : "2018-08-30 18:40:02 UTC"
},
"units" : [ {
"dn" : "ou=test,ou=Org,o=xyz",
"attributes" : {
"countryName" : "SE",
"createTimestamp" : "20180504113600Z",
"creatorsName" : "cn=improxy,ou=System,o=test",
"hsaCountyCode" : "14",
"hsaIdentity" : [ "test" ],
"hsaMunicipalityCode" : [ "1480" ],
"modifiersName" : "cn=admin,ou=System,o=test",
"modifyTimestamp" : "20180829082917Z",
"ou" : [ "xyz" ],
"vgrAo3kod" : [ "501" ],
"vgrModifyTimestamp" : "20180618080954Z",
"vgrModifyersName" : "cn=user,ou=Personal,o=test"
}
}, {

I don´t see a way of opening (and flattening) it in QGIS. How do I do that?

Also available in: Atom PDF