units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

19 rows where COUNTY = 3, LAYER = 2 and MNG_AGENCY = 214

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Cypress, City of · 19 ✖

DES_TP 1

ACCESS_TYP 1

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

CSV options: 

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]);