units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, DES_TP = 1420 and MNG_AG_LEV = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

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
16910 16910 16909 {"type": "Polygon", "coordinates": [[[-122.33036, 37.52058], [-122.33006, 37.52091], [-122.32899, 37.52069], [-122.32764, 37.52097], [-122.32656, 37.52146], [-122.32553, 37.52223], [-122.32553, 37.52224], [-122.32578, 37.52241], [-122.32567, 37.52252], [-122.32538, 37.52262], [-122.32526, 37.5227], [-122.32521, 37.52266], [-122.32513, 37.52271], [-122.32518, 37.52276], [-122.32501, 37.52288], [-122.32517, 37.52303], [-122.32506, 37.5232], [-122.32496, 37.52343], [-122.3248, 37.52339], [-122.32441, 37.52369], [-122.32445, 37.52385], [-122.32402, 37.52429], [-122.32415, 37.52442], [-122.32402, 37.52458], [-122.32394, 37.52475], [-122.32391, 37.52494], [-122.32393, 37.52514], [-122.32413, 37.52511], [-122.32418, 37.52525], [-122.32427, 37.52539], [-122.32435, 37.52547], [-122.32441, 37.52548], [-122.32456, 37.5256], [-122.32476, 37.52581], [-122.32498, 37.52623], [-122.32507, 37.52633], [-122.32512, 37.52634], [-122.32524, 37.52648], [-122.32573, 37.5272], [-122.32554, 37.52728], [-122.32526, 37.52685], [-122.32487, 37.52699], [-122.32485, 37.52692], [-122.32439, 37.52702], [-122.32443, 37.52721], [-122.32427, 37.52725], [-122.3243, 37.5275], [-122.32399, 37.52749], [-122.32378, 37.52753], [-122.32371, 37.52736], [-122.32365, 37.52737], [-122.32331, 37.52727], [-122.32215, 37.52724], [-122.32196, 37.52811], [-122.32151, 37.52822], [-122.32126, 37.52752], [-122.32126, 37.52721], [-122.32119, 37.52705], [-122.32095, 37.527], [-122.32063, 37.52711], [-122.32044, 37.52723], [-122.32059, 37.52748], [-122.32045, 37.52773], [-122.32041, 37.52801], [-122.32006, 37.52816], [-122.32001, 37.52815], [-122.3198, 37.52794], [-122.31951, 37.52812], [-122.31953, 37.52823], [-122.31945, 37.52824], [-122.31943, 37.52816], [-122.31874, 37.52819], [-122.31849, 37.52826], [-122.3179, 37.52849], [-122.31767, 37.52852], [-122.31746, 37.52856], [-122.31722, 37.52857], [-122.31683, 37.52877], [-122.31637, 37.52843], [-122.31597, 37.52836], [-122.31579, 37.52842], [-122.31555, 37.52795], [-122.31563, 37.52785], [-122.31581, 37.52781], [-122.31583, 37.52792], [-122.31606, 37.52781], [-122.31626, 37.52772], [-122.31635, 37.52758], [-122.31658, 37.52761], [-122.31667, 37.52757], [-122.3167, 37.52742], [-122.31676, 37.52734], [-122.31694, 37.52746], [-122.31705, 37.52746], [-122.31724, 37.52736], [-122.31725, 37.52726], [-122.31751, 37.52726], [-122.31802, 37.52711], [-122.3184, 37.52708], [-122.31841, 37.52705], [-122.3185, 37.52705], [-122.31857, 37.52702], [-122.31857, 37.5269], [-122.31835, 37.52691], [-122.3183, 37.52677], [-122.31786, 37.52677], [-122.31737, 37.52684], [-122.31705, 37.52693], [-122.31679, 37.52702], [-122.31587, 37.5263], [-122.31625, 37.52599], [-122.31624, 37.52597], [-122.31434, 37.52534], [-122.3142, 37.52521], [-122.31453, 37.52477], [-122.31459, 37.52438], [-122.31429, 37.52405], [-122.31419, 37.52386], [-122.31412, 37.52358], [-122.31328, 37.52356], [-122.31324, 37.52381], [-122.31335, 37.5242], [-122.31331, 37.52455], [-122.3129, 37.52486], [-122.3136, 37.52621], [-122.31334, 37.52678], [-122.31307, 37.5269], [-122.313, 37.52675], [-122.31217, 37.5269], [-122.31232, 37.52669], [-122.31225, 37.5263], [-122.31204, 37.52592], [-122.31169, 37.52551], [-122.31204, 37.52522], [-122.31199, 37.52511], [-122.31215, 37.5251], [-122.31214, 37.52503], [-122.31231, 37.52468], [-122.31189, 37.52452], [-122.312, 37.52426], [-122.31196, 37.52424], [-122.31262, 37.52268], [-122.31339, 37.52159], [-122.31382, 37.52142], [-122.31423, 37.5214], [-122.31455, 37.52114], [-122.31472, 37.52074], [-122.3148, 37.52014], [-122.31492, 37.51953], [-122.31506, 37.51925], [-122.31538, 37.51923], [-122.31606, 37.51943], [-122.31641, 37.51946], [-122.31735, 37.51937], [-122.31782, 37.51923], [-122.3186, 37.51929], [-122.31928, 37.51925], [-122.31963, 37.51946], [-122.32012, 37.51983], [-122.32056, 37.52046], [-122.32155, 37.5212], [-122.32184, 37.52121], [-122.32248, 37.52097], [-122.32277, 37.52082], [-122.32291, 37.52076], [-122.3232, 37.5207], [-122.32329, 37.52074], [-122.32337, 37.52085], [-122.3235, 37.52099], [-122.32375, 37.521], [-122.32441, 37.5205], [-122.32458, 37.52028], [-122.32497, 37.52018], [-122.32533, 37.51988], [-122.32543, 37.51959], [-122.32545, 37.51935], [-122.32554, 37.51908], [-122.32546, 37.51879], [-122.32538, 37.51865], [-122.32525, 37.51853], [-122.32513, 37.51846], [-122.32511, 37.51836], [-122.32516, 37.51809], [-122.32506, 37.51782], [-122.32508, 37.51769], [-122.32505, 37.51753], [-122.32489, 37.51731], [-122.32492, 37.51724], [-122.32519, 37.51715], [-122.32556, 37.51712], [-122.32578, 37.51686], [-122.32585, 37.51672], [-122.32587, 37.51658], [-122.32593, 37.51647], [-122.32675, 37.51559], [-122.32691, 37.51532], [-122.32691, 37.51505], [-122.32736, 37.51541], [-122.32679, 37.51587], [-122.32722, 37.51663], [-122.32694, 37.51683], [-122.32623, 37.51782], [-122.3269, 37.51829], [-122.32788, 37.51813], [-122.32848, 37.5177], [-122.32923, 37.51866], [-122.32761, 37.51891], [-122.32704, 37.51962], [-122.32729, 37.52014], [-122.32815, 37.52034], [-122.3294, 37.5199], [-122.32963, 37.52028], [-122.33036, 37.52058]]]} Open Access 1 14062 Laurelwood Park and Sugarloaf Mountain 29306 1310 San Mateo, City of 98 City 2 City Agency 2 http://www.cityofsanmateo.org/index.aspx?nid=324 City 2 1310 San Mateo, City of 96 City 2 City Agency 2 http://www.cityofsanmateo.org/index.aspx?NID=2449 San Mateo 15 236.587 Laurelwood Park and Sugarloaf Mtn. 2000 None 1420  

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