units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
YR_EST >30 ✖
MNG_AG_TYP >30
- City Agency 9,675
- County Agency 1,127
- Recreation/Parks District 1,120
- State Agency 1,110
- Non Profit - Land Trust 574
- Federal Agency 491
- Open Space District 410
- Water District 235
- County Agency - Parks 229
- Home Owners Association 198
- Community Services District 197
- Non Profit - Conservation 146
- Flood District 102
- Irrigation District 48
- Cemetery District 46
- Non Profit - Other 45
- School District 38
- County Agency - Other 31
- Port/Harbor District 29
- Special District - Other 15
- Commercial 14
- Sanitation District 9
- Joint Powers Authority 9
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 480
- Los Angeles, City of 444
- California Department of Fish and Wildlife 430
- California Department of Parks and Recreation 373
- Mountains Recreation and Conservation Authority 334
- San Jose, City of 236
- Sacramento, City of 220
- San Francisco, City and County of 200
- East Bay Regional Park District 165
- Los Angeles, County of 153
- Ventura, City of 144
- Roseville, City of 130
- Long Beach, City of 128
- Oakland, City of 120
- United States Bureau of Land Management 117
- Santa Barbara, County of 109
- San Diego, County of 106
- United States Forest Service 105
- Irvine, City of 99
- Consumnes Community Services District 94
- Orange, County of 85
- Modesto, City of 85
- California State Lands Commission 83
- Hayward Area Recreation and Park District 82
- United States Fish and Wildlife Service 81
- Stockton, City of 81
- Napa, City of 81
- United States National Park Service 80
- Santa Rosa, City of 78
- Tracy, City of 73
- …
DES_TP >30
- Local Park 8,545
- Local Recreation Area 1,902
- Local Other or Unknown 1,171
- Private Conservation 601
- Local Conservation Area 465
- State Conservation Area 371
- Private Recreation or Education 263
- State Park 204
- State Resource Management Area 157
- State Recreation Area 141
- Local Historic or Cultural Area 96
- National Forest 92
- National Wildlife Refuge 75
- National Public Lands 72
- State Other or Unknown 70
- State Historic or Cultural Area 63
- Recreation Management Area 57
- Private Other or Unknown 51
- National Monument or Landmark 38
- National Recreation Area 37
- Resource Management Area 25
- National Park 23
- Local Resource Management Area 23
- Federal Other or Unknown 23
- Conservation Area 12
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 6
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 13,446
- Restricted Access 1,163
- No Public Access 944
- Unknown Access 379
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1137 | 1137 | 1136 | {"type": "MultiPolygon", "coordinates": [[[[-117.02885, 33.34502], [-117.02695, 33.34498], [-117.02614, 33.34414], [-117.02426, 33.34497], [-117.02419, 33.34265], [-117.02878, 33.34259], [-117.02885, 33.34502]]], [[[-117.05093, 33.3583], [-117.04668, 33.35835], [-117.04442, 33.35814], [-117.04443, 33.35429], [-117.04345, 33.35427], [-117.0434, 33.35804], [-117.04323, 33.35802], [-117.04326, 33.35059], [-117.04225, 33.35057], [-117.04224, 33.35058], [-117.04223, 33.35424], [-117.04258, 33.35426], [-117.04258, 33.35796], [-117.04222, 33.35793], [-117.04221, 33.35603], [-117.04114, 33.35604], [-117.0411, 33.35792], [-117.04095, 33.35765], [-117.04058, 33.35758], [-117.03982, 33.35725], [-117.03928, 33.35674], [-117.03849, 33.35579], [-117.03828, 33.35582], [-117.03668, 33.35448], [-117.03357, 33.35447], [-117.03356, 33.35433], [-117.02942, 33.35428], [-117.0292, 33.3542], [-117.02912, 33.35051], [-117.02563, 33.35045], [-117.02562, 33.34983], [-117.0257, 33.34859], [-117.02569, 33.3484], [-117.02565, 33.34824], [-117.02555, 33.34803], [-117.02542, 33.34786], [-117.02435, 33.34678], [-117.02433, 33.34655], [-117.03346, 33.34656], [-117.03331, 33.34315], [-117.04228, 33.34309], [-117.05066, 33.3431], [-117.05068, 33.34591], [-117.0508, 33.35071], [-117.05093, 33.3583]]]]} | Open Access 1 | 7251 | Wilderness Gardens Preserve | 29262 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/WildernessGardens.html | San Diego 4 | 732.625 | Wilderness Gardens Preserve | 0 | Local Conservation Area 4 | 2 |
1138 | 1138 | 1137 | {"type": "Polygon", "coordinates": [[[-118.17117, 33.79377], [-118.1707, 33.79377], [-118.1707, 33.79348], [-118.17072, 33.79348], [-118.17117, 33.79377]]]} | No Public Access 3 | 6684 | Chittick Field | 29944 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.181 | Chittick Field | 2014 | Local Recreation Area 3 | 4 | |
1139 | 1139 | 1138 | {"type": "Polygon", "coordinates": [[[-122.51189, 37.77681], [-122.51151, 37.77685], [-122.5112, 37.77653], [-122.51112, 37.77641], [-122.51112, 37.77626], [-122.51093, 37.77611], [-122.51078, 37.77588], [-122.51061, 37.77568], [-122.51028, 37.77523], [-122.51108, 37.7752], [-122.51109, 37.77541], [-122.51113, 37.77564], [-122.5112, 37.77588], [-122.51128, 37.77607], [-122.51149, 37.7764], [-122.51189, 37.77681]]]} | Open Access 1 | 6699 | Gr.hwy/balboa Natural Area | 19412 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.868 | Gr.hwy/balboa Natural Area | 0 | Local Conservation Area 4 | 2 | |
1140 | 1140 | 1139 | {"type": "Polygon", "coordinates": [[[-118.1547, 33.95388], [-118.15452, 33.95422], [-118.15424, 33.9546], [-118.15397, 33.95488], [-118.15371, 33.95511], [-118.15347, 33.95528], [-118.14778, 33.95833], [-118.14294, 33.95579], [-118.14293, 33.95577], [-118.14293, 33.95574], [-118.14549, 33.95228], [-118.14787, 33.95356], [-118.14876, 33.95237], [-118.15149, 33.95385], [-118.15239, 33.95264], [-118.1547, 33.95388]]]} | Restricted Access 2 | 6710 | Rio Hondo Golf Club | 33020 | 1088 | Downey, City of 82 | City 2 | City Agency 2 | http://www.downeyca.org/services/cs/default.asp | City 2 | 1088 | Downey, City of 80 | City 2 | City Agency 2 | Los Angeles 6 | 101.146 | Rio Hondo Golf Club | 0 | Local Recreation Area 3 | 4 | |
1141 | 1141 | 1140 | {"type": "Polygon", "coordinates": [[[-122.44587, 37.72056], [-122.4458, 37.72066], [-122.44507, 37.72037], [-122.44513, 37.72028], [-122.44518, 37.72027], [-122.44529, 37.72033], [-122.44587, 37.72056]]]} | Open Access 1 | 6711 | Geneva Ave Strip | 19256 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.231 | Geneva Ave Strip | None 102 | |||
1142 | 1142 | 1141 | {"type": "MultiPolygon", "coordinates": [[[[-118.15899, 34.20112], [-118.15798, 34.20099], [-118.15803, 34.20185], [-118.15593, 34.20201], [-118.15628, 34.20126], [-118.15588, 34.20113], [-118.15642, 34.19994], [-118.15896, 34.20076], [-118.15899, 34.20112]]], [[[-118.1575, 34.20252], [-118.15539, 34.20268], [-118.15534, 34.20222], [-118.15742, 34.20206], [-118.15745, 34.2021], [-118.1575, 34.20252]]], [[[-118.15918, 34.20422], [-118.1569, 34.20411], [-118.15721, 34.20392], [-118.15738, 34.20379], [-118.15741, 34.20376], [-118.15741, 34.20374], [-118.15755, 34.20359], [-118.15768, 34.20337], [-118.15774, 34.20316], [-118.15776, 34.20299], [-118.15766, 34.20208], [-118.15768, 34.20204], [-118.15909, 34.20194], [-118.15918, 34.20422]]]]} | Open Access 1 | 6712 | Loma Alta Park | 32482 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 20.497 | Loma Alta Park | 0 | Local Park 2 | 4 | |
1143 | 1143 | 1142 | {"type": "Polygon", "coordinates": [[[-122.37519, 40.68902], [-122.37481, 40.68902], [-122.37446, 40.68819], [-122.37432, 40.68767], [-122.37432, 40.68736], [-122.37481, 40.68737], [-122.37482, 40.68864], [-122.37489, 40.68876], [-122.37516, 40.68898], [-122.37519, 40.68902]]]} | Open Access 1 | 48430 | Blue Canyon Park | 33127 | 1438 | Shasta Lake, City of 324 | City 2 | City Agency 2 | http://www.ci.shasta-lake.ca.us/index.aspx?nid=253 | City 2 | 1438 | Shasta Lake, City of 321 | City 2 | City Agency 2 | https://cityofshastalake.org/553/Parks | Shasta 27 | 1.375 | Blue Canyon Park | 0 | Local Park 2 | 4 |
1144 | 1144 | 1143 | {"type": "Polygon", "coordinates": [[[-118.50693, 34.45383], [-118.50419, 34.45385], [-118.50418, 34.45232], [-118.50691, 34.4523], [-118.50693, 34.45383]]]} | Open Access 1 | 7283 | Bouquet Canyon Park | 16302 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 10.567 | Bouquet Canyon Park | 0 | Local Park 2 | 4 | |
1145 | 1145 | 1144 | {"type": "Polygon", "coordinates": [[[-118.08726, 34.1584], [-118.08682, 34.15836], [-118.08638, 34.15829], [-118.08536, 34.15802], [-118.08542, 34.15783], [-118.08564, 34.15677], [-118.08585, 34.1568], [-118.086, 34.15604], [-118.08705, 34.15619], [-118.08703, 34.15669], [-118.08705, 34.15718], [-118.08711, 34.15767], [-118.08726, 34.1584]]]} | Open Access 1 | 6726 | Viña Vieja Park | 28118 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 7.898 | Viña Vieja Park | 0 | Local Park 2 | 4 | |
1146 | 1146 | 1145 | {"type": "Polygon", "coordinates": [[[-118.07621, 34.16419], [-118.07389, 34.1642], [-118.07385, 34.16196], [-118.07616, 34.16193], [-118.07621, 34.16419]]]} | Open Access 1 | 6729 | Hamilton Park | 19620 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 13.142 | Hamilton Park | 0 | Local Park 2 | 4 | |
1147 | 1147 | 1146 | {"type": "Polygon", "coordinates": [[[-118.08707, 34.14127], [-118.08706, 34.1421], [-118.08635, 34.14211], [-118.08635, 34.14203], [-118.08628, 34.14203], [-118.08607, 34.14179], [-118.08603, 34.14173], [-118.08594, 34.14163], [-118.08453, 34.14025], [-118.08436, 34.14002], [-118.08426, 34.13981], [-118.08387, 34.13867], [-118.08386, 34.13849], [-118.08413, 34.13849], [-118.08413, 34.1389], [-118.08447, 34.1389], [-118.08445, 34.13992], [-118.08449, 34.14005], [-118.08458, 34.14016], [-118.0847, 34.14024], [-118.08486, 34.14028], [-118.08596, 34.14027], [-118.08594, 34.14115], [-118.0861, 34.14128], [-118.08707, 34.14127]]]} | Open Access 1 | 6731 | Eaton Blanche Park | 18406 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/Eaton_Blanche_Park/ | Los Angeles 6 | 5.782 | Eaton Blanche Park | 0 | Local Park 2 | 4 |
1148 | 1148 | 1147 | {"type": "Polygon", "coordinates": [[[-118.17776, 34.14042], [-118.17776, 34.14045], [-118.17758, 34.14079], [-118.17755, 34.14081], [-118.17673, 34.14085], [-118.1767, 34.14083], [-118.17661, 34.14069], [-118.17742, 34.14033], [-118.17773, 34.14039], [-118.17776, 34.14042]]]} | Open Access 1 | 6733 | San Rafael Park | 24983 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/San_Rafael_Park/ | Los Angeles 6 | 0.948 | San Rafael Park | 0 | Local Park 2 | 4 |
1149 | 1149 | 1148 | {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} | Restricted Access 2 | 6734 | Hillcrest And Ocean View Lots | 19962 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 0.08 | Hillcrest And Ocean View Lots | 0 | Local Other or Unknown 14 | 4 | |
1150 | 1150 | 1149 | {"type": "Polygon", "coordinates": [[[-118.00252, 33.9204], [-118.00176, 33.92042], [-118.0013, 33.92086], [-118.00129, 33.92095], [-118.0011, 33.92094], [-118.00067, 33.92095], [-118.00055, 33.92097], [-118.00054, 33.92099], [-117.99937, 33.92118], [-117.99564, 33.9216], [-117.99534, 33.92172], [-117.99465, 33.92215], [-117.99459, 33.92217], [-117.99455, 33.92225], [-117.99452, 33.92225], [-117.99451, 33.92104], [-117.99447, 33.92103], [-117.99447, 33.92091], [-117.99652, 33.92069], [-117.99652, 33.92001], [-117.99657, 33.92002], [-117.99666, 33.91998], [-117.99666, 33.92066], [-117.99671, 33.92067], [-117.99893, 33.92043], [-118.00039, 33.92042], [-118.00094, 33.92026], [-118.00122, 33.92015], [-118.00178, 33.91989], [-118.00206, 33.91978], [-118.0024, 33.91969], [-118.00249, 33.91999], [-118.00245, 33.92002], [-118.00241, 33.92009], [-118.00241, 33.92019], [-118.00251, 33.92035], [-118.00252, 33.9204]]]} | Open Access 1 | 6758 | Creek Park | 17763 | 1158 | La Mirada, City of 326 | City 2 | City Agency 2 | http://www.cityoflamirada.org/index.aspx?page=58 | City 2 | 1158 | La Mirada, City of 323 | City 2 | City Agency 2 | Los Angeles 6 | 15.949 | Creek Park | 0 | Local Park 2 | 4 | |
1151 | 1151 | 1150 | {"type": "Polygon", "coordinates": [[[-118.16869, 34.15351], [-118.16865, 34.15354], [-118.16836, 34.15333], [-118.16826, 34.15332], [-118.16819, 34.15335], [-118.16814, 34.1534], [-118.16812, 34.15344], [-118.16805, 34.15383], [-118.16806, 34.15393], [-118.16779, 34.15412], [-118.16776, 34.15415], [-118.16784, 34.15438], [-118.168, 34.15465], [-118.16854, 34.15527], [-118.16857, 34.15539], [-118.16858, 34.15549], [-118.16855, 34.15561], [-118.1685, 34.15571], [-118.16843, 34.1558], [-118.16832, 34.15588], [-118.16823, 34.15592], [-118.16757, 34.15606], [-118.1676, 34.15659], [-118.16753, 34.15651], [-118.16743, 34.15645], [-118.16731, 34.15641], [-118.1672, 34.15641], [-118.16632, 34.15661], [-118.16607, 34.15669], [-118.16566, 34.15687], [-118.16435, 34.15769], [-118.16411, 34.15782], [-118.16386, 34.15734], [-118.16382, 34.15729], [-118.16343, 34.15642], [-118.16335, 34.1563], [-118.16308, 34.156], [-118.16347, 34.15577], [-118.16293, 34.15456], [-118.16303, 34.15449], [-118.16324, 34.15425], [-118.1628, 34.15332], [-118.16238, 34.15345], [-118.16284, 34.15231], [-118.1627, 34.15135], [-118.16242, 34.1512], [-118.16264, 34.15103], [-118.16247, 34.15079], [-118.16268, 34.15066], [-118.1629, 34.15045], [-118.16304, 34.15034], [-118.16357, 34.15003], [-118.16381, 34.14994], [-118.16408, 34.1497], [-118.16416, 34.14967], [-118.16448, 34.14959], [-118.16455, 34.14954], [-118.16462, 34.14942], [-118.16474, 34.1494], [-118.16452, 34.14863], [-118.16443, 34.1485], [-118.16425, 34.14833], [-118.16468, 34.14833], [-118.1652, 34.14871], [-118.1653, 34.14833], [-118.16548, 34.14832], [-118.16545, 34.14792], [-118.16543, 34.14782], [-118.16538, 34.14775], [-118.1653, 34.14766], [-118.1652, 34.14759], [-118.16509, 34.14755], [-118.16495, 34.14752], [-118.16473, 34.14742], [-118.16432, 34.14709], [-118.16448, 34.14694], [-118.16422, 34.14675], [-118.16411, 34.14655], [-118.16412, 34.14645], [-118.1651, 34.1462], [-118.165, 34.14637], [-118.165, 34.14655], [-118.16541, 34.14669], [-118.16582, 34.14675], [-118.16616, 34.14688], [-118.1662, 34.14692], [-118.1661, 34.14692], [-118.16609, 34.14693], [-118.16613, 34.14696], [-118.16626, 34.14697], [-118.16679, 34.14743], [-118.16676, 34.14781], [-118.16648, 34.14813], [-118.16642, 34.14823], [-118.16635, 34.14836], [-118.16632, 34.1485], [-118.16631, 34.14864], [-118.16632, 34.14876], [-118.16643, 34.14917], [-118.1663, 34.14923], [-118.16597, 34.14903], [-118.1658, 34.14936], [-118.16591, 34.15034], [-118.1661, 34.1504], [-118.16628, 34.15052], [-118.16633, 34.15061], [-118.16656, 34.15077], [-118.16668, 34.1509], [-118.16675, 34.1509], [-118.16678, 34.15112], [-118.16683, 34.15137], [-118.16697, 34.15176], [-118.16717, 34.15215], [-118.16734, 34.15239], [-118.1675, 34.15258], [-118.16767, 34.15276], [-118.16788, 34.15294], [-118.16869, 34.15351]]]} | Open Access 1 | 6736 | Brookside Park | 16431 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/Brookside_Park1/ | Los Angeles 6 | 94.183 | Brookside Park | 0 | Local Park 2 | 4 |
1152 | 1152 | 1151 | {"type": "Polygon", "coordinates": [[[-118.15682, 34.13566], [-118.15567, 34.13566], [-118.15566, 34.13461], [-118.15619, 34.1346], [-118.1562, 34.13464], [-118.1568, 34.13463], [-118.15682, 34.13566]]]} | Open Access 1 | 6737 | Singer Park | 25517 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 3.01 | Singer Park | 0 | Local Park 2 | 4 | |
1153 | 1153 | 1152 | {"type": "Polygon", "coordinates": [[[-118.15031, 34.14345], [-118.149, 34.14346], [-118.14897, 34.14072], [-118.14899, 34.14069], [-118.15003, 34.14068], [-118.15021, 34.14071], [-118.15028, 34.14077], [-118.15031, 34.14345]]]} | Open Access 1 | 6738 | Pasadena Central Park | 23489 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/Central_Park_Master_Plan/ | Los Angeles 6 | 9.154 | Pasadena Central Park | 0 | Local Park 2 | 4 |
1154 | 1154 | 1153 | {"type": "Polygon", "coordinates": [[[-118.14408, 34.15668], [-118.14265, 34.15668], [-118.14265, 34.15622], [-118.14284, 34.15621], [-118.14285, 34.15613], [-118.14291, 34.15613], [-118.14291, 34.15598], [-118.14264, 34.15598], [-118.14215, 34.15539], [-118.14226, 34.15475], [-118.14218, 34.15474], [-118.14218, 34.15442], [-118.14162, 34.15442], [-118.14161, 34.15425], [-118.14406, 34.15423], [-118.14408, 34.15668]]]} | Open Access 1 | 6753 | Villa Parke | 27105 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/HumanServices/VillaParke_Community_Center/ | Los Angeles 6 | 10.546 | Villa Parke | None 103 | ||
1155 | 1155 | 1154 | {"type": "Polygon", "coordinates": [[[-118.03783, 33.91186], [-118.03703, 33.91186], [-118.037, 33.90981], [-118.03775, 33.9098], [-118.0378, 33.90983], [-118.03783, 33.91186]]]} | Open Access 1 | 6759 | Frontier Park | 19132 | 1158 | La Mirada, City of 326 | City 2 | City Agency 2 | http://www.cityoflamirada.org/index.aspx?page=58 | City 2 | 1158 | La Mirada, City of 323 | City 2 | City Agency 2 | Los Angeles 6 | 4.162 | Frontier Park | 0 | Local Park 2 | 4 | |
1156 | 1156 | 1155 | {"type": "Polygon", "coordinates": [[[-118.02738, 33.89883], [-118.02466, 33.89886], [-118.02464, 33.89746], [-118.02499, 33.89716], [-118.02612, 33.89741], [-118.02738, 33.89811], [-118.02738, 33.89883]]]} | Open Access 1 | 6760 | Neff Park | 22684 | 1158 | La Mirada, City of 326 | City 2 | City Agency 2 | http://www.cityoflamirada.org/index.aspx?page=58 | City 2 | 1158 | La Mirada, City of 323 | City 2 | City Agency 2 | Los Angeles 6 | 9.259 | Neff 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]);