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_ID
This data as json, copyable, CSV (advanced)
DES_TP 5
- Local Recreation Area 4
- Local Park 3
- None 1
- None 1
- None 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16125 | 16125 | 16124 | {"type": "MultiPolygon", "coordinates": [[[[-122.46298, 37.88279], [-122.46273, 37.88292], [-122.46271, 37.88298], [-122.46271, 37.88305], [-122.46274, 37.88313], [-122.46269, 37.88319], [-122.46259, 37.88297], [-122.46255, 37.88294], [-122.4625, 37.88294], [-122.46272, 37.88287], [-122.46293, 37.88276], [-122.46298, 37.88279]]], [[[-122.46249, 37.88294], [-122.46249, 37.88294], [-122.46249, 37.88294], [-122.46249, 37.88294], [-122.46249, 37.88294]]], [[[-122.46833, 37.88332], [-122.46798, 37.88337], [-122.46713, 37.88363], [-122.46631, 37.88384], [-122.46515, 37.88417], [-122.46484, 37.88369], [-122.46486, 37.88364], [-122.46532, 37.88373], [-122.46575, 37.88351], [-122.46624, 37.8837], [-122.46657, 37.88361], [-122.46689, 37.88324], [-122.46736, 37.88311], [-122.46772, 37.88306], [-122.46833, 37.88332]]]]} | Open Access 1 | 16211 | Hilarita Project Open Space | 31723 | 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.839 | Hilarita Project OS | 0 | Local Recreation Area 3 | 4 | |
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 | |
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 | |
9648 | 9648 | 9647 | {"type": "Polygon", "coordinates": [[[-122.48842, 37.91763], [-122.48795, 37.91791], [-122.48781, 37.91709], [-122.48758, 37.91541], [-122.48838, 37.9154], [-122.48842, 37.91763]]]} | Open Access 1 | 16249 | Cibrian Subdivision Open Space | 31728 | 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 | 3.766 | Cibrian Subdivision OS | 0 | Local Recreation Area 3 | 4 | |
9649 | 9649 | 9648 | {"type": "Polygon", "coordinates": [[[-122.4874, 37.91851], [-122.48707, 37.91842], [-122.48695, 37.91845], [-122.48682, 37.91854], [-122.48674, 37.91869], [-122.48672, 37.91859], [-122.48665, 37.91847], [-122.48657, 37.91838], [-122.48643, 37.91829], [-122.48712, 37.91797], [-122.4874, 37.91851]]]} | Open Access 1 | 16251 | Hexan Subdivision Open Space Dedication | 19891 | 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.705 | Hexan Subdivision OS Dedication | None 823 | |||
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 | |
14058 | 14058 | 14057 | {"type": "Polygon", "coordinates": [[[-122.48901, 37.89521], [-122.4888, 37.89557], [-122.48822, 37.89497], [-122.4877, 37.89489], [-122.48636, 37.89374], [-122.4861, 37.89391], [-122.48646, 37.89424], [-122.48719, 37.89499], [-122.487, 37.89509], [-122.4865, 37.89457], [-122.48594, 37.89402], [-122.48532, 37.89353], [-122.48479, 37.89316], [-122.48493, 37.89301], [-122.4846, 37.89232], [-122.48478, 37.8918], [-122.48451, 37.89148], [-122.48438, 37.89133], [-122.48415, 37.89126], [-122.4841, 37.89121], [-122.4843, 37.8909], [-122.48771, 37.89414], [-122.48858, 37.89488], [-122.48901, 37.89521]]]} | Open Access 1 | 38060 | McKegney Green | 31739 | 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.467 | McKegney Green | 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 | |||
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 | |
9408 | 9408 | 9407 | {"type": "Polygon", "coordinates": [[[-122.49207, 37.89502], [-122.49188, 37.89527], [-122.49079, 37.89555], [-122.49079, 37.89576], [-122.49092, 37.89579], [-122.49107, 37.8958], [-122.49135, 37.89577], [-122.49174, 37.89564], [-122.49186, 37.89557], [-122.49165, 37.8958], [-122.49147, 37.89584], [-122.49147, 37.89589], [-122.49077, 37.89627], [-122.49017, 37.89668], [-122.49009, 37.89668], [-122.49005, 37.89662], [-122.49015, 37.89626], [-122.49019, 37.89623], [-122.49024, 37.89622], [-122.49065, 37.89624], [-122.49071, 37.89601], [-122.49032, 37.89613], [-122.48994, 37.89615], [-122.48996, 37.89622], [-122.48981, 37.89665], [-122.48973, 37.89683], [-122.48963, 37.89702], [-122.48951, 37.89719], [-122.48936, 37.89734], [-122.48928, 37.89729], [-122.48902, 37.89749], [-122.48902, 37.8975], [-122.48907, 37.89755], [-122.48868, 37.89782], [-122.48855, 37.89788], [-122.48835, 37.89791], [-122.48817, 37.89789], [-122.48796, 37.89782], [-122.48779, 37.89769], [-122.48769, 37.89754], [-122.48766, 37.89745], [-122.48766, 37.89732], [-122.48779, 37.89686], [-122.48783, 37.89657], [-122.4878, 37.89631], [-122.48777, 37.89617], [-122.48768, 37.89598], [-122.48746, 37.89564], [-122.48724, 37.89534], [-122.487, 37.89509], [-122.48719, 37.895], [-122.48776, 37.89556], [-122.48818, 37.89532], [-122.4877, 37.89489], [-122.48822, 37.89497], [-122.48881, 37.89557], [-122.48955, 37.89554], [-122.48961, 37.89543], [-122.48971, 37.89544], [-122.49016, 37.89536], [-122.4916, 37.89498], [-122.49207, 37.89502]]]} | Open Access 1 | 47819 | Blackie's Pasture | 31743 | 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 | 15.452 | Blackie's Pasture | None 776 |
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]);