id summary reporter owner description type status priority milestone component version severity resolution keywords cc 6452 GeoJSON import with ogr2ogr treat relative URLs as dates ethervoid warmerdam "I have the next geojson file: {{{ {""type"": ""FeatureCollection"", ""features"": [{""type"":""Feature"",""geometry"":{""type"":""Point"",""coordinates"":[-4.72372,41.65518]},""properties"":{""id"":1,""url"":""//images.contentful.com/xts27qnup0jr/47Yq6W7PgAKQKGQ4cSG6oa/7c8d8296ffa3481efd93b2bb2cefc86c/stamen.png"",""name"":""url relativa"",""city"":""valladolid""}}]} }}} When I try to import into postgresql using ogr2ogr, I receive the following error message: {{{ ERROR 1: COPY statement failed. ERROR: date/time field value out of range: ""2000/00/00"" HINT: Perhaps you need a different ""datestyle"" setting. CONTEXT: COPY importer_29147a0400bb11e69244080027eb929e, line 1, column url: ""2000/00/00"" }}} Funny thing is that ogrinfo is detecting it as a string: {{{ ERROR 4: GeoJSON Driver doesn't support update. Had to open data source read-only. INFO: Open of `lala.geojson' using driver `GeoJSON' successful. Layer name: OGRGeoJSON Geometry: Point Feature Count: 1 Extent: (-4.723720, 41.655180) - (-4.723720, 41.655180) Layer SRS WKT: GEOGCS[""WGS 84"", DATUM[""WGS_1984"", SPHEROID[""WGS 84"",6378137,298.257223563, AUTHORITY[""EPSG"",""7030""]], AUTHORITY[""EPSG"",""6326""]], PRIMEM[""Greenwich"",0, AUTHORITY[""EPSG"",""8901""]], UNIT[""degree"",0.0174532925199433, AUTHORITY[""EPSG"",""9122""]], AUTHORITY[""EPSG"",""4326""]] id: Integer (0.0) url: String (0.0) name: String (0.0) city: String (0.0) OGRFeature(OGRGeoJSON):0 id (Integer) = 1 url (String) = http//images.contentful.com/xts27qnup0jr/47Yq6W7PgAKQKGQ4cSG6oa/7c8d8296ffa3481efd93b2bb2cefc86c/stamen.png name (String) = url relativa city (String) = valladolid POINT (-4.72372 41.65518) }}} Any idea? It looks like a bug in the GeoJSON driver, in other formats I don't any problems at all." defect closed normal 2.0.3 default unspecified normal fixed ogr2ogr geojson import