calands: units_with_maps: 5 rows where DES_TP = 2, MNG_AGENCY = 428 and YR

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

5 rows where DES_TP = 2, MNG_AGENCY = 428 and YR_EST = 0

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
1860	1860	1859	{"type": "Polygon", "coordinates": [[[-122.25881, 38.16563], [-122.25708, 38.16557], [-122.25695, 38.16477], [-122.25719, 38.16478], [-122.25771, 38.16491], [-122.25778, 38.16488], [-122.25793, 38.16467], [-122.25798, 38.16468], [-122.25862, 38.16504], [-122.25843, 38.16526], [-122.25881, 38.16563]]]}	Open Access 1	14200	Northampton Park	22865	1005	American Canyon, City of 434	City 2	City Agency 2	http://cityofamericancanyon.org/city-departments/parks-recreation	City 2	1005	American Canyon, City of 428	City 2	City Agency 2	Napa 11	2.9	Northampton Park	Local Park 2	4
8535	8535	8534	{"type": "MultiPolygon", "coordinates": [[[[-122.26479, 38.15542], [-122.26477, 38.15543], [-122.26472, 38.16056], [-122.26232, 38.16079], [-122.26209, 38.16108], [-122.26201, 38.16106], [-122.26202, 38.16082], [-122.2616, 38.16088], [-122.26148, 38.16121], [-122.26164, 38.16149], [-122.26183, 38.16156], [-122.26204, 38.16188], [-122.26173, 38.16192], [-122.26173, 38.16174], [-122.26152, 38.16152], [-122.26146, 38.16132], [-122.26122, 38.16131], [-122.26114, 38.16137], [-122.26104, 38.16132], [-122.26093, 38.16133], [-122.26087, 38.16122], [-122.26066, 38.16125], [-122.26044, 38.16134], [-122.2605, 38.16165], [-122.26027, 38.16173], [-122.26027, 38.1606], [-122.26068, 38.16062], [-122.26068, 38.15862], [-122.26228, 38.15844], [-122.2636, 38.15841], [-122.2636, 38.15877], [-122.26386, 38.15894], [-122.26447, 38.15892], [-122.26462, 38.15867], [-122.26466, 38.15538], [-122.26479, 38.15538], [-122.26479, 38.15542]]], [[[-122.26005, 38.16085], [-122.26004, 38.16086], [-122.26002, 38.1619], [-122.25998, 38.16193], [-122.25982, 38.16197], [-122.25968, 38.16202], [-122.25949, 38.16215], [-122.25948, 38.16197], [-122.25919, 38.16194], [-122.25919, 38.16188], [-122.25915, 38.16183], [-122.2591, 38.1618], [-122.25903, 38.16178], [-122.25894, 38.1618], [-122.25887, 38.16185], [-122.25872, 38.16178], [-122.25856, 38.16177], [-122.25834, 38.16182], [-122.25821, 38.16189], [-122.25818, 38.16196], [-122.25807, 38.16197], [-122.25798, 38.16202], [-122.25785, 38.16195], [-122.25748, 38.16197], [-122.25615, 38.16194], [-122.25619, 38.16129], [-122.25767, 38.1613], [-122.25861, 38.16121], [-122.2596, 38.16103], [-122.2598, 38.16092], [-122.25989, 38.1608], [-122.26001, 38.1608], [-122.26004, 38.16082], [-122.26005, 38.16085]]], [[[-122.25595, 38.16129], [-122.25592, 38.1614], [-122.25591, 38.16211], [-122.25546, 38.162], [-122.25522, 38.16205], [-122.25514, 38.16217], [-122.25503, 38.16215], [-122.25493, 38.16219], [-122.25489, 38.16225], [-122.25488, 38.1623], [-122.2549, 38.16235], [-122.25496, 38.16243], [-122.25477, 38.16243], [-122.25469, 38.16248], [-122.25446, 38.16273], [-122.25445, 38.16285], [-122.25438, 38.16286], [-122.25432, 38.16289], [-122.25429, 38.16293], [-122.25427, 38.16299], [-122.25415, 38.16299], [-122.25382, 38.16331], [-122.25366, 38.16341], [-122.25366, 38.16359], [-122.25359, 38.16356], [-122.25352, 38.16355], [-122.25345, 38.16357], [-122.25339, 38.16361], [-122.25337, 38.16367], [-122.25337, 38.16372], [-122.2534, 38.16377], [-122.25345, 38.16381], [-122.25343, 38.16408], [-122.25318, 38.16407], [-122.25339, 38.16132], [-122.25397, 38.16134], [-122.25399, 38.16127], [-122.25595, 38.16129]]]]}	Open Access 1	13421	Kimberly Park	20648	1005	American Canyon, City of 434	City 2	City Agency 2	http://cityofamericancanyon.org/city-departments/parks-recreation	City 2	1005	American Canyon, City of 428	City 2	City Agency 2	Napa 11	39.792	Kimberly Park	Local Park 2	4
8745	8745	8744	{"type": "Polygon", "coordinates": [[[-122.26381, 38.16293], [-122.26252, 38.16345], [-122.26264, 38.16365], [-122.26255, 38.1637], [-122.26252, 38.16376], [-122.26253, 38.16382], [-122.26259, 38.16389], [-122.26266, 38.16391], [-122.26266, 38.1641], [-122.26273, 38.16422], [-122.26319, 38.16423], [-122.26317, 38.16429], [-122.26289, 38.16436], [-122.26289, 38.16451], [-122.26264, 38.16468], [-122.26261, 38.16464], [-122.26264, 38.16454], [-122.26258, 38.1643], [-122.26259, 38.16413], [-122.26236, 38.16404], [-122.26238, 38.164], [-122.26237, 38.16393], [-122.26233, 38.16387], [-122.26228, 38.16385], [-122.26231, 38.16364], [-122.2622, 38.1636], [-122.26122, 38.16399], [-122.26118, 38.16408], [-122.26112, 38.16399], [-122.26094, 38.16407], [-122.26094, 38.16408], [-122.261, 38.16415], [-122.26088, 38.16412], [-122.26026, 38.16437], [-122.26017, 38.16457], [-122.26029, 38.16463], [-122.26027, 38.16469], [-122.26028, 38.16473], [-122.26032, 38.16479], [-122.26024, 38.16484], [-122.26014, 38.16486], [-122.26011, 38.1648], [-122.26, 38.16474], [-122.26004, 38.16457], [-122.25984, 38.1645], [-122.25975, 38.16449], [-122.25901, 38.1648], [-122.25887, 38.16495], [-122.2584, 38.16471], [-122.25929, 38.16434], [-122.25919, 38.16431], [-122.2592, 38.16426], [-122.25912, 38.16413], [-122.25905, 38.1641], [-122.25907, 38.16402], [-122.25905, 38.16398], [-122.25897, 38.16392], [-122.25889, 38.1639], [-122.25871, 38.16368], [-122.2586, 38.1635], [-122.25868, 38.16346], [-122.25887, 38.16359], [-122.25902, 38.16376], [-122.25919, 38.16378], [-122.25919, 38.16383], [-122.25922, 38.16389], [-122.25936, 38.16395], [-122.25936, 38.16412], [-122.25945, 38.1642], [-122.26059, 38.16367], [-122.26063, 38.16358], [-122.26075, 38.16375], [-122.26092, 38.16368], [-122.26083, 38.1635], [-122.26095, 38.16353], [-122.26168, 38.16324], [-122.26202, 38.16317], [-122.26244, 38.163], [-122.26245, 38.16286], [-122.26218, 38.16277], [-122.2622, 38.16271], [-122.26217, 38.16264], [-122.26214, 38.1626], [-122.26203, 38.16257], [-122.26192, 38.1623], [-122.26187, 38.16206], [-122.26198, 38.16204], [-122.26204, 38.16223], [-122.26226, 38.1624], [-122.26245, 38.16248], [-122.26244, 38.16254], [-122.26246, 38.1626], [-122.26251, 38.16265], [-122.2625, 38.16279], [-122.26256, 38.16286], [-122.26269, 38.1629], [-122.26369, 38.16249], [-122.26373, 38.16254], [-122.26373, 38.16272], [-122.26381, 38.16293]]]}	Open Access 1	14202	Elliott Park	18590	1005	American Canyon, City of 434	City 2	City Agency 2	http://cityofamericancanyon.org/city-departments/parks-recreation	City 2	1005	American Canyon, City of 428	City 2	City Agency 2	Napa 11	8.099	Elliott Park	Local Park 2	4
8747	8747	8746	{"type": "Polygon", "coordinates": [[[-122.25601, 38.17428], [-122.25487, 38.17441], [-122.25486, 38.17432], [-122.25496, 38.17431], [-122.25493, 38.17412], [-122.25596, 38.17401], [-122.25601, 38.17428]]]}	Open Access 1	14209	Melvin Park	22114	1005	American Canyon, City of 434	City 2	City Agency 2	http://cityofamericancanyon.org/city-departments/parks-recreation	City 2	1005	American Canyon, City of 428	City 2	City Agency 2	Napa 11	0.72	Melvin Park	Local Park 2	4
10126	10126	10125	{"type": "Polygon", "coordinates": [[[-122.25487, 38.17441], [-122.25417, 38.17448], [-122.25406, 38.17387], [-122.2547, 38.1738], [-122.25475, 38.17413], [-122.25483, 38.17413], [-122.25487, 38.17441]]]}	Open Access 1	17596	Melvin Park	22114	1005	American Canyon, City of 434	City 2	City Agency 2	http://cityofamericancanyon.org/city-departments/parks-recreation	City 2	1005	American Canyon, City of 428	City 2	City Agency 2	Napa 11	1.001	Melvin Park	Local Park 2	4

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