Selon Dmitriy Baryshnikov <[email protected]>: > Hi, > > GDAL GeoJSON driver use modified and outdated json-c. It seem to me that > this is the bug and ticket in track needed.
It would be a 2 step work. I indeed see that newer json-c supports int64, so a first step would be to make the GeoJSON driver uses the new json-c 64 bit API. But OGR does not support int64 yet, so the overflow would occur just afterwards. There's an RFC ( http://trac.osgeo.org/gdal/wiki/rfc31_ogr_64 ) about that waiting for implementation. Best regards, Even > > 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-dev > >> Try 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 _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
