superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where MNG_AGENCY = 96 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1821 | 1821 | 1820 | {"type": "MultiPolygon", "coordinates": [[[[-122.2915, 37.54521], [-122.2906, 37.54579], [-122.29059, 37.54581], [-122.29054, 37.54585], [-122.29049, 37.54587], [-122.29042, 37.54587], [-122.29036, 37.54584], [-122.29033, 37.5458], [-122.29033, 37.54573], [-122.29037, 37.54569], [-122.29042, 37.54565], [-122.29045, 37.54566], [-122.29135, 37.54507], [-122.2915, 37.54521]]], [[[-122.29268, 37.54444], [-122.29163, 37.54512], [-122.29149, 37.54498], [-122.29253, 37.5443], [-122.29268, 37.54444]]]]} | Open Access 1 | Bay Meadows Linear | 15874 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.179 | Bay Meadows Linear | ||
5888 | 5888 | 5887 | {"type": "Polygon", "coordinates": [[[-122.28058, 37.53709], [-122.28016, 37.53733], [-122.2797, 37.53729], [-122.27961, 37.53725], [-122.27952, 37.53716], [-122.27948, 37.53703], [-122.27948, 37.53675], [-122.27955, 37.53663], [-122.27955, 37.53658], [-122.27948, 37.53647], [-122.27946, 37.53631], [-122.27946, 37.53622], [-122.27951, 37.53606], [-122.27949, 37.53601], [-122.27954, 37.53596], [-122.28058, 37.53709]]]} | Open Access 1 | Laguna Vista | 20869 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.998 | Laguna Vista | 1980 | |
2672 | 2672 | 2671 | {"type": "Polygon", "coordinates": [[[-122.28234, 37.53399], [-122.28208, 37.53415], [-122.28213, 37.53423], [-122.28188, 37.53438], [-122.28187, 37.53441], [-122.28178, 37.53444], [-122.28173, 37.5345], [-122.28169, 37.53449], [-122.28144, 37.53464], [-122.28081, 37.53396], [-122.2823, 37.53395], [-122.28234, 37.53399]]]} | Open Access 1 | Casanova | 16932 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.376 | Casanova | 1961 | |
6057 | 6057 | 6056 | {"type": "Polygon", "coordinates": [[[-122.28234, 37.53373], [-122.28117, 37.53374], [-122.28116, 37.53302], [-122.28094, 37.53243], [-122.28103, 37.53235], [-122.28112, 37.53224], [-122.28119, 37.53212], [-122.28123, 37.53199], [-122.28125, 37.53196], [-122.28233, 37.53195], [-122.28234, 37.53373]]]} | Open Access 1 | Laurie Meadows | 21110 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 5.285 | Laurie Meadows | 1973 | |
6421 | 6421 | 6420 | {"type": "Polygon", "coordinates": [[[-122.28324, 37.54136], [-122.283, 37.5415], [-122.28293, 37.54158], [-122.28289, 37.54165], [-122.28286, 37.54177], [-122.28286, 37.54186], [-122.28295, 37.54204], [-122.28215, 37.54258], [-122.28309, 37.54348], [-122.2823, 37.54398], [-122.28105, 37.54282], [-122.28103, 37.54282], [-122.28112, 37.54076], [-122.28213, 37.54016], [-122.28324, 37.54136]]]} | Open Access 1 | Los Prados | 21529 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 12.587 | Los Prados | 1973 | |
4885 | 4885 | 4884 | {"type": "Polygon", "coordinates": [[[-122.28747, 37.54971], [-122.28743, 37.54972], [-122.28691, 37.55004], [-122.28681, 37.55003], [-122.28635, 37.54958], [-122.28609, 37.54929], [-122.2869, 37.54882], [-122.28746, 37.54942], [-122.28731, 37.54954], [-122.28747, 37.54971]]]} | Open Access 1 | Lakeshore Park | 20974 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 2.259 | Lakeshore Park | 1973 | |
6674 | 6674 | 6673 | {"type": "Polygon", "coordinates": [[[-122.28903, 37.56304], [-122.28898, 37.56325], [-122.28894, 37.56329], [-122.28866, 37.56332], [-122.28819, 37.56339], [-122.28798, 37.56344], [-122.28786, 37.56339], [-122.28779, 37.56338], [-122.2877, 37.56342], [-122.28766, 37.5635], [-122.28755, 37.56353], [-122.28738, 37.56313], [-122.28731, 37.56303], [-122.28716, 37.56296], [-122.28689, 37.56292], [-122.28681, 37.56287], [-122.28669, 37.56277], [-122.28709, 37.56244], [-122.28709, 37.56242], [-122.28742, 37.56208], [-122.28903, 37.56304]]]} | Open Access 1 | Mariner's Island | 21851 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 4.056 | Mariner's Island | 1973 | |
10344 | 10344 | 10343 | {"type": "Polygon", "coordinates": [[[-122.2895, 37.56963], [-122.28945, 37.56994], [-122.28945, 37.57029], [-122.28938, 37.57034], [-122.28742, 37.57046], [-122.28656, 37.57049], [-122.28485, 37.57046], [-122.28479, 37.57043], [-122.28474, 37.57034], [-122.28476, 37.57016], [-122.28478, 37.56967], [-122.28473, 37.56942], [-122.2847, 37.56908], [-122.2847, 37.56832], [-122.28655, 37.56883], [-122.28697, 37.56869], [-122.28702, 37.56878], [-122.28702, 37.56893], [-122.28707, 37.56909], [-122.28749, 37.56947], [-122.28783, 37.56965], [-122.28815, 37.56978], [-122.28852, 37.56987], [-122.28896, 37.5699], [-122.28912, 37.56978], [-122.28937, 37.56963], [-122.2895, 37.56963]]]} | Open Access 1 | Tidelands | 26345 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 14.753 | Tidelands | 1973 | |
6648 | 6648 | 6647 | {"type": "Polygon", "coordinates": [[[-122.2914, 37.568], [-122.29143, 37.56813], [-122.29141, 37.56827], [-122.29139, 37.56829], [-122.29135, 37.56831], [-122.29123, 37.56825], [-122.29109, 37.56813], [-122.29095, 37.56795], [-122.29089, 37.56778], [-122.29092, 37.56774], [-122.29111, 37.5678], [-122.29126, 37.56788], [-122.2914, 37.568]]]} | Open Access 1 | Marina Lagoon Wildlife Island | 21829 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 0.386 | Marina Lagoon Wildlife Island | 1962 | |
10332 | 10332 | 10331 | {"type": "Polygon", "coordinates": [[[-122.29224, 37.57021], [-122.2896, 37.5702], [-122.2896, 37.57001], [-122.28967, 37.57007], [-122.28978, 37.5701], [-122.29028, 37.57011], [-122.29047, 37.57006], [-122.29066, 37.56996], [-122.29087, 37.56977], [-122.2909, 37.56972], [-122.29091, 37.56967], [-122.29086, 37.56956], [-122.29087, 37.56951], [-122.29119, 37.56926], [-122.29214, 37.57006], [-122.2922, 37.57013], [-122.29224, 37.57021]]]} | Open Access 1 | Tidelands Park | 26347 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 2.39 | Tidelands Park | 1973 | |
1820 | 1820 | 1819 | {"type": "Polygon", "coordinates": [[[-122.29236, 37.54722], [-122.29185, 37.54752], [-122.29115, 37.5467], [-122.29144, 37.5465], [-122.2914, 37.54642], [-122.29154, 37.54633], [-122.29159, 37.54639], [-122.29155, 37.54645], [-122.29153, 37.54651], [-122.29155, 37.54658], [-122.29158, 37.54663], [-122.29164, 37.54668], [-122.29171, 37.54671], [-122.29185, 37.54671], [-122.29236, 37.54722]]]} | Open Access 1 | Bay Meadows East | 15873 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.372 | Bay Meadows East | 1962 | |
7960 | 7960 | 7959 | {"type": "Polygon", "coordinates": [[[-122.29358, 37.56203], [-122.29325, 37.56211], [-122.29295, 37.56165], [-122.29246, 37.56112], [-122.29168, 37.56068], [-122.29147, 37.5605], [-122.29138, 37.56039], [-122.29133, 37.56029], [-122.29129, 37.56017], [-122.29127, 37.56002], [-122.2913, 37.55979], [-122.29141, 37.55957], [-122.29147, 37.5596], [-122.29328, 37.56156], [-122.29358, 37.56203]]]} | Open Access 1 | Parkside Aquatic | 23447 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 3.141 | Parkside Aquatic | 1961 | |
3427 | 3427 | 3426 | {"type": "Polygon", "coordinates": [[[-122.29376, 37.57208], [-122.29375, 37.5721], [-122.29368, 37.57216], [-122.29354, 37.57217], [-122.29315, 37.57217], [-122.29283, 37.57201], [-122.29283, 37.57196], [-122.29274, 37.57193], [-122.29272, 37.5719], [-122.29252, 37.57204], [-122.29247, 37.5721], [-122.29245, 37.57219], [-122.29245, 37.57227], [-122.29249, 37.57238], [-122.29247, 37.57244], [-122.2924, 37.57248], [-122.29229, 37.57248], [-122.29219, 37.57251], [-122.29215, 37.57255], [-122.29214, 37.57261], [-122.29216, 37.57276], [-122.29209, 37.57288], [-122.29195, 37.57302], [-122.29189, 37.57315], [-122.2919, 37.57329], [-122.29219, 37.57352], [-122.29226, 37.57353], [-122.29231, 37.57357], [-122.29233, 37.57364], [-122.29229, 37.57372], [-122.29217, 37.57387], [-122.29196, 37.57404], [-122.29188, 37.57416], [-122.2918, 37.57434], [-122.29169, 37.57447], [-122.29148, 37.57462], [-122.29127, 37.57475], [-122.29105, 37.57486], [-122.29093, 37.57488], [-122.28789, 37.5746], [-122.28789, 37.57075], [-122.28998, 37.57076], [-122.29112, 37.57112], [-122.29202, 37.57144], [-122.29283, 37.57162], [-122.29327, 37.57176], [-122.29349, 37.57185], [-122.2937, 37.57196], [-122.29375, 37.57201], [-122.29376, 37.57208]]]} | Open Access 1 | Bay Marshes Open Space | 30938 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 40.284 | Bay Marshes OS | ||
1823 | 1823 | 1822 | {"type": "Polygon", "coordinates": [[[-122.29381, 37.54598], [-122.29325, 37.54661], [-122.29319, 37.54657], [-122.29232, 37.54575], [-122.29336, 37.54507], [-122.2935, 37.54518], [-122.29315, 37.5456], [-122.29381, 37.54598]]]} | Open Access 1 | Bay Meadows West | 15876 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 2.441 | Bay Meadows West | 1962 | |
4217 | 4217 | 4216 | {"type": "Polygon", "coordinates": [[[-122.29641, 37.55058], [-122.2957, 37.55093], [-122.29572, 37.55098], [-122.29509, 37.55128], [-122.29476, 37.5511], [-122.29445, 37.55084], [-122.29433, 37.5509], [-122.29395, 37.55051], [-122.29439, 37.55026], [-122.2946, 37.55016], [-122.296, 37.54977], [-122.29613, 37.55], [-122.2961, 37.55003], [-122.29602, 37.55005], [-122.29602, 37.55007], [-122.29641, 37.55058]]]} | Open Access 1 | Fiesta Meadows | 18892 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 4.906 | Fiesta Meadows | 1961 | |
1840 | 1840 | 1839 | {"type": "Polygon", "coordinates": [[[-122.29693, 37.56703], [-122.29692, 37.56786], [-122.29316, 37.56785], [-122.29294, 37.56768], [-122.29268, 37.56753], [-122.29242, 37.56742], [-122.29212, 37.56734], [-122.29267, 37.56564], [-122.29286, 37.56562], [-122.29321, 37.56562], [-122.29327, 37.5657], [-122.29327, 37.56633], [-122.29367, 37.56635], [-122.29367, 37.56643], [-122.29371, 37.5665], [-122.29397, 37.56677], [-122.29441, 37.56732], [-122.29454, 37.56733], [-122.29465, 37.56726], [-122.29462, 37.56714], [-122.2945, 37.56701], [-122.29693, 37.56703]]]} | Open Access 1 | Bayside Joinville Park | 15894 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 12.457 | Bayside Joinville Park | ||
3405 | 3405 | 3404 | {"type": "Polygon", "coordinates": [[[-122.29796, 37.56767], [-122.29795, 37.56824], [-122.29718, 37.56827], [-122.29719, 37.56766], [-122.29738, 37.56766], [-122.2974, 37.5677], [-122.29775, 37.5677], [-122.29777, 37.56767], [-122.29796, 37.56767]]]} | Open Access 1 | Dale Avenue | 17893 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.07 | Dale Avenue | 1961 | |
4296 | 4296 | 4295 | {"type": "Polygon", "coordinates": [[[-122.30386, 37.5286], [-122.30295, 37.52897], [-122.30258, 37.5289], [-122.30234, 37.52882], [-122.30231, 37.52883], [-122.30205, 37.52845], [-122.3034, 37.52789], [-122.30386, 37.5286]]]} | Open Access 1 | Indian Springs | 20207 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 2.707 | Indian Springs | 1961 | |
3794 | 3794 | 3793 | {"type": "Polygon", "coordinates": [[[-122.30409, 37.53651], [-122.3036, 37.53671], [-122.30288, 37.53523], [-122.30346, 37.53505], [-122.30372, 37.5359], [-122.30409, 37.53651]]]} | Open Access 1 | East Hillsdale | 18371 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 2.027 | East Hillsdale | 1961 | |
3150 | 3150 | 3149 | {"type": "Polygon", "coordinates": [[[-122.30455, 37.55525], [-122.30397, 37.55534], [-122.30391, 37.55508], [-122.30448, 37.55498], [-122.30455, 37.55525]]]} | Open Access 1 | Connie Park | 17591 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 0.389 | Connie Park | 1961 |
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]);