units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where ACCESS_TYP = 1, MNG_AGENCY = 117 and MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
DES_TP 4
- Local Park 60
- Local Recreation Area 6
- None 1
- None 1
MNG_AG_TYP 1
- City Agency · 68 ✖
MNG_AGENCY 1
- Chula Vista, City of · 68 ✖
ACCESS_TYP 1
- Open Access · 68 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16337 | 16337 | 16336 | {"type": "MultiPolygon", "coordinates": [[[[-117.07724, 32.58886], [-117.07702, 32.58887], [-117.07702, 32.58935], [-117.07542, 32.58935], [-117.07543, 32.5875], [-117.07724, 32.5875], [-117.07724, 32.58886]]], [[[-117.07114, 32.59021], [-117.07114, 32.59039], [-117.07056, 32.5903], [-117.06945, 32.5902], [-117.07114, 32.59021]]], [[[-117.05145, 32.59104], [-117.05145, 32.59113], [-117.05034, 32.59112], [-117.05034, 32.59103], [-117.05145, 32.59104]]], [[[-117.04928, 32.58936], [-117.04829, 32.58936], [-117.04829, 32.5878], [-117.04827, 32.58738], [-117.04815, 32.58739], [-117.04815, 32.58946], [-117.04715, 32.58946], [-117.04716, 32.58898], [-117.04617, 32.58897], [-117.04617, 32.5874], [-117.04603, 32.5874], [-117.04602, 32.58897], [-117.04503, 32.58897], [-117.04502, 32.58924], [-117.04397, 32.58926], [-117.04398, 32.59108], [-117.04503, 32.59108], [-117.04503, 32.59121], [-117.04077, 32.59126], [-117.04076, 32.59112], [-117.03866, 32.59115], [-117.03865, 32.58747], [-117.045, 32.58741], [-117.045, 32.58713], [-117.04548, 32.58711], [-117.04563, 32.58708], [-117.0458, 32.58697], [-117.04595, 32.58704], [-117.04613, 32.5869], [-117.04629, 32.58682], [-117.04646, 32.5867], [-117.04663, 32.5867], [-117.0468, 32.58666], [-117.04728, 32.58664], [-117.04777, 32.58674], [-117.0479, 32.5867], [-117.04804, 32.58663], [-117.04812, 32.58678], [-117.0482, 32.58684], [-117.04838, 32.58684], [-117.04863, 32.587], [-117.04879, 32.58699], [-117.04895, 32.58703], [-117.04925, 32.58706], [-117.04928, 32.58936]]], [[[-117.03561, 32.59007], [-117.03561, 32.59118], [-117.03231, 32.59122], [-117.03231, 32.59052], [-117.03561, 32.59007]]], [[[-117.06313, 32.59241], [-117.06252, 32.59241], [-117.0625, 32.59211], [-117.06035, 32.59206], [-117.06034, 32.59104], [-117.05813, 32.59103], [-117.05813, 32.58922], [-117.05812, 32.58921], [-117.05701, 32.58922], [-117.057, 32.58915], [-117.0548, 32.58916], [-117.05481, 32.58926], [-117.05701, 32.58926], [-117.05702, 32.59201], [-117.0565, 32.59186], [-117.05648, 32.59076], [-117.05594, 32.59077], [-117.05594, 32.59166], [-117.05381, 32.59167], [-117.05381, 32.59146], [-117.05393, 32.59123], [-117.05394, 32.59116], [-117.05392, 32.5911], [-117.05386, 32.59106], [-117.05372, 32.59105], [-117.05371, 32.58741], [-117.05801, 32.58744], [-117.06057, 32.58744], [-117.06076, 32.58781], [-117.06072, 32.58785], [-117.06078, 32.58853], [-117.06074, 32.58859], [-117.06079, 32.58889], [-117.06092, 32.58917], [-117.06111, 32.58954], [-117.06126, 32.58963], [-117.06137, 32.58984], [-117.06148, 32.58981], [-117.06205, 32.59085], [-117.06195, 32.59089], [-117.062, 32.59099], [-117.06212, 32.59095], [-117.06213, 32.59096], [-117.06219, 32.59106], [-117.06242, 32.59139], [-117.06276, 32.592], [-117.06295, 32.59222], [-117.06313, 32.59241]]], [[[-117.08192, 32.59211], [-117.08125, 32.59221], [-117.0809, 32.5922], [-117.08069, 32.59211], [-117.08063, 32.59204], [-117.08053, 32.59198], [-117.0804, 32.59195], [-117.07977, 32.59191], [-117.07976, 32.59168], [-117.07762, 32.59167], [-117.07761, 32.59203], [-117.07532, 32.59205], [-117.07531, 32.5928], [-117.07527, 32.5928], [-117.07525, 32.59284], [-117.07521, 32.59287], [-117.07437, 32.59287], [-117.07432, 32.59284], [-117.07388, 32.59203], [-117.07393, 32.59203], [-117.07393, 32.59201], [-117.07345, 32.59112], [-117.08191, 32.59115], [-117.08192, 32.59211]]], [[[-117.06506, 32.59281], [-117.06465, 32.5928], [-117.06464, 32.59284], [-117.06461, 32.59284], [-117.06437, 32.59277], [-117.06388, 32.59258], [-117.06355, 32.59238], [-117.06329, 32.59214], [-117.06308, 32.59191], [-117.06295, 32.59167], [-117.0627, 32.59109], [-117.06504, 32.5911], [-117.06506, 32.59281]]], [[[-117.03003, 32.59295], [-117.02946, 32.59306], [-117.02891, 32.59321], [-117.02792, 32.59359], [-117.02792, 32.59302], [-117.02789, 32.59301], [-117.02789, 32.5935], [-117.0277, 32.59349], [-117.02748, 32.59353], [-117.02729, 32.59363], [-117.02715, 32.59375], [-117.02705, 32.59377], [-117.02698, 32.59375], [-117.02694, 32.59371], [-117.02687, 32.59352], [-117.02679, 32.59343], [-117.02667, 32.59334], [-117.02655, 32.59331], [-117.02619, 32.59326], [-117.02519, 32.59335], [-117.02471, 32.59332], [-117.02416, 32.59317], [-117.0232, 32.59297], [-117.0231, 32.59288], [-117.02301, 32.59285], [-117.02188, 32.59273], [-117.02165, 32.59269], [-117.02136, 32.59261], [-117.02018, 32.5925], [-117.01982, 32.59255], [-117.01973, 32.59259], [-117.01966, 32.59265], [-117.01963, 32.5927], [-117.01964, 32.59277], [-117.01978, 32.59293], [-117.01977, 32.59295], [-117.01912, 32.59307], [-117.0188, 32.59305], [-117.01877, 32.59311], [-117.01865, 32.59343], [-117.01727, 32.59308], [-117.01699, 32.59302], [-117.01648, 32.59296], [-117.0159, 32.59295], [-117.01561, 32.59298], [-117.01525, 32.59303], [-117.01448, 32.59321], [-117.01447, 32.59344], [-117.01416, 32.59353], [-117.01374, 32.59361], [-117.01164, 32.59384], [-117.0111, 32.59384], [-117.01087, 32.59383], [-117.01005, 32.59371], [-117.01004, 32.59355], [-117.0074, 32.59311], [-117.00674, 32.59307], [-117.00674, 32.59097], [-117.00749, 32.59106], [-117.00822, 32.59118], [-117.0079, 32.59229], [-117.00852, 32.59242], [-117.00888, 32.59122], [-117.00907, 32.59125], [-117.00954, 32.59112], [-117.01003, 32.59112], [-117.01006, 32.5909], [-117.01447, 32.59108], [-117.03002, 32.59121], [-117.03003, 32.59295]]]]} | Open Access 1 | 7396 | Otay Valley Regional Park | 2353 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.ovrp.org/ | San Diego 4 | 324.371 | Otay Valley RP | 0 | Local Park 2 | 4 |
16088 | 16088 | 16087 | {"type": "Polygon", "coordinates": [[[-117.06918, 32.64875], [-117.06908, 32.64878], [-117.06907, 32.6488], [-117.06875, 32.64877], [-117.06877, 32.64866], [-117.06873, 32.64853], [-117.06906, 32.64844], [-117.06918, 32.64875]]]} | Open Access 1 | 45190 | Chula Vista Open Space | 17242 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 0.292 | Chula Vista OS | 0 | Local Recreation Area 3 | 4 | |
16036 | 16036 | 16035 | {"type": "Polygon", "coordinates": [[[-117.03382, 32.61286], [-117.03349, 32.6137], [-117.03347, 32.61384], [-117.03347, 32.61412], [-117.03353, 32.61451], [-117.03347, 32.61457], [-117.033, 32.61462], [-117.0322, 32.61478], [-117.03167, 32.61487], [-117.03113, 32.61491], [-117.03111, 32.61487], [-117.03317, 32.61427], [-117.03268, 32.61309], [-117.03299, 32.61322], [-117.0333, 32.61315], [-117.03363, 32.6128], [-117.03382, 32.61286]]]} | Open Access 1 | 45160 | Greg Rogers Open Space | 19497 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 3.286 | Greg Rogers OS | 0 | Local Recreation Area 3 | 4 | |
15499 | 15499 | 15498 | {"type": "Polygon", "coordinates": [[[-117.03519, 32.61371], [-117.03432, 32.61396], [-117.03397, 32.61417], [-117.03397, 32.61419], [-117.03366, 32.61425], [-117.03363, 32.61401], [-117.03365, 32.61375], [-117.03368, 32.61363], [-117.03396, 32.61295], [-117.03424, 32.61302], [-117.03431, 32.61284], [-117.03436, 32.61267], [-117.03438, 32.61247], [-117.03436, 32.61198], [-117.0344, 32.61182], [-117.03447, 32.61169], [-117.03467, 32.61177], [-117.03472, 32.61192], [-117.03453, 32.61199], [-117.03519, 32.61371]]]} | Open Access 1 | 45159 | Flair Slopes Open Space | 18937 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 4.503 | Flair Slopes OS | 0 | Local Recreation Area 3 | 4 | |
14851 | 14851 | 14850 | {"type": "Polygon", "coordinates": [[[-117.00958, 32.6349], [-117.00825, 32.63528], [-117.00753, 32.63555], [-117.00743, 32.63566], [-117.00718, 32.63564], [-117.00706, 32.63568], [-117.00713, 32.63598], [-117.00697, 32.63602], [-117.00608, 32.63596], [-117.00596, 32.63596], [-117.0056, 32.63623], [-117.0056, 32.63624], [-117.00558, 32.63622], [-117.00559, 32.63621], [-117.00528, 32.63542], [-117.00934, 32.63428], [-117.00958, 32.6349]]]} | Open Access 1 | 45345 | Independence Park Open Space | 20196 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/independence-park | San Diego 4 | 8.212 | Independence Park OS | 0 | Local Recreation Area 3 | 4 |
14843 | 14843 | 14842 | {"type": "Polygon", "coordinates": [[[-117.09107, 32.61913], [-117.09075, 32.61922], [-117.09068, 32.61905], [-117.091, 32.61896], [-117.09107, 32.61913]]]} | Open Access 1 | 45343 | Lancerlot Park | 21000 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/lancerlot-park | San Diego 4 | 0.155 | Lancerlot Park | 0 | Local Park 2 | 4 |
14762 | 14762 | 14761 | {"type": "Polygon", "coordinates": [[[-116.97651, 32.6128], [-116.97638, 32.61287], [-116.97623, 32.61292], [-116.97566, 32.61299], [-116.97547, 32.61304], [-116.9753, 32.61311], [-116.97513, 32.6132], [-116.97499, 32.6133], [-116.97474, 32.61356], [-116.97466, 32.61359], [-116.97418, 32.61369], [-116.97406, 32.61373], [-116.97391, 32.61384], [-116.97376, 32.61399], [-116.97363, 32.61405], [-116.97357, 32.61383], [-116.97353, 32.61361], [-116.97346, 32.6126], [-116.97478, 32.61231], [-116.975, 32.61238], [-116.97625, 32.61212], [-116.97627, 32.6123], [-116.97632, 32.61248], [-116.9764, 32.61264], [-116.97651, 32.6128]]]} | Open Access 1 | 45144 | All Seasons Park | 15377 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/all-seasons-park | San Diego 4 | 7.603 | All Seasons Park | 0 | Local Park 2 | 4 |
14603 | 14603 | 14602 | {"type": "Polygon", "coordinates": [[[-117.00274, 32.63678], [-117.00237, 32.63691], [-117.0021, 32.63708], [-117.00207, 32.63715], [-117.00196, 32.63715], [-117.0019, 32.63717], [-117.00187, 32.63722], [-117.00178, 32.63718], [-117.00147, 32.63726], [-117.00139, 32.63705], [-117.00171, 32.63697], [-117.00176, 32.6368], [-117.00183, 32.63678], [-117.00193, 32.63693], [-117.002, 32.63695], [-117.00263, 32.6366], [-117.00274, 32.63678]]]} | Open Access 1 | 44824 | Rancho Del Rey Finger | 24139 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/rancho-del-rey-park | San Diego 4 | 0.747 | Rancho Del Rey Finger | None 1246 | ||
14598 | 14598 | 14597 | {"type": "Polygon", "coordinates": [[[-116.98456, 32.63845], [-116.98455, 32.63849], [-116.98452, 32.63851], [-116.98444, 32.63854], [-116.98433, 32.63855], [-116.98428, 32.63857], [-116.98425, 32.63864], [-116.98427, 32.63871], [-116.9842, 32.63876], [-116.9841, 32.63879], [-116.984, 32.63879], [-116.98397, 32.63872], [-116.98392, 32.63869], [-116.98387, 32.63868], [-116.98381, 32.6387], [-116.98374, 32.63876], [-116.98358, 32.63881], [-116.98353, 32.63879], [-116.98341, 32.63835], [-116.9834, 32.63819], [-116.98335, 32.6381], [-116.98379, 32.63786], [-116.98375, 32.63775], [-116.9838, 32.63774], [-116.9841, 32.63775], [-116.98413, 32.63785], [-116.98426, 32.638], [-116.98456, 32.63845]]]} | Open Access 1 | 44823 | Breezewood Park | 16347 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/breezewood-park | San Diego 4 | 2.13 | Breezewood Park | 0 | Local Park 2 | 4 |
7722 | 7722 | 7721 | {"type": "Polygon", "coordinates": [[[-117.04933, 32.60323], [-117.04733, 32.6038], [-117.04724, 32.60358], [-117.04778, 32.60325], [-117.04812, 32.60225], [-117.04893, 32.60207], [-117.04893, 32.60115], [-117.04932, 32.60115], [-117.04933, 32.60323]]]} | Open Access 1 | 7898 | Loma Verde Park | 21408 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/loma-verde-park | San Diego 4 | 6.08 | Loma Verde Park | 0 | Local Park 2 | 4 |
7721 | 7721 | 7720 | {"type": "Polygon", "coordinates": [[[-117.04485, 32.59873], [-117.0448, 32.59874], [-117.04479, 32.59888], [-117.0448, 32.59986], [-117.04462, 32.60028], [-117.04447, 32.6003], [-117.04444, 32.60062], [-117.0444, 32.60063], [-117.04429, 32.60033], [-117.04396, 32.60049], [-117.04384, 32.60049], [-117.04385, 32.59896], [-117.0435, 32.59895], [-117.04351, 32.59847], [-117.04401, 32.59847], [-117.04485, 32.59845], [-117.04485, 32.59873]]]} | Open Access 1 | 7878 | Los Ninos Park | 21521 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/los-ninos-park | San Diego 4 | 5.094 | Los Ninos Park | 0 | Local Park 2 | 4 |
7720 | 7720 | 7719 | {"type": "Polygon", "coordinates": [[[-116.97799, 32.6467], [-116.97786, 32.64678], [-116.97765, 32.64685], [-116.97688, 32.64697], [-116.97686, 32.64694], [-116.97688, 32.64646], [-116.97685, 32.6463], [-116.97678, 32.6461], [-116.9764, 32.6454], [-116.97634, 32.64518], [-116.97799, 32.6467]]]} | Open Access 1 | 7876 | Pedestrian Park | 23560 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 2.453 | Pedestrian Park | 0 | Local Park 2 | 4 | |
7719 | 7719 | 7718 | {"type": "Polygon", "coordinates": [[[-117.05519, 32.60397], [-117.05513, 32.60401], [-117.0551, 32.60406], [-117.0551, 32.60413], [-117.05514, 32.60418], [-117.05488, 32.60426], [-117.05479, 32.60407], [-117.05481, 32.60406], [-117.05471, 32.6038], [-117.05489, 32.60376], [-117.055, 32.60402], [-117.05519, 32.60397]]]} | Open Access 1 | 7844 | Sherwood Park | 25399 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/sherwood-park | San Diego 4 | 0.291 | Sherwood Park | 0 | Local Park 2 | 4 |
7718 | 7718 | 7717 | {"type": "Polygon", "coordinates": [[[-117.02906, 32.64765], [-117.02832, 32.64831], [-117.02811, 32.64847], [-117.02788, 32.64862], [-117.02762, 32.64875], [-117.02735, 32.64885], [-117.02707, 32.64894], [-117.02674, 32.64902], [-117.02678, 32.64886], [-117.02654, 32.64817], [-117.02689, 32.64808], [-117.02734, 32.64789], [-117.02738, 32.64789], [-117.02755, 32.64776], [-117.02759, 32.64776], [-117.02776, 32.64762], [-117.0278, 32.64763], [-117.02797, 32.64749], [-117.02812, 32.64752], [-117.02815, 32.64756], [-117.02836, 32.64762], [-117.02838, 32.64764], [-117.02869, 32.64767], [-117.02872, 32.64769], [-117.02896, 32.64763], [-117.02904, 32.64763], [-117.02906, 32.64765]]]} | Open Access 1 | 7834 | Marisol Park | 21868 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/marisol-park | San Diego 4 | 4.661 | Marisol Park | 0 | Local Park 2 | 4 |
7717 | 7717 | 7716 | {"type": "Polygon", "coordinates": [[[-117.05366, 32.59768], [-117.05361, 32.59768], [-117.05329, 32.59759], [-117.05329, 32.59744], [-117.0533, 32.59742], [-117.05335, 32.59739], [-117.05366, 32.59738], [-117.05366, 32.59768]]]} | Open Access 1 | 7832 | Holiday Estates I Park | 30009 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/holiday-estates-i-park | San Diego 4 | 0.243 | Holiday Estates I Park | 0 | Local Park 2 | 4 |
7713 | 7713 | 7712 | {"type": "Polygon", "coordinates": [[[-116.99159, 32.62877], [-116.99156, 32.63051], [-116.99151, 32.63053], [-116.99042, 32.63052], [-116.99007, 32.63055], [-116.99003, 32.63055], [-116.99, 32.63052], [-116.98997, 32.63018], [-116.98997, 32.6297], [-116.98999, 32.6293], [-116.99003, 32.62916], [-116.99003, 32.62908], [-116.99, 32.62902], [-116.98989, 32.62895], [-116.98992, 32.62892], [-116.98993, 32.62876], [-116.99053, 32.62875], [-116.99159, 32.62877]]]} | Open Access 1 | 7798 | Harvest Park | 19721 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/harvest-park | San Diego 4 | 7.303 | Harvest Park | 0 | Local Park 2 | 4 |
7712 | 7712 | 7711 | {"type": "Polygon", "coordinates": [[[-117.06959, 32.6096], [-117.06886, 32.6098], [-117.06833, 32.60844], [-117.06839, 32.60841], [-117.06829, 32.60816], [-117.06911, 32.60793], [-117.06953, 32.60903], [-117.0694, 32.60909], [-117.06959, 32.6096]]]} | Open Access 1 | 7791 | Lauderbach Park | 21083 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/lauderbach-park | San Diego 4 | 3.819 | Lauderbach Park | 0 | Local Park 2 | 4 |
7711 | 7711 | 7710 | {"type": "Polygon", "coordinates": [[[-116.99759, 32.65572], [-116.99525, 32.65807], [-116.99418, 32.65763], [-116.99362, 32.65738], [-116.99358, 32.65732], [-116.99387, 32.65684], [-116.99422, 32.65698], [-116.99435, 32.65678], [-116.9947, 32.65639], [-116.99492, 32.65576], [-116.99759, 32.65572]]]} | Open Access 1 | 7787 | Bonita Long Canyon Park | 16260 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/bonita-long-canyon-park | San Diego 4 | 12.067 | Bonita Long Canyon Park | 0 | Local Park 2 | 4 |
7709 | 7709 | 7708 | {"type": "Polygon", "coordinates": [[[-116.96371, 32.63329], [-116.9623, 32.6344], [-116.96036, 32.63265], [-116.96174, 32.63156], [-116.96371, 32.63329]]]} | Open Access 1 | 7835 | Sunset View Park | 26067 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/sunset-view-park | San Diego 4 | 11.765 | Sunset View Park | 0 | Local Park 2 | 4 |
7708 | 7708 | 7707 | {"type": "Polygon", "coordinates": [[[-117.03368, 32.63514], [-117.03287, 32.63536], [-117.0321, 32.63482], [-117.03214, 32.63476], [-117.03243, 32.6349], [-117.03266, 32.63458], [-117.03359, 32.63505], [-117.03368, 32.63514]]]} | Open Access 1 | 7772 | Undeveloped Park | 26653 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 1.435 | Undeveloped 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]);