units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by COUNTY
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 9,089
- Recreation/Parks District 1,161
- State Agency 1,076
- County Agency 1,048
- Non Profit - Land Trust 579
- Federal Agency 497
- Open Space District 428
- County Agency - Parks 236
- Water District 234
- Community Services District 193
- Non Profit - Conservation 138
- Flood District 107
- Cemetery District 60
- Home Owners Association 55
- Irrigation District 46
- Non Profit - Other 45
- School District 38
- County Agency - Other 34
- Port/Harbor District 26
- Special District - Other 15
- Commercial 14
- Sanitation District 9
- Joint Powers Authority 8
- 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
- Los Angeles, City of 491
- San Diego, City of 457
- California Department of Fish and Wildlife 422
- Mountains Recreation and Conservation Authority 351
- California Department of Parks and Recreation 346
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 220
- Los Angeles, County of 175
- East Bay Regional Park District 167
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- Oakland, City of 122
- Santa Barbara, County of 119
- United States Bureau of Land Management 113
- United States Forest Service 109
- San Diego, County of 102
- Fresno, City of 95
- Consumnes Community Services District 94
- United States National Park Service 89
- California State Lands Commission 85
- Hayward Area Recreation and Park District 84
- Santa Rosa, City of 83
- Stockton, City of 81
- Napa, City of 81
- United States Fish and Wildlife Service 79
- Torrance, City of 73
- Tracy, City of 73
- Santa Cruz, City of 72
- …
DES_TP >30
- Local Park 8,121
- Local Recreation Area 1,816
- Local Other or Unknown 1,100
- Private Conservation 598
- Local Conservation Area 446
- State Conservation Area 361
- State Park 179
- State Resource Management Area 154
- State Recreation Area 141
- Private Recreation or Education 123
- Local Historic or Cultural Area 107
- National Forest 97
- National Public Lands 72
- National Wildlife Refuge 71
- State Other or Unknown 69
- State Historic or Cultural Area 62
- Recreation Management Area 56
- Private Other or Unknown 50
- National Recreation Area 40
- National Monument or Landmark 36
- National Park 26
- Resource Management Area 26
- Local Resource Management Area 24
- Federal Other or Unknown 24
- Conservation Area 14
- Private Agricultural 12
- Wilderness Area 7
- Historic or Cultural Area 5
- Area of Critical Environmental Concern 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 12,846
- Restricted Access 998
- No Public Access 945
- Unknown Access 381
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2741 | 2741 | 2740 | {"type": "Polygon", "coordinates": [[[-117.14983, 32.80583], [-117.14965, 32.80592], [-117.14703, 32.80654], [-117.14601, 32.80681], [-117.14593, 32.80695], [-117.14584, 32.80702], [-117.14523, 32.80722], [-117.14464, 32.80723], [-117.14458, 32.80727], [-117.14457, 32.80722], [-117.14459, 32.8071], [-117.14518, 32.8071], [-117.14575, 32.80693], [-117.14612, 32.80616], [-117.14612, 32.80497], [-117.14743, 32.80496], [-117.1476, 32.80493], [-117.14782, 32.80485], [-117.1497, 32.80486], [-117.14967, 32.80509], [-117.14968, 32.80532], [-117.14972, 32.80558], [-117.14983, 32.80583]]]} | Open Access 1 | 18406 | Cabrillo Heights Park | 16637 | 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 | San Diego 4 | 13.899 | Cabrillo Heights Park | 0 | Local Park 2 | 4 | |
2743 | 2743 | 2742 | {"type": "Polygon", "coordinates": [[[-117.16413, 32.82077], [-117.16178, 32.81938], [-117.16153, 32.81917], [-117.16141, 32.81905], [-117.16112, 32.81867], [-117.1609, 32.81828], [-117.16108, 32.8182], [-117.16112, 32.81812], [-117.16185, 32.81782], [-117.16189, 32.81782], [-117.16193, 32.81783], [-117.16263, 32.81834], [-117.16288, 32.81861], [-117.16311, 32.81895], [-117.16319, 32.81916], [-117.16325, 32.81935], [-117.16327, 32.81951], [-117.16329, 32.82026], [-117.16379, 32.82027], [-117.16413, 32.82077]]]} | Open Access 1 | 18420 | Lindbergh Neighborhood Park | 30093 | 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 | San Diego 4 | 7.96 | Lindbergh Neighborhood Park | 0 | Local Park 2 | 4 | |
2754 | 2754 | 2753 | {"type": "Polygon", "coordinates": [[[-117.24499, 32.80093], [-117.24419, 32.8011], [-117.24283, 32.80145], [-117.24267, 32.80102], [-117.24251, 32.80051], [-117.24472, 32.80004], [-117.24499, 32.80093]]]} | Restricted Access 2 | 18441 | Pacific Beach Community Park | 33345 | 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 | San Diego 4 | 5.466 | Pacific Beach Community Park | 0 | Local Park 2 | 4 | |
2760 | 2760 | 2759 | {"type": "Polygon", "coordinates": [[[-117.18439, 32.80319], [-117.18381, 32.80474], [-117.18375, 32.80478], [-117.18357, 32.80474], [-117.18342, 32.80474], [-117.18327, 32.80477], [-117.18314, 32.80482], [-117.18281, 32.80473], [-117.18214, 32.80285], [-117.18401, 32.80233], [-117.18402, 32.80309], [-117.18439, 32.80319]]]} | Open Access 1 | 18457 | East Clairemont Athletic Area | 18365 | 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 | San Diego 4 | 9.192 | East Clairemont Athletic Area | 0 | Local Recreation Area 3 | 4 | |
2764 | 2764 | 2763 | {"type": "Polygon", "coordinates": [[[-117.24414, 32.86664], [-117.24413, 32.8688], [-117.24266, 32.86878], [-117.24315, 32.86665], [-117.24414, 32.86664]]]} | Open Access 1 | 18467 | La Jolla Athletic Area - Allen Field | 30078 | 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 | San Diego 4 | 6.779 | La Jolla Athletic Area - Allen Field | 0 | Local Recreation Area 3 | 4 | |
2770 | 2770 | 2769 | {"type": "Polygon", "coordinates": [[[-117.28011, 32.82509], [-117.28009, 32.82536], [-117.28002, 32.82566], [-117.27999, 32.82612], [-117.27954, 32.82622], [-117.27953, 32.82616], [-117.27953, 32.82584], [-117.27996, 32.82511], [-117.28011, 32.82509]]]} | Open Access 1 | 18505 | Hermosa Terrace Park | 30053 | 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 | San Diego 4 | 0.993 | Hermosa Terrace Park | 0 | Local Park 2 | 4 | |
2777 | 2777 | 2776 | {"type": "Polygon", "coordinates": [[[-117.24598, 32.85902], [-117.24599, 32.85969], [-117.24598, 32.85977], [-117.24591, 32.85992], [-117.24578, 32.86005], [-117.24495, 32.86044], [-117.24472, 32.86048], [-117.24414, 32.86051], [-117.24598, 32.85902]]]} | Open Access 1 | 18516 | La Jolla Open Space | 20766 | 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 | San Diego 4 | 2.612 | La Jolla OS | 0 | Local Recreation Area 3 | 4 | |
2778 | 2778 | 2777 | {"type": "Polygon", "coordinates": [[[-117.04655, 32.98981], [-117.04644, 32.99002], [-117.04624, 32.98988], [-117.04549, 32.99], [-117.04438, 32.98961], [-117.04432, 32.98956], [-117.04366, 32.98955], [-117.04282, 32.99048], [-117.04281, 32.99102], [-117.04207, 32.99065], [-117.04173, 32.99079], [-117.04172, 32.99156], [-117.04071, 32.99164], [-117.04067, 32.98935], [-117.04001, 32.98937], [-117.03979, 32.9893], [-117.03874, 32.9893], [-117.03872, 32.98932], [-117.0387, 32.98932], [-117.03452, 32.98928], [-117.03447, 32.98902], [-117.03441, 32.98896], [-117.03432, 32.98895], [-117.03425, 32.98881], [-117.03424, 32.98875], [-117.03456, 32.98881], [-117.03497, 32.98871], [-117.03501, 32.9882], [-117.03501, 32.98798], [-117.0346, 32.98742], [-117.03455, 32.98719], [-117.03413, 32.98665], [-117.03405, 32.9862], [-117.03378, 32.98578], [-117.03374, 32.98563], [-117.03632, 32.98566], [-117.03637, 32.9884], [-117.04066, 32.98844], [-117.04062, 32.98567], [-117.04493, 32.98579], [-117.04494, 32.98939], [-117.04639, 32.98941], [-117.04636, 32.98975], [-117.04655, 32.98981]]]} | Open Access 1 | 18531 | Twin Peaks Open Space | 26620 | 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 | http://powaytrails.com/trails/TwinPeaksTrail/ | San Diego 4 | 81.613 | Twin Peaks OS | 0 | Local Recreation Area 3 | 4 |
2780 | 2780 | 2779 | {"type": "MultiPolygon", "coordinates": [[[[-116.97064, 32.98874], [-116.97048, 32.99571], [-116.97003, 32.99569], [-116.96974, 32.9957], [-116.96935, 32.99576], [-116.96907, 32.99583], [-116.96869, 32.99598], [-116.96747, 32.99662], [-116.96603, 32.99716], [-116.96572, 32.99726], [-116.96537, 32.99735], [-116.965, 32.99742], [-116.9641, 32.99752], [-116.96409, 32.99739], [-116.96193, 32.99737], [-116.96202, 32.99245], [-116.95777, 32.99241], [-116.95776, 32.9887], [-116.96204, 32.98869], [-116.97064, 32.98874]]], [[[-116.97043, 32.99718], [-116.97037, 33.00014], [-116.96611, 33.0001], [-116.96618, 32.99841], [-116.96646, 32.99827], [-116.968, 32.99778], [-116.96936, 32.99733], [-116.97043, 32.99718]]]]} | Open Access 1 | 18539 | Rock Haven Spring Open Space | 24509 | 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 | 244.004 | Rock Haven Spring OS | 0 | Local Recreation Area 3 | 4 | |
2787 | 2787 | 2786 | {"type": "MultiPolygon", "coordinates": [[[[-117.1655, 32.74559], [-117.1651, 32.7456], [-117.16509, 32.74433], [-117.1655, 32.74432], [-117.1655, 32.74559]]], [[[-117.16661, 32.74404], [-117.1661, 32.74404], [-117.16611, 32.74459], [-117.16556, 32.7446], [-117.16555, 32.74405], [-117.16556, 32.74392], [-117.16661, 32.7439], [-117.16661, 32.74404]]], [[[-117.16849, 32.74062], [-117.16808, 32.74063], [-117.16809, 32.74086], [-117.16797, 32.74096], [-117.16759, 32.74142], [-117.16751, 32.74153], [-117.16669, 32.74154], [-117.16668, 32.74105], [-117.16763, 32.74103], [-117.16764, 32.74064], [-117.16763, 32.74022], [-117.16809, 32.74021], [-117.16809, 32.73983], [-117.16848, 32.73982], [-117.16849, 32.74062]]], [[[-117.16935, 32.73926], [-117.16914, 32.73957], [-117.16907, 32.7397], [-117.169, 32.73971], [-117.16899, 32.73918], [-117.16934, 32.73918], [-117.16935, 32.73926]]]]} | Open Access 1 | 18557 | Albatross Canyon Open Space | 15332 | 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 | San Diego 4 | 5.812 | Albatross Canyon OS | 0 | Local Recreation Area 3 | 4 | |
2799 | 2799 | 2798 | {"type": "MultiPolygon", "coordinates": [[[[-117.05969, 32.76384], [-117.05963, 32.76392], [-117.05829, 32.76395], [-117.05834, 32.7639], [-117.05835, 32.76382], [-117.05963, 32.76378], [-117.05966, 32.76379], [-117.05969, 32.76384]]], [[[-117.06115, 32.76232], [-117.06114, 32.76248], [-117.06111, 32.76257], [-117.06106, 32.76264], [-117.06009, 32.76351], [-117.06004, 32.76235], [-117.06115, 32.76232]]]]} | Restricted Access 2 | 18582 | Clay Neighborhood Park | 31592 | 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 | San Diego 4 | 2.413 | Clay Neighborhood Park | 0 | Local Park 2 | 4 | |
2808 | 2808 | 2807 | {"type": "MultiPolygon", "coordinates": [[[[-117.07778, 33.0469], [-117.0777, 33.04805], [-117.07744, 33.04827], [-117.07733, 33.04853], [-117.07686, 33.04884], [-117.07613, 33.04995], [-117.07575, 33.05041], [-117.07551, 33.0502], [-117.07465, 33.04958], [-117.07443, 33.04938], [-117.07427, 33.0492], [-117.07411, 33.04898], [-117.07399, 33.04877], [-117.07384, 33.04837], [-117.0738, 33.04801], [-117.07377, 33.04761], [-117.0738, 33.04658], [-117.07388, 33.04658], [-117.07394, 33.04656], [-117.074, 33.04652], [-117.07403, 33.04647], [-117.07419, 33.04588], [-117.0744, 33.04536], [-117.0744, 33.04531], [-117.07438, 33.04525], [-117.07435, 33.04521], [-117.07429, 33.04517], [-117.07454, 33.04485], [-117.07512, 33.04473], [-117.07581, 33.04506], [-117.07646, 33.04577], [-117.07681, 33.04619], [-117.07765, 33.04667], [-117.07778, 33.0469]]], [[[-117.07436, 33.04534], [-117.07414, 33.04587], [-117.07398, 33.04646], [-117.07396, 33.0465], [-117.07391, 33.04652], [-117.0738, 33.04654], [-117.07384, 33.04615], [-117.07391, 33.04587], [-117.07407, 33.0455], [-117.07425, 33.04521], [-117.07434, 33.04526], [-117.07436, 33.04534]]]]} | Open Access 1 | 18642 | Rancho Bernardo Community Park | 24129 | 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 | San Diego 4 | 38.443 | Rancho Bernardo Community Park | 0 | Local Park 2 | 4 | |
2821 | 2821 | 2820 | {"type": "Polygon", "coordinates": [[[-117.10565, 32.95951], [-117.1049, 32.96028], [-117.10511, 32.96076], [-117.10481, 32.96091], [-117.10479, 32.96082], [-117.10437, 32.95997], [-117.10434, 32.95988], [-117.10452, 32.95947], [-117.10458, 32.95938], [-117.10472, 32.95925], [-117.10502, 32.95901], [-117.10523, 32.95877], [-117.1051, 32.95909], [-117.10558, 32.95931], [-117.10565, 32.95951]]]} | Open Access 1 | 18679 | Sunridge Vista Mini-Park | 30196 | 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 | San Diego 4 | 3.1 | Sunridge Vista Mini-Park | 0 | Local Park 2 | 4 | |
2824 | 2824 | 2823 | {"type": "Polygon", "coordinates": [[[-117.14001, 32.97192], [-117.13993, 32.97379], [-117.13978, 32.97392], [-117.13899, 32.97392], [-117.13901, 32.97353], [-117.13893, 32.97346], [-117.13896, 32.97341], [-117.13897, 32.97336], [-117.13895, 32.9733], [-117.13891, 32.97327], [-117.13895, 32.97321], [-117.13897, 32.97298], [-117.139, 32.97294], [-117.139, 32.97271], [-117.13891, 32.97265], [-117.13894, 32.97261], [-117.13895, 32.97256], [-117.13892, 32.9725], [-117.13889, 32.97246], [-117.13894, 32.9724], [-117.13893, 32.97203], [-117.13901, 32.97201], [-117.13918, 32.97191], [-117.1393, 32.97187], [-117.14001, 32.97192]]]} | Open Access 1 | 18685 | Adobe Bluffs Neighborhood Park | 15270 | 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 | San Diego 4 | 5.149 | Adobe Bluffs Neighborhood Park | 0 | Local Park 2 | 4 | |
2825 | 2825 | 2824 | {"type": "MultiPolygon", "coordinates": [[[[-117.16552, 32.98511], [-117.16551, 32.98602], [-117.1655, 32.98942], [-117.1653, 32.98936], [-117.16526, 32.98935], [-117.16525, 32.98932], [-117.16534, 32.98905], [-117.16538, 32.98882], [-117.16537, 32.98859], [-117.16528, 32.98808], [-117.16528, 32.98775], [-117.1653, 32.98759], [-117.16537, 32.98735], [-117.1654, 32.98709], [-117.1654, 32.98514], [-117.16545, 32.98511], [-117.16552, 32.98511]]], [[[-117.16611, 32.99288], [-117.16557, 32.99287], [-117.16538, 32.99289], [-117.16539, 32.98957], [-117.16549, 32.98959], [-117.16547, 32.99274], [-117.16611, 32.99275], [-117.16611, 32.99288]]]]} | Open Access 1 | 18687 | Black Mountain Ranch Open Space | 16134 | 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 | San Diego 4 | 2.646 | Black Mtn. Ranch OS | 0 | Local Recreation Area 3 | 4 | |
2826 | 2826 | 2825 | {"type": "Polygon", "coordinates": [[[-117.12944, 32.98294], [-117.12938, 32.98304], [-117.12928, 32.9829], [-117.12938, 32.98285], [-117.12944, 32.98294]]]} | Open Access 1 | 931 | 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.04 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 4 |
2836 | 2836 | 2835 | {"type": "Polygon", "coordinates": [[[-117.21384, 32.72823], [-117.21312, 32.72832], [-117.20895, 32.72874], [-117.20604, 32.72901], [-117.20516, 32.72907], [-117.20513, 32.7292], [-117.20489, 32.72922], [-117.20399, 32.72923], [-117.19926, 32.72923], [-117.19849, 32.72878], [-117.1987, 32.72875], [-117.199, 32.72867], [-117.19923, 32.72864], [-117.19928, 32.72856], [-117.19939, 32.72853], [-117.19967, 32.72863], [-117.19994, 32.72869], [-117.20437, 32.72869], [-117.20737, 32.72857], [-117.20898, 32.72845], [-117.21342, 32.72796], [-117.21356, 32.72797], [-117.21373, 32.72805], [-117.21384, 32.72817], [-117.21384, 32.72823]]]} | Open Access 1 | 4 | Spanish Landing Park | 25712 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/spanish-landing-park.html | San Diego 4 | 16.066 | Spanish Landing Park | 0 | Local Park 2 | 4 |
2837 | 2837 | 2836 | {"type": "Polygon", "coordinates": [[[-117.2474, 32.75459], [-117.24739, 32.75484], [-117.24661, 32.75496], [-117.24628, 32.75506], [-117.23979, 32.75584], [-117.2352, 32.75631], [-117.23602, 32.75535], [-117.23671, 32.75479], [-117.23711, 32.75456], [-117.24002, 32.75307], [-117.24079, 32.75264], [-117.24111, 32.75238], [-117.24153, 32.752], [-117.24208, 32.75143], [-117.24236, 32.75155], [-117.24326, 32.75207], [-117.24425, 32.75223], [-117.2449, 32.75257], [-117.24493, 32.7527], [-117.24492, 32.75295], [-117.24495, 32.75313], [-117.24529, 32.75309], [-117.24534, 32.75326], [-117.24542, 32.7534], [-117.2455, 32.75351], [-117.24543, 32.75352], [-117.24526, 32.75374], [-117.24531, 32.75376], [-117.24579, 32.75419], [-117.24596, 32.75431], [-117.24592, 32.75436], [-117.24592, 32.75438], [-117.24619, 32.75434], [-117.2462, 32.75437], [-117.24625, 32.75436], [-117.24628, 32.75454], [-117.24654, 32.75461], [-117.24668, 32.75462], [-117.2469, 32.75459], [-117.24721, 32.75461], [-117.2474, 32.75459]]]} | Open Access 1 | 46755 | Ocean Beach Athletic Area - Robb Field | 30206 | 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 | San Diego 4 | 68.208 | Ocean Beach Athletic Area - Robb Field | 0 | Local Recreation Area 3 | 4 | |
2839 | 2839 | 2838 | {"type": "Polygon", "coordinates": [[[-117.15582, 32.75554], [-117.15554, 32.75574], [-117.15531, 32.75552], [-117.15538, 32.75542], [-117.15582, 32.75543], [-117.15582, 32.75554]]]} | Open Access 1 | 68 | Uptown Open Space | 26740 | 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 | San Diego 4 | 0.27 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
2840 | 2840 | 2839 | {"type": "Polygon", "coordinates": [[[-117.19326, 32.96674], [-117.19257, 32.96698], [-117.19225, 32.96707], [-117.1915, 32.96711], [-117.19085, 32.96726], [-117.18994, 32.96739], [-117.18968, 32.96693], [-117.19283, 32.96625], [-117.19304, 32.96653], [-117.19313, 32.9666], [-117.19326, 32.96674]]]} | Open Access 1 | 46742 | Solana Ranch Neighborhood Park | 30192 | 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 | San Diego 4 | 4.961 | Solana Ranch Neighborhood 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]);