units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, AGNCY_WEB = "http://sfwater.org/" and DES_TP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Local Conservation Area · 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
16850 16850 16849 {"type": "MultiPolygon", "coordinates": [[[[-121.79156, 37.50476], [-121.79134, 37.51904], [-121.77329, 37.51942], [-121.77349, 37.50472], [-121.79132, 37.50475], [-121.79156, 37.50476]]], [[[-121.87405, 37.50648], [-121.87397, 37.51447], [-121.86949, 37.51447], [-121.86944, 37.51803], [-121.86487, 37.5181], [-121.86496, 37.52091], [-121.86052, 37.52093], [-121.84804, 37.52104], [-121.84802, 37.52104], [-121.84789, 37.52089], [-121.84764, 37.52114], [-121.84773, 37.52161], [-121.84789, 37.52188], [-121.84795, 37.52219], [-121.8479, 37.52282], [-121.84792, 37.52308], [-121.84791, 37.52344], [-121.84757, 37.52368], [-121.84771, 37.52423], [-121.84792, 37.52445], [-121.84807, 37.52452], [-121.84827, 37.5249], [-121.84836, 37.52516], [-121.84844, 37.52517], [-121.84862, 37.52509], [-121.849, 37.52561], [-121.84932, 37.52585], [-121.84964, 37.52624], [-121.84971, 37.52644], [-121.84984, 37.52663], [-121.85003, 37.52681], [-121.84991, 37.52694], [-121.85014, 37.52694], [-121.85003, 37.52711], [-121.85056, 37.5274], [-121.85086, 37.52788], [-121.85115, 37.52822], [-121.85145, 37.52836], [-121.85152, 37.52838], [-121.85173, 37.52861], [-121.85198, 37.52883], [-121.85229, 37.52915], [-121.85217, 37.5293], [-121.85244, 37.52935], [-121.8526, 37.52988], [-121.85281, 37.53021], [-121.85271, 37.5302], [-121.85276, 37.53032], [-121.85277, 37.53054], [-121.85263, 37.5307], [-121.85212, 37.53148], [-121.85209, 37.5316], [-121.85203, 37.53169], [-121.85168, 37.53269], [-121.85171, 37.5335], [-121.8519, 37.53405], [-121.85216, 37.53445], [-121.85237, 37.5348], [-121.85267, 37.53514], [-121.85287, 37.53547], [-121.85305, 37.53569], [-121.8528, 37.53564], [-121.85263, 37.53557], [-121.85226, 37.53555], [-121.85196, 37.53559], [-121.85142, 37.53574], [-121.85089, 37.53583], [-121.85049, 37.53588], [-121.85023, 37.5359], [-121.85, 37.53589], [-121.84978, 37.53595], [-121.8493, 37.53591], [-121.84871, 37.53615], [-121.84833, 37.53615], [-121.84796, 37.53606], [-121.84773, 37.53609], [-121.84735, 37.53629], [-121.84716, 37.53648], [-121.84685, 37.53674], [-121.84646, 37.53688], [-121.84617, 37.53694], [-121.84582, 37.53694], [-121.84552, 37.53705], [-121.84521, 37.53709], [-121.84463, 37.53699], [-121.84444, 37.53701], [-121.84434, 37.53704], [-121.84415, 37.53703], [-121.84384, 37.53693], [-121.84343, 37.5369], [-121.84339, 37.53685], [-121.84323, 37.53683], [-121.84325, 37.5352], [-121.83885, 37.5352], [-121.8389, 37.52886], [-121.83433, 37.52892], [-121.83432, 37.52138], [-121.83435, 37.51299], [-121.8282, 37.51317], [-121.82799, 37.51335], [-121.82789, 37.51329], [-121.82778, 37.51319], [-121.82478, 37.51328], [-121.82498, 37.50593], [-121.81606, 37.50569], [-121.81589, 37.50578], [-121.81578, 37.52129], [-121.80715, 37.52064], [-121.80686, 37.50545], [-121.81386, 37.50563], [-121.81415, 37.5054], [-121.81492, 37.50464], [-121.81576, 37.50409], [-121.81698, 37.5036], [-121.81907, 37.50437], [-121.81948, 37.50513], [-121.81977, 37.50495], [-121.81956, 37.50443], [-121.81987, 37.50434], [-121.82052, 37.5033], [-121.8222, 37.50333], [-121.82486, 37.50313], [-121.82524, 37.50319], [-121.82543, 37.50361], [-121.82565, 37.50399], [-121.82603, 37.50385], [-121.82641, 37.50342], [-121.82703, 37.50361], [-121.82791, 37.50396], [-121.82867, 37.50442], [-121.82899, 37.5048], [-121.83019, 37.50608], [-121.84289, 37.50646], [-121.85985, 37.50665], [-121.85999, 37.50648], [-121.86938, 37.50648], [-121.86939, 37.50649], [-121.87405, 37.50648]], [[-121.85612, 37.51725], [-121.85397, 37.51724], [-121.85395, 37.5181], [-121.85611, 37.51811], [-121.85612, 37.51725]]]]} Open Access 1 29545 Sunol Regional Wilderness 10841 321 San Francisco - Public Utilities Commission, City and County of 31 County 3 County Agency - Other 9 http://sfwater.org/ County 3 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/parks/sunol Alameda 17 2997.505 Sunol Reg. Wilderness 1962 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]);