common file format

kml

source

• google kml tutorial

gml

source

• wiki
• 中文參考

osm xml

source

• osm wiki

gpx

source

• osm wiki

wkt

source

• wiki
• More about Spatial SQL: WKT and WKB

wkb

source

• oracle doc
• More about Spatial SQL: WKT and WKB

shapfiles (.shp)

source

• wiki
• osm wiki
• postgis intro

geojson

source

• org

topojson

source

• mbostock github wiki

support in postgis function

Well-known text (WKT)

• ST_GeomFromText(text, srid) returns geometry
• ST_AsText(geometry) returns text
• ST_AsEWKT(geometry) returns text

Well-known binary (WKB)

• ST_GeomFromWKB(bytea) returns geometry
• ST_AsBinary(geometry) returns bytea
• ST_AsEWKB(geometry) returns bytea

Geographic Mark-up Language (GML)

• ST_GeomFromGML(text) returns geometry
• ST_AsGML(geometry) returns text

Keyhole Mark-up Language (KML)

• ST_GeomFromKML(text) returns geometry
• ST_AsKML(geometry) returns text

GeoJSON

• ST_AsGeoJSON(geometry) returns text

Scalable Vector Graphics (SVG)

• ST_AsSVG(geometry) returns text