superunits_with_maps

Table actions

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

8 rows where ACCESS_TYP = 2, MNG_AGENCY = 383 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 8 ✖

MNG_AGENCY 1

  • Sonoma County Agricultural Preservation and Open Space District · 8 ✖

ACCESS_TYP 1

  • Restricted Access · 8 ✖
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
3638 3638 3637 {"type": "Polygon", "coordinates": [[[-122.74565, 38.48914], [-122.74561, 38.49073], [-122.74474, 38.49073], [-122.74477, 38.48913], [-122.74565, 38.48914]]]} Restricted Access 2 Dogbane Preserve   18185 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 3.336 Dogbane Preserve 1997
4913 4913 4912 {"type": "Polygon", "coordinates": [[[-122.77518, 38.5124], [-122.77517, 38.51382], [-122.77439, 38.51382], [-122.77438, 38.51457], [-122.77441, 38.51462], [-122.77411, 38.51462], [-122.77416, 38.51461], [-122.77419, 38.51456], [-122.77419, 38.51408], [-122.77381, 38.51408], [-122.77007, 38.51134], [-122.77015, 38.51127], [-122.77266, 38.51126], [-122.77306, 38.5114], [-122.7732, 38.51147], [-122.77398, 38.51204], [-122.77415, 38.51213], [-122.77433, 38.5122], [-122.77453, 38.51225], [-122.77454, 38.5124], [-122.77518, 38.5124]]]} Restricted Access 2 Haroutunian - North   19687 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 17.885 Haroutunian - North 1998
8034 8034 8033 {"type": "Polygon", "coordinates": [[[-122.71333, 38.46711], [-122.71299, 38.46738], [-122.71145, 38.46737], [-122.71128, 38.46696], [-122.71062, 38.46664], [-122.70974, 38.46649], [-122.7093, 38.46643], [-122.70931, 38.46509], [-122.70982, 38.46538], [-122.70965, 38.46549], [-122.70965, 38.46551], [-122.71007, 38.46571], [-122.71059, 38.46537], [-122.71017, 38.46515], [-122.71023, 38.4651], [-122.71094, 38.46545], [-122.71107, 38.46539], [-122.71143, 38.46574], [-122.71137, 38.46579], [-122.71199, 38.46668], [-122.71288, 38.46701], [-122.71318, 38.46714], [-122.71327, 38.46715], [-122.71333, 38.46711]]]} Restricted Access 2 Paulin Creek Preserve   23535 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 8.971 Paulin Creek Preserve 2002
11613 11613 11612 {"type": "Polygon", "coordinates": [[[-122.57706, 38.34341], [-122.57393, 38.34345], [-122.57415, 38.3379], [-122.57415, 38.3379], [-122.57706, 38.34341]]]} Restricted Access 2 Sonoma Mountain North Slope http://www.sonomaopenspace.org/Content/?p=10096/preview.html 28157 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 20.85 Sonoma Mtn. North Slope  
13761 13761 13760 {"type": "Polygon", "coordinates": [[[-123.07275, 38.37014], [-123.07057, 38.37134], [-123.06942, 38.37164], [-123.0685, 38.37149], [-123.06748, 38.37154], [-123.06637, 38.37194], [-123.06309, 38.36451], [-123.06149, 38.36456], [-123.05809, 38.35921], [-123.05832, 38.35919], [-123.05836, 38.35916], [-123.0584, 38.35911], [-123.05846, 38.35891], [-123.05851, 38.35864], [-123.05854, 38.35835], [-123.05851, 38.35812], [-123.05851, 38.35799], [-123.05848, 38.35785], [-123.0583, 38.35731], [-123.05826, 38.35715], [-123.05826, 38.35706], [-123.05823, 38.35697], [-123.05822, 38.35682], [-123.05822, 38.35627], [-123.0582, 38.35599], [-123.05824, 38.35569], [-123.05831, 38.35553], [-123.05839, 38.35542], [-123.05872, 38.35516], [-123.05927, 38.3549], [-123.05942, 38.35485], [-123.05994, 38.35473], [-123.06015, 38.35469], [-123.06041, 38.35468], [-123.06101, 38.35462], [-123.06128, 38.35457], [-123.06153, 38.35449], [-123.06171, 38.35436], [-123.06179, 38.35419], [-123.06177, 38.3541], [-123.06176, 38.35385], [-123.06179, 38.35378], [-123.06188, 38.35331], [-123.06184, 38.35315], [-123.06172, 38.35292], [-123.06172, 38.35287], [-123.06166, 38.35281], [-123.06163, 38.35274], [-123.06158, 38.35256], [-123.06249, 38.35334], [-123.06313, 38.35379], [-123.06445, 38.35463], [-123.06499, 38.35501], [-123.06561, 38.35547], [-123.0666, 38.35624], [-123.06683, 38.3565], [-123.06689, 38.35665], [-123.06694, 38.35688], [-123.06696, 38.35708], [-123.06696, 38.35747], [-123.06692, 38.35779], [-123.06695, 38.358], [-123.06706, 38.35821], [-123.0675, 38.35885], [-123.06775, 38.35926], [-123.06781, 38.35942], [-123.06797, 38.3601], [-123.06807, 38.36034], [-123.06817, 38.36051], [-123.06855, 38.361], [-123.06867, 38.36122], [-123.06873, 38.36144], [-123.06873, 38.36205], [-123.06878, 38.36226], [-123.06891, 38.36246], [-123.06962, 38.36317], [-123.06968, 38.36328], [-123.0698, 38.36358], [-123.06997, 38.36426], [-123.07005, 38.36441], [-123.07075, 38.36541], [-123.0715, 38.36668], [-123.07159, 38.36688], [-123.0717, 38.36731], [-123.07179, 38.36752], [-123.07194, 38.3677], [-123.07229, 38.36799], [-123.07245, 38.36823], [-123.07281, 38.3691], [-123.07287, 38.36927], [-123.07288, 38.36939], [-123.07287, 38.36952], [-123.07283, 38.3697], [-123.07275, 38.36998], [-123.07275, 38.37014]]]} Restricted Access 2 Carrington Coast Ranch   31268 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 329.468 Carrington Coast Ranch 2003
13762 13762 13761 {"type": "Polygon", "coordinates": [[[-123.08436, 38.41731], [-123.08339, 38.41781], [-123.08307, 38.41824], [-123.07891, 38.419], [-123.07696, 38.41946], [-123.0755, 38.41958], [-123.07523, 38.41971], [-123.0749, 38.41972], [-123.07391, 38.42022], [-123.07362, 38.42069], [-123.07155, 38.41916], [-123.07123, 38.4189], [-123.07012, 38.41946], [-123.05, 38.41394], [-123.04996, 38.41276], [-123.05159, 38.40942], [-123.05189, 38.40885], [-123.05599, 38.39896], [-123.05744, 38.39899], [-123.06296, 38.39893], [-123.07062, 38.39889], [-123.0766, 38.3989], [-123.07661, 38.39927], [-123.07777, 38.40065], [-123.07788, 38.40203], [-123.0783, 38.40265], [-123.0803, 38.40324], [-123.08065, 38.40337], [-123.08077, 38.40419], [-123.08137, 38.40521], [-123.08169, 38.40551], [-123.08067, 38.40628], [-123.08286, 38.40896], [-123.08208, 38.40935], [-123.08436, 38.41731]]]} Restricted Access 2 Wright Hill (Poff) Ranch Preserve   31269 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 1311.071 Wright Hill (Poff) Ranch Preserve 2007
14702 14702 14701 {"type": "Polygon", "coordinates": [[[-122.51794, 38.39444], [-122.51749, 38.39489], [-122.51721, 38.39492], [-122.51628, 38.39471], [-122.51547, 38.39579], [-122.5154, 38.39625], [-122.51434, 38.39719], [-122.51404, 38.39797], [-122.51341, 38.39844], [-122.51254, 38.39839], [-122.51226, 38.3985], [-122.51155, 38.3992], [-122.51308, 38.40643], [-122.50662, 38.41063], [-122.50692, 38.41194], [-122.50623, 38.41198], [-122.49862, 38.41202], [-122.499, 38.41263], [-122.50109, 38.41614], [-122.50109, 38.4227], [-122.4944, 38.42265], [-122.49366, 38.42183], [-122.49301, 38.42133], [-122.49233, 38.42044], [-122.49132, 38.41978], [-122.49077, 38.41969], [-122.49016, 38.4195], [-122.48989, 38.41911], [-122.48945, 38.41874], [-122.48906, 38.41815], [-122.48894, 38.41773], [-122.48806, 38.41736], [-122.48745, 38.41671], [-122.48692, 38.41646], [-122.48595, 38.41633], [-122.48543, 38.41574], [-122.48421, 38.41545], [-122.4839, 38.41529], [-122.48328, 38.41467], [-122.48146, 38.41346], [-122.4811, 38.41314], [-122.48107, 38.41254], [-122.48064, 38.41238], [-122.47932, 38.41211], [-122.4788, 38.41156], [-122.47866, 38.41119], [-122.47818, 38.41075], [-122.47807, 38.41056], [-122.47739, 38.41053], [-122.47694, 38.41031], [-122.47669, 38.4101], [-122.47625, 38.40949], [-122.47575, 38.40944], [-122.47531, 38.4091], [-122.47555, 38.40877], [-122.47573, 38.40867], [-122.47772, 38.4086], [-122.47774, 38.40479], [-122.47768, 38.40149], [-122.48243, 38.4015], [-122.50109, 38.40116], [-122.50102, 38.39755], [-122.50161, 38.39707], [-122.50206, 38.39694], [-122.50251, 38.39704], [-122.50286, 38.39702], [-122.50325, 38.39686], [-122.50349, 38.39655], [-122.50409, 38.39644], [-122.50441, 38.39656], [-122.50477, 38.39656], [-122.50534, 38.39684], [-122.50555, 38.39692], [-122.50841, 38.40025], [-122.50845, 38.40022], [-122.50858, 38.40003], [-122.5087, 38.3998], [-122.50887, 38.39932], [-122.50895, 38.39919], [-122.50924, 38.39885], [-122.50945, 38.39869], [-122.5097, 38.39856], [-122.50997, 38.39851], [-122.51032, 38.39846], [-122.51077, 38.39841], [-122.51099, 38.39845], [-122.51109, 38.39849], [-122.51121, 38.39858], [-122.51136, 38.39863], [-122.51143, 38.39863], [-122.5117, 38.39849], [-122.51196, 38.39823], [-122.51224, 38.39808], [-122.51236, 38.39804], [-122.51271, 38.39798], [-122.51305, 38.39797], [-122.5133, 38.39795], [-122.51345, 38.39791], [-122.51365, 38.39776], [-122.5137, 38.39769], [-122.51377, 38.39742], [-122.51396, 38.39708], [-122.51414, 38.3969], [-122.51426, 38.39681], [-122.51444, 38.39665], [-122.51464, 38.39643], [-122.51498, 38.39615], [-122.51522, 38.39546], [-122.51543, 38.39507], [-122.51564, 38.39478], [-122.51581, 38.3946], [-122.5161, 38.39438], [-122.51622, 38.39424], [-122.51632, 38.39416], [-122.51673, 38.39357], [-122.51702, 38.39296], [-122.51721, 38.39237], [-122.51737, 38.39236], [-122.5175, 38.39232], [-122.51754, 38.39242], [-122.51773, 38.39268], [-122.51802, 38.39328], [-122.51803, 38.39369], [-122.51796, 38.39416], [-122.51794, 38.39444]]]} Restricted Access 2 Calabazas Creek Open Space Preserve   16669 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 1283.469 Calabazas Creek OSP 2004
15559 15559 15558 {"type": "Polygon", "coordinates": [[[-122.64929, 38.49868], [-122.64914, 38.49872], [-122.64901, 38.4988], [-122.6489, 38.4989], [-122.64884, 38.49901], [-122.6488, 38.49912], [-122.6488, 38.49924], [-122.64817, 38.49896], [-122.648, 38.49906], [-122.64602, 38.49904], [-122.64464, 38.49892], [-122.64157, 38.49828], [-122.64048, 38.4982], [-122.63995, 38.49843], [-122.63855, 38.49832], [-122.63752, 38.49783], [-122.63694, 38.498], [-122.63675, 38.49867], [-122.63629, 38.49901], [-122.63575, 38.49931], [-122.63419, 38.50054], [-122.63629, 38.50362], [-122.64069, 38.5036], [-122.64077, 38.50728], [-122.64017, 38.50767], [-122.6393, 38.50829], [-122.63932, 38.50826], [-122.6393, 38.50821], [-122.639, 38.50804], [-122.63784, 38.5084], [-122.63158, 38.51022], [-122.62288, 38.50997], [-122.6228, 38.50987], [-122.62239, 38.50957], [-122.62224, 38.50941], [-122.62216, 38.50927], [-122.62202, 38.50917], [-122.62177, 38.50893], [-122.62175, 38.50886], [-122.62151, 38.50868], [-122.62101, 38.50848], [-122.62053, 38.50846], [-122.62019, 38.50842], [-122.6199, 38.50829], [-122.61969, 38.50828], [-122.61957, 38.50824], [-122.6193, 38.50804], [-122.61911, 38.50738], [-122.61907, 38.50735], [-122.619, 38.50719], [-122.61875, 38.50706], [-122.61842, 38.50707], [-122.61802, 38.50695], [-122.61785, 38.50695], [-122.61776, 38.50693], [-122.61763, 38.50696], [-122.61743, 38.50694], [-122.61698, 38.50677], [-122.61629, 38.50629], [-122.61625, 38.50628], [-122.61568, 38.50593], [-122.61495, 38.50564], [-122.61414, 38.50543], [-122.61408, 38.50545], [-122.61396, 38.50544], [-122.61302, 38.50578], [-122.61262, 38.50579], [-122.61255, 38.50583], [-122.61239, 38.50584], [-122.61207, 38.50581], [-122.61183, 38.50568], [-122.61169, 38.50555], [-122.61153, 38.50552], [-122.61152, 38.50553], [-122.61159, 38.5076], [-122.61405, 38.50761], [-122.6166, 38.50994], [-122.60967, 38.50997], [-122.60857, 38.49909], [-122.60853, 38.4956], [-122.6135, 38.49559], [-122.61368, 38.4994], [-122.63133, 38.49922], [-122.63517, 38.49898], [-122.63515, 38.49793], [-122.63588, 38.49767], [-122.63584, 38.49644], [-122.64068, 38.49719], [-122.64381, 38.49559], [-122.64277, 38.49505], [-122.64275, 38.49291], [-122.64347, 38.49251], [-122.64347, 38.49249], [-122.64293, 38.49197], [-122.64279, 38.49202], [-122.64265, 38.49203], [-122.64252, 38.49199], [-122.64234, 38.49191], [-122.64166, 38.4915], [-122.64144, 38.49133], [-122.64134, 38.49118], [-122.6413, 38.49106], [-122.6412, 38.49053], [-122.6411, 38.49036], [-122.64079, 38.49006], [-122.64066, 38.48988], [-122.64049, 38.48942], [-122.64041, 38.4893], [-122.64028, 38.48924], [-122.64017, 38.48922], [-122.64001, 38.48584], [-122.64922, 38.48596], [-122.64926, 38.48754], [-122.64935, 38.49519], [-122.64929, 38.49868]], [[-122.63965, 38.50754], [-122.63964, 38.50751], [-122.63829, 38.50681], [-122.63821, 38.50688], [-122.63794, 38.50721], [-122.63913, 38.5079], [-122.63965, 38.50754]]]} Restricted Access 2 Saddle Mountain Open Space Preserve   24775 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 975.341 Saddle Mtn. OSP 2006

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