superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
16 rows where ACCESS_TYP = 1, MNG_AGENCY = 84, MNG_AG_ID = 1102 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 16 ✖
MNG_AGENCY 1
- Escondido, City of · 16 ✖
ACCESS_TYP 1
- Open Access · 16 ✖
| Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 565 | 565 | 564 | {"type": "MultiPolygon", "coordinates": [[[[-117.03073, 33.19651], [-117.02907, 33.19653], [-117.02882, 33.19303], [-117.02401, 33.19292], [-117.0228, 33.1853], [-117.02064, 33.18522], [-117.02055, 33.18593], [-117.0206, 33.18691], [-117.02084, 33.18697], [-117.02093, 33.18703], [-117.02101, 33.1871], [-117.02071, 33.18786], [-117.02031, 33.1882], [-117.01902, 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.00757, 33.18239], [-117.00672, 33.17921], [-117.01206, 33.1785], [-117.01181, 33.17495], [-117.01664, 33.17427], [-117.0227, 33.17392], [-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.17744], [-117.02339, 33.17927], [-117.02339, 33.17941], [-117.02342, 33.17978], [-117.0235, 33.18061], [-117.02358, 33.18096], [-117.02366, 33.18125], [-117.02378, 33.18155], [-117.02399, 33.18202], [-117.02427, 33.18255], [-117.02457, 33.18293], [-117.02475, 33.18311], [-117.02495, 33.18328], [-117.02764, 33.18511], [-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.18766], [-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.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.08596, 33.21105], [-117.07696, 33.21118], [-117.07616, 33.21123], [-117.07254, 33.21128], [-117.0714, 33.21128], [-117.06794, 33.21138], [-117.06481, 33.21153], [-117.06331, 33.21159], [-117.06316, 33.208], [-117.06379, 33.20798], [-117.06375, 33.20737], [-117.06314, 33.20737], [-117.06311, 33.20725], [-117.05865, 33.20738], [-117.05837, 33.19947], [-117.05385, 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.03358, 33.19274], [-117.03367, 33.19276], [-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.18595], [-117.0299, 33.18594], [-117.02964, 33.18577], [-117.02928, 33.18549], [-117.02896, 33.18528], [-117.03365, 33.18523], [-117.03368, 33.18189], [-117.03375, 33.18168], [-117.02736, 33.18149], [-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.02359, 33.17643], [-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.03252, 33.1743], [-117.03137, 33.16699], [-117.03667, 33.16696], [-117.03662, 33.16308], [-117.03431, 33.16304], [-117.03124, 33.1605], [-117.03122, 33.1605], [-117.03118, 33.16047], [-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.15908], [-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.15506], [-117.03441, 33.15478], [-117.03457, 33.15408], [-117.03456, 33.15406], [-117.03446, 33.15407], [-117.03448, 33.15399], [-117.03459, 33.15399], [-117.0347, 33.1535], [-117.03479, 33.15322], [-117.03482, 33.15322], [-117.03488, 33.15308], [-117.03502, 33.15287], [-117.03608, 33.1517], [-117.03622, 33.1515], [-117.03646, 33.15103], [-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.03436, 33.15578], [-117.03655, 33.15578], [-117.03657, 33.15601], [-117.04976, 33.15607], [-117.04978, 33.15744], [-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.05177, 33.16694], [-117.05188, 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.16693], [-117.05248, 33.16695], [-117.05846, 33.16706], [-117.0584, 33.17069], [-117.06698, 33.17084], [-117.06699, 33.17824], [-117.06698, 33.17873], [-117.06706, 33.19255], [-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.03332, 33.17901], [-117.0333, 33.17901], [-117.03337, 33.17934], [-117.03337, 33.17926], [-117.03332, 33.17901]], [[-117.05389, 33.18883], [-117.054, 33.19607], [-117.06273, 33.19608], [-117.06262, 33.18866], [-117.05389, 33.18883]], [[-117.06748, 33.20304], [-117.07191, 33.20325], [-117.0717, 33.19972], [-117.06729, 33.19959], [-117.06748, 33.20304]]], [[[-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 | Daley Ranch | http://www.escondido.org/daley-ranch.aspx | 3569 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 4396.82 | Daley Ranch | |
| 566 | 566 | 565 | {"type": "MultiPolygon", "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.06835, 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.07829], [-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.06243, 33.08189], [-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.08166], [-117.05982, 33.08145], [-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.06989], [-117.06093, 33.0696], [-117.06107, 33.06938], [-117.0666, 33.07404], [-117.06716, 33.07426], [-117.06752, 33.07433], [-117.06788, 33.07435], [-117.0682, 33.07433], [-117.0685, 33.07426], [-117.0696, 33.07388]]], [[[-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.09334], [-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.08589], [-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.08657], [-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.06537, 33.08901], [-117.06542, 33.08949], [-117.06528, 33.0895], [-117.06478, 33.0893], [-117.06469, 33.08946], [-117.0651, 33.09035], [-117.06571, 33.09133], [-117.06634, 33.09192], [-117.06571, 33.09168], [-117.0657, 33.09168], [-117.06577, 33.09193], [-117.06601, 33.09227], [-117.0662, 33.09267], [-117.06669, 33.09329], [-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 | Kit Carson Park | http://www.escondido.org/kit-carson-park.aspx | 3581 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 293.615 | Kit Carson Park | |
| 574 | 574 | 573 | {"type": "MultiPolygon", "coordinates": [[[[-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.99994, 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.9999, 33.17502], [-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.17573], [-116.99764, 33.17555], [-116.99739, 33.17538], [-116.9971, 33.17523], [-116.9968, 33.17513], [-116.99659, 33.1751], [-116.9964, 33.17509], [-116.99503, 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.17816], [-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.9909, 33.17777], [-116.9909, 33.17762], [-116.99057, 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.17743], [-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.17939], [-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.989, 33.16827], [-116.98907, 33.17206], [-116.99359, 33.17216], [-116.9936, 33.17215], [-116.99354, 33.16838], [-116.99528, 33.1684], [-116.99531, 33.16829], [-116.99535, 33.16808], [-116.99537, 33.16764], [-116.99533, 33.16701], [-116.99535, 33.16665], [-116.99532, 33.16649], [-116.99524, 33.1663], [-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.99623, 33.166], [-116.99663, 33.16605], [-116.99694, 33.16614], [-116.99782, 33.16649], [-116.99804, 33.16662], [-116.9981, 33.16848], [-117.00235, 33.16858], [-117.00236, 33.16693], [-117.00248, 33.16686], [-117.00261, 33.16683], [-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]], [[-116.98467, 33.1742], [-116.98461, 33.17198], [-116.98009, 33.17189], [-116.97577, 33.17202], [-116.97584, 33.17577], [-116.98024, 33.17565], [-116.98252, 33.17572], [-116.98468, 33.17575], [-116.98467, 33.1742]], [[-116.99575, 33.1674], [-116.99574, 33.16734], [-116.9957, 33.16729], [-116.99558, 33.16725], [-116.9956, 33.16764], [-116.99564, 33.16764], [-116.9957, 33.16757], [-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.9804, 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.98442, 33.17843], [-116.98475, 33.17831], [-116.98479, 33.17976]]], [[[-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.17597], [-116.99386, 33.17595], [-116.99407, 33.17572], [-116.99423, 33.1756], [-116.99439, 33.1755], [-116.9947, 33.17538], [-116.99505, 33.1753], [-116.99645, 33.17526], [-116.99671, 33.17529], [-116.99696, 33.17536], [-116.99719, 33.17546], [-116.99737, 33.17557]]], [[[-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.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]]], [[[-117.02058, 33.16665], [-117.01805, 33.16641], [-117.01794, 33.16624], [-117.01779, 33.16609], [-117.01764, 33.16601], [-117.01733, 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.01668, 33.16425], [-117.01658, 33.16416], [-117.01643, 33.16407], [-117.01628, 33.16402], [-117.0161, 33.164], [-117.01599, 33.16401], [-117.01583, 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.0128, 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.00443, 33.16603], [-117.00417, 33.16612], [-117.0038, 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.01526, 33.16494], [-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.01657, 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.01736, 33.16611], [-117.01757, 33.16617], [-117.01771, 33.16626], [-117.01781, 33.16637], [-117.018, 33.16673], [-117.0181, 33.17002]]]]} | Open Access 1 | Lake Wohlford | http://www.escondido.org/lake-wohlford.aspx | 3582 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 994.318 | Lake Wohlford | |
| 1162 | 1162 | 1161 | {"type": "MultiPolygon", "coordinates": [[[[-117.05334, 33.14072], [-117.052, 33.14174], [-117.05186, 33.14186], [-117.05187, 33.14191], [-117.04901, 33.14418], [-117.04851, 33.14452], [-117.04849, 33.14452], [-117.04716, 33.14528], [-117.047, 33.14503], [-117.04825, 33.14426], [-117.04825, 33.14423], [-117.04853, 33.14406], [-117.05037, 33.14262], [-117.05045, 33.14259], [-117.05073, 33.14237], [-117.05076, 33.1423], [-117.05316, 33.1404], [-117.05324, 33.14057], [-117.05327, 33.14057], [-117.05334, 33.14072]]], [[[-117.06021, 33.13542], [-117.06016, 33.13545], [-117.0602, 33.13557], [-117.06005, 33.13562], [-117.06001, 33.13559], [-117.05878, 33.13609], [-117.05872, 33.13619], [-117.05868, 33.13606], [-117.05866, 33.13606], [-117.05764, 33.1365], [-117.05703, 33.13685], [-117.05678, 33.13703], [-117.05654, 33.13722], [-117.05619, 33.13758], [-117.05513, 33.13885], [-117.05498, 33.13909], [-117.05478, 33.1393], [-117.05407, 33.14016], [-117.05383, 33.14042], [-117.05366, 33.14057], [-117.05367, 33.14061], [-117.05357, 33.1407], [-117.05335, 33.14025], [-117.05351, 33.14015], [-117.05365, 33.14003], [-117.05545, 33.13785], [-117.05545, 33.13782], [-117.05556, 33.13767], [-117.05558, 33.13767], [-117.05606, 33.13714], [-117.05634, 33.13691], [-117.05671, 33.13664], [-117.05693, 33.1365], [-117.05744, 33.13624], [-117.05795, 33.13603], [-117.05797, 33.13604], [-117.05848, 33.13584], [-117.05849, 33.13582], [-117.05844, 33.13576], [-117.06006, 33.13509], [-117.06017, 33.13526], [-117.06021, 33.13542]]]]} | Open Access 1 | Escondido Creek Trail | https://www.escondido.org/Data/Sites/1/media/PDFs/BikingEscondido.pdf | 32877 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 15.736 | Escondido Creek Trail | |
| 3471 | 3471 | 3470 | {"type": "MultiPolygon", "coordinates": [[[[-117.03167, 33.15096], [-117.03167, 33.15198], [-117.0239, 33.15197], [-117.0239, 33.1489], [-117.02592, 33.1489], [-117.026, 33.14908], [-117.02608, 33.14922], [-117.02622, 33.14939], [-117.02639, 33.14954], [-117.0266, 33.14966], [-117.02694, 33.14984], [-117.02708, 33.14989], [-117.02734, 33.14995], [-117.02755, 33.14998], [-117.02779, 33.14997], [-117.02868, 33.14984], [-117.02889, 33.14982], [-117.03031, 33.14989], [-117.0315, 33.14992], [-117.03143, 33.14994], [-117.0314, 33.14999], [-117.0314, 33.15094], [-117.03167, 33.15096]]], [[[-117.03129, 33.14889], [-117.03128, 33.14912], [-117.03116, 33.1497], [-117.03031, 33.14971], [-117.02882, 33.14964], [-117.02789, 33.14978], [-117.02763, 33.1498], [-117.02734, 33.14977], [-117.02718, 33.14973], [-117.02695, 33.14963], [-117.02664, 33.14947], [-117.02649, 33.14937], [-117.02633, 33.14921], [-117.02622, 33.14905], [-117.02614, 33.1489], [-117.03129, 33.14889]]]]} | Open Access 1 | Frances Ryan Community Park | https://www.escondido.org/ryan-park.aspx | 19040 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 56.638 | Frances Ryan Community Park | |
| 3909 | 3909 | 3908 | {"type": "MultiPolygon", "coordinates": [[[[-117.07366, 33.14302], [-117.07242, 33.14376], [-117.07258, 33.14401], [-117.07228, 33.1442], [-117.07215, 33.144], [-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 | El Norte Park | https://www.escondido.org/el-norte-park.aspx | 18522 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 2.415 | El Norte Park | |
| 4054 | 4054 | 4053 | {"type": "Polygon", "coordinates": [[[-117.07385, 33.10473], [-117.07348, 33.10491], [-117.07336, 33.10474], [-117.07338, 33.10472], [-117.07355, 33.10462], [-117.07372, 33.10455], [-117.07385, 33.10473]]]} | Open Access 1 | Escondido City Park | 18704 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 0.235 | Escondido City Park | ||
| 4706 | 4706 | 4705 | {"type": "Polygon", "coordinates": [[[-117.08488, 33.12287], [-117.08464, 33.12304], [-117.08445, 33.12329], [-117.0846, 33.1235], [-117.08411, 33.12379], [-117.08436, 33.12439], [-117.08376, 33.12476], [-117.08317, 33.12528], [-117.08246, 33.12364], [-117.0847, 33.12257], [-117.08488, 33.12287]]]} | Open Access 1 | Grape Day Park | https://www.escondido.org/grape-day-park.aspx | 19446 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 7.667 | Grape Day Park | |
| 4778 | 4778 | 4777 | {"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 | Grove Park | https://www.escondido.org/grove-park.aspx | 19534 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 4.564 | Grove Park | |
| 5523 | 5523 | 5522 | {"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.16513], [-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 | Jesmond Dene Park | https://www.escondido.org/jesmond-dene-park.aspx | 20402 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 35.526 | Jesmond Dene Park | |
| 8887 | 8887 | 8886 | {"type": "Polygon", "coordinates": [[[-117.10161, 33.14781], [-117.10055, 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 | Rod McLeod Park | https://www.escondido.org/rod-mcleod-park.aspx | 24547 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 17.24 | Rod McLeod Park | |
| 11035 | 11035 | 11034 | {"type": "Polygon", "coordinates": [[[-117.0646, 33.13353], [-117.06399, 33.13352], [-117.06374, 33.13349], [-117.0637, 33.1334], [-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.13325], [-117.06292, 33.13314], [-117.06325, 33.13308], [-117.06357, 33.13309], [-117.06359, 33.13306], [-117.06426, 33.13311], [-117.0646, 33.13353]]]} | Open Access 1 | Washington Park | https://www.escondido.org/washington-park.aspx | 27275 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 12.696 | Washington Park | |
| 11152 | 11152 | 11151 | {"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 | Westside Park | https://www.escondido.org/westside-park.aspx | 27425 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 2.351 | Westside Park | |
| 13871 | 13871 | 13870 | {"type": "Polygon", "coordinates": [[[-117.03223, 33.15748], [-117.03218, 33.15758], [-117.0322, 33.15761], [-117.03147, 33.15901], [-117.03133, 33.15897], [-117.03144, 33.15869], [-117.0315, 33.15844], [-117.03159, 33.15746], [-117.03223, 33.15748]]]} | Open Access 1 | Mayflower Dog Park | https://www.escondido.org/mayflower-dog-park.aspx | 31425 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1.445 | Mayflower Dog Park | |
| 14837 | 14837 | 14836 | {"type": "MultiPolygon", "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.0802, 33.167], [-117.08128, 33.16637], [-117.08135, 33.16636], [-117.08112, 33.1665], [-117.08077, 33.16723], [-117.08057, 33.16742], [-117.08047, 33.16756], [-117.0806, 33.16791], [-117.08073, 33.16802], [-117.08108, 33.16808], [-117.08126, 33.1679], [-117.08129, 33.16782], [-117.08104, 33.16772], [-117.08106, 33.16768], [-117.08136, 33.16776], [-117.08181, 33.16687], [-117.08187, 33.16673], [-117.0819, 33.16659], [-117.08189, 33.16635], [-117.08181, 33.16612], [-117.08154, 33.16625], [-117.08156, 33.16621], [-117.08344, 33.16511], [-117.0835, 33.16545]]], [[[-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], [-117.08438, 33.17027]]], [[[-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]]], [[[-117.08784, 33.16292], [-117.08767, 33.16301], [-117.08764, 33.16311], [-117.08733, 33.16327], [-117.08703, 33.1634], [-117.08533, 33.16437], [-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.08685, 33.16937], [-117.08646, 33.16833], [-117.08612, 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.08497, 33.16423], [-117.08497, 33.16419], [-117.0876, 33.16268], [-117.0877, 33.1627], [-117.08784, 33.16292]]], [[[-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 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 22.536 | City of Escondido OS | ||
| 15482 | 15482 | 15481 | {"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.12718], [-117.03508, 33.12661], [-117.03508, 33.12642], [-117.0387, 33.12652]]]} | Open Access 1 | Mountain View Park | https://www.escondido.org/mountain-view-park.aspx | 22554 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 26.289 | Mtn. View Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps(
id INT,
map,
ACCESS_TYP INT,
PARK_NAME TEXT,
PARK_URL TEXT,
SUID_NMA INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
ON [superunits_with_maps] ([ACCESS_TYP]);