units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
207 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 26
- Torrance, City of 18
- San Diego, City of 16
- Napa, City of 12
- Santa Rosa, City of 9
- Escondido, City of 8
- Rocklin, City of 8
- Vallejo, City of 7
- Los Angeles - Department of Water and Power, City of 6
- Saint Helena, City of 5
- Petaluma, City of 4
- Vacaville, City of 4
- San Marcos, City of 4
- Rolling Hills, City of 3
- Long Beach, City of 3
- La Verne, City of 3
- Chico, City of 3
- Roseville, City of 3
- Poway, City of 2
- Rancho Palos Verdes, City of 2
- Palos Verdes Estates, City of 2
- Redding, City of 2
- Sebastopol, City of 2
- Watsonville, City of 1
- Santee, City of 1
- Glendora, City of 1
- Oceanside, City of 1
- Chula Vista, City of 1
- Rosemead, City of 1
- Davis, City of 1
- …
DES_TP >30
- Local Other or Unknown 49
- Local Recreation Area 39
- Local Park 35
- Local Conservation Area 6
- Local Resource Management Area 2
- None 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
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
LAYER 4 ✖
- City 182
- Special District 3
- Other Federal 1
- Private 1
MNG_AG_TYP 1
- City Agency · 187 ✖
ACCESS_TYP 1
- No Public Access · 187 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7948 | 7948 | 7947 | {"type": "Polygon", "coordinates": [[[-118.37369, 34.12306], [-118.3737, 34.12323], [-118.37362, 34.12338], [-118.37328, 34.12338], [-118.37328, 34.12313], [-118.3733, 34.12309], [-118.37349, 34.12293], [-118.37369, 34.12306]]]} | No Public Access 3 | 12814 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.377 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
3582 | 3582 | 3581 | {"type": "Polygon", "coordinates": [[[-118.32429, 33.80965], [-118.32389, 33.80965], [-118.32389, 33.80924], [-118.32429, 33.80924], [-118.32429, 33.80965]]]} | No Public Access 3 | 36688 | Empty Lot 237th and Vine | 29082 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.419 | Empty Lot 237th and Vine | 0 | Local Other or Unknown 14 | 4 | |
12763 | 12763 | 12762 | {"type": "Polygon", "coordinates": [[[-118.35893, 33.85167], [-118.35893, 33.85181], [-118.35772, 33.85181], [-118.35772, 33.85168], [-118.35893, 33.85167]]]} | No Public Access 3 | 35836 | Entradero Swale 6 | 29163 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.421 | Entradero Swale 6 | None 1118 | |||
15363 | 15363 | 15362 | {"type": "Polygon", "coordinates": [[[-118.04461, 34.0463], [-118.04438, 34.04649], [-118.04391, 34.0461], [-118.04414, 34.0459], [-118.04461, 34.0463]]]} | No Public Access 3 | 46548 | Civic Center Community Park | 29845 | 1402 | South El Monte, City of 606 | City 2 | City Agency 2 | http://www.ci.south-el-monte.ca.us/CITYDEPARTMENTSSERVICES/CommunityServices/ParksandRecreationDivision.aspx | City 2 | 1402 | South El Monte, City of 595 | City 2 | City Agency 2 | Los Angeles 6 | 0.465 | Civic Ctr. Community Park | 0 | Local Park 2 | 4 | |
4667 | 4667 | 4666 | {"type": "Polygon", "coordinates": [[[-122.26819, 38.3106], [-122.26761, 38.3104], [-122.26755, 38.31017], [-122.26748, 38.31002], [-122.26773, 38.30992], [-122.26819, 38.3106]]]} | No Public Access 3 | 36614 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.487 | 0 | Local Other or Unknown 14 | 4 | ||
3570 | 3570 | 3569 | {"type": "Polygon", "coordinates": [[[-122.29827, 38.33084], [-122.29801, 38.33096], [-122.29792, 38.33085], [-122.29785, 38.33081], [-122.29739, 38.3307], [-122.2972, 38.33046], [-122.29733, 38.3304], [-122.29775, 38.33062], [-122.29795, 38.33066], [-122.29796, 38.33065], [-122.29814, 38.33067], [-122.29827, 38.33084]]]} | No Public Access 3 | 36603 | Silverado Creek Maintenance District | 30030 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.498 | Silverado Creek Maintenance District | None 299 | |||
11456 | 11456 | 11455 | {"type": "Polygon", "coordinates": [[[-118.0761, 34.07395], [-118.07588, 34.07396], [-118.07583, 34.07284], [-118.07606, 34.07306], [-118.0761, 34.07395]]]} | No Public Access 3 | 48148 | Rosemead Community Garden | 32678 | 1284 | Rosemead, City of 130 | City 2 | City Agency 2 | http://www.cityofrosemead.org/index.aspx?page=74 | City 2 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 0.555 | Rosemead Community Garden | 0 | Local Park 2 | 4 | |
13434 | 13434 | 13433 | {"type": "Polygon", "coordinates": [[[-118.35344, 33.79965], [-118.35314, 33.79985], [-118.35296, 33.79967], [-118.35259, 33.79991], [-118.35249, 33.7998], [-118.3532, 33.79933], [-118.3534, 33.79955], [-118.35337, 33.79958], [-118.35344, 33.79965]]]} | No Public Access 3 | 35559 | Slope-Via Valmonte | 29176 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.562 | Slope-Via Valmonte | None 1160 | |||
4633 | 4633 | 4632 | {"type": "Polygon", "coordinates": [[[-122.26376, 38.30317], [-122.26366, 38.30341], [-122.26313, 38.30317], [-122.26295, 38.30314], [-122.26275, 38.30314], [-122.26311, 38.30284], [-122.26376, 38.30317]]]} | No Public Access 3 | 36317 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.57 | 0 | Local Other or Unknown 14 | 4 | ||
8208 | 8208 | 8207 | {"type": "MultiPolygon", "coordinates": [[[[-118.34152, 34.1213], [-118.34152, 34.12134], [-118.34148, 34.12139], [-118.34142, 34.1215], [-118.34141, 34.12163], [-118.34115, 34.12183], [-118.34097, 34.12159], [-118.34146, 34.12124], [-118.34152, 34.1213]]], [[[-118.34202, 34.12109], [-118.34195, 34.12117], [-118.3418, 34.12119], [-118.34166, 34.12124], [-118.34159, 34.12124], [-118.34154, 34.12118], [-118.34192, 34.1209], [-118.34202, 34.121], [-118.34202, 34.12109]]]]} | No Public Access 3 | 12463 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.578 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
8326 | 8326 | 8325 | {"type": "Polygon", "coordinates": [[[-118.38131, 34.10838], [-118.38103, 34.10855], [-118.38075, 34.10838], [-118.38077, 34.1079], [-118.38091, 34.10781], [-118.38131, 34.10838]]]} | No Public Access 3 | 12808 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.602 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
1411 | 1411 | 1410 | {"type": "Polygon", "coordinates": [[[-117.76876, 34.14961], [-117.76819, 34.14963], [-117.76817, 34.14987], [-117.76775, 34.14988], [-117.76775, 34.1492], [-117.76818, 34.14946], [-117.76819, 34.14957], [-117.76875, 34.14956], [-117.76876, 34.14961]]]} | No Public Access 3 | 12352 | La Verne City Parkland | 20811 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 0.671 | La Verne City Parkland | 0 | Local Park 2 | 4 | |
8211 | 8211 | 8210 | {"type": "MultiPolygon", "coordinates": [[[[-118.22394, 34.01724], [-118.22332, 34.01724], [-118.22326, 34.01718], [-118.22339, 34.01692], [-118.22343, 34.01692], [-118.22354, 34.01703], [-118.22355, 34.01702], [-118.22353, 34.01692], [-118.22386, 34.01691], [-118.22394, 34.01724]]], [[[-118.22583, 34.0794], [-118.22575, 34.07921], [-118.22576, 34.0792], [-118.2258, 34.07917], [-118.22584, 34.0794], [-118.22601, 34.07938], [-118.22623, 34.07981], [-118.2261, 34.07992], [-118.22583, 34.0794]]]]} | No Public Access 3 | 12471 | Los Angeles River | 21498 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.706 | Los Angeles River | 0 | None 684 | ||
13981 | 13981 | 13980 | {"type": "Polygon", "coordinates": [[[-118.37443, 33.82141], [-118.37442, 33.82234], [-118.37432, 33.82233], [-118.37398, 33.82192], [-118.37365, 33.822], [-118.37358, 33.82193], [-118.37359, 33.82188], [-118.37374, 33.82172], [-118.374, 33.82188], [-118.37443, 33.82141]]]} | No Public Access 3 | 36651 | Torrance holding 11 | 26417 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.738 | Torrance holding 11 | 0 | Local Other or Unknown 14 | 4 | |
14375 | 14375 | 14374 | {"type": "MultiPolygon", "coordinates": [[[[-124.0864, 40.88579], [-124.08616, 40.88604], [-124.08552, 40.8859], [-124.08554, 40.88586], [-124.08609, 40.88597], [-124.08628, 40.88577], [-124.0864, 40.88579]]], [[[-124.08872, 40.88422], [-124.08785, 40.88561], [-124.08769, 40.88558], [-124.08732, 40.88562], [-124.08738, 40.88553], [-124.08782, 40.88545], [-124.08839, 40.88455], [-124.08846, 40.88429], [-124.08854, 40.88416], [-124.08872, 40.88422]]], [[[-124.08879, 40.88379], [-124.08864, 40.88404], [-124.08855, 40.88401], [-124.08871, 40.88376], [-124.08879, 40.88379]]]]} | No Public Access 3 | 47027 | Janes Creek Openspace | 30677 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 0.742 | Janes Creek Openspace | None 1219 | |||
15449 | 15449 | 15448 | {"type": "Polygon", "coordinates": [[[-122.30439, 38.26326], [-122.30382, 38.2634], [-122.30362, 38.26287], [-122.30419, 38.26274], [-122.30439, 38.26326]]]} | No Public Access 3 | 36595 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.78 | 0 | Local Other or Unknown 14 | 4 | ||
2803 | 2803 | 2802 | {"type": "Polygon", "coordinates": [[[-118.37097, 34.13187], [-118.37053, 34.13214], [-118.36993, 34.13183], [-118.37013, 34.13145], [-118.37097, 34.13187]]]} | No Public Access 3 | 12817 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.89 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
13549 | 13549 | 13548 | {"type": "Polygon", "coordinates": [[[-118.36169, 33.85181], [-118.35893, 33.85181], [-118.35893, 33.85167], [-118.36169, 33.85167], [-118.36169, 33.85181]]]} | No Public Access 3 | 35909 | Entradero Swale 5 | 29162 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.961 | Entradero Swale 5 | None 1168 | |||
5496 | 5496 | 5495 | {"type": "Polygon", "coordinates": [[[-118.39301, 34.11863], [-118.39283, 34.11899], [-118.39267, 34.11881], [-118.39276, 34.11874], [-118.39271, 34.11868], [-118.3926, 34.11875], [-118.39249, 34.11863], [-118.39234, 34.11881], [-118.39226, 34.11887], [-118.39219, 34.11889], [-118.39201, 34.11889], [-118.39183, 34.11881], [-118.39175, 34.11874], [-118.39223, 34.11873], [-118.39222, 34.11808], [-118.39228, 34.11821], [-118.39284, 34.11848], [-118.39299, 34.11857], [-118.39297, 34.1186], [-118.39301, 34.11863]]]} | No Public Access 3 | 12820 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.964 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
251 | 251 | 250 | {"type": "Polygon", "coordinates": [[[-117.0929, 33.12785], [-117.09258, 33.12797], [-117.09245, 33.12767], [-117.09253, 33.12696], [-117.09276, 33.12662], [-117.09289, 33.12693], [-117.09286, 33.12698], [-117.09278, 33.12727], [-117.09278, 33.12756], [-117.0929, 33.12785]]]} | No Public Access 3 | 683 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 0.966 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 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]);