Hi,GDAL GeoJSON driver use modified and outdated json-c. It seem to me that this is the bug and ticket in track needed.
Best regards,
Dmitriy
01.08.2013 22:31, Smith, Michael ERDC-RDE-CRREL-NH пишет:
Unfortunately, that¹s after the data has been read and overflowed. The time should be 1375291903959. Updated should be 1375295733317. Mike On 8/1/13 2:21 PM, "Kyle Shannon" <[email protected]> wrote:On Thu, Aug 1, 2013 at 11:36 AM, Smith, Michael ERDC-RDE-CRREL-NH <[email protected]> wrote:I'm reading a geojson feed put out by the USGS (http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/all_day.geojson ) but the time/updated values are overflowing. Are there any settings to allow the data to come across as bigint or strings? For example: {"type":"Feature","properties":{"mag":0.46,"place":"2km W of Lemmon Valley, Nevada","time":1375291903959,"updated":1375295733317,"tz":-420,"url":"htt p://earthquake.usgs.gov/earthquakes/eventpage/nn00419191","detail":"http: //earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nn00419191.geojson","f elt":null,"cdi":null,"mmi":null,"alert":null,"status":"REVIEWED","tsunami ":null,"sig":3,"net":"nn","code":"00419191","ids":",nn00419191,","sources ":",nn,","types":",cap,general-link,geoserve,nearby-cities,origin,","nst" :12,"dmin":0.069,"rms":0.1034,"gap":74,"magType":"ml","type":"earthquake" },"geometry":{"type":"Point","coordinates":[-119.8773,39.632,5.0829]},"id ":"nn00419191"} Gets returned as OGRFeature(OGRGeoJSON):176 mag (Real) = 1.7 place (String) = 21km S of Lowell, Oregon time (Integer) = 902732480 updated (Integer) = 903846662 tz (Integer) = -420 url (String) = http://earthquake.usgs.gov/earthquakes/eventpage/uw60561592 detail (String) = http://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw60561592.geojso n felt (String) = (null) cdi (String) = (null) mmi (String) = (null) alert (String) = (null) status (String) = REVIEWED tsunami (String) = (null) sig (Integer) = 44 net (String) = uw code (String) = 60561592 ids (String) = ,uw60561592, sources (String) = ,uw, types (String) = ,cap,general-link,geoserve,nearby-cities,origin, nst (Integer) = (null) dmin (Real) = 0.24254513 rms (Real) = 0.24 gap (Real) = 118.8 magType (String) = Md type (String) = quarry POINT (-122.7927 43.7262 0) _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-devTry the cast operator in ogr sql: kyle@kyle-workstation:~$ ogrinfo -sql 'select *, cast(time as character(0)),cast(updated as character(0)) from OGRGeoJSON' /vsicurl/http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/all_day. geojson ... OGRFeature(OGRGeoJSON):185 mag (Real) = 2.4 place (String) = 29km N of Brenas, Puerto Rico time (Integer) = 905049680 updated (Integer) = 908474945 tz (Integer) = -240 url (String) = http://earthquake.usgs.gov/earthquakes/eventpage/pr13212004 detail (String) = http://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr13212004.geojson felt (String) = (null) cdi (String) = (null) mmi (String) = (null) alert (String) = (null) status (String) = REVIEWED tsunami (String) = (null) sig (Integer) = 89 net (String) = pr code (String) = 13212004 ids (String) = ,pr13212004, sources (String) = ,pr, types (String) = ,cap,geoserve,nearby-cities,origin,tectonic-summary, nst (String) = 13 dmin (Real) = 0.30722383 rms (Real) = 0.27 gap (Real) = 219.6 magType (String) = Md type (String) = earthquake time (String) = 905049680 updated (String) = 908474945 POINT (-66.3495 18.7346 29) note the values at the bottom, time and update as (String). You could write the entire field list in the sql and substitue time and updated for the casted values. kss_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
