units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where MNG_AGENCY = 477 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
DES_TP 3
MNG_AG_TYP 1
- City Agency 10
MNG_AGENCY 1
- Tiburon, Town of · 10 ✖
ACCESS_TYP 1
- Open Access 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9545 | 9545 | 9544 | {"type": "Polygon", "coordinates": [[[-122.46118, 37.87759], [-122.45971, 37.87832], [-122.45958, 37.87819], [-122.45957, 37.87799], [-122.45885, 37.87784], [-122.45815, 37.87728], [-122.45822, 37.87699], [-122.45809, 37.87672], [-122.45816, 37.87668], [-122.45819, 37.87673], [-122.45856, 37.87686], [-122.45859, 37.87692], [-122.45916, 37.87712], [-122.45932, 37.87708], [-122.45968, 37.87719], [-122.45991, 37.87676], [-122.46026, 37.87689], [-122.46044, 37.87756], [-122.46109, 37.87757], [-122.46118, 37.87759]]]} | Open Access 1 | 16017 | Point Tiburon Marsh Open Space | 31727 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 5.403 | Point Tiburon Marsh OS | 0 | Local Recreation Area 3 | 4 | |
2148 | 2148 | 2147 | {"type": "Polygon", "coordinates": [[[-122.45562, 37.87341], [-122.4553, 37.87328], [-122.45521, 37.87326], [-122.45512, 37.87316], [-122.45502, 37.87312], [-122.45478, 37.87315], [-122.45449, 37.87308], [-122.45431, 37.87305], [-122.45404, 37.87304], [-122.45367, 37.87306], [-122.45342, 37.87306], [-122.45289, 37.873], [-122.45271, 37.87296], [-122.45245, 37.87285], [-122.45194, 37.87251], [-122.45148, 37.87227], [-122.45132, 37.87221], [-122.45115, 37.87218], [-122.45097, 37.87216], [-122.45081, 37.87217], [-122.45072, 37.87209], [-122.45083, 37.87205], [-122.45113, 37.87203], [-122.45149, 37.87219], [-122.45178, 37.87229], [-122.45235, 37.87243], [-122.4524, 37.87249], [-122.45241, 37.87261], [-122.45251, 37.87268], [-122.45275, 37.87272], [-122.45302, 37.87274], [-122.45325, 37.8728], [-122.45363, 37.87285], [-122.45414, 37.87291], [-122.45457, 37.87293], [-122.45485, 37.87296], [-122.45543, 37.87296], [-122.45562, 37.87341]]]} | Open Access 1 | 16015 | Point Tiburon Shoreline Park | 31724 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 2.267 | Point Tiburon Shoreline Park | 0 | Local Park 2 | 4 | |
11298 | 11298 | 11297 | {"type": "Polygon", "coordinates": [[[-122.45841, 37.87645], [-122.45823, 37.87652], [-122.45816, 37.87667], [-122.45809, 37.87672], [-122.4576, 37.87652], [-122.45715, 37.87631], [-122.45674, 37.87606], [-122.45731, 37.87592], [-122.45747, 37.87592], [-122.45757, 37.87595], [-122.45798, 37.87625], [-122.45807, 37.87628], [-122.45822, 37.87628], [-122.45833, 37.87639], [-122.45841, 37.87645]]]} | Open Access 1 | 22044 | Point Tiburon Tennis Courts | 31725 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 1.433 | Point Tiburon Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
2165 | 2165 | 2164 | {"type": "Polygon", "coordinates": [[[-122.46492, 37.8834], [-122.46484, 37.88369], [-122.4639, 37.88347], [-122.46345, 37.88363], [-122.46344, 37.88329], [-122.46354, 37.88316], [-122.46369, 37.88317], [-122.46398, 37.88297], [-122.46492, 37.8834]]]} | Open Access 1 | 16215 | Reed Park | 24257 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 1.451 | Reed Park | 0 | Local Park 2 | 4 | |
16026 | 16026 | 16025 | {"type": "Polygon", "coordinates": [[[-122.47243, 37.89254], [-122.47257, 37.89352], [-122.47254, 37.89366], [-122.47248, 37.89376], [-122.47239, 37.89385], [-122.47204, 37.89357], [-122.46989, 37.89271], [-122.46896, 37.89222], [-122.46913, 37.89201], [-122.46947, 37.89194], [-122.4698, 37.89157], [-122.46984, 37.89147], [-122.46987, 37.89126], [-122.46985, 37.8911], [-122.46982, 37.89099], [-122.46993, 37.89073], [-122.47067, 37.89096], [-122.47116, 37.89161], [-122.472, 37.89197], [-122.47189, 37.89213], [-122.47183, 37.89229], [-122.4718, 37.89246], [-122.4718, 37.8926], [-122.47243, 37.89254]]]} | Open Access 1 | 5223 | Reed School District Open Space | 31736 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 11.783 | Reed School District OS | 0 | Local Recreation Area 3 | 4 | |
6764 | 6764 | 6763 | {"type": "MultiPolygon", "coordinates": [[[[-122.47044, 37.88282], [-122.47137, 37.88329], [-122.47177, 37.88352], [-122.47191, 37.88361], [-122.47229, 37.88394], [-122.47228, 37.88408], [-122.47155, 37.88354], [-122.47113, 37.88331], [-122.47071, 37.88311], [-122.46655, 37.88146], [-122.46617, 37.88128], [-122.46582, 37.88107], [-122.46549, 37.88084], [-122.46519, 37.88058], [-122.46485, 37.88023], [-122.46461, 37.87994], [-122.46398, 37.87905], [-122.46375, 37.87876], [-122.46349, 37.87828], [-122.46366, 37.87841], [-122.46393, 37.87866], [-122.46418, 37.87896], [-122.46473, 37.87971], [-122.46513, 37.88021], [-122.46543, 37.88051], [-122.46589, 37.88086], [-122.46654, 37.88124], [-122.46914, 37.88228], [-122.47044, 37.88282]]], [[[-122.48493, 37.89302], [-122.48479, 37.89316], [-122.48443, 37.89294], [-122.48444, 37.89292], [-122.48369, 37.89248], [-122.48336, 37.89224], [-122.48307, 37.89199], [-122.48301, 37.8919], [-122.4828, 37.89168], [-122.48218, 37.89088], [-122.4819, 37.89053], [-122.48142, 37.89016], [-122.48098, 37.88989], [-122.48092, 37.88992], [-122.48079, 37.88983], [-122.48052, 37.8897], [-122.47978, 37.88947], [-122.47892, 37.88905], [-122.47831, 37.88872], [-122.47672, 37.88778], [-122.4767, 37.88778], [-122.47506, 37.88663], [-122.47435, 37.88604], [-122.47238, 37.88426], [-122.47239, 37.88407], [-122.47364, 37.88519], [-122.4749, 37.88627], [-122.47624, 37.88729], [-122.47681, 37.88766], [-122.47834, 37.88856], [-122.47903, 37.88892], [-122.47991, 37.88929], [-122.48072, 37.88955], [-122.48094, 37.88965], [-122.48151, 37.88999], [-122.48174, 37.89016], [-122.48195, 37.89034], [-122.48214, 37.89054], [-122.48321, 37.89188], [-122.48365, 37.89224], [-122.48392, 37.89233], [-122.48424, 37.8926], [-122.48493, 37.89302]]]]} | Open Access 1 | 5206 | Richardson Bay Lineal Park | 31740 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 11.345 | Richardson Bay Lineal Park | 0 | Local Park 2 | 4 | |
9406 | 9406 | 9405 | {"type": "Polygon", "coordinates": [[[-122.48493, 37.89302], [-122.48424, 37.8926], [-122.48392, 37.89233], [-122.48365, 37.89224], [-122.48351, 37.89213], [-122.48321, 37.89188], [-122.48243, 37.89091], [-122.48254, 37.89103], [-122.48261, 37.89097], [-122.48262, 37.8908], [-122.48269, 37.89064], [-122.48315, 37.89035], [-122.4833, 37.89039], [-122.48364, 37.89071], [-122.48415, 37.89126], [-122.48438, 37.89133], [-122.48478, 37.8918], [-122.4846, 37.89232], [-122.48493, 37.89302]]]} | Open Access 1 | 47817 | South of the Knoll Park | 31741 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 6.518 | South of the Knoll Park | 0 | Local Park 2 | 4 | |
3991 | 3991 | 3990 | {"type": "Polygon", "coordinates": [[[-122.47299, 37.88423], [-122.47287, 37.8843], [-122.47264, 37.88406], [-122.47257, 37.88396], [-122.47243, 37.88398], [-122.47246, 37.88381], [-122.47244, 37.88364], [-122.47251, 37.88362], [-122.47289, 37.88412], [-122.47299, 37.88423]]]} | Open Access 1 | 38063 | The Cypress Garden Park (Secred Garden) | 26280 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 0.299 | The Cypress Garden Park (Secred Garden) | None 347 | |||
16126 | 16126 | 16125 | {"type": "Polygon", "coordinates": [[[-122.46627, 37.88243], [-122.46596, 37.8826], [-122.46576, 37.88273], [-122.46565, 37.88287], [-122.46555, 37.88303], [-122.4655, 37.88316], [-122.46552, 37.88329], [-122.46555, 37.88335], [-122.46562, 37.88343], [-122.46575, 37.88351], [-122.46532, 37.88373], [-122.46486, 37.88363], [-122.46499, 37.88319], [-122.4651, 37.8827], [-122.46546, 37.88242], [-122.4656, 37.88239], [-122.46621, 37.88245], [-122.46627, 37.88243]]]} | Open Access 1 | 16213 | Town Hall Area Open Space | 31733 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 1.96 | Town Hall Area OS | 0 | Local Recreation Area 3 | 4 | |
2149 | 2149 | 2148 | {"type": "Polygon", "coordinates": [[[-122.46161, 37.87736], [-122.46118, 37.87759], [-122.46109, 37.87757], [-122.46043, 37.87756], [-122.46026, 37.87689], [-122.46161, 37.87736]]]} | Open Access 1 | 16016 | Zelinksy Park | 27860 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 1.209 | Zelinksy 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]);