units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, COUNTY = 49 and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 2 ✖
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
3235 3235 3234 {"type": "MultiPolygon", "coordinates": [[[[-122.00869, 39.3834], [-122.00714, 39.38191], [-122.0054, 39.38067], [-122.00292, 39.37969], [-122.00171, 39.37912], [-121.99818, 39.37897], [-121.99817, 39.37898], [-121.99801, 39.38382], [-121.99772, 39.38388], [-121.9904, 39.38389], [-121.99025, 39.38381], [-121.99064, 39.38338], [-121.99132, 39.38288], [-121.99194, 39.38265], [-121.99289, 39.38253], [-121.99326, 39.38232], [-121.99362, 39.38151], [-121.99366, 39.38109], [-121.99356, 39.38061], [-121.99333, 39.38016], [-121.9931, 39.37953], [-121.99301, 39.37898], [-121.99308, 39.37842], [-121.99337, 39.37774], [-121.99392, 39.37706], [-121.9945, 39.37646], [-121.99507, 39.37593], [-121.99566, 39.37548], [-121.99572, 39.37541], [-121.99584, 39.37518], [-121.99588, 39.37466], [-121.99586, 39.37403], [-121.9957, 39.37329], [-121.99558, 39.37195], [-121.9956, 39.37142], [-122.00122, 39.3715], [-122.00119, 39.37253], [-122.00131, 39.37315], [-122.00124, 39.37345], [-122.00108, 39.37372], [-122.00076, 39.37415], [-122.00064, 39.37442], [-122.00064, 39.37455], [-122.00243, 39.37458], [-122.00264, 39.37469], [-122.0054, 39.37516], [-122.00851, 39.3755], [-122.00844, 39.37563], [-122.00824, 39.37588], [-122.00858, 39.37599], [-122.00935, 39.37684], [-122.00967, 39.37805], [-122.00983, 39.37935], [-122.00974, 39.3805], [-122.00869, 39.3834]]], [[[-122.00741, 39.244], [-122.00434, 39.24588], [-122.00196, 39.24728], [-122.00086, 39.24564], [-122.00084, 39.24564], [-122.00063, 39.24504], [-122.00069, 39.24503], [-122.00068, 39.24394], [-122.00084, 39.24294], [-122.00112, 39.24226], [-122.0015, 39.24178], [-122.00243, 39.24093], [-122.00345, 39.2403], [-122.00403, 39.23972], [-122.00434, 39.23892], [-122.00431, 39.23814], [-122.00414, 39.23706], [-122.00391, 39.23673], [-122.00372, 39.23631], [-122.00371, 39.23588], [-122.00476, 39.23621], [-122.00546, 39.23672], [-122.00627, 39.2376], [-122.0071, 39.23873], [-122.00707, 39.24098], [-122.00693, 39.24147], [-122.00689, 39.24257], [-122.00741, 39.244]]], [[[-122.00727, 39.22632], [-122.00661, 39.22789], [-122.00587, 39.22802], [-122.00546, 39.22793], [-122.00545, 39.22789], [-122.00248, 39.22734], [-122.00204, 39.22538], [-122.00239, 39.22439], [-122.00277, 39.22355], [-122.00662, 39.22351], [-122.00685, 39.22507], [-122.00727, 39.22632]]], [[[-122.01384, 39.38105], [-122.01406, 39.38659], [-122.01317, 39.38979], [-122.01171, 39.39294], [-122.01065, 39.39501], [-122.01014, 39.39666], [-122.00987, 39.39889], [-122.00393, 39.39883], [-122.00372, 39.3981], [-122.00408, 39.39671], [-122.00428, 39.39631], [-122.00473, 39.39556], [-122.00504, 39.39516], [-122.00522, 39.39486], [-122.00537, 39.39455], [-122.00557, 39.39428], [-122.00631, 39.39346], [-122.00657, 39.39315], [-122.0069, 39.39286], [-122.00737, 39.39228], [-122.00741, 39.39222], [-122.00867, 39.39119], [-122.00959, 39.38985], [-122.0096, 39.38811], [-122.00923, 39.38675], [-122.00947, 39.38461], [-122.00954, 39.38442], [-122.0102, 39.38396], [-122.01019, 39.38395], [-122.00971, 39.38394], [-122.00993, 39.3833], [-122.01118, 39.38164], [-122.01384, 39.38105]]], [[[-122.02359, 39.35551], [-122.02338, 39.35559], [-122.02217, 39.3566], [-122.02043, 39.35758], [-122.01981, 39.35804], [-122.01882, 39.35871], [-122.01845, 39.3594], [-122.01788, 39.35938], [-122.01395, 39.36101], [-122.01394, 39.3605], [-122.01428, 39.35762], [-122.01442, 39.35711], [-122.01465, 39.35634], [-122.0151, 39.35535], [-122.02337, 39.35544], [-122.02359, 39.35551]]], [[[-122.03067, 39.34996], [-122.0302, 39.35207], [-122.0264, 39.35221], [-122.02541, 39.35362], [-122.01513, 39.35347], [-122.01583, 39.35219], [-122.0177, 39.35081], [-122.0193, 39.3502], [-122.02131, 39.35021], [-122.02266, 39.35046], [-122.0229, 39.35056], [-122.02289, 39.35071], [-122.02282, 39.35086], [-122.02304, 39.35111], [-122.02401, 39.35133], [-122.02487, 39.35125], [-122.02595, 39.35094], [-122.02753, 39.34998], [-122.03067, 39.34996]]], [[[-122.02605, 39.32207], [-122.02605, 39.32213], [-122.02576, 39.32327], [-122.02543, 39.32357], [-122.02434, 39.32432], [-122.02363, 39.32504], [-122.02307, 39.32581], [-122.02277, 39.32666], [-122.02277, 39.32702], [-122.02299, 39.32726], [-122.02294, 39.32747], [-122.02263, 39.32779], [-122.01642, 39.32762], [-122.01594, 39.32701], [-122.01593, 39.32621], [-122.01603, 39.32452], [-122.01613, 39.32209], [-122.02605, 39.32207]]], [[[-122.03184, 39.30436], [-122.03176, 39.30576], [-122.03068, 39.31047], [-122.03041, 39.31182], [-122.03023, 39.31384], [-122.03017, 39.31531], [-122.01895, 39.31527], [-122.01985, 39.31506], [-122.02041, 39.31482], [-122.02052, 39.31462], [-122.02038, 39.31457], [-122.02038, 39.31438], [-122.02076, 39.31438], [-122.02118, 39.31423], [-122.02228, 39.31358], [-122.02216, 39.31327], [-122.02238, 39.31294], [-122.02275, 39.31187], [-122.02308, 39.31143], [-122.02361, 39.31114], [-122.02432, 39.31037], [-122.02492, 39.31018], [-122.02614, 39.31029], [-122.02705, 39.31074], [-122.02795, 39.31081], [-122.02843, 39.31097], [-122.02972, 39.31093], [-122.03001, 39.31067], [-122.03005, 39.309], [-122.03052, 39.30776], [-122.03055, 39.30709], [-122.03112, 39.30534], [-122.03131, 39.30408], [-122.03184, 39.30436]]]]} Open Access 1 23020 Sacramento River Wildlife Area 30494 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Sacramento-River-WA Colusa 49 991.391 Sacramento River Wildlife Area 1978 State Conservation Area 8 2
16768 16768 16767 {"type": "MultiPolygon", "coordinates": [[[[-121.99607, 39.23163], [-121.99415, 39.23674], [-121.99399, 39.2367], [-121.99391, 39.23693], [-121.99347, 39.23666], [-121.99148, 39.23665], [-121.9906, 39.23634], [-121.98981, 39.2363], [-121.98972, 39.23666], [-121.98574, 39.23757], [-121.97634, 39.23942], [-121.97627, 39.2417], [-121.976, 39.24181], [-121.97603, 39.24217], [-121.97639, 39.24285], [-121.97635, 39.24539], [-121.95773, 39.24539], [-121.95616, 39.24452], [-121.95452, 39.24292], [-121.95473, 39.24276], [-121.9541, 39.24182], [-121.95295, 39.23908], [-121.95048, 39.23528], [-121.9491, 39.23411], [-121.94833, 39.23161], [-121.94835, 39.23064], [-121.94826, 39.22903], [-121.94865, 39.22825], [-121.9484, 39.22735], [-121.94726, 39.22494], [-121.94683, 39.22465], [-121.94648, 39.22446], [-121.94556, 39.2237], [-121.95296, 39.22358], [-121.9543, 39.22397], [-121.95471, 39.22359], [-121.95996, 39.22368], [-121.96156, 39.22359], [-121.96149, 39.22736], [-121.96714, 39.22741], [-121.97646, 39.22747], [-121.9765, 39.22826], [-121.97647, 39.2309], [-121.99447, 39.23088], [-121.99502, 39.23089], [-121.996, 39.23126], [-121.99607, 39.23163]]], [[[-121.9989, 39.23351], [-121.99579, 39.23794], [-121.99421, 39.23704], [-121.99431, 39.23682], [-121.99425, 39.23679], [-121.99426, 39.23677], [-121.9963, 39.23152], [-121.99826, 39.23228], [-121.99771, 39.23245], [-121.99768, 39.23287], [-121.99735, 39.23331], [-121.99749, 39.23327], [-121.99803, 39.23302], [-121.99832, 39.23307], [-121.9989, 39.23351]]]]} Open Access 1 25266 Colusa Bypass Wildlife Area 30427 219 Central Valley Flood Protection Board 1027 State 5 State Agency 5 http://www.cvfpb.ca.gov/ Other State 5 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Colusa 49 1524.983 Colusa Bypass Wildlife Area 1993 State Conservation Area 8 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]);