units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1 and MNG_AGENCY = 802

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
6035 6035 6034 {"type": "Polygon", "coordinates": [[[-121.32629, 39.06195], [-121.3262, 39.06219], [-121.32455, 39.06449], [-121.32446, 39.06432], [-121.32444, 39.06432], [-121.32419, 39.06471], [-121.32392, 39.06495], [-121.32362, 39.06511], [-121.32323, 39.0652], [-121.3161, 39.06519], [-121.31608, 39.06617], [-121.31433, 39.06532], [-121.3141, 39.06518], [-121.30308, 39.06511], [-121.30316, 39.05903], [-121.30234, 39.05904], [-121.30219, 39.06131], [-121.30048, 39.06088], [-121.29973, 39.063], [-121.2979, 39.06267], [-121.29789, 39.06268], [-121.30002, 39.06449], [-121.30005, 39.06509], [-121.30003, 39.06523], [-121.30003, 39.06702], [-121.29874, 39.07054], [-121.29861, 39.07061], [-121.29861, 39.07063], [-121.29912, 39.07649], [-121.29815, 39.0768], [-121.29621, 39.07433], [-121.29611, 39.07433], [-121.29376, 39.07127], [-121.29003, 39.06663], [-121.28899, 39.06697], [-121.29008, 39.07248], [-121.29071, 39.07538], [-121.28975, 39.07786], [-121.28859, 39.07771], [-121.28628, 39.07357], [-121.28378, 39.07411], [-121.2829, 39.0729], [-121.28181, 39.07132], [-121.27987, 39.06846], [-121.27983, 39.06845], [-121.2798, 39.05769], [-121.28011, 39.05769], [-121.28021, 39.05905], [-121.28266, 39.0583], [-121.28575, 39.06172], [-121.2873, 39.05932], [-121.28634, 39.05701], [-121.28865, 39.05585], [-121.2912, 39.05689], [-121.29121, 39.05687], [-121.2911, 39.05667], [-121.29189, 39.05631], [-121.28812, 39.05453], [-121.28805, 39.05341], [-121.29046, 39.05328], [-121.29085, 39.05108], [-121.28921, 39.0502], [-121.28655, 39.0509], [-121.28622, 39.04977], [-121.28722, 39.04823], [-121.28597, 39.0479], [-121.28576, 39.04397], [-121.28468, 39.04312], [-121.28452, 39.03597], [-121.28511, 39.03603], [-121.28584, 39.03619], [-121.28631, 39.03622], [-121.28664, 39.03628], [-121.28705, 39.0364], [-121.28782, 39.0365], [-121.28815, 39.03653], [-121.28886, 39.03665], [-121.28918, 39.03668], [-121.28976, 39.03684], [-121.29029, 39.03701], [-121.29044, 39.03713], [-121.29096, 39.03743], [-121.29124, 39.03767], [-121.29153, 39.03808], [-121.29165, 39.03833], [-121.29172, 39.03857], [-121.29183, 39.03922], [-121.29194, 39.03973], [-121.29194, 39.04016], [-121.292, 39.04057], [-121.29218, 39.04119], [-121.2924, 39.04171], [-121.29256, 39.04195], [-121.29294, 39.04271], [-121.29322, 39.04352], [-121.29374, 39.0442], [-121.29393, 39.04442], [-121.29423, 39.04465], [-121.29499, 39.04498], [-121.29522, 39.04504], [-121.29582, 39.04531], [-121.29638, 39.04563], [-121.29686, 39.04582], [-121.29723, 39.04607], [-121.29798, 39.0465], [-121.29831, 39.04665], [-121.29883, 39.04696], [-121.29931, 39.04716], [-121.29954, 39.0473], [-121.29976, 39.04739], [-121.29996, 39.0475], [-121.30013, 39.04753], [-121.30028, 39.04753], [-121.30058, 39.04749], [-121.3011, 39.04748], [-121.30138, 39.0475], [-121.30164, 39.04757], [-121.30189, 39.04762], [-121.30211, 39.04773], [-121.30231, 39.04788], [-121.30246, 39.04793], [-121.30265, 39.04815], [-121.30291, 39.04861], [-121.30299, 39.04872], [-121.30318, 39.04943], [-121.30332, 39.04984], [-121.30343, 39.05046], [-121.30356, 39.05083], [-121.30379, 39.05124], [-121.3044, 39.05211], [-121.30468, 39.05236], [-121.30483, 39.05246], [-121.30537, 39.05274], [-121.3056, 39.05281], [-121.30587, 39.05292], [-121.3061, 39.05296], [-121.30634, 39.05304], [-121.30662, 39.05304], [-121.30688, 39.05308], [-121.30707, 39.05306], [-121.30728, 39.05296], [-121.30749, 39.05294], [-121.30845, 39.05275], [-121.30909, 39.05266], [-121.30945, 39.05256], [-121.30984, 39.05248], [-121.31023, 39.05235], [-121.31061, 39.05227], [-121.31098, 39.05221], [-121.31185, 39.05189], [-121.31233, 39.05163], [-121.3131, 39.05124], [-121.31358, 39.05106], [-121.31402, 39.05085], [-121.31473, 39.05047], [-121.31508, 39.05034], [-121.31558, 39.05011], [-121.31596, 39.04998], [-121.31624, 39.04985], [-121.31739, 39.04955], [-121.31768, 39.0495], [-121.31799, 39.04939], [-121.31864, 39.04921], [-121.31867, 39.04924], [-121.32036, 39.04907], [-121.32101, 39.05002], [-121.32242, 39.05154], [-121.3224, 39.05322], [-121.32191, 39.05332], [-121.32212, 39.05379], [-121.32241, 39.05528], [-121.32242, 39.05557], [-121.3223, 39.0563], [-121.3223, 39.0565], [-121.32236, 39.05663], [-121.32256, 39.05692], [-121.32274, 39.05712], [-121.3238, 39.05846], [-121.3239, 39.05846], [-121.32525, 39.06021], [-121.32623, 39.0616], [-121.32629, 39.06195]]]} Open Access 1 736 Camp Far West Reservoir 12744 2159 South Sutter Water District 824 Special District 4 Water District 13 http://www.foothillswaternetwork.org/about%20us/interactive-journey/ssw.php Special District 4 2159 South Sutter Water District 802 Special District 4 Water District 13 http://www.campfarwestlake.net/aboutus.htm Yuba 25 1968.35 Camp Far West Reservoir 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]);