units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
19 rows where COUNTY = 23 and MNG_AGENCY = 439
This data as json, copyable, CSV (advanced)
DES_TP 4
- Local Park 16
- Local Recreation Area 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 19
MNG_AGENCY 1
- Sausalito, City of · 19 ✖
ACCESS_TYP 1
- Open Access 19
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 | |
9592 | 9592 | 9591 | {"type": "Polygon", "coordinates": [[[-122.4989, 37.86411], [-122.49887, 37.86427], [-122.49881, 37.86443], [-122.49867, 37.86425], [-122.49868, 37.86412], [-122.49872, 37.86402], [-122.4989, 37.86411]]]} | Open Access 1 | 16178 | Sausalito Land 006 | 25173 | 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.143 | Sausalito Land 006 | None 807 | |||
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 | |
9609 | 9609 | 9608 | {"type": "Polygon", "coordinates": [[[-122.48622, 37.84764], [-122.48563, 37.84802], [-122.48546, 37.84795], [-122.48537, 37.84786], [-122.486, 37.84758], [-122.48622, 37.84764]]]} | Open Access 1 | 16191 | Sausalito Land 004 | 25172 | 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.37 | Sausalito Land 004 | None 815 | |||
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 | |
16123 | 16123 | 16122 | {"type": "MultiPolygon", "coordinates": [[[[-122.50006, 37.85954], [-122.49996, 37.86048], [-122.49971, 37.86081], [-122.49955, 37.86094], [-122.49954, 37.86123], [-122.49948, 37.86134], [-122.49947, 37.86149], [-122.49951, 37.86164], [-122.49952, 37.86176], [-122.49947, 37.86186], [-122.49938, 37.86197], [-122.4993, 37.86213], [-122.49931, 37.86227], [-122.49935, 37.8624], [-122.4993, 37.8625], [-122.4992, 37.86256], [-122.49876, 37.86272], [-122.49863, 37.86273], [-122.49852, 37.8627], [-122.49859, 37.86214], [-122.49836, 37.86202], [-122.49782, 37.86157], [-122.49774, 37.86149], [-122.49767, 37.86137], [-122.49765, 37.86123], [-122.49766, 37.86101], [-122.49781, 37.86029], [-122.49778, 37.86019], [-122.49769, 37.86012], [-122.49783, 37.85999], [-122.49816, 37.86016], [-122.49873, 37.85947], [-122.49817, 37.85917], [-122.4983, 37.85901], [-122.49822, 37.85882], [-122.49784, 37.85857], [-122.49792, 37.85848], [-122.49826, 37.85851], [-122.49854, 37.85865], [-122.49912, 37.85855], [-122.49947, 37.85859], [-122.49955, 37.85865], [-122.49962, 37.85874], [-122.49952, 37.85893], [-122.50006, 37.85954]], [[-122.49924, 37.86159], [-122.49915, 37.86153], [-122.49904, 37.8615], [-122.49893, 37.8615], [-122.49882, 37.86152], [-122.49875, 37.86157], [-122.49869, 37.86164], [-122.49866, 37.86172], [-122.49867, 37.86181], [-122.49873, 37.86191], [-122.49884, 37.86198], [-122.49898, 37.86201], [-122.49912, 37.86199], [-122.49923, 37.86192], [-122.4993, 37.86182], [-122.49931, 37.86171], [-122.49928, 37.86165], [-122.49924, 37.86159]]], [[[-122.50046, 37.86184], [-122.50012, 37.86222], [-122.4999, 37.86209], [-122.49995, 37.86202], [-122.49994, 37.86201], [-122.49967, 37.86218], [-122.4995, 37.86224], [-122.49949, 37.86215], [-122.49954, 37.86205], [-122.49963, 37.86192], [-122.49969, 37.86177], [-122.49968, 37.86167], [-122.5, 37.86196], [-122.50022, 37.86187], [-122.50046, 37.86184]]], [[[-122.50069, 37.86158], [-122.50067, 37.86164], [-122.50031, 37.86166], [-122.50044, 37.86153], [-122.50061, 37.86153], [-122.50066, 37.86155], [-122.50069, 37.86158]]], [[[-122.50086, 37.86141], [-122.50081, 37.86146], [-122.50054, 37.8614], [-122.50066, 37.86127], [-122.50086, 37.86141]]]]} | Open Access 1 | 16174 | Cypress Ridge Open Space | 17884 | 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 | 15.372 | Cypress Ridge OS | 0 | Local Recreation Area 3 | 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]);