The OpenGIS specification also requires that the internal storage format of spatial objects include a spatial referencing
system identifier (SRID). The SRID is required when creating spatial objects for insertion into the database.
Input/Output of these formats are available using the following interfaces:
bytea WKB = asBinary(geometry);
text WKT = asText(geometry);
geometry = GeomFromWKB(bytea WKB, SRID);
geometry = GeometryFromText(text WKT, SRID);
For example, a valid insert statement to create and insert an OGC spatial object would be:

INSERT INTO SPATIALTABLE (
THE_GEOM,
THE_NAME
)
VALUES (
GeomFromText(’POINT(-126.4 45.32)’, 312),
’A Place’
)

相关文章：

• Introduction of Spatial Data Analysis By R
• the OpenSource on GIS
• Sahana — Disaster Management System
• 利用python解析基于GraphML的的社会网络并用GIS展示
• Why aren’t PostgreSQL R-Tree indexes supported?