units_with_maps

Table actions

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

11 rows where DES_TP = 2, MNG_AGENCY = 96 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

  • City Agency · 11 ✖

MNG_AGENCY 1

  • San Mateo, City of · 11 ✖

DES_TP 1

  • Local Park · 11 ✖

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
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
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
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
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
9125 9125 9124 {"type": "Polygon", "coordinates": [[[-122.28747, 37.54971], [-122.28743, 37.54972], [-122.28691, 37.55004], [-122.28681, 37.55003], [-122.28635, 37.54958], [-122.28609, 37.54929], [-122.2869, 37.54882], [-122.28746, 37.54942], [-122.2873, 37.54954], [-122.28747, 37.54971]]]} Open Access 1 15130 Lakeshore Park 20974 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.257 Lakeshore Park 1973 Local Park 2 4
9126 9126 9125 {"type": "Polygon", "coordinates": [[[-122.30914, 37.55926], [-122.30919, 37.55927], [-122.30921, 37.55932], [-122.30909, 37.55976], [-122.30879, 37.55971], [-122.30855, 37.55964], [-122.30909, 37.55927], [-122.30914, 37.55926]]]} Open Access 1 15133 Sunnybrae Park 26005 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.408 Sunnybrae Park 1961 Local Park 2 4
9127 9127 9126 {"type": "Polygon", "coordinates": [[[-122.30455, 37.55525], [-122.30397, 37.55534], [-122.30391, 37.55508], [-122.30448, 37.55498], [-122.30455, 37.55525]]]} Open Access 1 15136 Connie Park 17591 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.389 Connie Park 1961 Local Park 2 4
10066 10066 10065 {"type": "Polygon", "coordinates": [[[-122.31684, 37.53809], [-122.31636, 37.53823], [-122.31625, 37.53818], [-122.31614, 37.53821], [-122.31449, 37.53937], [-122.31379, 37.53974], [-122.31339, 37.53932], [-122.313, 37.53886], [-122.31264, 37.53839], [-122.31231, 37.5379], [-122.31581, 37.53648], [-122.31684, 37.53809]]]} Open Access 1 18917 Beresford Park 16020 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 17.934 Beresford Park 1961 Local Park 2 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

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