The following table lists the data and file formats supported by SQL Anywhere for importing and exporting spatial data:
Data format | Import | Export | Description | ||
---|---|---|---|---|---|
Well Known Text (WKT) |
Yes | Yes |
Geographic data expressed in ASCII text. This format is maintained by the Open Geospatial Consortium (OGC) as part of the Simple Features defined for the OpenGIS Implementation Specification for Geographic Information. See www.opengeospatial.org/standards/sfa. Here is an example of how a point might be represented in WKT:
|
||
Well Known Binary (WKB) |
Yes | Yes |
Geographic data expressed as binary streams. This format is maintained by the OGC as part of the Simple Features defined for the OpenGIS Implementation Specification for Geographic Information. See www.opengeospatial.org/standards/sfa. Here is an example of how a point might be represented in WKB:
|
||
Extended Well Known Text (EWKT) |
Yes | Yes |
WKT format, but with SRID information embedded. This format is maintained as part of PostGIS, the spatial database extension for PostgreSQL. See postgis.refractions.net/. Here is an example of how a point might be represented in EWKT:
|
||
Extended Well Known Binary (EWKB) |
Yes | Yes |
WKB format, but with SRID information embedded. This format is maintained as part of PostGIS, the spatial database extension for PostgreSQL. See postgis.refractions.net/. Here is an example of how a point might be represented in EWKB:
|
||
Geographic Markup Language (GML) |
No | Yes |
XML grammar used to represent geographic spatial data. This standard is maintained by the Open Geospatial Consortium (OGC), and is intended for the exchange of geographic data over the internet. See www.opengeospatial.org/standards/gml. Here is an example of how a point might be represented in GML:
|
||
KML |
No | Yes |
Formerly Google's Keyhole Markup Language, this XML grammar is used to represent geographic data including visualization and navigation aids and the ability to annotate maps and images. Google proposed this standard to the OGC. The OGC accepted it as an open standard which it now calls KML. See www.opengeospatial.org/standards/kml. Here is an example of how a point might be represented in KML:
|
||
ESRI shapefiles |
Yes | No |
A popular geospatial vector data format for representing spatial objects in the form of shapefiles (several files that are used together to define the shape). For more information about ESRI shapefile support, see Support for ESRI shapefiles. |
||
GeoJSON | No | Yes |
Text format that uses name/value pairs, ordered lists of values, and conventions similar to those used in common programming languages such as C, C++, C#, Java, JavaScript, Perl, and Python. GeoJSON is a subset of the JSON standard and is used to encode geographic information. SQL Anywhere supports the GeoJSON standard and provides the ST_AsGEOJSON method for converting SQL output to the GeoJSON format. See ST_AsGeoJSON method for type ST_Geometry. Here is an example of how a point might be represented in GeoJSON:
For more information about the GeoJSON specification, see geojson.org/geojson-spec.html. |
||
Scalable Vector Graphic (SVG) files |
No | Yes |
XML-based format used to represent two-dimensional geometries. The SVG format is maintained by the World Wide Web Consortium (W3C). See www.w3.org/Graphics/SVG/. Here is an example of how a point might be represented in SVG:
|
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |