units_with_maps

Table actions

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

5 rows where ACCESS_TYP = 2, DES_TP = 4 and MNG_AG_ID = 2155

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Local Conservation Area · 5 ✖

ACCESS_TYP 1

  • Restricted Access · 5 ✖
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
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
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
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]);