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 = 8 and SUID_NMA = 32168

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY

MNG_AG_TYP 1

DES_TP 1

  • State Conservation Area · 1 ✖

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
15603 15603 15602 {"type": "MultiPolygon", "coordinates": [[[[-117.71163, 35.22904], [-117.71146, 35.23625], [-117.70265, 35.23641], [-117.70281, 35.22921], [-117.71163, 35.22904]]], [[[-117.72597, 35.25074], [-117.72502, 35.25075], [-117.72502, 35.25075], [-117.72529, 35.25047], [-117.72549, 35.25054], [-117.72578, 35.25068], [-117.72597, 35.25074]]], [[[-117.72497, 35.25028], [-117.7246, 35.25076], [-117.72064, 35.25081], [-117.72086, 35.25072], [-117.72102, 35.25063], [-117.7213, 35.25047], [-117.72152, 35.25031], [-117.7221, 35.25005], [-117.72235, 35.24997], [-117.72283, 35.24988], [-117.72308, 35.24986], [-117.7235, 35.24986], [-117.72383, 35.24989], [-117.72415, 35.24995], [-117.72447, 35.25005], [-117.72476, 35.25016], [-117.72497, 35.25028]]], [[[-117.74753, 35.26294], [-117.7475, 35.26541], [-117.7475, 35.26594], [-117.74746, 35.26566], [-117.7474, 35.26538], [-117.7473, 35.26503], [-117.74719, 35.26476], [-117.74705, 35.26449], [-117.74685, 35.26417], [-117.74671, 35.26398], [-117.7464, 35.26362], [-117.74753, 35.26294]]], [[[-117.75632, 35.25744], [-117.75596, 35.25766], [-117.74738, 35.25775], [-117.74744, 35.26004], [-117.74748, 35.2604], [-117.74756, 35.26076], [-117.74754, 35.26273], [-117.73709, 35.26897], [-117.73701, 35.26897], [-117.73635, 35.26828], [-117.73558, 35.26757], [-117.73478, 35.2669], [-117.73394, 35.26626], [-117.73335, 35.26585], [-117.73275, 35.26547], [-117.72954, 35.26354], [-117.72949, 35.25798], [-117.72955, 35.25073], [-117.72936, 35.25073], [-117.72934, 35.25065], [-117.72725, 35.25069], [-117.72683, 35.25069], [-117.72631, 35.25059], [-117.72601, 35.25051], [-117.72564, 35.25037], [-117.72547, 35.25025], [-117.72842, 35.24669], [-117.7289, 35.24606], [-117.72919, 35.24561], [-117.72961, 35.24484], [-117.72975, 35.24451], [-117.72984, 35.24436], [-117.73016, 35.24341], [-117.7298, 35.24342], [-117.72956, 35.24411], [-117.72943, 35.24441], [-117.72935, 35.24457], [-117.72929, 35.24472], [-117.72907, 35.24518], [-117.72871, 35.24577], [-117.72841, 35.2462], [-117.72515, 35.25007], [-117.72459, 35.24985], [-117.72408, 35.24971], [-117.72361, 35.24964], [-117.72283, 35.24965], [-117.72275, 35.24968], [-117.72249, 35.24971], [-117.72219, 35.24978], [-117.72186, 35.2499], [-117.72163, 35.25], [-117.72133, 35.25016], [-117.7211, 35.25032], [-117.72078, 35.2505], [-117.72046, 35.25063], [-117.72035, 35.24671], [-117.7203, 35.24353], [-117.70237, 35.24376], [-117.70259, 35.23649], [-117.72038, 35.23624], [-117.72041, 35.23267], [-117.71172, 35.23281], [-117.71177, 35.22908], [-117.72046, 35.22895], [-117.72915, 35.22879], [-117.72916, 35.23007], [-117.72918, 35.23029], [-117.72928, 35.2308], [-117.72942, 35.23119], [-117.72943, 35.23118], [-117.72939, 35.22875], [-117.73854, 35.22876], [-117.7385, 35.23879], [-117.74467, 35.23872], [-117.7447, 35.24079], [-117.74748, 35.24085], [-117.74739, 35.24314], [-117.7563, 35.24307], [-117.7563, 35.254], [-117.75632, 35.25744]], [[-117.72951, 35.23607], [-117.72949, 35.23531], [-117.72948, 35.23607], [-117.72926, 35.24337], [-117.72927, 35.24338], [-117.72962, 35.24336], [-117.72955, 35.23608], [-117.72951, 35.23607]]], [[[-117.73673, 35.26914], [-117.73673, 35.26917], [-117.73671, 35.26919], [-117.73105, 35.27257], [-117.73106, 35.27258], [-117.7314, 35.27258], [-117.73424, 35.2708], [-117.73425, 35.27948], [-117.73344, 35.27922], [-117.73333, 35.27996], [-117.72525, 35.27982], [-117.72524, 35.27267], [-117.72522, 35.27266], [-117.72529, 35.26547], [-117.72955, 35.26538], [-117.72954, 35.26389], [-117.73255, 35.26569], [-117.73314, 35.26607], [-117.73372, 35.26647], [-117.73455, 35.26709], [-117.73534, 35.26776], [-117.73609, 35.26846], [-117.73647, 35.26884], [-117.73673, 35.26914]]], [[[-117.75646, 35.27251], [-117.75623, 35.2757], [-117.75596, 35.28008], [-117.75566, 35.28328], [-117.75532, 35.28767], [-117.74664, 35.28741], [-117.74711, 35.2799], [-117.74483, 35.27982], [-117.74537, 35.27249], [-117.75646, 35.27251]]], [[[-117.80727, 35.33153], [-117.78933, 35.33211], [-117.78933, 35.31744], [-117.8071, 35.31688], [-117.80727, 35.33153]]], [[[-117.82564, 35.3813], [-117.81704, 35.38361], [-117.81702, 35.38307], [-117.80805, 35.38326], [-117.8079, 35.37601], [-117.8256, 35.37572], [-117.82561, 35.37877], [-117.82564, 35.3813]]], [[[-117.82574, 35.38624], [-117.81701, 35.38844], [-117.81701, 35.38844], [-117.81706, 35.38448], [-117.82566, 35.38219], [-117.82574, 35.38624]]], [[[-117.82577, 35.39043], [-117.81699, 35.39047], [-117.817, 35.3887], [-117.82575, 35.38648], [-117.82577, 35.39043]]], [[[-117.80854, 35.39051], [-117.7994, 35.39263], [-117.79892, 35.39269], [-117.79837, 35.39269], [-117.79788, 35.39263], [-117.79735, 35.39251], [-117.79811, 35.39198], [-117.799, 35.39145], [-117.79993, 35.39097], [-117.80094, 35.39053], [-117.80854, 35.39051]]], [[[-117.79824, 35.39291], [-117.79759, 35.39307], [-117.79734, 35.39315], [-117.79711, 35.39325], [-117.79688, 35.39337], [-117.79664, 35.39354], [-117.79645, 35.39369], [-117.79628, 35.39386], [-117.793, 35.39749], [-117.7927, 35.39786], [-117.79241, 35.39825], [-117.79216, 35.39865], [-117.79193, 35.39907], [-117.79163, 35.39967], [-117.79156, 35.39986], [-117.79152, 35.40003], [-117.79149, 35.40023], [-117.79149, 35.40042], [-117.79146, 35.40051], [-117.79136, 35.40061], [-117.79093, 35.40081], [-117.79088, 35.3988], [-117.79173, 35.3977], [-117.79267, 35.3966], [-117.79368, 35.39555], [-117.79476, 35.39454], [-117.79591, 35.39359], [-117.79712, 35.39268], [-117.7977, 35.39284], [-117.79824, 35.39291]]], [[[-117.80878, 35.40488], [-117.79109, 35.40492], [-117.79094, 35.401], [-117.79148, 35.40075], [-117.79157, 35.40068], [-117.79164, 35.4006], [-117.79169, 35.40045], [-117.7917, 35.40017], [-117.79176, 35.3999], [-117.79204, 35.39928], [-117.79226, 35.39887], [-117.7925, 35.39847], [-117.79296, 35.39783], [-117.79317, 35.39759], [-117.79644, 35.39396], [-117.7967, 35.39371], [-117.79701, 35.39351], [-117.79739, 35.39332], [-117.79786, 35.39317], [-117.79899, 35.39292], [-117.79931, 35.39288], [-117.79967, 35.39281], [-117.80822, 35.39083], [-117.80878, 35.40488]]], [[[-117.78567, 35.405], [-117.78429, 35.40684], [-117.78413, 35.40678], [-117.78389, 35.40709], [-117.78361, 35.40742], [-117.78331, 35.40773], [-117.78298, 35.40804], [-117.7824, 35.40851], [-117.78177, 35.40895], [-117.78109, 35.40933], [-117.78037, 35.40967], [-117.77962, 35.40996], [-117.77884, 35.41019], [-117.77803, 35.41036], [-117.77754, 35.41044], [-117.77705, 35.4105], [-117.7762, 35.41055], [-117.77619, 35.41041], [-117.7748, 35.4104], [-117.77387, 35.41037], [-117.77312, 35.41032], [-117.77306, 35.40874], [-117.77759, 35.40868], [-117.77748, 35.4051], [-117.78567, 35.405]]], [[[-117.75526, 35.41008], [-117.75382, 35.41044], [-117.75319, 35.41061], [-117.75192, 35.411], [-117.75004, 35.41166], [-117.7488, 35.41214], [-117.74796, 35.41249], [-117.74654, 35.41252], [-117.74655, 35.41313], [-117.7457, 35.41354], [-117.73788, 35.41808], [-117.73787, 35.41259], [-117.74216, 35.4126], [-117.74217, 35.40897], [-117.75088, 35.40893], [-117.75072, 35.40519], [-117.75498, 35.40517], [-117.75526, 35.41008]]], [[[-117.7344, 35.41982], [-117.73388, 35.42008], [-117.72795, 35.4235], [-117.72187, 35.4251], [-117.72106, 35.42501], [-117.72077, 35.42308], [-117.72522, 35.42312], [-117.72485, 35.41984], [-117.7344, 35.41982]]], [[[-117.72758, 35.42375], [-117.72663, 35.42437], [-117.72595, 35.42475], [-117.72523, 35.42508], [-117.72447, 35.42536], [-117.72401, 35.4255], [-117.72353, 35.42562], [-117.72272, 35.42576], [-117.72222, 35.42582], [-117.72167, 35.42586], [-117.72117, 35.42582], [-117.72108, 35.42516], [-117.72192, 35.42525], [-117.72758, 35.42375]]], [[[-117.66417, 35.428], [-117.66416, 35.428], [-117.65473, 35.42811], [-117.65511, 35.42797], [-117.65547, 35.42786], [-117.65595, 35.42776], [-117.65633, 35.4277], [-117.65673, 35.42768], [-117.65713, 35.42767], [-117.65753, 35.42769], [-117.65832, 35.42777], [-117.65899, 35.42778], [-117.65937, 35.42775], [-117.65974, 35.4277], [-117.6601, 35.42763], [-117.66045, 35.42754], [-117.66079, 35.42742], [-117.66112, 35.42729], [-117.66165, 35.427], [-117.66213, 35.42665], [-117.66264, 35.42618], [-117.66293, 35.42594], [-117.66333, 35.42567], [-117.66372, 35.42547], [-117.66417, 35.428]]], [[[-117.66771, 35.42445], [-117.66708, 35.42437], [-117.66646, 35.42434], [-117.66351, 35.42433], [-117.6635, 35.42434], [-117.66362, 35.42483], [-117.66311, 35.42507], [-117.66257, 35.42541], [-117.66215, 35.42573], [-117.66157, 35.42627], [-117.66121, 35.42654], [-117.66073, 35.4268], [-117.66045, 35.42692], [-117.66014, 35.42703], [-117.65983, 35.42711], [-117.65951, 35.42718], [-117.65918, 35.42722], [-117.65885, 35.42725], [-117.65825, 35.42725], [-117.65747, 35.42716], [-117.65703, 35.42714], [-117.65648, 35.42715], [-117.65594, 35.4272], [-117.65532, 35.42732], [-117.65501, 35.4274], [-117.65462, 35.42753], [-117.65434, 35.42765], [-117.65397, 35.42782], [-117.65363, 35.42802], [-117.65337, 35.42819], [-117.65072, 35.42828], [-117.65054, 35.4267], [-117.65017, 35.42474], [-117.6592, 35.42445], [-117.658, 35.41937], [-117.66254, 35.4194], [-117.66684, 35.41937], [-117.66771, 35.42445]]]]} Open Access 1 16657 Fremont Valley Ecological Reserve 32168 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/Fremont-Valley-ER Kern 36 5730.017 Fremont Valley ER 1988 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]);