units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,421 rows where COUNTY = 4 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, MNG_AG_LEV
MNG_AGENCY >30
- San Diego, City of 533
- San Diego, County of 123
- Chula Vista, City of 70
- Poway, City of 67
- Encinitas, City of 57
- Oceanside, City of 45
- Carlsbad, City of 40
- San Marcos, City of 40
- Escondido, City of 34
- California Department of Fish and Wildlife 31
- Home Owners Association - Unknown Name 27
- California Department of Transportation 22
- California Department of Parks and Recreation 21
- The Environmental Trust 21
- Coronado, City of 19
- San Diego Unified Port District 19
- Vista, City of 18
- El Cajon, City of 17
- Fallbrook Land Conservancy 15
- La Mesa, City of 14
- Endangered Habitats Conservancy 14
- Center for Natural Lands Management 13
- Santee, City of 12
- United States Fish and Wildlife Service 10
- Del Mar, City of 8
- United States Bureau of Land Management 7
- National City, City of 7
- San Diego River Park Foundation 7
- San Dieguito River Valley Land Conservancy 6
- Lemon Grove, City of 6
- …
DES_TP >30
- Local Park 646
- Local Recreation Area 309
- Local Other or Unknown 99
- Private Conservation 87
- Local Conservation Area 58
- Private Recreation or Education 38
- State Conservation Area 36
- State Other or Unknown 20
- State Park 16
- National Wildlife Refuge 11
- State Resource Management Area 6
- National Public Lands 4
- Local Historic or Cultural Area 3
- Private Other or Unknown 3
- Conservation Area 2
- State Recreation Area 2
- Local Resource Management Area 2
- State Historic or Cultural Area 2
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- Recreation Management Area 1
- None 1
- None 1
- National Monument or Landmark 1
- None 1
- …
MNG_AG_TYP 21
- City Agency 995
- County Agency 123
- State Agency 87
- Non Profit - Land Trust 69
- Home Owners Association 28
- Non Profit - Conservation 24
- Water District 23
- Federal Agency 21
- Port/Harbor District 19
- Non Profit - Other 7
- Commercial 5
- Recreation/Parks District 4
- Transportation Agency 4
- Open Space District 2
- Irrigation District 2
- Special District - Other 2
- Other 2
- School District 1
- Mitigation Bank 1
- Utility 1
- Fire District 1
ACCESS_TYP 4
- Open Access 1,164
- No Public Access 128
- Restricted Access 102
- Unknown Access 27
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5651 | 5651 | 5650 | {"type": "MultiPolygon", "coordinates": [[[[-117.23481, 32.70867], [-117.23453, 32.70872], [-117.23408, 32.70871], [-117.23418, 32.70864], [-117.23425, 32.70854], [-117.23427, 32.70845], [-117.23425, 32.70832], [-117.23418, 32.70823], [-117.23409, 32.70816], [-117.23397, 32.70811], [-117.23384, 32.7081], [-117.2332, 32.70819], [-117.23264, 32.70834], [-117.23221, 32.70853], [-117.23165, 32.70889], [-117.2314, 32.70908], [-117.23107, 32.70939], [-117.22976, 32.71094], [-117.22935, 32.7114], [-117.22919, 32.71156], [-117.22641, 32.71385], [-117.22558, 32.71451], [-117.22521, 32.71482], [-117.2247, 32.71529], [-117.22376, 32.71604], [-117.22268, 32.71676], [-117.22233, 32.71697], [-117.22213, 32.71712], [-117.22203, 32.71721], [-117.22057, 32.71887], [-117.22052, 32.71895], [-117.22044, 32.71891], [-117.22023, 32.71914], [-117.22032, 32.71889], [-117.22032, 32.71885], [-117.22028, 32.71828], [-117.22029, 32.71823], [-117.22037, 32.71808], [-117.22051, 32.71789], [-117.221, 32.71733], [-117.22166, 32.71663], [-117.22209, 32.71624], [-117.22255, 32.71587], [-117.22259, 32.71576], [-117.22259, 32.71571], [-117.22256, 32.7156], [-117.22258, 32.71552], [-117.22263, 32.7155], [-117.2227, 32.71552], [-117.22288, 32.71581], [-117.22294, 32.71583], [-117.223, 32.71582], [-117.22352, 32.71545], [-117.22359, 32.71535], [-117.22359, 32.71527], [-117.22355, 32.71519], [-117.22343, 32.7151], [-117.22337, 32.71509], [-117.22324, 32.71512], [-117.22305, 32.71531], [-117.22294, 32.71538], [-117.22288, 32.7154], [-117.22283, 32.71537], [-117.22282, 32.71532], [-117.22284, 32.71528], [-117.22318, 32.71503], [-117.22326, 32.71498], [-117.22333, 32.71496], [-117.22359, 32.71496], [-117.22444, 32.71469], [-117.22509, 32.71442], [-117.22538, 32.7142], [-117.22733, 32.71264], [-117.22804, 32.71212], [-117.22831, 32.71185], [-117.22845, 32.71176], [-117.22872, 32.71147], [-117.22895, 32.71127], [-117.22913, 32.71108], [-117.22931, 32.71093], [-117.22995, 32.71027], [-117.23028, 32.70993], [-117.23097, 32.70915], [-117.23127, 32.70889], [-117.2315, 32.70871], [-117.23181, 32.70851], [-117.23209, 32.70837], [-117.23238, 32.70825], [-117.23287, 32.70809], [-117.23317, 32.70801], [-117.23344, 32.70796], [-117.23399, 32.70792], [-117.23433, 32.70793], [-117.23443, 32.70795], [-117.23463, 32.70801], [-117.2348, 32.70812], [-117.23485, 32.70838], [-117.23484, 32.70853], [-117.23481, 32.70867]], [[-117.22404, 32.71529], [-117.22399, 32.7153], [-117.22388, 32.71543], [-117.22374, 32.71553], [-117.22381, 32.71562], [-117.22391, 32.71555], [-117.22389, 32.71552], [-117.22411, 32.71534], [-117.22404, 32.71529]]], [[[-117.22229, 32.71844], [-117.22218, 32.71849], [-117.2221, 32.71854], [-117.222, 32.71866], [-117.22197, 32.71865], [-117.2213, 32.71939], [-117.22119, 32.71932], [-117.22109, 32.7194], [-117.22101, 32.71944], [-117.22088, 32.71946], [-117.22077, 32.71945], [-117.22068, 32.71941], [-117.2206, 32.71937], [-117.22054, 32.7193], [-117.22049, 32.71923], [-117.22047, 32.71911], [-117.2205, 32.71899], [-117.2205, 32.7191], [-117.22052, 32.71921], [-117.22058, 32.71929], [-117.22065, 32.71935], [-117.22077, 32.7194], [-117.22086, 32.71941], [-117.22098, 32.7194], [-117.22105, 32.71937], [-117.22116, 32.71929], [-117.22208, 32.71822], [-117.22229, 32.71844]]], [[[-117.23342, 32.70851], [-117.23331, 32.70845], [-117.2333, 32.70838], [-117.23334, 32.70831], [-117.2334, 32.70828], [-117.23375, 32.70824], [-117.23389, 32.70823], [-117.23402, 32.70827], [-117.23408, 32.70832], [-117.23413, 32.70844], [-117.23412, 32.70854], [-117.23408, 32.70859], [-117.23403, 32.70863], [-117.23391, 32.70867], [-117.23384, 32.70867], [-117.23371, 32.70863], [-117.23342, 32.70851]]]]} | Open Access 1 | 2 | Shelter Island Shoreline Park | 25388 | 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/shelter-island-shoreline-park.html | San Diego 4 | 22.918 | Shelter Island Shoreline Park | 0 | Local Park 2 | 4 |
5774 | 5774 | 5773 | {"type": "MultiPolygon", "coordinates": [[[[-117.21277, 32.72409], [-117.21242, 32.72415], [-117.21242, 32.72416], [-117.21255, 32.72421], [-117.21263, 32.72426], [-117.21269, 32.72434], [-117.21273, 32.72447], [-117.21271, 32.72458], [-117.21263, 32.72468], [-117.21253, 32.72474], [-117.21242, 32.72477], [-117.21231, 32.72477], [-117.2122, 32.72474], [-117.21211, 32.72467], [-117.21204, 32.72457], [-117.21198, 32.72453], [-117.21186, 32.72448], [-117.21175, 32.72447], [-117.20891, 32.72485], [-117.20875, 32.72489], [-117.20862, 32.72495], [-117.2083, 32.72515], [-117.20804, 32.72523], [-117.20804, 32.72522], [-117.2082, 32.72517], [-117.20834, 32.7251], [-117.20868, 32.7249], [-117.20886, 32.72484], [-117.2118, 32.72445], [-117.2119, 32.72447], [-117.21199, 32.72452], [-117.21206, 32.72457], [-117.21214, 32.72467], [-117.21222, 32.72472], [-117.21233, 32.72475], [-117.21247, 32.72475], [-117.21257, 32.7247], [-117.21265, 32.72462], [-117.21269, 32.72452], [-117.21269, 32.72443], [-117.21265, 32.72433], [-117.21257, 32.72426], [-117.21247, 32.72421], [-117.21235, 32.7242], [-117.20882, 32.72469], [-117.20868, 32.72472], [-117.20855, 32.72478], [-117.20818, 32.72501], [-117.20794, 32.72508], [-117.20575, 32.72528], [-117.20556, 32.72526], [-117.20516, 32.72509], [-117.20502, 32.72505], [-117.20491, 32.72504], [-117.20472, 32.72506], [-117.19821, 32.72516], [-117.19534, 32.72498], [-117.19334, 32.72482], [-117.19051, 32.72449], [-117.1898, 32.72438], [-117.1897, 32.72439], [-117.18962, 32.72441], [-117.1895, 32.7245], [-117.18954, 32.72421], [-117.19152, 32.72448], [-117.1935, 32.72472], [-117.19748, 32.725], [-117.20082, 32.72506], [-117.20418, 32.72498], [-117.20622, 32.72484], [-117.20787, 32.72469], [-117.20964, 32.72449], [-117.21135, 32.72425], [-117.21275, 32.72401], [-117.21277, 32.72409]]], [[[-117.18975, 32.72447], [-117.18983, 32.72447], [-117.1899, 32.72451], [-117.18995, 32.72456], [-117.18998, 32.72463], [-117.18998, 32.72469], [-117.18995, 32.72476], [-117.18988, 32.72481], [-117.1898, 32.72484], [-117.18971, 32.72484], [-117.18963, 32.72481], [-117.18957, 32.72475], [-117.18954, 32.72469], [-117.18955, 32.72461], [-117.18959, 32.72453], [-117.18967, 32.72448], [-117.18975, 32.72447]]], [[[-117.19031, 32.72454], [-117.19017, 32.72458], [-117.19008, 32.72464], [-117.19006, 32.72456], [-117.19002, 32.7245], [-117.19031, 32.72454]]], [[[-117.21235, 32.72429], [-117.21245, 32.7243], [-117.21253, 32.72435], [-117.21257, 32.7244], [-117.21259, 32.72447], [-117.21259, 32.72454], [-117.21254, 32.72461], [-117.21248, 32.72466], [-117.21238, 32.72468], [-117.21228, 32.72467], [-117.2122, 32.72463], [-117.21214, 32.72456], [-117.21212, 32.72448], [-117.21214, 32.72441], [-117.21219, 32.72434], [-117.21226, 32.7243], [-117.21235, 32.72429]]]]} | Open Access 1 | 3 | Harbor Island Park | 19664 | 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/harbor-island-park.html | San Diego 4 | 9.626 | Harbor Island Park | 0 | Local Park 2 | 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 |
5775 | 5775 | 5774 | {"type": "Polygon", "coordinates": [[[-117.05795, 32.7466], [-117.05795, 32.74669], [-117.05759, 32.74659], [-117.05761, 32.74652], [-117.05777, 32.74658], [-117.05795, 32.7466]]]} | Open Access 1 | 5 | Zena Mini-Park | 27862 | 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.067 | Zena Mini-Park | 0 | Local Park 2 | 4 | |
5776 | 5776 | 5775 | {"type": "Polygon", "coordinates": [[[-117.12088, 32.74978], [-117.12063, 32.74969], [-117.12063, 32.74952], [-117.12075, 32.74941], [-117.12088, 32.74978]]]} | Open Access 1 | 6 | Wabash Neighborhood Park | 30119 | 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.131 | Wabash Neighborhood Park | 0 | Local Park 2 | 4 | |
5772 | 5772 | 5771 | {"type": "MultiPolygon", "coordinates": [[[[-117.09595, 32.73243], [-117.09595, 32.73295], [-117.09545, 32.73295], [-117.09545, 32.73292], [-117.09595, 32.73243]]], [[[-117.09843, 32.73523], [-117.09843, 32.73653], [-117.09794, 32.73653], [-117.09794, 32.73626], [-117.09742, 32.73627], [-117.09716, 32.73619], [-117.0962, 32.73618], [-117.0962, 32.73598], [-117.0967, 32.73597], [-117.09673, 32.7318], [-117.09719, 32.7318], [-117.09717, 32.73381], [-117.0979, 32.73382], [-117.09789, 32.73522], [-117.09843, 32.73523]]], [[[-117.09844, 32.73154], [-117.09844, 32.73179], [-117.09803, 32.7318], [-117.09802, 32.73173], [-117.09745, 32.73172], [-117.09745, 32.73153], [-117.09844, 32.73154]]], [[[-117.09875, 32.73833], [-117.09835, 32.73833], [-117.09836, 32.73695], [-117.09875, 32.73695], [-117.09875, 32.73833]]], [[[-117.09913, 32.73237], [-117.09913, 32.73258], [-117.09869, 32.73258], [-117.09869, 32.73237], [-117.09913, 32.73237]]], [[[-117.09913, 32.73195], [-117.09913, 32.73209], [-117.09869, 32.73209], [-117.09869, 32.73195], [-117.09913, 32.73195]]], [[[-117.09935, 32.73841], [-117.09934, 32.73864], [-117.09894, 32.73864], [-117.09894, 32.73841], [-117.09935, 32.73841]]]]} | Open Access 1 | 20 | Swan's Canyon | 26095 | 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 | 14.734 | Swan's Canyon | 0 | Local Recreation Area 3 | 4 | |
5787 | 5787 | 5786 | {"type": "Polygon", "coordinates": [[[-117.16383, 32.73565], [-117.16352, 32.73566], [-117.16351, 32.7358], [-117.16293, 32.7358], [-117.16292, 32.73594], [-117.16203, 32.73595], [-117.16202, 32.73649], [-117.16202, 32.73727], [-117.1617, 32.73727], [-117.1617, 32.73766], [-117.16137, 32.73766], [-117.16136, 32.73741], [-117.16137, 32.73596], [-117.16184, 32.73595], [-117.16185, 32.73568], [-117.16227, 32.73567], [-117.16226, 32.73477], [-117.16292, 32.73477], [-117.16293, 32.73452], [-117.16319, 32.73452], [-117.1632, 32.73438], [-117.16382, 32.73438], [-117.16383, 32.73565]]]} | Open Access 1 | 21 | Maple Canyon Open Space | 21772 | 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.943 | Maple Canyon OS | 0 | Local Recreation Area 3 | 4 | |
6 | 6 | 5 | {"type": "MultiPolygon", "coordinates": [[[[-117.11089, 32.73295], [-117.11088, 32.73298], [-117.11086, 32.73286], [-117.1107, 32.73261], [-117.11037, 32.73248], [-117.10993, 32.73245], [-117.10979, 32.73242], [-117.10919, 32.73273], [-117.10874, 32.73272], [-117.10872, 32.73247], [-117.10818, 32.73272], [-117.10811, 32.73272], [-117.10788, 32.73308], [-117.10775, 32.73295], [-117.10773, 32.73295], [-117.1074, 32.73315], [-117.10734, 32.73317], [-117.10705, 32.7334], [-117.10683, 32.73321], [-117.10705, 32.73283], [-117.10727, 32.73261], [-117.10691, 32.73234], [-117.10697, 32.73229], [-117.10703, 32.73226], [-117.10776, 32.73211], [-117.10766, 32.73176], [-117.10765, 32.73157], [-117.10769, 32.73139], [-117.10774, 32.73124], [-117.10782, 32.73111], [-117.10802, 32.73089], [-117.10797, 32.73062], [-117.10803, 32.73067], [-117.10847, 32.7309], [-117.10876, 32.73109], [-117.10866, 32.73109], [-117.10858, 32.73107], [-117.10849, 32.73117], [-117.10866, 32.73138], [-117.10875, 32.73158], [-117.10881, 32.73182], [-117.10883, 32.73208], [-117.10939, 32.73195], [-117.10985, 32.73194], [-117.10996, 32.73191], [-117.11035, 32.73217], [-117.11072, 32.73258], [-117.11089, 32.73286], [-117.11089, 32.73295]]], [[[-117.10995, 32.73399], [-117.10989, 32.73404], [-117.10985, 32.734], [-117.10991, 32.73395], [-117.10995, 32.73399]]]]} | Open Access 1 | 26 | Azalea Neighborhood Park | 30115 | 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.138 | Azalea Neighborhood Park | 0 | Local Park 2 | 4 | |
10 | 10 | 9 | {"type": "MultiPolygon", "coordinates": [[[[-117.09436, 32.74201], [-117.09395, 32.74201], [-117.09393, 32.74146], [-117.09346, 32.74146], [-117.09345, 32.74102], [-117.09291, 32.74017], [-117.09284, 32.74016], [-117.09282, 32.73919], [-117.09236, 32.73919], [-117.09235, 32.7385], [-117.0928, 32.73849], [-117.09279, 32.73755], [-117.09339, 32.73754], [-117.09339, 32.73696], [-117.09359, 32.73697], [-117.0936, 32.73699], [-117.0938, 32.73699], [-117.09383, 32.7391], [-117.09321, 32.73912], [-117.09324, 32.74037], [-117.09385, 32.74037], [-117.09387, 32.74118], [-117.09435, 32.74118], [-117.09436, 32.74201]]], [[[-117.09277, 32.74057], [-117.0927, 32.74058], [-117.09269, 32.74084], [-117.09238, 32.74085], [-117.09238, 32.74039], [-117.09276, 32.74038], [-117.09277, 32.74057]]], [[[-117.09497, 32.74242], [-117.09456, 32.74242], [-117.09456, 32.74223], [-117.09497, 32.74222], [-117.09497, 32.74242]]], [[[-117.09603, 32.7429], [-117.09564, 32.74291], [-117.09564, 32.7427], [-117.09603, 32.7427], [-117.09603, 32.7429]]]]} | Open Access 1 | 31 | 47th Street Canyon | 15202 | 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.994 | 47th Street Canyon | 0 | Local Recreation Area 3 | 4 | |
5790 | 5790 | 5789 | {"type": "MultiPolygon", "coordinates": [[[[-117.05865, 32.73857], [-117.05803, 32.73858], [-117.05803, 32.73858], [-117.05803, 32.73856], [-117.05825, 32.73832], [-117.05837, 32.73835], [-117.05865, 32.73857]]], [[[-117.07608, 32.7349], [-117.07553, 32.73603], [-117.07537, 32.7361], [-117.07502, 32.7362], [-117.07475, 32.73625], [-117.07425, 32.73628], [-117.07389, 32.73626], [-117.07368, 32.73623], [-117.07342, 32.73618], [-117.07295, 32.73604], [-117.07392, 32.73416], [-117.07397, 32.73212], [-117.07206, 32.7321], [-117.07202, 32.73303], [-117.06932, 32.733], [-117.06852, 32.73484], [-117.06333, 32.73515], [-117.06296, 32.73519], [-117.06243, 32.73529], [-117.06193, 32.73541], [-117.06145, 32.73556], [-117.06106, 32.73572], [-117.06065, 32.73591], [-117.0602, 32.73616], [-117.05974, 32.73646], [-117.05946, 32.73668], [-117.05898, 32.73711], [-117.05826, 32.73785], [-117.05827, 32.73787], [-117.05822, 32.7379], [-117.05815, 32.73791], [-117.05808, 32.7379], [-117.05804, 32.73788], [-117.05806, 32.73498], [-117.05829, 32.73483], [-117.05962, 32.7333], [-117.06222, 32.73142], [-117.06439, 32.73013], [-117.06626, 32.72932], [-117.06794, 32.72884], [-117.06794, 32.72935], [-117.07536, 32.72946], [-117.07535, 32.73054], [-117.07436, 32.73039], [-117.07431, 32.7322], [-117.07528, 32.73223], [-117.07525, 32.73371], [-117.0751, 32.7337], [-117.0749, 32.73396], [-117.07524, 32.73479], [-117.07525, 32.73489], [-117.07608, 32.7349]]], [[[-117.07739, 32.73587], [-117.07737, 32.73674], [-117.07678, 32.73675], [-117.07676, 32.73801], [-117.07523, 32.73805], [-117.07525, 32.7402], [-117.07485, 32.7404], [-117.07138, 32.74035], [-117.07141, 32.73924], [-117.07138, 32.73918], [-117.07133, 32.73912], [-117.07133, 32.73895], [-117.06827, 32.7393], [-117.06726, 32.73928], [-117.06724, 32.74028], [-117.06672, 32.74028], [-117.06671, 32.73846], [-117.05891, 32.73857], [-117.05887, 32.73852], [-117.05867, 32.73833], [-117.05842, 32.73814], [-117.05854, 32.73799], [-117.05857, 32.738], [-117.05908, 32.73745], [-117.05943, 32.7371], [-117.05966, 32.7369], [-117.05991, 32.73671], [-117.06041, 32.73638], [-117.0608, 32.73616], [-117.06136, 32.73591], [-117.06196, 32.7357], [-117.0625, 32.73556], [-117.06343, 32.73542], [-117.06534, 32.73529], [-117.06849, 32.73512], [-117.06912, 32.73512], [-117.06941, 32.73515], [-117.06966, 32.73521], [-117.07013, 32.73534], [-117.07282, 32.73631], [-117.07351, 32.73649], [-117.07402, 32.73655], [-117.07434, 32.73656], [-117.07465, 32.73654], [-117.07493, 32.7365], [-117.07521, 32.73644], [-117.07551, 32.73635], [-117.0763, 32.73602], [-117.07656, 32.73594], [-117.07693, 32.73587], [-117.07739, 32.73587]]]]} | Open Access 1 | 39 | Chollas Lake Community Park | 30046 | 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 | 341.762 | Chollas Lake Community Park | 0 | Local Park 2 | 4 | |
5179 | 5179 | 5178 | {"type": "Polygon", "coordinates": [[[-117.15713, 32.7541], [-117.15639, 32.7541], [-117.15639, 32.75376], [-117.15712, 32.75376], [-117.15713, 32.7541]]]} | Open Access 1 | 40 | Mission Valley Hillsides Open Space | 22316 | 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.644 | Mission Valley Hillsides OS | 0 | Local Recreation Area 3 | 4 | |
5793 | 5793 | 5792 | {"type": "MultiPolygon", "coordinates": [[[[-117.19381, 32.75393], [-117.19314, 32.75468], [-117.19139, 32.75359], [-117.19142, 32.75354], [-117.19096, 32.75325], [-117.19099, 32.75319], [-117.1896, 32.75233], [-117.18989, 32.752], [-117.19175, 32.75315], [-117.19204, 32.75283], [-117.19381, 32.75393]]], [[[-117.19427, 32.7534], [-117.19392, 32.7538], [-117.19353, 32.75356], [-117.19387, 32.75316], [-117.19427, 32.7534]]]]} | Open Access 1 | 45 | Heritage Park | 19842 | 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/Heritage.html | San Diego 4 | 8.454 | Heritage Park | 0 | Local Park 2 | 4 |
5056 | 5056 | 5055 | {"type": "Polygon", "coordinates": [[[-117.13499, 32.75509], [-117.13393, 32.75509], [-117.13391, 32.75416], [-117.13499, 32.75415], [-117.13499, 32.75509]]]} | Restricted Access 2 | 46 | San Diego Indoor Soccer Center | 30288 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 6103 | Private Landowner 774 | Private 7 | Other 26 | San Diego 4 | 2.583 | San Diego Indoor Soccer Ctr. | None 416 | |||
5795 | 5795 | 5794 | {"type": "Polygon", "coordinates": [[[-117.13499, 32.75399], [-117.13391, 32.75399], [-117.13392, 32.75231], [-117.13395, 32.75221], [-117.13397, 32.7522], [-117.13398, 32.75045], [-117.13451, 32.75045], [-117.13451, 32.75112], [-117.13498, 32.75112], [-117.13499, 32.75399]]]} | Open Access 1 | 51 | North Park Community Park | 22844 | 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 | 8.653 | North Park Community Park | 0 | Local Park 2 | 4 | |
15958 | 15958 | 15957 | {"type": "MultiPolygon", "coordinates": [[[[-117.16852, 32.75178], [-117.16819, 32.75178], [-117.16819, 32.75095], [-117.16851, 32.75094], [-117.16852, 32.75178]]], [[[-117.17277, 32.75259], [-117.17219, 32.7526], [-117.17221, 32.75382], [-117.17234, 32.75383], [-117.17233, 32.75447], [-117.17188, 32.75448], [-117.17188, 32.75493], [-117.17128, 32.75494], [-117.17129, 32.75521], [-117.17188, 32.75521], [-117.17188, 32.75535], [-117.1704, 32.75535], [-117.1704, 32.75679], [-117.16881, 32.75676], [-117.16879, 32.75595], [-117.16827, 32.75595], [-117.16825, 32.7539], [-117.16825, 32.75383], [-117.16882, 32.75382], [-117.1688, 32.75369], [-117.1688, 32.75301], [-117.16946, 32.75301], [-117.16949, 32.75482], [-117.17153, 32.7548], [-117.17154, 32.75383], [-117.17152, 32.75273], [-117.17153, 32.75233], [-117.17127, 32.75232], [-117.17061, 32.75232], [-117.17062, 32.75197], [-117.17065, 32.75193], [-117.1707, 32.75191], [-117.17127, 32.75191], [-117.17128, 32.75218], [-117.17185, 32.75218], [-117.17186, 32.75225], [-117.17244, 32.75225], [-117.17245, 32.75219], [-117.17277, 32.75219], [-117.17277, 32.75259]]], [[[-117.1731, 32.75421], [-117.17278, 32.75421], [-117.17277, 32.75382], [-117.17309, 32.75381], [-117.1731, 32.75421]]]]} | Open Access 1 | 63 | 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 | 22.556 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
5807 | 5807 | 5806 | {"type": "MultiPolygon", "coordinates": [[[[-117.1979, 32.75524], [-117.19784, 32.75522], [-117.1978, 32.75525], [-117.19726, 32.75586], [-117.19496, 32.75444], [-117.19544, 32.75389], [-117.19571, 32.75404], [-117.19609, 32.75362], [-117.19582, 32.75346], [-117.19652, 32.75267], [-117.19659, 32.75267], [-117.19815, 32.75364], [-117.19828, 32.75373], [-117.19843, 32.75387], [-117.19854, 32.75401], [-117.19863, 32.75415], [-117.19874, 32.75463], [-117.19879, 32.75481], [-117.19886, 32.75497], [-117.19905, 32.75527], [-117.19933, 32.75556], [-117.19935, 32.7556], [-117.19935, 32.75565], [-117.19932, 32.75571], [-117.19913, 32.75594], [-117.19907, 32.75595], [-117.1979, 32.75524]]], [[[-117.19967, 32.75541], [-117.19958, 32.75542], [-117.19949, 32.75539], [-117.19918, 32.7551], [-117.19911, 32.75501], [-117.19904, 32.75488], [-117.19898, 32.75472], [-117.19892, 32.75437], [-117.19884, 32.75414], [-117.19871, 32.75391], [-117.19852, 32.75369], [-117.19905, 32.75402], [-117.19912, 32.75401], [-117.19967, 32.75541]]]]} | Open Access 1 | 67 | Old Town San Diego State Historic Park | 1665 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/default.asp?page_id=663 | San Diego 4 | 19.895 | Old Town San Diego SHP | 1967 | State Historic or Cultural Area 132 | 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 | |
5805 | 5805 | 5804 | {"type": "Polygon", "coordinates": [[[-117.15503, 32.75526], [-117.15494, 32.7552], [-117.15494, 32.75483], [-117.15502, 32.75483], [-117.15503, 32.75526]]]} | Open Access 1 | 73 | 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.082 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
15959 | 15959 | 15958 | {"type": "Polygon", "coordinates": [[[-117.15844, 32.75574], [-117.15803, 32.75574], [-117.15769, 32.75634], [-117.15747, 32.75625], [-117.15712, 32.75602], [-117.15701, 32.75585], [-117.15677, 32.7558], [-117.15656, 32.75572], [-117.15644, 32.75554], [-117.15643, 32.75545], [-117.15766, 32.75548], [-117.15765, 32.7543], [-117.15782, 32.75454], [-117.158, 32.75474], [-117.15844, 32.75574]]]} | Open Access 1 | 74 | 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 | 3.512 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
34 | 34 | 33 | {"type": "MultiPolygon", "coordinates": [[[[-117.17794, 32.74783], [-117.17775, 32.74806], [-117.17722, 32.74774], [-117.1774, 32.74752], [-117.17794, 32.74783]]], [[[-117.17828, 32.74722], [-117.17791, 32.74765], [-117.1775, 32.74741], [-117.17767, 32.74719], [-117.17788, 32.74732], [-117.17807, 32.74709], [-117.17828, 32.74722]]], [[[-117.18416, 32.74689], [-117.18397, 32.7471], [-117.18305, 32.74655], [-117.18229, 32.74742], [-117.18242, 32.74751], [-117.18213, 32.74784], [-117.1823, 32.74795], [-117.18122, 32.74795], [-117.18235, 32.74663], [-117.18211, 32.74647], [-117.18239, 32.74614], [-117.18259, 32.74591], [-117.18283, 32.74606], [-117.18329, 32.74552], [-117.18411, 32.74602], [-117.1836, 32.74661], [-117.18398, 32.74685], [-117.18403, 32.74681], [-117.18416, 32.74689]]]]} | Open Access 1 | 83 | Mission Hills Park and Open Space | 22301 | 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.109 | Mission Hills Park and OS | 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]);