From a0a5100807f0201b1af63182ce8ef0afe311a9b1 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Mon, 28 Mar 2016 22:28:27 +0200 Subject: [PATCH] remove unused files --- NEWS | 0 settings/partitionedtags.def | 165 ----------------------------------- sql/tables-minimal.sql | 155 -------------------------------- sql/update_bigint.sql | 9 -- 4 files changed, 329 deletions(-) delete mode 100644 NEWS delete mode 100644 settings/partitionedtags.def delete mode 100644 sql/tables-minimal.sql delete mode 100644 sql/update_bigint.sql diff --git a/NEWS b/NEWS deleted file mode 100644 index e69de29b..00000000 diff --git a/settings/partitionedtags.def b/settings/partitionedtags.def deleted file mode 100644 index ef4caf5b..00000000 --- a/settings/partitionedtags.def +++ /dev/null @@ -1,165 +0,0 @@ -amenity airport -amenity arts_centre -amenity atm -amenity auditorium -amenity bank -amenity bar -amenity bench -amenity bicycle_parking -amenity bicycle_rental -amenity brothel -amenity bureau_de_change -amenity bus_station -amenity cafe -amenity car_rental -amenity car_wash -amenity casino -amenity cinema -amenity clinic -amenity club -amenity college -amenity community_centre -amenity courthouse -amenity crematorium -amenity dentist -amenity doctors -amenity dormitory -amenity drinking_water -amenity driving_school -amenity embassy -amenity emergency_phone -amenity fast_food -amenity ferry_terminal -amenity fire_hydrant -amenity fire_station -amenity fountain -amenity fuel -amenity grave_yard -amenity hall -amenity health_centre -amenity hospital -amenity hotel -amenity hunting_stand -amenity ice_cream -amenity kindergarten -amenity library -amenity market -amenity marketplace -amenity nightclub -amenity nursery -amenity nursing_home -amenity office -amenity park -amenity parking -amenity pharmacy -amenity place_of_worship -amenity police -amenity post_box -amenity post_office -amenity preschool -amenity prison -amenity pub -amenity public_building -amenity public_market -amenity reception_area -amenity restaurant -amenity retirement_home -amenity sauna -amenity school -amenity shelter -amenity shop -amenity shopping -amenity social_club -amenity studio -amenity supermarket -amenity taxi -amenity telephone -amenity theatre -amenity toilets -amenity townhall -amenity university -amenity veterinary -amenity waste_basket -amenity wifi -amenity youth_centre -boundary administrative -building apartments -building block -building bunker -building chapel -building church -building commercial -building dormitory -building entrance -building faculty -building farm -building flats -building garage -building hospital -building hotel -building house -building industrial -building office -building public -building residential -building retail -building school -building shop -building stadium -building store -building terrace -building tower -building train_station -building university -highway bridleway -highway bus_stop -highway construction -highway cycleway -highway distance_marker -highway emergency_access_point -highway footway -highway gate -highway motorway_junction -highway path -highway pedestrian -highway platform -highway primary -highway primary_link -highway raceway -highway road -highway secondary -highway secondary_link -highway services -highway steps -highway tertiary -highway track -highway trail -highway trunk -highway trunk_link -highway unsurfaced -historic archaeological_site -historic battlefield -historic building -historic castle -historic church -historic house -historic icon -historic manor -historic memorial -historic mine -historic monument -historic museum -historic ruins -historic tower -historic wayside_cross -historic wayside_shrine -historic wreck -landuse cemetery -landuse commercial -landuse construction -landuse farm -landuse farmland -landuse farmyard -landuse forest -landuse grass -landuse industrial diff --git a/sql/tables-minimal.sql b/sql/tables-minimal.sql deleted file mode 100644 index d7a28633..00000000 --- a/sql/tables-minimal.sql +++ /dev/null @@ -1,155 +0,0 @@ -drop table import_npi_log; -CREATE TABLE import_npi_log ( - npiid integer, - batchend timestamp, - batchsize integer, - starttime timestamp, - endtime timestamp, - event text - ); - -drop table IF EXISTS word; -CREATE TABLE word ( - word_id INTEGER, - word_token text, - word_trigram text, - word text, - class text, - type text, - country_code varchar(2), - search_name_count INTEGER, - operator TEXT - ); -SELECT AddGeometryColumn('word', 'location', 4326, 'GEOMETRY', 2); -CREATE INDEX idx_word_word_id on word USING BTREE (word_id); -CREATE INDEX idx_word_word_token on word USING BTREE (word_token); -GRANT SELECT ON word TO "www-data" ; -DROP SEQUENCE seq_word; -CREATE SEQUENCE seq_word start 1; - -drop table IF EXISTS location_property CASCADE; -CREATE TABLE location_property ( - place_id BIGINT, - partition integer, - parent_place_id BIGINT, - housenumber TEXT, - postcode TEXT - ); -SELECT AddGeometryColumn('location_property', 'centroid', 4326, 'POINT', 2); - -CREATE TABLE location_property_aux () INHERITS (location_property); -CREATE INDEX idx_location_property_aux_place_id ON location_property_aux USING BTREE (place_id); -CREATE INDEX idx_location_property_aux_parent_place_id ON location_property_aux USING BTREE (parent_place_id); -CREATE INDEX idx_location_property_aux_housenumber_parent_place_id ON location_property_aux USING BTREE (parent_place_id, housenumber); - -CREATE TABLE location_property_tiger () INHERITS (location_property); -CREATE INDEX idx_location_property_tiger_place_id ON location_property_tiger USING BTREE (place_id); -CREATE INDEX idx_location_property_tiger_parent_place_id ON location_property_tiger USING BTREE (parent_place_id); -CREATE INDEX idx_location_property_tiger_housenumber_parent_place_id ON location_property_tiger USING BTREE (parent_place_id, housenumber); - -drop table IF EXISTS search_name_blank CASCADE; -CREATE TABLE search_name_blank ( - place_id BIGINT, - search_rank integer, - address_rank integer, - importance FLOAT, - country_code varchar(2), - name_vector integer[], - nameaddress_vector integer[] - ); -SELECT AddGeometryColumn('search_name_blank', 'centroid', 4326, 'GEOMETRY', 2); - -drop table IF EXISTS search_name; -CREATE TABLE search_name () INHERITS (search_name_blank); -CREATE INDEX search_name_name_vector_idx ON search_name USING GIN (name_vector gin__int_ops) WITH (fastupdate = off); -CREATE INDEX searchnameplacesearch_search_nameaddress_vector_idx ON search_name USING GIN (nameaddress_vector gin__int_ops) WITH (fastupdate = off); -CREATE INDEX idx_search_name_centroid ON search_name USING GIST (centroid); -CREATE INDEX idx_search_name_place_id ON search_name USING BTREE (place_id); - -drop table IF EXISTS place_addressline; -CREATE TABLE place_addressline ( - place_id BIGINT, - address_place_id BIGINT, - fromarea boolean, - isaddress boolean, - distance float, - cached_rank_address integer - ); -CREATE INDEX idx_place_addressline_place_id on place_addressline USING BTREE (place_id); -CREATE INDEX idx_place_addressline_address_place_id on place_addressline USING BTREE (address_place_id); - -drop table IF EXISTS place_boundingbox CASCADE; -CREATE TABLE place_boundingbox ( - place_id BIGINT, - minlat float, - maxlat float, - minlon float, - maxlon float, - numfeatures integer, - area float - ); -CREATE INDEX idx_place_boundingbox_place_id on place_boundingbox USING BTREE (place_id); -SELECT AddGeometryColumn('place_boundingbox', 'outline', 4326, 'GEOMETRY', 2); -CREATE INDEX idx_place_boundingbox_outline ON place_boundingbox USING GIST (outline); -GRANT SELECT on place_boundingbox to "www-data" ; -GRANT INSERT on place_boundingbox to "www-data" ; - -drop table country; -CREATE TABLE country ( - country_code varchar(2), - country_name hstore, - country_default_language_code varchar(2) - ); -SELECT AddGeometryColumn('country', 'geometry', 4326, 'POLYGON', 2); -insert into country select iso3166::varchar(2), 'name:en'->cntry_name, null, - ST_Transform(geometryn(the_geom, generate_series(1, numgeometries(the_geom))), 4326) from worldboundaries; -CREATE INDEX idx_country_country_code ON country USING BTREE (country_code); -CREATE INDEX idx_country_geometry ON country USING GIST (geometry); - -drop table placex; -CREATE TABLE placex ( - place_id BIGINT NOT NULL, - partition integer, - osm_type char(1), - osm_id INTEGER, - class TEXT NOT NULL, - type TEXT NOT NULL, - name HSTORE, - admin_level INTEGER, - housenumber TEXT, - street TEXT, - isin TEXT, - postcode TEXT, - country_code varchar(2), - extratags HSTORE, - parent_place_id BIGINT, - linked_place_id BIGINT, - rank_address INTEGER, - rank_search INTEGER, - importance FLOAT, - indexed_status INTEGER, - indexed_date TIMESTAMP, - geometry_sector INTEGER - ); -SELECT AddGeometryColumn('placex', 'geometry', 4326, 'GEOMETRY', 2); -CREATE UNIQUE INDEX idx_place_id ON placex USING BTREE (place_id); -CREATE INDEX idx_placex_osmid ON placex USING BTREE (osm_type, osm_id); -CREATE INDEX idx_placex_rank_search ON placex USING BTREE (rank_search); -CREATE INDEX idx_placex_rank_address ON placex USING BTREE (rank_address); -CREATE INDEX idx_placex_geometry ON placex USING GIST (geometry); -CREATE INDEX idx_placex_parent_place_id ON placex USING BTREE (parent_place_id) where parent_place_id IS NOT NULL; - -DROP SEQUENCE seq_place; -CREATE SEQUENCE seq_place start 1; -GRANT SELECT on placex to "www-data" ; -GRANT UPDATE ON placex to "www-data" ; -GRANT SELECT ON search_name to "www-data" ; -GRANT DELETE on search_name to "www-data" ; -GRANT INSERT on search_name to "www-data" ; -GRANT SELECT on place_addressline to "www-data" ; -GRANT INSERT ON place_addressline to "www-data" ; -GRANT DELETE on place_addressline to "www-data" ; -GRANT SELECT ON seq_word to "www-data" ; -GRANT UPDATE ON seq_word to "www-data" ; -GRANT INSERT ON word to "www-data" ; -GRANT SELECT on country to "www-data" ; diff --git a/sql/update_bigint.sql b/sql/update_bigint.sql deleted file mode 100644 index 9cc0fffb..00000000 --- a/sql/update_bigint.sql +++ /dev/null @@ -1,9 +0,0 @@ -\a -\t -\o /tmp/bigintupdate.sql -select 'alter table "'||relname||'" alter '||attname||' type bigint;' from pg_attribute join pg_class on -(attrelid = oid) where attname like '%place_id%' and attnum > 0 and relkind = 'r'::"char" and atttypid = 23 -and not relname::text ~ '^.*_[0-9]+$' order by 'alter table "'||relname||'" alter '||attname||' type -bigint;'; -\o -\i /tmp/bigintupdate.sql -- 2.39.5