<div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Aug 1, 2013 at 1:32 PM, Even Rouault <span dir="ltr"><<a href="mailto:even.rouault@mines-paris.org" target="_blank">even.rouault@mines-paris.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Selon Dmitriy Baryshnikov <<a href="mailto:bishop.dev@gmail.com">bishop.dev@gmail.com</a>>:<br>
<div class="im"><br>
> Hi,<br>
><br>
> GDAL GeoJSON driver use modified and outdated json-c. It seem to me that<br>
> this is the bug and ticket in track needed.<br>
<br>
</div>It would be a 2 step work. I indeed see that newer json-c supports int64, so a<br>
first step would be to make the GeoJSON driver uses the new json-c 64 bit API.<br>
But OGR does not support int64 yet, so the overflow would occur just afterwards.<br>
There's an RFC ( <a href="http://trac.osgeo.org/gdal/wiki/rfc31_ogr_64" target="_blank">http://trac.osgeo.org/gdal/wiki/rfc31_ogr_64</a> ) about that<br>
waiting for implementation.<br></blockquote><div><br></div><div>Folks,</div><div><br></div><div>Also waiting for final refinement and adoption...</div><div><br></div><div>I think I'd like to revisit this issue before the next major release since it is negatively impacting a number of drivers - not just geojson.</div>
<div><br></div><div>Best regards,<br></div><div>Frank</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Best regards,<br>
<br>
Even<br>
<br>
><br>
> Best regards,<br>
> Dmitriy<br>
><br>
> 01.08.2013 22:31, Smith, Michael ERDC-RDE-CRREL-NH Ð¿ÐžÑ ÐµÑ :<br>
> > Unfortunately, that¹s after the data has been read and overflowed.<br>
<div class="HOEnZb"><div class="h5">> ><br>
> > The time should be 1375291903959.<br>
> > Updated should be 1375295733317.<br>
> ><br>
> > Mike<br>
> ><br>
> > On 8/1/13 2:21 PM, "Kyle Shannon" <<a href="mailto:kyle@pobox.com">kyle@pobox.com</a>> wrote:<br>
> ><br>
> >> On Thu, Aug 1, 2013 at 11:36 AM, Smith, Michael ERDC-RDE-CRREL-NH<br>
> >> <<a href="mailto:Michael.Smith@erdc.dren.mil">Michael.Smith@erdc.dren.mil</a>> wrote:<br>
> >>> I'm reading a geojson feed put out by the USGS<br>
> >>><br>
> >>> (<a href="http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/all_day.geojson" target="_blank">http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/all_day.geojson</a><br>
> >>> )<br>
> >>> but the time/updated values are overflowing. Are there any settings to<br>
> >>> allow<br>
> >>> the data to come across as bigint or strings?<br>
> >>><br>
> >>> For example:<br>
> >>> {"type":"Feature","properties":{"mag":0.46,"place":"2km W of Lemmon<br>
> >>> Valley,<br>
> >>><br>
> >>> Nevada","time":1375291903959,"updated":1375295733317,"tz":-420,"url":"htt<br>
> >>> p://<a href="http://earthquake.usgs.gov/earthquakes/eventpage/nn00419191" target="_blank">earthquake.usgs.gov/earthquakes/eventpage/nn00419191</a>","detail":"http:<br>
> >>> //<a href="http://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nn00419191.geojson" target="_blank">earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nn00419191.geojson</a>","f<br>
> >>> elt":null,"cdi":null,"mmi":null,"alert":null,"status":"REVIEWED","tsunami<br>
> >>> ":null,"sig":3,"net":"nn","code":"00419191","ids":",nn00419191,","sources<br>
> >>> ":",nn,","types":",cap,general-link,geoserve,nearby-cities,origin,","nst"<br>
> >>> :12,"dmin":0.069,"rms":0.1034,"gap":74,"magType":"ml","type":"earthquake"<br>
> >>> },"geometry":{"type":"Point","coordinates":[-119.8773,39.632,5.0829]},"id<br>
> >>> ":"nn00419191"}<br>
> >>><br>
> >>> Gets returned as<br>
> >>><br>
> >>> OGRFeature(OGRGeoJSON):176<br>
> >>> mag (Real) = 1.7<br>
> >>> place (String) = 21km S of Lowell, Oregon<br>
> >>> time (Integer) = 902732480<br>
> >>> updated (Integer) = 903846662<br>
> >>> tz (Integer) = -420<br>
> >>> url (String) =<br>
> >>> <a href="http://earthquake.usgs.gov/earthquakes/eventpage/uw60561592" target="_blank">http://earthquake.usgs.gov/earthquakes/eventpage/uw60561592</a><br>
> >>> detail (String) =<br>
> >>><br>
> >>> <a href="http://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw60561592.geojso" target="_blank">http://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw60561592.geojso</a><br>
> >>> n<br>
> >>> felt (String) = (null)<br>
> >>> cdi (String) = (null)<br>
> >>> mmi (String) = (null)<br>
> >>> alert (String) = (null)<br>
> >>> status (String) = REVIEWED<br>
> >>> tsunami (String) = (null)<br>
> >>> sig (Integer) = 44<br>
> >>> net (String) = uw<br>
> >>> code (String) = 60561592<br>
> >>> ids (String) = ,uw60561592,<br>
> >>> sources (String) = ,uw,<br>
> >>> types (String) = ,cap,general-link,geoserve,nearby-cities,origin,<br>
> >>> nst (Integer) = (null)<br>
> >>> dmin (Real) = 0.24254513<br>
> >>> rms (Real) = 0.24<br>
> >>> gap (Real) = 118.8<br>
> >>> magType (String) = Md<br>
> >>> type (String) = quarry<br>
> >>> POINT (-122.7927 43.7262 0)<br>
> >>><br>
> >>> _______________________________________________<br>
> >>> gdal-dev mailing list<br>
> >>> <a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
> >>> <a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
> >> Try the cast operator in ogr sql:<br>
> >><br>
> >> kyle@kyle-workstation:~$ ogrinfo -sql 'select *, cast(time as<br>
> >> character(0)),cast(updated as character(0)) from OGRGeoJSON'<br>
> >> /vsicurl/<a href="http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/all_day" target="_blank">http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/all_day</a>.<br>
> >> geojson<br>
> >><br>
> >> ...<br>
> >><br>
> >><br>
> >> OGRFeature(OGRGeoJSON):185<br>
> >> mag (Real) = 2.4<br>
> >> place (String) = 29km N of Brenas, Puerto Rico<br>
> >> time (Integer) = 905049680<br>
> >> updated (Integer) = 908474945<br>
> >> tz (Integer) = -240<br>
> >> url (String) =<br>
> >> <a href="http://earthquake.usgs.gov/earthquakes/eventpage/pr13212004" target="_blank">http://earthquake.usgs.gov/earthquakes/eventpage/pr13212004</a><br>
> >> detail (String) =<br>
> >> <a href="http://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr13212004.geojson" target="_blank">http://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr13212004.geojson</a><br>
> >> felt (String) = (null)<br>
> >> cdi (String) = (null)<br>
> >> mmi (String) = (null)<br>
> >> alert (String) = (null)<br>
> >> status (String) = REVIEWED<br>
> >> tsunami (String) = (null)<br>
> >> sig (Integer) = 89<br>
> >> net (String) = pr<br>
> >> code (String) = 13212004<br>
> >> ids (String) = ,pr13212004,<br>
> >> sources (String) = ,pr,<br>
> >> types (String) = ,cap,geoserve,nearby-cities,origin,tectonic-summary,<br>
> >> nst (String) = 13<br>
> >> dmin (Real) = 0.30722383<br>
> >> rms (Real) = 0.27<br>
> >> gap (Real) = 219.6<br>
> >> magType (String) = Md<br>
> >> type (String) = earthquake<br>
> >> time (String) = 905049680<br>
> >> updated (String) = 908474945<br>
> >> POINT (-66.3495 18.7346 29)<br>
> >><br>
> >> note the values at the bottom, time and update as (String). You could<br>
> >> write the entire field list in the sql and substitue time and updated<br>
> >> for the casted values.<br>
> >><br>
> >> kss<br>
> > _______________________________________________<br>
> > gdal-dev mailing list<br>
> > <a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
> > <a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
> ><br>
> ><br>
><br>
> _______________________________________________<br>
> gdal-dev mailing list<br>
> <a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
<br>
<br>
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>---------------------------------------+--------------------------------------<br>I set the clouds in motion - turn up | Frank Warmerdam, <a href="mailto:warmerdam@pobox.com" target="_blank">warmerdam@pobox.com</a><br>
light and sound - activate the windows | <a href="http://pobox.com/~warmerdam" target="_blank">http://pobox.com/~warmerdam</a><br>and watch the world go round - Rush | Geospatial Software Developer<br>
</div></div>