units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, LABEL_NAME = "Uvas Canyon County Park" and MNG_AGENCY = 465

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

DES_TP 1

ACCESS_TYP 1

  • Open Access · 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
6380 6380 6379 {"type": "Polygon", "coordinates": [[[-121.81889, 37.09054], [-121.81048, 37.09054], [-121.81034, 37.08688], [-121.79689, 37.08693], [-121.79604, 37.08665], [-121.79596, 37.08665], [-121.79463, 37.08629], [-121.79413, 37.08608], [-121.79233, 37.08564], [-121.79228, 37.0833], [-121.78772, 37.0833], [-121.78762, 37.07966], [-121.78311, 37.07967], [-121.78301, 37.07603], [-121.77853, 37.07588], [-121.7785, 37.07389], [-121.77966, 37.0739], [-121.77967, 37.07389], [-121.77961, 37.07212], [-121.77848, 37.07211], [-121.77845, 37.06896], [-121.78283, 37.06913], [-121.78769, 37.06913], [-121.78753, 37.06216], [-121.78781, 37.06223], [-121.7881, 37.06235], [-121.78815, 37.06242], [-121.78821, 37.06275], [-121.78827, 37.06284], [-121.78838, 37.0629], [-121.78871, 37.06293], [-121.78884, 37.06297], [-121.78899, 37.0631], [-121.78915, 37.06332], [-121.78925, 37.06339], [-121.78938, 37.06341], [-121.78961, 37.0634], [-121.78972, 37.06342], [-121.78981, 37.06347], [-121.78999, 37.06366], [-121.79011, 37.06372], [-121.7902, 37.06373], [-121.79047, 37.0637], [-121.7907, 37.06379], [-121.79104, 37.06379], [-121.79109, 37.06382], [-121.79121, 37.06393], [-121.79138, 37.06398], [-121.79206, 37.06397], [-121.79215, 37.06913], [-121.79189, 37.06915], [-121.79198, 37.07256], [-121.7966, 37.07257], [-121.7967, 37.07602], [-121.801, 37.07602], [-121.81385, 37.07584], [-121.8139, 37.07837], [-121.81731, 37.07833], [-121.81733, 37.07854], [-121.81723, 37.07871], [-121.81718, 37.07886], [-121.81713, 37.07896], [-121.81706, 37.07904], [-121.81691, 37.07916], [-121.81662, 37.07932], [-121.81652, 37.07945], [-121.81649, 37.0796], [-121.81652, 37.07976], [-121.81651, 37.07993], [-121.81394, 37.07996], [-121.814, 37.08314], [-121.81768, 37.0831], [-121.81776, 37.08319], [-121.81789, 37.0833], [-121.81796, 37.08338], [-121.818, 37.08347], [-121.81805, 37.08368], [-121.81814, 37.08381], [-121.81822, 37.08387], [-121.81832, 37.0839], [-121.8187, 37.08397], [-121.81889, 37.09054]]]} Open Access 1 1796 Uvas Canyon County Park 29312 326 Santa Clara County Parks and Recreation Dept., County of 472 County 3 County Agency - Parks 7 http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx County 3 326 Santa Clara County Parks and Recreation Dept., County of 465 County 3 County Agency - Parks 7 http://www.sccgov.org/sites/parks/parkfinder/Pages/UvasCanyon.aspx Santa Clara 19 1145.905 Uvas Canyon County 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]);