units_with_maps

Table actions

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

5 rows where AGNCY_WEB = "http://www.ci.thousand-oaks.ca.us/", MNG_AGENCY = 496 and MNG_AG_TYP = 6

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

  • Open Space District · 5 ✖

MNG_AGENCY 1

  • Conejo Open Space Conservation Agency · 5 ✖

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
7951 7951 7950 {"type": "Polygon", "coordinates": [[[-118.88577, 34.2375], [-118.88101, 34.2362], [-118.881, 34.23473], [-118.88338, 34.23472], [-118.88338, 34.23321], [-118.88457, 34.23321], [-118.88457, 34.23461], [-118.88419, 34.23471], [-118.88468, 34.23472], [-118.88423, 34.23516], [-118.88335, 34.23583], [-118.88577, 34.23649], [-118.88577, 34.2375]]]} Open Access 1 49005 Mount Clef Ridge Open Space - COSCA 22524 1347 Thousand Oaks, City of 428 City 2 City Agency 2 http://www.ci.thousand-oaks.ca.us/ City 2 2024 Conejo Open Space Conservation Agency 496 Special District 4 Open Space District 6 http://www.conejo-openspace.org/mt.-clef.html Ventura 8 23.22 Mount Clef Ridge OS - COSCA   None 663  
10033 10033 10032 {"type": "Polygon", "coordinates": [[[-118.99143, 34.15817], [-118.99103, 34.15857], [-118.99079, 34.15858], [-118.99057, 34.15855], [-118.99035, 34.15849], [-118.99016, 34.1584], [-118.98998, 34.15826], [-118.98983, 34.1581], [-118.98903, 34.15682], [-118.98894, 34.1567], [-118.98881, 34.15658], [-118.98867, 34.15647], [-118.98851, 34.15638], [-118.98833, 34.15631], [-118.98984, 34.15631], [-118.99122, 34.15735], [-118.99143, 34.15817]]]} Open Access 1 49022 Vista Del Mar Open Space 33722 1347 Thousand Oaks, City of 428 City 2 City Agency 2 http://www.ci.thousand-oaks.ca.us/ City 2 2024 Conejo Open Space Conservation Agency 496 Special District 4 Open Space District 6 http://www.conejo-openspace.org/vista-del-mar.html Ventura 8 8.702 Vista Del Mar OS 2008 Local Recreation Area 3 4
15391 15391 15390 {"type": "Polygon", "coordinates": [[[-118.96432, 34.19047], [-118.96431, 34.19886], [-118.95984, 34.19957], [-118.95976, 34.19948], [-118.95916, 34.19971], [-118.95836, 34.19959], [-118.95836, 34.19945], [-118.95848, 34.19888], [-118.95918, 34.19877], [-118.95999, 34.19653], [-118.96333, 34.19652], [-118.96333, 34.19525], [-118.96347, 34.19524], [-118.96347, 34.19389], [-118.96193, 34.19396], [-118.96116, 34.19173], [-118.96135, 34.19081], [-118.96021, 34.1908], [-118.96029, 34.19047], [-118.96432, 34.19047]]]} Open Access 1 49021 Vallecito Open Space 33721 1347 Thousand Oaks, City of 428 City 2 City Agency 2 http://www.ci.thousand-oaks.ca.us/ City 2 2024 Conejo Open Space Conservation Agency 496 Special District 4 Open Space District 6 http://www.conejo-openspace.org/vallecito.html Ventura 8 66.788 Vallecito OS 0 Local Recreation Area 3 4
16107 16107 16106 {"type": "Polygon", "coordinates": [[[-118.94813, 34.15608], [-118.94801, 34.15654], [-118.94796, 34.15651], [-118.94753, 34.15644], [-118.94739, 34.15666], [-118.94763, 34.15685], [-118.94757, 34.15709], [-118.94744, 34.15715], [-118.94721, 34.15691], [-118.94702, 34.15681], [-118.94667, 34.15716], [-118.9465, 34.15711], [-118.9464, 34.15718], [-118.94593, 34.15673], [-118.94618, 34.15659], [-118.94637, 34.15653], [-118.94677, 34.15651], [-118.94722, 34.15658], [-118.94733, 34.15638], [-118.94737, 34.15598], [-118.94755, 34.15596], [-118.94774, 34.15596], [-118.94792, 34.156], [-118.94813, 34.15608]]]} Open Access 1 49018 Deer Ridge Open Space 33719 1347 Thousand Oaks, City of 428 City 2 City Agency 2 http://www.ci.thousand-oaks.ca.us/ City 2 2024 Conejo Open Space Conservation Agency 496 Special District 4 Open Space District 6 http://www.conejo-openspace.org/deer-ridge.html Ventura 8 2.769 Deer Ridge OS 0 Local Recreation Area 3 4
16114 16114 16113 {"type": "Polygon", "coordinates": [[[-118.95456, 34.20563], [-118.947, 34.21744], [-118.94068, 34.21679], [-118.93523, 34.2145], [-118.93489, 34.21376], [-118.93554, 34.21268], [-118.93715, 34.21253], [-118.93816, 34.21187], [-118.93877, 34.21239], [-118.93943, 34.21233], [-118.93948, 34.21228], [-118.9399, 34.21229], [-118.94125, 34.21217], [-118.9419, 34.21156], [-118.9411, 34.21014], [-118.94059, 34.21007], [-118.9409, 34.2098], [-118.94046, 34.20903], [-118.93946, 34.20762], [-118.93858, 34.20769], [-118.93875, 34.20633], [-118.93701, 34.20526], [-118.93646, 34.2055], [-118.93639, 34.20488], [-118.93566, 34.205], [-118.93474, 34.20443], [-118.93467, 34.20405], [-118.93546, 34.20316], [-118.93678, 34.2034], [-118.93787, 34.20255], [-118.93816, 34.20153], [-118.93787, 34.20107], [-118.93714, 34.20139], [-118.93629, 34.20005], [-118.93492, 34.20012], [-118.93491, 34.19935], [-118.93556, 34.19889], [-118.93535, 34.19856], [-118.93347, 34.19823], [-118.93221, 34.19836], [-118.93293, 34.19684], [-118.93433, 34.19687], [-118.93434, 34.19708], [-118.9364, 34.19708], [-118.93639, 34.1979], [-118.93674, 34.1979], [-118.93696, 34.19814], [-118.93738, 34.19813], [-118.93739, 34.19708], [-118.93855, 34.19708], [-118.9387, 34.19763], [-118.93891, 34.19795], [-118.93868, 34.19814], [-118.93855, 34.19829], [-118.93854, 34.20564], [-118.95456, 34.20563]]]} Open Access 1 49002 Conejo Canyons Open Space 30794 1347 Thousand Oaks, City of 428 City 2 City Agency 2 http://www.ci.thousand-oaks.ca.us/ City 2 2024 Conejo Open Space Conservation Agency 496 Special District 4 Open Space District 6 http://www.conejo-openspace.org/open-space.html Ventura 8 410.746 Conejo Canyons OS 0 Local Recreation Area 3 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]);