superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AGENCY = 221
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12761 | 12761 | 12760 | {"type": "Polygon", "coordinates": [[[-118.04189, 33.86024], [-118.04187, 33.8616], [-118.04175, 33.8616], [-118.0409, 33.86124], [-118.04104, 33.86112], [-118.04104, 33.86109], [-118.04097, 33.86103], [-118.04189, 33.86024]]]} | Open Access 1 | Bettencourt Park | 29947 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1.883 | Bettencourt Park | ||
12784 | 12784 | 12783 | {"type": "Polygon", "coordinates": [[[-118.05493, 33.84996], [-118.05442, 33.85033], [-118.05038, 33.85035], [-118.05037, 33.84987], [-118.05458, 33.84984], [-118.0546, 33.84915], [-118.05485, 33.84915], [-118.05493, 33.84996]]]} | Open Access 1 | El Rancho Verde Park, West | http://www.cerritos.us/RESIDENTS/recreation/facilities/neighborhood_parks/el_rancho_verde_park.php | 29978 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 5.831 | El Rancho Verde Park, West | |
14263 | 14263 | 14262 | {"type": "Polygon", "coordinates": [[[-118.09645, 33.8693], [-118.09644, 33.87086], [-118.09533, 33.87086], [-118.09531, 33.8686], [-118.09645, 33.8693]]]} | Open Access 1 | Rosewood Park | 24670 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 5.439 | Rosewood Park | ||
14324 | 14324 | 14323 | {"type": "Polygon", "coordinates": [[[-118.09143, 33.87602], [-118.09139, 33.87609], [-118.09128, 33.87602], [-118.09124, 33.87543], [-118.09143, 33.87602]]]} | Open Access 1 | Unnamed site - Artesia, City of | 29525 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 0.128 |
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]);