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" <k...@pobox.com> wrote: >On Thu, Aug 1, 2013 at 11:36 AM, Smith, Michael ERDC-RDE-CRREL-NH ><michael.sm...@erdc.dren.mil> 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 >> gdal-dev@lists.osgeo.org >> 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 gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev