superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where MNG_AGENCY = 218 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14391 | 14391 | 14390 | {"type": "Polygon", "coordinates": [[[-117.01983, 33.78712], [-117.01846, 33.78712], [-117.01837, 33.78705], [-117.01838, 33.78608], [-117.01843, 33.78604], [-117.019, 33.78604], [-117.01925, 33.78607], [-117.01936, 33.78603], [-117.01943, 33.78595], [-117.01981, 33.78608], [-117.01983, 33.78712]]]} | Open Access 1 | Unknown park - San Jacinto, City of | 33557 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 3.985 | |||
11664 | 11664 | 11663 | {"type": "Polygon", "coordinates": [[[-117.00038, 33.7932], [-117.00038, 33.79349], [-116.99823, 33.7935], [-116.99822, 33.79141], [-116.99856, 33.79141], [-116.99858, 33.79169], [-116.99892, 33.7917], [-116.99893, 33.79205], [-116.99897, 33.79218], [-116.99903, 33.79232], [-116.99918, 33.7925], [-116.99965, 33.79293], [-116.99981, 33.79304], [-116.99999, 33.79312], [-117.00017, 33.79318], [-117.00038, 33.7932]]]} | Open Access 1 | Aaron J. Ward Park | http://www.ci.san-jacinto.ca.us/residents/parks.html | 28234 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 5.842 | Aaron J. Ward Park | |
11669 | 11669 | 11668 | {"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 | Almaden Park | http://www.ci.san-jacinto.ca.us/residents/parks.html | 28243 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1.699 | Almaden Park | |
1831 | 1831 | 1830 | {"type": "Polygon", "coordinates": [[[-116.92363, 33.76592], [-116.92305, 33.7664], [-116.92281, 33.76619], [-116.92324, 33.76594], [-116.9234, 33.76582], [-116.92352, 33.76583], [-116.92363, 33.76592]]]} | Open Access 1 | Belicia Park | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304452 | 32960 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 0.472 | Belicia Park | |
2121 | 2121 | 2120 | {"type": "Polygon", "coordinates": [[[-116.99361, 33.78554], [-116.99306, 33.78554], [-116.99289, 33.78542], [-116.9927, 33.78531], [-116.9924, 33.78518], [-116.99218, 33.78511], [-116.99217, 33.78509], [-116.99089, 33.78477], [-116.99087, 33.78479], [-116.98953, 33.78445], [-116.98952, 33.78232], [-116.98959, 33.78225], [-116.98983, 33.78225], [-116.98988, 33.78229], [-116.98988, 33.78255], [-116.9899, 33.78269], [-116.99017, 33.7837], [-116.99023, 33.78384], [-116.99037, 33.78404], [-116.99056, 33.78421], [-116.99068, 33.78431], [-116.9909, 33.78442], [-116.99125, 33.78452], [-116.99117, 33.7848], [-116.99224, 33.78506], [-116.99257, 33.78518], [-116.99259, 33.78518], [-116.99264, 33.78521], [-116.9927, 33.78523], [-116.99271, 33.78526], [-116.99296, 33.78541], [-116.99361, 33.78541], [-116.99361, 33.78554]]]} | Open Access 1 | Bolander Park | 16236 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 4.845 | Bolander Park | ||
11667 | 11667 | 11666 | {"type": "Polygon", "coordinates": [[[-116.99613, 33.79415], [-116.99591, 33.79416], [-116.9957, 33.79394], [-116.99547, 33.79376], [-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 | Caseros Park | http://www.ci.san-jacinto.ca.us/residents/parks.html | 28237 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1.482 | Caseros Park | |
11639 | 11639 | 11638 | {"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 | Catalpa Park | http://www.ci.san-jacinto.ca.us/residents/parks.html | 28229 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 6.934 | Catalpa Park | |
11672 | 11672 | 11671 | {"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.99802, 33.8171], [-116.99801, 33.81688], [-116.99786, 33.81646], [-116.99755, 33.81657], [-116.99751, 33.81649], [-116.99799, 33.81631], [-116.99954, 33.81759], [-116.99957, 33.81764]]]} | Open Access 1 | Col. Lewis Millett Park | http://www.ci.san-jacinto.ca.us/residents/parks.html | 28246 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 5.814 | Col. Lewis Millett Park | |
11663 | 11663 | 11662 | {"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.99498, 33.78636], [-116.9955, 33.78635], [-116.9955, 33.78657], [-116.99547, 33.78675], [-116.99551, 33.78686], [-116.99558, 33.78691], [-116.99568, 33.78694], [-116.99591, 33.78691], [-116.99618, 33.78691], [-116.99619, 33.78721]]]]} | Open Access 1 | Cutting Park | http://www.ci.san-jacinto.ca.us/residents/parks.html | 28233 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 2.837 | Cutting Park | |
11665 | 11665 | 11664 | {"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 | Daniel Najera Park | http://www.ci.san-jacinto.ca.us/residents/parks.html | 28235 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1.438 | Daniel Najera Park | |
3711 | 3711 | 3710 | {"type": "Polygon", "coordinates": [[[-116.96087, 33.7857], [-116.9601, 33.7857], [-116.9601, 33.78506], [-116.96035, 33.78527], [-116.96087, 33.7857]]]} | Open Access 1 | Druding Park | 18276 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 0.63 | Druding Park | ||
11674 | 11674 | 11673 | {"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 | Durango Park | http://www.ci.san-jacinto.ca.us/residents/parks.html | 28248 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 2.773 | Durango Park | |
11675 | 11675 | 11674 | {"type": "Polygon", "coordinates": [[[-116.96921, 33.78085], [-116.96805, 33.78184], [-116.96692, 33.78091], [-116.96759, 33.78035], [-116.9692, 33.78035], [-116.96921, 33.78085]]]} | Open Access 1 | Francisco Estudillo Heritage Park | http://www.ci.san-jacinto.ca.us/residents/parks.html | 28249 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 5.383 | Francisco Estudillo Heritage Park | |
11673 | 11673 | 11672 | {"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.81154], [-116.995, 33.8111], [-116.99507, 33.8111], [-116.99551, 33.81146], [-116.99551, 33.81152]]]} | Open Access 1 | Granite Homes | http://www.ci.san-jacinto.ca.us/residents/parks.html | 28247 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 4.576 | Granite Homes | |
1906 | 1906 | 1905 | {"type": "Polygon", "coordinates": [[[-116.95082, 33.76272], [-116.95023, 33.76243], [-116.95039, 33.76233], [-116.95042, 33.76227], [-116.95043, 33.76223], [-116.95039, 33.76215], [-116.94999, 33.76177], [-116.95014, 33.76153], [-116.95081, 33.76152], [-116.95082, 33.76272]]]} | Open Access 1 | Hafliger Park | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304536 | 32964 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1.599 | Hafliger Park | |
11668 | 11668 | 11667 | {"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.79075], [-116.98056, 33.79089]]]} | Open Access 1 | Haugen Park | http://www.ci.san-jacinto.ca.us/residents/parks.html | 28238 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 2.47 | Haugen Park | |
1907 | 1907 | 1906 | {"type": "Polygon", "coordinates": [[[-116.9599, 33.78189], [-116.95986, 33.78192], [-116.95894, 33.78192], [-116.95894, 33.78116], [-116.9599, 33.78116], [-116.9599, 33.78189]]]} | Open Access 1 | Hofmann Park | 32965 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1.865 | Hofmann Park | ||
6473 | 6473 | 6472 | {"type": "MultiPolygon", "coordinates": [[[[-116.98153, 33.77753], [-116.98137, 33.77744], [-116.98119, 33.77737], [-116.981, 33.77733], [-116.98078, 33.77731], [-116.98075, 33.77726], [-116.98075, 33.77705], [-116.98097, 33.77713], [-116.98116, 33.77724], [-116.98153, 33.77753]]], [[[-116.98447, 33.78005], [-116.98386, 33.78005], [-116.9838, 33.78003], [-116.98378, 33.77999], [-116.98377, 33.7797], [-116.98375, 33.77957], [-116.98368, 33.77941], [-116.98355, 33.77922], [-116.98416, 33.77972], [-116.98447, 33.78005]]], [[[-116.98632, 33.77936], [-116.98628, 33.77942], [-116.98594, 33.77947], [-116.98593, 33.77914], [-116.98508, 33.77914], [-116.98507, 33.77777], [-116.98565, 33.77777], [-116.98567, 33.77785], [-116.98607, 33.77785], [-116.98609, 33.77888], [-116.98614, 33.77907], [-116.98632, 33.77936]]]]} | Open Access 1 | Lynden Trail Park | 21608 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 4.619 | Lynden Trail Park | ||
14121 | 14121 | 14120 | {"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 | Pocket Park at the Cove #1 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | 33668 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 0.295 | PP at the Cove #1 | |
14431 | 14431 | 14430 | {"type": "Polygon", "coordinates": [[[-117.03611, 33.78835], [-117.03606, 33.78836], [-117.03603, 33.78814], [-117.03599, 33.78804], [-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 | Pocket Park at the Cove #2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | 33669 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 0.447 | PP at the Cove #2 |
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]);