units_with_maps

Table actions

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

8 rows where ACCESS_TYP = 2, AGNCY_NAME = 387 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 8 ✖

ACCESS_TYP 1

  • Restricted Access · 8 ✖
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
2286 2286 2285 {"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.51457], [-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.77453, 38.5124], [-122.77518, 38.5124]]]} Restricted Access 2 16876 Haroutunian - North 19687 2155 Sonoma County Agricultural Preservation and Open Space District 387 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4   Sonoma 16 17.875 Haroutunian - North 1998 None 190  
3617 3617 3616 {"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 29390 Dogbane Preserve 18185 2155 Sonoma County Agricultural Preservation and Open Space District 387 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4   Sonoma 16 3.337 Dogbane Preserve 1997 Local Conservation Area 4 2
5768 5768 5767 {"type": "Polygon", "coordinates": [[[-122.57706, 38.34341], [-122.57393, 38.34345], [-122.57415, 38.3379], [-122.57706, 38.34341], [-122.57706, 38.34341]]]} Restricted Access 2 24774 Sonoma Mountain North Slope 28157 2155 Sonoma County Agricultural Preservation and Open Space District 387 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/Content/?p=10096/preview.html Sonoma 16 20.852 Sonoma Mtn. North Slope   None 464  
6790 6790 6789 {"type": "Polygon", "coordinates": [[[-122.71333, 38.46711], [-122.71318, 38.46725], [-122.71299, 38.46738], [-122.71145, 38.46737], [-122.71128, 38.46696], [-122.71062, 38.46664], [-122.70973, 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.46572], [-122.7106, 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 5292 Paulin Creek Preserve 23535 2155 Sonoma County Agricultural Preservation and Open Space District 387 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4   Sonoma 16 8.962 Paulin Creek Preserve 2002 Local Conservation Area 4 2
6981 6981 6980 {"type": "Polygon", "coordinates": [[[-123.08436, 38.41731], [-123.08339, 38.41781], [-123.08308, 38.41824], [-123.07891, 38.419], [-123.07696, 38.41946], [-123.0755, 38.41958], [-123.07523, 38.41971], [-123.0749, 38.41972], [-123.0739, 38.42022], [-123.07362, 38.42069], [-123.07155, 38.41916], [-123.07123, 38.41889], [-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.40266], [-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.40934], [-123.08436, 38.41731]]]} Restricted Access 2 47552 Wright Hill (Poff) Ranch Preserve 31269 2155 Sonoma County Agricultural Preservation and Open Space District 387 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4   Sonoma 16 1311.039 Wright Hill (Poff) Ranch Preserve 2007 Local Conservation Area 4 2
9081 9081 9080 {"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.3645], [-123.06149, 38.36456], [-123.05809, 38.35921], [-123.05832, 38.35919], [-123.05836, 38.35916], [-123.0584, 38.35911], [-123.05846, 38.35892], [-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.35714], [-123.05826, 38.35705], [-123.05823, 38.35697], [-123.05822, 38.35682], [-123.05822, 38.35627], [-123.0582, 38.356], [-123.05824, 38.35569], [-123.05831, 38.35553], [-123.05838, 38.35543], [-123.05872, 38.35516], [-123.05927, 38.3549], [-123.05941, 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.35435], [-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.3578], [-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.36033], [-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.36427], [-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 15036 Carrington Coast Ranch 31268 2155 Sonoma County Agricultural Preservation and Open Space District 387 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4   Sonoma 16 329.459 Carrington Coast Ranch 2003 Local Other or Unknown 14 4
15891 15891 15890 {"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.50661, 38.41063], [-122.50692, 38.41194], [-122.50623, 38.41198], [-122.49861, 38.41202], [-122.499, 38.41263], [-122.50109, 38.41614], [-122.50109, 38.4227], [-122.4944, 38.42265], [-122.49366, 38.42182], [-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.41875], [-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.48108, 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.41055], [-122.47739, 38.41053], [-122.47694, 38.41031], [-122.47669, 38.4101], [-122.47625, 38.40948], [-122.47575, 38.40944], [-122.47531, 38.4091], [-122.47555, 38.40877], [-122.47573, 38.40867], [-122.47772, 38.40861], [-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.51381, 38.39736], [-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.51738, 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 8210 Calabazas Creek Open Space Preserve 16669 2155 Sonoma County Agricultural Preservation and Open Space District 387 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4   Sonoma 16 1283.299 Calabazas Creek OSP 2004 Local Conservation Area 4 2
16944 16944 16943 {"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.63418, 38.50055], [-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.61367, 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.64382, 38.49558], [-122.64277, 38.49505], [-122.64275, 38.49291], [-122.64348, 38.4925], [-122.64292, 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.6404, 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.50753], [-122.63965, 38.50752], [-122.63829, 38.5068], [-122.63821, 38.50687], [-122.63793, 38.50722], [-122.63914, 38.5079], [-122.63965, 38.50753]]]} Restricted Access 2 29388 Saddle Mountain Open Space Preserve 24775 2155 Sonoma County Agricultural Preservation and Open Space District 387 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4   Sonoma 16 975.177 Saddle Mtn. OSP 2006 Local Conservation Area 4 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]);