units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
20 rows where ACCESS_TYP = 1, MNG_AGENCY = 218 and PARK_URL = "http://www.ci.san-jacinto.ca.us/residents/parks.html"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3842 | 3842 | 3841 | {"type": "Polygon", "coordinates": [[[-117.01532, 33.78362], [-117.0139, 33.78363], [-117.01408, 33.7834], [-117.01418, 33.78331], [-117.01424, 33.78315], [-117.01446, 33.78269], [-117.0146, 33.78223], [-117.01465, 33.78198], [-117.01467, 33.78168], [-117.01467, 33.78078], [-117.0147, 33.78058], [-117.01466, 33.78048], [-117.01466, 33.78011], [-117.01522, 33.78011], [-117.01529, 33.78017], [-117.01532, 33.78362]]]} | Open Access 1 | 45431 | Catalpa Park | 28229 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 6.935 | Catalpa Park | 0 | Local Park 2 | 4 |
3844 | 3844 | 3843 | {"type": "Polygon", "coordinates": [[[-116.96921, 33.78085], [-116.96805, 33.78184], [-116.96692, 33.78091], [-116.96758, 33.78035], [-116.9692, 33.78035], [-116.96921, 33.78085]]]} | Open Access 1 | 45450 | Francisco Estudillo Heritage Park | 28249 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 5.384 | Francisco Estudillo Heritage Park | 0 | Local Park 2 | 4 |
4295 | 4295 | 4294 | {"type": "Polygon", "coordinates": [[[-116.9907, 33.78992], [-116.98963, 33.78993], [-116.98956, 33.78986], [-116.98955, 33.78958], [-116.99016, 33.78958], [-116.99017, 33.78952], [-116.99033, 33.78964], [-116.9907, 33.78964], [-116.9907, 33.78992]]]} | Open Access 1 | 45439 | Stallions Crossings | 28232 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 0.94 | Stallions Crossings | None 376 | ||
4323 | 4323 | 4322 | {"type": "Polygon", "coordinates": [[[-117.01978, 33.78361], [-117.01948, 33.78361], [-117.0194, 33.78364], [-117.01932, 33.78356], [-117.0192, 33.78352], [-117.01898, 33.78355], [-117.01865, 33.78354], [-117.0186, 33.7835], [-117.01861, 33.78297], [-117.01866, 33.78293], [-117.01896, 33.78293], [-117.01917, 33.78296], [-117.01926, 33.78295], [-117.01933, 33.78291], [-117.01935, 33.78292], [-117.01977, 33.78292], [-117.01978, 33.78361]]]} | Open Access 1 | 45432 | Terrazzo Park | 28228 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 1.882 | Terrazzo Park | 0 | Local Park 2 | 4 |
4324 | 4324 | 4323 | {"type": "Polygon", "coordinates": [[[-117.00334, 33.7746], [-117.00259, 33.7746], [-117.00259, 33.77419], [-117.00281, 33.77421], [-117.00289, 33.77419], [-117.00295, 33.77414], [-117.00302, 33.77419], [-117.00333, 33.77419], [-117.00334, 33.7746]]]} | Open Access 1 | 45436 | Solana II Park | 28230 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 0.776 | Solana II Park | 0 | Local Park 2 | 4 |
5627 | 5627 | 5626 | {"type": "MultiPolygon", "coordinates": [[[[-116.99518, 33.78996], [-116.99517, 33.79002], [-116.99479, 33.79022], [-116.99456, 33.78993], [-116.99375, 33.79008], [-116.99374, 33.78929], [-116.99403, 33.78928], [-116.99432, 33.7892], [-116.99449, 33.78959], [-116.99484, 33.78947], [-116.99493, 33.78961], [-116.99518, 33.78996]]], [[[-116.99698, 33.79061], [-116.99687, 33.79067], [-116.99675, 33.79077], [-116.99657, 33.79097], [-116.99628, 33.79097], [-116.99585, 33.79054], [-116.99511, 33.78955], [-116.99499, 33.78932], [-116.99493, 33.78906], [-116.99493, 33.78803], [-116.99698, 33.79061]]]]} | Open Access 1 | 45438 | Sandelwood Park | 28231 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 7.842 | Sandelwood Park | 0 | Local Park 2 | 4 |
14877 | 14877 | 14876 | {"type": "Polygon", "coordinates": [[[-116.989, 33.7964], [-116.98899, 33.79696], [-116.98805, 33.79697], [-116.988, 33.79693], [-116.98799, 33.7964], [-116.989, 33.7964]]]} | Open Access 1 | 45444 | Daniel Najera Park | 28235 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 1.438 | Daniel Najera Park | 0 | Local Park 2 | 4 |
14886 | 14886 | 14885 | {"type": "Polygon", "coordinates": [[[-116.9851, 33.79461], [-116.98504, 33.79466], [-116.98414, 33.79467], [-116.98411, 33.79447], [-116.98399, 33.79416], [-116.98396, 33.79397], [-116.98397, 33.79371], [-116.98405, 33.79342], [-116.9841, 33.79318], [-116.98412, 33.79277], [-116.98509, 33.79277], [-116.9851, 33.79461]]]} | Open Access 1 | 45443 | Warneke Park | 28236 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 5.012 | Warneke Park | 0 | Local Park 2 | 4 |
14888 | 14888 | 14887 | {"type": "Polygon", "coordinates": [[[-117.02407, 33.78613], [-117.02397, 33.78608], [-117.02257, 33.7863], [-117.02248, 33.78627], [-117.0225, 33.78621], [-117.02249, 33.78616], [-117.02242, 33.78598], [-117.02228, 33.7854], [-117.02231, 33.78535], [-117.0225, 33.78532], [-117.02327, 33.78531], [-117.0235, 33.78533], [-117.02359, 33.78531], [-117.02366, 33.78527], [-117.02375, 33.78533], [-117.02405, 33.78533], [-117.02407, 33.78613]]]} | Open Access 1 | 45433 | Tamarisk Park | 28227 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 3.725 | Tamarisk Park | 0 | Local Park 2 | 4 |
14889 | 14889 | 14888 | {"type": "Polygon", "coordinates": [[[-117.00648, 33.77991], [-117.00478, 33.77992], [-117.00469, 33.77986], [-117.00469, 33.77968], [-117.00474, 33.77964], [-117.00499, 33.77962], [-117.00523, 33.77956], [-117.00541, 33.77949], [-117.00559, 33.77939], [-117.00576, 33.77926], [-117.00589, 33.77912], [-117.006, 33.77896], [-117.00608, 33.77878], [-117.00648, 33.77888], [-117.00648, 33.77991]]]} | Open Access 1 | 45434 | Ward Park | 28226 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 2.854 | Ward Park | 0 | Local Park 2 | 4 |
14890 | 14890 | 14889 | {"type": "Polygon", "coordinates": [[[-117.00038, 33.7932], [-117.00038, 33.79349], [-116.99823, 33.7935], [-116.99822, 33.79141], [-116.99856, 33.79141], [-116.99857, 33.7917], [-116.99892, 33.79169], [-116.99893, 33.79205], [-116.99897, 33.79218], [-116.99903, 33.79232], [-116.99918, 33.7925], [-116.99965, 33.79294], [-116.99981, 33.79304], [-116.99999, 33.79312], [-117.00017, 33.79318], [-117.00038, 33.7932]]]} | Open Access 1 | 45437 | Aaron J. Ward Park | 28234 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 5.84 | Aaron J. Ward Park | 0 | Local Park 2 | 4 |
14891 | 14891 | 14890 | {"type": "MultiPolygon", "coordinates": [[[[-116.99448, 33.78593], [-116.99442, 33.78606], [-116.99434, 33.78617], [-116.99428, 33.78618], [-116.99418, 33.78613], [-116.99403, 33.78601], [-116.99391, 33.78586], [-116.99386, 33.78573], [-116.99383, 33.78554], [-116.99423, 33.78554], [-116.99448, 33.78593]]], [[[-116.99619, 33.78721], [-116.99501, 33.78721], [-116.99493, 33.78715], [-116.99491, 33.78689], [-116.99484, 33.78666], [-116.9947, 33.78647], [-116.99452, 33.78631], [-116.99451, 33.78626], [-116.99467, 33.78604], [-116.99474, 33.786], [-116.9948, 33.786], [-116.99481, 33.78628], [-116.99497, 33.78636], [-116.9955, 33.78635], [-116.9955, 33.78657], [-116.99547, 33.78675], [-116.99551, 33.78685], [-116.99558, 33.78691], [-116.99568, 33.78694], [-116.99591, 33.78691], [-116.99618, 33.78691], [-116.99619, 33.78721]]]]} | Open Access 1 | 45440 | Cutting Park | 28233 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 2.836 | Cutting Park | 0 | Local Park 2 | 4 |
14892 | 14892 | 14891 | {"type": "Polygon", "coordinates": [[[-116.98056, 33.79089], [-116.98048, 33.79096], [-116.97911, 33.79096], [-116.97886, 33.79094], [-116.97874, 33.79097], [-116.97866, 33.79105], [-116.97846, 33.79105], [-116.97846, 33.79047], [-116.97971, 33.79046], [-116.98, 33.79049], [-116.9801, 33.79047], [-116.98013, 33.79052], [-116.98056, 33.79074], [-116.98056, 33.79089]]]} | Open Access 1 | 45441 | Haugen Park | 28238 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 2.47 | Haugen Park | 0 | Local Park 2 | 4 |
14893 | 14893 | 14892 | {"type": "Polygon", "coordinates": [[[-116.99613, 33.79415], [-116.99591, 33.79416], [-116.9957, 33.79394], [-116.99547, 33.79377], [-116.99524, 33.79357], [-116.99508, 33.79338], [-116.99504, 33.79319], [-116.9947, 33.79319], [-116.9947, 33.79249], [-116.99612, 33.79405], [-116.99613, 33.79415]]]} | Open Access 1 | 45442 | Caseros Park | 28237 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 1.481 | Caseros Park | 0 | Local Park 2 | 4 |
14894 | 14894 | 14893 | {"type": "Polygon", "coordinates": [[[-116.99551, 33.81152], [-116.99412, 33.81269], [-116.99401, 33.81269], [-116.99276, 33.81166], [-116.99301, 33.81145], [-116.99324, 33.8116], [-116.99352, 33.8117], [-116.99382, 33.81173], [-116.99411, 33.81169], [-116.9943, 33.81163], [-116.99448, 33.81153], [-116.995, 33.8111], [-116.99507, 33.8111], [-116.99551, 33.81146], [-116.99551, 33.81152]]]} | Open Access 1 | 45445 | Granite Homes | 28247 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 4.577 | Granite Homes | None 1285 | ||
14895 | 14895 | 14894 | {"type": "Polygon", "coordinates": [[[-116.99957, 33.81764], [-116.99952, 33.81802], [-116.99946, 33.81832], [-116.99937, 33.81838], [-116.99898, 33.81833], [-116.99863, 33.81826], [-116.99808, 33.81798], [-116.99788, 33.81791], [-116.99767, 33.81785], [-116.99763, 33.81781], [-116.9977, 33.81733], [-116.9977, 33.81712], [-116.99803, 33.8171], [-116.99801, 33.81688], [-116.99786, 33.81645], [-116.99755, 33.81657], [-116.99751, 33.81649], [-116.99799, 33.81631], [-116.99954, 33.81759], [-116.99957, 33.81764]]]} | Open Access 1 | 45446 | Col. Lewis Millett Park | 28246 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 5.809 | Col. Lewis Millett Park | 0 | Local Park 2 | 4 |
14896 | 14896 | 14895 | {"type": "MultiPolygon", "coordinates": [[[[-116.98416, 33.80825], [-116.98321, 33.80894], [-116.98286, 33.80865], [-116.98315, 33.80843], [-116.98327, 33.80845], [-116.98338, 33.80841], [-116.98353, 33.80827], [-116.98385, 33.80804], [-116.98391, 33.80804], [-116.98416, 33.80825]]], [[[-116.98521, 33.80747], [-116.98431, 33.80814], [-116.98407, 33.80794], [-116.98407, 33.80787], [-116.9849, 33.80726], [-116.98497, 33.80727], [-116.98521, 33.80747]]], [[[-116.9863, 33.80667], [-116.98536, 33.80736], [-116.98512, 33.80716], [-116.98512, 33.8071], [-116.98596, 33.80648], [-116.98607, 33.80649], [-116.9863, 33.80667]]], [[[-116.98763, 33.80587], [-116.9867, 33.80666], [-116.98627, 33.80631], [-116.98626, 33.80621], [-116.98663, 33.80589], [-116.98684, 33.80563], [-116.98689, 33.80566], [-116.98705, 33.80554], [-116.98696, 33.80545], [-116.98701, 33.80539], [-116.98729, 33.80514], [-116.9874, 33.80507], [-116.98746, 33.80512], [-116.9871, 33.80543], [-116.98763, 33.80587]]]]} | Open Access 1 | 45447 | Skyview Park | 28245 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 5.302 | Skyview Park | 0 | Local Park 2 | 4 |
14897 | 14897 | 14896 | {"type": "Polygon", "coordinates": [[[-116.98083, 33.8092], [-116.98081, 33.80926], [-116.98082, 33.81102], [-116.97972, 33.81103], [-116.97971, 33.81039], [-116.97992, 33.81033], [-116.98011, 33.81023], [-116.98027, 33.81011], [-116.9804, 33.80995], [-116.98048, 33.8098], [-116.98053, 33.80964], [-116.98053, 33.80915], [-116.98083, 33.8092]]]} | Open Access 1 | 45448 | Sagecrest Park | 28244 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 3.135 | Sagecrest Park | 0 | Local Park 2 | 4 |
14898 | 14898 | 14897 | {"type": "Polygon", "coordinates": [[[-116.98924, 33.8019], [-116.98924, 33.8019], [-116.98777, 33.80191], [-116.98809, 33.80164], [-116.98816, 33.80167], [-116.98824, 33.80168], [-116.98832, 33.80166], [-116.98838, 33.80162], [-116.9887, 33.8013], [-116.98883, 33.80107], [-116.98923, 33.80118], [-116.98924, 33.8019]]]} | Open Access 1 | 45449 | Almaden Park | 28243 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 1.699 | Almaden Park | 0 | Local Park 2 | 4 |
14899 | 14899 | 14898 | {"type": "Polygon", "coordinates": [[[-116.94363, 33.78384], [-116.94254, 33.78385], [-116.94232, 33.78351], [-116.94236, 33.78345], [-116.94237, 33.78339], [-116.94234, 33.78321], [-116.94234, 33.78304], [-116.94239, 33.783], [-116.94284, 33.783], [-116.94311, 33.78302], [-116.94322, 33.78297], [-116.94328, 33.78288], [-116.94363, 33.78295], [-116.94363, 33.78384]]]} | Open Access 1 | 45451 | Durango Park | 28248 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 2.774 | Durango 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]);