units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Agate Beach" and MNG_AG_TYP = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2482 | 2482 | 2481 | {"type": "MultiPolygon", "coordinates": [[[[-122.71352, 37.90015], [-122.71308, 37.9004], [-122.71226, 37.89978], [-122.71205, 37.89957], [-122.71194, 37.89942], [-122.7113, 37.8982], [-122.71119, 37.89809], [-122.71104, 37.89801], [-122.71091, 37.89799], [-122.71077, 37.89799], [-122.7106, 37.89803], [-122.71049, 37.89808], [-122.71041, 37.89816], [-122.71024, 37.8984], [-122.71022, 37.89851], [-122.71026, 37.89864], [-122.70994, 37.89875], [-122.71006, 37.89899], [-122.71012, 37.89919], [-122.71009, 37.8992], [-122.71, 37.89905], [-122.70983, 37.89892], [-122.70962, 37.89883], [-122.70944, 37.8988], [-122.70946, 37.89864], [-122.70969, 37.89854], [-122.70981, 37.89846], [-122.70995, 37.89832], [-122.71007, 37.89814], [-122.71013, 37.89793], [-122.71013, 37.89779], [-122.71011, 37.89765], [-122.71005, 37.89751], [-122.70991, 37.89733], [-122.70955, 37.89753], [-122.70938, 37.89742], [-122.70905, 37.89729], [-122.70883, 37.89717], [-122.70862, 37.89699], [-122.70807, 37.89619], [-122.70791, 37.89605], [-122.70774, 37.89593], [-122.70819, 37.89543], [-122.70925, 37.89589], [-122.71022, 37.89622], [-122.71056, 37.89674], [-122.71082, 37.89717], [-122.71098, 37.89748], [-122.71124, 37.89769], [-122.71126, 37.89779], [-122.71136, 37.89796], [-122.71136, 37.89802], [-122.71147, 37.89821], [-122.71194, 37.89883], [-122.71208, 37.89908], [-122.71235, 37.89934], [-122.71258, 37.89954], [-122.71285, 37.89969], [-122.71345, 37.90008], [-122.71352, 37.90015]]], [[[-122.71035, 37.90018], [-122.71029, 37.90026], [-122.71004, 37.90051], [-122.70995, 37.90066], [-122.70992, 37.90061], [-122.70991, 37.90044], [-122.70986, 37.9003], [-122.7098, 37.90028], [-122.71004, 37.8995], [-122.71008, 37.89957], [-122.71007, 37.89976], [-122.70999, 37.90011], [-122.71003, 37.90026], [-122.71035, 37.90018]]]]} | Open Access 1 | 17481 | Agate Beach | 15284 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 13.699 | Agate Beach | 0 | 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]);