Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47 | 47 | 17325 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 150 Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/31/2016 12:00:00 AM | 3 | 3x3 | 6006651.4447 | 2108878.4679400004 | 37.7709543699737 | -122.420355751511 | (37.7709543699737, -122.420355751511) | ||
10495 | 10495 | 986 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 1634 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6001643.13591 | 2092619.68288 | 37.7260281147961 | -122.436515696352 | (37.7260281147961, -122.436515696352) | |||
10728 | 10728 | 22543 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 1416X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X6 | 6002329.27888 | 2093769.4237799998 | 37.7292240094582 | -122.434225904616 | (37.7292240094582, -122.434225904616) | |||
10870 | 10870 | 22542 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 1416X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X6 | 6002345.30363 | 2093794.47674 | 37.7292937087186 | -122.43417229601499 | (37.7292937087186, -122.434172296015) | |||
11684 | 11684 | 989 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 1654 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6001587.11696 | 2092507.46593 | 37.725716809081604 | -122.436701320907 | (37.7257168090816, -122.436701320907) | |||
17650 | 17650 | 17327 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 150 Otis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006652.60436 | 2108850.55128 | 37.7708777828196 | -122.420349758438 | (37.7708777828196, -122.420349758438) | |||
19584 | 19584 | 17328 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 150 Otis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006653.987869999 | 2108819.46705 | 37.7707925108849 | -122.420342766214 | (37.7707925108849, -122.420342766214) | |||
21084 | 21084 | 17329 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 150 Otis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006657.292 | 2108797.5447400003 | 37.77073250362729 | -122.42032978092199 | (37.7707325036273, -122.420329780922) | |||
23336 | 23336 | 17326 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 150 Otis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/2015 12:00:00 AM | 24 | 3X3 | 6006652.92291 | 2108866.0729799997 | 37.770920419662794 | -122.420349758429 | (37.7709204196628, -122.420349758429) | ||
27983 | 27983 | 112232 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 5999559.4748 | 2111943.9518 | 37.7789692179466 | -122.44510740551901 | (37.7789692179466, -122.445107405519) | |||
28575 | 28575 | 112217 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999859.3165 | 2111987.2698 | 37.7791052675019 | -122.44407324969801 | (37.7791052675019, -122.444073249698) | |||
31336 | 31336 | 112207 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6000150.3593 | 2112028.2188 | 37.7792343016328 | -122.44306935884899 | (37.7792343016328, -122.443069358849) | |||
33561 | 33561 | 112199 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6000361.5345 | 2112057.6615 | 37.779327182073395 | -122.44234093295799 | (37.7793271820734, -122.442340932958) | |||
34004 | 34004 | 112228 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999656.6019 | 2111958.8423 | 37.779015646658394 | -122.44477247571501 | (37.7790156466584, -122.444772475715) | |||
38659 | 38659 | 112219 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999801.7848 | 2111978.4708 | 37.7790778255592 | -122.444271642134 | (37.7790778255592, -122.444271642134) | |||
39731 | 39731 | 112221 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999767.2658 | 2111975.0866 | 37.779066563967206 | -122.444390813692 | (37.7790665639672, -122.444390813692) | |||
39897 | 39897 | 112227 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999670.4772 | 2111960.8729 | 37.7790220139758 | -122.44472462161998 | (37.7790220139758, -122.44472462162) | |||
44460 | 44460 | 112222 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999751.0216 | 2111973.3945 | 37.7790609910565 | -122.444446887136 | (37.7790609910565, -122.444446887136) | |||
47041 | 47041 | 112205 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6000191.9852 | 2112033.972 | 37.7792524717433 | -122.44292577135599 | (37.7792524717433, -122.442925771356) | |||
47523 | 47523 | 112220 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999785.2022 | 2111976.4403 | 37.7790713042385 | -122.444328861929 | (37.7790713042385, -122.444328861929) | |||
48233 | 48233 | 112203 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6000273.8832 | 2112045.1399 | 37.7792878048325 | -122.442643255191 | (37.7792878048325, -122.442643255191) | |||
48426 | 48426 | 112230 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999608.2076 | 2111950.3818 | 37.77898965446521 | -122.444939282166 | (37.7789896544652, -122.444939282166) | |||
57247 | 57247 | 112208 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6000131.4077 | 2112027.2035 | 37.7792304332977 | -122.443134847125 | (37.7792304332977, -122.443134847125) | |||
59458 | 59458 | 112216 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999876.9145 | 2111991.6693 | 37.779118351288204 | -122.444012687447 | (37.7791183512882, -122.444012687447) | |||
60187 | 60187 | 112229 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999625.4671 | 2111952.4123 | 37.778996214713004 | -122.444879720826 | (37.778996214713, -122.444879720826) | |||
60436 | 60436 | 112231 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999586.5486 | 2111947.336 | 37.778980055338295 | -122.44501399007 | (37.7789800553383, -122.44501399007) | |||
74479 | 74479 | 112233 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999535.7853 | 2111942.5981 | 37.778964148885706 | -122.44518925935499 | (37.7789641488857, -122.445189259355) | |||
82743 | 82743 | 93379 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 3066 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996271.089980001 | 2111490.88446 | 37.7775369752727 | -122.45645040737101 | (37.7775369752727, -122.456450407371) | ||
126632 | 126632 | 4236 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 4015 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003796.178919099 | 2100385.9218973 | 37.7474745521244 | -122.42962640666799 | (37.7474745521244, -122.429626406668) | |||
131017 | 131017 | 112212 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6000031.5732 | 2112011.6361 | 37.779181996245605 | -122.443479096263 | (37.7791819962456, -122.443479096263) | |||
131502 | 131502 | 112210 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6000061.0159 | 2112016.0356 | 37.7791957551898 | -122.443377558283 | (37.7791957551898, -122.443377558283) | |||
135084 | 135084 | 112226 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999690.1056 | 2111964.2571 | 37.779032426205795 | -122.444656962607 | (37.7790324262058, -122.444656962607) | |||
135581 | 135581 | 112201 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6000313.4786 | 2112051.2315 | 37.779306787844604 | -122.44250671611799 | (37.7793067878446, -122.442506716118) | |||
136249 | 136249 | 112225 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999706.3499 | 2111966.626 | 37.77903985754121 | -122.44460093751199 | (37.7790398575412, -122.444600937512) | |||
136269 | 136269 | 112204 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6000217.3668 | 2112038.0330000003 | 37.7792650692531 | -122.44283825785 | (37.7792650692531, -122.44283825785) | |||
136544 | 136544 | 112214 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999912.7872 | 2111996.4072 | 37.779133406627494 | -122.443888930048 | (37.7791334066275, -122.443888930048) | |||
156126 | 156126 | 112211 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6000045.7869 | 2112014.0051 | 37.7791893114958 | -122.443430095603 | (37.7791893114958, -122.443430095603) | |||
164918 | 164918 | 112209 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6000086.7360000005 | 2112020.0967 | 37.779208372612096 | -122.44328887392 | (37.7792083726121, -122.44328887392) | |||
168403 | 168403 | 112200 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 6000341.5676 | 2112055.2926 | 37.779319539633605 | -122.442409836485 | (37.7793195396336, -122.442409836485) | |||
168737 | 168737 | 112206 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6000170.3262 | 2112030.9262 | 37.779242873892606 | -122.443000479785 | (37.7792428738926, -122.443000479785) | |||
174469 | 174469 | 112234 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999518.8642 | 2111940.5676 | 37.7789576077977 | -122.445247649985 | (37.7789576077977, -122.445247649985) | |||
175320 | 175320 | 112224 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999721.5789 | 2111968.3181 | 37.7790453725975 | -122.444548376071 | (37.7790453725975, -122.444548376071) | |||
176847 | 176847 | 112215 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999896.5429 | 2111994.715 | 37.7791278336753 | -122.443945003918 | (37.7791278336753, -122.443945003918) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");