Skip to content

Instantly share code, notes, and snippets.

@silvestrelosada
Created October 30, 2014 09:17
Show Gist options
  • Save silvestrelosada/aeb0972e39e94a9faa0d to your computer and use it in GitHub Desktop.
Save silvestrelosada/aeb0972e39e94a9faa0d to your computer and use it in GitHub Desktop.
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(Geometry,4326) |
Indexes:
"idx_search_name_place_id" btree (place_id)
nominatim=# \d place_addressline
Table "public.place_addressline"
Column | Type | Modifiers
---------------------+------------------+-----------
place_id | bigint |
address_place_id | bigint |
fromarea | boolean |
isaddress | boolean |
distance | double precision |
cached_rank_address | integer |
Indexes:
"idx_place_addressline_place_id" btree (place_id)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment