units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where DES_TP = 2 and LAYER = 14 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, PARK_URL, COUNTY, YR_EST
MNG_AGENCY 19
- Valley-Wide Recreation and Park District 7
- Bellflower, City of 5
- Irvine, City of 3
- San Clemente, City of 3
- San Jacinto, City of 2
- Chino, City of 2
- West Hollywood, City of 2
- El Centro, City of 1
- Carlsbad, City of 1
- Rosemead, City of 1
- Monterey Park, City of 1
- Paramount, City of 1
- Long Beach, City of 1
- Santa Clarita, City of 1
- La Mirada, City of 1
- Avalon, City of 1
- King City, City of 1
- South Gate, City of 1
- Menifee, City of 1
MNG_AG_TYP 2
DES_TP 1
- Local Park · 36 ✖
ACCESS_TYP 1
- Open Access 36
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3525 | 3525 | 3524 | {"type": "Polygon", "coordinates": [[[-118.1436, 33.87107], [-118.14301, 33.87107], [-118.14301, 33.87037], [-118.14299, 33.87036], [-118.14299, 33.86965], [-118.1436, 33.86965], [-118.1436, 33.87107]]]} | Open Access 1 | 20595 | Constitution Park | 17598 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 2.156 | Constitution Park | 0 | Local Park 2 | 4 | |
3943 | 3943 | 3942 | {"type": "Polygon", "coordinates": [[[-118.10976, 33.89657], [-118.10921, 33.89657], [-118.10912, 33.88798], [-118.10968, 33.88802], [-118.10976, 33.89657]]]} | Open Access 1 | 46282 | Riverview Park | 24462 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 12.094 | Riverview Park | 0 | Local Park 2 | 4 | |
4172 | 4172 | 4171 | {"type": "Polygon", "coordinates": [[[-118.16946, 33.93806], [-118.16891, 33.93872], [-118.16808, 33.93971], [-118.16762, 33.9386], [-118.1679, 33.93827], [-118.1681, 33.93828], [-118.16864, 33.93763], [-118.16946, 33.93806]]]} | Open Access 1 | 46508 | Circle Park | 29791 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1339 | South Gate, City of 645 | City 2 | City Agency 2 | Los Angeles 6 | 4.401 | Circle Park | 0 | Local Park 2 | 4 | |
5283 | 5283 | 5282 | {"type": "Polygon", "coordinates": [[[-117.12889, 33.61282], [-117.12851, 33.61291], [-117.12886, 33.61428], [-117.12859, 33.61432], [-117.12851, 33.61411], [-117.12842, 33.61354], [-117.1283, 33.61315], [-117.1283, 33.61293], [-117.12828, 33.61271], [-117.12798, 33.6127], [-117.128, 33.61263], [-117.12799, 33.61259], [-117.12794, 33.61253], [-117.12789, 33.61251], [-117.1278, 33.61251], [-117.12774, 33.61254], [-117.12769, 33.61249], [-117.12733, 33.61255], [-117.12733, 33.61251], [-117.12788, 33.61241], [-117.12845, 33.61224], [-117.12854, 33.61226], [-117.12889, 33.61282]]]} | Open Access 1 | 48401 | Linear Workout Park | 32968 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 2.073 | Linear Workout Park | 0 | Local Park 2 | 4 | |
8372 | 8372 | 8371 | {"type": "Polygon", "coordinates": [[[-121.13806, 36.21648], [-121.13809, 36.21658], [-121.13804, 36.21705], [-121.138, 36.21722], [-121.13792, 36.21739], [-121.13781, 36.21754], [-121.13767, 36.21767], [-121.13751, 36.21779], [-121.13718, 36.21797], [-121.13712, 36.21799], [-121.13705, 36.21799], [-121.13694, 36.21794], [-121.13639, 36.21725], [-121.13787, 36.21647], [-121.13806, 36.21648]]]} | Open Access 1 | 48506 | CreekBridge Baseball Park | 33217 | 7033 | Creekbridge Homes LLC 892 | Private 7 | Home Owners Association 16 | Private 14 | 1152 | King City, City of 473 | City 2 | City Agency 2 | Monterey 14 | 3.565 | CreekBridge Baseball Park | 0 | Local Park 2 | 4 | ||
10515 | 10515 | 10514 | {"type": "Polygon", "coordinates": [[[-117.63201, 33.95915], [-117.632, 33.95932], [-117.632, 33.95991], [-117.63149, 33.96007], [-117.6312, 33.95941], [-117.63201, 33.95915]]]} | Open Access 1 | 48706 | West Meridian Park | 33436 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | San Bernardino 22 | 1.242 | West Meridian Park | 0 | Local Park 2 | 4 | |
10628 | 10628 | 10627 | {"type": "Polygon", "coordinates": [[[-117.62852, 33.961], [-117.62791, 33.96119], [-117.6279, 33.96039], [-117.62795, 33.96033], [-117.62821, 33.96032], [-117.62852, 33.961]]]} | Open Access 1 | 48707 | North Meridian Park | 33434 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | San Bernardino 22 | 0.926 | North Meridian Park | 0 | Local Park 2 | 4 | |
10847 | 10847 | 10846 | {"type": "Polygon", "coordinates": [[[-118.12837, 34.0455], [-118.12829, 34.04553], [-118.12817, 34.04553], [-118.12743, 34.04535], [-118.1272, 34.04532], [-118.11801, 34.04309], [-118.11799, 34.04277], [-118.11801, 34.04266], [-118.12629, 34.04467], [-118.12828, 34.0447], [-118.12838, 34.04547], [-118.12837, 34.0455]]]} | Open Access 1 | 20633 | Edison Trails Park | 18447 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 12.372 | Edison Trails Park | 0 | Local Park 2 | 4 | |
10887 | 10887 | 10886 | {"type": "Polygon", "coordinates": [[[-117.7503, 33.71658], [-117.74985, 33.71697], [-117.74946, 33.71734], [-117.74941, 33.71732], [-117.74938, 33.71735], [-117.74772, 33.71619], [-117.74855, 33.71536], [-117.7503, 33.71658]]]} | Open Access 1 | 48663 | Eastwood Neighborhood Park | 33410 | 6129 | Irvine Community Development Company LLC 961 | Private 7 | Commercial 20 | https://www.irvinecompany.com/ | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 6.129 | Eastwood Neighborhood Park | 0 | Local Park 2 | 4 | |
11154 | 11154 | 11153 | {"type": "Polygon", "coordinates": [[[-117.79698, 33.70006], [-117.79706, 33.70012], [-117.79707, 33.70016], [-117.79689, 33.70036], [-117.79686, 33.70044], [-117.79687, 33.70049], [-117.79677, 33.70052], [-117.7967, 33.70048], [-117.79666, 33.70047], [-117.79649, 33.70063], [-117.79644, 33.7006], [-117.79664, 33.7004], [-117.79662, 33.70038], [-117.79668, 33.70036], [-117.79698, 33.70006]]]} | Open Access 1 | 48692 | Flagstone Park | 18936 | 6033 | Windwood Homeowners Association 926 | Private 7 | Home Owners Association 16 | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 0.248 | Flagstone Park | 0 | Local Park 2 | 4 | ||
11155 | 11155 | 11154 | {"type": "Polygon", "coordinates": [[[-117.71514, 33.7026], [-117.71503, 33.70272], [-117.71348, 33.70165], [-117.71319, 33.70188], [-117.71283, 33.70221], [-117.71279, 33.70214], [-117.71274, 33.70194], [-117.71273, 33.70165], [-117.71268, 33.70136], [-117.71281, 33.70133], [-117.71297, 33.70113], [-117.71496, 33.70241], [-117.715, 33.70239], [-117.71508, 33.70244], [-117.71514, 33.7026]]]} | Open Access 1 | 48695 | Orchard Trail Park | 33407 | 6128 | Portola Springs Community Association 967 | Private 7 | Home Owners Association 16 | https://portolasprings.org/ | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.227 | Orchard Trail Park | 0 | Local Park 2 | 4 | |
11408 | 11408 | 11407 | {"type": "Polygon", "coordinates": [[[-115.54531, 32.76157], [-115.5453, 32.76193], [-115.54472, 32.76194], [-115.54451, 32.76195], [-115.54426, 32.76202], [-115.54411, 32.76204], [-115.54368, 32.76207], [-115.54357, 32.76207], [-115.54356, 32.76168], [-115.54359, 32.76168], [-115.5436, 32.76165], [-115.54404, 32.76165], [-115.54459, 32.76156], [-115.54531, 32.76157]]]} | Open Access 1 | 48092 | Countryside Park | 32595 | 6122 | Pulte Home Corporation 976 | Private 7 | Commercial 20 | https://www.pulte.com/ | Private 14 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 1.727 | Countryside Park | 2007 | Local Park 2 | 4 | |
14346 | 14346 | 14345 | {"type": "Polygon", "coordinates": [[[-118.08266, 34.08809], [-118.08266, 34.08809], [-118.08238, 34.08853], [-118.08229, 34.08817], [-118.08227, 34.08805], [-118.08228, 34.08802], [-118.08232, 34.08799], [-118.08238, 34.08799], [-118.08266, 34.08809]]]} | Open Access 1 | 45594 | Guess Park | 29851 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 0.28 | Guess Park | 0 | Local Park 2 | 4 | |
15168 | 15168 | 15167 | {"type": "Polygon", "coordinates": [[[-118.32353, 33.34225], [-118.32381, 33.34224], [-118.32377, 33.34263], [-118.32321, 33.34256], [-118.32326, 33.34241], [-118.32332, 33.34234], [-118.32339, 33.34229], [-118.32353, 33.34225]]]} | Open Access 1 | 46018 | Avalon City Park | 29343 | 6013 | Northwood II Community Association 1139 | Private 7 | Home Owners Association 16 | Private 14 | 1016 | Avalon, City of 327 | City 2 | City Agency 2 | Los Angeles 6 | 0.445 | Avalon City Park | 0 | Local Park 2 | 4 | ||
15255 | 15255 | 15254 | {"type": "Polygon", "coordinates": [[[-118.12195, 33.89644], [-118.12189, 33.89649], [-118.12166, 33.89649], [-118.12171, 33.89622], [-118.12195, 33.89622], [-118.12195, 33.89644]]]} | Open Access 1 | 46308 | Chevron Pocket Park | 29600 | 6104 | Chevron Pipe Line Company 1145 | Private 7 | Commercial 20 | http://www.chevronpipeline.com/about/ | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 0.179 | Chevron PP | 0 | Local Park 2 | 4 | |
15317 | 15317 | 15316 | {"type": "Polygon", "coordinates": [[[-118.01167, 33.9126], [-118.01104, 33.91346], [-118.01104, 33.91426], [-118.01127, 33.91427], [-118.01118, 33.91432], [-118.01101, 33.91431], [-118.01083, 33.91482], [-118.00994, 33.91503], [-118.01023, 33.91471], [-118.01004, 33.91464], [-118.01004, 33.91461], [-118.01024, 33.91467], [-118.01043, 33.9143], [-118.0105, 33.91395], [-118.01056, 33.9133], [-118.01061, 33.91317], [-118.01081, 33.91298], [-118.01102, 33.91265], [-118.01073, 33.91253], [-118.01074, 33.9125], [-118.01102, 33.9126], [-118.01116, 33.91239], [-118.01149, 33.91179], [-118.01152, 33.91167], [-118.01166, 33.91167], [-118.01166, 33.912], [-118.01157, 33.9121], [-118.01157, 33.91245], [-118.01167, 33.91246], [-118.01167, 33.9126]]]} | Open Access 1 | 46499 | Oak Creek Park | 22960 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1158 | La Mirada, City of 323 | City 2 | City Agency 2 | Los Angeles 6 | 4.296 | Oak Creek Park | 0 | Local Park 2 | 4 | ||
15399 | 15399 | 15398 | {"type": "Polygon", "coordinates": [[[-118.18285, 33.87975], [-118.18285, 33.88002], [-118.18185, 33.88002], [-118.18185, 33.87975], [-118.18285, 33.87975]]]} | Open Access 1 | 46616 | North Community Gardens | 29930 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.68 | North Community Gardens | 0 | Local Park 2 | 4 | |
15329 | 15329 | 15328 | {"type": "Polygon", "coordinates": [[[-117.03611, 33.78835], [-117.03606, 33.78836], [-117.03603, 33.78814], [-117.03599, 33.78803], [-117.0359, 33.78786], [-117.03583, 33.78777], [-117.03574, 33.78768], [-117.03558, 33.78755], [-117.03537, 33.78743], [-117.03604, 33.78743], [-117.03599, 33.78773], [-117.03606, 33.7878], [-117.03603, 33.78785], [-117.03602, 33.78791], [-117.03605, 33.78798], [-117.03604, 33.788], [-117.03611, 33.78835]]]} | Open Access 1 | 48972 | Pocket Park at the Cove #2 | 33669 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.446 | PP at the Cove #2 | 0 | Local Park 2 | 4 |
15540 | 15540 | 15539 | {"type": "Polygon", "coordinates": [[[-117.03786, 33.79012], [-117.03745, 33.79026], [-117.03733, 33.79002], [-117.03774, 33.78988], [-117.03786, 33.79012]]]} | Open Access 1 | 48971 | Pocket Park at the Cove #1 | 33668 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.295 | PP at the Cove #1 | 0 | Local Park 2 | 4 |
1595 | 1595 | 1594 | {"type": "Polygon", "coordinates": [[[-117.33591, 33.13338], [-117.33487, 33.13375], [-117.33448, 33.13298], [-117.33535, 33.13267], [-117.3354, 33.13267], [-117.33591, 33.13338]]]} | Open Access 1 | 12167 | Cannon Park | 16804 | 6076 | San Diego Gas and Electric 389 | Private 7 | Utility 21 | http://www.sdge.com/ | Private 14 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/cannon.asp | San Diego 4 | 2.282 | Cannon Park | 0 | Local Park 2 | 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]);