issue_comments: 1030461163

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/399#issuecomment-1030461163 https://api.github.com/repos/simonw/sqlite-utils/issues/399 1030461163 IC_kwDOCGYnMM49a5br 9599 2022-02-05T00:30:18Z 2022-02-05T00:30:18Z OWNER

I wonder what the most developer-friendly way to insert geometry data into SpatiaLite is?

From https://www.gaia-gis.it/gaia-sins/spatialite-sql-latest.html it looks like these are the main options:

  • GeomFromText( wkt String [ , SRID Integer] )
  • GeomFromWKB( wkbGeometry Binary [ , SRID Integer] )
  • GeomFromKml( KmlGeometry String )
  • GeomFromGML( gmlGeometry String )
  • GeomFromGeoJSON( geoJSONGeometry String )
  • GeomFromEWKB( ewkbGeometry String )
  • GeomFromEWKT( ewktGeometry String )
  • GeomFromFGF( fgfGeometry Binary [ , SRID Integer] )
  • GeomFromTWKB( twkbGeometry BLOB [ , SRID Integer] )
  • GeomFromGPB( geom GPKG Blob Geometry ) - GeoPackage format
  • GeomFromExifGpsBlob( image BLOB )

Interesting that some accept an SRID and others do not - presumably GeomFromGeoJSON() always uses SRID=4326?

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 1124731464