units_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: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL
DES_TP 5
- Local Park 29
- Local Other or Unknown 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 33
MNG_AGENCY 1
- San Jacinto, City of · 33 ✖
ACCESS_TYP 1
- Open Access 33
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4816 | 4816 | 4815 | {"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 | 48837 | Unknown park - San Jacinto, City of | 33557 | 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 | Riverside 10 | 3.986 | 0 | Local Other or Unknown 14 | 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 |
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 |
4455 | 4455 | 4454 | {"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 | 48395 | Belicia Park | 32960 | 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://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304452 | Riverside 10 | 0.472 | Belicia Park | 0 | Local Park 2 | 4 |
3759 | 3759 | 3758 | {"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.78422], [-116.99068, 33.78431], [-116.9909, 33.78442], [-116.99125, 33.78452], [-116.99116, 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 | 34899 | Bolander Park | 16236 | 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 | Riverside 10 | 4.841 | Bolander 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 |
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 |
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 |
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 |
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 |
4550 | 4550 | 4549 | {"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 | 24659 | Druding Park | 18276 | 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 | Riverside 10 | 0.63 | Druding 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 |
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 |
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 | ||
4841 | 4841 | 4840 | {"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 | 48398 | Hafliger Park | 32964 | 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://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304536 | Riverside 10 | 1.6 | Hafliger 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 |
2940 | 2940 | 2939 | {"type": "Polygon", "coordinates": [[[-116.9599, 33.78116], [-116.9599, 33.78189], [-116.95989, 33.78191], [-116.95986, 33.78192], [-116.95894, 33.78192], [-116.95894, 33.78116], [-116.9599, 33.78116]]]} | Open Access 1 | 19957 | Hofmann Park | 32965 | 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 | Riverside 10 | 1.866 | Hofmann Park | 0 | Local Park 2 | 4 | |
3758 | 3758 | 3757 | {"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.98594, 33.77914], [-116.98508, 33.77914], [-116.98507, 33.77777], [-116.98565, 33.77777], [-116.98566, 33.77785], [-116.98607, 33.77785], [-116.98609, 33.77888], [-116.98614, 33.77907], [-116.98632, 33.77936]]]]} | Open Access 1 | 34898 | Lynden Trail Park | 21608 | 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 | Riverside 10 | 4.615 | Lynden Trail Park | 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 |
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 |
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]);