units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
22 rows where ACCESS_TYP = 1, GAP_STS = 4 and MNG_AGENCY = 84
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
14670 | 14670 | 14669 | {"type": "MultiPolygon", "coordinates": [[[[-117.05334, 33.14072], [-117.052, 33.14174], [-117.05186, 33.14187], [-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.04826, 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.14058], [-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.06002, 33.13559], [-117.05878, 33.13609], [-117.05872, 33.13619], [-117.05868, 33.13606], [-117.05867, 33.13605], [-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.05546, 33.13784], [-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.13605], [-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 | 48308 | Escondido Creek Trail | 32877 | 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/Data/Sites/1/media/PDFs/BikingEscondido.pdf | San Diego 4 | 15.735 | Escondido Creek Trail | 0 | Local Recreation Area 3 | 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]);