]> git.openstreetmap.org Git - nominatim.git/blob - lib-sql/postcode_tables.sql
Ported functions for the import of special phrases from php to python.
[nominatim.git] / lib-sql / postcode_tables.sql
1 DROP TABLE IF EXISTS gb_postcode;
2 CREATE TABLE gb_postcode (
3     id integer,
4     postcode character varying(9),
5     geometry geometry,
6     CONSTRAINT enforce_dims_geometry CHECK ((st_ndims(geometry) = 2)),
7     CONSTRAINT enforce_srid_geometry CHECK ((st_srid(geometry) = 4326))
8 );
9
10 DROP TABLE IF EXISTS us_postcode;
11 CREATE TABLE us_postcode (
12     postcode text,
13     x double precision,
14     y double precision
15 );