reload pavementedge_carto

[mattyschell]

See CityOfNewYork/nyc-planimetrics#56

We loaded pavementedge_carto.pos_yitz assuming that the column was "internal use only." Instead it should be named "visibility" and "show/hide" values replace "above/below." Visibility should be published.

[mattyschell]

update pavementedge_carto
set
visibility = 'Show'
where
visibility = 'above';
update pavementedge_carto
set
visibility = 'Hide'
where
visibility = 'below';
commit;

select
count(*)
from
pavementedge_carto
where
visibility not in ('Show','Hide');

0