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)
MNG_AG_TYP >30
- City Agency 5,393
- Recreation/Parks District 752
- State Agency 749
- County Agency 632
- Federal Agency 302
- Non Profit - Land Trust 301
- Open Space District 199
- Community Services District 153
- Home Owners Association 144
- Water District 143
- County Agency - Parks 142
- Non Profit - Conservation 92
- Flood District 67
- Irrigation District 30
- School District 29
- Non Profit - Other 22
- Cemetery District 14
- County Agency - Other 12
- Port/Harbor District 11
- Special District - Other 11
- Commercial 9
- Joint Powers Authority 7
- Sanitation District 5
- Other 5
- Transportation Agency 5
- Conservation District 4
- Non Profit - Education 3
- Mitigation Bank 2
- Metropolitan Planning Organization 1
- Home Owners Associatin 1
- …
MNG_AGENCY >30
- California Department of Fish and Wildlife 283
- California Department of Parks and Recreation 280
- San Diego, City of 220
- Los Angeles, City of 185
- Sacramento, City of 145
- Mountains Recreation and Conservation Authority 136
- San Jose, City of 133
- East Bay Regional Park District 129
- Ventura, City of 113
- Roseville, City of 97
- Consumnes Community Services District 86
- Los Angeles, County of 81
- Oakland, City of 79
- San Francisco, City and County of 70
- United States Fish and Wildlife Service 67
- California State Lands Commission 67
- United States Bureau of Land Management 66
- Long Beach, City of 63
- United States Forest Service 61
- Orange, County of 61
- Irvine, City of 61
- Napa, City of 59
- Davis, City of 57
- Hayward Area Recreation and Park District 57
- Stockton, City of 56
- Santa Barbara, County of 49
- United States National Park Service 49
- Poway, City of 49
- Modesto, City of 48
- Tracy, City of 46
- …
DES_TP >30
- Local Park 4,631
- Local Recreation Area 1,222
- Local Other or Unknown 745
- Private Conservation 348
- Local Conservation Area 279
- State Conservation Area 271
- Private Recreation or Education 174
- State Park 161
- State Resource Management Area 100
- State Recreation Area 98
- National Wildlife Refuge 61
- National Forest 56
- State Historic or Cultural Area 51
- National Public Lands 41
- Local Historic or Cultural Area 37
- Recreation Management Area 33
- National Monument or Landmark 25
- National Recreation Area 23
- State Other or Unknown 20
- National Park 15
- Local Resource Management Area 13
- Federal Other or Unknown 13
- Resource Management Area 10
- Conservation Area 9
- Private Agricultural 9
- Private Other or Unknown 9
- Area of Critical Environmental Concern 5
- Historic or Cultural Area 4
- Wilderness Area 2
- Research or Educational Area 1
- …
ACCESS_TYP 4
- Open Access 7,750
- Restricted Access 749
- No Public Access 555
- Unknown 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7828 | 7828 | 7827 | {"type": "Polygon", "coordinates": [[[-119.71474, 36.32481], [-119.71447, 36.32482], [-119.71291, 36.32308], [-119.7091, 36.3231], [-119.70911, 36.3207], [-119.71061, 36.3207], [-119.71062, 36.32069], [-119.70911, 36.31921], [-119.70919, 36.31883], [-119.7097, 36.31935], [-119.71109, 36.31934], [-119.7111, 36.31884], [-119.71159, 36.31884], [-119.71156, 36.32113], [-119.71151, 36.32118], [-119.71408, 36.32382], [-119.7146, 36.32439], [-119.71435, 36.3244], [-119.71474, 36.32481]]]} | Open Access 1 | 9397 | Armona Recreation Park | 15593 | 2279 | Aromona Community Services District 880 | Special District 4 | Community Services District 19 | Special District 4 | 2279 | Aromona Community Services District 856 | Special District 4 | Community Services District 17 | Kings 44 | 26.885 | Armona Rec. Park | 0 | Local Recreation Area 3 | 4 | ||
7829 | 7829 | 7828 | {"type": "Polygon", "coordinates": [[[-122.50267, 37.76171], [-122.50184, 37.76175], [-122.50179, 37.76106], [-122.50262, 37.76102], [-122.50267, 37.76171]]]} | Open Access 1 | 47708 | Playland at 43rd Avenue | 31457 | 2414 | San Francisco Unified School District 881 | Special District 4 | School District 14 | http://www.sfusd.edu/ | Special District 4 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.382 | Playland at 43rd Avenue | 2016 | None 654 | ||
7830 | 7830 | 7829 | {"type": "Polygon", "coordinates": [[[-117.05962, 32.93512], [-117.05625, 32.93698], [-117.05427, 32.93557], [-117.05391, 32.93515], [-117.05962, 32.93512]]]} | Open Access 1 | 35850 | Poway holding 11 | 23934 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 13.923 | Poway holding 11 | 0 | Local Other or Unknown 14 | 4 | |
7831 | 7831 | 7830 | {"type": "Polygon", "coordinates": [[[-122.51046, 37.51201], [-122.51023, 37.51234], [-122.50987, 37.51294], [-122.50983, 37.51292], [-122.50706, 37.51697], [-122.50076, 37.5116], [-122.50136, 37.51061], [-122.50087, 37.51021], [-122.50163, 37.50897], [-122.50091, 37.50795], [-122.50104, 37.50785], [-122.50038, 37.50695], [-122.50001, 37.50719], [-122.49898, 37.50631], [-122.49883, 37.50653], [-122.49817, 37.50681], [-122.49557, 37.50574], [-122.4949, 37.50607], [-122.49505, 37.50582], [-122.49492, 37.50576], [-122.4946, 37.5047], [-122.494, 37.5042], [-122.49436, 37.5036], [-122.49452, 37.50365], [-122.49471, 37.50331], [-122.49457, 37.50324], [-122.49472, 37.50299], [-122.49465, 37.50191], [-122.49398, 37.50143], [-122.49432, 37.50124], [-122.49578, 37.50023], [-122.49585, 37.50037], [-122.49593, 37.50051], [-122.49634, 37.50095], [-122.49652, 37.50132], [-122.49654, 37.50142], [-122.49664, 37.50204], [-122.49673, 37.50251], [-122.49673, 37.50345], [-122.4967, 37.5036], [-122.49666, 37.50368], [-122.49674, 37.50378], [-122.49841, 37.50458], [-122.49871, 37.50239], [-122.49742, 37.50097], [-122.4972, 37.49987], [-122.4983, 37.49966], [-122.49979, 37.49844], [-122.49984, 37.49849], [-122.49978, 37.49862], [-122.49996, 37.49876], [-122.50002, 37.49897], [-122.49996, 37.49897], [-122.49914, 37.49951], [-122.49909, 37.4997], [-122.49903, 37.50002], [-122.49892, 37.50017], [-122.49884, 37.50042], [-122.49887, 37.50077], [-122.49902, 37.50115], [-122.49912, 37.50132], [-122.49954, 37.50174], [-122.49966, 37.50174], [-122.49981, 37.50193], [-122.49974, 37.50204], [-122.49974, 37.50223], [-122.49983, 37.50247], [-122.50002, 37.50288], [-122.50028, 37.50332], [-122.50044, 37.50343], [-122.50067, 37.50356], [-122.5011, 37.50398], [-122.50167, 37.50469], [-122.5019, 37.50487], [-122.50202, 37.50501], [-122.50209, 37.50507], [-122.50219, 37.50512], [-122.50229, 37.50513], [-122.50238, 37.50519], [-122.50258, 37.50522], [-122.50271, 37.50536], [-122.5029, 37.50543], [-122.50306, 37.50554], [-122.50325, 37.50562], [-122.50351, 37.50578], [-122.50374, 37.50595], [-122.50383, 37.506], [-122.50403, 37.50606], [-122.50419, 37.50617], [-122.5043, 37.50616], [-122.50462, 37.5062], [-122.50481, 37.50628], [-122.50487, 37.50634], [-122.50492, 37.50641], [-122.50515, 37.5066], [-122.50542, 37.50688], [-122.5056, 37.50697], [-122.50566, 37.50704], [-122.50581, 37.50716], [-122.50591, 37.50731], [-122.50598, 37.50738], [-122.5061, 37.50752], [-122.50625, 37.50776], [-122.50632, 37.50783], [-122.50638, 37.508], [-122.50646, 37.50806], [-122.50657, 37.5082], [-122.50664, 37.50827], [-122.50674, 37.50843], [-122.50687, 37.50857], [-122.507, 37.5088], [-122.50738, 37.50922], [-122.50761, 37.5094], [-122.5077, 37.50956], [-122.5078, 37.50965], [-122.50804, 37.50923], [-122.50827, 37.50949], [-122.5092, 37.51101], [-122.51046, 37.51201]], [[-122.49897, 37.5063], [-122.49912, 37.50606], [-122.49883, 37.50595], [-122.49869, 37.50619], [-122.49897, 37.5063]]]} | Open Access 1 | 9314 | Pillar Point Bluff | 23670 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 226.452 | Pillar Point Bluff | None 655 | |||
7832 | 7832 | 7831 | {"type": "Polygon", "coordinates": [[[-117.56449, 34.10877], [-117.56445, 34.10893], [-117.56447, 34.10923], [-117.56442, 34.10942], [-117.56436, 34.10943], [-117.56436, 34.10957], [-117.56384, 34.10954], [-117.56375, 34.10981], [-117.56294, 34.10965], [-117.56266, 34.10962], [-117.56257, 34.10986], [-117.56219, 34.11032], [-117.56197, 34.11016], [-117.5618, 34.10996], [-117.56169, 34.10978], [-117.56161, 34.10957], [-117.56157, 34.10937], [-117.56157, 34.10877], [-117.56158, 34.10874], [-117.56162, 34.10872], [-117.56234, 34.10868], [-117.56235, 34.10866], [-117.56326, 34.10866], [-117.56395, 34.1087], [-117.56449, 34.10877]]]} | Open Access 1 | 9315 | Ralph M. Lewis Park | 24102 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 8.007 | Ralph M. Lewis Park | 0 | Local Park 2 | 4 | |
7833 | 7833 | 7832 | {"type": "Polygon", "coordinates": [[[-118.79535, 34.03826], [-118.79477, 34.03824], [-118.79477, 34.03957], [-118.79361, 34.03957], [-118.7936, 34.03837], [-118.79107, 34.0391], [-118.79255, 34.03838], [-118.79212, 34.0374], [-118.79008, 34.03869], [-118.79052, 34.03807], [-118.7899, 34.03768], [-118.79316, 34.03568], [-118.79317, 34.03571], [-118.7931, 34.03572], [-118.79308, 34.03578], [-118.79312, 34.03582], [-118.7932, 34.03581], [-118.79331, 34.03629], [-118.79429, 34.03684], [-118.79448, 34.03785], [-118.79535, 34.03826]]]} | Open Access 1 | 9327 | Ramirez Canyon Park | 24108 | 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 | 21.794 | Ramirez Canyon Park | 0 | Local Park 2 | 4 | |
7834 | 7834 | 7833 | {"type": "Polygon", "coordinates": [[[-117.77094, 33.74041], [-117.77055, 33.74081], [-117.77019, 33.74055], [-117.77005, 33.74048], [-117.77001, 33.74041], [-117.77015, 33.7402], [-117.77037, 33.73998], [-117.77093, 33.74037], [-117.77094, 33.74041]]]} | Open Access 1 | 12279 | Comstock Park | 17573 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 1.03 | Comstock Park | 0 | Local Park 2 | 4 | |
7835 | 7835 | 7834 | {"type": "Polygon", "coordinates": [[[-122.05746, 37.62338], [-122.05725, 37.62354], [-122.05718, 37.62354], [-122.05709, 37.62357], [-122.05704, 37.62365], [-122.0566, 37.62401], [-122.05605, 37.62357], [-122.0562, 37.62344], [-122.0556, 37.62297], [-122.05627, 37.62243], [-122.05718, 37.62315], [-122.05716, 37.62319], [-122.05736, 37.62334], [-122.05739, 37.62332], [-122.05746, 37.62338]]]} | Open Access 1 | 47703 | Silver Star Veterans Park | 31448 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.309 | Silver Star Veterans Park | 0 | Local Park 2 | 4 | |
7836 | 7836 | 7835 | {"type": "Polygon", "coordinates": [[[-122.07255, 37.69448], [-122.07245, 37.69479], [-122.07246, 37.69486], [-122.07249, 37.69495], [-122.07248, 37.69502], [-122.07212, 37.6949], [-122.07228, 37.69459], [-122.07203, 37.6945], [-122.07231, 37.69398], [-122.0723, 37.69395], [-122.07227, 37.69395], [-122.07224, 37.69382], [-122.07182, 37.69362], [-122.07168, 37.69362], [-122.07161, 37.69348], [-122.0716, 37.69294], [-122.07155, 37.69271], [-122.0719, 37.6927], [-122.0719, 37.69293], [-122.07177, 37.69294], [-122.07182, 37.69357], [-122.07188, 37.69362], [-122.07198, 37.69362], [-122.07226, 37.69375], [-122.07231, 37.69386], [-122.0724, 37.69394], [-122.07245, 37.69423], [-122.07255, 37.69448]]]} | Open Access 1 | 47704 | Castro Valley Creek Park | 31450 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.308 | Castro Valley Creek Park | 0 | Local Park 2 | 4 | |
7837 | 7837 | 7836 | {"type": "Polygon", "coordinates": [[[-122.03138, 37.67539], [-122.03177, 37.67601], [-122.03184, 37.67616], [-122.03207, 37.67648], [-122.03214, 37.67663], [-122.03216, 37.67677], [-122.0321, 37.67712], [-122.0312, 37.67848], [-122.03059, 37.67809], [-122.03035, 37.67797], [-122.03, 37.67773], [-122.02986, 37.67762], [-122.02967, 37.67737], [-122.02951, 37.67703], [-122.02949, 37.67667], [-122.02955, 37.6764], [-122.02964, 37.67619], [-122.02975, 37.676], [-122.03016, 37.67566], [-122.03045, 37.67553], [-122.03072, 37.67544], [-122.03097, 37.6754], [-122.03138, 37.67539]]]} | Open Access 1 | 47705 | Five Canyons Park | 31454 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/Facilities/Facility/Details/Five-Canyons-Park-127 | Alameda 17 | 13.452 | Five Canyons Park | 0 | Local Park 2 | 4 |
7838 | 7838 | 7837 | {"type": "Polygon", "coordinates": [[[-122.11632, 37.69538], [-122.11631, 37.69594], [-122.11596, 37.69624], [-122.11544, 37.69587], [-122.11561, 37.69571], [-122.1157, 37.69577], [-122.11618, 37.69535], [-122.11623, 37.69538], [-122.11632, 37.69538]]]} | Open Access 1 | 47706 | Jack Holland Sr. Park | 31455 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/Facilities/Facility/Details/Jack-Holland-Sr-Park-129 | Alameda 17 | 1.0 | Jack Holland Sr. Park | 0 | Local Park 2 | 4 |
7839 | 7839 | 7838 | {"type": "Polygon", "coordinates": [[[-118.10917, 33.89261], [-118.10876, 33.89261], [-118.10872, 33.89076], [-118.10871, 33.88801], [-118.10912, 33.88804], [-118.10917, 33.89261]]]} | Open Access 1 | 44929 | Riverview Park | 24462 | 1024 | Bellflower, City of 449 | City 2 | City Agency 2 | https://www.bellflower.org/home/index.asp?page=132 | City 2 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 4.88 | Riverview Park | 0 | Local Park 2 | 4 | |
7840 | 7840 | 7839 | {"type": "Polygon", "coordinates": [[[-120.31439, 39.32589], [-120.30989, 39.32587], [-120.30989, 39.32587], [-120.3099, 39.32575], [-120.31057, 39.32566], [-120.31114, 39.3258], [-120.31114, 39.32582], [-120.31118, 39.32583], [-120.31147, 39.32585], [-120.31172, 39.32584], [-120.31196, 39.32579], [-120.31214, 39.32573], [-120.31231, 39.32565], [-120.31253, 39.3255], [-120.31271, 39.32531], [-120.31278, 39.32519], [-120.31276, 39.32517], [-120.31284, 39.32496], [-120.31289, 39.32477], [-120.31291, 39.32449], [-120.31283, 39.32391], [-120.31283, 39.32376], [-120.31286, 39.3236], [-120.31293, 39.32342], [-120.31302, 39.32328], [-120.3132, 39.32309], [-120.31345, 39.32296], [-120.31387, 39.32282], [-120.31401, 39.32274], [-120.31418, 39.3226], [-120.31432, 39.3224], [-120.31439, 39.32589]]]} | Open Access 1 | 48983 | Black Wall | 33678 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.truckeedonnerlandtrust.org/ | Nevada 30 | 11.753 | Black Wall | 0 | Private Conservation 16 | 2 |
7841 | 7841 | 7840 | {"type": "Polygon", "coordinates": [[[-116.95835, 32.58995], [-116.95155, 32.59194], [-116.94918, 32.59009], [-116.947, 32.58786], [-116.94582, 32.58582], [-116.94542, 32.58527], [-116.94808, 32.58424], [-116.94748, 32.58333], [-116.94716, 32.58293], [-116.94705, 32.58296], [-116.94672, 32.58291], [-116.94635, 32.58283], [-116.94603, 32.58271], [-116.94582, 32.58248], [-116.9458, 32.58217], [-116.94581, 32.58211], [-116.94962, 32.58217], [-116.95013, 32.5831], [-116.95155, 32.5844], [-116.95157, 32.58584], [-116.9523, 32.58586], [-116.95595, 32.58857], [-116.95639, 32.58888], [-116.95835, 32.58995]]]} | No Public Access 3 | 47716 | Otay Valley Regional Park | 31498 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.sdparks.org/content/sdparks/en/park-pages/OVRP.html | San Diego 4 | 146.674 | Otay Valley RP | None 656 | ||
7842 | 7842 | 7841 | {"type": "MultiPolygon", "coordinates": [[[[-117.56281, 34.1216], [-117.56283, 34.12193], [-117.56279, 34.12211], [-117.56269, 34.1223], [-117.56263, 34.1225], [-117.56259, 34.12278], [-117.56252, 34.12304], [-117.56237, 34.12323], [-117.56219, 34.12338], [-117.56211, 34.12352], [-117.56203, 34.1237], [-117.56198, 34.12388], [-117.56185, 34.12404], [-117.56168, 34.12419], [-117.56152, 34.1243], [-117.56122, 34.12437], [-117.56085, 34.12438], [-117.5605, 34.12442], [-117.5601, 34.12451], [-117.55978, 34.12461], [-117.55959, 34.1247], [-117.5594, 34.12471], [-117.55924, 34.12466], [-117.55858, 34.12465], [-117.55858, 34.1216], [-117.56281, 34.1216]]], [[[-117.57053, 34.12177], [-117.56857, 34.12529], [-117.55858, 34.12512], [-117.55858, 34.12485], [-117.55924, 34.12484], [-117.5594, 34.12479], [-117.55955, 34.12478], [-117.55994, 34.12463], [-117.56027, 34.12453], [-117.5606, 34.12447], [-117.56086, 34.12445], [-117.56107, 34.12445], [-117.5613, 34.12443], [-117.56155, 34.12435], [-117.56176, 34.12424], [-117.5619, 34.12411], [-117.56204, 34.12393], [-117.56217, 34.12359], [-117.56227, 34.12344], [-117.56243, 34.12326], [-117.56258, 34.12306], [-117.56267, 34.12283], [-117.56272, 34.12247], [-117.56279, 34.12228], [-117.56289, 34.1221], [-117.56305, 34.12193], [-117.56305, 34.12161], [-117.57045, 34.12161], [-117.57046, 34.12166], [-117.57053, 34.12177]]]]} | Open Access 1 | 9411 | Central Park | 17056 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 98.798 | Central Park | 0 | Local Park 2 | 4 | |
7843 | 7843 | 7842 | {"type": "Polygon", "coordinates": [[[-121.614, 37.79798], [-121.61399, 37.79871], [-121.61178, 37.80234], [-121.60506, 37.80232], [-121.60511, 37.79512], [-121.60597, 37.79516], [-121.60635, 37.79514], [-121.60669, 37.7951], [-121.60709, 37.79511], [-121.6071, 37.79502], [-121.61204, 37.79505], [-121.614, 37.79798]]]} | No Public Access 3 | 9433 | Byron Conservation Bank | 32076 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Alameda 17 | 139.979 | Byron Conservation Bank | 0 | State Resource Management Area 55 | 3 | |
7844 | 7844 | 7843 | {"type": "Polygon", "coordinates": [[[-117.69628, 33.65981], [-117.69568, 33.66048], [-117.69348, 33.66067], [-117.69341, 33.65989], [-117.69537, 33.65978], [-117.69538, 33.65943], [-117.69552, 33.65942], [-117.69558, 33.65938], [-117.69563, 33.65926], [-117.69628, 33.65981]]]} | Open Access 1 | 9434 | Rancho Serrano Park | 24176 | 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 | 5.454 | Rancho Serrano Park | 0 | Local Park 2 | 4 | |
7845 | 7845 | 7844 | {"type": "Polygon", "coordinates": [[[-117.36351, 34.00678], [-117.36336, 34.00838], [-117.362, 34.01018], [-117.35971, 34.01331], [-117.35887, 34.0143], [-117.35658, 34.01406], [-117.35175, 34.01332], [-117.35243, 34.01217], [-117.35253, 34.01193], [-117.35277, 34.01117], [-117.35321, 34.01016], [-117.35385, 34.00916], [-117.35449, 34.00853], [-117.35588, 34.0073], [-117.35792, 34.00425], [-117.35802, 34.00423], [-117.36351, 34.00678]]]} | Open Access 1 | 9734 | Reid Park | 24279 | 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 | 172.703 | Reid Park | 0 | Local Park 2 | 4 | |
7846 | 7846 | 7845 | {"type": "Polygon", "coordinates": [[[-117.15919, 33.00094], [-117.15671, 33.00189], [-117.15677, 33.00261], [-117.15655, 33.00257], [-117.15662, 33.0025], [-117.15669, 33.00233], [-117.15669, 33.00219], [-117.15663, 33.00202], [-117.15653, 33.00191], [-117.1564, 33.00183], [-117.15595, 33.00167], [-117.15606, 33.00153], [-117.15628, 33.00141], [-117.15596, 33.00098], [-117.15599, 33.00093], [-117.15656, 33.00087], [-117.1567, 33.00079], [-117.15677, 33.00073], [-117.15683, 33.00065], [-117.15687, 33.00053], [-117.15687, 33.00043], [-117.15684, 33.00033], [-117.15676, 33.0002], [-117.15689, 33.00002], [-117.15693, 32.99987], [-117.15698, 32.99954], [-117.15702, 32.99947], [-117.15723, 32.9993], [-117.15729, 32.99918], [-117.15732, 32.99909], [-117.15809, 32.99871], [-117.15825, 32.99891], [-117.15839, 32.99912], [-117.1585, 32.99935], [-117.15919, 33.00094]]]} | Open Access 1 | 9590 | Black Mountain Open Space Park | 10257 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml | San Diego 4 | 14.063 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 4 |
7847 | 7847 | 7846 | {"type": "Polygon", "coordinates": [[[-117.15681, 33.0032], [-117.15678, 33.00321], [-117.15678, 33.00317], [-117.15673, 33.00305], [-117.15662, 33.00291], [-117.15655, 33.00286], [-117.1565, 33.00276], [-117.15678, 33.00276], [-117.15681, 33.0032]]]} | Open Access 1 | 9594 | Black Mountain Open Space Park | 10257 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml | San Diego 4 | 0.148 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 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]);