Commit Graph

  • 48249be3b3 fixes typo Carla 2014-09-30 11:57:17 +02:00
  • 67d7c99a64 Merge pull request #84 from CartoDB/iri/finishesadm0 Andrew W. Hill 2014-09-25 14:13:22 -04:00
  • ca096f09ae Merge pull request #77 from CartoDB/iri/issue-55 Andrew W. Hill 2014-09-25 14:12:29 -04:00
  • 8112594ed9 Splits all geometries to allow all adm0 regions Carla 2014-09-25 14:14:41 +02:00
  • 322b30c724 added synonym readme andrewxhill 2014-09-20 00:15:20 +02:00
  • aee9556afa admin0 synonym service andrewxhill 2014-09-20 00:12:25 +02:00
  • a55632d779 readme andrewxhill 2014-09-20 00:08:00 +02:00
  • cf609dbac9 first draft available services api andrewxhill 2014-09-20 00:05:53 +02:00
  • d42e72bad6 point postal code service check andrewxhill 2014-09-19 23:57:43 +02:00
  • f64359e1a5 clean empty postal code point rows andrewxhill 2014-09-19 23:53:49 +02:00
  • 2e0b8a4213 postal code over zip andrewxhill 2014-09-19 23:53:07 +02:00
  • ae8c85b4b3 working on avail services api andrewxhill 2014-09-19 23:51:56 +02:00
  • 14bd0b0c63 Adds Chris changes fixes #55 Carla 2014-09-11 14:12:09 +02:00
  • 49d0a8f452 Merge pull request #70 from CartoDB/iri/addsubunits origin/iri/wikitables Carla 2014-09-11 13:20:17 +02:00
  • c00eb60b13 Merge pull request #66 from CartoDB/iri/woesynonyms Andrew W. Hill 2014-09-09 06:36:33 -07:00
  • 82b29c1d19 Adds new query for subunit column and modifies ranks Carla 2014-09-09 11:53:13 +02:00
  • 8f71c4567f fixes #54. Adds woe_label sql functions and updates readme with new rank Carla 2014-09-07 12:38:30 +02:00
  • 7ce2d779b1 Merge pull request #61 from CartoDB/iri/adm1synsql Andrew W. Hill 2014-09-05 07:27:37 -04:00
  • 11127879c5 Updates sql to remove duplicates avoiding auto-deletion Carla 2014-09-05 11:30:59 +02:00
  • aa7a9415d1 Merge branch 'master' of github.com:CartoDB/data-services andrewxhill 2014-09-04 10:23:35 -04:00
  • 2eefa8cfd5 added CAN filter to postal code poly geocoder andrewxhill 2014-09-04 10:23:29 -04:00
  • 005fecee19 adm1 table name mistake andrewxhill 2014-09-01 11:29:08 -04:00
  • 342fc8b4c1 Merge branch 'master' of https://github.com/CartoDB/data-services Chris Henrick 2014-08-31 19:36:17 -04:00
  • 27b1678cfa update readme Chris Henrick 2014-08-31 19:36:10 -04:00
  • a2d3addcef Merge branch 'master' of github.com:CartoDB/data-services andrewxhill 2014-08-27 12:46:33 -04:00
  • 24d53e5f6f created test_ version of new admin1 geocoder function andrewxhill 2014-08-27 12:46:30 -04:00
  • 931ed596b3 Merge branch 'iri/geonames3' Carla 2014-08-26 11:24:55 +02:00
  • 8482759057 postal-codes Carla 2014-08-26 11:24:43 +02:00
  • a4d7962682 adds info for polygons and reorganizes document Carla 2014-08-26 11:19:53 +02:00
  • b57b9679dc Merge pull request #57 from CartoDB/iri/geonames2 Carla 2014-08-26 11:08:20 +02:00
  • 5e5fc1777c fixes markdown Carla 2014-08-26 11:09:14 +02:00
  • a6a28d7352 Merge pull request #56 from CartoDB/iri/geonames Carla 2014-08-26 11:02:03 +02:00
  • ec78d147bf solves #50 Carla 2014-08-26 11:00:13 +02:00
  • 42d5582b47 Merge pull request #53 from CartoDB/iri/ipadd Carla 2014-08-25 12:55:58 +02:00
  • 8cd501a4be modifies comment in sql for title Carla 2014-08-25 12:38:52 +02:00
  • c54af7c770 add data sources Carla 2014-08-25 12:33:47 +02:00
  • e0ee93bc3e removed single array method of the admin1 polygon geocoder andrewxhill 2014-08-22 13:21:14 -04:00
  • 4e56d7cf03 Merge branch 'master' of https://github.com/CartoDB/data-services Chris Henrick 2014-08-22 11:17:43 -04:00
  • 4971acf44d updated rank table Chris Henrick 2014-08-22 11:16:00 -04:00
  • 886c9cbee2 remove uk andrewxhill 2014-08-22 09:12:48 -04:00
  • f13ff761ec Merge branch 'master' of github.com:CartoDB/data-services andrewxhill 2014-08-22 09:12:18 -04:00
  • 1234f8e47e creating a top level document to recreate tables, indexes, and triggers andrewxhill 2014-08-22 09:04:15 -04:00
  • 8725220d6f creating a top level document to recreate tables, indexes, and triggers andrewxhill 2014-08-22 09:03:56 -04:00
  • f52db1203a Update README.md Andrew W. Hill 2014-08-22 08:06:47 -04:00
  • e396add905 postal code point placeholder andrewxhill 2014-08-22 08:06:19 -04:00
  • ff0c6fb4de added queries from ne admin1 to match qs Chris Henrick 2014-08-21 18:25:04 -04:00
  • a90bd90986 update readme Chris Henrick 2014-08-21 17:09:11 -04:00
  • 1828dddf40 updated readme Chris Henrick 2014-08-21 17:08:45 -04:00
  • 9f3e1bb130 update sql qs admin1 synonyms Chris Henrick 2014-08-21 16:11:50 -04:00
  • e22e1874b5 update sql qs admin1 synonyms Chris Henrick 2014-08-21 16:10:10 -04:00
  • 42529dd1e2 Merge branch 'master' of https://github.com/CartoDB/data-services Chris Henrick 2014-08-21 16:00:55 -04:00
  • 62ce313497 added sql for qs admin1 synonyms Chris Henrick 2014-08-21 16:00:48 -04:00
  • ce003f0c22 Merge branch 'master' of github.com:CartoDB/data-services andrewxhill 2014-08-21 15:43:49 -04:00
  • e3a4857733 update comments Chris Henrick 2014-08-21 15:42:41 -04:00
  • 4f6127ae88 Merge branch 'master' of https://github.com/CartoDB/data-services Chris Henrick 2014-08-21 15:36:57 -04:00
  • 6ae82c768f punch out ne coastline from qs admin1 Chris Henrick 2014-08-21 15:36:50 -04:00
  • a949e25dd6 deployed geocode_postalcode_polygons andrewxhill 2014-08-21 15:20:17 -04:00
  • 875c3fa57f Merge branch 'master' of github.com:CartoDB/data-services andrewxhill 2014-08-21 15:01:34 -04:00
  • c3155db82e updated postalcode polygon build to use real source tables andrewxhill 2014-08-21 15:01:29 -04:00
  • 7a6b07c5e3 fixed select statements Chris Henrick 2014-08-21 13:53:25 -04:00
  • c3d404750e add inserts from qs data Chris Henrick 2014-08-21 13:47:49 -04:00
  • 02bd608dc3 Merge branch 'master' of https://github.com/CartoDB/data-services Chris Henrick 2014-08-21 13:37:53 -04:00
  • 2dc98672b0 added SQL code to create unique id for qs data Chris Henrick 2014-08-21 13:37:40 -04:00
  • 9f2c3049ba dropped unused postalcode plpgsql functions andrewxhill 2014-08-21 13:36:42 -04:00
  • 430340c60e recast on the fly andrewxhill 2014-08-21 13:20:20 -04:00
  • 2ffe60e1bd wrote ip address update script andrewxhill 2014-08-21 13:19:43 -04:00
  • a0afb99acc ip address readme andrewxhill 2014-08-21 12:38:57 -04:00
  • c7375210cf test functions for postal code polys andrewxhill 2014-08-19 16:30:12 -04:00
  • 14d93604ba added postalcode polygons geocoder andrewxhill 2014-08-18 17:31:17 -04:00
  • 00ca9c2648 Merge pull request #42 from CartoDB/synonymstab Carla 2014-08-13 18:42:53 +02:00
  • d079757052 solves #24 Carla 2014-08-13 18:43:20 +02:00
  • 42a63c759a includes manual synonyms protocol fixes format Carla 2014-08-12 18:28:01 +02:00
  • f859f7b62a includes manual synonyms protocol Carla 2014-08-12 18:27:18 +02:00
  • 958e129d1b postal code scripts andrewxhill 2014-08-12 12:02:02 -04:00
  • 5a3fe17249 postal code placeholder andrewxhill 2014-08-12 07:44:08 -04:00
  • ff5556e30a postal code placeholder andrewxhill 2014-08-11 10:14:56 -04:00
  • 81edfc543b moved admin0 function off of test_ andrewxhill 2014-08-08 11:26:34 -04:00
  • d9b2c83013 updated rank table andrewxhill 2014-08-08 11:26:12 -04:00
  • 7ac669ec1f added pull from manual addtions table andrewxhill 2014-08-08 11:24:01 -04:00
  • 92fe6ed2b1 better regex for removing weird chars andrewxhill 2014-08-07 20:24:15 -04:00
  • 61758a5df1 better regex for removing weird chars andrewxhill 2014-08-07 17:30:22 -04:00
  • 3ff9b57703 merge andrewxhill 2014-08-06 13:19:57 -04:00
  • 58d5c54f34 mod of admin0 geocoder to consolidate search function andrewxhill 2014-08-06 13:19:09 -04:00
  • b548eb3e7b should clear data at the start of each run Andrew W. Hill 2014-08-06 10:59:49 -04:00
  • 3d1de6cd46 stop referrencing wiki for triggers/indexes andrewxhill 2014-08-05 12:56:52 -04:00
  • e7086d0507 moved indexes and triggers to repo andrewxhill 2014-08-05 12:55:56 -04:00
  • a45d8776f1 added old variations andrewxhill 2014-08-05 12:51:18 -04:00
  • fd774a9cb6 adding old admin1 geocoder sql to start edit andrewxhill 2014-08-05 12:48:27 -04:00
  • de43832c3b Update geocoder.sql Andrew W. Hill 2014-08-05 12:29:05 -04:00
  • 6a640b3365 update regex to match trigger andrewxhill 2014-08-04 19:25:34 -04:00
  • 12555333e9 added endoynms andrewxhill 2014-08-04 18:31:22 -04:00
  • 3e813b9868 structuring for a make file andrewxhill 2014-08-04 18:29:28 -04:00
  • 0156731a20 first commit andrewxhill 2014-07-31 14:26:20 -04:00