calands: units_with_maps: 1 row where ACCESS_TYP = 1, DES_TP = 4 and MNG

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

1 row where ACCESS_TYP = 1, DES_TP = 4 and MNG_AGENCY = 369

Search:

descending

This data as json, copyable, CSV (advanced)

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
16940	16940	16939	{"type": "Polygon", "coordinates": [[[-122.84377, 38.62226], [-122.84368, 38.6223], [-122.84358, 38.62231], [-122.84251, 38.62232], [-122.84195, 38.62227], [-122.84194, 38.62237], [-122.84211, 38.62239], [-122.84209, 38.62266], [-122.84173, 38.62262], [-122.84146, 38.62261], [-122.84145, 38.62289], [-122.84092, 38.62291], [-122.83988, 38.62287], [-122.83935, 38.62288], [-122.83932, 38.62261], [-122.8385, 38.62264], [-122.83877, 38.62224], [-122.83884, 38.62226], [-122.83889, 38.62219], [-122.83906, 38.62227], [-122.83918, 38.62227], [-122.83929, 38.62204], [-122.83907, 38.62196], [-122.83888, 38.62178], [-122.83872, 38.62157], [-122.83862, 38.6215], [-122.83849, 38.62145], [-122.83831, 38.62145], [-122.83813, 38.62151], [-122.83803, 38.62158], [-122.83775, 38.62188], [-122.83708, 38.62147], [-122.83713, 38.62062], [-122.83543, 38.62019], [-122.83495, 38.61921], [-122.83414, 38.61931], [-122.83411, 38.61939], [-122.83377, 38.61963], [-122.83329, 38.61974], [-122.83322, 38.61978], [-122.8331, 38.61987], [-122.83305, 38.61997], [-122.833, 38.62003], [-122.83241, 38.62041], [-122.83109, 38.62042], [-122.83098, 38.62033], [-122.83122, 38.61983], [-122.83154, 38.61989], [-122.83171, 38.61933], [-122.83183, 38.61844], [-122.83043, 38.6186], [-122.82999, 38.61855], [-122.82945, 38.61845], [-122.82937, 38.61872], [-122.8289, 38.61905], [-122.82851, 38.61911], [-122.82849, 38.6189], [-122.82854, 38.61876], [-122.82855, 38.61869], [-122.82859, 38.61857], [-122.82858, 38.61856], [-122.82873, 38.61827], [-122.82913, 38.61772], [-122.82916, 38.61763], [-122.82917, 38.61752], [-122.8292, 38.61746], [-122.82925, 38.61741], [-122.82949, 38.61732], [-122.83004, 38.61777], [-122.83039, 38.61772], [-122.83069, 38.61762], [-122.8307, 38.61761], [-122.83059, 38.61749], [-122.83074, 38.61742], [-122.83076, 38.61743], [-122.83097, 38.6173], [-122.83121, 38.61714], [-122.83145, 38.61694], [-122.83144, 38.61693], [-122.83122, 38.61677], [-122.83151, 38.61647], [-122.83123, 38.61632], [-122.83145, 38.61601], [-122.83254, 38.6164], [-122.83256, 38.61587], [-122.83507, 38.61554], [-122.83573, 38.61541], [-122.83587, 38.61568], [-122.83646, 38.61567], [-122.8367, 38.61612], [-122.83795, 38.61568], [-122.83876, 38.61654], [-122.83923, 38.61678], [-122.84085, 38.61657], [-122.84112, 38.61639], [-122.84178, 38.61646], [-122.8423, 38.61692], [-122.84344, 38.61729], [-122.84328, 38.62056], [-122.8473, 38.62055], [-122.84721, 38.62384], [-122.84713, 38.62377], [-122.84704, 38.62359], [-122.84697, 38.62351], [-122.84687, 38.62346], [-122.84648, 38.62335], [-122.84634, 38.62325], [-122.84626, 38.62314], [-122.84624, 38.62309], [-122.84622, 38.62297], [-122.84623, 38.62286], [-122.84622, 38.6228], [-122.84618, 38.62273], [-122.84611, 38.62269], [-122.84603, 38.62266], [-122.8459, 38.62267], [-122.84547, 38.62287], [-122.84526, 38.62288], [-122.84489, 38.62269], [-122.84456, 38.62257], [-122.84453, 38.62252], [-122.84477, 38.62231], [-122.84469, 38.62216], [-122.84439, 38.62229], [-122.84433, 38.62204], [-122.84427, 38.62197], [-122.84443, 38.62173], [-122.84426, 38.62168], [-122.84407, 38.62168], [-122.84393, 38.62173], [-122.84411, 38.62196], [-122.84386, 38.62221], [-122.84377, 38.62226]]]}	Open Access 1	49079	Fitch Mountain Park Open Space Preserve	33780	1131	Healdsburg, City of 374	City 2	City Agency 2	http://www.ci.healdsburg.ca.us/index.aspx?page=94	City 2	1131	Healdsburg, City of 369	City 2	City Agency 2		Sonoma 16	171.489	Fitch Mtn. Park OSP	0	Local Conservation Area 4	2

Advanced export

JSON shape: default, array, newline-delimited

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