units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
266 rows where LAYER = 14 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, MNG_AG_LEV, PARK_URL, COUNTY, YR_EST, GAP_STS
MNG_AGENCY >30
- Woodbridge Village Association 31
- Home Owners Association - Unknown Name 27
- Rancho Santa Margarita Landscape and Recreation Corporation 18
- Valley-Wide Recreation and Park District 7
- Amerige Heights Community Association 7
- Bellflower, City of 6
- San Clemente, City of 4
- Paseo Westpark Maintenance Association 4
- Deerfield Community Association 4
- Nellie Gail Ranch Owners Association 4
- Westpark Maintenance District 4
- Sierra Bonita Community Association 4
- Town Center Association 4
- Irvine, City of 3
- Quail Hill Community Association 3
- Private Landowner 3
- Wildlands Inc 3
- East Highlands Ranch MHOA 3
- Northpark Square Maintenance Association 3
- Turtle Rock Broadmoor Community Association 3
- Summerly Homes 2
- San Jacinto, City of 2
- Chino, City of 2
- Paramount, City of 2
- West Hollywood, City of 2
- Oak Creek Village Maintenance Association 2
- King City, City of 2
- Broadmoor Campus View Community Association 2
- McCloud River Railroad Company 2
- Woodbridge Owners Association 2
- …
DES_TP 19
- Private Recreation or Education 193
- Local Park 36
- Private Conservation 16
- Local Recreation Area 6
- Local Conservation Area 1
- Local Other or Unknown 1
- State Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 12
ACCESS_TYP 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16692 | 16692 | 16691 | {"type": "Polygon", "coordinates": [[[-121.42227, 36.74537], [-121.41401, 36.7565], [-121.40419, 36.75221], [-121.40404, 36.7525], [-121.40396, 36.75279], [-121.4037, 36.75322], [-121.4035, 36.75336], [-121.40337, 36.75341], [-121.40309, 36.7538], [-121.403, 36.75394], [-121.40287, 36.75408], [-121.40248, 36.75456], [-121.40064, 36.75395], [-121.40084, 36.75358], [-121.40089, 36.7534], [-121.40105, 36.75331], [-121.4012, 36.75321], [-121.40134, 36.75305], [-121.4014, 36.75287], [-121.40148, 36.75279], [-121.40151, 36.7527], [-121.40159, 36.75265], [-121.40164, 36.75256], [-121.40165, 36.75238], [-121.40174, 36.75231], [-121.40179, 36.75223], [-121.40179, 36.75215], [-121.40203, 36.75203], [-121.40207, 36.75179], [-121.40218, 36.75164], [-121.40225, 36.75158], [-121.40227, 36.75155], [-121.40226, 36.75148], [-121.4022, 36.75136], [-121.40224, 36.75119], [-121.40243, 36.75104], [-121.40254, 36.75098], [-121.40272, 36.7508], [-121.40277, 36.75064], [-121.40276, 36.7506], [-121.40278, 36.75043], [-121.40276, 36.75037], [-121.40279, 36.75033], [-121.4029, 36.75022], [-121.40467, 36.75106], [-121.40623, 36.74897], [-121.4083, 36.74988], [-121.40942, 36.74838], [-121.41193, 36.74948], [-121.41574, 36.74435], [-121.41574, 36.74355], [-121.41776, 36.7434], [-121.42227, 36.74537]]]} | Open Access 1 | 44462 | Hollister Hills State Vehicular Recreation Area | 4250 | 6069 | Green Valley Homeowners Recreation Association 1101 | Private 7 | Home Owners Association 16 | http://www.gvhra.com/ | Private 14 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://ohv.parks.ca.gov/?page_id=1179 | San Benito 38 | 277.458 | Hollister Hills SVRA | 1975 | State Recreation Area 39 | 4 |
15246 | 15246 | 15245 | {"type": "Polygon", "coordinates": [[[-117.84926, 34.08602], [-117.84835, 34.08657], [-117.84776, 34.08715], [-117.84678, 34.08702], [-117.8469, 34.08751], [-117.84639, 34.08764], [-117.84612, 34.0873], [-117.8453, 34.08752], [-117.84539, 34.08772], [-117.84528, 34.08799], [-117.84507, 34.08831], [-117.84442, 34.08851], [-117.84404, 34.08774], [-117.84443, 34.08765], [-117.84478, 34.08726], [-117.84618, 34.08684], [-117.84717, 34.08673], [-117.84857, 34.08591], [-117.84917, 34.08485], [-117.84905, 34.08586], [-117.84926, 34.08602]]]} | Open Access 1 | 46289 | Lyman Staging Area | 29581 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/!ut/p/b0/04_Sj9CPykssy0xPLMnMz0vMAfGjzOLdDAwM3P2dgo0MggwcDTxdQl3MnI3DDMwNDfQLsh0VASikIj4!/ | Los Angeles 6 | 8.522 | Lyman Staging Area | None 1341 | |||
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 | ||
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 | |
3526 | 3526 | 3525 | {"type": "Polygon", "coordinates": [[[-118.11099, 33.9097], [-118.1104, 33.90972], [-118.10973, 33.90773], [-118.11031, 33.90763], [-118.11099, 33.9097]]]} | Open Access 1 | 20596 | H. Byrum Zinn Community Park and Trail | 29571 | 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 | 3.096 | H. Byrum Zinn Community Park and Trail | 0 | Local Recreation Area 3 | 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 | |
4426 | 4426 | 4425 | {"type": "Polygon", "coordinates": [[[-118.10901, 33.88199], [-118.109, 33.88235], [-118.10866, 33.88235], [-118.10866, 33.88199], [-118.10901, 33.88199]]]} | Open Access 1 | 46311 | Caruthers Park North | 29601 | 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 | https://www.bellflower.org/home/index.asp?page=132 | Los Angeles 6 | 0.313 | Caruthers Park North | 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 | |
15256 | 15256 | 15255 | {"type": "MultiPolygon", "coordinates": [[[[-118.109, 33.88327], [-118.10866, 33.88327], [-118.10866, 33.88309], [-118.109, 33.88308], [-118.109, 33.88327]]], [[[-118.10902, 33.88416], [-118.10866, 33.88416], [-118.10866, 33.8838], [-118.10901, 33.8838], [-118.10902, 33.88416]]]]} | Open Access 1 | 46312 | Caruthers Park North | 29601 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | https://www.bellflower.org/home/index.asp?page=132 | Los Angeles 6 | 0.48 | Caruthers Park North | 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 |
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 | |
6938 | 6938 | 6937 | {"type": "Polygon", "coordinates": [[[-118.10543, 33.93264], [-118.10487, 33.93319], [-118.10081, 33.93783], [-118.10047, 33.93824], [-118.10017, 33.93865], [-118.09971, 33.93843], [-118.10032, 33.93761], [-118.10032, 33.93724], [-118.10116, 33.93525], [-118.10125, 33.93525], [-118.10344, 33.93344], [-118.10398, 33.93344], [-118.10463, 33.93269], [-118.105, 33.93223], [-118.10543, 33.93264]]]} | Open Access 1 | 5834 | Wilderness Park | 27512 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1088 | Downey, City of 80 | City 2 | City Agency 2 | Los Angeles 6 | 18.456 | Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
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 | |
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 | |
4801 | 4801 | 4800 | {"type": "Polygon", "coordinates": [[[-121.13503, 36.22044], [-121.13428, 36.22083], [-121.13391, 36.22026], [-121.13345, 36.21979], [-121.13422, 36.2194], [-121.13503, 36.22044]]]} | Open Access 1 | 48509 | CreekBridge Soccer Park | 33221 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1152 | King City, City of 473 | City 2 | City Agency 2 | Monterey 14 | 2.614 | CreekBridge Soccer Park | 0 | Local Recreation Area 3 | 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 | ||
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 |
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]);