units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where AGNCY_LEV = 2, GAP_STS = 4 and MNG_AGENCY = 306
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1052 | 1052 | 1051 | {"type": "Polygon", "coordinates": [[[-118.14761, 34.11561], [-118.14713, 34.11686], [-118.14711, 34.11686], [-118.14708, 34.11692], [-118.14706, 34.11702], [-118.14668, 34.11802], [-118.14657, 34.11825], [-118.14637, 34.11854], [-118.14609, 34.11883], [-118.14581, 34.11883], [-118.14576, 34.1182], [-118.14641, 34.11565], [-118.14761, 34.11561]]]} | Open Access 1 | 5653 | Garfield Park | 19217 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 7.505 | Garfield Park | 0 | Local Park 2 | 4 | |
2262 | 2262 | 2261 | {"type": "Polygon", "coordinates": [[[-118.16806, 34.11775], [-118.16699, 34.11798], [-118.16694, 34.11722], [-118.16702, 34.11722], [-118.16721, 34.11715], [-118.16752, 34.1172], [-118.16778, 34.11722], [-118.168, 34.11744], [-118.16806, 34.11775]]]} | Open Access 1 | 48005 | South Pawsadena Dog Park | 32429 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 1.715 | South Pawsadena Dog Park | 0 | Local Park 2 | 4 | |
3109 | 3109 | 3108 | {"type": "Polygon", "coordinates": [[[-118.15489, 34.11834], [-118.15488, 34.11879], [-118.15472, 34.11879], [-118.15472, 34.11834], [-118.15489, 34.11834]]]} | Open Access 1 | 47989 | Grevelia Street Pocket Park | 32409 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | https://southpasadenacalendar.com/locations/grevelia-pocket-park/ | Los Angeles 6 | 0.187 | Grevelia Street PP | 0 | Local Park 2 | 4 |
3138 | 3138 | 3137 | {"type": "MultiPolygon", "coordinates": [[[[-118.16009, 34.11155], [-118.16009, 34.11174], [-118.16006, 34.11178], [-118.15964, 34.11176], [-118.15964, 34.11155], [-118.16009, 34.11155]]], [[[-118.16075, 34.11182], [-118.16038, 34.11179], [-118.16036, 34.11176], [-118.16036, 34.11155], [-118.16075, 34.11155], [-118.16075, 34.11182]]]]} | Open Access 1 | 48039 | Via Del Rey Park | 32532 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 0.503 | Via Del Rey Park | 0 | Local Park 2 | 4 | |
4279 | 4279 | 4278 | {"type": "Polygon", "coordinates": [[[-118.1696, 34.09866], [-118.1696, 34.09908], [-118.16933, 34.09908], [-118.16934, 34.09866], [-118.1694, 34.09866], [-118.16941, 34.09877], [-118.16952, 34.09878], [-118.16953, 34.09866], [-118.1696, 34.09866]]]} | Open Access 1 | 48043 | Via Del Rey/Camino Verde Park | 32536 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 0.245 | Via Del Rey/Camino Verde Park | 0 | Local Park 2 | 4 | |
7233 | 7233 | 7232 | {"type": "Polygon", "coordinates": [[[-118.17442, 34.11313], [-118.17382, 34.11314], [-118.17249, 34.1138], [-118.1717, 34.11481], [-118.17141, 34.1152], [-118.17123, 34.11541], [-118.17064, 34.11525], [-118.17023, 34.11568], [-118.1699, 34.11588], [-118.16957, 34.11604], [-118.1687, 34.11633], [-118.1684, 34.11659], [-118.16778, 34.11722], [-118.16752, 34.1172], [-118.16721, 34.11715], [-118.16702, 34.11722], [-118.16668, 34.1172], [-118.16617, 34.11698], [-118.16631, 34.1167], [-118.16644, 34.11652], [-118.16714, 34.1158], [-118.16736, 34.11565], [-118.16786, 34.11535], [-118.16903, 34.11436], [-118.17094, 34.11312], [-118.17138, 34.11306], [-118.1719, 34.11287], [-118.17256, 34.11271], [-118.17296, 34.1125], [-118.17362, 34.11232], [-118.17402, 34.11239], [-118.17442, 34.11313]]]} | Restricted Access 2 | 6930 | Arroyo Seco Golf Course | 29411 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.arroyosecogolf.com/Home.html | Los Angeles 6 | 31.16 | Arroyo Seco GC | 0 | Local Recreation Area 3 | 4 |
7420 | 7420 | 7419 | {"type": "Polygon", "coordinates": [[[-118.16885, 34.11828], [-118.16884, 34.11835], [-118.16739, 34.11941], [-118.16831, 34.12017], [-118.16794, 34.12033], [-118.16747, 34.1211], [-118.16765, 34.12174], [-118.1663, 34.12276], [-118.16623, 34.12284], [-118.16615, 34.12297], [-118.16579, 34.12393], [-118.16556, 34.12393], [-118.16562, 34.12372], [-118.16566, 34.12344], [-118.16565, 34.12271], [-118.1656, 34.12238], [-118.16543, 34.12178], [-118.16537, 34.1215], [-118.16531, 34.12099], [-118.16529, 34.12042], [-118.16531, 34.12017], [-118.16539, 34.11982], [-118.16542, 34.11961], [-118.16544, 34.11892], [-118.16547, 34.11873], [-118.16552, 34.11854], [-118.16795, 34.11801], [-118.16778, 34.11815], [-118.16777, 34.11834], [-118.16779, 34.1184], [-118.16785, 34.1185], [-118.16794, 34.11858], [-118.16802, 34.11863], [-118.16812, 34.11865], [-118.16826, 34.11866], [-118.16842, 34.11862], [-118.16857, 34.11853], [-118.16885, 34.11828]]]} | Open Access 1 | 6928 | Arroyo Seco Park | 29429 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 25.8 | Arroyo Seco Park | 0 | Local Park 2 | 4 | |
10624 | 10624 | 10623 | {"type": "Polygon", "coordinates": [[[-118.14213, 34.10941], [-118.14133, 34.10941], [-118.14133, 34.10896], [-118.14212, 34.10895], [-118.14213, 34.10941]]]} | Open Access 1 | 18930 | Eddie Park | 18425 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 0.911 | Eddie Park | 0 | Local Park 2 | 4 | |
10853 | 10853 | 10852 | {"type": "Polygon", "coordinates": [[[-118.15156, 34.11989], [-118.15129, 34.12018], [-118.15109, 34.1205], [-118.15058, 34.12166], [-118.15055, 34.12166], [-118.15045, 34.12197], [-118.15046, 34.1202], [-118.15076, 34.12021], [-118.15105, 34.12016], [-118.15133, 34.12005], [-118.15156, 34.11989]]]} | Open Access 1 | 20641 | War Memorial Park | 27251 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 1.788 | War Memorial Park | 0 | Local Park 2 | 4 | |
10854 | 10854 | 10853 | {"type": "Polygon", "coordinates": [[[-118.16101, 34.11558], [-118.1597, 34.11564], [-118.15973, 34.11481], [-118.16092, 34.11478], [-118.16101, 34.11558]]]} | Open Access 1 | 20642 | Orange Grove Park | 23154 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 2.585 | Orange Grove Park | 0 | Local Park 2 | 4 | |
10855 | 10855 | 10854 | {"type": "Polygon", "coordinates": [[[-118.15621, 34.11379], [-118.15621, 34.11465], [-118.15535, 34.11465], [-118.15536, 34.1138], [-118.15621, 34.11379]]]} | Open Access 1 | 20643 | Library Park | 21221 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 1.848 | Library Park | 0 | Local Park 2 | 4 | |
11161 | 11161 | 11160 | {"type": "Polygon", "coordinates": [[[-118.15905, 34.09977], [-118.15905, 34.09991], [-118.15855, 34.09991], [-118.15856, 34.09977], [-118.15905, 34.09977]]]} | Open Access 1 | 47990 | Berkshire Avenue Pocket Park | 32411 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 0.171 | Berkshire Avenue PP | 0 | Local Park 2 | 4 | |
11234 | 11234 | 11233 | {"type": "Polygon", "coordinates": [[[-118.15695, 34.11034], [-118.157, 34.11035], [-118.15703, 34.11042], [-118.15701, 34.11047], [-118.15695, 34.1105], [-118.1569, 34.11048], [-118.15687, 34.11042], [-118.15688, 34.11037], [-118.15695, 34.11034]]]} | Open Access 1 | 48040 | El Cerrito Circle Park | 32533 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 0.048 | El Cerrito Circle Park | 0 | Local Park 2 | 4 | |
11279 | 11279 | 11278 | {"type": "Polygon", "coordinates": [[[-118.15783, 34.11516], [-118.15741, 34.1155], [-118.15725, 34.11565], [-118.15722, 34.11553], [-118.15722, 34.11543], [-118.15741, 34.11524], [-118.15742, 34.11513], [-118.15783, 34.11513], [-118.15783, 34.11516]]]} | Open Access 1 | 48041 | Ironwork Historical Museum and Park | 32534 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | https://www.southpasadenaca.gov/government/departments/community-services/administration/south-pasadena-historical-museum | Los Angeles 6 | 0.327 | Ironwork Historical Museum and Park | 0 | Local Historic or Cultural Area 19 | 4 |
11280 | 11280 | 11279 | {"type": "Polygon", "coordinates": [[[-118.13862, 34.10639], [-118.13859, 34.10671], [-118.13859, 34.10691], [-118.13857, 34.10697], [-118.13852, 34.10701], [-118.1384, 34.10701], [-118.13835, 34.10697], [-118.13832, 34.10689], [-118.1383, 34.10668], [-118.13825, 34.10638], [-118.13829, 34.10636], [-118.13838, 34.10635], [-118.13858, 34.10636], [-118.13862, 34.10639]]]} | Open Access 1 | 48042 | Camden Park | 32535 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 0.489 | Camden Park | 0 | Local Park 2 | 4 | |
11520 | 11520 | 11519 | {"type": "Polygon", "coordinates": [[[-118.173, 34.10024], [-118.17269, 34.10089], [-118.17254, 34.1016], [-118.17274, 34.10362], [-118.17137, 34.10351], [-118.17031, 34.10289], [-118.17048, 34.10232], [-118.17087, 34.10211], [-118.17092, 34.10168], [-118.17054, 34.10116], [-118.1704, 34.10045], [-118.17043, 34.09986], [-118.1714, 34.09987], [-118.17222, 34.1], [-118.173, 34.10024]]]} | Open Access 1 | 48231 | Lot 117 in the Altos de Monterey tract | 32788 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 18.878 | Lot 117 in the Altos de Monterey tract | 0 | Local Other or Unknown 14 | 4 | |
15196 | 15196 | 15195 | {"type": "Polygon", "coordinates": [[[-118.17123, 34.11541], [-118.16918, 34.11752], [-118.16899, 34.11733], [-118.16859, 34.11755], [-118.16857, 34.11757], [-118.16862, 34.11762], [-118.16806, 34.11775], [-118.168, 34.11744], [-118.16778, 34.11722], [-118.1684, 34.11659], [-118.1687, 34.11633], [-118.16957, 34.11604], [-118.1699, 34.11588], [-118.17023, 34.11568], [-118.17064, 34.11524], [-118.17123, 34.11541]]]} | Restricted Access 2 | 46069 | Arroyo Seco Racquet Center | 29412 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/index.aspx?page=66 | Los Angeles 6 | 7.411 | Arroyo Seco Racquet Ctr. | 0 | Local Recreation Area 3 | 4 |
15197 | 15197 | 15196 | {"type": "Polygon", "coordinates": [[[-118.16668, 34.11804], [-118.16562, 34.11827], [-118.16617, 34.11698], [-118.16651, 34.11713], [-118.1665, 34.11751], [-118.16664, 34.11751], [-118.16668, 34.11804]]]} | Open Access 1 | 46071 | Skate Park | 29414 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/index.aspx?page=102 | Los Angeles 6 | 1.934 | Skate Park | 0 | Local Recreation Area 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);