superunits_with_maps

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

754 rows where ACCESS_TYP = 3

View and edit SQL

Suggested facets: MNG_AG_LEV, LAYER

ACCESS_TYP

  • No Public Access · 754
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
79 78 {"type": "Polygon", "coordinates": [[[-122.58436, 38.47825], [-122.57965, 38.47824], [-122.57935, 38.47459], [-122.58412, 38.47455], [-122.58436, 38.47825]]]} No Public Access 3 Santa Rosa Creek Redwoods   31790 3082 Sonoma Land Trust 241 Non Profit 6 Non Profit - Land Trust 10 http://www.sonomalandtrust.org/ Non Governmental Organization 10 41.699 Santa Rosa Creek Redwoods 2018
80 79 {"type": "Polygon", "coordinates": [[[-121.77853, 37.07588], [-121.76509, 37.07542], [-121.76501, 37.07143], [-121.76791, 37.06968], [-121.76826, 37.07015], [-121.76836, 37.07057], [-121.76857, 37.07105], [-121.76854, 37.07122], [-121.76836, 37.07142], [-121.76851, 37.07179], [-121.76829, 37.07195], [-121.76806, 37.07225], [-121.76777, 37.07252], [-121.76769, 37.0727], [-121.76771, 37.07293], [-121.76757, 37.0733], [-121.76764, 37.07378], [-121.76775, 37.07403], [-121.76803, 37.07423], [-121.76821, 37.07467], [-121.76813, 37.0749], [-121.76814, 37.07491], [-121.77093, 37.07339], [-121.77067, 37.07249], [-121.77067, 37.07238], [-121.77157, 37.07239], [-121.77158, 37.07188], [-121.77848, 37.07211], [-121.77853, 37.07588]]]} No Public Access 3 Croy Redwoods   31791 2142 Santa Clara Valley Open Space Authority 468 Special District 4 Recreation/Parks District 4 http://www.openspaceauthority.org/ Special District 4 115.547 Croy Redwoods 2018
84 83 {"type": "Polygon", "coordinates": [[[-122.69582, 38.54625], [-122.69567, 38.54622], [-122.6949, 38.54581], [-122.69432, 38.54576], [-122.69338, 38.54514], [-122.69307, 38.54474], [-122.69284, 38.54396], [-122.69244, 38.5437], [-122.69183, 38.54277], [-122.69113, 38.54204], [-122.69108, 38.54018], [-122.69581, 38.54015], [-122.69582, 38.54625]]]} No Public Access 3 Wendle Property   31796 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 50.237 Wendle Property 2018
106 105 {"type": "Polygon", "coordinates": [[[-117.33309, 33.47838], [-117.32511, 33.4758], [-117.32508, 33.47489], [-117.32412, 33.47486], [-117.32413, 33.47409], [-117.32497, 33.47409], [-117.32544, 33.47311], [-117.32616, 33.47088], [-117.32581, 33.46875], [-117.32987, 33.4687], [-117.3299, 33.46759], [-117.32883, 33.46768], [-117.32931, 33.46611], [-117.33054, 33.46549], [-117.3304, 33.46403], [-117.3287, 33.46412], [-117.32431, 33.46406], [-117.32041, 33.46405], [-117.32059, 33.46391], [-117.32871, 33.4639], [-117.33309, 33.46368], [-117.33301, 33.46731], [-117.33086, 33.46751], [-117.33071, 33.47104], [-117.33073, 33.47106], [-117.33304, 33.47086], [-117.33309, 33.47838]]]} No Public Access 3 Durling Preserve https://www.fallbrooklandconservancy.org/durling.html 31815 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 186.985 Durling Preserve 2012
113 112 {"type": "Polygon", "coordinates": [[[-121.5396, 38.7289], [-121.53955, 38.73052], [-121.53953, 38.73375], [-121.53067, 38.73375], [-121.53068, 38.72896], [-121.5396, 38.7289]]]} No Public Access 3 Bianchi West   16062 2092 Natomas Basin Conservancy 623 Special District 4 Flood District 9 http://www.natomasbasin.org/ Special District 4 102.176 Bianchi West  
115 114 {"type": "Polygon", "coordinates": [[[-117.01978, 33.34227], [-117.01951, 33.34216], [-117.01831, 33.34175], [-117.01701, 33.34157], [-117.01718, 33.34144], [-117.01789, 33.34103], [-117.01816, 33.34027], [-117.01511, 33.33929], [-117.01499, 33.3393], [-117.01482, 33.33925], [-117.01477, 33.33931], [-117.01403, 33.33932], [-117.01408, 33.339], [-117.01668, 33.33534], [-117.0194, 33.33715], [-117.01974, 33.33725], [-117.01978, 33.34227]]]} No Public Access 3 Granger Preserve   31817 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 53.484 Granger Preserve 2016
117 116 {"type": "Polygon", "coordinates": [[[-121.72392, 37.72515], [-121.72391, 37.72701], [-121.71937, 37.72699], [-121.71955, 37.72651], [-121.71934, 37.72518], [-121.71901, 37.72496], [-121.71905, 37.72481], [-121.71958, 37.72492], [-121.72009, 37.72486], [-121.72039, 37.72492], [-121.72092, 37.72511], [-121.72158, 37.72515], [-121.72198, 37.72506], [-121.72233, 37.72491], [-121.72253, 37.72495], [-121.72267, 37.72508], [-121.72367, 37.72516], [-121.72392, 37.72515]]]} No Public Access 3 Garaventa Wetlands Preserve https://www.larpd.org/garaventa-wetlands 31818 2062 Livermore Area Recreation and Park District 388 Special District 4 Recreation/Parks District 4 http://www.larpd.dst.ca.us/ Special District 4 21.408 Garaventa Wetlands Preserve  
135 134 {"type": "MultiPolygon", "coordinates": [[[[-118.63834, 34.05331], [-118.63828, 34.05338], [-118.63796, 34.05287], [-118.63805, 34.05287], [-118.63822, 34.05318], [-118.63834, 34.05331]]], [[[-118.6403, 34.06405], [-118.63999, 34.06447], [-118.63883, 34.06406], [-118.63887, 34.06394], [-118.63887, 34.06386], [-118.63882, 34.06371], [-118.63874, 34.06362], [-118.63846, 34.06342], [-118.63832, 34.06326], [-118.63943, 34.06277], [-118.63948, 34.06284], [-118.63955, 34.06289], [-118.63962, 34.06291], [-118.63972, 34.06301], [-118.63979, 34.06313], [-118.63977, 34.06317], [-118.64005, 34.06353], [-118.64004, 34.06366], [-118.64009, 34.06377], [-118.6403, 34.06405]]]]} No Public Access 3 Las Flores Canyon Open Space   29666 3044 Mountains Restoration Trust 526 Non Profit 6 Non Profit - Conservation 12 http://www.mountainstrust.org/ Non Governmental Organization 10 4.661 Las Flores Canyon OS  
266 265 {"type": "Polygon", "coordinates": [[[-122.61292, 38.22825], [-122.61179, 38.22899], [-122.61147, 38.22909], [-122.61106, 38.22933], [-122.61102, 38.22968], [-122.61177, 38.23], [-122.61184, 38.23035], [-122.61151, 38.23186], [-122.60961, 38.23153], [-122.60965, 38.23137], [-122.6092, 38.2308], [-122.6087, 38.23061], [-122.61067, 38.22837], [-122.60854, 38.22718], [-122.60936, 38.22628], [-122.60989, 38.22655], [-122.6104, 38.22678], [-122.61292, 38.22825]]]} No Public Access 3 Alman   15392 1249 Petaluma, City of 144 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 26.616 Alman 1995
346 345 {"type": "Polygon", "coordinates": [[[-121.70881, 37.05148], [-121.70881, 37.05521], [-121.70362, 37.05528], [-121.7038, 37.06238], [-121.69622, 37.06245], [-121.69514, 37.06244], [-121.69439, 37.06355], [-121.69444, 37.0639], [-121.69444, 37.06407], [-121.69411, 37.0645], [-121.6941, 37.06458], [-121.69364, 37.06462], [-121.69249, 37.0636], [-121.69248, 37.05907], [-121.69522, 37.05905], [-121.69519, 37.05511], [-121.69504, 37.05144], [-121.69974, 37.05144], [-121.69975, 37.04779], [-121.70426, 37.0478], [-121.70428, 37.05146], [-121.70881, 37.05148]]]} No Public Access 3 Uvas South Open Space Regional Reserve https://www.scv-habitatagency.org/ 33792 503 Santa Clara Valley Habitat Agency 529 Joint 8 Joint Powers Authority 23 https://www.scv-habitatagency.org/ Special District 4 347.767 Uvas South OS RR  
398 397 {"type": "Polygon", "coordinates": [[[-121.45171, 37.99673], [-121.45157, 37.99753], [-121.45125, 37.99803], [-121.44772, 37.99697], [-121.449, 37.99516], [-121.45045, 37.99469], [-121.45112, 37.99482], [-121.4517, 37.99592], [-121.45175, 37.99649], [-121.45171, 37.99673]]]} No Public Access 3 Acker Island   32009 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 20.964 Acker Island  
419 418 {"type": "MultiPolygon", "coordinates": [[[[-119.50998, 35.36521], [-119.50076, 35.36536], [-119.50076, 35.36145], [-119.50129, 35.36134], [-119.50218, 35.36122], [-119.50274, 35.36122], [-119.50324, 35.36126], [-119.50374, 35.36134], [-119.50422, 35.36146], [-119.50466, 35.36161], [-119.50529, 35.36191], [-119.50667, 35.36283], [-119.50706, 35.36313], [-119.50998, 35.36521]]], [[[-119.63933, 35.48483], [-119.63646, 35.48481], [-119.63652, 35.47193], [-119.63789, 35.47208], [-119.63786, 35.47474], [-119.63778, 35.47861], [-119.63933, 35.48483]]]]} No Public Access 3 California Aqueduct, Region 4   32081 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 118.422 California Aqueduct, Region 4  
426 425 {"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 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 4.082 Bodega Bay Monarch Butterfly  
430 429 {"type": "Polygon", "coordinates": [[[-120.90912, 38.31308], [-120.909, 38.31682], [-120.90552, 38.31687], [-120.90527, 38.31584], [-120.90514, 38.31541], [-120.90507, 38.31524], [-120.90461, 38.31438], [-120.90456, 38.3131], [-120.90912, 38.31308]]]} No Public Access 3 Apricum Hill Ecological Reserve   32028 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 37.028 Apricum Hill ER  
446 445 {"type": "MultiPolygon", "coordinates": [[[[-120.48135, 37.664], [-120.48132, 37.6642], [-120.48125, 37.66437], [-120.4811, 37.66452], [-120.48045, 37.66487], [-120.48026, 37.66491], [-120.48014, 37.66503], [-120.48008, 37.66532], [-120.48024, 37.66591], [-120.48028, 37.66614], [-120.4798, 37.66635], [-120.47901, 37.66496], [-120.4796, 37.66459], [-120.48005, 37.664], [-120.48135, 37.664]]], [[[-120.4855, 37.66112], [-120.48408, 37.66265], [-120.48188, 37.66423], [-120.48187, 37.66342], [-120.48365, 37.66179], [-120.48456, 37.66139], [-120.4855, 37.66112]]], [[[-120.49114, 37.6524], [-120.49083, 37.65283], [-120.48841, 37.65436], [-120.48773, 37.65488], [-120.48736, 37.65553], [-120.48638, 37.65828], [-120.48687, 37.65881], [-120.48684, 37.65947], [-120.48661, 37.65996], [-120.48558, 37.66106], [-120.48505, 37.66093], [-120.48574, 37.65927], [-120.48583, 37.65912], [-120.48578, 37.65798], [-120.48685, 37.65542], [-120.48765, 37.65458], [-120.48824, 37.6535], [-120.48889, 37.65314], [-120.48929, 37.65245], [-120.49114, 37.6524]]]]} No Public Access 3 Basso Bridge   32041 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 31.443 Basso Bridge  
447 446 {"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 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 45.386 Bend Ferry Road  
479 478 {"type": "Polygon", "coordinates": [[[-121.614, 37.79798], [-121.61399, 37.79871], [-121.61178, 37.80234], [-121.60506, 37.80232], [-121.60511, 37.79512], [-121.60597, 37.79516], [-121.60635, 37.79514], [-121.60669, 37.7951], [-121.60708, 37.79511], [-121.6071, 37.79502], [-121.61204, 37.79505], [-121.614, 37.79798]]]} No Public Access 3 Byron Conservation Bank   32076 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 139.977 Byron Conservation Bank  
523 522 {"type": "MultiPolygon", "coordinates": [[[[-119.95169, 35.34039], [-119.95158, 35.34385], [-119.94704, 35.34383], [-119.947, 35.3511], [-119.93381, 35.35103], [-119.93382, 35.34373], [-119.94282, 35.34379], [-119.94285, 35.34034], [-119.95169, 35.34039]]], [[[-119.96505, 35.33683], [-119.96502, 35.344], [-119.96043, 35.3441], [-119.96043, 35.3477], [-119.9559, 35.34767], [-119.95603, 35.34409], [-119.96042, 35.34408], [-119.96057, 35.33683], [-119.96505, 35.33683]]], [[[-119.98747, 35.33683], [-119.98735, 35.34411], [-119.96942, 35.34398], [-119.96961, 35.33682], [-119.98747, 35.33683]]], [[[-120.11221, 35.42515], [-120.11212, 35.43976], [-120.07625, 35.43965], [-120.07683, 35.425], [-120.05856, 35.4248], [-120.05868, 35.41024], [-120.04079, 35.41018], [-120.04075, 35.39937], [-120.03648, 35.39936], [-120.03645, 35.40289], [-120.03174, 35.40286], [-120.03177, 35.39558], [-120.02292, 35.39551], [-120.02283, 35.39752], [-120.01828, 35.39748], [-120.01829, 35.39549], [-120.01409, 35.39544], [-120.0141, 35.39176], [-120.01834, 35.39181], [-120.0183, 35.39547], [-120.01842, 35.39547], [-120.01842, 35.38431], [-120.01407, 35.3843], [-120.01398, 35.40632], [-120.02291, 35.40637], [-120.02291, 35.41006], [-120.01397, 35.4101], [-120.01396, 35.40745], [-119.98714, 35.40745], [-119.98723, 35.39547], [-119.98728, 35.38073], [-119.98721, 35.36616], [-120.00498, 35.36619], [-120.00533, 35.3516], [-120.03916, 35.35179], [-120.03919, 35.35942], [-120.03263, 35.35936], [-120.03223, 35.35888], [-120.03236, 35.3554], [-120.03276, 35.35491], [-120.03265, 35.35331], [-120.02691, 35.35332], [-120.02685, 35.35474], [-120.02724, 35.35502], [-120.02737, 35.38091], [-120.02717, 35.38093], [-120.02729, 35.3881], [-120.03183, 35.38814], [-120.03182, 35.38882], [-120.03184, 35.38884], [-120.03414, 35.38879], [-120.03698, 35.38817], [-120.04584, 35.38823], [-120.04588, 35.39171], [-120.04986, 35.39171], [-120.04991, 35.39568], [-120.05879, 35.39569], [-120.05897, 35.38872], [-120.06823, 35.38878], [-120.06819, 35.3957], [-120.08401, 35.39576], [-120.084, 35.40312], [-120.09426, 35.40318], [-120.09436, 35.42494], [-120.11221, 35.42515]], [[-120.0095, 35.36991], [-120.00951, 35.3699], [-120.0095, 35.36985], [-120.00509, 35.36985], [-120.00507, 35.36914], [-120.00505, 35.36914], [-120.00507, 35.3699], [-120.0095, 35.36991]], [[-120.0141, 35.38085], [-120.01412, 35.38084], [-120.0141, 35.38055], [-120.01409, 35.38084], [-120.0141, 35.38085]]], [[[-120.04067, 35.38442], [-120.03626, 35.3844], [-120.03623, 35.38094], [-120.04065, 35.38097], [-120.04067, 35.38442]]], [[[-120.09453, 35.35203], [-120.09446, 35.35604], [-120.09433, 35.35941], [-120.0943, 35.36646], [-120.08626, 35.36648], [-120.07741, 35.36647], [-120.07697, 35.36631], [-120.07702, 35.35933], [-120.07701, 35.35682], [-120.07617, 35.35678], [-120.07177, 35.35231], [-120.07016, 35.35227], [-120.07016, 35.35184], [-120.06997, 35.34965], [-120.06845, 35.34954], [-120.0685, 35.34831], [-120.0667, 35.34825], [-120.06668, 35.34663], [-120.06482, 35.34664], [-120.06478, 35.34489], [-120.06469, 35.3448], [-120.05735, 35.3449], [-120.05727, 35.34647], [-120.0543, 35.34645], [-120.05426, 35.34491], [-120.05033, 35.34496], [-120.0502, 35.34824], [-120.04715, 35.34821], [-120.04698, 35.3597], [-120.04063, 35.3597], [-120.04082, 35.33879], [-120.04089, 35.33879], [-120.05021, 35.34175], [-120.05287, 35.3416], [-120.0528, 35.33703], [-120.07704, 35.33706], [-120.07699, 35.35187], [-120.09453, 35.35203]]], [[[-120.09423, 35.37925], [-120.09423, 35.38101], [-120.09421, 35.38124], [-120.08206, 35.38118], [-120.08205, 35.38115], [-120.07786, 35.38119], [-120.0779, 35.37486], [-120.07979, 35.37486], [-120.08205, 35.37551], [-120.08204, 35.36856], [-120.08214, 35.3686], [-120.08216, 35.37614], [-120.09141, 35.37927], [-120.09423, 35.37925]]]]} No Public Access 3 California Valley   32084 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 12381.101 California Valley  
538 537 {"type": "Polygon", "coordinates": [[[-120.12654, 39.80173], [-120.12649, 39.80538], [-120.1218, 39.80539], [-120.12175, 39.80901], [-120.12212, 39.80903], [-120.12208, 39.81271], [-120.11271, 39.81273], [-120.1127, 39.80904], [-120.11264, 39.80179], [-120.12654, 39.80173]]]} No Public Access 3 Chilcoot   32112 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 277.451 Chilcoot  
539 538 {"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 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 63.897 Christensen Road Burrowing Owl Site  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY(ACCESS_TYP) REFERENCES ACCESS_TYP(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(LAYER) REFERENCES LAYER(id)
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
                ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
                ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
                ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
                ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
                ON [superunits_with_maps] ([ACCESS_TYP]);
Powered by Datasette · Query took 327.229ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette