units_with_maps

Table actions

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

283 rows where COUNTY = 15 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 283 ✖
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
150 150 149 {"type": "Polygon", "coordinates": [[[-122.37823, 37.65795], [-122.37809, 37.65808], [-122.37717, 37.65723], [-122.37692, 37.65689], [-122.37681, 37.65671], [-122.37658, 37.65623], [-122.37649, 37.65598], [-122.37644, 37.65557], [-122.37631, 37.65525], [-122.37614, 37.65507], [-122.37557, 37.65506], [-122.37555, 37.65493], [-122.3765, 37.65493], [-122.37663, 37.65527], [-122.37674, 37.65581], [-122.37692, 37.65629], [-122.37762, 37.65744], [-122.37776, 37.65752], [-122.37823, 37.65795]]]} Open Access 1 388 San Bruno Point Park 24841 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 2.521 San Bruno Point Park 0 Local Park 2 4
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
525 525 524 {"type": "Polygon", "coordinates": [[[-122.28056, 37.51666], [-122.27928, 37.5168], [-122.27927, 37.51676], [-122.27901, 37.5168], [-122.2788, 37.51686], [-122.27858, 37.51694], [-122.27812, 37.5172], [-122.27801, 37.51738], [-122.2779, 37.51753], [-122.27782, 37.51767], [-122.27777, 37.51779], [-122.27768, 37.51815], [-122.27757, 37.51845], [-122.2773, 37.5182], [-122.27733, 37.51818], [-122.27729, 37.51815], [-122.27737, 37.51806], [-122.27653, 37.5173], [-122.27651, 37.5173], [-122.27646, 37.51725], [-122.27647, 37.51723], [-122.27643, 37.5172], [-122.27659, 37.51717], [-122.27668, 37.51694], [-122.27696, 37.51665], [-122.27662, 37.5163], [-122.27952, 37.5138], [-122.28056, 37.51666]]]} Open Access 1 1741 Twin Pines Park 26622 1025 Belmont, City of 198 City 2 City Agency 2 http://www.belmont.gov/city-hall/park-and-recreation City 2 1025 Belmont, City of 194 City 2 City Agency 2   San Mateo 15 19.848 Twin Pines Park 1973 Local Park 2 4
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
1597 1597 1596 {"type": "Polygon", "coordinates": [[[-122.27259, 37.52352], [-122.2725, 37.52374], [-122.27206, 37.52424], [-122.27191, 37.52437], [-122.27175, 37.52449], [-122.27154, 37.52459], [-122.2713, 37.52468], [-122.27109, 37.52473], [-122.27253, 37.52348], [-122.27259, 37.52352]]]} Open Access 1 13500 O'Donnell Park 22947 1025 Belmont, City of 198 City 2 City Agency 2 http://www.belmont.gov/city-hall/park-and-recreation City 2 1025 Belmont, City of 194 City 2 City Agency 2   San Mateo 15 0.889 O'Donnell Park 1961 Local Park 2 4
1598 1598 1597 {"type": "Polygon", "coordinates": [[[-122.37011, 37.58959], [-122.36989, 37.58982], [-122.36931, 37.58952], [-122.36955, 37.58926], [-122.37011, 37.58959]]]} Open Access 1 13512 Laguna Park 20864 1039 Burlingame, City of 390 City 2 City Agency 2 http://www.burlingame.org/index.aspx?page=33 City 2 1039 Burlingame, City of 384 City 2 City Agency 2   San Mateo 15 0.505 Laguna Park 1931 Local Park 2 4
1627 1627 1626 {"type": "Polygon", "coordinates": [[[-122.2018, 37.48289], [-122.20065, 37.48477], [-122.20046, 37.48474], [-122.20042, 37.48472], [-122.20037, 37.48466], [-122.20038, 37.48459], [-122.20146, 37.48281], [-122.2016, 37.48286], [-122.20164, 37.48282], [-122.2018, 37.48289]]]} Open Access 1 13912 Andrew Spinas Park 15485 1271 Redwood City, City of 397 City 2 City Agency 2 http://www.redwoodcity.org/parks/ City 2 1271 Redwood City, City of 391 City 2 City Agency 2   San Mateo 15 1.759 Andrew Spinas Park 1966 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  
1659 1659 1658 {"type": "Polygon", "coordinates": [[[-122.39721, 37.59372], [-122.39652, 37.59394], [-122.39638, 37.594], [-122.39628, 37.59398], [-122.39625, 37.59395], [-122.39607, 37.59348], [-122.39603, 37.59323], [-122.39648, 37.59325], [-122.39668, 37.59314], [-122.39721, 37.59372]]]} Open Access 1 14302 Rotary Park 24691 1205 Millbrae, City of 404 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 1205 Millbrae, City of 398 City 2 City Agency 2   San Mateo 15 1.461 Rotary Park 1961 Local Park 2 4
1693 1693 1692 {"type": "Polygon", "coordinates": [[[-122.49248, 37.63035], [-122.49247, 37.63053], [-122.49221, 37.63053], [-122.49218, 37.63034], [-122.49248, 37.63035]]]} Open Access 1 14655 Palmetto Mini Park 23354 1239 Pacifica, City of 409 City 2 City Agency 2 http://www.cityofpacifica.org/depts/rec_department/default.asp City 2 1239 Pacifica, City of 403 City 2 City Agency 2   San Mateo 15 0.124 Palmetto MP 0 Local Park 2 4
1768 1768 1767 {"type": "Polygon", "coordinates": [[[-122.45497, 37.66843], [-122.45478, 37.66855], [-122.4547, 37.66847], [-122.45464, 37.66833], [-122.45454, 37.66839], [-122.45421, 37.6682], [-122.45421, 37.66809], [-122.45418, 37.668], [-122.45447, 37.66792], [-122.45403, 37.66686], [-122.45429, 37.6668], [-122.45497, 37.66843]]]} Open Access 1 15288 Winston Manor Park 27651 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 1.481 Winston Manor Park 0 Local Park 2 4
1789 1789 1788 {"type": "Polygon", "coordinates": [[[-122.29403, 37.50902], [-122.29314, 37.50954], [-122.29231, 37.50864], [-122.29321, 37.50812], [-122.29358, 37.50853], [-122.29389, 37.50835], [-122.2939, 37.50837], [-122.2936, 37.50855], [-122.29403, 37.50902]]]} Open Access 1 13487 Belameda Park 15963 1025 Belmont, City of 198 City 2 City Agency 2 http://www.belmont.gov/city-hall/park-and-recreation City 2 1025 Belmont, City of 194 City 2 City Agency 2   San Mateo 15 3.025 Belameda Park 1960 Local Park 2 4
1794 1794 1793 {"type": "Polygon", "coordinates": [[[-122.37855, 37.58883], [-122.37806, 37.5894], [-122.37803, 37.58941], [-122.37753, 37.58916], [-122.37733, 37.5891], [-122.37692, 37.58903], [-122.37678, 37.58897], [-122.37657, 37.58885], [-122.37674, 37.58868], [-122.37666, 37.5885], [-122.37681, 37.58814], [-122.37681, 37.58797], [-122.37705, 37.5877], [-122.3772, 37.58779], [-122.37775, 37.58781], [-122.37794, 37.58779], [-122.37754, 37.58828], [-122.37855, 37.58883]]]} Open Access 1 13508 Ray Park 24204 1039 Burlingame, City of 390 City 2 City Agency 2 http://www.burlingame.org/index.aspx?page=33 City 2 1039 Burlingame, City of 384 City 2 City Agency 2   San Mateo 15 4.291 Ray Park 1941 Local Park 2 4
1809 1809 1808 {"type": "Polygon", "coordinates": [[[-122.46028, 37.70064], [-122.46009, 37.70065], [-122.45961, 37.70111], [-122.45957, 37.70032], [-122.46026, 37.70029], [-122.46028, 37.70064]]]} Open Access 1 15603 Edgewood Park 18440 1078 Daly City, City of 427 City 2 City Agency 2 http://www.dalycity.org/ City 2 1078 Daly City, City of 421 City 2 City Agency 2   San Mateo 15 0.854 Edgewood Park 0 Local Park 2 4
1831 1831 1830 {"type": "Polygon", "coordinates": [[[-122.25021, 37.5256], [-122.24964, 37.5261], [-122.2493, 37.52562], [-122.24918, 37.52553], [-122.24903, 37.52546], [-122.2489, 37.52543], [-122.24873, 37.52543], [-122.24826, 37.52554], [-122.24808, 37.52556], [-122.24787, 37.52556], [-122.2478, 37.52546], [-122.24787, 37.52541], [-122.24792, 37.52534], [-122.24799, 37.52472], [-122.24796, 37.52444], [-122.24786, 37.52424], [-122.24781, 37.5241], [-122.24779, 37.52394], [-122.2478, 37.52381], [-122.24792, 37.52383], [-122.24796, 37.524], [-122.24805, 37.52413], [-122.24924, 37.52518], [-122.24939, 37.52527], [-122.24954, 37.52533], [-122.24994, 37.52541], [-122.25021, 37.5256]]]} Open Access 1 13927 Mariner Park 21853 1271 Redwood City, City of 397 City 2 City Agency 2 http://www.redwoodcity.org/parks/ City 2 1271 Redwood City, City of 391 City 2 City Agency 2   San Mateo 15 4.052 Mariner Park 1978 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  
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  

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