units_with_maps

Table actions

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

54 rows where DES_TP = 39 and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

Suggested facets: COUNTY, YR_EST

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 54 ✖

DES_TP 1

  • State Recreation Area · 54 ✖
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
391 391 390 {"type": "Polygon", "coordinates": [[[-122.90647, 38.50264], [-122.90621, 38.50264], [-122.9057, 38.50237], [-122.90378, 38.50239], [-122.90186, 38.50146], [-122.89966, 38.50045], [-122.89918, 38.50012], [-122.89896, 38.49992], [-122.89874, 38.4996], [-122.89862, 38.49815], [-122.89817, 38.49687], [-122.89757, 38.49608], [-122.89836, 38.49578], [-122.8985, 38.4953], [-122.89887, 38.49556], [-122.90061, 38.49693], [-122.90352, 38.49951], [-122.90396, 38.49992], [-122.90513, 38.50094], [-122.90559, 38.50128], [-122.90647, 38.50264]], [[-122.90226, 38.49992], [-122.90214, 38.49984], [-122.90159, 38.50028], [-122.90262, 38.50107], [-122.90325, 38.50075], [-122.90325, 38.50074], [-122.90226, 38.49992]]]} Open Access 1 1165 Steelhead Beach Fishing Access 32317 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 54.507 Steelhead Beach FA 0 State Recreation Area 39 4
689 689 688 {"type": "Polygon", "coordinates": [[[-122.27644, 41.23646], [-122.27565, 41.23673], [-122.27558, 41.23593], [-122.27633, 41.2358], [-122.27644, 41.23646]]]} Open Access 1 3506 Sacramento River -- Prospect Ave. Fishing Access 32282 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.339 Sacramento River -- Prospect Ave. FA 0 State Recreation Area 39 4
1224 1224 1223 {"type": "Polygon", "coordinates": [[[-122.86042, 38.59925], [-122.86034, 38.59981], [-122.86039, 38.60018], [-122.86041, 38.60169], [-122.85992, 38.60156], [-122.85954, 38.60002], [-122.85952, 38.60002], [-122.85941, 38.60012], [-122.85928, 38.59999], [-122.85995, 38.5991], [-122.86042, 38.59925]]]} Open Access 1 8807 Healdsburg Fishing Access 32183 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.182 Healdsburg FA 0 State Recreation Area 39 4
1642 1642 1641 {"type": "MultiPolygon", "coordinates": [[[[-122.91501, 38.23223], [-122.91436, 38.23304], [-122.91323, 38.23292], [-122.91298, 38.23269], [-122.91332, 38.23235], [-122.91362, 38.23199], [-122.91396, 38.23141], [-122.91403, 38.23117], [-122.91417, 38.23093], [-122.91444, 38.23065], [-122.91472, 38.2304], [-122.91498, 38.23013], [-122.91479, 38.23083], [-122.91501, 38.23223]]], [[[-122.92228, 38.22119], [-122.92219, 38.22138], [-122.9222, 38.2214], [-122.92205, 38.22171], [-122.921, 38.22207], [-122.92063, 38.22229], [-122.91984, 38.22279], [-122.9192, 38.22313], [-122.91832, 38.22349], [-122.91766, 38.22384], [-122.9169, 38.22438], [-122.91676, 38.22491], [-122.91692, 38.22544], [-122.91697, 38.2261], [-122.91706, 38.22669], [-122.9171, 38.22705], [-122.91691, 38.22739], [-122.9167, 38.22796], [-122.91636, 38.22833], [-122.91608, 38.22869], [-122.9155, 38.22952], [-122.91512, 38.22995], [-122.91571, 38.22916], [-122.91592, 38.2289], [-122.91618, 38.22848], [-122.91635, 38.22809], [-122.91629, 38.22676], [-122.91608, 38.22537], [-122.91611, 38.22521], [-122.91622, 38.22491], [-122.91629, 38.22477], [-122.91649, 38.22449], [-122.91673, 38.22425], [-122.91702, 38.22406], [-122.91779, 38.22361], [-122.91846, 38.22313], [-122.91928, 38.22288], [-122.9198, 38.22249], [-122.92014, 38.22228], [-122.92196, 38.22151], [-122.92215, 38.22137], [-122.92228, 38.22119]]]]} Open Access 1 1917 Keys Creek Fishing Access 32194 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   Marin 23 15.8 Keys Creek FA 0 State Recreation Area 39 4
1849 1849 1848 {"type": "MultiPolygon", "coordinates": [[[[-122.94254, 40.6514], [-122.94075, 40.65216], [-122.94037, 40.65217], [-122.94034, 40.65114], [-122.94131, 40.65085], [-122.94254, 40.6514]]], [[[-122.94341, 40.6502], [-122.94276, 40.65044], [-122.94314, 40.65089], [-122.94277, 40.65114], [-122.94173, 40.6506], [-122.94119, 40.65048], [-122.94161, 40.6503], [-122.94222, 40.6503], [-122.94227, 40.64999], [-122.94239, 40.64988], [-122.94276, 40.64961], [-122.94341, 40.6502]]]]} Open Access 1 14107 Trinity River Fishing Access 32329 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   Trinity 46 7.06 Trinity River FA 0 State Recreation Area 39 4
2024 2024 2023 {"type": "Polygon", "coordinates": [[[-122.37678, 38.2076], [-122.3765, 38.20788], [-122.37427, 38.20626], [-122.37478, 38.2058], [-122.37528, 38.20615], [-122.37569, 38.20667], [-122.37625, 38.20725], [-122.3765, 38.20744], [-122.37678, 38.2076]]]} Open Access 1 17014 Hudeman Slough Fishing Access 32186 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 3.392 Hudeman Slough FA 1962 State Recreation Area 39 4
2169 2169 2168 {"type": "Polygon", "coordinates": [[[-122.26026, 40.46551], [-122.25995, 40.4661], [-122.25878, 40.46717], [-122.25844, 40.46756], [-122.25829, 40.46797], [-122.25851, 40.46908], [-122.25823, 40.46964], [-122.25693, 40.46679], [-122.257, 40.46675], [-122.25734, 40.4669], [-122.25754, 40.46693], [-122.25755, 40.46692], [-122.25569, 40.46488], [-122.25569, 40.46461], [-122.25488, 40.464], [-122.25532, 40.46233], [-122.25635, 40.46254], [-122.25663, 40.46264], [-122.25701, 40.46333], [-122.25815, 40.46388], [-122.25913, 40.46406], [-122.25986, 40.46436], [-122.26021, 40.46499], [-122.26026, 40.46551]]]} Open Access 1 17642 Anderson Fishing Access 32022 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   Shasta 27 37.547 Anderson FA 0 State Recreation Area 39 4
2508 2508 2507 {"type": "Polygon", "coordinates": [[[-121.24804, 38.63376], [-121.24739, 38.63522], [-121.24697, 38.63508], [-121.24352, 38.63369], [-121.24282, 38.63347], [-121.242, 38.63327], [-121.24122, 38.63298], [-121.24087, 38.6328], [-121.24054, 38.63257], [-121.24015, 38.63234], [-121.23977, 38.63218], [-121.23316, 38.63264], [-121.23297, 38.63186], [-121.22925, 38.63193], [-121.22925, 38.63137], [-121.23982, 38.63078], [-121.24804, 38.63376]]]} Open Access 1 17562 American River Access 32019 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   Sacramento 41 59.692 American River Access 0 State Recreation Area 39 4
2573 2573 2572 {"type": "Polygon", "coordinates": [[[-122.22395, 40.26271], [-122.2237, 40.26323], [-122.22328, 40.26376], [-122.22186, 40.26304], [-122.22219, 40.26302], [-122.22269, 40.26218], [-122.22395, 40.26271]]]} Open Access 1 17891 Bend Bridge Public Access 32046 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 3.867 Bend Bridge PA 0 State Recreation Area 39 4
3144 3144 3143 {"type": "Polygon", "coordinates": [[[-124.10173, 40.49177], [-124.09991, 40.49269], [-124.09979, 40.49248], [-124.1004, 40.49204], [-124.10081, 40.4918], [-124.1015, 40.49158], [-124.10173, 40.49177]]]} Open Access 1 21596 Eel River -- Rio Dell Fishing Access 32156 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 1.525 Eel River -- Rio Dell FA 0 State Recreation Area 39 4
3145 3145 3144 {"type": "MultiPolygon", "coordinates": [[[[-124.12175, 41.03989], [-124.12131, 41.03991], [-124.12121, 41.03987], [-124.12108, 41.03988], [-124.12093, 41.03992], [-124.12068, 41.04038], [-124.12061, 41.04044], [-124.12043, 41.04052], [-124.12027, 41.04068], [-124.12019, 41.04085], [-124.12012, 41.04095], [-124.12012, 41.04076], [-124.11999, 41.04031], [-124.11976, 41.04003], [-124.11934, 41.03975], [-124.11887, 41.03953], [-124.11879, 41.03945], [-124.11867, 41.03927], [-124.11859, 41.0391], [-124.11854, 41.03893], [-124.11849, 41.03884], [-124.11888, 41.03883], [-124.11962, 41.0388], [-124.12031, 41.03915], [-124.12093, 41.03936], [-124.1213, 41.03963], [-124.12175, 41.03989]]], [[[-124.12038, 41.04196], [-124.12008, 41.04195], [-124.1199, 41.04196], [-124.11979, 41.04199], [-124.11958, 41.04198], [-124.11972, 41.04168], [-124.11995, 41.04141], [-124.11995, 41.04147], [-124.12003, 41.04161], [-124.12008, 41.04164], [-124.12021, 41.04175], [-124.12038, 41.04196]]]]} Open Access 1 21601 Luffenholtz Creek Fishing Access 32210 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 6.71 Luffenholtz Creek FA 0 State Recreation Area 39 4
3284 3284 3283 {"type": "Polygon", "coordinates": [[[-114.722, 33.08954], [-114.70844, 33.08952], [-114.70802, 33.08874], [-114.70769, 33.08819], [-114.70696, 33.08728], [-114.70612, 33.08661], [-114.70461, 33.08633], [-114.7046, 33.08105], [-114.71315, 33.08099], [-114.71309, 33.075], [-114.72176, 33.07503], [-114.722, 33.08954]]]} Open Access 1 23367 Colorado River Access 32132 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   Imperial 20 488.822 Colorado River Access 0 State Recreation Area 39 4
3286 3286 3285 {"type": "Polygon", "coordinates": [[[-122.31276, 38.91619], [-122.30056, 38.91633], [-122.30018, 38.91044], [-122.30064, 38.91037], [-122.30093, 38.9103], [-122.30254, 38.90997], [-122.30296, 38.90992], [-122.30356, 38.90991], [-122.30391, 38.90996], [-122.30423, 38.91005], [-122.30598, 38.91071], [-122.30669, 38.91102], [-122.30716, 38.91107], [-122.30751, 38.91104], [-122.30761, 38.91103], [-122.30833, 38.91081], [-122.30868, 38.91064], [-122.30877, 38.91057], [-122.3089, 38.91042], [-122.30904, 38.9103], [-122.30907, 38.91024], [-122.30929, 38.90996], [-122.30929, 38.90988], [-122.3096, 38.90939], [-122.30981, 38.9092], [-122.31013, 38.90898], [-122.31036, 38.90884], [-122.31044, 38.90882], [-122.31061, 38.90873], [-122.31088, 38.90866], [-122.31144, 38.9086], [-122.312, 38.90866], [-122.31239, 38.90877], [-122.31264, 38.90888], [-122.31273, 38.90893], [-122.31276, 38.91619]]]} Open Access 1 23563 Cache Creek Public Access 32077 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   Yolo 33 184.731 Cache Creek PA 0 State Recreation Area 39 4
3443 3443 3442 {"type": "Polygon", "coordinates": [[[-122.27607, 38.12156], [-122.27576, 38.12178], [-122.2757, 38.12104], [-122.27592, 38.12097], [-122.27607, 38.12156]]]} Open Access 1 25259 Vallejo Fishing Pier 32344 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   Solano 26 0.461 Vallejo Fishing Pier 0 State Recreation Area 39 4
3597 3597 3596 {"type": "Polygon", "coordinates": [[[-120.42453, 41.423], [-120.42447, 41.42337], [-120.42407, 41.42367], [-120.42401, 41.42387], [-120.42359, 41.42413], [-120.42319, 41.42405], [-120.42179, 41.4233], [-120.42091, 41.423], [-120.42064, 41.42284], [-120.42067, 41.42262], [-120.42116, 41.42223], [-120.42189, 41.42202], [-120.42261, 41.422], [-120.4235, 41.42232], [-120.42413, 41.42232], [-120.42432, 41.42243], [-120.42453, 41.423]]]} Open Access 1 29187 Pine Creek Reservoir Public Access 32264 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   Modoc 56 11.894 Pine Creek Reservoir PA 0 State Recreation Area 39 4
3951 3951 3950 {"type": "MultiPolygon", "coordinates": [[[[-122.92088, 40.65941], [-122.90654, 40.65933], [-122.90652, 40.65755], [-122.90653, 40.65578], [-122.90892, 40.6558], [-122.90893, 40.65758], [-122.91198, 40.65759], [-122.91302, 40.65654], [-122.9133, 40.65678], [-122.91445, 40.6576], [-122.92086, 40.65764], [-122.92088, 40.65941]]], [[[-122.93008, 40.65443], [-122.93007, 40.65583], [-122.92977, 40.65583], [-122.92978, 40.65452], [-122.93008, 40.65443]]]]} Open Access 1 1124 Indian Creek Public Access 32188 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   Trinity 46 72.715 Indian Creek PA 0 State Recreation Area 39 4
4066 4066 4065 {"type": "Polygon", "coordinates": [[[-119.73129, 36.97793], [-119.7303, 36.97877], [-119.72525, 36.98164], [-119.72042, 36.98537], [-119.72043, 36.98505], [-119.72124, 36.98436], [-119.72154, 36.98342], [-119.72122, 36.98287], [-119.72074, 36.98281], [-119.72075, 36.98168], [-119.72235, 36.9798], [-119.72305, 36.97932], [-119.72304, 36.97794], [-119.73031, 36.97791], [-119.73129, 36.97793]]]} Open Access 1 44427 Lost Lake Fishing Access 32207 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 73.033 Lost Lake FA 0 State Recreation Area 39 4
4070 4070 4069 {"type": "Polygon", "coordinates": [[[-122.26206, 37.57356], [-122.25329, 37.58145], [-122.25329, 37.58145], [-122.25315, 37.58126], [-122.26174, 37.57345], [-122.26206, 37.57356]]]} Restricted Access 2 44448 San Mateo Fishing Pier 24951 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 Mateo 15 7.589 San Mateo Fishing Pier 0 State Recreation Area 39 4
4862 4862 4861 {"type": "Polygon", "coordinates": [[[-121.66948, 38.16979], [-121.66941, 38.16983], [-121.66936, 38.16994], [-121.66935, 38.17035], [-121.66932, 38.17042], [-121.66873, 38.17075], [-121.66858, 38.17088], [-121.66823, 38.17112], [-121.66788, 38.17132], [-121.66746, 38.17165], [-121.66698, 38.17205], [-121.66674, 38.17196], [-121.66754, 38.1713], [-121.66837, 38.17043], [-121.66914, 38.16955], [-121.66948, 38.16979]]]} Open Access 1 22113 Cliff House Fishing Access 32119 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   Sacramento 41 3.203 Cliff House FA 0 State Recreation Area 39 4
4964 4964 4963 {"type": "Polygon", "coordinates": [[[-122.43108, 41.43777], [-122.43089, 41.43822], [-122.4304, 41.43783], [-122.43008, 41.43741], [-122.43055, 41.43722], [-122.43108, 41.43777]]]} Open Access 1 3682 Shasta River Fishing Access 32306 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.086 Shasta River FA 0 State Recreation Area 39 4

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