calands: units_with_maps: 16 rows where AGNCY_NAME = 445, DES_TP = 2 and MNG_AG

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

16 rows where AGNCY_NAME = 445, DES_TP = 2 and MNG_AG_TYP = 2

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
1875	1875	1874	{"type": "Polygon", "coordinates": [[[-122.47958, 37.85038], [-122.47942, 37.85069], [-122.47929, 37.85087], [-122.4792, 37.85087], [-122.47929, 37.85065], [-122.47936, 37.85055], [-122.47945, 37.85045], [-122.47954, 37.85038], [-122.47958, 37.85038]]]}	Open Access 1	14407	Tiffany Beach	26358	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	0.14	Tiffany Beach	Local Park 2	4
2160	2160	2159	{"type": "Polygon", "coordinates": [[[-122.49486, 37.86031], [-122.49473, 37.86047], [-122.49416, 37.86015], [-122.49437, 37.8599], [-122.49444, 37.86005], [-122.49457, 37.86019], [-122.49476, 37.86028], [-122.49486, 37.86031]]]}	Open Access 1	16176	Langendorf Park	21014	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	0.328	Langendorf Park	Local Park 2	4
4270	4270	4269	{"type": "Polygon", "coordinates": [[[-122.48245, 37.85044], [-122.48245, 37.85076], [-122.48172, 37.85075], [-122.48171, 37.85044], [-122.48245, 37.85044]]]}	Open Access 1	14402	South View Park	25682	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	0.575	South View Park	Local Park 2	4
4273	4273	4272	{"type": "Polygon", "coordinates": [[[-122.47895, 37.85512], [-122.47854, 37.85515], [-122.47853, 37.85494], [-122.47888, 37.85494], [-122.47888, 37.855], [-122.47895, 37.85512]]]}	Open Access 1	14409	Yee Tock Chee Park	27767	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	0.175	Yee Tock Chee Park	Local Park 2	4
4274	4274	4273	{"type": "Polygon", "coordinates": [[[-122.4793, 37.85718], [-122.47893, 37.8577], [-122.47886, 37.85767], [-122.47871, 37.85685], [-122.4793, 37.85718]]]}	Open Access 1	14412	Gabrielson Park	19167	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	0.58	Gabrielson Park	Local Park 2	4
4284	4284	4283	{"type": "Polygon", "coordinates": [[[-122.48723, 37.85269], [-122.48677, 37.85288], [-122.48659, 37.85247], [-122.48723, 37.85269], [-122.48723, 37.85269]]]}	Open Access 1	14415	Cloud View Park	17433	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	0.269	Cloud View Park	Local Park 2	4
4285	4285	4284	{"type": "Polygon", "coordinates": [[[-122.48908, 37.86001], [-122.4888, 37.86035], [-122.48811, 37.85999], [-122.4884, 37.85964], [-122.48908, 37.86001]]]}	Open Access 1	14418	Robin Sweeny Park	24500	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	0.823	Robin Sweeny Park	Local Park 2	4
4286	4286	4285	{"type": "MultiPolygon", "coordinates": [[[[-122.48822, 37.861], [-122.4879, 37.86139], [-122.48721, 37.86102], [-122.4875, 37.86067], [-122.48822, 37.861]]], [[[-122.48912, 37.86142], [-122.48876, 37.86184], [-122.48807, 37.86149], [-122.4884, 37.86109], [-122.48912, 37.86142]]]]}	Open Access 1	14421	Dunphy Park	18306	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	1.863	Dunphy Park	Local Park 2	4
4287	4287	4286	{"type": "Polygon", "coordinates": [[[-122.49695, 37.86442], [-122.49593, 37.86523], [-122.49525, 37.86468], [-122.49623, 37.86391], [-122.49631, 37.8639], [-122.49695, 37.86442]]]}	Open Access 1	14424	Marinship Park	21861	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	2.671	Marinship Park	Local Park 2	4
4289	4289	4288	{"type": "Polygon", "coordinates": [[[-122.50566, 37.8674], [-122.50507, 37.86779], [-122.50533, 37.86806], [-122.50536, 37.86886], [-122.50532, 37.86901], [-122.50522, 37.86905], [-122.50517, 37.8691], [-122.50515, 37.86915], [-122.50515, 37.86932], [-122.50487, 37.8696], [-122.50501, 37.86977], [-122.50501, 37.86986], [-122.50492, 37.86988], [-122.50388, 37.87055], [-122.5039, 37.86953], [-122.50387, 37.86937], [-122.50381, 37.86913], [-122.50374, 37.86897], [-122.50358, 37.86871], [-122.50336, 37.86846], [-122.50307, 37.86819], [-122.50508, 37.86686], [-122.50566, 37.8674]]]}	Open Access 1	14427	Martin Luther King Jr. Park	21915	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	11.082	Martin Luther King Jr. Park	Local Park 2	4
9601	9601	9600	{"type": "MultiPolygon", "coordinates": [[[[-122.47946, 37.84735], [-122.47946, 37.84789], [-122.47923, 37.84789], [-122.47923, 37.84733], [-122.47946, 37.84735]]], [[[-122.47987, 37.84761], [-122.47987, 37.84789], [-122.4798, 37.84789], [-122.47981, 37.84756], [-122.47987, 37.84761]]]]}	Open Access 1	16189	Swedes Beach	26100	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	0.35	Swedes Beach	Local Park 2	4
9615	9615	9614	{"type": "Polygon", "coordinates": [[[-122.48317, 37.85696], [-122.48316, 37.85713], [-122.48285, 37.8571], [-122.48289, 37.8569], [-122.48317, 37.85696]]]}	Open Access 1	16185	Mary Ann Sears Park	30873	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	0.129	Mary Ann Sears Park	Local Park 2	4
9616	9616	9615	{"type": "Polygon", "coordinates": [[[-122.47966, 37.85632], [-122.47962, 37.85637], [-122.47953, 37.85635], [-122.47905, 37.85608], [-122.47902, 37.85604], [-122.47903, 37.856], [-122.47909, 37.85595], [-122.47939, 37.85595], [-122.47966, 37.85632]]]}	Open Access 1	16187	Island Park	20281	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	0.317	Island Park	Local Park 2	4
11311	11311	11310	{"type": "Polygon", "coordinates": [[[-122.4799, 37.85052], [-122.47985, 37.85072], [-122.47979, 37.85078], [-122.47976, 37.85088], [-122.47942, 37.85088], [-122.47965, 37.85052], [-122.4799, 37.85052]]]}	Open Access 1	22027	Tiffany Park	26360	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	0.271	Tiffany Park	Local Park 2	4
14040	14040	14039	{"type": "Polygon", "coordinates": [[[-122.48999, 37.86387], [-122.48986, 37.86398], [-122.48869, 37.86367], [-122.48898, 37.86332], [-122.48946, 37.86358], [-122.48985, 37.86351], [-122.48992, 37.86375], [-122.48999, 37.86387]]]}	Open Access 1	38054	Schoonmaker Beach	25192	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	0.992	Schoonmaker Beach	Local Park 2	4
14052	14052	14051	{"type": "Polygon", "coordinates": [[[-122.48777, 37.85715], [-122.48774, 37.85721], [-122.48754, 37.8571], [-122.48753, 37.85703], [-122.48777, 37.85715]]]}	Open Access 1	38053	Cazneau Park	16987	1327	Sausalito, City of 445	City 2	City Agency 2	http://www.ci.sausalito.ca.us/index.aspx?page=156	City 2	1327	Sausalito, City of 439	City 2	City Agency 2	Marin 23	0.04	Cazneau 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]);