units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where ACCESS_TYP = 1 and AGNCY_NAME = 86
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Park 15
- Local Recreation Area 7
- None 1
MNG_AG_TYP 1
- City Agency 23
MNG_AGENCY 1
ACCESS_TYP 1
- Open Access · 23 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
240 | 240 | 239 | {"type": "Polygon", "coordinates": [[[-117.08384, 33.16747], [-117.08271, 33.16759], [-117.08326, 33.16655], [-117.08332, 33.16648], [-117.08345, 33.1664], [-117.08359, 33.16635], [-117.08368, 33.16634], [-117.08367, 33.16648], [-117.08368, 33.16662], [-117.08384, 33.16747]]]} | Open Access 1 | 645 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 2.034 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
1730 | 1730 | 1729 | {"type": "Polygon", "coordinates": [[[-117.08435, 33.17012], [-117.08438, 33.17027], [-117.08433, 33.17032], [-117.082, 33.17124], [-117.08208, 33.17105], [-117.08221, 33.17108], [-117.08271, 33.17089], [-117.08333, 33.17055], [-117.0842, 33.17013], [-117.08435, 33.17012]]]} | Open Access 1 | 12924 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 0.911 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
1736 | 1736 | 1735 | {"type": "Polygon", "coordinates": [[[-117.10161, 33.14781], [-117.10054, 33.14783], [-117.10058, 33.14924], [-117.09922, 33.14927], [-117.09919, 33.14852], [-117.09833, 33.14853], [-117.09826, 33.14822], [-117.09916, 33.14747], [-117.09914, 33.1465], [-117.09734, 33.14653], [-117.09741, 33.14629], [-117.0975, 33.14628], [-117.09751, 33.14626], [-117.09905, 33.14625], [-117.10077, 33.14621], [-117.10158, 33.14671], [-117.10161, 33.14781]]]} | Open Access 1 | 12943 | Rod McLeod Park | 24547 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/rod-mcleod-park.aspx | San Diego 4 | 17.211 | Rod McLeod Park | 0 | Local Park 2 | 4 |
3820 | 3820 | 3819 | {"type": "Polygon", "coordinates": [[[-117.07294, 33.13624], [-117.07138, 33.13696], [-117.07093, 33.13639], [-117.07125, 33.13623], [-117.07102, 33.13594], [-117.07231, 33.13531], [-117.07294, 33.13624]]]} | Open Access 1 | 45221 | Grove Park | 19534 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/grove-park.aspx | San Diego 4 | 4.561 | Grove Park | 0 | Local Park 2 | 4 |
4198 | 4198 | 4197 | {"type": "Polygon", "coordinates": [[[-117.03223, 33.15748], [-117.03217, 33.15759], [-117.0322, 33.15761], [-117.03147, 33.15902], [-117.03133, 33.15897], [-117.03144, 33.15869], [-117.0315, 33.15844], [-117.03159, 33.15746], [-117.03223, 33.15748]]]} | Open Access 1 | 47689 | Mayflower Dog Park | 31425 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/mayflower-dog-park.aspx | San Diego 4 | 1.445 | Mayflower Dog Park | 0 | Local Park 2 | 4 |
4913 | 4913 | 4912 | {"type": "Polygon", "coordinates": [[[-117.0835, 33.16545], [-117.08297, 33.16569], [-117.08281, 33.16578], [-117.08258, 33.16596], [-117.0824, 33.16616], [-117.0823, 33.16631], [-117.08099, 33.1689], [-117.08055, 33.16784], [-117.08057, 33.16783], [-117.0806, 33.16791], [-117.08073, 33.16802], [-117.08107, 33.16808], [-117.08126, 33.1679], [-117.0813, 33.16781], [-117.08104, 33.16772], [-117.08106, 33.16768], [-117.08136, 33.16777], [-117.08181, 33.16687], [-117.08187, 33.16673], [-117.0819, 33.16659], [-117.08189, 33.16635], [-117.0818, 33.16611], [-117.08154, 33.16625], [-117.08156, 33.16621], [-117.08344, 33.16511], [-117.0835, 33.16545]]]} | Open Access 1 | 12921 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 3.546 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
4915 | 4915 | 4914 | {"type": "Polygon", "coordinates": [[[-117.08135, 33.16636], [-117.08112, 33.1665], [-117.08077, 33.16723], [-117.08057, 33.16742], [-117.08047, 33.16756], [-117.08057, 33.16782], [-117.08055, 33.16784], [-117.0802, 33.167], [-117.08128, 33.16637], [-117.08135, 33.16636]]]} | Open Access 1 | 12925 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 1.075 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
5824 | 5824 | 5823 | {"type": "Polygon", "coordinates": [[[-117.0387, 33.12652], [-117.03852, 33.12705], [-117.03677, 33.12981], [-117.03458, 33.12979], [-117.03462, 33.12717], [-117.03548, 33.12719], [-117.03508, 33.12661], [-117.03508, 33.12642], [-117.0387, 33.12652]]]} | Open Access 1 | 677 | Mountain View Park | 22554 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/mountain-view-park.aspx | San Diego 4 | 26.279 | Mtn. View Park | 0 | Local Park 2 | 4 |
5919 | 5919 | 5918 | {"type": "Polygon", "coordinates": [[[-117.09, 33.11459], [-117.0896, 33.11481], [-117.0887, 33.11354], [-117.08925, 33.11325], [-117.09, 33.11432], [-117.08987, 33.1144], [-117.09, 33.11459]]]} | Open Access 1 | 406 | Westside Park | 27425 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/westside-park.aspx | San Diego 4 | 2.35 | Westside Park | 0 | Local Park 2 | 4 |
6001 | 6001 | 6000 | {"type": "Polygon", "coordinates": [[[-117.0646, 33.13353], [-117.06399, 33.13352], [-117.06374, 33.13349], [-117.0637, 33.13339], [-117.06346, 33.13339], [-117.06325, 33.1334], [-117.063, 33.13347], [-117.06278, 33.13357], [-117.06261, 33.13369], [-117.06193, 33.13449], [-117.06258, 33.13619], [-117.06094, 33.13717], [-117.06087, 33.13699], [-117.06045, 33.13543], [-117.06028, 33.13504], [-117.0605, 33.13496], [-117.06093, 33.13475], [-117.06131, 33.1345], [-117.06178, 33.13412], [-117.06178, 33.13408], [-117.0623, 33.13348], [-117.0626, 33.13322], [-117.06264, 33.13326], [-117.06278, 33.13319], [-117.06292, 33.13314], [-117.06325, 33.13308], [-117.06358, 33.13309], [-117.06359, 33.13306], [-117.06426, 33.13311], [-117.0646, 33.13353]]]} | Open Access 1 | 648 | Washington Park | 27275 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/washington-park.aspx | San Diego 4 | 12.694 | Washington Park | 0 | Local Park 2 | 4 |
6021 | 6021 | 6020 | {"type": "Polygon", "coordinates": [[[-117.09032, 33.16855], [-117.09013, 33.16916], [-117.08888, 33.17318], [-117.08881, 33.17309], [-117.08922, 33.17174], [-117.08935, 33.17106], [-117.08962, 33.17044], [-117.08971, 33.17017], [-117.08973, 33.16987], [-117.08969, 33.16963], [-117.08924, 33.16964], [-117.08917, 33.16947], [-117.08972, 33.1694], [-117.08988, 33.16933], [-117.08991, 33.16921], [-117.08957, 33.16847], [-117.08962, 33.16834], [-117.08975, 33.16834], [-117.08977, 33.16836], [-117.08986, 33.16835], [-117.09023, 33.16843], [-117.09032, 33.16855]]]} | Open Access 1 | 694 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 2.827 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
6609 | 6609 | 6608 | {"type": "MultiPolygon", "coordinates": [[[[-117.07366, 33.14302], [-117.07241, 33.14377], [-117.07258, 33.14401], [-117.07228, 33.1442], [-117.07215, 33.14401], [-117.07213, 33.14393], [-117.07214, 33.14388], [-117.07218, 33.14383], [-117.07345, 33.14309], [-117.07348, 33.14302], [-117.07348, 33.14298], [-117.07334, 33.1428], [-117.07341, 33.14274], [-117.07366, 33.14302]]], [[[-117.07383, 33.1458], [-117.07359, 33.14592], [-117.07354, 33.14584], [-117.07346, 33.14587], [-117.07256, 33.14458], [-117.07228, 33.14474], [-117.07225, 33.14467], [-117.07248, 33.14453], [-117.07248, 33.14448], [-117.07238, 33.14433], [-117.07266, 33.14415], [-117.07383, 33.1458]]]]} | Open Access 1 | 4170 | El Norte Park | 18522 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/el-norte-park.aspx | San Diego 4 | 2.406 | El Norte Park | 0 | Local Park 2 | 4 |
6680 | 6680 | 6679 | {"type": "Polygon", "coordinates": [[[-117.0696, 33.07388], [-117.06955, 33.07528], [-117.06859, 33.07537], [-117.06861, 33.07532], [-117.06859, 33.07526], [-117.06853, 33.07522], [-117.06844, 33.07522], [-117.0684, 33.07524], [-117.06834, 33.07529], [-117.06836, 33.07536], [-117.0684, 33.07541], [-117.06751, 33.07607], [-117.06746, 33.07642], [-117.06738, 33.07674], [-117.06728, 33.07693], [-117.06669, 33.0783], [-117.06684, 33.07836], [-117.06684, 33.08016], [-117.06724, 33.08017], [-117.06724, 33.08071], [-117.06727, 33.08106], [-117.06726, 33.08271], [-117.06242, 33.08188], [-117.06247, 33.08295], [-117.06255, 33.08402], [-117.06256, 33.0847], [-117.06239, 33.08465], [-117.06222, 33.08464], [-117.06204, 33.08466], [-117.06187, 33.08472], [-117.06173, 33.08482], [-117.06157, 33.085], [-117.06149, 33.08491], [-117.0611, 33.08424], [-117.06065, 33.08347], [-117.06058, 33.08332], [-117.06057, 33.08324], [-117.06059, 33.0823], [-117.06106, 33.08167], [-117.06106, 33.08165], [-117.05982, 33.08144], [-117.05954, 33.08279], [-117.05659, 33.08229], [-117.05686, 33.08093], [-117.05755, 33.07775], [-117.05763, 33.07737], [-117.05775, 33.07701], [-117.05893, 33.07405], [-117.06037, 33.07055], [-117.06068, 33.06987], [-117.06079, 33.0699], [-117.06093, 33.0696], [-117.06107, 33.06938], [-117.0666, 33.07404], [-117.06715, 33.07426], [-117.06752, 33.07433], [-117.06788, 33.07435], [-117.0682, 33.07433], [-117.0685, 33.07426], [-117.0696, 33.07388]]]} | Open Access 1 | 4952 | Kit Carson Park | 3581 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/kit-carson-park.aspx | San Diego 4 | 266.929 | Kit Carson Park | 0 | Local Park 2 | 4 |
7596 | 7596 | 7595 | {"type": "Polygon", "coordinates": [[[-117.06814, 33.09539], [-117.06642, 33.09508], [-117.06657, 33.0945], [-117.06594, 33.09413], [-117.06589, 33.09394], [-117.06597, 33.09372], [-117.06597, 33.09333], [-117.06587, 33.09317], [-117.06558, 33.09294], [-117.06558, 33.09234], [-117.06519, 33.09203], [-117.06485, 33.09148], [-117.06459, 33.0906], [-117.06431, 33.09019], [-117.06367, 33.08997], [-117.06336, 33.0886], [-117.06291, 33.08778], [-117.06237, 33.08737], [-117.06182, 33.08668], [-117.0615, 33.08596], [-117.06085, 33.08598], [-117.06106, 33.08588], [-117.06119, 33.0858], [-117.06138, 33.08563], [-117.0615, 33.08547], [-117.06172, 33.08508], [-117.06179, 33.08499], [-117.06189, 33.08491], [-117.06219, 33.08556], [-117.06249, 33.08579], [-117.06308, 33.08611], [-117.06376, 33.08623], [-117.06343, 33.08657], [-117.06317, 33.08654], [-117.06288, 33.08656], [-117.06295, 33.08689], [-117.06326, 33.08714], [-117.06367, 33.08793], [-117.06408, 33.08816], [-117.06454, 33.08864], [-117.06536, 33.08865], [-117.06536, 33.08901], [-117.06542, 33.08949], [-117.06528, 33.0895], [-117.06478, 33.0893], [-117.06469, 33.08945], [-117.0651, 33.09035], [-117.06571, 33.09133], [-117.06634, 33.09192], [-117.06571, 33.09167], [-117.0657, 33.09168], [-117.06577, 33.09193], [-117.06601, 33.09227], [-117.0662, 33.09267], [-117.0667, 33.0933], [-117.06699, 33.09335], [-117.06692, 33.09368], [-117.06748, 33.094], [-117.06747, 33.09404], [-117.06691, 33.09424], [-117.06695, 33.09458], [-117.06734, 33.09493], [-117.06776, 33.09498], [-117.06803, 33.09517], [-117.06814, 33.09539]]]} | Open Access 1 | 7306 | Kit Carson Park | 3581 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/kit-carson-park.aspx | San Diego 4 | 26.619 | Kit Carson Park | 0 | Local Park 2 | 4 |
8355 | 8355 | 8354 | {"type": "MultiPolygon", "coordinates": [[[[-117.02058, 33.16665], [-117.01805, 33.16641], [-117.01794, 33.16623], [-117.01779, 33.16609], [-117.01764, 33.16601], [-117.01734, 33.16591], [-117.01725, 33.16585], [-117.01715, 33.16574], [-117.01709, 33.16561], [-117.01701, 33.16528], [-117.01685, 33.16487], [-117.01683, 33.16462], [-117.0168, 33.16448], [-117.01674, 33.16435], [-117.01667, 33.16425], [-117.01658, 33.16416], [-117.01643, 33.16407], [-117.01628, 33.16402], [-117.01611, 33.164], [-117.01599, 33.16401], [-117.01584, 33.16405], [-117.01573, 33.1641], [-117.01562, 33.16417], [-117.0155, 33.16432], [-117.01533, 33.16465], [-117.01523, 33.16475], [-117.01514, 33.16481], [-117.01376, 33.16536], [-117.01358, 33.16545], [-117.01342, 33.16548], [-117.01281, 33.16553], [-117.0123, 33.16563], [-117.01206, 33.1657], [-117.0119, 33.16577], [-117.01177, 33.16586], [-117.01159, 33.16602], [-117.01141, 33.16611], [-117.01127, 33.16615], [-117.01059, 33.16625], [-117.01011, 33.16638], [-117.00974, 33.16654], [-117.00911, 33.16688], [-117.00845, 33.16715], [-117.0078, 33.16703], [-117.0074, 33.16693], [-117.00716, 33.16684], [-117.00688, 33.16669], [-117.00617, 33.16642], [-117.00598, 33.16639], [-117.00552, 33.16639], [-117.00536, 33.16636], [-117.00524, 33.16631], [-117.00495, 33.1661], [-117.00484, 33.16605], [-117.00468, 33.16602], [-117.00444, 33.16603], [-117.00417, 33.16612], [-117.00381, 33.1662], [-117.00368, 33.16626], [-117.00335, 33.1665], [-117.00311, 33.16663], [-117.003, 33.16665], [-117.0026, 33.16663], [-117.00246, 33.16665], [-117.00235, 33.1667], [-117.00233, 33.16444], [-117.00669, 33.16416], [-117.01268, 33.16299], [-117.01479, 33.16263], [-117.01957, 33.16279], [-117.02058, 33.16665]]], [[[-117.0181, 33.17002], [-117.01749, 33.16997], [-117.01752, 33.16978], [-117.0159, 33.16621], [-117.00749, 33.16844], [-117.00764, 33.1682], [-117.00786, 33.16793], [-117.00839, 33.1674], [-117.00861, 33.16726], [-117.00924, 33.16701], [-117.00983, 33.16668], [-117.01017, 33.16654], [-117.01064, 33.16641], [-117.01128, 33.16632], [-117.01151, 33.16625], [-117.01172, 33.16614], [-117.01199, 33.16592], [-117.01221, 33.16583], [-117.01271, 33.16571], [-117.01291, 33.16568], [-117.01348, 33.16564], [-117.01374, 33.16557], [-117.01387, 33.1655], [-117.01525, 33.16495], [-117.01538, 33.16486], [-117.01549, 33.16474], [-117.01569, 33.16438], [-117.01577, 33.16428], [-117.01596, 33.16419], [-117.01607, 33.16417], [-117.01618, 33.16417], [-117.01631, 33.1642], [-117.01642, 33.16426], [-117.01651, 33.16434], [-117.01658, 33.16444], [-117.01663, 33.16463], [-117.01664, 33.16481], [-117.01666, 33.16493], [-117.01683, 33.16534], [-117.01691, 33.16569], [-117.01699, 33.16584], [-117.01708, 33.16594], [-117.0172, 33.16603], [-117.01735, 33.16611], [-117.01757, 33.16617], [-117.01771, 33.16626], [-117.01781, 33.16637], [-117.018, 33.16673], [-117.0181, 33.17002]]], [[[-117.00051, 33.17509], [-117.00052, 33.17525], [-117.00049, 33.17543], [-117.00042, 33.17559], [-117.00034, 33.17571], [-117.00034, 33.17544], [-117.00024, 33.17534], [-117.00051, 33.17509]]], [[[-117.00669, 33.17565], [-117.0026, 33.17584], [-117.0004, 33.17594], [-117.00058, 33.1757], [-117.00069, 33.17544], [-117.00071, 33.17529], [-117.00071, 33.17517], [-117.00068, 33.17493], [-117.00284, 33.17286], [-117.00303, 33.17269], [-117.00453, 33.17118], [-117.00665, 33.16939], [-117.00669, 33.17565]]], [[[-116.99737, 33.17557], [-116.99612, 33.176], [-116.9957, 33.17599], [-116.9957, 33.17655], [-116.99461, 33.17656], [-116.99425, 33.17734], [-116.99399, 33.17734], [-116.99398, 33.17596], [-116.99386, 33.17595], [-116.99407, 33.17572], [-116.99423, 33.1756], [-116.99439, 33.1755], [-116.9947, 33.17538], [-116.99504, 33.1753], [-116.99645, 33.17526], [-116.99671, 33.17529], [-116.99696, 33.17536], [-116.99719, 33.17546], [-116.99737, 33.17557]]], [[[-116.97995, 33.16806], [-116.989, 33.16827], [-116.98907, 33.17206], [-116.99359, 33.17216], [-116.9936, 33.17215], [-116.99354, 33.16838], [-116.99528, 33.16841], [-116.99531, 33.16829], [-116.99535, 33.16808], [-116.99537, 33.16764], [-116.99533, 33.167], [-116.99535, 33.16665], [-116.99532, 33.16649], [-116.99524, 33.16629], [-116.99524, 33.16624], [-116.99526, 33.16614], [-116.9953, 33.16608], [-116.99544, 33.16617], [-116.99552, 33.16612], [-116.99568, 33.16606], [-116.99598, 33.166], [-116.99622, 33.166], [-116.99663, 33.16605], [-116.99694, 33.16614], [-116.99782, 33.16649], [-116.99804, 33.16662], [-116.99809, 33.16848], [-117.00235, 33.16858], [-117.00236, 33.16693], [-117.00248, 33.16686], [-117.00261, 33.16682], [-117.00301, 33.16685], [-117.00322, 33.16681], [-117.00347, 33.16668], [-117.00388, 33.16639], [-117.00416, 33.16633], [-117.00456, 33.16621], [-117.00468, 33.16621], [-117.00482, 33.16626], [-117.00511, 33.16647], [-117.00531, 33.16656], [-117.00547, 33.16659], [-117.00595, 33.16659], [-117.00609, 33.16661], [-117.00675, 33.16685], [-117.00707, 33.16702], [-117.00729, 33.16711], [-117.00761, 33.16719], [-117.00823, 33.1673], [-117.00757, 33.16798], [-117.00744, 33.16816], [-117.00721, 33.16852], [-117.00663, 33.16868], [-117.00665, 33.16915], [-117.00456, 33.17091], [-117.0041, 33.17135], [-117.00289, 33.17258], [-117.00269, 33.17275], [-117.0006, 33.17475], [-117.0005, 33.1746], [-117.00038, 33.17447], [-117.00014, 33.17429], [-116.99995, 33.17418], [-116.99988, 33.17427], [-117.00009, 33.17443], [-117.0003, 33.17463], [-117.0004, 33.17476], [-117.00046, 33.17489], [-117.00011, 33.17521], [-116.99991, 33.17502], [-116.99965, 33.17519], [-116.99953, 33.17526], [-116.99935, 33.17539], [-116.99915, 33.17573], [-116.99889, 33.176], [-116.9985, 33.17602], [-116.99795, 33.17584], [-116.99782, 33.17574], [-116.99764, 33.17556], [-116.99739, 33.17538], [-116.9971, 33.17523], [-116.9968, 33.17513], [-116.99659, 33.1751], [-116.9964, 33.17509], [-116.99502, 33.17514], [-116.99482, 33.17517], [-116.99457, 33.17524], [-116.99429, 33.17536], [-116.99405, 33.17551], [-116.99381, 33.17573], [-116.99352, 33.17612], [-116.99323, 33.17663], [-116.99305, 33.17704], [-116.99288, 33.17753], [-116.99278, 33.17771], [-116.99267, 33.17784], [-116.99252, 33.17797], [-116.99235, 33.17807], [-116.99214, 33.17815], [-116.99197, 33.17819], [-116.99173, 33.17821], [-116.99153, 33.17819], [-116.99134, 33.17815], [-116.99105, 33.17803], [-116.99068, 33.17777], [-116.99091, 33.17777], [-116.9909, 33.17762], [-116.99056, 33.17762], [-116.99055, 33.17769], [-116.99031, 33.17756], [-116.99006, 33.17748], [-116.98983, 33.17743], [-116.98953, 33.1774], [-116.98924, 33.17742], [-116.98481, 33.17812], [-116.98453, 33.1782], [-116.98434, 33.17828], [-116.98267, 33.1792], [-116.98233, 33.17933], [-116.98198, 33.17941], [-116.98159, 33.17945], [-116.98128, 33.17944], [-116.98045, 33.17938], [-116.98016, 33.17938], [-116.9798, 33.17943], [-116.97547, 33.18047], [-116.97495, 33.18064], [-116.97449, 33.18081], [-116.97223, 33.18185], [-116.9721, 33.18192], [-116.97179, 33.18098], [-116.97175, 33.18082], [-116.97173, 33.18067], [-116.97171, 33.17842], [-116.97168, 33.17826], [-116.97163, 33.17811], [-116.97149, 33.17789], [-116.97144, 33.17211], [-116.97138, 33.1682], [-116.97995, 33.16806]], [[-116.98024, 33.17565], [-116.98252, 33.17572], [-116.98469, 33.17575], [-116.98467, 33.1742], [-116.98462, 33.17198], [-116.98009, 33.17189], [-116.97577, 33.17201], [-116.97583, 33.17577], [-116.98024, 33.17565]], [[-116.99575, 33.1674], [-116.99574, 33.16734], [-116.9957, 33.16729], [-116.99557, 33.16724], [-116.99559, 33.16764], [-116.99564, 33.16764], [-116.9957, 33.16758], [-116.99574, 33.16748], [-116.99575, 33.1674]]], [[[-116.97193, 33.18205], [-116.97174, 33.18227], [-116.97157, 33.18261], [-116.97154, 33.18077], [-116.97159, 33.18099], [-116.97193, 33.18205]]], [[[-116.98479, 33.17976], [-116.98039, 33.17976], [-116.98052, 33.18323], [-116.9716, 33.18333], [-116.97168, 33.1829], [-116.97182, 33.18253], [-116.97198, 33.18227], [-116.97217, 33.18208], [-116.97233, 33.18199], [-116.97449, 33.181], [-116.97497, 33.18081], [-116.97549, 33.18064], [-116.97987, 33.17959], [-116.98018, 33.17955], [-116.98047, 33.17954], [-116.98135, 33.17961], [-116.9816, 33.17961], [-116.98192, 33.17959], [-116.98223, 33.17953], [-116.98247, 33.17946], [-116.98276, 33.17935], [-116.98443, 33.17843], [-116.98475, 33.17831], [-116.98479, 33.17976]]]]} | Open Access 1 | 12876 | Lake Wohlford | 3582 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/lake-wohlford.aspx | San Diego 4 | 994.039 | Lake Wohlford | 0 | None 698 | |
8356 | 8356 | 8355 | {"type": "MultiPolygon", "coordinates": [[[[-117.09708, 33.16732], [-117.09706, 33.17024], [-117.09686, 33.17014], [-117.09662, 33.16997], [-117.09644, 33.16979], [-117.09629, 33.16963], [-117.09607, 33.16945], [-117.09576, 33.16927], [-117.09545, 33.16914], [-117.09507, 33.16905], [-117.09338, 33.16882], [-117.09084, 33.16831], [-117.09077, 33.16829], [-117.09074, 33.16825], [-117.09079, 33.16805], [-117.09158, 33.16551], [-117.09168, 33.1657], [-117.09241, 33.16684], [-117.09253, 33.16709], [-117.09271, 33.16755], [-117.09662, 33.16732], [-117.09708, 33.16732]]], [[[-117.09282, 33.16732], [-117.09271, 33.16703], [-117.0926, 33.1668], [-117.09181, 33.16555], [-117.09175, 33.16542], [-117.09171, 33.16529], [-117.09171, 33.16512], [-117.09173, 33.16497], [-117.09216, 33.1636], [-117.0928, 33.16358], [-117.09277, 33.16628], [-117.09281, 33.16683], [-117.09282, 33.16732]]]]} | Open Access 1 | 12877 | Jesmond Dene Park | 20402 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/jesmond-dene-park.aspx | San Diego 4 | 35.52 | Jesmond Dene Park | 0 | Local Park 2 | 4 |
8358 | 8358 | 8357 | {"type": "MultiPolygon", "coordinates": [[[[-117.0235, 33.18061], [-117.02198, 33.18058], [-117.02185, 33.18209], [-117.01695, 33.182], [-117.01667, 33.18516], [-117.02064, 33.18522], [-117.02055, 33.18593], [-117.0206, 33.18692], [-117.02084, 33.18697], [-117.02093, 33.18703], [-117.02101, 33.1871], [-117.02071, 33.18786], [-117.02031, 33.1882], [-117.01901, 33.18856], [-117.01887, 33.18905], [-117.01629, 33.18892], [-117.01173, 33.18943], [-117.012, 33.18566], [-117.00673, 33.18622], [-117.00675, 33.1825], [-117.00758, 33.1824], [-117.00672, 33.17921], [-117.01206, 33.1785], [-117.01181, 33.17495], [-117.01664, 33.17427], [-117.01804, 33.1742], [-117.01823, 33.17782], [-117.01684, 33.17787], [-117.01693, 33.17965], [-117.02342, 33.17978], [-117.0235, 33.18061]]], [[[-117.0311, 33.19001], [-117.03109, 33.1903], [-117.03104, 33.19066], [-117.03096, 33.191], [-117.03086, 33.1913], [-117.03064, 33.1917], [-117.0303, 33.19203], [-117.03011, 33.19229], [-117.03004, 33.19243], [-117.02998, 33.19261], [-117.02992, 33.19294], [-117.02994, 33.19324], [-117.03012, 33.19381], [-117.03017, 33.19421], [-117.03022, 33.19449], [-117.03073, 33.19651], [-117.02907, 33.19653], [-117.02882, 33.19303], [-117.02401, 33.19292], [-117.0228, 33.1853], [-117.02792, 33.18527], [-117.02842, 33.18552], [-117.0292, 33.18595], [-117.02954, 33.18618], [-117.02985, 33.18646], [-117.03007, 33.18673], [-117.03027, 33.18708], [-117.03033, 33.18724], [-117.03034, 33.18765], [-117.03044, 33.18813], [-117.03055, 33.18846], [-117.03066, 33.1887], [-117.03082, 33.18898], [-117.03098, 33.18921], [-117.03107, 33.18965], [-117.0311, 33.19001]]], [[[-117.03375, 33.18167], [-117.02735, 33.18149], [-117.02744, 33.17411], [-117.0325, 33.17429], [-117.03375, 33.18167]]], [[[-117.03367, 33.19279], [-117.03365, 33.19649], [-117.03112, 33.19651], [-117.0309, 33.19553], [-117.03072, 33.19429], [-117.0306, 33.19394], [-117.03043, 33.19361], [-117.03047, 33.19318], [-117.03054, 33.19284], [-117.03062, 33.19257], [-117.03073, 33.1923], [-117.03093, 33.19188], [-117.03113, 33.19178], [-117.03136, 33.19162], [-117.03155, 33.19145], [-117.03169, 33.19128], [-117.0318, 33.1911], [-117.03189, 33.19085], [-117.03193, 33.19064], [-117.03194, 33.19045], [-117.0319, 33.19021], [-117.03182, 33.18998], [-117.03146, 33.18936], [-117.03094, 33.18761], [-117.0306, 33.18696], [-117.03054, 33.18678], [-117.03276, 33.18678], [-117.03278, 33.18594], [-117.0299, 33.18594], [-117.02964, 33.18577], [-117.02928, 33.18549], [-117.02896, 33.18528], [-117.03365, 33.18523], [-117.03358, 33.19275], [-117.03367, 33.19276], [-117.03367, 33.19279]]], [[[-117.03073, 33.18827], [-117.03063, 33.18814], [-117.03057, 33.188], [-117.03055, 33.18785], [-117.03058, 33.18771], [-117.03073, 33.18827]]], [[[-117.03146, 33.19016], [-117.03157, 33.1903], [-117.03164, 33.19048], [-117.03166, 33.19067], [-117.03164, 33.19081], [-117.03157, 33.19099], [-117.03146, 33.19114], [-117.03133, 33.19126], [-117.03115, 33.19137], [-117.03128, 33.19096], [-117.03137, 33.1905], [-117.03146, 33.19016]]]]} | Open Access 1 | 12952 | Daley Ranch | 3569 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/daley-ranch.aspx | San Diego 4 | 683.571 | Daley Ranch | 0 | Local Park 2 | 4 |
9911 | 9911 | 9910 | {"type": "Polygon", "coordinates": [[[-117.08784, 33.16292], [-117.08766, 33.16301], [-117.08764, 33.16311], [-117.08733, 33.16327], [-117.08703, 33.1634], [-117.08533, 33.16436], [-117.08531, 33.16463], [-117.08614, 33.16695], [-117.08671, 33.16777], [-117.08676, 33.16801], [-117.08668, 33.16843], [-117.08677, 33.16863], [-117.08682, 33.16885], [-117.08701, 33.16933], [-117.08698, 33.16938], [-117.08688, 33.16936], [-117.08685, 33.16937], [-117.08646, 33.16833], [-117.08611, 33.16841], [-117.08592, 33.16863], [-117.08565, 33.16874], [-117.08537, 33.16882], [-117.08451, 33.16922], [-117.0843, 33.16813], [-117.08477, 33.16806], [-117.08548, 33.16786], [-117.08572, 33.16781], [-117.08576, 33.16782], [-117.08605, 33.16771], [-117.08616, 33.16749], [-117.08577, 33.16643], [-117.08575, 33.1663], [-117.08537, 33.16528], [-117.08428, 33.16511], [-117.08423, 33.16493], [-117.08413, 33.16472], [-117.08498, 33.16422], [-117.08497, 33.16419], [-117.0876, 33.16268], [-117.0877, 33.1627], [-117.08784, 33.16292]]]} | Open Access 1 | 643 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 12.097 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
10388 | 10388 | 10387 | {"type": "MultiPolygon", "coordinates": [[[[-117.02422, 33.17395], [-117.02382, 33.17469], [-117.02359, 33.17522], [-117.02339, 33.17587], [-117.02328, 33.17642], [-117.02323, 33.17698], [-117.02323, 33.17743], [-117.02339, 33.17927], [-117.02339, 33.17941], [-117.02342, 33.17978], [-117.01693, 33.17966], [-117.01683, 33.17787], [-117.01823, 33.17781], [-117.01804, 33.1742], [-117.0227, 33.17392], [-117.02422, 33.17395]]], [[[-117.02816, 33.18488], [-117.02735, 33.18452], [-117.02678, 33.18418], [-117.0264, 33.18391], [-117.02509, 33.18283], [-117.02482, 33.18257], [-117.02456, 33.18228], [-117.02433, 33.18183], [-117.02414, 33.18135], [-117.02405, 33.18103], [-117.02398, 33.18069], [-117.02384, 33.17952], [-117.0239, 33.17901], [-117.02389, 33.17861], [-117.02354, 33.177], [-117.02355, 33.17686], [-117.02359, 33.17643], [-117.02365, 33.17611], [-117.02372, 33.17579], [-117.02385, 33.1754], [-117.02397, 33.1751], [-117.02411, 33.17479], [-117.02457, 33.17394], [-117.02744, 33.17411], [-117.02735, 33.18149], [-117.02816, 33.18488]]], [[[-117.02792, 33.18527], [-117.0228, 33.1853], [-117.02065, 33.18522], [-117.01666, 33.18517], [-117.01695, 33.182], [-117.02184, 33.18209], [-117.02198, 33.18058], [-117.0235, 33.18061], [-117.02358, 33.18096], [-117.02366, 33.18125], [-117.02378, 33.18154], [-117.02399, 33.18202], [-117.02427, 33.18256], [-117.02457, 33.18293], [-117.02475, 33.18311], [-117.02495, 33.18328], [-117.02764, 33.18511], [-117.02792, 33.18527]]], [[[-117.03344, 33.17983], [-117.03337, 33.17926], [-117.0329, 33.17667], [-117.03137, 33.16699], [-117.03668, 33.16697], [-117.03662, 33.16308], [-117.03431, 33.16304], [-117.03124, 33.16049], [-117.03122, 33.1605], [-117.03117, 33.16046], [-117.03109, 33.1606], [-117.03095, 33.16076], [-117.03083, 33.16085], [-117.03069, 33.16095], [-117.03046, 33.16104], [-117.03121, 33.15938], [-117.0313, 33.15909], [-117.03144, 33.15909], [-117.03219, 33.15762], [-117.03217, 33.1576], [-117.03218, 33.15757], [-117.0324, 33.15719], [-117.03252, 33.15704], [-117.03266, 33.1569], [-117.03316, 33.15649], [-117.03321, 33.15651], [-117.03331, 33.15639], [-117.0336, 33.1561], [-117.03381, 33.15586], [-117.03388, 33.15574], [-117.03416, 33.15539], [-117.03433, 33.15505], [-117.03441, 33.15478], [-117.03457, 33.15407], [-117.03456, 33.15406], [-117.03446, 33.15407], [-117.03448, 33.15399], [-117.03458, 33.15399], [-117.0347, 33.1535], [-117.03479, 33.15322], [-117.03482, 33.15323], [-117.03488, 33.15308], [-117.03502, 33.15287], [-117.03608, 33.1517], [-117.03622, 33.1515], [-117.03646, 33.15102], [-117.03644, 33.151], [-117.03691, 33.15007], [-117.0373, 33.1501], [-117.03637, 33.15199], [-117.03627, 33.15199], [-117.03536, 33.15301], [-117.03518, 33.15326], [-117.03507, 33.15354], [-117.03474, 33.15499], [-117.03462, 33.15535], [-117.03435, 33.15578], [-117.03655, 33.15578], [-117.03656, 33.15601], [-117.04976, 33.15607], [-117.04977, 33.15745], [-117.05143, 33.15747], [-117.05187, 33.15795], [-117.05191, 33.15957], [-117.054, 33.15964], [-117.05411, 33.16329], [-117.05231, 33.16327], [-117.0523, 33.16409], [-117.05254, 33.16456], [-117.05238, 33.16485], [-117.05268, 33.1653], [-117.05278, 33.16582], [-117.05255, 33.16596], [-117.05234, 33.16614], [-117.05211, 33.16637], [-117.05177, 33.16676], [-117.05176, 33.16694], [-117.05189, 33.16694], [-117.05189, 33.16683], [-117.05216, 33.1665], [-117.05248, 33.16618], [-117.05276, 33.16595], [-117.05278, 33.16595], [-117.05279, 33.16607], [-117.05295, 33.16632], [-117.05247, 33.16694], [-117.05247, 33.16695], [-117.05846, 33.16706], [-117.05839, 33.17069], [-117.06698, 33.17084], [-117.06699, 33.17824], [-117.06698, 33.17873], [-117.06706, 33.19256], [-117.07146, 33.19263], [-117.07149, 33.19617], [-117.07586, 33.19628], [-117.07625, 33.20344], [-117.08491, 33.20383], [-117.08542, 33.2073], [-117.08586, 33.21047], [-117.08596, 33.21105], [-117.07696, 33.21119], [-117.07616, 33.21123], [-117.07254, 33.21128], [-117.0714, 33.21128], [-117.06793, 33.21138], [-117.06481, 33.21153], [-117.06331, 33.21159], [-117.06316, 33.208], [-117.0638, 33.20798], [-117.06376, 33.20737], [-117.06314, 33.20737], [-117.06311, 33.20725], [-117.05865, 33.20738], [-117.05838, 33.19947], [-117.05384, 33.19955], [-117.05395, 33.20328], [-117.04948, 33.20339], [-117.04716, 33.20135], [-117.04708, 33.20127], [-117.04142, 33.19628], [-117.04531, 33.19617], [-117.0452, 33.18877], [-117.04507, 33.18192], [-117.04129, 33.18191], [-117.04129, 33.18513], [-117.03365, 33.18523], [-117.03368, 33.18189], [-117.03375, 33.18167], [-117.03344, 33.17983]], [[-117.06748, 33.20305], [-117.07192, 33.20326], [-117.0717, 33.19972], [-117.06729, 33.19958], [-117.06748, 33.20305]], [[-117.05388, 33.18883], [-117.054, 33.19608], [-117.06274, 33.19608], [-117.06263, 33.18865], [-117.05388, 33.18883]]]]} | Open Access 1 | 18344 | Daley Ranch | 3569 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/daley-ranch.aspx | San Diego 4 | 3711.855 | Daley Ranch | 0 | Local Park 2 | 4 |
10692 | 10692 | 10691 | {"type": "Polygon", "coordinates": [[[-117.08488, 33.12287], [-117.08464, 33.12304], [-117.08445, 33.1233], [-117.0846, 33.1235], [-117.0841, 33.12379], [-117.08436, 33.12439], [-117.08377, 33.12476], [-117.08317, 33.12528], [-117.08246, 33.12364], [-117.0847, 33.12257], [-117.08488, 33.12287]]]} | Open Access 1 | 19847 | Grape Day Park | 19446 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/grape-day-park.aspx | San Diego 4 | 7.661 | Grape Day 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]);