Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE terrain_points (
- ogc_fid serial NOT NULL,
- elevation double precision,
- );
- SELECT AddGeometryColumn('terrain_points', 'wkb_geometry', 3725, 'POINT', 3 );
- CREATE TABLE terrain_points
- (
- ogc_fid serial NOT NULL,
- wkb_geometry geometry,
- elevation double precision,
- CONSTRAINT terrain_points_pk PRIMARY KEY (ogc_fid),
- CONSTRAINT enforce_dims_wkb_geometry CHECK (st_ndims(wkb_geometry) = 3),
- CONSTRAINT enforce_geotype_wkb_geometry CHECK (geometrytype(wkb_geometry) = 'POINT'::text OR wkb_geometry IS NULL),
- CONSTRAINT enforce_srid_wkb_geometry CHECK (st_srid(wkb_geometry) = 3725)
- )
- WITH (
- OIDS=FALSE
- );
- ALTER TABLE terrain_points OWNER TO postgres;
- -- Index: terrain_points_geom_idx
- -- DROP INDEX terrain_points_geom_idx;
- CREATE INDEX terrain_points_geom_idx
- ON terrain_points
- USING gist
- (wkb_geometry);
- -- points in geographic wgs84 coordinates (epsg:4326)
- create table mypoints (id serial, name varchar, geom geometry(Point, 4326));
- -- lines in spherical mercator (epsg:3857)
- create table mylines (id serial, name varchar, geom geometry(LineString, 3857));
- -- polygons in Dutch national coordinate system (epsg:28992)
- create table mypolygons (id serial, name varchar, geom geometry(Polygon, 28992));
- -- multipolygons in British National Grid (epsg:27700)
- create table
- mymultipolygons(id serial, name varchar, geom geometry(Multipolygon, 27700));
Add Comment
Please, Sign In to add comment