superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, MNG_AGENCY = 31 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

  • Pleasanton, City of · 1 ✖

ACCESS_TYP 1

  • Restricted Access · 1 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
14603 14603 14602 {"type": "Polygon", "coordinates": [[[-121.8681, 37.62662], [-121.86809, 37.62949], [-121.86746, 37.62949], [-121.86738, 37.62958], [-121.86719, 37.62974], [-121.86701, 37.62999], [-121.86704, 37.63011], [-121.86705, 37.63038], [-121.86702, 37.63046], [-121.86704, 37.63053], [-121.86733, 37.63117], [-121.86726, 37.63131], [-121.86735, 37.63136], [-121.86744, 37.63156], [-121.86696, 37.63156], [-121.86695, 37.63157], [-121.86761, 37.63321], [-121.86754, 37.63324], [-121.86752, 37.63323], [-121.86724, 37.63258], [-121.86693, 37.63267], [-121.86653, 37.63313], [-121.86542, 37.63362], [-121.86487, 37.63389], [-121.86502, 37.63417], [-121.86474, 37.63427], [-121.86444, 37.63433], [-121.86278, 37.63494], [-121.86129, 37.63491], [-121.86113, 37.63488], [-121.86098, 37.63481], [-121.86096, 37.63476], [-121.86101, 37.63462], [-121.86103, 37.6345], [-121.86102, 37.63427], [-121.86164, 37.63401], [-121.86159, 37.63348], [-121.86117, 37.63345], [-121.86142, 37.63313], [-121.86168, 37.63309], [-121.86172, 37.6331], [-121.86217, 37.63287], [-121.86227, 37.63264], [-121.86262, 37.63207], [-121.86196, 37.63105], [-121.86149, 37.6305], [-121.86094, 37.6296], [-121.8606, 37.62883], [-121.86034, 37.62882], [-121.8604, 37.62867], [-121.86041, 37.62853], [-121.86031, 37.62774], [-121.86034, 37.62758], [-121.86041, 37.6274], [-121.86029, 37.62735], [-121.8602, 37.6275], [-121.86012, 37.62748], [-121.85898, 37.62797], [-121.8579, 37.6265], [-121.85797, 37.62603], [-121.85819, 37.62589], [-121.85848, 37.62587], [-121.85881, 37.62593], [-121.85907, 37.62586], [-121.85927, 37.62573], [-121.86018, 37.62572], [-121.86054, 37.6257], [-121.86062, 37.62557], [-121.86053, 37.62523], [-121.86079, 37.62515], [-121.86085, 37.62494], [-121.861, 37.62492], [-121.86109, 37.62488], [-121.86128, 37.62499], [-121.8615, 37.62527], [-121.86166, 37.62542], [-121.86172, 37.62559], [-121.86173, 37.62574], [-121.86216, 37.62596], [-121.86288, 37.6265], [-121.8632, 37.6266], [-121.86336, 37.62669], [-121.86347, 37.62673], [-121.86363, 37.62674], [-121.8637, 37.62672], [-121.86373, 37.62667], [-121.8637, 37.62657], [-121.86319, 37.62626], [-121.86305, 37.626], [-121.863, 37.62595], [-121.86294, 37.62586], [-121.86297, 37.62583], [-121.86306, 37.62567], [-121.86313, 37.62561], [-121.8633, 37.6256], [-121.86351, 37.62565], [-121.86358, 37.62564], [-121.86364, 37.62561], [-121.86368, 37.62557], [-121.86372, 37.62542], [-121.86377, 37.62535], [-121.86395, 37.62528], [-121.86401, 37.62528], [-121.86409, 37.62533], [-121.86419, 37.62535], [-121.86429, 37.62545], [-121.86443, 37.62544], [-121.86454, 37.62545], [-121.86472, 37.62555], [-121.8648, 37.62584], [-121.86506, 37.62594], [-121.86517, 37.62602], [-121.86544, 37.62616], [-121.86554, 37.62628], [-121.86574, 37.62626], [-121.86579, 37.62627], [-121.86595, 37.62662], [-121.86595, 37.62664], [-121.86606, 37.6268], [-121.86624, 37.62694], [-121.86628, 37.627], [-121.86632, 37.62717], [-121.86635, 37.62719], [-121.86642, 37.6272], [-121.86662, 37.62711], [-121.86679, 37.62705], [-121.86685, 37.62702], [-121.86685, 37.62699], [-121.86696, 37.62693], [-121.86718, 37.62701], [-121.86712, 37.62739], [-121.86706, 37.62751], [-121.86716, 37.62766], [-121.86728, 37.62769], [-121.86727, 37.62785], [-121.86722, 37.62798], [-121.867, 37.62835], [-121.86686, 37.6285], [-121.86686, 37.62852], [-121.86691, 37.62854], [-121.86719, 37.6283], [-121.86731, 37.62822], [-121.86747, 37.62785], [-121.86763, 37.62771], [-121.86774, 37.62743], [-121.86791, 37.62731], [-121.868, 37.62701], [-121.86804, 37.62665], [-121.8681, 37.62662]], [[-121.86232, 37.63345], [-121.86168, 37.63343], [-121.8617, 37.63379], [-121.86179, 37.63397], [-121.8621, 37.63405], [-121.86235, 37.63398], [-121.86248, 37.6339], [-121.86248, 37.63351], [-121.86232, 37.63345]], [[-121.86638, 37.62877], [-121.86626, 37.62874], [-121.86603, 37.62888], [-121.86601, 37.62867], [-121.86589, 37.62847], [-121.86563, 37.62841], [-121.86527, 37.62842], [-121.86519, 37.62857], [-121.86521, 37.62865], [-121.86511, 37.62889], [-121.86535, 37.62917], [-121.86549, 37.6291], [-121.86562, 37.6291], [-121.86579, 37.62903], [-121.86585, 37.62931], [-121.866, 37.62918], [-121.86651, 37.62896], [-121.86638, 37.62877]]]} Restricted Access 2 Callippe Preserve Golf Course   33079 1257 Pleasanton, City of 31 City 2 City Agency 2 http://www.cityofpleasantonca.gov/ City 2 130.102 Callippe Preserve GC  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);