units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by ACCESS_TYP
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 9,654
- County Agency 1,129
- Recreation/Parks District 1,118
- State Agency 1,115
- Non Profit - Land Trust 586
- Federal Agency 498
- Open Space District 407
- Water District 236
- County Agency - Parks 228
- Home Owners Association 203
- Community Services District 197
- Non Profit - Conservation 148
- Flood District 104
- Irrigation District 49
- Cemetery District 46
- Non Profit - Other 45
- School District 38
- County Agency - Other 34
- Port/Harbor District 29
- Commercial 15
- Special District - Other 15
- 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 477
- Los Angeles, City of 440
- California Department of Fish and Wildlife 435
- California Department of Parks and Recreation 372
- Mountains Recreation and Conservation Authority 331
- San Jose, City of 236
- Sacramento, City of 220
- San Francisco, City and County of 198
- East Bay Regional Park District 165
- Los Angeles, County of 154
- Ventura, City of 144
- Roseville, City of 130
- Long Beach, City of 129
- Oakland, City of 120
- United States Bureau of Land Management 117
- Santa Barbara, County of 110
- United States Forest Service 105
- San Diego, County of 105
- Irvine, City of 99
- Consumnes Community Services District 94
- Orange, County of 85
- Modesto, City of 85
- California State Lands Commission 83
- United States Fish and Wildlife Service 82
- United States National Park Service 82
- Hayward Area Recreation and Park District 82
- Stockton, City of 81
- Napa, City of 81
- Santa Rosa, City of 79
- Tracy, City of 73
- …
DES_TP >30
- Local Park 8,511
- Local Recreation Area 1,903
- Local Other or Unknown 1,178
- Private Conservation 615
- Local Conservation Area 465
- State Conservation Area 374
- Private Recreation or Education 268
- State Park 204
- State Resource Management Area 159
- State Recreation Area 141
- Local Historic or Cultural Area 96
- National Forest 92
- National Wildlife Refuge 74
- National Public Lands 72
- State Other or Unknown 68
- State Historic or Cultural Area 63
- Recreation Management Area 58
- Private Other or Unknown 51
- National Monument or Landmark 38
- National Recreation Area 37
- Resource Management Area 26
- National Park 24
- Local Resource Management Area 24
- Federal Other or Unknown 24
- Conservation Area 13
- 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,388
- Restricted Access 1,203
- No Public Access 969
- Unknown Access 386
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1200 | 1200 | 1199 | {"type": "MultiPolygon", "coordinates": [[[[-117.90541, 34.1585], [-117.90453, 34.15837], [-117.90437, 34.15839], [-117.90421, 34.15845], [-117.904, 34.15843], [-117.90408, 34.15835], [-117.90423, 34.15828], [-117.9044, 34.15824], [-117.90456, 34.15824], [-117.9054, 34.15837], [-117.90541, 34.1585]]], [[[-117.90754, 34.15868], [-117.90754, 34.15881], [-117.90649, 34.15867], [-117.90649, 34.15852], [-117.90754, 34.15868]]], [[[-117.90401, 34.15871], [-117.90397, 34.15877], [-117.90371, 34.15961], [-117.9033, 34.15961], [-117.90163, 34.16004], [-117.89984, 34.1611], [-117.89886, 34.16208], [-117.89885, 34.16256], [-117.89881, 34.16256], [-117.89882, 34.16212], [-117.89861, 34.16211], [-117.89973, 34.16101], [-117.90022, 34.1607], [-117.89901, 34.16124], [-117.89884, 34.16139], [-117.8987, 34.16156], [-117.89728, 34.16357], [-117.89714, 34.16374], [-117.89686, 34.164], [-117.89655, 34.1642], [-117.89633, 34.16431], [-117.89605, 34.16441], [-117.89461, 34.1647], [-117.89323, 34.16486], [-117.89298, 34.16493], [-117.89253, 34.16513], [-117.89224, 34.16513], [-117.89224, 34.1651], [-117.89289, 34.16481], [-117.89305, 34.16475], [-117.89459, 34.16456], [-117.89597, 34.16429], [-117.89617, 34.16423], [-117.8964, 34.16412], [-117.89668, 34.16396], [-117.89684, 34.16383], [-117.89705, 34.16361], [-117.89856, 34.16149], [-117.89868, 34.16134], [-117.8989, 34.16114], [-117.90321, 34.15912], [-117.90322, 34.1591], [-117.90317, 34.15875], [-117.90362, 34.1587], [-117.90401, 34.15871]], [[-117.90325, 34.15927], [-117.90321, 34.15927], [-117.90307, 34.15933], [-117.90229, 34.15971], [-117.90327, 34.15948], [-117.90325, 34.15927]]]]} | Open Access 1 | 6939 | San Gabriel River | 24896 | 2137 | San Gabriel River Water Committee 332 | Special District 4 | Water District 13 | Special District 4 | 2137 | San Gabriel River Water Committee 329 | Special District 4 | Water District 13 | Los Angeles 6 | 8.661 | San Gabriel River | 0 | None 106 | |||
1201 | 1201 | 1200 | {"type": "MultiPolygon", "coordinates": [[[[-118.21043, 34.19465], [-118.21042, 34.19681], [-118.20855, 34.19793], [-118.20783, 34.19795], [-118.2078, 34.19801], [-118.20775, 34.19797], [-118.20767, 34.19783], [-118.20761, 34.19779], [-118.20753, 34.19779], [-118.20749, 34.19782], [-118.20747, 34.19785], [-118.20723, 34.1978], [-118.20725, 34.1977], [-118.20723, 34.19761], [-118.20718, 34.19752], [-118.20706, 34.19742], [-118.20669, 34.19728], [-118.20637, 34.19712], [-118.2061, 34.19703], [-118.20588, 34.19699], [-118.20589, 34.1969], [-118.20544, 34.1966], [-118.20516, 34.19663], [-118.20464, 34.19646], [-118.20464, 34.19628], [-118.20363, 34.196], [-118.20377, 34.19575], [-118.20364, 34.19522], [-118.20348, 34.19494], [-118.20297, 34.19471], [-118.20387, 34.19432], [-118.20377, 34.19418], [-118.20374, 34.19409], [-118.20371, 34.19396], [-118.20362, 34.19381], [-118.20354, 34.19374], [-118.20344, 34.19368], [-118.20338, 34.19369], [-118.20335, 34.19374], [-118.20326, 34.19362], [-118.20327, 34.1936], [-118.20351, 34.19344], [-118.20355, 34.19346], [-118.20376, 34.19338], [-118.20418, 34.19339], [-118.20462, 34.1931], [-118.20447, 34.19293], [-118.20413, 34.19281], [-118.20425, 34.19256], [-118.20607, 34.19304], [-118.20639, 34.19295], [-118.20658, 34.19219], [-118.20647, 34.19208], [-118.2061, 34.19186], [-118.20588, 34.19136], [-118.20537, 34.19109], [-118.2057, 34.1908], [-118.20569, 34.19048], [-118.2045, 34.18997], [-118.20341, 34.18966], [-118.20294, 34.18919], [-118.20278, 34.18948], [-118.20221, 34.1896], [-118.20203, 34.18953], [-118.20192, 34.18948], [-118.20179, 34.18862], [-118.20153, 34.18845], [-118.20205, 34.1879], [-118.20216, 34.18786], [-118.20324, 34.18789], [-118.20375, 34.18757], [-118.20525, 34.18911], [-118.20713, 34.18763], [-118.20746, 34.18778], [-118.2077, 34.18779], [-118.20778, 34.18782], [-118.2079, 34.18795], [-118.20803, 34.18798], [-118.20778, 34.1893], [-118.20791, 34.19013], [-118.20802, 34.19061], [-118.21042, 34.19233], [-118.21043, 34.19465]]], [[[-118.21345, 34.19409], [-118.21264, 34.19506], [-118.2128, 34.19534], [-118.21098, 34.19647], [-118.21098, 34.19475], [-118.21194, 34.19493], [-118.21195, 34.19445], [-118.21098, 34.19443], [-118.21098, 34.19273], [-118.21101, 34.19276], [-118.21216, 34.1927], [-118.21345, 34.19409]]]]} | Open Access 1 | 6940 | Cherry Canyon Park | 17166 | 1154 | La Canada Flintridge, City of 333 | City 2 | City Agency 2 | http://www.lcf.ca.gov/parks-rec | City 2 | 1154 | La Canada Flintridge, City of 330 | City 2 | City Agency 2 | Los Angeles 6 | 136.901 | Cherry Canyon Park | 0 | Local Park 2 | 4 | |
1202 | 1202 | 1201 | {"type": "Polygon", "coordinates": [[[-117.97826, 33.84135], [-117.97825, 33.84136], [-117.97826, 33.84163], [-117.97826, 33.84221], [-117.97824, 33.84225], [-117.97636, 33.84226], [-117.9763, 33.84225], [-117.97627, 33.84222], [-117.97626, 33.84138], [-117.97826, 33.84133], [-117.97826, 33.84135]]]} | Open Access 1 | 8374 | Peter Marshall Park | 23627 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 4.555 | Peter Marshall Park | 0 | Local Park 2 | 4 | |
1203 | 1203 | 1202 | {"type": "Polygon", "coordinates": [[[-118.20224, 34.18028], [-118.20222, 34.18038], [-118.20222, 34.18051], [-118.20181, 34.18053], [-118.20179, 34.18078], [-118.20182, 34.18124], [-118.20177, 34.18125], [-118.2018, 34.18154], [-118.20179, 34.18154], [-118.20155, 34.18147], [-118.20095, 34.18115], [-118.20096, 34.18102], [-118.20086, 34.18095], [-118.20069, 34.18086], [-118.20042, 34.18077], [-118.20025, 34.18068], [-118.20016, 34.18061], [-118.20008, 34.18052], [-118.20002, 34.18041], [-118.19999, 34.18031], [-118.19995, 34.18025], [-118.20013, 34.1801], [-118.20067, 34.18007], [-118.20072, 34.17987], [-118.20086, 34.17974], [-118.20103, 34.17953], [-118.20134, 34.17941], [-118.20174, 34.17962], [-118.20194, 34.17986], [-118.20194, 34.17999], [-118.20186, 34.18029], [-118.20224, 34.18028]]]} | Open Access 1 | 6950 | Emerald Isle Park | 18616 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 6.204 | Emerald Isle Park | 0 | Local Park 2 | 4 | |
1204 | 1204 | 1203 | {"type": "Polygon", "coordinates": [[[-118.22149, 34.17394], [-118.2211, 34.17522], [-118.22096, 34.17516], [-118.22088, 34.1751], [-118.22025, 34.1749], [-118.21963, 34.17458], [-118.21952, 34.17411], [-118.22128, 34.17399], [-118.22131, 34.17398], [-118.22133, 34.17391], [-118.22149, 34.17394]]]} | Open Access 1 | 6951 | Mayor's Bicentennial Park | 21978 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 3.901 | Mayor's Bicentennial Park | 0 | Local Park 2 | 4 | |
1205 | 1205 | 1204 | {"type": "Polygon", "coordinates": [[[-118.20232, 34.16387], [-118.20106, 34.1656], [-118.19947, 34.16766], [-118.19941, 34.16746], [-118.19749, 34.16476], [-118.19693, 34.16344], [-118.19696, 34.1634], [-118.19691, 34.16337], [-118.19799, 34.1627], [-118.19908, 34.16182], [-118.19934, 34.16179], [-118.19954, 34.16174], [-118.20232, 34.16387]]]} | Open Access 1 | 6952 | Poulsen Open Space | 23929 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 42.171 | Poulsen OS | 0 | Local Recreation Area 3 | 4 | |
1206 | 1206 | 1205 | {"type": "Polygon", "coordinates": [[[-122.69481, 38.34006], [-122.6948, 38.3401], [-122.69443, 38.34011], [-122.69437, 38.34025], [-122.69369, 38.33982], [-122.69282, 38.33935], [-122.6926, 38.33958], [-122.6919, 38.33919], [-122.69186, 38.33914], [-122.69191, 38.33898], [-122.69192, 38.3389], [-122.69229, 38.3389], [-122.69228, 38.33872], [-122.69224, 38.33849], [-122.69215, 38.33812], [-122.69255, 38.3382], [-122.69262, 38.33827], [-122.69308, 38.33902], [-122.6931, 38.3391], [-122.6932, 38.33916], [-122.69347, 38.33943], [-122.69359, 38.33934], [-122.69379, 38.33956], [-122.69374, 38.33961], [-122.69373, 38.33968], [-122.69374, 38.33971], [-122.69379, 38.33976], [-122.6939, 38.3398], [-122.69422, 38.34006], [-122.69434, 38.34], [-122.69441, 38.34003], [-122.69481, 38.34006]]]} | Open Access 1 | 8435 | Caterpillar Park | 16973 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 3.241 | Caterpillar Park | 1962 | Local Park 2 | 4 | |
1207 | 1207 | 1206 | {"type": "Polygon", "coordinates": [[[-122.70189, 38.33494], [-122.70176, 38.3354], [-122.70189, 38.33561], [-122.70048, 38.33619], [-122.7005, 38.33624], [-122.69917, 38.33674], [-122.69927, 38.33693], [-122.69936, 38.3369], [-122.69964, 38.33736], [-122.69877, 38.33769], [-122.69843, 38.33712], [-122.69844, 38.33707], [-122.69859, 38.33701], [-122.69875, 38.33689], [-122.69884, 38.3368], [-122.69893, 38.33661], [-122.69894, 38.33646], [-122.69891, 38.33637], [-122.69885, 38.33625], [-122.69866, 38.33595], [-122.70127, 38.33495], [-122.70152, 38.33476], [-122.70176, 38.3349], [-122.70189, 38.33494]]]} | Open Access 1 | 8446 | Benicia Park | 16012 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 8.436 | Benicia Park | 1962 | Local Park 2 | 4 | |
1209 | 1209 | 1208 | {"type": "Polygon", "coordinates": [[[-118.61077, 34.34136], [-118.60659, 34.34141], [-118.60658, 34.33946], [-118.61074, 34.33941], [-118.61077, 34.34136]]]} | Open Access 1 | 8436 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 20.46 | 0 | Local Other or Unknown 14 | 4 | ||
1210 | 1210 | 1209 | {"type": "MultiPolygon", "coordinates": [[[[-118.61079, 34.34292], [-118.6087, 34.34294], [-118.60869, 34.34216], [-118.61078, 34.34214], [-118.61079, 34.34292]]], [[[-118.61929, 34.3608], [-118.6181, 34.36074], [-118.61801, 34.35708], [-118.61919, 34.35713], [-118.61929, 34.3608]]]]} | Open Access 1 | 8447 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 15.04 | 0 | Local Other or Unknown 14 | 4 | ||
1211 | 1211 | 1210 | {"type": "Polygon", "coordinates": [[[-118.20078, 34.14846], [-118.20154, 34.14823], [-118.20184, 34.14784], [-118.20283, 34.14745], [-118.20339, 34.1476], [-118.20357, 34.14971], [-118.2027, 34.15067], [-118.20087, 34.15088], [-118.20079, 34.14885], [-118.19959, 34.14885], [-118.20078, 34.14846]]]} | Open Access 1 | 6958 | Eagle Rock Hillside Park | 18346 | 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 | 19.215 | Eagle Rock Hillside Park | 0 | Local Park 2 | 4 | |
1212 | 1212 | 1211 | {"type": "Polygon", "coordinates": [[[-117.25036, 34.05452], [-117.25031, 34.05479], [-117.25024, 34.05483], [-117.25016, 34.05482], [-117.24987, 34.05468], [-117.24987, 34.05445], [-117.24992, 34.05442], [-117.25032, 34.05448], [-117.25036, 34.05452]]]} | Open Access 1 | 48451 | Durango Loop Park | 33155 | 1181 | Loma Linda, City of 185 | City 2 | City Agency 2 | http://www.lomalinda-ca.gov/ | City 2 | 1181 | Loma Linda, City of 181 | City 2 | City Agency 2 | San Bernardino 22 | 0.386 | Durango Loop Park | 0 | Local Park 2 | 4 | |
1213 | 1213 | 1212 | {"type": "Polygon", "coordinates": [[[-118.28465, 34.04135], [-118.28428, 34.04135], [-118.28427, 34.04052], [-118.28434, 34.04052], [-118.28435, 34.04058], [-118.28464, 34.04058], [-118.28465, 34.04135]]]} | Open Access 1 | 8469 | Pico Union Park | 23657 | 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.722 | Pico Union Park | 0 | Local Park 2 | 4 | |
1214 | 1214 | 1213 | {"type": "Polygon", "coordinates": [[[-117.67237, 33.6469], [-117.67233, 33.64708], [-117.67221, 33.64733], [-117.67221, 33.64761], [-117.67231, 33.6481], [-117.6723, 33.64822], [-117.67224, 33.64843], [-117.67217, 33.64849], [-117.67198, 33.64854], [-117.67183, 33.64863], [-117.67141, 33.64905], [-117.67135, 33.64914], [-117.67134, 33.64934], [-117.67115, 33.64964], [-117.67018, 33.64921], [-117.67055, 33.64859], [-117.67071, 33.64827], [-117.67086, 33.64794], [-117.67094, 33.64768], [-117.67102, 33.64723], [-117.67103, 33.6469], [-117.67101, 33.64654], [-117.67201, 33.64633], [-117.67231, 33.64674], [-117.67237, 33.6469]]]} | Open Access 1 | 8555 | Pittsford Park | 23751 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 9.931 | Pittsford Park | 0 | Local Park 2 | 4 | |
1215 | 1215 | 1214 | {"type": "MultiPolygon", "coordinates": [[[[-118.00306, 34.14857], [-118.00111, 34.1486], [-118.00111, 34.14833], [-118.00114, 34.14832], [-118.00114, 34.1483], [-118.00111, 34.1483], [-118.00111, 34.14816], [-118.00306, 34.14813], [-118.00306, 34.14857]]], [[[-118.00308, 34.14906], [-118.00113, 34.14908], [-118.00111, 34.14863], [-118.00306, 34.14862], [-118.00308, 34.14906]]]]} | Open Access 1 | 6984 | Monrovia Library Park | 22376 | 1209 | Monrovia, City of 312 | City 2 | City Agency 2 | http://www.cityofmonrovia.org/publicworks/page/parks | City 2 | 1209 | Monrovia, City of 309 | City 2 | City Agency 2 | Los Angeles 6 | 4.375 | Monrovia Library Park | 0 | Local Park 2 | 4 | |
1217 | 1217 | 1216 | {"type": "Polygon", "coordinates": [[[-118.35173, 34.0933], [-118.35164, 34.09346], [-118.35164, 34.09393], [-118.35064, 34.09391], [-118.35063, 34.09304], [-118.35019, 34.09303], [-118.35019, 34.09276], [-118.35063, 34.09275], [-118.35062, 34.09086], [-118.35126, 34.09086], [-118.35125, 34.09183], [-118.35135, 34.09184], [-118.35136, 34.09223], [-118.35173, 34.09224], [-118.35173, 34.0933]]]} | Open Access 1 | 8660 | Plummer Park | 23817 | 1375 | West Hollywood, City of 334 | City 2 | City Agency 2 | http://www.weho.org/residents/recreation-services/parks-and-facilities | City 2 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | Los Angeles 6 | 7.175 | Plummer Park | 0 | Local Park 2 | 4 | |
1218 | 1218 | 1217 | {"type": "MultiPolygon", "coordinates": [[[[-122.1451, 37.64851], [-122.14511, 37.64897], [-122.14509, 37.64903], [-122.14501, 37.64917], [-122.14486, 37.64934], [-122.14456, 37.64957], [-122.14429, 37.64973], [-122.14412, 37.64979], [-122.14409, 37.64745], [-122.14507, 37.64744], [-122.1451, 37.64851]]], [[[-122.14586, 37.6471], [-122.14517, 37.64711], [-122.14517, 37.64682], [-122.14586, 37.64682], [-122.14586, 37.6471]]]]} | Open Access 1 | 8671 | Hayward Shoreline | 19762 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 5.421 | Hayward Shoreline | 1977 | Local Park 2 | 4 | |
1219 | 1219 | 1218 | {"type": "Polygon", "coordinates": [[[-117.94405, 34.14347], [-117.94338, 34.14347], [-117.94338, 34.14238], [-117.94351, 34.14234], [-117.94372, 34.14233], [-117.94385, 34.14235], [-117.94404, 34.1424], [-117.94405, 34.14347]]]} | Open Access 1 | 6997 | Hacienda Park | 19587 | 1089 | Duarte, City of 328 | City 2 | City Agency 2 | http://www.accessduarte.com/index.php?option=com_content&view=article&id=62&Itemid=72 | City 2 | 1089 | Duarte, City of 325 | City 2 | City Agency 2 | Los Angeles 6 | 1.876 | Hacienda Park | 0 | Local Park 2 | 4 | |
1220 | 1220 | 1219 | {"type": "Polygon", "coordinates": [[[-117.26783, 33.92058], [-117.26764, 33.92058], [-117.26747, 33.92053], [-117.26684, 33.92026], [-117.26704, 33.91989], [-117.26709, 33.91976], [-117.26711, 33.91964], [-117.26711, 33.91952], [-117.26708, 33.9194], [-117.26683, 33.91877], [-117.26682, 33.91847], [-117.26684, 33.91845], [-117.26782, 33.91847], [-117.26783, 33.92058]]]} | Open Access 1 | 8693 | Adrienne Mitchell Memorial Park | 15276 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 4.412 | Adrienne Mitchell Memorial Park | 0 | Local Park 2 | 4 | |
1221 | 1221 | 1220 | {"type": "Polygon", "coordinates": [[[-118.12522, 34.12104], [-118.12514, 34.12114], [-118.12504, 34.12134], [-118.12499, 34.12137], [-118.12479, 34.12136], [-118.12377, 34.12137], [-118.12355, 34.1214], [-118.1231, 34.12151], [-118.12294, 34.12153], [-118.12268, 34.12153], [-118.122, 34.12143], [-118.12171, 34.12143], [-118.12128, 34.12151], [-118.12098, 34.12152], [-118.12075, 34.12147], [-118.12061, 34.12142], [-118.12048, 34.12136], [-118.12031, 34.12123], [-118.12022, 34.12113], [-118.11961, 34.12024], [-118.12013, 34.11999], [-118.12074, 34.11944], [-118.12105, 34.11929], [-118.12166, 34.11902], [-118.12242, 34.11883], [-118.12322, 34.11865], [-118.12353, 34.1191], [-118.12411, 34.11884], [-118.12427, 34.11908], [-118.12369, 34.11935], [-118.12415, 34.12005], [-118.12464, 34.11954], [-118.12485, 34.11972], [-118.12486, 34.11974], [-118.12433, 34.12031], [-118.12443, 34.12047], [-118.12522, 34.12104]]]} | Open Access 1 | 7003 | Lacy Park | 20819 | 1309 | San Marino, City of 335 | City 2 | City Agency 2 | http://www.cityofsanmarino.org/275/Parks | City 2 | 1309 | San Marino, City of 332 | City 2 | City Agency 2 | Los Angeles 6 | 26.652 | Lacy 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]);