CAMP Notes

[tibbben]

camp notes:

gdsc ingest

check folios QC

check water parcels

check road parcels

create municipalities and places (not in GDSC automation yet)

CREATE SERVER postgis_dn7tn2p5cfahc611 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'postgis-dn7tn2p5cfahc611', dbname 'gdsc', port '5432');
CREATE USER MAPPING FOR postgres SERVER postgis_dn7tn2p5cfahc611 OPTIONS (user 'postgres', password 'WaterGDSCFlow');
IMPORT FOREIGN SCHEMA public LIMIT TO (mdc_municipal_boundary) FROM SERVER postgis_dn7tn2p5cfahc611 INTO public;

CREATE SERVER postgis_d1gxh00d8j6m2xd0 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'postgis-d1gxh00d8j6m2xd0', dbname 'gdsc', port '5432');
CREATE USER MAPPING FOR postgres SERVER postgis_d1gxh00d8j6m2xd0 OPTIONS (user 'postgres', password 'WaterGDSCFlow');
IMPORT FOREIGN SCHEMA public LIMIT TO (mdc_neighborhoods) FROM SERVER postgis_d1gxh00d8j6m2xd0 INTO public;

CREATE SERVER postgis_90zi29yo2f6dr8g0 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'postgis-90zi29yo2f6dr8g0', dbname 'gdsc', port '5432');
CREATE USER MAPPING FOR postgres SERVER postgis_90zi29yo2f6dr8g0 OPTIONS (user 'postgres', password 'WaterGDSCFlow');
IMPORT FOREIGN SCHEMA public LIMIT TO (com_neighborhoods) FROM SERVER postgis_90zi29yo2f6dr8g0 INTO public;

ALTER TABLE mdc_parcels_camp ADD COLUMN mdc_place varchar;
ALTER TABLE mdc_parcels_camp ADD COLUMN mdc_municipality varchar;
ALTER TABLE mdc_parcels_camp ADD COLUMN com_neighborhood varchar;

UPDATE mdc_parcels_camp
SET place = 'Unincorporated Miami-Dade County';

-- all title case: initcap()

UPDATE mdc_parcels_camp
SET mdc_place = initcap(mdc_neighborhoods.name)
FROM mdc_neighborhoods
WHERE ST_Within(mdc_parcels_camp.geom_centroid,mdc_neighborhoods.geom);

UPDATE mdc_parcels_camp
SET mdc_place = initcap(mdc_municipal_boundary.name), mdc_municipality = initcap(mdc_municipal_boundary.name)
FROM mdc_municipal_boundary
WHERE ST_Within(mdc_parcels_camp.geom_centroid,mdc_municipal_boundary.geom) AND mdc_municipal_boundary.name != 'UNINCORPORATED MIAMI-DADE';

UPDATE mdc_parcels_camp
SET mdc_place = initcap(com_neighborhoods.label), com_neighborhood = initcap(com_neighborhoods.label)
FROM com_neighborhoods
WHERE ST_Within(mdc_parcels_camp.geom_centroid,com_neighborhoods.geom);

create county_parks and municipal_parks (not in automation yet)

same as above but not notes yet ... within and create column with park names (one for each, county and municipality)

add land use

ogr2ogr -f PostgreSQL PG:"dbname=$POSTGRES_DB port=$POSTGRES_PORT user=$POSTGRES_USER password=$POSTGRES_PASSWORD host='postgis-4d8urdupgjvec6d0'" distinct_dor_code_list_filtered.csv -nln dor_code_list

ALTER TABLE mdc_parcels_camp ADD COLUMN land_use varchar;
UPDATE mdc_parcels_camp
SET land_use = dor_code_list.cce_land_use
FROM dor_code_list
WHERE mdc_parcels_camp.dor_code_cur = dor_code_list.dor_code_cur;

add ownership

create vecctor tiles

ogr2ogr -f "GeoJSON" /data/mdc_parcels_camp/dump/mdc_parcels_camp.json PG:"dbname=$POSTGRES_DB port=$POSTGRES_PORT user=$POSTGRES_USER password=$POSTGRES_PASSWORD host='postgis-4d8urdupgjvec6d0'" -sql "SELECT folio, true_site_addr as address, true_site_unit as unit, true_site_city as city, true_site_zip_code as zip_code, true_owner1 as owner, dor_code_cur as dor_code, dor_desc, land_use, building_actual_area as building_area, lot_size, year_built, mdc_county_zone || ' - ' || mdc_county_zone_desc as county_zone, mdc_municipal_zone || ' - ' || mdc_municipal_zone_desc as municipal_zone, mdc_municipal_park_name, mdc_county_park_name, flma_name || ' - ' || flma_type as florida_managed_area, fema_flood_zone as floodzone, mdc_qualified_opportunity_zones as qualified_opportunity_zone, elevation, place, municipality, neighborhood, geom from mdc_parcels_camp"

tippecanoe -Z 14 -z 20 -o mdc_parcels_camp.mbtiles mdc_parcels_camp.json

start tileserver-ng in pod

node@tileserver-gl:/data $ nohup node /usr/src/app/src/main.js tilserver-gl -c /tiles/vector/config.json -p 7810 &

[tibbben]

• Cooling center source? MDC Emergency Management Policy and Procedures

[tibbben]

• try ownership script on CAMP parcels (wait for 2024 update)
• work with Harsha to make layer map to GDSC
• rename com_neighborhoods
• check elevation
• rename maname, matype?
• cooling centers :
  • url: https://mdc.maps.arcgis.com/home/item.html?id=9a42d1aae6e74cdcb2cbc9d82d58d6bd&sublayer=0
  • source: https://services.arcgis.com/8Pc9XBTAsYuxx9Ny/arcgis/rest/services/Cooling_Centers/FeatureServer/0/query?where=1%3D1&outFields=*&returnGeometry=true&outSR=4326&f=geojson