units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
646 rows where COUNTY = 4 and DES_TP = 2 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, MNG_AG_LEV, YR_EST
MNG_AGENCY 25
- San Diego, City of 281
- San Diego, County of 68
- Chula Vista, City of 60
- Oceanside, City of 28
- Carlsbad, City of 23
- San Marcos, City of 21
- Encinitas, City of 19
- Coronado, City of 17
- San Diego Unified Port District 17
- Escondido, City of 16
- La Mesa, City of 14
- Poway, City of 13
- Vista, City of 13
- El Cajon, City of 12
- Santee, City of 10
- National City, City of 6
- Lemon Grove, City of 6
- Del Mar, City of 5
- Imperial Beach, City of 5
- Solana Beach, City of 3
- Valley Center Parks and Recreation 3
- Helix Water District 2
- San Dieguito River Park Joint Powers Authority 2
- Ramona Municipal Water District 1
- Padre Dam Municipal Water District 1
MNG_AG_TYP 6
ACCESS_TYP 3
- Open Access 626
- Restricted Access 11
- No Public Access 9
DES_TP 1
- Local Park · 646 ✖
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 | |
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 | |
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 | |
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 |
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 | |
26 | 26 | 25 | {"type": "Polygon", "coordinates": [[[-117.08357, 32.75155], [-117.08352, 32.75156], [-117.08352, 32.75251], [-117.08356, 32.75252], [-117.08356, 32.75298], [-117.08332, 32.75306], [-117.08317, 32.75308], [-117.08165, 32.75308], [-117.08164, 32.75303], [-117.08042, 32.75302], [-117.0804, 32.75307], [-117.07989, 32.75305], [-117.07986, 32.753], [-117.07987, 32.75272], [-117.0797, 32.7518], [-117.07969, 32.75051], [-117.07966, 32.7505], [-117.07967, 32.74994], [-117.08202, 32.74993], [-117.08203, 32.75], [-117.08346, 32.75002], [-117.08348, 32.75006], [-117.08343, 32.75131], [-117.08356, 32.75132], [-117.08357, 32.75155]]]} | Open Access 1 | 89 | Colina Del Sol Community Park | 17497 | 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 | 29.899 | Colina Del Sol Community Park | 0 | Local Park 2 | 4 | |
41 | 41 | 40 | {"type": "Polygon", "coordinates": [[[-117.19344, 32.75165], [-117.19315, 32.75181], [-117.19311, 32.75179], [-117.19296, 32.75158], [-117.1933, 32.75139], [-117.19344, 32.75165]]]} | Open Access 1 | 95 | El Campo Santo Neighborhood Park | 30058 | 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.276 | El Campo Santo Neighborhood Park | 0 | Local Park 2 | 4 | |
5817 | 5817 | 5816 | {"type": "Polygon", "coordinates": [[[-117.07929, 32.75187], [-117.07928, 32.75306], [-117.07847, 32.75306], [-117.07843, 32.75304], [-117.0784, 32.75299], [-117.07841, 32.75278], [-117.07845, 32.75266], [-117.0786, 32.75249], [-117.07929, 32.75187]]]} | Open Access 1 | 100 | Colina Del Sol Community Park | 17497 | 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 | 1.783 | Colina Del Sol Community Park | 0 | Local Park 2 | 4 | |
49 | 49 | 48 | {"type": "Polygon", "coordinates": [[[-117.04877, 32.81115], [-117.04766, 32.81153], [-117.04656, 32.81065], [-117.04633, 32.81056], [-117.04656, 32.80996], [-117.04591, 32.8096], [-117.04518, 32.80917], [-117.0453, 32.80896], [-117.04544, 32.80897], [-117.04612, 32.8091], [-117.04679, 32.80933], [-117.04712, 32.80941], [-117.04749, 32.80943], [-117.04824, 32.80934], [-117.04829, 32.8096], [-117.0481, 32.80978], [-117.04786, 32.81015], [-117.04788, 32.81022], [-117.04852, 32.81057], [-117.04845, 32.81084], [-117.04877, 32.81115]]]} | Open Access 1 | 107 | Tuxedo Neighborhood Park | 30163 | 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 | 10.11 | Tuxedo Neighborhood Park | 0 | Local Park 2 | 4 | |
36 | 36 | 35 | {"type": "Polygon", "coordinates": [[[-117.05461, 32.80729], [-117.05411, 32.80771], [-117.05225, 32.80659], [-117.05423, 32.80617], [-117.05443, 32.80698], [-117.05448, 32.8071], [-117.05461, 32.80729]]]} | Open Access 1 | 118 | Dailard Neighborhood Park | 17891 | 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.634 | Dailard Neighborhood Park | 0 | Local Park 2 | 4 | |
58 | 58 | 57 | {"type": "Polygon", "coordinates": [[[-117.02209, 32.79762], [-117.02195, 32.79979], [-117.02062, 32.79972], [-117.02075, 32.79755], [-117.02202, 32.79758], [-117.02207, 32.7976], [-117.02209, 32.79762]]]} | Open Access 1 | 129 | San Carlos Community Park | 24847 | 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.486 | San Carlos Community Park | 0 | Local Park 2 | 4 | |
5820 | 5820 | 5819 | {"type": "Polygon", "coordinates": [[[-117.09642, 32.93477], [-117.09468, 32.93491], [-117.09432, 32.93597], [-117.09068, 32.9351], [-117.09092, 32.93437], [-117.09231, 32.9336], [-117.09269, 32.93357], [-117.09269, 32.93371], [-117.09284, 32.93402], [-117.09283, 32.93411], [-117.09305, 32.93419], [-117.09552, 32.9345], [-117.09578, 32.93446], [-117.09587, 32.93434], [-117.09578, 32.93292], [-117.09556, 32.93283], [-117.09544, 32.93282], [-117.09539, 32.93277], [-117.09539, 32.93265], [-117.09622, 32.93246], [-117.09637, 32.93247], [-117.09631, 32.93373], [-117.09642, 32.93477]]]} | Open Access 1 | 139 | Spring Canyon Neighborhood Park | 25736 | 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 | 19.013 | Spring Canyon Neighborhood Park | 0 | Local Park 2 | 4 | |
61 | 61 | 60 | {"type": "Polygon", "coordinates": [[[-117.12117, 32.92243], [-117.12114, 32.92415], [-117.11938, 32.9242], [-117.11931, 32.92417], [-117.11913, 32.9225], [-117.11913, 32.92238], [-117.12117, 32.92243]]]} | Open Access 1 | 146 | Westview Park | 27432 | 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.82 | Westview Park | 0 | Local Park 2 | 4 | |
68 | 68 | 67 | {"type": "MultiPolygon", "coordinates": [[[[-117.08318, 32.79598], [-117.08318, 32.79625], [-117.07976, 32.79623], [-117.07979, 32.79489], [-117.08005, 32.79464], [-117.08026, 32.79453], [-117.08041, 32.79449], [-117.08053, 32.79447], [-117.08069, 32.79447], [-117.08088, 32.79451], [-117.08105, 32.79458], [-117.08115, 32.79463], [-117.08253, 32.7958], [-117.0828, 32.79593], [-117.083, 32.79597], [-117.08318, 32.79598]]], [[[-117.08168, 32.79321], [-117.08167, 32.7939], [-117.08165, 32.79398], [-117.08157, 32.79411], [-117.08123, 32.79443], [-117.08117, 32.79444], [-117.08096, 32.79435], [-117.08077, 32.79431], [-117.08057, 32.7943], [-117.08036, 32.79433], [-117.07996, 32.79402], [-117.08082, 32.79319], [-117.08168, 32.79321]]]]} | Open Access 1 | 155 | Allied Gardens Community Park | 15383 | 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.814 | Allied Gardens Community Park | 0 | Local Park 2 | 4 | |
69 | 69 | 68 | {"type": "Polygon", "coordinates": [[[-117.06833, 32.78979], [-117.0681, 32.78985], [-117.06791, 32.78987], [-117.06755, 32.78998], [-117.06712, 32.79007], [-117.0668, 32.78832], [-117.06803, 32.78813], [-117.06823, 32.7894], [-117.06833, 32.78979]]]} | Open Access 1 | 163 | Princess Del Cerro Neighborhood Park | 30167 | 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.472 | Princess Del Cerro Neighborhood Park | 0 | Local Park 2 | 4 | |
70 | 70 | 69 | {"type": "Polygon", "coordinates": [[[-117.09581, 32.78702], [-117.0958, 32.78757], [-117.09407, 32.78755], [-117.09403, 32.78751], [-117.09402, 32.78697], [-117.09483, 32.78698], [-117.09581, 32.78702]]]} | Open Access 1 | 164 | Grantville Neighborhood Park | 30217 | 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.604 | Grantville 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]);