Skip to content

Instantly share code, notes, and snippets.

@apetresc
Created July 26, 2012 17:21
Show Gist options
  • Select an option

  • Save apetresc/3183304 to your computer and use it in GitHub Desktop.

Select an option

Save apetresc/3183304 to your computer and use it in GitHub Desktop.
search_name
nominatim=# \d search_name;
Table "public.search_name"
Column | Type | Modifiers
--------------------+----------------------+-----------
place_id | bigint |
search_rank | integer |
address_rank | integer |
importance | double precision |
country_code | character varying(2) |
name_vector | integer[] |
nameaddress_vector | integer[] |
centroid | geometry |
Indexes:
"idx_search_name_place_id" btree (place_id)
Check constraints:
"enforce_dims_centroid" CHECK (st_ndims(centroid) = 2)
"enforce_srid_centroid" CHECK (st_srid(centroid) = 4326)
Inherits: search_name_blank
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment