Missing INUP boundary

[nateirwin]

http://www.nps.gov/inup/index.htm

[chadlawlis]

Just like ALEU we do not have a boundary for this in CartoDB, and it is not available in Lands either.

We will have to reach out to someone in AKR for the geometry.

[chadlawlis]

I emailed Angie and Regan about this today.

[chadlawlis]

There is currently no record for this unit in PostGIS parks, which I will add today. I will populate the geom_poly once we have a geometry to use.

[chadlawlis]

insert into parks (unit_id, unit_name_short, unit_name_long, unit_code, unit_region, unit_state, unit_url) values ((select max(unit_id) + 1 from parks), 'Iñupiat Heritage Center', 'Iñupiat Heritage Center', 'inup', 'akr', 'ak', 'http://www.nps.gov/inup/index.htm');
insert into parks_poly (unit_id, unit_code) values ((select unit_id from parks where unit_code = 'inup'), 'inup');
insert into parks_line (unit_id, unit_code) values ((select unit_id from parks where unit_code = 'inup'), 'inup');

[chadlawlis]

Emailed Angie and Regan about this on 1/13/16 and again today.

[chadlawlis]

Pinged Alex, Web Coordinator @ DENA about this today.

[chadlawlis]

From Alex:

I have a street address for INUP ... 5421 N Star St, Barrow, AK 99723

We can geocode this address to create a point for the unit for now. With changes to the boundary/label table schemas should come the ability to zoom to a point from the Park Tiles search bar, so that will help.

[chadlawlis]

geom_point generated from address above via:

-- set point coordinate in 4326
UPDATE parks
SET geom_point = (SELECT ST_GeomFromText('POINT(-156.7529135942459 71.29889154912895)', 4326))
WHERE unit_code = 'inup';

-- convert to 3857
UPDATE parks
SET geom_point = ST_Transform(ST_SetSRID(geom_point, 4326), 3857)
WHERE unit_code = 'inup';