units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, AGNCY_NAME = 32 and DES_TP = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Recreation Area · 1 ✖

ACCESS_TYP 1

  • Restricted 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
15703 15703 15702 {"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.86725, 37.63132], [-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.86725, 37.63257], [-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.86263, 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.86042, 37.62853], [-121.86031, 37.62774], [-121.86034, 37.62758], [-121.86041, 37.6274], [-121.86028, 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.62594], [-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.86101, 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.86374, 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.62559], [-121.86351, 37.62565], [-121.86358, 37.62564], [-121.86364, 37.62561], [-121.86368, 37.62557], [-121.86369, 37.6255], [-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.86516, 37.62602], [-121.86544, 37.62616], [-121.86554, 37.62628], [-121.86574, 37.62626], [-121.86579, 37.62627], [-121.86595, 37.62662], [-121.86594, 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.8668, 37.62705], [-121.86686, 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.86685, 37.6285], [-121.86686, 37.62852], [-121.86691, 37.62854], [-121.86719, 37.6283], [-121.86731, 37.62823], [-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.86167, 37.63343], [-121.8617, 37.63379], [-121.86179, 37.63397], [-121.8621, 37.63405], [-121.86235, 37.63398], [-121.86249, 37.6339], [-121.86248, 37.63351], [-121.86232, 37.63345]], [[-121.86638, 37.62876], [-121.86627, 37.62874], [-121.86603, 37.62888], [-121.86602, 37.62867], [-121.86589, 37.62847], [-121.86563, 37.62841], [-121.86526, 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.86584, 37.62932], [-121.866, 37.62918], [-121.86652, 37.62896], [-121.86638, 37.62876]]]} Restricted Access 2 23675 Callippe Preserve Golf Course 33079 1257 Pleasanton, City of 32 City 2 City Agency 2 http://www.cityofpleasantonca.gov/ City 2 1257 Pleasanton, City of 31 City 2 City Agency 2   Alameda 17 130.046 Callippe Preserve GC 0 Local Recreation Area 3 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]);