superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AGENCY = 221 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Link | rowid ▲ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3837 | 3837 | 3836 | {"type": "Polygon", "coordinates": [[[-118.09204, 33.87619], [-118.09159, 33.8762], [-118.09157, 33.87591], [-118.09149, 33.87562], [-118.09116, 33.87468], [-118.09115, 33.87461], [-118.09117, 33.87459], [-118.09117, 33.87417], [-118.09142, 33.87482], [-118.09146, 33.87483], [-118.09179, 33.87547], [-118.09204, 33.87619]]]} | Open Access 1 | Ecology Park | 18422 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1.382 | Ecology Park | ||
3808 | 3808 | 3807 | {"type": "Polygon", "coordinates": [[[-118.09066, 33.8501], [-118.08213, 33.85012], [-118.08212, 33.84964], [-118.09066, 33.84962], [-118.09066, 33.8501]]]} | Open Access 1 | Gridley Park | 19513 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 10.398 | Gridley Park | ||
2802 | 2802 | 2801 | {"type": "Polygon", "coordinates": [[[-118.05197, 33.87864], [-118.0517, 33.87858], [-118.05103, 33.87857], [-118.05089, 33.87868], [-118.05091, 33.88043], [-118.04871, 33.88045], [-118.04867, 33.87687], [-118.05195, 33.87685], [-118.05196, 33.87799], [-118.05185, 33.878], [-118.05185, 33.87816], [-118.05197, 33.87818], [-118.05197, 33.87864]]]} | Open Access 1 | Cerritos Park East | 17088 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 24.737 | Cerritos Park East | ||
2279 | 2279 | 2278 | {"type": "Polygon", "coordinates": [[[-118.05293, 33.86585], [-118.05292, 33.86593], [-118.052, 33.86618], [-118.05162, 33.86627], [-118.05118, 33.86635], [-118.0507, 33.8664], [-118.05044, 33.86625], [-118.05003, 33.86596], [-118.05033, 33.86601], [-118.05204, 33.86599], [-118.05226, 33.86597], [-118.05245, 33.86589], [-118.05277, 33.86572], [-118.05284, 33.86574], [-118.05291, 33.86578], [-118.05293, 33.86585]]]} | Open Access 1 | Brookhaven Park | 16422 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1.761 | Brookhaven Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);