calands: units_with_maps: 1 row where ACCESS_TYP = 1 and DES

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

1 row where ACCESS_TYP = 1 and DES_TP = 858

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
9882	9882	9881	{"type": "MultiPolygon", "coordinates": [[[[-122.38423, 38.49037], [-122.38351, 38.49016], [-122.38261, 38.48945], [-122.38255, 38.4892], [-122.38301, 38.48884], [-122.38299, 38.48859], [-122.38226, 38.48817], [-122.38179, 38.48776], [-122.38174, 38.48748], [-122.38092, 38.48655], [-122.38069, 38.48618], [-122.37943, 38.48583], [-122.37323, 38.483], [-122.37285, 38.4827], [-122.37282, 38.48225], [-122.37317, 38.4819], [-122.37306, 38.48094], [-122.37201, 38.48069], [-122.37163, 38.48027], [-122.3716, 38.47924], [-122.37108, 38.47975], [-122.37093, 38.47998], [-122.3709, 38.48068], [-122.37064, 38.48124], [-122.37009, 38.4816], [-122.36936, 38.48169], [-122.36817, 38.4816], [-122.36668, 38.48119], [-122.3663, 38.48119], [-122.36562, 38.48153], [-122.36562, 38.48106], [-122.36576, 38.481], [-122.36606, 38.48074], [-122.36642, 38.48057], [-122.36654, 38.48058], [-122.36665, 38.48055], [-122.36698, 38.48061], [-122.36761, 38.48078], [-122.3682, 38.48097], [-122.36843, 38.48108], [-122.36871, 38.48114], [-122.36889, 38.48116], [-122.37003, 38.4811], [-122.37043, 38.48086], [-122.37072, 38.4803], [-122.37089, 38.47965], [-122.37094, 38.4796], [-122.37123, 38.47912], [-122.37125, 38.47904], [-122.37124, 38.47903], [-122.37085, 38.47956], [-122.3708, 38.47963], [-122.37063, 38.48029], [-122.37035, 38.48082], [-122.36999, 38.48103], [-122.3689, 38.48109], [-122.36873, 38.48107], [-122.36847, 38.48101], [-122.36824, 38.48091], [-122.36764, 38.48071], [-122.367, 38.48054], [-122.36665, 38.48048], [-122.36653, 38.48051], [-122.3664, 38.4805], [-122.36617, 38.4806], [-122.366, 38.48069], [-122.36571, 38.48094], [-122.36561, 38.48099], [-122.36499, 38.48146], [-122.36444, 38.48175], [-122.36372, 38.48186], [-122.36335, 38.48162], [-122.36294, 38.48154], [-122.36166, 38.4819], [-122.36151, 38.4819], [-122.36116, 38.48178], [-122.36101, 38.48179], [-122.36082, 38.48183], [-122.36052, 38.4817], [-122.35947, 38.48167], [-122.35906, 38.48208], [-122.3587, 38.48252], [-122.35813, 38.48302], [-122.3573, 38.48333], [-122.35636, 38.48281], [-122.35617, 38.48278], [-122.35596, 38.48277], [-122.35576, 38.48281], [-122.3556, 38.48289], [-122.3555, 38.48298], [-122.35535, 38.48333], [-122.35531, 38.48375], [-122.35532, 38.48397], [-122.35529, 38.48413], [-122.35519, 38.48434], [-122.35505, 38.48478], [-122.35507, 38.48501], [-122.35505, 38.48505], [-122.35497, 38.48511], [-122.35418, 38.48543], [-122.35382, 38.48565], [-122.35368, 38.48578], [-122.3536, 38.48594], [-122.35357, 38.48621], [-122.35337, 38.48668], [-122.35324, 38.48717], [-122.35317, 38.4873], [-122.35302, 38.48739], [-122.35283, 38.48744], [-122.35217, 38.48757], [-122.35169, 38.48767], [-122.35122, 38.4878], [-122.35052, 38.48806], [-122.34988, 38.48824], [-122.34922, 38.48846], [-122.34907, 38.48853], [-122.34893, 38.48865], [-122.34884, 38.48881], [-122.3488, 38.48907], [-122.34722, 38.48934], [-122.3465, 38.48958], [-122.34615, 38.49002], [-122.34603, 38.49032], [-122.34571, 38.49062], [-122.34479, 38.491], [-122.34479, 38.49101], [-122.34513, 38.49128], [-122.34568, 38.49121], [-122.34693, 38.49041], [-122.34737, 38.4902], [-122.34775, 38.49014], [-122.34853, 38.49016], [-122.34866, 38.4902], [-122.34865, 38.49022], [-122.3485, 38.49031], [-122.34821, 38.49036], [-122.34727, 38.49047], [-122.34709, 38.49056], [-122.34673, 38.49096], [-122.34654, 38.49115], [-122.34629, 38.4913], [-122.34607, 38.49138], [-122.3457, 38.49145], [-122.34464, 38.49155], [-122.34386, 38.49169], [-122.34363, 38.49176], [-122.34338, 38.49188], [-122.34321, 38.49202], [-122.34294, 38.4922], [-122.34279, 38.49234], [-122.34251, 38.49243], [-122.34205, 38.49254], [-122.34105, 38.49236], [-122.34017, 38.49196], [-122.33978, 38.49185], [-122.33871, 38.49206], [-122.33772, 38.49243], [-122.33691, 38.49239], [-122.33621, 38.49222], [-122.33567, 38.4919], [-122.33498, 38.49142], [-122.33513, 38.49125], [-122.33544, 38.49133], [-122.33622, 38.49178], [-122.33677, 38.4918], [-122.33725, 38.49171], [-122.33786, 38.49149], [-122.33897, 38.49123], [-122.33959, 38.49098], [-122.34016, 38.4906], [-122.34036, 38.49033], [-122.34071, 38.49074], [-122.34116, 38.49095], [-122.34151, 38.49123], [-122.34169, 38.49132], [-122.34211, 38.49111], [-122.34247, 38.49082], [-122.34245, 38.48999], [-122.34247, 38.48637], [-122.34894, 38.48647], [-122.34895, 38.4864], [-122.35071, 38.48642], [-122.35072, 38.48655], [-122.35183, 38.48663], [-122.35184, 38.48609], [-122.35174, 38.48608], [-122.35178, 38.48286], [-122.34721, 38.48282], [-122.34726, 38.47921], [-122.34706, 38.47581], [-122.35164, 38.47568], [-122.35146, 38.47217], [-122.35611, 38.47193], [-122.35641, 38.4792], [-122.37084, 38.47956], [-122.37085, 38.47955], [-122.37085, 38.4782], [-122.37619, 38.47836], [-122.37617, 38.47968], [-122.38396, 38.47979], [-122.3841, 38.48447], [-122.38401, 38.48443], [-122.3839, 38.48434], [-122.3836, 38.48416], [-122.38322, 38.4839], [-122.38274, 38.48349], [-122.38211, 38.48307], [-122.38189, 38.48289], [-122.38181, 38.48278], [-122.38176, 38.48273], [-122.3815, 38.48257], [-122.38074, 38.4823], [-122.3805, 38.48218], [-122.38021, 38.48206], [-122.3797, 38.48189], [-122.37932, 38.48173], [-122.37883, 38.48155], [-122.37809, 38.48121], [-122.37765, 38.48105], [-122.37709, 38.48075], [-122.3764, 38.4805], [-122.37604, 38.48033], [-122.3758, 38.48024], [-122.37507, 38.48011], [-122.37466, 38.48009], [-122.37441, 38.48009], [-122.37341, 38.48022], [-122.37304, 38.48023], [-122.37288, 38.48023], [-122.37258, 38.48017], [-122.37235, 38.48009], [-122.37216, 38.47995], [-122.37212, 38.47988], [-122.37211, 38.47982], [-122.37217, 38.47963], [-122.37216, 38.47959], [-122.37216, 38.47917], [-122.37203, 38.47902], [-122.37202, 38.47902], [-122.37206, 38.47918], [-122.37207, 38.4796], [-122.37201, 38.47984], [-122.37202, 38.47996], [-122.37215, 38.48014], [-122.37233, 38.48025], [-122.37248, 38.4803], [-122.37267, 38.48034], [-122.37298, 38.48035], [-122.37367, 38.48031], [-122.37425, 38.48021], [-122.37503, 38.48022], [-122.3756, 38.48032], [-122.37622, 38.48052], [-122.37647, 38.48064], [-122.37677, 38.48074], [-122.37736, 38.48099], [-122.3776, 38.48114], [-122.3778, 38.48122], [-122.378, 38.48128], [-122.37883, 38.48166], [-122.37945, 38.48189], [-122.37971, 38.482], [-122.38007, 38.48211], [-122.3806, 38.48235], [-122.38116, 38.48255], [-122.38162, 38.48276], [-122.38171, 38.48282], [-122.38185, 38.48299], [-122.38219, 38.48325], [-122.38244, 38.48339], [-122.38259, 38.48352], [-122.38278, 38.48365], [-122.38311, 38.48385], [-122.38329, 38.48401], [-122.3841, 38.4846], [-122.38423, 38.49037]]], [[[-122.37226, 38.49405], [-122.35636, 38.49396], [-122.35629, 38.49028], [-122.36676, 38.49036], [-122.36709, 38.49094], [-122.36744, 38.49138], [-122.36752, 38.49165], [-122.36744, 38.49263], [-122.36758, 38.49291], [-122.36784, 38.49357], [-122.36997, 38.49348], [-122.3714, 38.49371], [-122.37207, 38.49394], [-122.37226, 38.49405]]], [[[-122.39624, 38.50548], [-122.39563, 38.5056], [-122.39509, 38.50553], [-122.3947, 38.50535], [-122.39455, 38.50515], [-122.39431, 38.5053], [-122.39365, 38.50473], [-122.3933, 38.50458], [-122.39222, 38.50425], [-122.39197, 38.50411], [-122.39134, 38.50398], [-122.39069, 38.50347], [-122.39021, 38.50267], [-122.38984, 38.50245], [-122.38927, 38.50242], [-122.38865, 38.50227], [-122.38788, 38.50123], [-122.38782, 38.50119], [-122.3878, 38.50113], [-122.38783, 38.50099], [-122.38769, 38.50079], [-122.38739, 38.50054], [-122.38658, 38.50049], [-122.38609, 38.50018], [-122.38587, 38.49991], [-122.38508, 38.49782], [-122.38475, 38.49729], [-122.38446, 38.49674], [-122.38426, 38.49614], [-122.38423, 38.49601], [-122.3839, 38.49534], [-122.38382, 38.49523], [-122.38387, 38.49499], [-122.38418, 38.49454], [-122.38451, 38.49413], [-122.3845, 38.49412], [-122.38391, 38.49412], [-122.38447, 38.49332], [-122.38477, 38.49305], [-122.38526, 38.49284], [-122.38561, 38.4925], [-122.38642, 38.49229], [-122.38642, 38.49174], [-122.38645, 38.49145], [-122.38622, 38.49115], [-122.38593, 38.49097], [-122.385, 38.4906], [-122.38479, 38.49054], [-122.38886, 38.49057], [-122.38896, 38.49414], [-122.39329, 38.49416], [-122.39327, 38.49607], [-122.39331, 38.49752], [-122.3933, 38.49769], [-122.39358, 38.4977], [-122.39354, 38.5038], [-122.39441, 38.50402], [-122.39466, 38.50447], [-122.3952, 38.50491], [-122.39557, 38.5053], [-122.39624, 38.50548]]]]}	Open Access 1	16918	Lake Hennessey	28927	1397	Napa, City of 447	City 2	City Agency 2	http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63	City 2	1397	Napa, City of 441	City 2	City Agency 2	http://www.cityofnapa.org/index.php?option=com_content&view=article&id=1331&Itemid=827	Napa 11	887.518	Lake Hennessey	0	None 858

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