superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where ACCESS_TYP = 1 and MNG_AGENCY = 477 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL ▼ | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14408 | 14408 | 14407 | {"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.46561, 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 | Town Hall Area Open Space | 31733 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1.96 | Town Hall Area OS | ||
14778 | 14778 | 14777 | {"type": "Polygon", "coordinates": [[[-122.49232, 37.90311], [-122.49225, 37.90325], [-122.49196, 37.90343], [-122.49196, 37.90348], [-122.49198, 37.90352], [-122.49199, 37.90386], [-122.49192, 37.90395], [-122.49199, 37.9041], [-122.492, 37.90455], [-122.49193, 37.90467], [-122.49204, 37.90475], [-122.49206, 37.9049], [-122.49223, 37.90502], [-122.4922, 37.90522], [-122.492, 37.90539], [-122.4919, 37.90567], [-122.49165, 37.90576], [-122.49045, 37.90632], [-122.48945, 37.90655], [-122.48859, 37.90739], [-122.48821, 37.90809], [-122.48808, 37.90799], [-122.48758, 37.90776], [-122.48678, 37.9079], [-122.4841, 37.90617], [-122.48226, 37.90505], [-122.48228, 37.90351], [-122.48236, 37.90347], [-122.4834, 37.90319], [-122.48405, 37.90377], [-122.48421, 37.90472], [-122.48714, 37.9047], [-122.48831, 37.9043], [-122.48958, 37.90411], [-122.48988, 37.90429], [-122.49138, 37.90373], [-122.49135, 37.90342], [-122.4917, 37.90341], [-122.49171, 37.90309], [-122.49189, 37.90289], [-122.49232, 37.90311]]]} | Open Access 1 | Atkinson Open Space Purchase | 31737 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 59.739 | Atkinson OS Purchase | ||
14784 | 14784 | 14783 | {"type": "MultiPolygon", "coordinates": [[[[-122.47137, 37.88797], [-122.47086, 37.88811], [-122.47097, 37.8885], [-122.47118, 37.88878], [-122.4703, 37.88964], [-122.47019, 37.88961], [-122.47011, 37.8896], [-122.46998, 37.88962], [-122.46989, 37.88965], [-122.46768, 37.8882], [-122.46816, 37.88767], [-122.46817, 37.8876], [-122.46822, 37.88752], [-122.46823, 37.88748], [-122.4682, 37.88744], [-122.46814, 37.88745], [-122.46811, 37.88744], [-122.46811, 37.88734], [-122.4682, 37.88715], [-122.46834, 37.88694], [-122.46842, 37.88678], [-122.46846, 37.88666], [-122.46878, 37.88693], [-122.47011, 37.88547], [-122.47067, 37.88596], [-122.47051, 37.88637], [-122.47044, 37.88637], [-122.47038, 37.8864], [-122.47035, 37.88645], [-122.47035, 37.8865], [-122.47037, 37.88654], [-122.47041, 37.88657], [-122.47057, 37.88659], [-122.47077, 37.88678], [-122.47086, 37.8869], [-122.47092, 37.88707], [-122.47095, 37.88735], [-122.47047, 37.88729], [-122.47043, 37.88749], [-122.47098, 37.88756], [-122.47101, 37.88765], [-122.4711, 37.88776], [-122.47129, 37.88789], [-122.47137, 37.88797]]], [[[-122.47245, 37.88757], [-122.47182, 37.88815], [-122.47172, 37.88814], [-122.47158, 37.88803], [-122.47135, 37.88779], [-122.47125, 37.88771], [-122.47177, 37.8874], [-122.47173, 37.88693], [-122.47245, 37.88757]]]]} | Open Access 1 | Eavey Open Space Purchase | 31734 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 21.377 | Eavey OS Purchase | ||
14785 | 14785 | 14784 | {"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.46948, 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.89212], [-122.47183, 37.89229], [-122.4718, 37.89246], [-122.47181, 37.8926], [-122.47243, 37.89254]]]} | Open Access 1 | Reed School District Open Space | 31736 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 11.787 | Reed School District OS | ||
15016 | 15016 | 15015 | {"type": "Polygon", "coordinates": [[[-122.47464, 37.89116], [-122.47323, 37.89247], [-122.472, 37.89197], [-122.47116, 37.89161], [-122.4732, 37.89029], [-122.4737, 37.88994], [-122.47427, 37.89053], [-122.47464, 37.89116]]]} | Open Access 1 | Hamon (Rock & Tree) Open Space | 31721 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 10.491 | Hamon (Rock & Tree) OS | ||
15017 | 15017 | 15016 | {"type": "Polygon", "coordinates": [[[-122.4659, 37.89032], [-122.46485, 37.89155], [-122.46381, 37.8928], [-122.46073, 37.89172], [-122.46105, 37.89101], [-122.46158, 37.89118], [-122.46276, 37.8913], [-122.46367, 37.89121], [-122.46381, 37.89117], [-122.46397, 37.89102], [-122.46408, 37.89096], [-122.46421, 37.89093], [-122.46439, 37.89093], [-122.4645, 37.89089], [-122.46457, 37.89084], [-122.46471, 37.89066], [-122.46482, 37.89063], [-122.46491, 37.89047], [-122.46501, 37.89047], [-122.46517, 37.89034], [-122.4653, 37.89028], [-122.46544, 37.89024], [-122.46559, 37.89024], [-122.46578, 37.89027], [-122.4659, 37.89032]], [[-122.46368, 37.89222], [-122.46368, 37.89224], [-122.46374, 37.89232], [-122.46391, 37.89225], [-122.46385, 37.89217], [-122.46368, 37.89222]]]} | Open Access 1 | Mount Tiburon Subdivision Open Space | 31722 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 12.365 | Mount Tiburon Subdivision OS | ||
15018 | 15018 | 15017 | {"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.4625, 37.88294], [-122.46249, 37.88294], [-122.46249, 37.88294], [-122.46249, 37.88294], [-122.4625, 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.46625, 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 | Hilarita Project Open Space | 31723 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 2.842 | Hilarita Project OS | ||
15019 | 15019 | 15018 | {"type": "MultiPolygon", "coordinates": [[[[-122.47204, 37.89357], [-122.46975, 37.89544], [-122.46937, 37.89509], [-122.46575, 37.89237], [-122.46605, 37.89211], [-122.4662, 37.89246], [-122.46633, 37.89265], [-122.46652, 37.89286], [-122.46681, 37.89306], [-122.4671, 37.89317], [-122.46752, 37.89325], [-122.46811, 37.89321], [-122.4684, 37.89315], [-122.46868, 37.89303], [-122.46831, 37.89259], [-122.46846, 37.89251], [-122.46857, 37.8924], [-122.46863, 37.89228], [-122.46871, 37.89207], [-122.46877, 37.89196], [-122.46893, 37.89205], [-122.46913, 37.89201], [-122.46898, 37.89223], [-122.46989, 37.89271], [-122.47204, 37.89357]]], [[[-122.46989, 37.88965], [-122.46976, 37.88976], [-122.46967, 37.88989], [-122.46962, 37.89013], [-122.46953, 37.89042], [-122.46951, 37.89027], [-122.46947, 37.89017], [-122.46923, 37.88995], [-122.46972, 37.88953], [-122.46989, 37.88965]]], [[[-122.47298, 37.88952], [-122.47253, 37.89006], [-122.47294, 37.89045], [-122.47116, 37.89161], [-122.47067, 37.89096], [-122.46995, 37.89074], [-122.46982, 37.89099], [-122.46953, 37.89092], [-122.46975, 37.89017], [-122.4698, 37.88994], [-122.46989, 37.88981], [-122.47001, 37.88974], [-122.47014, 37.88972], [-122.47021, 37.88974], [-122.47026, 37.88978], [-122.4703, 37.88984], [-122.47031, 37.88997], [-122.47034, 37.89006], [-122.47039, 37.89013], [-122.47047, 37.8902], [-122.47057, 37.89026], [-122.47075, 37.89031], [-122.47089, 37.89038], [-122.471, 37.89047], [-122.47109, 37.89058], [-122.47118, 37.89064], [-122.47126, 37.89067], [-122.47138, 37.89068], [-122.47147, 37.89066], [-122.47157, 37.89062], [-122.47164, 37.89057], [-122.47169, 37.89048], [-122.47172, 37.89031], [-122.47169, 37.88973], [-122.47169, 37.88964], [-122.47172, 37.88954], [-122.47177, 37.88946], [-122.47188, 37.88934], [-122.47199, 37.88929], [-122.47217, 37.88923], [-122.4723, 37.88916], [-122.47241, 37.88906], [-122.47249, 37.88894], [-122.47257, 37.88891], [-122.4727, 37.88896], [-122.47281, 37.88906], [-122.47284, 37.88915], [-122.47284, 37.88925], [-122.47287, 37.88936], [-122.47291, 37.88944], [-122.47298, 37.88952]]], [[[-122.47129, 37.88894], [-122.47107, 37.88919], [-122.47091, 37.88963], [-122.47101, 37.89008], [-122.47091, 37.89024], [-122.47061, 37.89015], [-122.47054, 37.8901], [-122.47048, 37.89001], [-122.47046, 37.88994], [-122.47045, 37.88982], [-122.47042, 37.88975], [-122.47036, 37.88969], [-122.4703, 37.88964], [-122.47118, 37.88878], [-122.47129, 37.88894]]]]} | Open Access 1 | Del Madera Subdivision Open Space | 31730 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 29.292 | Del Madera Subdivision OS | ||
15021 | 15021 | 15020 | {"type": "MultiPolygon", "coordinates": [[[[-122.4787, 37.89407], [-122.4783, 37.89414], [-122.4783, 37.89453], [-122.47817, 37.8946], [-122.47805, 37.89468], [-122.4779, 37.89459], [-122.47808, 37.89439], [-122.47788, 37.89427], [-122.47769, 37.89455], [-122.4774, 37.89438], [-122.47718, 37.89461], [-122.47742, 37.89476], [-122.47737, 37.89481], [-122.47725, 37.89474], [-122.47682, 37.89479], [-122.47671, 37.89499], [-122.47692, 37.89514], [-122.47599, 37.89548], [-122.47545, 37.89536], [-122.47502, 37.89525], [-122.47391, 37.89443], [-122.47325, 37.89392], [-122.47288, 37.89422], [-122.47239, 37.89385], [-122.47248, 37.89376], [-122.47254, 37.89367], [-122.47257, 37.89352], [-122.47243, 37.89256], [-122.4718, 37.89261], [-122.4718, 37.89246], [-122.47182, 37.89229], [-122.47189, 37.89212], [-122.472, 37.89197], [-122.47323, 37.89246], [-122.47444, 37.89135], [-122.47492, 37.89179], [-122.47445, 37.89213], [-122.47444, 37.89215], [-122.47559, 37.89313], [-122.47598, 37.89323], [-122.47581, 37.89367], [-122.4752, 37.89299], [-122.47444, 37.89263], [-122.47423, 37.89279], [-122.47445, 37.89298], [-122.47437, 37.89306], [-122.47412, 37.89286], [-122.47385, 37.89304], [-122.47386, 37.89306], [-122.47397, 37.89314], [-122.47376, 37.89335], [-122.47396, 37.8935], [-122.47406, 37.89354], [-122.47401, 37.89364], [-122.47384, 37.89359], [-122.47372, 37.89358], [-122.47361, 37.89368], [-122.47387, 37.89389], [-122.47425, 37.89447], [-122.47433, 37.89454], [-122.47459, 37.89472], [-122.47523, 37.89487], [-122.47547, 37.89482], [-122.47552, 37.89471], [-122.47546, 37.89452], [-122.47567, 37.89447], [-122.47593, 37.89435], [-122.47624, 37.89429], [-122.47649, 37.89415], [-122.47677, 37.8944], [-122.47727, 37.89433], [-122.47818, 37.89358], [-122.47842, 37.89369], [-122.4787, 37.89376], [-122.4787, 37.89407]]], [[[-122.47531, 37.89394], [-122.47502, 37.89401], [-122.47499, 37.89403], [-122.47494, 37.89392], [-122.47483, 37.89379], [-122.47467, 37.89376], [-122.47455, 37.8938], [-122.47451, 37.89375], [-122.47472, 37.89363], [-122.47478, 37.89368], [-122.47499, 37.89392], [-122.4751, 37.89395], [-122.4753, 37.8939], [-122.47531, 37.89394]]]]} | Open Access 1 | Miraflores Subdivision Open Space | 31731 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 17.323 | Miraflores Subdivision OS |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);