Re: [Geojson] Question regarding RFC 7946

[Martin Daly <[e-mail]>]

You have no “FeatureCollection” object, and therefore no “features” array. Your “properties” object does not have commas between consecutive key/value pairs. That’s two problems to be going on with.

You can use jsonlint.com and geojsonlint.com to check your output, which may give clearer errors than you have been getting.

Martin


From: GeoJSON <[e-mail]> On Behalf Of V. Kelly Bellis
Sent: 16 March 2019 16:52
To: [e-mail]
Subject: [Geojson] Question regarding RFC 7946


Hello [e-mail]<mailto:[e-mail]>

Trying to get OpenWeatherMap's list cities into the GeoJSON format has been a great excuse to get reacquainted with regex; however (after two days of failures), I'm wondering: is there a better way?



OpenWeatherMap.org<https://openweathermap.org/> uses a list of cities by ID: http://bulk.openweathermap.org/sample/city.list.json.gz

Typical format contained in city.list.json

[cid:image001.png@01D4DD69.22CB7250]



I first thought a typical record looks similar to the format in GeoJSON<http://geojson.org/>, but not similar enough for Global Mapper which can read GeoJSON files. Here is the result after attempting to read the original OWM format:
[cid:image002.png@01D4DD69.22CB7250]



After starting with the easy change of finding "coords" and changing to "coordinates", I eventually developed:

Find: ^  {\n    "id": ([0-9]*),\n    "name": "([A-Za-z\u00C0-\u017F&\s\'\‘\’]*)",\n    "country": "([A-Z]*)",\n    "coordinates": {\n      "lon": ([-]*)([0-9]*.[0-9]*),\n      "lat": ([-]*)([0-9]*.[0-9]*)\n    }\n  },\n

Replace with: {\n  "type": "Feature",\n  "geometry": {\n    "type": "Point",\n    "coordinates": [\4\5, \6\7]\n  },\n  "properties": {\n    "city_name": "\2"\n    "country_code": "\3"\n    "owm_id": "\1"\n  }\n},\n

From what I've gathered, it is closer to being in the (attached) geojson format (though I haven't dared try and parse https://tools.ietf.org/html/rfc7946 as it's a bit intimidating), but still it fails. And what little I read of it, GeoJSON generally appears to be unforgiving and laden with rigidities.

I've been testing using only regex and a small sample of OpenWeatherMap records wherein I added algebraic signs; i.e., tossed in a couple minus symbols for lon and lat, and added some odd characters, found naturally in the larger dataset.

Here's a before and after screen:

[cid:image003.png@01D4DD69.22CB7250]



Still, Global Mapper balked at my reformatting:

[cid:image004.png@01D4DD69.22CB7250]



At this point, I'm not sure what else I can do to get GM to read the OWM stuff. And to be clear, this was more of an educational lark than anything, all stemming from simply wanting to know the OWM city IDs in a given area.


FWIW, I also wrote to [e-mail]<mailto:[e-mail]> asking:

  1.  Why isn't OWM's format the same as the standard GeoJSON?
  2.  And in followup, could you please consider offering the city id list in GeoJSON format in addition to your own OWM format?

Also, I'm in close contact with Blue Marble Geographics.

Maybe I'll hear from them next week..

Thank you! :)

Kind regards,

Kelly



On 3/15/2019 11:29 AM, Mike Childs wrote:
Hi Kelly,

Their .json file is indeed slightly different than the standard GeoJSON format. I'm not sure whey they chose to get so close to the actual standard but then modify a few things.

Our GeoJSON import capabilities come from a 3rd-party library (GDAL), so we'd need them to add support for this flavor, or you could modify the file directly in a text editor to match the expected format.

I think you could start by changing "coords" to "coordinates", but more may be needed.

Best Regards,

Mike Childs | Global Mapper Guru
Blue Marble Geographics
www.bluemarblegeo.com<http://www.bluemarblegeo.com/?utm_source=signature&utm_medium=email&utm_campaign=website>

22 Carriage Lane
Hallowell, ME 04347 USA
Phone: [phone]
Toll Free: [phone]
Email: [e-mail]<mailto:[e-mail]>

Please note, [e-mail]<mailto:[e-mail]> is no longer an active email - please update your tech support contact to [e-mail]<mailto:[e-mail]>.
[Image removed by sender. Blue Marble GeoTalks on March 21,                                  2019]<http://www.bluemarblegeo.com/bmuc/index.php?aid=siggeotalks01152019&utm_source=signature&utm_medium=email&utm_campaign=geotalks_2019&utm_term=http://www.bluemarblegeo.com/bmuc/index.php&utm_content=signature>

[Image removed by sender. Follow us:]

[Image removed by sender. Facebook]<https://www.facebook.com/bluemarble.geographics>

[Image removed by sender. Twitter]<https://twitter.com/BlueMarbleGeo>

[Image removed by sender. LinkedIn]<http://www.linkedin.com/company/blue-marble-geographics>

[Image removed by sender. YouTube]<http://www.youtube.com/user/BlueMarbleWebinars>

[Image removed by sender. Instagram]<https://www.instagram.com/bluemarblegeo/>


The information in this email message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this email. If you have received this email in error, please notify the sender and delete all copies of the message promptly. Thank you.


On Fri, Mar 15, 2019 at 8:38 AM V. Kelly Bellis <[e-mail]<mailto:[e-mail]>> wrote:

OpenWeatherMap.org<https://openweathermap.org/> uses a list of cities by ID: http://bulk.openweathermap.org/sample/city.list.json.gz

Typical format contained in city.list.json
[cid:image001.png@01D4DD69.22CB7250]

A typical record looks similar to the format in GeoJSON, but not similar enough for Global Mapper.

[cid:image002.png@01D4DD69.22CB7250]



Doubt there's much public need for this, and am just curious - Is it too much bother to expand GM's format choices to include OWM's json? I'll give TextPad and regex  a try just for fun! :)

Thank you! :)

Kind regards,

Kelly

--
V. Kelly Bellis, PLS
17 Union Street
Ellsworth, ME 04605

Precisely Determining True North<https://www.youtube.com/watch?v=zMwDkzl43n8> without a surveyor!
--
V. Kelly Bellis, PLS
17 Union Street
Ellsworth, ME 04605

Precisely Determining True North<https://www.youtube.com/watch?v=zMwDkzl43n8> without a surveyor!