units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 3, DES_TP = 3 and MNG_AG_TYP = 6

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Open Space District · 2 ✖

DES_TP 1

  • Local Recreation Area · 2 ✖

ACCESS_TYP 1

  • No Public Access · 2 ✖
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
2887 2887 2886 {"type": "Polygon", "coordinates": [[[-118.84526, 34.14121], [-118.84508, 34.14159], [-118.84522, 34.14267], [-118.84416, 34.14354], [-118.84341, 34.14305], [-118.8431, 34.14296], [-118.84277, 34.14318], [-118.84221, 34.14277], [-118.84222, 34.14259], [-118.84241, 34.1424], [-118.84258, 34.14219], [-118.84301, 34.14178], [-118.84324, 34.14153], [-118.84343, 34.14145], [-118.84344, 34.1413], [-118.84369, 34.1412], [-118.84394, 34.14106], [-118.84411, 34.14111], [-118.84433, 34.14102], [-118.84434, 34.1409], [-118.84443, 34.14087], [-118.84447, 34.14081], [-118.84456, 34.14084], [-118.84473, 34.14066], [-118.84526, 34.14121]]]} No Public Access 3 1005 Southshore Hills Open Space 25695 2024 Conejo Open Space Conservation Agency 504 Special District 4 Open Space District 6 http://www.conejo-openspace.org/ Special District 4 2024 Conejo Open Space Conservation Agency 496 Special District 4 Open Space District 6   Ventura 8 12.796 Southshore Hills OS 0 Local Recreation Area 3 4
16131 16131 16130 {"type": "Polygon", "coordinates": [[[-118.8652, 34.1282], [-118.86121, 34.13049], [-118.86299, 34.13597], [-118.85869, 34.13651], [-118.85702, 34.1388], [-118.85688, 34.13874], [-118.85677, 34.13887], [-118.85669, 34.13933], [-118.85672, 34.13936], [-118.85558, 34.13936], [-118.8556, 34.14318], [-118.85034, 34.14283], [-118.84995, 34.14271], [-118.84972, 34.14255], [-118.84941, 34.14244], [-118.84927, 34.14268], [-118.84912, 34.14288], [-118.84848, 34.14251], [-118.84744, 34.14241], [-118.84563, 34.14069], [-118.84679, 34.14002], [-118.84614, 34.13892], [-118.84533, 34.13905], [-118.8449, 34.1384], [-118.84507, 34.13807], [-118.84421, 34.13779], [-118.84366, 34.13876], [-118.84251, 34.13861], [-118.84181, 34.13877], [-118.84161, 34.13899], [-118.84134, 34.13906], [-118.84135, 34.13927], [-118.84123, 34.13944], [-118.84125, 34.13956], [-118.8411, 34.13955], [-118.84112, 34.13952], [-118.84116, 34.1395], [-118.84116, 34.13938], [-118.84111, 34.13935], [-118.84106, 34.13922], [-118.84098, 34.13911], [-118.84091, 34.13903], [-118.8408, 34.13895], [-118.84068, 34.13889], [-118.8405, 34.13885], [-118.83976, 34.13877], [-118.83985, 34.13807], [-118.84, 34.13797], [-118.83969, 34.13763], [-118.83955, 34.13754], [-118.8394, 34.13766], [-118.83933, 34.13773], [-118.83895, 34.13751], [-118.8409, 34.13632], [-118.8412, 34.13696], [-118.84084, 34.13714], [-118.84109, 34.13755], [-118.84188, 34.13724], [-118.84219, 34.13746], [-118.84204, 34.1379], [-118.8429, 34.138], [-118.84373, 34.13714], [-118.84426, 34.13705], [-118.84455, 34.13687], [-118.84452, 34.13636], [-118.84487, 34.13601], [-118.84635, 34.13582], [-118.84619, 34.13525], [-118.8454, 34.13514], [-118.84483, 34.1352], [-118.8444, 34.13474], [-118.84415, 34.13432], [-118.85657, 34.12671], [-118.85675, 34.12683], [-118.85835, 34.12756], [-118.85901, 34.12755], [-118.85914, 34.12666], [-118.86051, 34.12589], [-118.86205, 34.12655], [-118.86256, 34.12655], [-118.86464, 34.12711], [-118.8652, 34.1282]]]} No Public Access 3 17212 Lake Eleanor Open Space 20885 2024 Conejo Open Space Conservation Agency 504 Special District 4 Open Space District 6 http://www.conejo-openspace.org/ Special District 4 2024 Conejo Open Space Conservation Agency 496 Special District 4 Open Space District 6   Ventura 8 523.143 Lake Eleanor 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]);