units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where ACCESS_TYP = 1, AGNCY_NAME = 86 and DES_TP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
14805 | 14805 | 14804 | {"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.02623, 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.14983], [-117.02889, 33.14982], [-117.03031, 33.14989], [-117.0315, 33.14991], [-117.03143, 33.14994], [-117.0314, 33.14999], [-117.0314, 33.15095], [-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 | 45220 | Frances Ryan Community Park | 19040 | 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/ryan-park.aspx | San Diego 4 | 56.637 | Frances Ryan Community Park | 0 | Local Park 2 | 4 |
14806 | 14806 | 14805 | {"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 | 45222 | Escondido City Park | 18704 | 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.235 | Escondido City 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]);