units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where MNG_AGENCY = 96 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST, GAP_STS
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1636 | 1636 | 1635 | {"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.28214, 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 | 14056 | Los Prados | 21529 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 12.576 | Los Prados | 1973 | None 133 | ||
1833 | 1833 | 1832 | {"type": "Polygon", "coordinates": [[[-122.31523, 37.58098], [-122.31449, 37.58149], [-122.31363, 37.58076], [-122.31441, 37.58023], [-122.31523, 37.58098]]]} | Open Access 1 | 14016 | Harborview | 19669 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 2.434 | Harborview | 1961 | None 143 | ||
1836 | 1836 | 1835 | {"type": "Polygon", "coordinates": [[[-122.29796, 37.56767], [-122.29795, 37.56824], [-122.29718, 37.56827], [-122.29719, 37.56766], [-122.29738, 37.56766], [-122.29739, 37.5677], [-122.29776, 37.5677], [-122.29777, 37.56767], [-122.29796, 37.56767]]]} | Open Access 1 | 14064 | Dale Avenue | 17893 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.07 | Dale Avenue | 1961 | None 144 | ||
1837 | 1837 | 1836 | {"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 | 14066 | Laguna Vista | 20869 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.998 | Laguna Vista | 1980 | None 145 | ||
1841 | 1841 | 1840 | {"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 | 14077 | Bay Meadows West | 15876 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 2.436 | Bay Meadows West | 1962 | None 146 | ||
1842 | 1842 | 1841 | {"type": "Polygon", "coordinates": [[[-122.29185, 37.54671], [-122.29236, 37.54722], [-122.29185, 37.54752], [-122.29115, 37.5467], [-122.29145, 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.54664], [-122.29164, 37.54668], [-122.29171, 37.54671], [-122.29185, 37.54671]]]} | Open Access 1 | 14079 | Bay Meadows East | 15873 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.371 | Bay Meadows East | 1962 | None 147 | ||
1843 | 1843 | 1842 | {"type": "MultiPolygon", "coordinates": [[[[-122.2915, 37.54521], [-122.29059, 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.29044, 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 | 14081 | Bay Meadows Linear | 15874 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.18 | Bay Meadows Linear | None 148 | |||
3721 | 3721 | 3720 | {"type": "Polygon", "coordinates": [[[-122.31947, 37.56947], [-122.31859, 37.57008], [-122.31843, 37.56994], [-122.31804, 37.56974], [-122.31787, 37.56968], [-122.31738, 37.56941], [-122.31678, 37.56954], [-122.31768, 37.56892], [-122.318, 37.56921], [-122.31789, 37.56928], [-122.31789, 37.56935], [-122.31827, 37.56968], [-122.31834, 37.56968], [-122.3184, 37.56965], [-122.3187, 37.56992], [-122.31881, 37.56987], [-122.31941, 37.56946], [-122.31947, 37.56947]]]} | Open Access 1 | 14036 | Gateway | 19234 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.454 | Gateway | 1940 | None 310 | ||
3728 | 3728 | 3727 | {"type": "Polygon", "coordinates": [[[-122.32824, 37.55981], [-122.32774, 37.55988], [-122.3277, 37.55972], [-122.32775, 37.55963], [-122.32814, 37.55935], [-122.32824, 37.55981]]]} | Open Access 1 | 14038 | Bay Tree | 15881 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 0.416 | Bay Tree | 1940 | None 311 | ||
8679 | 8679 | 8678 | {"type": "Polygon", "coordinates": [[[-122.31792, 37.58464], [-122.31731, 37.58506], [-122.31598, 37.58396], [-122.31589, 37.58383], [-122.31573, 37.58366], [-122.31559, 37.58356], [-122.31531, 37.58329], [-122.31316, 37.58144], [-122.31296, 37.58135], [-122.31274, 37.58129], [-122.31266, 37.58122], [-122.3126, 37.58111], [-122.31, 37.57889], [-122.30995, 37.57869], [-122.30897, 37.57783], [-122.30564, 37.575], [-122.3054, 37.57491], [-122.30497, 37.57507], [-122.30473, 37.57512], [-122.30454, 37.57521], [-122.30437, 37.57542], [-122.30423, 37.57548], [-122.30404, 37.57546], [-122.30398, 37.57559], [-122.30388, 37.57571], [-122.3034, 37.57585], [-122.30285, 37.57589], [-122.30232, 37.5759], [-122.3018, 37.57587], [-122.30118, 37.5758], [-122.30071, 37.57584], [-122.30033, 37.57581], [-122.29999, 37.57576], [-122.29986, 37.57564], [-122.29951, 37.57561], [-122.29903, 37.57551], [-122.29699, 37.57551], [-122.29687, 37.57543], [-122.29686, 37.57387], [-122.29696, 37.5716], [-122.30759, 37.57461], [-122.30693, 37.57511], [-122.30692, 37.57513], [-122.30822, 37.57614], [-122.3135, 37.58067], [-122.31371, 37.58083], [-122.31665, 37.58335], [-122.31654, 37.58345], [-122.31792, 37.58464]]]} | Open Access 1 | 14017 | Shoreline Bayfront Seal Point | 25425 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 92.182 | Shoreline Bayfront Seal Point | None 729 | |||
8680 | 8680 | 8679 | {"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 | 14020 | Tidelands | 26345 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 14.752 | Tidelands | 1973 | None 730 | ||
8681 | 8681 | 8680 | {"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.28769, 37.56342], [-122.28766, 37.5635], [-122.28755, 37.56353], [-122.28738, 37.56313], [-122.28731, 37.56303], [-122.28716, 37.56295], [-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 | 14022 | Mariner's Island | 21851 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 4.056 | Mariner's Island | 1973 | None 731 | ||
8682 | 8682 | 8681 | {"type": "Polygon", "coordinates": [[[-122.29358, 37.56203], [-122.29325, 37.56211], [-122.29295, 37.56166], [-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 | 14024 | Parkside Aquatic | 23447 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 3.141 | Parkside Aquatic | 1961 | None 732 | ||
8684 | 8684 | 8683 | {"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 | 14042 | Indian Springs | 20207 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 2.707 | Indian Springs | 1961 | None 733 | ||
8685 | 8685 | 8684 | {"type": "Polygon", "coordinates": [[[-122.30777, 37.53501], [-122.30722, 37.53524], [-122.30688, 37.53471], [-122.30691, 37.53452], [-122.30676, 37.53428], [-122.30662, 37.53422], [-122.30713, 37.53401], [-122.30777, 37.53501]]]} | Open Access 1 | 14044 | West Hillsdale | 27361 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.56 | West Hillsdale | 1961 | None 734 | ||
8686 | 8686 | 8685 | {"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 | 14046 | East Hillsdale | 18371 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 2.027 | East Hillsdale | 1961 | None 735 | ||
8690 | 8690 | 8689 | {"type": "Polygon", "coordinates": [[[-122.3097, 37.55093], [-122.30896, 37.55143], [-122.3086, 37.55081], [-122.30869, 37.55074], [-122.30847, 37.5504], [-122.30884, 37.55014], [-122.3097, 37.55093]]]} | Open Access 1 | 14052 | Trinta | 26544 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.875 | Trinta | 1940 | None 736 | ||
8691 | 8691 | 8690 | {"type": "Polygon", "coordinates": [[[-122.29641, 37.55058], [-122.29569, 37.55093], [-122.29572, 37.55098], [-122.29509, 37.55128], [-122.29477, 37.5511], [-122.29445, 37.55084], [-122.29433, 37.5509], [-122.29395, 37.55051], [-122.29439, 37.55025], [-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 | 14054 | Fiesta Meadows | 18892 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 4.905 | Fiesta Meadows | 1961 | None 737 | ||
8692 | 8692 | 8691 | {"type": "Polygon", "coordinates": [[[-122.28234, 37.53399], [-122.28207, 37.53415], [-122.28213, 37.53423], [-122.28187, 37.53439], [-122.28187, 37.53441], [-122.28178, 37.53444], [-122.28173, 37.5345], [-122.2817, 37.53449], [-122.28144, 37.53464], [-122.28081, 37.53396], [-122.2823, 37.53395], [-122.28234, 37.53399]]]} | Open Access 1 | 14058 | Casanova | 16932 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.375 | Casanova | 1961 | None 738 | ||
8693 | 8693 | 8692 | {"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 | 14060 | Laurie Meadows | 21110 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 5.286 | Laurie Meadows | 1973 | None 739 |
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]);