This supports USA for Photon and Tigerline

This added Tigerline and USA States to Photon
Yeah option is good

Bill Bell
Sent from mobile


On Jun 16, 2014, at 6:32 AM, "Christoph Lingg" <notifications@github.com<mailto:notifications@github.com>> wrote:


In src/main/java/de/komoot/photon/importer/nominatim/NominatimConnector.java:

> @@ -96,6 +99,21 @@ public PhotonDoc getByPlaceId(long placeId) {
>               return template.queryForObject("SELECT " + selectColsPlaceX + " FROM placex WHERE place_id = ?", new Object[]{placeId}, placeRowMapper);
>       }
>
> +     public List<TigerRow> getTigerAddresses(long placeId) {
> +//           placeId = 31210740;
> +             return template.query("SELECT place_id, housenumber, postcode, centroid FROM location_property_tiger WHERE parent_place_id = ?", new Object[]{placeId}, new RowMapper<TigerRow>() {


in case a photon user only want's to import osm data (without tiger) will there be an error, maybe the location_property_tiger table won't be available.

—
Reply to this email directly or view it on GitHub<https://github.com/komoot/photon/pull/62/files#r13802546>.