units_with_maps

Table actions

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

71 rows where AGNCY_NAME = 25, DES_TP = 55, MNG_AGENCY = 25 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

  • State Agency · 71 ✖

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 71 ✖

DES_TP 1

  • State Resource Management Area · 71 ✖
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
545 545 544 {"type": "Polygon", "coordinates": [[[-122.31307, 41.2763], [-122.31264, 41.2763], [-122.31266, 41.2752], [-122.31307, 41.2752], [-122.31307, 41.2763]]]} No Public Access 3 1814 Lower Box Canyon 32208 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   Siskiyou 28 1.061 Lower Box Canyon 0 State Resource Management Area 55 3
1130 1130 1129 {"type": "Polygon", "coordinates": [[[-118.05045, 37.26696], [-118.05032, 37.28884], [-118.04578, 37.2888], [-118.0458, 37.28518], [-118.04122, 37.28514], [-118.04125, 37.28152], [-118.03671, 37.28148], [-118.03674, 37.27786], [-118.03221, 37.27783], [-118.0323, 37.26688], [-118.05045, 37.26696]]]} No Public Access 3 6619 Deep Springs Lake 32146 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   Inyo 43 725.874 Deep Springs Lake 0 State Resource Management Area 55 3
1362 1362 1361 {"type": "MultiPolygon", "coordinates": [[[[-120.54592, 36.6911], [-120.53904, 36.69108], [-120.53903, 36.68751], [-120.53931, 36.68748], [-120.53932, 36.67661], [-120.53965, 36.67662], [-120.54592, 36.6911]]], [[[-120.54644, 36.69054], [-120.54632, 36.69071], [-120.54625, 36.69074], [-120.54003, 36.67662], [-120.54028, 36.67664], [-120.54644, 36.69054]]]]} No Public Access 3 8074 Pilobos 32263 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   Fresno 9 134.36 Pilobos 0 State Resource Management Area 55 3
1581 1581 1580 {"type": "Polygon", "coordinates": [[[-115.54599, 33.539], [-115.53693, 33.53898], [-115.53689, 33.53374], [-115.53922, 33.53373], [-115.53931, 33.53565], [-115.54152, 33.53564], [-115.54145, 33.53741], [-115.54597, 33.53769], [-115.54599, 33.539]]]} No Public Access 3 12128 Chuckwalla Bench 32115 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   Riverside 10 66.962 Chuckwalla Bench 0 State Resource Management Area 55 3
1949 1949 1948 {"type": "Polygon", "coordinates": [[[-119.3411, 35.24915], [-119.33804, 35.25071], [-119.33274, 35.25344], [-119.32347, 35.25337], [-119.32342, 35.24243], [-119.33225, 35.24252], [-119.3322, 35.23881], [-119.34107, 35.23889], [-119.3411, 35.24915]]]} No Public Access 3 16653 Elk Hills 32158 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   Kern 36 517.552 Elk Hills 0 State Resource Management Area 55 3
1956 1956 1955 {"type": "Polygon", "coordinates": [[[-117.8303, 35.57191], [-117.83026, 35.57926], [-117.82582, 35.57925], [-117.82581, 35.58284], [-117.82577, 35.58649], [-117.82128, 35.58644], [-117.82132, 35.58281], [-117.82141, 35.57924], [-117.82581, 35.57924], [-117.82587, 35.57561], [-117.82586, 35.5756], [-117.82143, 35.57557], [-117.82145, 35.57191], [-117.8303, 35.57191]]]} No Public Access 3 16665 Indian Wells Valley 32190 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   Kern 36 201.555 Indian Wells Valley 0 State Resource Management Area 55 3
2417 2417 2416 {"type": "Polygon", "coordinates": [[[-120.82613, 36.92597], [-120.81978, 36.92585], [-120.82012, 36.91517], [-120.82491, 36.91943], [-120.82613, 36.92597]]]} No Public Access 3 17273 Dos Amigos 32151 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   Merced 37 114.925 Dos Amigos 0 State Resource Management Area 55 3
2428 2428 2427 {"type": "MultiPolygon", "coordinates": [[[[-120.39692, 37.50741], [-120.39664, 37.51843], [-120.39339, 37.51813], [-120.39035, 37.51702], [-120.3889, 37.51665], [-120.38848, 37.51633], [-120.3843, 37.51606], [-120.38436, 37.5155], [-120.38449, 37.51059], [-120.38471, 37.51053], [-120.38563, 37.51016], [-120.38827, 37.50854], [-120.3895, 37.50769], [-120.39086, 37.50715], [-120.39629, 37.50707], [-120.39692, 37.50741]]], [[[-120.39693, 37.50636], [-120.39692, 37.50692], [-120.39645, 37.50666], [-120.39073, 37.50674], [-120.38921, 37.50734], [-120.38794, 37.50822], [-120.38536, 37.50981], [-120.3845, 37.51015], [-120.38462, 37.50621], [-120.39333, 37.50635], [-120.39693, 37.50636]]]]} No Public Access 3 17291 Merced River 32217 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   Merced 37 311.747 Merced River 0 State Resource Management Area 55 3
2481 2481 2480 {"type": "Polygon", "coordinates": [[[-122.19661, 40.26979], [-122.19658, 40.27249], [-122.19162, 40.27297], [-122.18953, 40.27326], [-122.19087, 40.26973], [-122.19661, 40.26979]]]} No Public Access 3 17478 Bend Ferry Road 32047 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   Tehama 18 45.388 Bend Ferry Road 0 State Resource Management Area 55 3
2853 2853 2852 {"type": "Polygon", "coordinates": [[[-123.12633, 39.12775], [-123.12199, 39.12765], [-123.12186, 39.12406], [-123.12181, 39.12124], [-123.12251, 39.12168], [-123.12399, 39.12253], [-123.12435, 39.12276], [-123.1246, 39.12316], [-123.12473, 39.12355], [-123.12507, 39.12389], [-123.12597, 39.1242], [-123.12633, 39.12775]]]} Open Access 1 22154 Mill Creek 32219 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   Mendocino 24 49.861 Mill Creek 0 State Resource Management Area 55 3
3142 3142 3141 {"type": "Polygon", "coordinates": [[[-124.10364, 40.82505], [-124.10204, 40.8308], [-124.10044, 40.83153], [-124.0966, 40.82984], [-124.08606, 40.82989], [-124.08663, 40.82862], [-124.08651, 40.82861], [-124.08712, 40.82752], [-124.08784, 40.82592], [-124.08642, 40.82542], [-124.08642, 40.82541], [-124.08628, 40.82535], [-124.08666, 40.82496], [-124.08699, 40.82469], [-124.08887, 40.82328], [-124.08903, 40.82319], [-124.08922, 40.82304], [-124.10364, 40.82505]], [[-124.08767, 40.82431], [-124.08749, 40.82436], [-124.08737, 40.8245], [-124.08721, 40.82478], [-124.08704, 40.82493], [-124.08715, 40.82496], [-124.08717, 40.82494], [-124.09118, 40.82586], [-124.0918, 40.8249], [-124.0918, 40.82489], [-124.08767, 40.82431]]]} Open Access 1 21590 Bracut Tidelands 32065 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   Humboldt 45 222.41 Bracut Tidelands 0 State Resource Management Area 55 3
3147 3147 3146 {"type": "MultiPolygon", "coordinates": [[[[-120.81642, 38.5584], [-120.8161, 38.55859], [-120.81609, 38.55862], [-120.81611, 38.55839], [-120.81642, 38.5584]]], [[[-120.82405, 38.55808], [-120.82414, 38.55836], [-120.82417, 38.55862], [-120.82414, 38.55901], [-120.82407, 38.55919], [-120.82377, 38.55954], [-120.82358, 38.55964], [-120.82332, 38.55973], [-120.82311, 38.55974], [-120.82289, 38.55977], [-120.82264, 38.55976], [-120.82233, 38.5597], [-120.82197, 38.55968], [-120.82166, 38.55965], [-120.82129, 38.55955], [-120.82089, 38.55941], [-120.8206, 38.55925], [-120.82011, 38.55885], [-120.81942, 38.55845], [-120.81877, 38.55822], [-120.81842, 38.55813], [-120.81821, 38.55806], [-120.82405, 38.55808]]]]} No Public Access 3 21619 Upper Cosumnes River 32342 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   Amador 52 15.616 Upper Cosumnes River 0 State Resource Management Area 55 3
3167 3167 3166 {"type": "MultiPolygon", "coordinates": [[[[-116.68524, 34.06247], [-116.6852, 34.07681], [-116.66784, 34.07682], [-116.66779, 34.06235], [-116.65036, 34.06223], [-116.65034, 34.04784], [-116.66779, 34.04785], [-116.6678, 34.06235], [-116.68524, 34.06247]]], [[[-116.6938, 34.10576], [-116.69375, 34.11974], [-116.68527, 34.11965], [-116.6851, 34.10573], [-116.66771, 34.1057], [-116.66798, 34.09129], [-116.68529, 34.09155], [-116.6851, 34.10573], [-116.6938, 34.10576]]]]} No Public Access 3 21980 Mission Creek 32221 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   San Bernardino 22 2202.531 Mission Creek 0 State Resource Management Area 55 3
3285 3285 3284 {"type": "Polygon", "coordinates": [[[-120.0828, 38.3461], [-120.08263, 38.35322], [-120.08006, 38.35324], [-120.0736, 38.35313], [-120.07364, 38.35139], [-120.07808, 38.35147], [-120.07829, 38.34769], [-120.07828, 38.34768], [-120.07372, 38.34762], [-120.07376, 38.346], [-120.0828, 38.3461]]]} Restricted Access 2 23368 Sands Meadow 25024 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   Tuolumne 21 114.054 Sands Meadow 0 State Resource Management Area 55 3
3296 3296 3295 {"type": "Polygon", "coordinates": [[[-121.61412, 37.7845], [-121.61412, 37.78579], [-121.61407, 37.78736], [-121.60506, 37.78748], [-121.605, 37.78452], [-121.6051, 37.78452], [-121.60511, 37.78451], [-121.61412, 37.7845]]]} No Public Access 3 23599 Christensen Road Burrowing Owl Site 32113 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   Alameda 17 63.899 Christensen Road Burrowing Owl Site 0 State Resource Management Area 55 3
3427 3427 3426 {"type": "Polygon", "coordinates": [[[-122.01238, 36.97053], [-122.01187, 36.97081], [-122.01185, 36.97079], [-122.01191, 36.97056], [-122.01223, 36.97036], [-122.01238, 36.97053]]]} No Public Access 3 25174 South Branciforte 32313 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   Santa Cruz 5 0.251 South Branciforte 0 State Resource Management Area 55 3
3437 3437 3436 {"type": "Polygon", "coordinates": [[[-122.4138, 38.46446], [-122.41344, 38.465], [-122.41272, 38.46514], [-122.41239, 38.46481], [-122.41285, 38.46468], [-122.41297, 38.46463], [-122.41332, 38.46455], [-122.41347, 38.4645], [-122.41361, 38.46442], [-122.41379, 38.46439], [-122.4138, 38.46446]]]} Open Access 1 25245 Rutherford Crossroad 32278 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   Napa 11 1.213 Rutherford Crossroad 0 State Resource Management Area 55 3
3439 3439 3438 {"type": "Polygon", "coordinates": [[[-116.69795, 34.67637], [-116.68049, 34.67634], [-116.68049, 34.67369], [-116.69794, 34.67376], [-116.69795, 34.67637]]]} No Public Access 3 25252 Ord Rodman 32252 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   San Bernardino 22 115.534 Ord Rodman 0 State Resource Management Area 55 3
3442 3442 3441 {"type": "Polygon", "coordinates": [[[-123.96676, 41.87177], [-123.95707, 41.87178], [-123.95706, 41.86815], [-123.96193, 41.86808], [-123.96197, 41.86444], [-123.96673, 41.86439], [-123.96667, 41.86953], [-123.96676, 41.87177]]]} No Public Access 3 25256 Stoney Creek 32321 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   Del Norte 50 120.393 Stoney Creek 0 State Resource Management Area 55 3
3485 3485 3484 {"type": "Polygon", "coordinates": [[[-123.05209, 38.33746], [-123.05198, 38.33754], [-123.05179, 38.33741], [-123.05131, 38.33782], [-123.05136, 38.33837], [-123.04991, 38.33944], [-123.04926, 38.33873], [-123.05025, 38.33836], [-123.05118, 38.33786], [-123.05131, 38.33741], [-123.05145, 38.33698], [-123.05209, 38.33746]]]} No Public Access 3 25904 Bodega Bay Monarch Butterfly 32057 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   Sonoma 16 4.076 Bodega Bay Monarch Butterfly 0 State Resource Management Area 55 3

Next page

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]);