units_with_maps

Table actions

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

1 row where COUNTY = 15, DES_TP = 655 and MNG_AGENCY = 28

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Mateo County Parks and Recreation Dept., County of · 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
7831 7831 7830 {"type": "Polygon", "coordinates": [[[-122.51046, 37.51201], [-122.51023, 37.51234], [-122.50987, 37.51294], [-122.50983, 37.51292], [-122.50706, 37.51697], [-122.50076, 37.5116], [-122.50136, 37.51061], [-122.50087, 37.51021], [-122.50163, 37.50897], [-122.50091, 37.50795], [-122.50104, 37.50785], [-122.50038, 37.50695], [-122.50001, 37.50719], [-122.49898, 37.50631], [-122.49883, 37.50653], [-122.49817, 37.50681], [-122.49557, 37.50574], [-122.4949, 37.50607], [-122.49505, 37.50582], [-122.49492, 37.50576], [-122.4946, 37.5047], [-122.494, 37.5042], [-122.49436, 37.5036], [-122.49452, 37.50365], [-122.49471, 37.50331], [-122.49457, 37.50324], [-122.49472, 37.50299], [-122.49465, 37.50191], [-122.49398, 37.50143], [-122.49432, 37.50124], [-122.49578, 37.50023], [-122.49585, 37.50037], [-122.49593, 37.50051], [-122.49634, 37.50095], [-122.49652, 37.50132], [-122.49654, 37.50142], [-122.49664, 37.50204], [-122.49673, 37.50251], [-122.49673, 37.50345], [-122.4967, 37.5036], [-122.49666, 37.50368], [-122.49674, 37.50378], [-122.49841, 37.50458], [-122.49871, 37.50239], [-122.49742, 37.50097], [-122.4972, 37.49987], [-122.4983, 37.49966], [-122.49979, 37.49844], [-122.49984, 37.49849], [-122.49978, 37.49862], [-122.49996, 37.49876], [-122.50002, 37.49897], [-122.49996, 37.49897], [-122.49914, 37.49951], [-122.49909, 37.4997], [-122.49903, 37.50002], [-122.49892, 37.50017], [-122.49884, 37.50042], [-122.49887, 37.50077], [-122.49902, 37.50115], [-122.49912, 37.50132], [-122.49954, 37.50174], [-122.49966, 37.50174], [-122.49981, 37.50193], [-122.49974, 37.50204], [-122.49974, 37.50223], [-122.49983, 37.50247], [-122.50002, 37.50288], [-122.50028, 37.50332], [-122.50044, 37.50343], [-122.50067, 37.50356], [-122.5011, 37.50398], [-122.50167, 37.50469], [-122.5019, 37.50487], [-122.50202, 37.50501], [-122.50209, 37.50507], [-122.50219, 37.50512], [-122.50229, 37.50513], [-122.50238, 37.50519], [-122.50258, 37.50522], [-122.50271, 37.50536], [-122.5029, 37.50543], [-122.50306, 37.50554], [-122.50325, 37.50562], [-122.50351, 37.50578], [-122.50374, 37.50595], [-122.50383, 37.506], [-122.50403, 37.50606], [-122.50419, 37.50617], [-122.5043, 37.50616], [-122.50462, 37.5062], [-122.50481, 37.50628], [-122.50487, 37.50634], [-122.50492, 37.50641], [-122.50515, 37.5066], [-122.50542, 37.50688], [-122.5056, 37.50697], [-122.50566, 37.50704], [-122.50581, 37.50716], [-122.50591, 37.50731], [-122.50598, 37.50738], [-122.5061, 37.50752], [-122.50625, 37.50776], [-122.50632, 37.50783], [-122.50638, 37.508], [-122.50646, 37.50806], [-122.50657, 37.5082], [-122.50664, 37.50827], [-122.50674, 37.50843], [-122.50687, 37.50857], [-122.507, 37.5088], [-122.50738, 37.50922], [-122.50761, 37.5094], [-122.5077, 37.50956], [-122.5078, 37.50965], [-122.50804, 37.50923], [-122.50827, 37.50949], [-122.5092, 37.51101], [-122.51046, 37.51201]], [[-122.49897, 37.5063], [-122.49912, 37.50606], [-122.49883, 37.50595], [-122.49869, 37.50619], [-122.49897, 37.5063]]]} Open Access 1 9314 Pillar Point Bluff 23670 324 San Mateo County Parks and Recreation Dept., County of 28 County 3 County Agency - Parks 7 http://www.co.sanmateo.ca.us/portal/site/parks/ County 3 324 San Mateo County Parks and Recreation Dept., County of 28 County 3 County Agency - Parks 7   San Mateo 15 226.452 Pillar Point Bluff   None 655  

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