units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where MNG_AGENCY = 218
This data as json, copyable, CSV (advanced)
DES_TP 2
- Local Park 12
- None 1
MNG_AG_TYP 1
- City Agency 13
MNG_AGENCY 1
- San Jacinto, City of · 13 ✖
ACCESS_TYP 1
- Open Access 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
15329 | 15329 | 15328 | {"type": "Polygon", "coordinates": [[[-117.03611, 33.78835], [-117.03606, 33.78836], [-117.03603, 33.78814], [-117.03599, 33.78803], [-117.0359, 33.78786], [-117.03583, 33.78777], [-117.03574, 33.78768], [-117.03558, 33.78755], [-117.03537, 33.78743], [-117.03604, 33.78743], [-117.03599, 33.78773], [-117.03606, 33.7878], [-117.03603, 33.78785], [-117.03602, 33.78791], [-117.03605, 33.78798], [-117.03604, 33.788], [-117.03611, 33.78835]]]} | Open Access 1 | 48972 | Pocket Park at the Cove #2 | 33669 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.446 | PP at the Cove #2 | 0 | Local Park 2 | 4 |
15540 | 15540 | 15539 | {"type": "Polygon", "coordinates": [[[-117.03786, 33.79012], [-117.03745, 33.79026], [-117.03733, 33.79002], [-117.03774, 33.78988], [-117.03786, 33.79012]]]} | Open Access 1 | 48971 | Pocket Park at the Cove #1 | 33668 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.295 | PP at the Cove #1 | 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]);