units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
19 rows where COUNTY = 3, MNG_AGENCY = 214 and YR_EST = 0
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 19
MNG_AGENCY 1
- Cypress, City of · 19 ✖
DES_TP 1
- Local Park 19
ACCESS_TYP 1
- Open Access 19
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
594 | 594 | 593 | {"type": "Polygon", "coordinates": [[[-118.04559, 33.82791], [-118.04349, 33.82792], [-118.04347, 33.82704], [-118.04558, 33.82702], [-118.04559, 33.82791]]]} | Open Access 1 | 4066 | Evergreen Park | 18766 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 4.743 | Evergreen Park | 0 | Local Park 2 | 4 | |
798 | 798 | 797 | {"type": "Polygon", "coordinates": [[[-118.05437, 33.82517], [-118.0527, 33.82519], [-118.05268, 33.82431], [-118.05431, 33.82429], [-118.05436, 33.82434], [-118.05437, 33.82517]]]} | Open Access 1 | 5837 | Willow Park | 27583 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 3.722 | Willow Park | 0 | Local Park 2 | 4 | |
976 | 976 | 975 | {"type": "Polygon", "coordinates": [[[-118.03464, 33.82123], [-118.03464, 33.82425], [-118.03457, 33.82428], [-118.03399, 33.82429], [-118.03399, 33.82402], [-118.03374, 33.82402], [-118.03373, 33.82429], [-118.0326, 33.82429], [-118.03258, 33.82395], [-118.03255, 33.82255], [-118.03257, 33.82189], [-118.03257, 33.82113], [-118.03254, 33.82023], [-118.03431, 33.82021], [-118.03431, 33.82066], [-118.03462, 33.82066], [-118.03461, 33.82069], [-118.03455, 33.82077], [-118.03453, 33.82083], [-118.03456, 33.82089], [-118.03462, 33.82094], [-118.03462, 33.82097], [-118.03456, 33.82102], [-118.03454, 33.82109], [-118.03455, 33.82114], [-118.03464, 33.82123]]]} | Open Access 1 | 6100 | Oak Knoll Park | 22983 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 20.799 | Oak Knoll Park | 0 | Local Park 2 | 4 | |
3048 | 3048 | 3047 | {"type": "Polygon", "coordinates": [[[-118.02457, 33.79558], [-118.02407, 33.79558], [-118.02361, 33.7948], [-118.02369, 33.79476], [-118.02374, 33.79479], [-118.02403, 33.79466], [-118.02403, 33.79464], [-118.02399, 33.79457], [-118.02427, 33.79445], [-118.02436, 33.79455], [-118.02447, 33.79458], [-118.02457, 33.79458], [-118.02457, 33.79558]]]} | Open Access 1 | 24501 | Maple Grove Park South | 21775 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 1.866 | Maple Grove Park South | 0 | Local Park 2 | 4 | |
4888 | 4888 | 4887 | {"type": "Polygon", "coordinates": [[[-118.0173, 33.80888], [-118.01729, 33.8098], [-118.01688, 33.8098], [-118.01681, 33.80979], [-118.01679, 33.80976], [-118.01678, 33.80971], [-118.01678, 33.80888], [-118.0173, 33.80888]]]} | Open Access 1 | 30329 | Baroldi/Sycamore Park | 15826 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 1.2 | Baroldi/Sycamore Park | 0 | Local Park 2 | 4 | |
6396 | 6396 | 6395 | {"type": "Polygon", "coordinates": [[[-118.04142, 33.83886], [-118.03947, 33.83888], [-118.03945, 33.83714], [-118.03942, 33.83627], [-118.04137, 33.83626], [-118.04142, 33.83886]]]} | Open Access 1 | 5635 | Cypress Park | 17877 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 12.864 | Cypress Park | 0 | Local Park 2 | 4 | |
7749 | 7749 | 7748 | {"type": "Polygon", "coordinates": [[[-118.01237, 33.79234], [-118.01231, 33.7924], [-118.01228, 33.79248], [-118.01228, 33.79292], [-118.01225, 33.79298], [-118.01179, 33.79299], [-118.0117, 33.79302], [-118.01166, 33.79298], [-118.01124, 33.79297], [-118.01125, 33.79199], [-118.01234, 33.79199], [-118.01233, 33.79231], [-118.01237, 33.79234]]]} | Open Access 1 | 8308 | Peppertree Park | 23598 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 2.668 | Peppertree Park | 0 | Local Park 2 | 4 | |
11620 | 11620 | 11619 | {"type": "Polygon", "coordinates": [[[-118.04379, 33.81804], [-118.04302, 33.81805], [-118.04303, 33.81778], [-118.04297, 33.81777], [-118.04298, 33.81709], [-118.04378, 33.81708], [-118.04379, 33.81804]]]} | Open Access 1 | 24580 | Darrell Essex Park | 17929 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 1.931 | Darrell Essex Park | 0 | Local Park 2 | 4 | |
11907 | 11907 | 11906 | {"type": "Polygon", "coordinates": [[[-118.02339, 33.79704], [-118.02339, 33.79628], [-118.02337, 33.7962], [-118.02331, 33.79613], [-118.02319, 33.79608], [-118.02281, 33.79607], [-118.02278, 33.79602], [-118.02278, 33.79586], [-118.0228, 33.79581], [-118.02288, 33.79578], [-118.0246, 33.79578], [-118.02464, 33.79579], [-118.0247, 33.79582], [-118.02471, 33.79586], [-118.02471, 33.79602], [-118.02469, 33.79605], [-118.02426, 33.79606], [-118.02412, 33.79611], [-118.02407, 33.79618], [-118.02405, 33.79621], [-118.02405, 33.7965], [-118.02404, 33.79706], [-118.02398, 33.79708], [-118.02347, 33.79708], [-118.02342, 33.79707], [-118.02339, 33.79704]]]} | Open Access 1 | 24500 | Maple Grove Park North | 21774 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 3.109 | Maple Grove Park North | 0 | Local Park 2 | 4 | |
11908 | 11908 | 11907 | {"type": "Polygon", "coordinates": [[[-118.05919, 33.81849], [-118.0564, 33.81853], [-118.05639, 33.81798], [-118.0567, 33.81797], [-118.05669, 33.81771], [-118.05919, 33.81772], [-118.05919, 33.81849]]]} | Open Access 1 | 24502 | Nature Park | 22672 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 5.44 | Nature Park | 0 | Local Park 2 | 4 | |
11946 | 11946 | 11945 | {"type": "Polygon", "coordinates": [[[-118.0313, 33.79525], [-118.03123, 33.79532], [-118.03122, 33.79557], [-118.02994, 33.79559], [-118.02982, 33.79557], [-118.02978, 33.79554], [-118.02977, 33.79499], [-118.03046, 33.795], [-118.03048, 33.79497], [-118.03052, 33.79497], [-118.03053, 33.79501], [-118.03091, 33.79501], [-118.03092, 33.79484], [-118.03123, 33.79484], [-118.03123, 33.79512], [-118.03125, 33.79519], [-118.0313, 33.79525]]]} | Open Access 1 | 24581 | Eucalyptus Park | 18742 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 2.28 | Eucalyptus Park | 0 | Local Park 2 | 4 | |
11960 | 11960 | 11959 | {"type": "Polygon", "coordinates": [[[-118.0466, 33.81324], [-118.0466, 33.81378], [-118.04653, 33.81379], [-118.04652, 33.81419], [-118.04658, 33.8142], [-118.04659, 33.8148], [-118.04572, 33.81479], [-118.04571, 33.81477], [-118.04572, 33.81464], [-118.0458, 33.81431], [-118.04584, 33.81398], [-118.04585, 33.81316], [-118.04615, 33.81316], [-118.04619, 33.81325], [-118.04624, 33.81329], [-118.0463, 33.81331], [-118.04637, 33.81329], [-118.0465, 33.81324], [-118.0466, 33.81324]]]} | Open Access 1 | 24579 | Cedar Glen Park | 16995 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 3.047 | Cedar Glen Park | 0 | Local Park 2 | 4 | |
11961 | 11961 | 11960 | {"type": "Polygon", "coordinates": [[[-118.01964, 33.79547], [-118.01953, 33.79555], [-118.01817, 33.79554], [-118.01812, 33.79552], [-118.0181, 33.79548], [-118.01809, 33.79541], [-118.0181, 33.79453], [-118.01814, 33.79451], [-118.01955, 33.79451], [-118.01961, 33.79453], [-118.01964, 33.79458], [-118.01964, 33.79473], [-118.01964, 33.79547]]]} | Open Access 1 | 24582 | Hettinga/Manzanita Park | 19889 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 4.015 | Hettinga/Manzanita Park | 0 | Local Park 2 | 4 | |
11962 | 11962 | 11961 | {"type": "Polygon", "coordinates": [[[-118.02486, 33.82168], [-118.02485, 33.82174], [-118.02486, 33.82178], [-118.02482, 33.8218], [-118.02483, 33.82231], [-118.0241, 33.82232], [-118.02404, 33.8223], [-118.02403, 33.82227], [-118.02402, 33.82119], [-118.02404, 33.82115], [-118.02482, 33.82113], [-118.02483, 33.82165], [-118.02486, 33.82168]]]} | Open Access 1 | 24583 | Pinewood Park | 23692 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 2.406 | Pinewood Park | 0 | Local Park 2 | 4 | |
11963 | 11963 | 11962 | {"type": "Polygon", "coordinates": [[[-118.03423, 33.82868], [-118.03331, 33.82869], [-118.03329, 33.82867], [-118.03327, 33.82814], [-118.03422, 33.82812], [-118.03423, 33.82868]]]} | Open Access 1 | 24584 | Rosen/Acacia Park | 24624 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 1.336 | Rosen/Acacia Park | 0 | Local Park 2 | 4 | |
12831 | 12831 | 12830 | {"type": "Polygon", "coordinates": [[[-118.03245, 33.81342], [-118.03055, 33.81344], [-118.03055, 33.8132], [-118.03053, 33.81314], [-118.03049, 33.81309], [-118.03039, 33.81304], [-118.03039, 33.81287], [-118.03122, 33.81288], [-118.03176, 33.8127], [-118.03176, 33.81152], [-118.03242, 33.81151], [-118.03245, 33.81342]]]} | Open Access 1 | 30331 | Laurel Park | 21099 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 5.177 | Laurel Park | 0 | Local Park 2 | 4 | |
12852 | 12852 | 12851 | {"type": "Polygon", "coordinates": [[[-118.04053, 33.81486], [-118.03978, 33.81487], [-118.03978, 33.8145], [-118.04011, 33.81449], [-118.04012, 33.81448], [-118.04011, 33.81431], [-118.03975, 33.81431], [-118.03974, 33.81386], [-118.03957, 33.81376], [-118.03907, 33.81375], [-118.03905, 33.8137], [-118.03877, 33.81369], [-118.03875, 33.81347], [-118.03856, 33.81347], [-118.03854, 33.81343], [-118.0385, 33.8134], [-118.03838, 33.81338], [-118.03838, 33.81323], [-118.0405, 33.81321], [-118.04053, 33.81486]]]} | Open Access 1 | 30332 | Damron Park | 17903 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 4.568 | Damron Park | 0 | Local Park 2 | 4 | |
12854 | 12854 | 12853 | {"type": "Polygon", "coordinates": [[[-118.03042, 33.81167], [-118.03018, 33.81168], [-118.03017, 33.8114], [-118.03022, 33.81139], [-118.03022, 33.81116], [-118.03037, 33.8112], [-118.03038, 33.81153], [-118.03042, 33.81154], [-118.03042, 33.81167]]]} | Open Access 1 | 30330 | Vessels Park | 27007 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 0.245 | Vessels Park | 0 | Local Park 2 | 4 | |
12882 | 12882 | 12881 | {"type": "Polygon", "coordinates": [[[-118.05429, 33.81815], [-118.05422, 33.81822], [-118.05373, 33.81824], [-118.05352, 33.81823], [-118.05283, 33.81801], [-118.05218, 33.81778], [-118.05182, 33.81771], [-118.05178, 33.81769], [-118.05177, 33.81764], [-118.05187, 33.81707], [-118.05194, 33.817], [-118.05228, 33.817], [-118.05255, 33.81697], [-118.05347, 33.81698], [-118.05412, 33.81704], [-118.05425, 33.81712], [-118.05425, 33.81768], [-118.05429, 33.81815]]]} | Open Access 1 | 30333 | Veterans Park | 27042 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 6.431 | Veterans 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]);