units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

37 rows where AGNCY_NAME = 98 and MNG_AGENCY = 96

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST, GAP_STS

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Mateo, City of · 37 ✖
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
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
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  
1834 1834 1833 {"type": "Polygon", "coordinates": [[[-122.29139, 37.56829], [-122.29135, 37.56831], [-122.2913, 37.56829], [-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.29127, 37.56788], [-122.2914, 37.568], [-122.29143, 37.56813], [-122.29141, 37.56827], [-122.29139, 37.56829]]]} Open Access 1 14019 Marina Lagoon Wildlife Island 21829 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.388 Marina Lagoon Wildlife Island 1962 Local Conservation Area 4 2
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  
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
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  
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
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  
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
6717 6717 6716 {"type": "Polygon", "coordinates": [[[-122.29224, 37.57021], [-122.2896, 37.5702], [-122.2896, 37.57001], [-122.28967, 37.57007], [-122.28978, 37.5701], [-122.29029, 37.57011], [-122.29047, 37.57006], [-122.29066, 37.56997], [-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 5073 Tidelands Park 26347 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.39 Tidelands Park 1973 Local Park 2 4
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
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  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);