units_with_maps

Table actions

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

1 row where MNG_AG_TYP = 7 and PARK_URL = "http://www.sccgov.org/sites/parks/parkfinder/Pages/MotorcycleCountyPark.aspx"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency - Parks · 1 ✖

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
10289 10289 10288 {"type": "Polygon", "coordinates": [[[-121.74562, 37.23219], [-121.74562, 37.23221], [-121.7453, 37.23234], [-121.74521, 37.23242], [-121.74509, 37.23255], [-121.74499, 37.2326], [-121.7449, 37.2326], [-121.74468, 37.23255], [-121.7445, 37.23254], [-121.74426, 37.23258], [-121.74415, 37.23261], [-121.74389, 37.23275], [-121.74381, 37.23277], [-121.74371, 37.23276], [-121.74349, 37.23269], [-121.74339, 37.23268], [-121.7432, 37.23271], [-121.74305, 37.23276], [-121.74278, 37.23295], [-121.7425, 37.23319], [-121.74181, 37.23395], [-121.74173, 37.23402], [-121.74164, 37.23405], [-121.74155, 37.23404], [-121.74129, 37.23393], [-121.74117, 37.2339], [-121.74103, 37.23391], [-121.74096, 37.23396], [-121.74091, 37.23404], [-121.74091, 37.23417], [-121.74097, 37.23426], [-121.74117, 37.2344], [-121.74117, 37.23446], [-121.74112, 37.23451], [-121.74105, 37.23454], [-121.74065, 37.2346], [-121.7405, 37.23464], [-121.74017, 37.23475], [-121.73991, 37.23489], [-121.73979, 37.23493], [-121.73968, 37.23493], [-121.73957, 37.23492], [-121.73936, 37.23483], [-121.73826, 37.23452], [-121.73805, 37.2345], [-121.73758, 37.23448], [-121.73742, 37.23451], [-121.73732, 37.23454], [-121.73717, 37.23465], [-121.73711, 37.23474], [-121.73708, 37.23484], [-121.7371, 37.2351], [-121.73708, 37.23514], [-121.73702, 37.23516], [-121.73693, 37.23514], [-121.73668, 37.23499], [-121.73657, 37.23497], [-121.73647, 37.23498], [-121.73622, 37.23506], [-121.73588, 37.23509], [-121.7354, 37.23516], [-121.73454, 37.23507], [-121.73416, 37.2351], [-121.73397, 37.23504], [-121.73383, 37.23502], [-121.73361, 37.23505], [-121.73317, 37.23517], [-121.73289, 37.23518], [-121.73243, 37.23516], [-121.73233, 37.23517], [-121.73204, 37.23523], [-121.73194, 37.23522], [-121.73149, 37.23505], [-121.7311, 37.23493], [-121.73096, 37.2349], [-121.73069, 37.23492], [-121.73004, 37.23508], [-121.72988, 37.23507], [-121.7296, 37.235], [-121.72945, 37.235], [-121.72924, 37.23503], [-121.72913, 37.23508], [-121.72896, 37.23518], [-121.7283, 37.23579], [-121.72809, 37.23605], [-121.72797, 37.23624], [-121.72786, 37.23646], [-121.72771, 37.23682], [-121.72766, 37.23691], [-121.72757, 37.237], [-121.72712, 37.23738], [-121.727, 37.23746], [-121.72683, 37.23752], [-121.72654, 37.23754], [-121.72625, 37.23751], [-121.72569, 37.23737], [-121.72531, 37.23732], [-121.72495, 37.23733], [-121.72449, 37.23741], [-121.72422, 37.23744], [-121.72396, 37.23742], [-121.72377, 37.23736], [-121.72339, 37.2372], [-121.7226, 37.23678], [-121.72234, 37.23667], [-121.72178, 37.23657], [-121.72111, 37.2365], [-121.72033, 37.23651], [-121.71954, 37.23659], [-121.71953, 37.2366], [-121.71955, 37.23662], [-121.71876, 37.23682], [-121.7179, 37.23706], [-121.71559, 37.23464], [-121.7172, 37.23464], [-121.71721, 37.23462], [-121.71453, 37.23233], [-121.72414, 37.22584], [-121.73351, 37.22881], [-121.73276, 37.23034], [-121.7392, 37.23238], [-121.741, 37.23086], [-121.74381, 37.23014], [-121.74562, 37.23219]]]} Open Access 1 18056 Motorcycle County Park 29286 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/MotorcycleCountyPark.aspx Santa Clara 19 445.447 Motorcycle 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]);