Indoor geojson wrong structure?

I believe that using the JSONTemplator is the right way. A template expression example could be provided if you could post a sample of feature attributes (set of name/value pairs) and a GeoJSON document that should be created from the attributes.

Hi @totobobiasos,

The GeoJSON writer may provide what you want. You just need to create the 'level' user attribute on the output feature type, with the type 'json' so you can set a list of values if necessary.

Hi @DaveAtSafe, I'm afraid that the GeoJSON writer won't convert a list attribute to a JSON array. Since the question feature contains a list attribute, I think it would be necessary to convert at least the list attribute to JSON array with the JSONTemplater beforehand, even if you would use the GeoJSON writer to create the destination document.

"These get joined by room number attribute with a Databasejoiner, and because some share rooms, turned into a list attribute."

Hi @takashi,

That's true, although I would have used a ListConcatenator to build the array, then an AttributeCreator to wrap in the square brackets.

I just dislike burying the workspace logic in the JSONTemplater.

... and here is an example of the result json that I wish to match:

Don't know where all the backslashes in my file comes from, though.

 

 

 

{

 

"type": "FeatureCollection",

 

"features": [

 

{

 

"type": "Feature",

 

"id": "way/94551277",

 

"properties": {

 

"type": "way",

 

"id": "94551277",

 

"tags": {

 

"buildingpart": "hall",

 

"height": "3.9",

 

"name": "012"

 

},

 

"relations": [

 

{

 

"role": "buildingpart",

 

"rel": "1370728",

 

"reltags": {

 

"height": "4",

 

"level": "0",

 

"name": "Erdgeschoss",

 

"type": "level"

 

}

 

}

 

],

 

"meta": {}

 

},

 

"geometry": {

 

"type": "Polygon",

 

"coordinates": [

 

[

 

[

 

8.6770429,

 

49.4186016

 

],

 

[

 

8.677043,

 

49.418499

 

],

 

[

 

8.6771835,

 

49.418499

 

],

 

[

 

8.6771835,

 

49.4186016

 

],

 

[

 

8.6770429,

 

49.4186016

 

]

 

]

 

]

 

}

 

},

This workspace example is not a complete solution (since I cannot understand Swedish!), but might help you to resolve the problem about creating JSON array, I think. The point is to use SUB template expression in the JSONTemplater.

jsontemplater-geojson-writer.fmwt (FME 2018.1.0.3)

Ah! I see what you did there. That helped. A LOT. Now I'm getting closer. Just one (or maybe two?) things.

My resulting geojson says:

 

 

"properties" : {

 

"room_number" : "4021",

 

"relations" : "[ { \\"reltags\\" : {

 

\\"level\\" : \\"4\\",

\\"name\\" : \\"Jane Doe\\",

\\"title\\" : \\"hitman\\",

etc. etc. So far so good.

But, the "relations" should be

"relations" : [

not

"relations" : "[

No matter how I bracket my sub template or root template they become objects, not arrays.

 

 

 

Probably you are writing the JSON array as a plain string value into the destination GeoJSON dataset. Make sure that you have set json to the data type for the "relations" column in the User Attributes tab, the GeoJSON writer feature type.

Words cannot describe my current mood.

 

 

Happiness comes pretty close. Be aware that you have made my day.

Very kind regards from Gothenburg, Sweden

Ok! Pretty much solved.

 

This I can do manually, but still..

 

 

The resulting JSON starts with

 

 

"data" : {

 

"type" : "FeatureCollection",

 

"features" : [

 

 

where "data" is the feature type name. However, in the example data the file starts as:

 

{

 

"type" : "FeatureCollection",

 

"features" : [

 

I know I can remove that by writing and reading the file back, substring remove the top most part and the last bracket. But that's not very neat.

 

Thanks for all the help you all!

 

Make sure that the Fully Conform to the GeoJSON Grammar in the GeoJSON writer is set to 'Yes'.