units_with_maps

Table actions

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

35 rows where ACCESS_TYP = 1, AGNCY_WEB = "http://www.cityofpaloalto.org/", MNG_AGENCY = 157 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 35 ✖
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
396 396 395 {"type": "Polygon", "coordinates": [[[-122.13963, 37.41148], [-122.13861, 37.41094], [-122.13867, 37.41065], [-122.1386, 37.41047], [-122.13841, 37.41035], [-122.13814, 37.41004], [-122.13828, 37.40965], [-122.13811, 37.40928], [-122.13786, 37.40907], [-122.13807, 37.40875], [-122.13818, 37.40851], [-122.13834, 37.40845], [-122.13963, 37.41148]]]} Open Access 1 1442 Bol Park 16235 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 4.248 Bol Park 1974 Local Park 2 4
453 453 452 {"type": "Polygon", "coordinates": [[[-122.12673, 37.40193], [-122.12661, 37.40184], [-122.12648, 37.40197], [-122.12604, 37.40189], [-122.12565, 37.40208], [-122.12556, 37.40226], [-122.12552, 37.40242], [-122.1254, 37.40246], [-122.12533, 37.40254], [-122.12512, 37.40323], [-122.12444, 37.40294], [-122.1239, 37.40228], [-122.12396, 37.40223], [-122.12422, 37.40168], [-122.12432, 37.40153], [-122.12442, 37.40133], [-122.12661, 37.40112], [-122.12673, 37.40193]]]} Open Access 1 1453 Terman Park 26250 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 7.663 Terman Park 1985 Local Park 2 4
536 536 535 {"type": "Polygon", "coordinates": [[[-122.15574, 37.44328], [-122.1555, 37.44352], [-122.15524, 37.44335], [-122.15548, 37.44311], [-122.15574, 37.44328]]]} Open Access 1 15226 Scott Park 25205 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 0.258 Scott Park 1973 Local Park 2 4
1765 1765 1764 {"type": "Polygon", "coordinates": [[[-122.1633, 37.4461], [-122.16283, 37.44657], [-122.16208, 37.4461], [-122.16255, 37.44562], [-122.1633, 37.4461]]]} Open Access 1 15229 Cogswell Plaza 17477 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 1.403 Cogswell Plaza 1924 Local Park 2 4
2017 2017 2016 {"type": "Polygon", "coordinates": [[[-122.13014, 37.43015], [-122.12886, 37.43144], [-122.12794, 37.43085], [-122.12807, 37.4307], [-122.12758, 37.43039], [-122.1287, 37.42924], [-122.13014, 37.43015]]]} Open Access 1 16985 Hoover Park 20080 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 7.014 Hoover Park 1955 Local Park 2 4
2338 2338 2337 {"type": "Polygon", "coordinates": [[[-122.14194, 37.42969], [-122.14151, 37.43021], [-122.14024, 37.42941], [-122.14023, 37.42936], [-122.1402, 37.42933], [-122.14013, 37.42931], [-122.14006, 37.42934], [-122.13997, 37.42927], [-122.14047, 37.4293], [-122.14063, 37.42925], [-122.14078, 37.42913], [-122.14088, 37.42912], [-122.14194, 37.42969]]]} Open Access 1 17054 J. Bowden Park 20291 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 2.088 J. Bowden Park 1952 Local Park 2 4
2347 2347 2346 {"type": "Polygon", "coordinates": [[[-122.16402, 37.44949], [-122.16354, 37.44998], [-122.16245, 37.44929], [-122.16293, 37.4488], [-122.16402, 37.44949]]]} Open Access 1 17102 Johnson Park 20478 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 2.092 Johnson Park 1968 Local Park 2 4
2597 2597 2596 {"type": "Polygon", "coordinates": [[[-122.11693, 37.42294], [-122.11586, 37.42351], [-122.11509, 37.42259], [-122.11452, 37.42289], [-122.11398, 37.42225], [-122.11284, 37.42285], [-122.11264, 37.42273], [-122.11246, 37.42258], [-122.11211, 37.42217], [-122.11336, 37.42152], [-122.11299, 37.42106], [-122.11332, 37.42087], [-122.11344, 37.42076], [-122.11353, 37.42064], [-122.11343, 37.4206], [-122.11335, 37.42071], [-122.11324, 37.42081], [-122.11293, 37.42099], [-122.11243, 37.42038], [-122.11336, 37.41989], [-122.11345, 37.42002], [-122.11351, 37.42022], [-122.11352, 37.42035], [-122.11346, 37.42054], [-122.11356, 37.42058], [-122.11361, 37.42043], [-122.11362, 37.42021], [-122.11355, 37.41999], [-122.11345, 37.41984], [-122.11408, 37.41951], [-122.11693, 37.42294]]]} Open Access 1 17952 Mitchell Park 22324 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 20.856 Mitchell Park 1952 Local Park 2 4
3277 3277 3276 {"type": "Polygon", "coordinates": [[[-122.1276, 37.47289], [-122.1263, 37.47477], [-122.12365, 37.4757], [-122.12364, 37.4744], [-122.12355, 37.47442], [-122.12354, 37.47435], [-122.12325, 37.47442], [-122.12322, 37.47422], [-122.1232, 37.47247], [-122.1217, 37.47234], [-122.12044, 37.47011], [-122.11894, 37.46936], [-122.1178, 37.46885], [-122.1166, 37.46744], [-122.11616, 37.46674], [-122.11562, 37.46613], [-122.11646, 37.46595], [-122.11693, 37.46561], [-122.11769, 37.46539], [-122.11935, 37.4644], [-122.12374, 37.46164], [-122.12382, 37.46146], [-122.12483, 37.46429], [-122.12594, 37.46698], [-122.1276, 37.47289]]]} Open Access 1 23137 Baylands Preserve 8356 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2 http://www.cityofpaloalto.org/gov/depts/csd/parks/preserves/baylands.asp San Mateo 15 193.549 Baylands Preserve 1944 Local Conservation Area 4 2
3792 3792 3791 {"type": "Polygon", "coordinates": [[[-122.16264, 37.4447], [-122.16245, 37.44488], [-122.16218, 37.44471], [-122.16237, 37.44453], [-122.16264, 37.4447]]]} Open Access 1 47056 Lytton Plaza 30706 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 0.195 Lytton Plaza 0 Local Park 2 4
4106 4106 4105 {"type": "Polygon", "coordinates": [[[-122.15743, 37.44385], [-122.15664, 37.44464], [-122.15607, 37.44428], [-122.15714, 37.4432], [-122.15737, 37.44334], [-122.15709, 37.44364], [-122.15743, 37.44385]]]} Open Access 1 47047 Heritage Park 30697 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 2.057 Heritage Park 0 Local Park 2 4
4110 4110 4109 {"type": "Polygon", "coordinates": [[[-122.12438, 37.45281], [-122.12411, 37.45285], [-122.12288, 37.45323], [-122.12265, 37.4533], [-122.12237, 37.45344], [-122.12221, 37.45356], [-122.12202, 37.45376], [-122.12188, 37.454], [-122.12182, 37.45426], [-122.12182, 37.45448], [-122.12097, 37.45356], [-122.1202, 37.45301], [-122.11907, 37.45273], [-122.12031, 37.45188], [-122.12045, 37.45182], [-122.12362, 37.45227], [-122.12392, 37.45261], [-122.12438, 37.45281]]]} Open Access 1 47071 Baylands Athletic Center 30722 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 14.189 Baylands Athletic Ctr. 0 Local Recreation Area 3 4
5288 5288 5287 {"type": "Polygon", "coordinates": [[[-122.11692, 37.40842], [-122.1165, 37.40846], [-122.11652, 37.40809], [-122.11656, 37.40805], [-122.11627, 37.40786], [-122.11635, 37.40778], [-122.1164, 37.40776], [-122.11644, 37.40777], [-122.11701, 37.40812], [-122.11702, 37.40816], [-122.11694, 37.40829], [-122.11692, 37.40842]]]} Open Access 1 15201 Monroe Mini Park 22373 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 0.62 Monroe MP 1974 Local Park 2 4
5829 5829 5828 {"type": "MultiPolygon", "coordinates": [[[[-122.14058, 37.44459], [-122.14058, 37.44487], [-122.14054, 37.44488], [-122.14054, 37.44511], [-122.13985, 37.44511], [-122.13986, 37.44459], [-122.14058, 37.44459]]], [[[-122.14425, 37.44411], [-122.14416, 37.44423], [-122.14415, 37.44446], [-122.13986, 37.44445], [-122.13986, 37.44359], [-122.14025, 37.44358], [-122.14023, 37.44309], [-122.14166, 37.44267], [-122.14173, 37.44278], [-122.14184, 37.44285], [-122.14186, 37.44298], [-122.14188, 37.44303], [-122.14203, 37.44315], [-122.14207, 37.44321], [-122.14209, 37.44331], [-122.14207, 37.44337], [-122.14202, 37.44343], [-122.14205, 37.4435], [-122.14226, 37.44365], [-122.14277, 37.44372], [-122.14367, 37.44367], [-122.14368, 37.44363], [-122.14396, 37.44364], [-122.14402, 37.44378], [-122.14423, 37.44394], [-122.14425, 37.44411]]]]} Open Access 1 158 Rinconada Park 24372 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 12.601 Rinconada Park 1922 Local Park 2 4
6404 6404 6403 {"type": "Polygon", "coordinates": [[[-122.13545, 37.42156], [-122.13539, 37.42163], [-122.13501, 37.42143], [-122.13497, 37.42147], [-122.13433, 37.42114], [-122.13446, 37.42098], [-122.13477, 37.42113], [-122.13515, 37.42068], [-122.1353, 37.42076], [-122.13529, 37.42096], [-122.13531, 37.42112], [-122.13535, 37.42128], [-122.13545, 37.42156]]]} Open Access 1 1989 Boulware Park 16300 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 1.094 Boulware Park 1965 Local Park 2 4
6796 6796 6795 {"type": "Polygon", "coordinates": [[[-122.168, 37.44966], [-122.1679, 37.45019], [-122.16792, 37.45081], [-122.16731, 37.45104], [-122.16636, 37.4508], [-122.16592, 37.45103], [-122.16577, 37.45165], [-122.16545, 37.45228], [-122.16541, 37.45294], [-122.16474, 37.453], [-122.16422, 37.45261], [-122.16385, 37.45288], [-122.16347, 37.45324], [-122.16297, 37.45348], [-122.16226, 37.45406], [-122.16154, 37.45412], [-122.16082, 37.45422], [-122.16066, 37.45458], [-122.15943, 37.45465], [-122.15886, 37.45421], [-122.15834, 37.4536], [-122.15739, 37.45358], [-122.15695, 37.45407], [-122.15629, 37.45426], [-122.15563, 37.4545], [-122.1557, 37.45494], [-122.15599, 37.45547], [-122.15528, 37.45588], [-122.15456, 37.45616], [-122.15335, 37.45693], [-122.15259, 37.45766], [-122.15214, 37.45766], [-122.15168, 37.45714], [-122.15034, 37.45721], [-122.15106, 37.45697], [-122.15184, 37.45683], [-122.15246, 37.45695], [-122.15328, 37.45627], [-122.15437, 37.45554], [-122.15536, 37.45512], [-122.15507, 37.45446], [-122.15588, 37.45378], [-122.15644, 37.45373], [-122.15705, 37.45336], [-122.15777, 37.45335], [-122.15911, 37.45337], [-122.1597, 37.4542], [-122.16008, 37.45415], [-122.16063, 37.45383], [-122.16124, 37.45351], [-122.16258, 37.45357], [-122.16274, 37.45335], [-122.16312, 37.45294], [-122.16378, 37.45248], [-122.16439, 37.45238], [-122.16494, 37.45215], [-122.16557, 37.45081], [-122.1665, 37.45017], [-122.16691, 37.45061], [-122.16741, 37.45055], [-122.16756, 37.45006], [-122.1676, 37.44958], [-122.16726, 37.44914], [-122.16736, 37.44891], [-122.16773, 37.44828], [-122.16781, 37.44895], [-122.16782, 37.44926], [-122.168, 37.44966]]]} Open Access 1 5305 Timothy Hopkins Park 26372 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 27.327 Timothy Hopkins Park 1907 Local Park 2 4
6798 6798 6797 {"type": "Polygon", "coordinates": [[[-122.1208, 37.44259], [-122.11901, 37.44439], [-122.11896, 37.44441], [-122.1189, 37.44441], [-122.11862, 37.44417], [-122.11799, 37.44357], [-122.11805, 37.4426], [-122.11636, 37.44099], [-122.11573, 37.44141], [-122.11564, 37.44127], [-122.1153, 37.44058], [-122.11656, 37.43987], [-122.11739, 37.44054], [-122.11754, 37.44057], [-122.11798, 37.44033], [-122.11805, 37.44037], [-122.11773, 37.44055], [-122.11772, 37.44057], [-122.1182, 37.44095], [-122.1208, 37.44259]]]} Open Access 1 5308 John Lucas Greer Park 20452 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 21.478 John Lucas Greer Park 1963 Local Park 2 4
8830 8830 8829 {"type": "Polygon", "coordinates": [[[-122.1431, 37.44885], [-122.14308, 37.45144], [-122.14138, 37.4509], [-122.14138, 37.44884], [-122.1431, 37.44885]]]} Open Access 1 16038 Eleanor Pardee Park 18556 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 9.675 Eleanor Pardee Park 1920 Local Park 2 4
9002 9002 9001 {"type": "Polygon", "coordinates": [[[-122.12346, 37.41546], [-122.12335, 37.41556], [-122.12328, 37.41552], [-122.12251, 37.4162], [-122.12163, 37.41564], [-122.12112, 37.41537], [-122.12212, 37.41449], [-122.12346, 37.41546]]]} Open Access 1 15199 Robles Park 24505 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 4.691 Robles Park 1956 Local Park 2 4
9151 9151 9150 {"type": "Polygon", "coordinates": [[[-122.11949, 37.43603], [-122.11883, 37.4365], [-122.11853, 37.43631], [-122.11853, 37.43626], [-122.11849, 37.43621], [-122.11834, 37.43619], [-122.11789, 37.4359], [-122.11827, 37.43551], [-122.11815, 37.43543], [-122.11819, 37.43539], [-122.11819, 37.43538], [-122.11756, 37.43498], [-122.11798, 37.43455], [-122.11906, 37.43523], [-122.1193, 37.43501], [-122.11938, 37.43506], [-122.11892, 37.43552], [-122.11946, 37.43587], [-122.11938, 37.43595], [-122.11949, 37.43603]]]} Open Access 1 15197 Seale Park 25243 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 4.257 Seale Park 1955 Local Park 2 4

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