Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 870 | 870 | 117001 | DPW Maintained 3 | :: 54 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 5230 | 5230 | 253826 | Permitted Site 1 | :: 54 | 701 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 138801 | 138801 | 115762 | Undocumented 2 | :: 54 | 84X Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | on Athens Street frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | |||
| 28625 | 28625 | 217557 | Undocumented 2 | :: 54 | 111 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5995778.3452 | 2088036.9975 | 37.7131101315221 | -122.456458551068 | (37.7131101315221, -122.456458551068) | |||
| 119252 | 119252 | 116340 | Undocumented 2 | :: 54 | 201X Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5993755.0695 | 2088847.02637 | 37.715217913096104 | -122.463510368547 | (37.7152179130961, -122.463510368547) | |||||
| 139436 | 139436 | 35137 | Permitted Site 1 | :: 54 | 832 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38668 | 6002000.93226273 | 2088942.9752097 | 37.7159530242515 | -122.435015979431 | (37.7159530242515, -122.435015979431) | ||
| 121386 | 121386 | 108949 | Permitted Site 1 | :: 54 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6003932.1 | 2088992.0 | 37.716197100768596 | -122.42834444974702 | (37.7161971007686, -122.428344449747) | |||
| 10139 | 10139 | 173867 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
| 140174 | 140174 | 31188 | Permitted Site 1 | :: 54 | 744 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
| 165416 | 165416 | 200238 | Undocumented 2 | :: 54 | 917 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014595.9922 | 2089500.6344 | 37.7181913669776 | -122.391520156023 | (37.7181913669776, -122.391520156023) | |||
| 177805 | 177805 | 200235 | Undocumented 2 | :: 54 | 923 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014534.9569 | 2089547.5847 | 37.7183168953073 | -122.39173441165 | (37.7183168953073, -122.39173441165) | |||
| 73420 | 73420 | 200232 | Undocumented 2 | :: 54 | 923 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014491.3602 | 2089577.767 | 37.7183973497527 | -122.391887217647 | (37.7183973497527, -122.391887217647) | |||
| 33211 | 33211 | 200211 | Undocumented 2 | :: 54 | 974 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014078.3317 | 2089599.8969999999 | 37.7184351760665 | -122.39331644356001 | (37.7184351760665, -122.39331644356) | |||
| 176910 | 176910 | 200204 | Undocumented 2 | :: 54 | 2 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014372.6432 | 2089670.326 | 37.71864490712711 | -122.392304046142 | (37.7186449071271, -122.392304046142) | |||
| 177358 | 177358 | 200205 | Undocumented 2 | :: 54 | 1003 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014813.9755 | 2089679.7161 | 37.71869518696921 | -122.39077918277701 | (37.7186951869692, -122.390779182777) | |||
| 182449 | 182449 | 200194 | Undocumented 2 | :: 54 | 1011 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014781.1104 | 2089713.2519999999 | 37.718785446443206 | -122.390895127615 | (37.7187854464432, -122.390895127615) | |||
| 147039 | 147039 | 200193 | Undocumented 2 | :: 54 | 975 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014303.5592 | 2089724.6542 | 37.7187902452961 | -122.392546641558 | (37.7187902452961, -122.392546641558) | |||
| 179207 | 179207 | 200191 | Undocumented 2 | :: 54 | 981 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014255.2675 | 2089757.5194 | 37.7188778046353 | -122.39271586587799 | (37.7188778046353, -122.392715865878) | |||
| 80004 | 80004 | 35095 | Permitted Site 1 | :: 54 | 647 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38637 | 6002415.60861753 | 2090011.70468142 | 37.718911055862606 | -122.43365900206499 | (37.7189110558626, -122.433659002065) | ||
| 179075 | 179075 | 200190 | Undocumented 2 | :: 54 | 1027 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014706.6607 | 2089771.6044 | 37.7189415394071 | -122.391156549139 | (37.7189415394071, -122.391156549139) | |||
| 55366 | 55366 | 200178 | Undocumented 2 | :: 54 | 3201 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014218.378 | 2089782.3359 | 37.7189438969212 | -122.39284511455 | (37.7189438969212, -122.39284511455) | |||
| 43519 | 43519 | 200180 | Undocumented 2 | :: 54 | 1031 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014690.5634 | 2089785.0188 | 37.7189774793874 | -122.391213128817 | (37.7189774793874, -122.391213128817) | |||
| 28513 | 28513 | 200177 | Undocumented 2 | :: 54 | 1041 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014650.3204 | 2089811.8475 | 37.7190489123065 | -122.39135410876001 | (37.7190489123065, -122.39135410876) | |||
| 29863 | 29863 | 200176 | Undocumented 2 | :: 54 | 1047 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014610.748 | 2089844.7127 | 37.7191369573176 | -122.391493192738 | (37.7191369573176, -122.391493192738) | |||
| 37581 | 37581 | 200170 | Undocumented 2 | :: 54 | 1001 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014099.661 | 2089867.5171 | 37.71917119290661 | -122.393261433304 | (37.7191711929066, -122.393261433304) | |||
| 177846 | 177846 | 200172 | Undocumented 2 | :: 54 | 1053 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014576.5414 | 2089866.8464 | 37.7191958334242 | -122.391612979464 | (37.7191958334242, -122.391612979464) | |||
| 186420 | 186420 | 200171 | Undocumented 2 | :: 54 | 1059 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014549.7127 | 2089886.9679 | 37.7192495938582 | -122.391707122944 | (37.7192495938582, -122.391707122944) | |||
| 150420 | 150420 | 200167 | Undocumented 2 | :: 54 | 1019 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014049.3571 | 2089910.4430000002 | 37.7192862641022 | -122.393438318502 | (37.7192862641022, -122.393438318502) | |||
| 133594 | 133594 | 200166 | Undocumented 2 | :: 54 | 1023 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014031.9185 | 2089919.1624 | 37.7193092369184 | -122.393499207549 | (37.7193092369184, -122.393499207549) | |||
| 54871 | 54871 | 200168 | Undocumented 2 | :: 54 | 1101 Gilman Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014990.039 | 2089901.3883 | 37.7193136223873 | -122.390186075408 | (37.7193136223873, -122.390186075408) | |||
| 144780 | 144780 | 200169 | Undocumented 2 | :: 54 | 1061 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014525.5668 | 2089911.1138 | 37.719314553356206 | -122.391792274296 | (37.7193145533562, -122.391792274296) | |||
| 30792 | 30792 | 200164 | Undocumented 2 | :: 54 | 1027 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014014.4798 | 2089939.2839 | 37.7193635176037 | -122.393560894555 | (37.7193635176037, -122.393560894555) | |||
| 156632 | 156632 | 200165 | Undocumented 2 | :: 54 | 1071 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014485.3238 | 2089939.2839 | 37.7193896687982 | -122.39193334918501 | (37.7193896687982, -122.391933349185) | |||
| 74346 | 74346 | 200162 | Undocumented 2 | :: 54 | 1035 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013970.2124 | 2089969.4662 | 37.7194439323961 | -122.393716023061 | (37.7194439323961, -122.393716023061) | |||
| 188973 | 188973 | 200161 | Undocumented 2 | :: 54 | 1083 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014425.6299 | 2089982.8806 | 37.7195060625081 | -122.392142737787 | (37.7195060625081, -122.392142737787) | |||
| 176452 | 176452 | 200497 | Undocumented 2 | :: 54 | 1110 Gilman Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014977.2953 | 2089975.1673 | 37.7195154981888 | -122.39023527774799 | (37.7195154981888, -122.390235277748) | |||
| 58301 | 58301 | 200156 | Undocumented 2 | :: 54 | 1047 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013914.5428 | 2090009.7093 | 37.7195513382693 | -122.39391126933 | (37.7195513382693, -122.39391126933) | |||
| 52467 | 52467 | 200157 | Undocumented 2 | :: 54 | 1091 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014392.094 | 2090006.3557 | 37.7195686584119 | -122.39226030100401 | (37.7195686584119, -122.392260301004) | |||
| 44928 | 44928 | 200155 | Undocumented 2 | :: 54 | 1091 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014363.9238 | 2090021.1115 | 37.719607610680704 | -122.39235870744899 | (37.7196076106807, -122.392358707449) | |||
| 61127 | 61127 | 200498 | Undocumented 2 | :: 54 | 1055 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013869.6047 | 2090039.2209 | 37.7196298737115 | -122.394068670065 | (37.7196298737115, -122.394068670065) | |||
| 80892 | 80892 | 104890 | Undocumented 2 | :: 54 | 150 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | empty | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | ||||
| 29647 | 29647 | 200249 | Undocumented 2 | :: 54 | 1067 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013803.2037 | 2090093.549 | 37.7197753570889 | -122.394301997885 | (37.7197753570889, -122.394301997885) | |||
| 39813 | 39813 | 200248 | Undocumented 2 | :: 54 | 1107 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014274.7183 | 2090092.8783 | 37.719799714154504 | -122.392672078819 | (37.7197997141545, -122.392672078819) | |||
| 168550 | 168550 | 200246 | Undocumented 2 | :: 54 | 1071 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013781.7407 | 2090110.9877 | 37.719822047209 | -122.394377408818 | (37.719822047209, -122.394377408818) | |||
| 28131 | 28131 | 200245 | Undocumented 2 | :: 54 | 1075 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013768.3263 | 2090118.3656 | 37.71984155975311 | -122.394424294358 | (37.7198415597531, -122.394424294358) | |||
| 171950 | 171950 | 200244 | Undocumented 2 | :: 54 | 1123 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014193.5615 | 2090152.5722 | 37.7199591140845 | -122.39295678576201 | (37.7199591140845, -122.392956785762) | |||
| 157610 | 157610 | 200239 | Undocumented 2 | :: 54 | 1131 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014148.6234 | 2090188.791 | 37.7200560674381 | -122.39311465541401 | (37.7200560674381, -122.393114655414) | |||
| 181617 | 181617 | 200202 | Undocumented 2 | :: 54 | 1090 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6013720.7054 | 2090215.6197 | 37.72010595277 | -122.394595711042 | (37.72010595277, -122.394595711042) | |||
| 177939 | 177939 | 200226 | Undocumented 2 | :: 54 | 1131 Fitzgerald Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6015013.4132 | 2090222.9153 | 37.720197768832605 | -122.390127728915 | (37.7201977688326, -122.390127728915) | |||
| 131768 | 131768 | 200212 | Undocumented 2 | :: 54 | 1101 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013545.647999999 | 2090276.655 | 37.720263809593604 | -122.395205102903 | (37.7202638095936, -122.395205102903) | |||
| 40807 | 40807 | 200183 | Undocumented 2 | :: 54 | 1197 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013828.6909 | 2090422.2008 | 37.7206791862384 | -122.39423689451401 | (37.7206791862384, -122.394236894514) | |||
| 185802 | 185802 | 200181 | Undocumented 2 | :: 54 | 1175 Ingerson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 0 | Width 0ft | 6013299.4945 | 2090456.4074 | 37.7207436812319 | -122.396068570714 | (37.7207436812319, -122.396068570714) | |||
| 123854 | 123854 | 38201 | Permitted Site 1 | :: 54 | 254X Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40328 | 6010721.34684579 | 2091489.60477168 | 37.723436846683704 | -122.405053190481 | (37.7234368466837, -122.405053190481) | ||
| 121409 | 121409 | 45784 | Permitted Site 1 | :: 54 | 355 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/2002 12:00:00 AM | Permit Number 44424 | 5995605.92038879 | 2092277.61806963 | 37.7247439722696 | -122.457361104262 | (37.7247439722696, -122.457361104262) | ||
| 83240 | 83240 | 108802 | Undocumented 2 | :: 54 | 401-499 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008323.152369999 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | |||||
| 135877 | 135877 | 199650 | Undocumented 2 | :: 54 | 0 | 1 | : 4 | Tree 1 | Private 1 | 0 | Width 0ft | 6014963.58685 | 2093280.8179400002 | 37.728591398452394 | -122.390513521988 | (37.7285913984524, -122.390513521988) | |||
| 85350 | 85350 | 40070 | Permitted Site 1 | :: 54 | 1434 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41296 | 6015644.04223078 | 2093317.32333735 | 37.7287293601115 | -122.388163675017 | (37.7287293601115, -122.388163675017) | ||
| 183672 | 183672 | 200636 | Undocumented 2 | :: 54 | 1301 Quesada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6016782.3625 | 2093458.8747 | 37.729181036936396 | -122.384238246013 | (37.7291810369364, -122.384238246013) | |||
| 111918 | 111918 | 109831 | Permitted Site 1 | :: 54 | 146 Staples Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12x15.3 | 5999109.5 | 2093827.3 | 37.7291996500545 | -122.445361075989 | (37.7291996500545, -122.445361075989) | ||||
| 113475 | 113475 | 46634 | Permitted Site 1 | :: 54 | 1569 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44755 | 6014739.185840401 | 2093576.72961431 | 37.729391461068204 | -122.391309972305 | (37.7293914610682, -122.391309972305) | ||
| 127351 | 127351 | 35482 | Permitted Site 1 | :: 54 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2000 12:00:00 AM | Permit Number 40088 | 6008340.04148266 | 2093836.36406151 | 37.7297471396453 | -122.413450843683 | (37.7297471396453, -122.413450843683) | ||
| 36680 | 36680 | 200762 | Undocumented 2 | :: 54 | 1999 Lane St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014632.1803 | 2093750.8421 | 37.7298635995705 | -122.39169207228201 | (37.7298635995705, -122.391692072282) | |||
| 158995 | 158995 | 200766 | Undocumented 2 | :: 54 | 1901 Lane St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014720.1223 | 2093871.3227 | 37.7301992962685 | -122.39139646330901 | (37.7301992962685, -122.391396463309) | |||
| 154317 | 154317 | 200577 | Undocumented 2 | :: 54 | 1701 Keith St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6015592.5071 | 2093926.7262 | 37.7303998031535 | -122.38838435336201 | (37.7303998031535, -122.388384353362) | |||
| 43479 | 43479 | 122819 | Undocumented 2 | :: 54 | 121 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003309.0 | 2094407.0 | 37.7310302083694 | -122.430884409483 | (37.7310302083694, -122.430884409483) | ||||
| 85267 | 85267 | 46322 | Permitted Site 1 | :: 54 | 3080 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2002 12:00:00 AM | Permit Number 44576 | 5988871.55058969 | 2094853.71729449 | 37.731428183192705 | -122.480829241755 | (37.7314281831927, -122.480829241755) | |||
| 100812 | 100812 | 115070 | Significant Tree 6 | :: 54 | 401 DARIEN WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5992724.0 | 2094938.0 | 37.7318827746659 | -122.467516839465 | (37.7318827746659, -122.467516839465) | ||||
| 129662 | 129662 | 200808 | Undocumented 2 | :: 54 | 1401 Oakdale Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6016065.8568 | 2094678.3259 | 37.732489764259896 | -122.386800296411 | (37.7324897642599, -122.386800296411) | |||
| 74359 | 74359 | 200626 | Undocumented 2 | :: 54 | 1370 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6016343.0854 | 2094895.2737 | 37.7331008048792 | -122.38585695867201 | (37.7331008048792, -122.385856958672) | |||
| 187469 | 187469 | 200742 | Undocumented 2 | :: 54 | 1454 Oakdale Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6015834.4667 | 2094922.2745 | 37.733146784173606 | -122.38761728786601 | (37.7331467841736, -122.387617287866) | |||
| 125838 | 125838 | 121591 | Undocumented 2 | :: 54 | 162 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6000339.0 | 2095263.0 | 37.7332118579221 | -122.44121356967199 | (37.7332118579221, -122.441213569672) | ||||
| 173333 | 173333 | 200730 | Undocumented 2 | :: 54 | 1466 Oakdale Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6015770.4184 | 2094966.2292 | 37.733263927070006 | -122.387841787924 | (37.73326392707, -122.387841787924) | |||
| 135055 | 135055 | 200729 | Undocumented 2 | :: 54 | 1481 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6015678.7414 | 2094969.3688 | 37.7332674687178 | -122.38815896225799 | (37.7332674687178, -122.388158962258) | |||
| 42125 | 42125 | 200722 | Undocumented 2 | :: 54 | 1476 Oakdale Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6015747.1852 | 2094980.6714 | 37.7333022953684 | -122.387923119588 | (37.7333022953684, -122.387923119588) | |||
| 96301 | 96301 | 101476 | Significant Tree 6 | :: 54 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2015 12:00:00 AM | 3 | Permit Number 775316 | 6000089.0 | 2095440.1 | 37.7336838892166 | -122.44209059296301 | (37.7336838892166, -122.442090592963) | ||
| 183233 | 183233 | 186926 | Undocumented 2 | :: 54 | 2800 Sunset Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985157.2666 | 2096011.7096 | 37.734391129301 | -122.493755335707 | (37.734391129301, -122.493755335707) | |||
| 33122 | 33122 | 185071 | Undocumented 2 | :: 54 | 2800 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984981.8139 | 2096034.5991 | 37.7344437114318 | -122.49436361071899 | (37.7344437114318, -122.494363610719) | |||
| 58562 | 58562 | 185072 | Undocumented 2 | :: 54 | 2801 Sunset Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985073.9331 | 2096042.9736 | 37.73447209618271 | -122.494045746017 | (37.7344720961827, -122.494045746017) | |||
| 79667 | 79667 | 109978 | Undocumented 2 | :: 54 | 75 Escondido Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986097.0 | 2096084.1 | 37.73464482809 | -122.490511739576 | (37.73464482809, -122.490511739576) | ||||
| 33065 | 33065 | 185060 | DPW Maintained 3 | :: 54 | 10x El Mirasol Pl | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5987413.8008 | 2096060.1353 | 37.7346558528299 | -122.485957413668 | (37.7346558528299, -122.485957413668) | |||
| 174948 | 174948 | 200699 | Undocumented 2 | :: 54 | 1501 Lane St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6015860.7307 | 2095472.4329 | 37.734658863200295 | -122.38756485421699 | (37.7346588632003, -122.387564854217) | |||
| 118134 | 118134 | 36519 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | ||
| 116859 | 116859 | 45263 | Permitted Site 1 | :: 54 | 673 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44109 | 6007439.21136226 | 2095836.00424965 | 37.7351870945672 | -122.41670672522 | (37.7351870945672, -122.41670672522) | ||
| 51515 | 51515 | 120669 | Undocumented 2 | :: 54 | 61 Paradise Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2016 12:00:00 AM | 3 | 3x3 | 6000974.0 | 2096001.0 | 37.7352743855737 | -122.43907108078899 | (37.7352743855737, -122.439071080789) | ||
| 30889 | 30889 | 245370 | Undocumented 2 | :: 54 | 3943 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005173.0525 | 2095986.3930000002 | 37.7354723102432 | -122.42455236124201 | (37.7354723102432, -122.424552361242) | |||
| 132272 | 132272 | 185049 | Undocumented 2 | :: 54 | 2731 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983672.3577 | 2096556.9514 | 37.7358012305935 | -122.49892933938999 | (37.7358012305935, -122.49892933939) | |||
| 133705 | 133705 | 184974 | Undocumented 2 | :: 54 | 2700 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984964.6462 | 2096531.6242 | 37.735807405046 | -122.494459590864 | (37.735807405046, -122.494459590864) | |||
| 125370 | 125370 | 3826 | DPW Maintained 3 | :: 54 | 120 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/1992 12:00:00 AM | 3 | 3X3 | 6016868.5122165 | 2095917.6664165 | 37.7359371538987 | -122.384111573291 | (37.7359371538987, -122.384111573291) | ||
| 151546 | 151546 | 182946 | Undocumented 2 | :: 54 | 3500 Wawona St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982068.7362 | 2096751.2664 | 37.7362405734928 | -122.504487984804 | (37.7362405734928, -122.504487984804) | |||
| 29214 | 29214 | 182945 | Undocumented 2 | :: 54 | 2691 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981809.5051 | 2096798.8146 | 37.7363558765881 | -122.50538776138 | (37.7363558765881, -122.50538776138) | |||
| 145560 | 145560 | 121126 | Undocumented 2 | :: 54 | 201 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216.0 | 2096386.0 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | ||
| 154543 | 154543 | 182944 | Undocumented 2 | :: 54 | 2678 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981851.131 | 2096866.8374 | 37.7365450979685 | -122.50524888568701 | (37.7365450979685, -122.505248885687) | |||
| 147162 | 147162 | 182943 | Undocumented 2 | :: 54 | 2674 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981850.1157 | 2096894.2496 | 37.7366203046104 | -122.505254426993 | (37.7366203046104, -122.505254426993) | |||
| 137654 | 137654 | 182938 | Undocumented 2 | :: 54 | 2657 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981803.7519 | 2096965.6566 | 37.7368136403966 | -122.505420015001 | (37.7368136403966, -122.505420015001) | |||
| 35754 | 35754 | 182933 | Undocumented 2 | :: 54 | 2646 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981845.0394 | 2097064.8142 | 37.7370883295038 | -122.505284615423 | (37.7370883295038, -122.505284615423) | |||
| 74865 | 74865 | 182936 | Undocumented 2 | :: 54 | 2643 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982105.6241 | 2097104.0711 | 37.737211448275794 | -122.50438657908998 | (37.7372114482758, -122.50438657909) | |||
| 181678 | 181678 | 182929 | Undocumented 2 | :: 54 | 2635 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981797.6603 | 2097141.2975 | 37.737295543609996 | -122.50545409100799 | (37.73729554361, -122.505454091008) | |||
| 67752 | 67752 | 185275 | Undocumented 2 | :: 54 | 2600 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984941.5117 | 2097207.3396 | 37.7376613847371 | -122.494589373511 | (37.7376613847371, -122.494589373511) | |||
| 40189 | 40189 | 183398 | Undocumented 2 | :: 54 | 2676 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989291.1458 | 2097146.7716 | 37.7377487006662 | -122.479546347444 | (37.7377487006662, -122.479546347444) | |||
| 41622 | 41622 | 183384 | Undocumented 2 | :: 54 | 2659 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989243.3159 | 2097242.4314 | 37.7380085792734 | -122.479718714161 | (37.7380085792734, -122.479718714161) |
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");