units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
16 rows where COUNTY = 23, DES_TP = 2 and MNG_AGENCY = 439
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 16
MNG_AGENCY 1
- Sausalito, City of · 16 ✖
DES_TP 1
- Local Park · 16 ✖
ACCESS_TYP 1
- Open Access 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 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]);