“spatial objects system identifier” —- SRID

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’
)

Related posts:

• Introduction of Spatial Data Analysis By R
• 利用python解析基于GraphML的的社会网络并用GIS展示
• the OpenSource on GIS
• Mass Shape File Load into PostGIS
• 几个开源GIS库的更新