units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where MNG_AGENCY = 96 sorted by YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
1838 | 1838 | 1837 | {"type": "Polygon", "coordinates": [[[-122.30912, 37.57475], [-122.30887, 37.57498], [-122.30859, 37.57511], [-122.30813, 37.57488], [-122.30792, 37.57476], [-122.30772, 37.57507], [-122.30762, 37.57505], [-122.30754, 37.57507], [-122.3075, 37.57514], [-122.3075, 37.57519], [-122.30753, 37.57523], [-122.30727, 37.5754], [-122.30692, 37.57512], [-122.30759, 37.57461], [-122.30797, 37.57472], [-122.3083, 37.57478], [-122.3087, 37.5748], [-122.30912, 37.57475]]]} | Open Access 1 | 14068 | Ryder Court | 24760 | 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.407 | Ryder Court | 0 | Local Park 2 | 4 | |
4105 | 4105 | 4104 | {"type": "Polygon", "coordinates": [[[-122.33426, 37.52088], [-122.33353, 37.52137], [-122.33341, 37.52122], [-122.33305, 37.52137], [-122.33302, 37.52132], [-122.33338, 37.52116], [-122.33334, 37.52099], [-122.33315, 37.52069], [-122.33336, 37.5206], [-122.33307, 37.52029], [-122.33287, 37.51998], [-122.33303, 37.51991], [-122.33426, 37.52088]]]} | Open Access 1 | 47228 | Timberland Open Space | 30936 | 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.894 | Timberland OS | 0 | Local Recreation Area 3 | 4 | |
10382 | 10382 | 10381 | {"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.56634], [-122.29367, 37.56635], [-122.29367, 37.56644], [-122.29371, 37.5665], [-122.29397, 37.56677], [-122.29441, 37.56732], [-122.29454, 37.56733], [-122.29465, 37.56727], [-122.29462, 37.56714], [-122.2945, 37.56701], [-122.29693, 37.56703]]]} | Open Access 1 | 18336 | Bayside Joinville Park | 15894 | 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.452 | Bayside Joinville Park | 0 | Local Park 2 | 4 | |
15993 | 15993 | 15992 | {"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.29218, 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 | 47230 | Bay Marshes Open Space | 30938 | 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 | 40.282 | Bay Marshes OS | 0 | Local Recreation Area 3 | 4 | |
15680 | 15680 | 15679 | {"type": "Polygon", "coordinates": [[[-122.3278, 37.584], [-122.32787, 37.58495], [-122.32785, 37.58503], [-122.3278, 37.58512], [-122.32454, 37.58738], [-122.32439, 37.58746], [-122.32426, 37.58749], [-122.32339, 37.58752], [-122.32316, 37.58757], [-122.32295, 37.58766], [-122.32265, 37.58791], [-122.32253, 37.58797], [-122.32238, 37.58802], [-122.32142, 37.58816], [-122.32145, 37.58826], [-122.32097, 37.58825], [-122.32072, 37.58807], [-122.3202, 37.58694], [-122.31931, 37.58631], [-122.31857, 37.58615], [-122.31794, 37.58639], [-122.31797, 37.58625], [-122.31788, 37.58596], [-122.31775, 37.58567], [-122.31758, 37.5851], [-122.3241, 37.5806], [-122.3278, 37.584]]]} | Restricted Access 2 | 14014 | San Mateo Municipal Golf Course | 33037 | 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 | 105.785 | San Mateo Municipal GC | 1933 | Local Recreation Area 3 | 4 | |
3720 | 3720 | 3719 | {"type": "Polygon", "coordinates": [[[-122.31469, 37.55875], [-122.31454, 37.55886], [-122.3145, 37.55887], [-122.31428, 37.55865], [-122.31444, 37.55853], [-122.31448, 37.55852], [-122.31457, 37.55859], [-122.31469, 37.55871], [-122.31469, 37.55875]]]} | Open Access 1 | 14034 | Hayward Park Square | 19760 | 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.192 | Hayward Park Square | 1940 | Local Park 2 | 4 | |
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 | ||
7909 | 7909 | 7908 | {"type": "Polygon", "coordinates": [[[-122.32427, 37.56169], [-122.3221, 37.56319], [-122.32082, 37.56202], [-122.32141, 37.56161], [-122.32142, 37.56159], [-122.32012, 37.5604], [-122.32038, 37.56022], [-122.32088, 37.56068], [-122.32219, 37.55977], [-122.32427, 37.56169]]]} | Open Access 1 | 10244 | Central Park | 17059 | 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 | 16.261 | Central Park | 1940 | Local Park 2 | 4 | |
8683 | 8683 | 8682 | {"type": "Polygon", "coordinates": [[[-122.32986, 37.56138], [-122.32912, 37.5622], [-122.32894, 37.56233], [-122.32844, 37.56238], [-122.32831, 37.56247], [-122.32823, 37.56284], [-122.32781, 37.56315], [-122.32743, 37.56319], [-122.32742, 37.56305], [-122.32757, 37.56302], [-122.32772, 37.56297], [-122.32787, 37.56289], [-122.328, 37.56279], [-122.32812, 37.56262], [-122.32821, 37.56237], [-122.32832, 37.56226], [-122.32847, 37.56218], [-122.32876, 37.56213], [-122.32893, 37.56205], [-122.32912, 37.56187], [-122.32922, 37.56173], [-122.32935, 37.56164], [-122.32946, 37.56162], [-122.32953, 37.56157], [-122.32957, 37.56149], [-122.32952, 37.5614], [-122.3297, 37.56137], [-122.32986, 37.56138]]]} | Open Access 1 | 14040 | DeAnza Historical Area | 17979 | 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.425 | DeAnza Historical Area | 1940 | Local Historic or Cultural Area 19 | 4 | |
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 | ||
238 | 238 | 237 | {"type": "Polygon", "coordinates": [[[-122.30466, 37.56871], [-122.3034, 37.56958], [-122.30328, 37.56965], [-122.30262, 37.56848], [-122.30364, 37.56777], [-122.30466, 37.56871]]]} | Open Access 1 | 771 | Shoreview Park | 25430 | 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.751 | Shoreview Park | 1961 | Local Park 2 | 4 | |
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 | ||
1844 | 1844 | 1843 | {"type": "Polygon", "coordinates": [[[-122.32314, 37.54969], [-122.32289, 37.54988], [-122.3213, 37.54842], [-122.32142, 37.54837], [-122.32155, 37.54836], [-122.32166, 37.54838], [-122.32176, 37.54843], [-122.32314, 37.54969]]]} | Open Access 1 | 14083 | Borel Park | 16283 | 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.55 | Borel Park | 1961 | Local Park 2 | 4 | |
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 |
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]);