units_with_maps

Table actions

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

17 rows where AGNCY_LEV = 2, DES_TP = 2 and MNG_AGENCY = 434

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Bruno, City of · 17 ✖

DES_TP 1

  • Local Park · 17 ✖

ACCESS_TYP 1

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
1869 1869 1868 {"type": "Polygon", "coordinates": [[[-122.40706, 37.62384], [-122.40529, 37.62418], [-122.40408, 37.62412], [-122.40388, 37.62311], [-122.40617, 37.62255], [-122.40706, 37.62384]]]} Open Access 1 14391 Lions Park 21323 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 8.503 Lions Park 1954 Local Park 2 4
3410 3410 3409 {"type": "Polygon", "coordinates": [[[-122.40457, 37.61584], [-122.40447, 37.6159], [-122.40423, 37.61562], [-122.40433, 37.61557], [-122.40457, 37.61584]]]} Open Access 1 24974 Lomita Park 21415 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 0.099 Lomita Park 0 Local Park 2 4
4268 4268 4267 {"type": "Polygon", "coordinates": [[[-122.44874, 37.62685], [-122.44841, 37.6272], [-122.44823, 37.6268], [-122.4477, 37.62634], [-122.44807, 37.62618], [-122.44836, 37.62653], [-122.44874, 37.62685]]]} Open Access 1 14398 Fleetwood Park 18941 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 0.866 Fleetwood Park 1974 Local Park 2 4
4269 4269 4268 {"type": "Polygon", "coordinates": [[[-122.41128, 37.62838], [-122.41128, 37.62838], [-122.41123, 37.62888], [-122.41096, 37.62843], [-122.41128, 37.62838]]]} Open Access 1 14400 Posy Park 23918 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 0.192 Posy Park 1940 Local Park 2 4
5916 5916 5915 {"type": "Polygon", "coordinates": [[[-122.42029, 37.61328], [-122.41977, 37.61352], [-122.42007, 37.61395], [-122.41969, 37.61397], [-122.41819, 37.61396], [-122.41797, 37.61398], [-122.41777, 37.61402], [-122.41683, 37.61437], [-122.41657, 37.61449], [-122.41644, 37.61459], [-122.41627, 37.61474], [-122.41581, 37.61531], [-122.41392, 37.61739], [-122.41261, 37.61578], [-122.41261, 37.61577], [-122.41259, 37.61574], [-122.41283, 37.61557], [-122.41515, 37.61373], [-122.41687, 37.61283], [-122.41984, 37.61265], [-122.42029, 37.61328]]]} Open Access 1 372 San Bruno City Park 24839 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 29.148 San Bruno City Park 1940 Local Park 2 4
6216 6216 6215 {"type": "Polygon", "coordinates": [[[-122.44181, 37.62294], [-122.44167, 37.62295], [-122.44149, 37.62283], [-122.44155, 37.62271], [-122.44171, 37.62265], [-122.44177, 37.62264], [-122.44181, 37.62294]]]} Open Access 1 14396 Glenview Park 19338 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 0.16 Glenview Park 1961 Local Park 2 4
6851 6851 6850 {"type": "Polygon", "coordinates": [[[-122.40576, 37.63377], [-122.40541, 37.63374], [-122.40526, 37.63285], [-122.40564, 37.63282], [-122.40576, 37.63377]]]} Open Access 1 14392 7th Avenue and Walnut Park 15213 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 0.806 7th Avenue and Walnut Park 1940 Local Park 2 4
6970 6970 6969 {"type": "Polygon", "coordinates": [[[-122.40517, 37.62935], [-122.40481, 37.62939], [-122.40477, 37.62877], [-122.40516, 37.62875], [-122.40517, 37.62935]]]} Open Access 1 14394 7th Avenue Park 15214 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 0.556 7th Avenue Park 1940 Local Park 2 4
8817 8817 8816 {"type": "Polygon", "coordinates": [[[-122.47102, 37.63479], [-122.47047, 37.63521], [-122.47012, 37.63544], [-122.46971, 37.63582], [-122.46954, 37.63615], [-122.46925, 37.63595], [-122.46917, 37.63538], [-122.47102, 37.63479]]]} Open Access 1 14370 Ponderosa Park 23888 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 1.786 Ponderosa Park 0 Local Park 2 4
8818 8818 8817 {"type": "Polygon", "coordinates": [[[-122.45546, 37.62882], [-122.45529, 37.63015], [-122.45423, 37.63029], [-122.45384, 37.62946], [-122.45378, 37.62906], [-122.45394, 37.62874], [-122.45546, 37.62882]]]} Open Access 1 14372 Pacific Heights Park 23300 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 5.044 Pacific Heights Park 1974 Local Park 2 4
8819 8819 8818 {"type": "Polygon", "coordinates": [[[-122.45557, 37.62585], [-122.45544, 37.62615], [-122.45525, 37.62639], [-122.45495, 37.62667], [-122.45465, 37.62686], [-122.45436, 37.627], [-122.4541, 37.6271], [-122.45354, 37.62697], [-122.45297, 37.62635], [-122.45256, 37.62599], [-122.45197, 37.62564], [-122.45148, 37.62485], [-122.45146, 37.6245], [-122.45176, 37.62445], [-122.45201, 37.62435], [-122.45244, 37.62481], [-122.45262, 37.62492], [-122.45318, 37.62556], [-122.45423, 37.62495], [-122.45489, 37.62568], [-122.45557, 37.62585]]]} Open Access 1 14373 Portola Highlands Park 23906 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 12.088 Portola Highlands Park 1973 Local Park 2 4
8820 8820 8819 {"type": "Polygon", "coordinates": [[[-122.43382, 37.61531], [-122.43349, 37.6156], [-122.43305, 37.61566], [-122.43269, 37.61549], [-122.4324, 37.61512], [-122.43206, 37.61487], [-122.43185, 37.61512], [-122.43161, 37.61504], [-122.4317, 37.61477], [-122.43161, 37.61395], [-122.43177, 37.61361], [-122.43184, 37.61353], [-122.43276, 37.61364], [-122.43352, 37.61354], [-122.43333, 37.61385], [-122.43326, 37.61435], [-122.43343, 37.61485], [-122.43382, 37.61531]]]} Open Access 1 14374 Buckeye Park 16473 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 7.472 Buckeye Park 1973 Local Park 2 4
8821 8821 8820 {"type": "Polygon", "coordinates": [[[-122.45317, 37.636], [-122.45301, 37.63617], [-122.45292, 37.63612], [-122.45221, 37.63611], [-122.45192, 37.63606], [-122.45158, 37.63592], [-122.45152, 37.63594], [-122.45109, 37.63634], [-122.45104, 37.63637], [-122.44895, 37.63522], [-122.44872, 37.6352], [-122.44836, 37.6352], [-122.45035, 37.63398], [-122.45041, 37.63405], [-122.45039, 37.63412], [-122.45045, 37.63418], [-122.45023, 37.63432], [-122.45122, 37.63533], [-122.45136, 37.63546], [-122.45154, 37.63557], [-122.45174, 37.63566], [-122.45195, 37.63573], [-122.45216, 37.63577], [-122.45253, 37.6358], [-122.45285, 37.63585], [-122.453, 37.63589], [-122.45317, 37.636]]]} Open Access 1 14376 Monte Verde Park 22394 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 8.743 Monte Verde Park 0 Local Park 2 4
8822 8822 8821 {"type": "Polygon", "coordinates": [[[-122.42194, 37.622], [-122.4215, 37.62222], [-122.42162, 37.62242], [-122.42145, 37.62256], [-122.42119, 37.62223], [-122.42061, 37.62251], [-122.42024, 37.62264], [-122.41996, 37.62266], [-122.41963, 37.62259], [-122.41939, 37.62267], [-122.41924, 37.62244], [-122.41996, 37.62208], [-122.42005, 37.62219], [-122.42119, 37.6216], [-122.42132, 37.62174], [-122.42164, 37.62158], [-122.42194, 37.622]]]} Open Access 1 14378 Grundy Park 19538 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 3.346 Grundy Park 1961 Local Park 2 4
8823 8823 8822 {"type": "Polygon", "coordinates": [[[-122.42713, 37.63088], [-122.42488, 37.63158], [-122.42457, 37.63098], [-122.42672, 37.63018], [-122.42713, 37.63088]]]} Open Access 1 14380 Commodore Park 17559 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 4.115 Commodore Park 1974 Local Park 2 4
8824 8824 8823 {"type": "Polygon", "coordinates": [[[-122.41852, 37.63269], [-122.4172, 37.63337], [-122.4159, 37.63383], [-122.41435, 37.63404], [-122.41411, 37.63403], [-122.41415, 37.63398], [-122.41494, 37.63392], [-122.41593, 37.63353], [-122.41759, 37.63292], [-122.4185, 37.6325], [-122.41852, 37.63269]]]} Open Access 1 14381 Forest Lane Park 18996 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 2.178 Forest Lane Park 1962 Local Park 2 4
8827 8827 8826 {"type": "Polygon", "coordinates": [[[-122.41488, 37.63785], [-122.41485, 37.63819], [-122.41445, 37.63825], [-122.41428, 37.6379], [-122.41488, 37.63785]]]} Open Access 1 14389 Bayshore Circle Park 15891 1294 San Bruno, City of 440 City 2 City Agency 2 http://www.sanbruno.ca.gov/parks_main.html City 2 1294 San Bruno, City of 434 City 2 City Agency 2   San Mateo 15 0.435 Bayshore Circle 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]);