units_with_maps

Table actions

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

1 row where DES_TP = 2 and PARK_URL = "http://www.larpd.org/open_space/sycamore.html"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Local Park · 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
6281 6281 6280 {"type": "Polygon", "coordinates": [[[-121.78658, 37.62857], [-121.78639, 37.62858], [-121.78639, 37.629], [-121.78301, 37.63081], [-121.78301, 37.63221], [-121.78169, 37.63162], [-121.78099, 37.63201], [-121.77771, 37.63469], [-121.77856, 37.63573], [-121.77897, 37.63582], [-121.77921, 37.63623], [-121.77965, 37.63653], [-121.77979, 37.63678], [-121.779, 37.63755], [-121.78164, 37.63973], [-121.78239, 37.64025], [-121.78297, 37.64099], [-121.78298, 37.64103], [-121.78298, 37.64187], [-121.78303, 37.64198], [-121.783, 37.64511], [-121.78017, 37.64511], [-121.78016, 37.64456], [-121.77334, 37.64016], [-121.77442, 37.63941], [-121.77442, 37.6394], [-121.76549, 37.63598], [-121.7649, 37.63596], [-121.76378, 37.63796], [-121.76341, 37.63779], [-121.76341, 37.63776], [-121.76197, 37.63689], [-121.76193, 37.63691], [-121.761, 37.63635], [-121.76005, 37.63603], [-121.75954, 37.63572], [-121.7589, 37.635], [-121.75806, 37.63426], [-121.75585, 37.63251], [-121.75566, 37.63222], [-121.75562, 37.63187], [-121.75547, 37.63119], [-121.75543, 37.63067], [-121.75555, 37.63037], [-121.75597, 37.62978], [-121.75602, 37.62951], [-121.75839, 37.62951], [-121.7587, 37.63008], [-121.75854, 37.63151], [-121.75914, 37.63199], [-121.75989, 37.63222], [-121.76148, 37.63231], [-121.76343, 37.63202], [-121.76358, 37.63204], [-121.7638, 37.63203], [-121.76409, 37.63198], [-121.76519, 37.6316], [-121.76571, 37.63146], [-121.7663, 37.63135], [-121.76661, 37.63132], [-121.76697, 37.63133], [-121.76731, 37.6314], [-121.76839, 37.6317], [-121.76951, 37.63212], [-121.76974, 37.63218], [-121.77002, 37.63222], [-121.77003, 37.63221], [-121.77003, 37.6315], [-121.77034, 37.63139], [-121.77076, 37.63138], [-121.77119, 37.63148], [-121.77159, 37.6317], [-121.77259, 37.63185], [-121.77329, 37.63181], [-121.77317, 37.63095], [-121.77286, 37.62999], [-121.77233, 37.62864], [-121.77225, 37.62807], [-121.77203, 37.62782], [-121.77003, 37.62782], [-121.77003, 37.62239], [-121.78373, 37.62241], [-121.78376, 37.62256], [-121.78454, 37.62258], [-121.7849, 37.62297], [-121.78524, 37.62373], [-121.78524, 37.62422], [-121.78591, 37.62585], [-121.78588, 37.62623], [-121.78639, 37.62693], [-121.78657, 37.62688], [-121.78658, 37.62857]]]} Open Access 1 1367 Sycamore Grove Park 5294 2062 Livermore Area Recreation and Park District 394 Special District 4 Recreation/Parks District 4 http://www.larpd.dst.ca.us/ Special District 4 2062 Livermore Area Recreation and Park District 388 Special District 4 Recreation/Parks District 4 http://www.larpd.org/open_space/sycamore.html Alameda 17 730.948 Sycamore Grove 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]);