units_with_maps

Table actions

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

13 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AGENCY = 217

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 13 ✖
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
608 608 607 {"type": "Polygon", "coordinates": [[[-122.16052, 37.46073], [-122.15992, 37.46148], [-122.15819, 37.46088], [-122.15834, 37.46016], [-122.15964, 37.46033], [-122.15972, 37.46057], [-122.16052, 37.46073]]]} Open Access 1 2123 Willow Oaks Park 27581 1202 Menlo Park, City of 221 City 2 City Agency 2 http://www.menlopark.org/ City 2 1202 Menlo Park, City of 217 City 2 City Agency 2   San Mateo 15 4.256 Willow Oaks Park 1940 Local Park 2 4
743 743 742 {"type": "Polygon", "coordinates": [[[-122.17782, 37.45219], [-122.17654, 37.45387], [-122.1743, 37.4528], [-122.17577, 37.45096], [-122.17782, 37.45219]]]} Open Access 1 4790 Burgess Park 16518 1202 Menlo Park, City of 221 City 2 City Agency 2 http://www.menlopark.org/ City 2 1202 Menlo Park, City of 217 City 2 City Agency 2   San Mateo 15 13.014 Burgess Park 1947 Local Park 2 4
1865 1865 1864 {"type": "Polygon", "coordinates": [[[-122.18669, 37.44885], [-122.18632, 37.44929], [-122.18592, 37.44908], [-122.18628, 37.44864], [-122.18669, 37.44885]]]} Open Access 1 14291 Fremont Park 19099 1202 Menlo Park, City of 221 City 2 City Agency 2 http://www.menlopark.org/ City 2 1202 Menlo Park, City of 217 City 2 City Agency 2   San Mateo 15 0.623 Fremont Park 2000 Local Park 2 4
2668 2668 2667 {"type": "Polygon", "coordinates": [[[-122.18195, 37.44777], [-122.18079, 37.44915], [-122.17918, 37.44823], [-122.18028, 37.44688], [-122.18195, 37.44777]]]} Open Access 1 18188 Nealon Park 22679 1202 Menlo Park, City of 221 City 2 City Agency 2 http://www.menlopark.org/ City 2 1202 Menlo Park, City of 217 City 2 City Agency 2   San Mateo 15 7.884 Nealon Park 1961 Local Park 2 4
5331 5331 5330 {"type": "Polygon", "coordinates": [[[-122.19589, 37.44038], [-122.19554, 37.4408], [-122.19566, 37.44089], [-122.19538, 37.44122], [-122.19395, 37.44046], [-122.19438, 37.43994], [-122.19478, 37.44014], [-122.19494, 37.43998], [-122.19508, 37.44008], [-122.1953, 37.44011], [-122.19589, 37.44038]]]} Open Access 1 15566 Tinkers Park 26373 1202 Menlo Park, City of 221 City 2 City Agency 2 http://www.menlopark.org/ City 2 1202 Menlo Park, City of 217 City 2 City Agency 2   San Mateo 15 3.227 Tinkers Park 1961 Local Park 2 4
6016 6016 6015 {"type": "Polygon", "coordinates": [[[-122.21219, 37.43296], [-122.21168, 37.433], [-122.21126, 37.43301], [-122.2108, 37.43298], [-122.21028, 37.43286], [-122.20983, 37.43272], [-122.2094, 37.43252], [-122.20901, 37.43238], [-122.20853, 37.43223], [-122.20811, 37.43215], [-122.20783, 37.43243], [-122.20732, 37.43216], [-122.20858, 37.43058], [-122.20888, 37.43058], [-122.20903, 37.43073], [-122.20908, 37.43093], [-122.20928, 37.4311], [-122.20954, 37.43115], [-122.21018, 37.43117], [-122.21054, 37.4312], [-122.21098, 37.43195], [-122.21106, 37.43249], [-122.21159, 37.43261], [-122.21201, 37.4326], [-122.21219, 37.43296]]]} Open Access 1 695 Sharon Hill Park 25362 1202 Menlo Park, City of 221 City 2 City Agency 2 http://www.menlopark.org/ City 2 1202 Menlo Park, City of 217 City 2 City Agency 2   San Mateo 15 12.961 Sharon Hill Park 1973 Local Park 2 4
6018 6018 6017 {"type": "Polygon", "coordinates": [[[-122.21204, 37.42373], [-122.21157, 37.42448], [-122.2106, 37.4243], [-122.20834, 37.42439], [-122.20823, 37.4236], [-122.20844, 37.42337], [-122.20979, 37.42308], [-122.21204, 37.42373]]]} Open Access 1 700 Sharon Park 25363 1202 Menlo Park, City of 221 City 2 City Agency 2 http://www.menlopark.org/ City 2 1202 Menlo Park, City of 217 City 2 City Agency 2   San Mateo 15 9.023 Sharon Park 1961 Local Park 2 4
8786 8786 8785 {"type": "Polygon", "coordinates": [[[-122.17165, 37.4789], [-122.16783, 37.47916], [-122.16777, 37.47856], [-122.16808, 37.47859], [-122.16966, 37.47849], [-122.16984, 37.47853], [-122.16994, 37.47849], [-122.16996, 37.47845], [-122.16996, 37.4784], [-122.16991, 37.47833], [-122.16983, 37.47831], [-122.16808, 37.47843], [-122.16791, 37.47842], [-122.16772, 37.47838], [-122.16789, 37.47815], [-122.16789, 37.47811], [-122.16977, 37.47798], [-122.16976, 37.47779], [-122.17165, 37.4789]]]} Open Access 1 14290 Kelly Park 20588 1202 Menlo Park, City of 221 City 2 City Agency 2 http://www.menlopark.org/ City 2 1202 Menlo Park, City of 217 City 2 City Agency 2   San Mateo 15 6.931 Kelly Park 1961 Local Park 2 4
9329 9329 9328 {"type": "Polygon", "coordinates": [[[-122.18424, 37.44468], [-122.18381, 37.44519], [-122.18236, 37.44442], [-122.18279, 37.44391], [-122.18424, 37.44468]]]} Open Access 1 15558 Jack W. Lyle Park 20313 1202 Menlo Park, City of 221 City 2 City Agency 2 http://www.menlopark.org/ City 2 1202 Menlo Park, City of 217 City 2 City Agency 2   San Mateo 15 2.626 Jack W. Lyle Park 1961 Local Park 2 4
9330 9330 9329 {"type": "MultiPolygon", "coordinates": [[[[-122.16628, 37.47667], [-122.16608, 37.47688], [-122.16602, 37.47689], [-122.1655, 37.47659], [-122.16567, 37.47641], [-122.16575, 37.4764], [-122.16598, 37.47653], [-122.166, 37.47651], [-122.16628, 37.47667]]], [[[-122.16607, 37.47699], [-122.16585, 37.47723], [-122.16582, 37.47712], [-122.16563, 37.47701], [-122.16576, 37.47686], [-122.16583, 37.47685], [-122.16607, 37.47699]]]]} Open Access 1 15560 Marketplace Park 21872 1202 Menlo Park, City of 221 City 2 City Agency 2 http://www.menlopark.org/ City 2 1202 Menlo Park, City of 217 City 2 City Agency 2   San Mateo 15 0.67 Marketplace Park 1961 Local Park 2 4
9331 9331 9330 {"type": "Polygon", "coordinates": [[[-122.16632, 37.45965], [-122.16591, 37.45985], [-122.16583, 37.45981], [-122.1657, 37.45978], [-122.16499, 37.45985], [-122.1649, 37.45987], [-122.16476, 37.45983], [-122.16514, 37.45907], [-122.16626, 37.45942], [-122.16632, 37.45965]]]} Open Access 1 15562 Seminary Oaks Park 25295 1202 Menlo Park, City of 221 City 2 City Agency 2 http://www.menlopark.org/ City 2 1202 Menlo Park, City of 217 City 2 City Agency 2   San Mateo 15 1.897 Seminary Oaks Park 1954 Local Park 2 4
9335 9335 9334 {"type": "Polygon", "coordinates": [[[-122.1983, 37.42177], [-122.19813, 37.42169], [-122.19708, 37.42144], [-122.19716, 37.42104], [-122.1972, 37.42101], [-122.19752, 37.42095], [-122.19785, 37.42085], [-122.1979, 37.42086], [-122.19796, 37.42094], [-122.19809, 37.4212], [-122.1983, 37.42177]]]} Open Access 1 15564 Stanford Hills Park 25787 1202 Menlo Park, City of 221 City 2 City Agency 2 http://www.menlopark.org/ City 2 1202 Menlo Park, City of 217 City 2 City Agency 2   San Mateo 15 1.539 Stanford Hills Park 1974 Local Park 2 4
14263 14263 14262 {"type": "Polygon", "coordinates": [[[-122.15988, 37.47944], [-122.15936, 37.47948], [-122.15931, 37.47894], [-122.1598, 37.47876], [-122.15988, 37.47944]]]} Open Access 1 44183 Hamilton Park 19619 1202 Menlo Park, City of 221 City 2 City Agency 2 http://www.menlopark.org/ City 2 1202 Menlo Park, City of 217 City 2 City Agency 2   San Mateo 15 0.765 Hamilton Park 0 Local Park 2 4

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