calands: units_with_maps: 3 rows where AGNCY_TYP = 4, DES_TP = 4 and MNG

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

3 rows where AGNCY_TYP = 4, DES_TP = 4 and MNG_AGENCY = 108

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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
1409	1409	1408	{"type": "Polygon", "coordinates": [[[-122.22844, 38.49945], [-122.2279, 38.50313], [-122.22773, 38.50628], [-122.22303, 38.50615], [-122.22259, 38.50313], [-122.21653, 38.50301], [-122.21525, 38.49979], [-122.21427, 38.50009], [-122.21463, 38.49794], [-122.21505, 38.49581], [-122.2195, 38.49582], [-122.22405, 38.49579], [-122.22333, 38.49946], [-122.22844, 38.49945]]]}	Open Access 1	47680	Berryessa Vista Wilderness Park	31419	2268	Napa County Regional Park and Open Space District 362	Special District 4	Recreation/Parks District 4	http://napaoutdoors.org/	Special District 4	2268	Napa County Regional Park and Open Space District 108	Special District 4	Recreation/Parks District 4	Napa 11	223.82	Berryessa Vista Wilderness Park	Local Conservation Area 4	2
5430	5430	5429	{"type": "Polygon", "coordinates": [[[-122.37954, 38.52679], [-122.37943, 38.53352], [-122.37934, 38.53719], [-122.3794, 38.54087], [-122.37473, 38.54091], [-122.3747, 38.53716], [-122.37009, 38.53718], [-122.37006, 38.53357], [-122.3654, 38.53357], [-122.36563, 38.52633], [-122.36109, 38.52638], [-122.36117, 38.52275], [-122.35615, 38.51918], [-122.35606, 38.51542], [-122.35137, 38.51208], [-122.35186, 38.51158], [-122.35196, 38.51146], [-122.35214, 38.51118], [-122.35232, 38.51084], [-122.35239, 38.51076], [-122.35292, 38.51034], [-122.35299, 38.51021], [-122.35301, 38.51004], [-122.35297, 38.50985], [-122.35281, 38.50955], [-122.35289, 38.50905], [-122.35299, 38.50893], [-122.35319, 38.50883], [-122.35346, 38.50875], [-122.35367, 38.50867], [-122.3538, 38.50858], [-122.35393, 38.50839], [-122.35551, 38.50838], [-122.35586, 38.50924], [-122.3559, 38.50981], [-122.35601, 38.51033], [-122.35619, 38.51066], [-122.35652, 38.51092], [-122.35682, 38.51129], [-122.35721, 38.51148], [-122.3573, 38.51156], [-122.35751, 38.51169], [-122.35771, 38.5118], [-122.35805, 38.51211], [-122.35841, 38.5123], [-122.35863, 38.51248], [-122.35887, 38.51257], [-122.35901, 38.51261], [-122.35925, 38.51273], [-122.3595, 38.51293], [-122.35991, 38.51319], [-122.36007, 38.51342], [-122.36032, 38.51372], [-122.36046, 38.51393], [-122.36061, 38.51406], [-122.36089, 38.51428], [-122.36107, 38.51437], [-122.36147, 38.51466], [-122.36184, 38.51489], [-122.36213, 38.51502], [-122.36247, 38.5153], [-122.36268, 38.51553], [-122.36279, 38.51562], [-122.36291, 38.51567], [-122.36308, 38.51579], [-122.36346, 38.51622], [-122.36367, 38.5165], [-122.3638, 38.51661], [-122.36396, 38.5167], [-122.36409, 38.5168], [-122.36427, 38.51706], [-122.36446, 38.5173], [-122.36463, 38.51757], [-122.36478, 38.51789], [-122.36493, 38.51813], [-122.36513, 38.51834], [-122.36531, 38.51848], [-122.36542, 38.5186], [-122.3657, 38.51884], [-122.36598, 38.51903], [-122.36637, 38.5194], [-122.36647, 38.51963], [-122.36647, 38.5197], [-122.36655, 38.5198], [-122.36672, 38.51998], [-122.36716, 38.5203], [-122.36733, 38.52047], [-122.36748, 38.52072], [-122.36761, 38.52103], [-122.3677, 38.52118], [-122.36794, 38.52138], [-122.36816, 38.52153], [-122.36827, 38.52167], [-122.36847, 38.52183], [-122.36855, 38.52203], [-122.36861, 38.52212], [-122.36886, 38.52227], [-122.36892, 38.52234], [-122.36896, 38.52243], [-122.36924, 38.52268], [-122.37396, 38.5227], [-122.37462, 38.52366], [-122.37522, 38.52405], [-122.37547, 38.52434], [-122.37548, 38.52461], [-122.37534, 38.52467], [-122.37517, 38.52492], [-122.37511, 38.52525], [-122.37521, 38.52551], [-122.37552, 38.52577], [-122.37597, 38.52605], [-122.3767, 38.52629], [-122.37702, 38.52654], [-122.3773, 38.52679], [-122.37757, 38.52694], [-122.37787, 38.52696], [-122.37812, 38.52691], [-122.37841, 38.52691], [-122.37863, 38.52697], [-122.37883, 38.52697], [-122.37925, 38.52689], [-122.37954, 38.52679]]]}	No Public Access 3	24947	Moore Creek Wilderness Park	22459	2268	Napa County Regional Park and Open Space District 362	Special District 4	Recreation/Parks District 4	http://napaoutdoors.org/	Special District 4	2268	Napa County Regional Park and Open Space District 108	Special District 4	Recreation/Parks District 4	Napa 11	717.953	Moore Creek Wilderness Park	Local Conservation Area 4	2
7802	7802	7801	{"type": "Polygon", "coordinates": [[[-122.23302, 38.23444], [-122.22473, 38.23495], [-122.22472, 38.2385], [-122.22301, 38.23789], [-122.22249, 38.23785], [-122.22244, 38.23808], [-122.22103, 38.23794], [-122.22104, 38.23774], [-122.21889, 38.23751], [-122.21854, 38.23663], [-122.21725, 38.23663], [-122.21747, 38.23776], [-122.21783, 38.23793], [-122.2181, 38.23813], [-122.21801, 38.23828], [-122.21814, 38.23842], [-122.218, 38.23846], [-122.21825, 38.23871], [-122.21804, 38.23877], [-122.21718, 38.23894], [-122.21686, 38.2391], [-122.21605, 38.23966], [-122.21593, 38.23976], [-122.21586, 38.23986], [-122.21527, 38.23979], [-122.21505, 38.24], [-122.21506, 38.24011], [-122.21554, 38.24033], [-122.21525, 38.24068], [-122.21519, 38.24085], [-122.21532, 38.24101], [-122.21567, 38.2411], [-122.21583, 38.24122], [-122.216, 38.24152], [-122.21604, 38.24172], [-122.21582, 38.2421], [-122.21638, 38.24252], [-122.21645, 38.24266], [-122.21683, 38.24294], [-122.21684, 38.24323], [-122.21911, 38.24384], [-122.22215, 38.24284], [-122.22559, 38.24302], [-122.22664, 38.24305], [-122.22869, 38.24297], [-122.22911, 38.2429], [-122.22996, 38.24319], [-122.23067, 38.24333], [-122.23094, 38.24343], [-122.23094, 38.2436], [-122.23062, 38.24461], [-122.23024, 38.24536], [-122.22976, 38.24612], [-122.22941, 38.24631], [-122.22467, 38.24747], [-122.22482, 38.24825], [-122.22452, 38.24835], [-122.22408, 38.24925], [-122.22489, 38.25021], [-122.22476, 38.25048], [-122.22304, 38.2527], [-122.22038, 38.25284], [-122.22022, 38.25141], [-122.21965, 38.25116], [-122.21813, 38.25139], [-122.21792, 38.2521], [-122.21831, 38.25257], [-122.21749, 38.25377], [-122.21768, 38.25501], [-122.21668, 38.25515], [-122.21607, 38.25493], [-122.21522, 38.25486], [-122.21355, 38.25427], [-122.21354, 38.25119], [-122.20989, 38.25119], [-122.2099, 38.24916], [-122.20859, 38.24823], [-122.20828, 38.2481], [-122.20819, 38.24804], [-122.20813, 38.24796], [-122.20808, 38.24787], [-122.20807, 38.24777], [-122.20758, 38.24574], [-122.20472, 38.2453], [-122.20419, 38.24387], [-122.2098, 38.24385], [-122.20966, 38.23501], [-122.21005, 38.23498], [-122.21061, 38.23476], [-122.21084, 38.23471], [-122.21144, 38.23474], [-122.21189, 38.2347], [-122.21246, 38.23484], [-122.21259, 38.23497], [-122.21274, 38.23506], [-122.21291, 38.23507], [-122.21303, 38.23505], [-122.21311, 38.23507], [-122.21319, 38.23512], [-122.21332, 38.23515], [-122.2138, 38.23538], [-122.21407, 38.23549], [-122.21421, 38.23546], [-122.21436, 38.23538], [-122.21462, 38.23528], [-122.21462, 38.23542], [-122.21514, 38.23578], [-122.21689, 38.23472], [-122.21689, 38.23454], [-122.21717, 38.23419], [-122.21735, 38.23392], [-122.21759, 38.23368], [-122.21796, 38.23346], [-122.21818, 38.23329], [-122.21844, 38.2332], [-122.21881, 38.23316], [-122.21896, 38.23312], [-122.21943, 38.23305], [-122.21974, 38.23293], [-122.21995, 38.23272], [-122.22006, 38.23264], [-122.2203, 38.23222], [-122.2204, 38.23197], [-122.22045, 38.2319], [-122.22072, 38.2316], [-122.22091, 38.2315], [-122.22109, 38.23133], [-122.22123, 38.2309], [-122.22133, 38.23029], [-122.22137, 38.23026], [-122.22632, 38.23028], [-122.22559, 38.23174], [-122.22506, 38.2333], [-122.22763, 38.234], [-122.22771, 38.23329], [-122.22877, 38.23166], [-122.23193, 38.23165], [-122.23302, 38.23444]]]}	No Public Access 3	47675	Suscol Headwaters Preserve	31417	2268	Napa County Regional Park and Open Space District 362	Special District 4	Recreation/Parks District 4	http://napaoutdoors.org/	Special District 4	2268	Napa County Regional Park and Open Space District 108	Special District 4	Recreation/Parks District 4	Napa 11	712.089	Suscol Headwaters Preserve	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]);