units_with_maps

Table actions

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

1 row where AGNCY_NAME = 531, DES_TP = 4 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Conservation Area · 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
14656 14656 14655 {"type": "Polygon", "coordinates": [[[-122.26076, 38.07691], [-122.26064, 38.0769], [-122.26063, 38.07694], [-122.25758, 38.07677], [-122.2557, 38.07638], [-122.25595, 38.07779], [-122.2569, 38.07836], [-122.25772, 38.0818], [-122.25793, 38.08285], [-122.25917, 38.08302], [-122.25879, 38.08349], [-122.25825, 38.08339], [-122.25824, 38.0834], [-122.25873, 38.08378], [-122.25901, 38.08386], [-122.26016, 38.08403], [-122.25886, 38.0844], [-122.26004, 38.08473], [-122.25888, 38.08472], [-122.2582, 38.08463], [-122.25799, 38.08463], [-122.25783, 38.08472], [-122.25682, 38.08369], [-122.25648, 38.08233], [-122.25642, 38.0818], [-122.25625, 38.08136], [-122.25608, 38.08105], [-122.2553, 38.08068], [-122.25544, 38.08059], [-122.25543, 38.08058], [-122.25322, 38.07996], [-122.25387, 38.0795], [-122.25321, 38.07877], [-122.25264, 38.07903], [-122.2507, 38.07665], [-122.25133, 38.0765], [-122.25284, 38.0755], [-122.25368, 38.07531], [-122.25483, 38.0753], [-122.25564, 38.07534], [-122.25591, 38.07527], [-122.25604, 38.07515], [-122.25659, 38.07432], [-122.25704, 38.07441], [-122.25737, 38.07472], [-122.25771, 38.07484], [-122.25796, 38.07497], [-122.25807, 38.07533], [-122.25857, 38.07549], [-122.25899, 38.07592], [-122.25921, 38.076], [-122.25952, 38.0763], [-122.26039, 38.07621], [-122.26043, 38.07599], [-122.2605, 38.07594], [-122.26059, 38.07596], [-122.26042, 38.07647], [-122.26076, 38.07691]]]} Open Access 1 44916 Mare Island Shoreline Heritage Preserve 21800 1365 Vallejo, City of 531 City 2 City Agency 2 http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails City 2 1365 Vallejo, City of 524 City 2 City Agency 2   Solano 26 83.482 Mare Island Shoreline Heritage Preserve 0 Local Conservation Area 4 2

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