Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 154149 | 154149 | 201514 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1001 Innes Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 75 | 6018663.55815 | 2094844.4948099998 | 37.733089515074795 | -122.377830854436 | (37.7330895150748, -122.377830854436) | ||||
| 172222 | 172222 | 201510 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1001 Innes Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6018594.17439 | 2094891.11142 | 37.73321369166371 | -122.378073969944 | (37.7332136916637, -122.378073969944) | ||||
| 887 | 887 | 251303 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 2 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 896 | 896 | 251302 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 114512 | 114512 | 108201 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 90 Reuel Ct | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774102 | 6017404.09127 | 2096025.6169900002 | 37.7362631610075 | -122.382267352258 | (37.7362631610075, -122.382267352258) | ||||
| 119476 | 119476 | 108200 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 90 Reuel Ct | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774102 | 6017404.09127 | 2096025.6169900002 | 37.7362631610075 | -122.382267352258 | (37.7362631610075, -122.382267352258) | ||||
| 119339 | 119339 | 121341 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 401X Cargo Way | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 3x3 | 6017217.0 | 2098844.0 | 37.7439915378474 | -122.383110313195 | (37.7439915378474, -122.383110313195) | |||
| 173688 | 173688 | 191721 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 1150x Tennessee St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 6015559.12531 | 2103608.85918 | 37.75698309171089 | -122.389175557402 | (37.7569830917109, -122.389175557402) | ||||
| 43077 | 43077 | 191722 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 25th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6014479.640380001 | 2101959.5389 | 37.752394509601494 | -122.392793471535 | (37.7523945096015, -122.392793471535) | ||||
| 164592 | 164592 | 191726 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 700 Missouri St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6013632.69543 | 2103711.63212 | 37.757158302141 | -122.395845128465 | (37.757158302141, -122.395845128465) | ||||
| 130593 | 130593 | 191727 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1790 23rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6013509.42079 | 2102917.94191 | 37.7549721419751 | -122.396215837988 | (37.7549721419751, -122.396215837988) | ||||
| 39683 | 39683 | 191728 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1790 23rd St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6013472.8835 | 2102915.30193 | 37.754962860065 | -122.39634201017999 | (37.754962860065, -122.39634201018) | ||||
| 139866 | 139866 | 115801 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 9M CAIRE TER | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012720.0 | 2101959.0 | 37.7522951385919 | -122.398878598484 | (37.7522951385919, -122.398878598484) | |||||
| 153783 | 153783 | 191723 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x Carolina St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 6012476.48508 | 2103328.88343 | 37.7560429683291 | -122.39981689974701 | (37.7560429683291, -122.399816899747) | ||||
| 99315 | 99315 | 3751 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 990 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | 18 | 6012435.5557064 | 2103342.2152382 | 37.756077292734105 | -122.399959384248 | (37.7560772927341, -122.399959384248) | |||
| 179689 | 179689 | 176336 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6012249.60162 | 2087766.47281 | 37.713299190589794 | -122.39950899437001 | (37.7132991905898, -122.39950899437) | ||||
| 701 | 701 | 176335 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6012233.93602 | 2087774.2056900002 | 37.7133195503322 | -122.399563683027 | (37.7133195503322, -122.399563683027) | ||||
| 692 | 692 | 176334 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6012223.87562 | 2087782.5469900002 | 37.713341893097 | -122.399599040764 | (37.713341893097, -122.399599040764) | ||||
| 103214 | 103214 | 106173 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 267 Green St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 771881 | 6011670.8 | 2119368.7 | 37.8000396459541 | -122.403731811098 | (37.8000396459541, -122.403731811098) | ||||
| 55507 | 55507 | 191724 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 950x Kansas St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 43 | 6011608.5229400005 | 2103823.60133 | 37.7573529289142 | -122.402853412073 | (37.7573529289142, -122.402853412073) | ||||
| 180599 | 180599 | 191725 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 950x Kansas St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 46 | 6011608.2265 | 2103816.01851 | 37.75733209161471 | -122.40285390399201 | (37.7573320916147, -122.402853903992) | ||||
| 28512 | 28512 | 176338 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6011479.2515 | 2090641.1055 | 37.721149380822 | -122.402373605767 | (37.721149380822, -122.402373605767) | |||
| 47690 | 47690 | 176337 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 59 | Width 0ft | 6011478.9031 | 2090656.6645400003 | 37.72119208331829 | -122.40237590353901 | (37.7211920833183, -122.402375903539) | |||
| 38393 | 38393 | 176339 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6011461.59774 | 2090655.36204 | 37.7211875408569 | -122.402435631998 | (37.7211875408569, -122.402435631998) | |||
| 171841 | 171841 | 176342 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6011455.5144 | 2090588.63485 | 37.721003982019504 | -122.40245197087799 | (37.7210039820195, -122.402451970878) | |||
| 75518 | 75518 | 191738 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 920 Vermont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 6011311.04969 | 2104026.1978700003 | 37.757892599481 | -122.40389645386699 | (37.757892599481, -122.403896453867) | ||||
| 151150 | 151150 | 126581 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 556 Pine St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 6011285.65956 | 2116338.25251 | 37.7916972455684 | -122.404851076143 | (37.7916972455684, -122.404851076143) | |||
| 130703 | 130703 | 224266 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6011271.09407 | 2103721.28577 | 37.75705314619071 | -122.404013180481 | (37.7570531461907, -122.404013180481) | ||||
| 156972 | 156972 | 224267 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6011260.203430001 | 2103721.90369 | 37.7570542343818 | -122.40405088815001 | (37.7570542343818, -122.40405088815) | ||||
| 73320 | 73320 | 224268 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6011248.24436 | 2103720.25065 | 37.757049027311204 | -122.40409213106001 | (37.7570490273112, -122.40409213106) | ||||
| 71541 | 71541 | 224269 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6011241.96431 | 2103719.95233 | 37.7570478572995 | -122.404113828986 | (37.7570478572995, -122.404113828986) | ||||
| 37470 | 37470 | 176346 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 40 Teddy Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6011228.44814 | 2087808.7969 | 37.7133584325151 | -122.40304144861 | (37.7133584325151, -122.40304144861) | ||||
| 183396 | 183396 | 176347 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 40 Teddy Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | 6011214.18105 | 2087815.3375799998 | 37.7133755951756 | -122.403091220704 | (37.7133755951756, -122.403091220704) | ||||
| 164095 | 164095 | 249920 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 358 Greenwich St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011181.16541 | 2120413.994 | 37.8028824034529 | -122.405499802075 | (37.8028824034529, -122.405499802075) | |||
| 44177 | 44177 | 113502 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x MANSELL ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 3x3 | 6011136.0 | 2090597.0 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | |||
| 178271 | 178271 | 176340 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x Mansell St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6011135.84107 | 2090535.2556900003 | 37.720839562571996 | -122.403553239308 | (37.720839562572, -122.403553239308) | |||
| 71413 | 71413 | 113506 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x Mansell St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 39 | 3x3 | 6011135.08211 | 2090555.5358799999 | 37.7208952054249 | -122.40355728893199 | (37.7208952054249, -122.403557288932) | |||
| 181003 | 181003 | 191736 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 200 Helena St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 57 | 6010895.577219999 | 2096228.10312 | 37.7364575084979 | -122.40478434551399 | (37.7364575084979, -122.404784345514) | ||||
| 66266 | 66266 | 191737 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 200 Helena St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6010885.73151 | 2096220.33708 | 37.736435634280895 | -122.40481783988199 | (37.7364356342809, -122.404817839882) | ||||
| 141354 | 141354 | 120533 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 951 Brannan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 22 | 3x3 | 6010745.0 | 2108673.0 | 37.7706200263658 | -122.40618148078501 | (37.7706200263658, -122.406181480785) | |||
| 100855 | 100855 | 114731 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 934 BRANNAN ST | Back Yard : Yard 13 | Tree 1 | Private 1 | Dept of Real Estate 9 | 10x10 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 139032 | 139032 | 30154 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 410X Mansell St | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
| 92339 | 92339 | 115295 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 500X 08TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010511.0 | 2109243.0 | 37.77217202356729 | -122.407031076357 | (37.7721720235673, -122.407031076357) | ||||
| 153590 | 153590 | 248107 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 138 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6010423.63855 | 2099478.50343 | 37.7453560168793 | -122.406645033853 | (37.7453560168793, -122.406645033853) | ||||
| 166763 | 166763 | 247928 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010393.74755 | 2098772.89885 | 37.7434169076795 | -122.406698675702 | (37.7434169076795, -122.406698675702) | ||||
| 31541 | 31541 | 247930 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6010384.98383 | 2098777.78466 | 37.7434298327179 | -122.406729322818 | (37.7434298327179, -122.406729322818) | ||||
| 24579 | 24579 | 247929 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6010384.7561099995 | 2098766.60945 | 37.743399135274295 | -122.40672932282301 | (37.7433991352743, -122.406729322823) | ||||
| 181095 | 181095 | 247932 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6010369.906140001 | 2098762.7933799997 | 37.743387826290395 | -122.406780401602 | (37.7433878262904, -122.406780401602) | ||||
| 70884 | 70884 | 247927 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6010318.55961 | 2098736.7728 | 37.7433135063186 | -122.40695611204501 | (37.7433135063186, -122.406956112045) | ||||
| 59867 | 59867 | 247926 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010312.05046 | 2098736.31721 | 37.743311891127604 | -122.406978587005 | (37.7433118911276, -122.406978587005) | ||||
| 46194 | 46194 | 247925 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6010304.27631 | 2098731.76841 | 37.743298966077795 | -122.407005147582 | (37.7432989660778, -122.407005147582) | ||||
| 30032 | 30032 | 247924 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6010297.695230001 | 2098727.78354 | 37.7432876562154 | -122.40702762254499 | (37.7432876562154, -122.407027622545) | ||||
| 74012 | 74012 | 247935 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6010295.56922 | 2098768.42696 | 37.743399135252204 | -122.407037837932 | (37.7433991352522, -122.407037837932) | ||||
| 62115 | 62115 | 247923 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6010288.87158 | 2098729.72842 | 37.7432925026595 | -122.40705826963699 | (37.7432925026595, -122.407058269637) | ||||
| 147007 | 147007 | 247922 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010270.948580001 | 2098720.09099 | 37.7432650373678 | -122.40711956383001 | (37.7432650373678, -122.40711956383) | ||||
| 44888 | 44888 | 176341 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 500x Mansell St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6010266.44711 | 2090286.24099 | 37.7201072185592 | -122.406540946309 | (37.7201072185592, -122.406540946309) | |||
| 169544 | 169544 | 247921 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 38 | 6010260.8237 | 2098716.17835 | 37.7432537274883 | -122.407154297447 | (37.7432537274883, -122.407154297447) | ||||
| 25982 | 25982 | 247919 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010242.48982 | 2098715.3752200003 | 37.743250496220895 | -122.40721763491001 | (37.7432504962209, -122.40721763491) | ||||
| 56692 | 56692 | 247937 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1149 Esmeralda Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6010236.06133 | 2098747.86868 | 37.7433393564296 | -122.40724215312599 | (37.7433393564296, -122.407242153126) | ||||
| 150294 | 150294 | 247917 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 32 | 6010231.88216 | 2098716.76824 | 37.7432537274832 | -122.407254411775 | (37.7432537274832, -122.407254411775) | ||||
| 50757 | 50757 | 191735 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6010009.096969999 | 2107534.42743 | 37.7674525780981 | -122.408646656734 | (37.7674525780981, -122.408646656734) | ||||
| 48059 | 48059 | 43994 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 141 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | 18 | Permit Number 43551 | 6010001.85414 | 2107517.13485 | 37.7674046909874 | -122.408670488759 | (37.7674046909874, -122.408670488759) | ||
| 164405 | 164405 | 191733 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6009990.5053900005 | 2107548.56259 | 37.7674903487254 | -122.408711960091 | (37.7674903487254, -122.408711960091) | ||||
| 159705 | 159705 | 191732 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6009982.19315 | 2107558.06249 | 37.7675159677065 | -122.408741381426 | (37.7675159677065, -122.408741381426) | ||||
| 70209 | 70209 | 191734 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6009976.801940001 | 2107534.39117 | 37.767450669731105 | -122.40875835881201 | (37.7674506697311, -122.408758358812) | ||||
| 185592 | 185592 | 191731 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009975.967759999 | 2107617.96239 | 37.76768009039721 | -122.408767140702 | (37.7676800903972, -122.408767140702) | ||||
| 134906 | 134906 | 191730 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009966.3806300005 | 2107638.17528 | 37.767735053365705 | -122.40880172773399 | (37.7677350533657, -122.408801727734) | ||||
| 158665 | 158665 | 191729 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009963.10998 | 2107668.13664 | 37.7678171371844 | -122.408815154618 | (37.7678171371844, -122.408815154618) | ||||
| 59219 | 59219 | 247999 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 346 Peralta Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6009771.618319999 | 2099231.70155 | 37.744641851750295 | -122.40888221345101 | (37.7446418517503, -122.408882213451) | ||||
| 172652 | 172652 | 247821 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 Jarboe Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009717.95526 | 2096849.3331900002 | 37.7380973799798 | -122.40889971695 | (37.7380973799798, -122.40889971695) | ||||
| 148899 | 148899 | 247820 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 Jarboe Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6009707.559769999 | 2096850.2861400002 | 37.7380994142676 | -122.40893572671699 | (37.7380994142676, -122.408935726717) | ||||
| 146980 | 146980 | 247819 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 Jarboe Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009694.17454 | 2096850.5592099999 | 37.738099414264 | -122.408982025597 | (37.738099414264, -122.408982025597) | ||||
| 183364 | 183364 | 247818 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1058 Jarboe Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 46 | 6009634.533480001 | 2096844.3676599998 | 37.738079072495395 | -122.409187798594 | (37.7380790724954, -122.409187798594) | ||||
| 182567 | 182567 | 246763 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6009290.72604 | 2098884.53398 | 37.74366165725821 | -122.410520540796 | (37.7436616572582, -122.410520540796) | ||||
| 186126 | 186126 | 246762 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6009259.9688 | 2098886.63063 | 37.743665689828 | -122.41062704033101 | (37.743665689828, -122.410627040331) | ||||
| 185207 | 185207 | 246760 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6009218.12342 | 2098889.2056 | 37.7436704139605 | -122.410771913907 | (37.7436704139605, -122.410771913907) | ||||
| 169268 | 169268 | 246758 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | 6009165.3759699995 | 2098887.8964 | 37.743663861508395 | -122.41095421008801 | (37.7436638615084, -122.410954210088) | ||||
| 89080 | 89080 | 106004 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 695X CAMPBELL AVE | unknown : Yard 19 | Tree 1 | Rec/Park 3 | 6009136.9 | 2088912.4 | 37.716271678506 | -122.41034847162202 | (37.716271678506, -122.410348471622) | ||||||
| 63741 | 63741 | 246757 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6009117.20748 | 2098899.99025 | 37.7436943673943 | -122.41112161978998 | (37.7436943673943, -122.41112161979) | ||||
| 70101 | 70101 | 247851 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 152 Chapman St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 79 | 6009070.86749 | 2098234.59559 | 37.7418647407582 | -122.411234858803 | (37.7418647407582, -122.411234858803) | ||||
| 112606 | 112606 | 105901 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 30 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
| 122561 | 122561 | 105900 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 30 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
| 138343 | 138343 | 105902 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 40 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
| 76551 | 76551 | 224247 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 527 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 46 | 6008745.222630001 | 2098103.60695 | 37.74148680607821 | -122.412351580256 | (37.7414868060782, -122.412351580256) | ||||
| 128978 | 128978 | 122678 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 701x Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3x3 | 6008711.0 | 2098131.0 | 37.741560100881 | -122.412471846631 | (37.741560100881, -122.412471846631) | |||
| 9734 | 9734 | 173682 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 450x Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6008515.0 | 2088365.0 | 37.71473375007071 | -122.41245939537501 | (37.7147337500707, -122.412459395375) | |||
| 9739 | 9739 | 173683 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 450x Raymond Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6008515.0 | 2088365.0 | 37.71473375007071 | -122.41245939537501 | (37.7147337500707, -122.412459395375) | |||
| 158274 | 158274 | 176343 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 450 Raymond Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 76 | 6008484.74111 | 2088383.4213400001 | 37.714782633086294 | -122.412565284366 | (37.7147826330863, -122.412565284366) | ||||
| 43267 | 43267 | 121204 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 44 MacOndray Ln | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 52 | 6008473.20212 | 2119153.5676 | 37.799269800719294 | -122.41478152415002 | (37.7992698007193, -122.41478152415) | ||||
| 71482 | 71482 | 176344 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 450 Raymond Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6008453.924319999 | 2088393.6006200002 | 37.714808853708604 | -122.41267251952299 | (37.7148088537086, -122.412672519523) | ||||
| 32543 | 32543 | 176345 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 450 Raymond Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | 6008420.88631 | 2088405.51015 | 37.7148397004654 | -122.412787554496 | (37.7148397004654, -122.412787554496) | ||||
| 159737 | 159737 | 224252 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 177 Powhattan Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 3ft | 6008209.41115 | 2098117.01266 | 37.741493532991 | -122.41420518642299 | (37.741493532991, -122.414205186423) | |||
| 32753 | 32753 | 224251 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 177 Powhattan Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6008204.54136 | 2098121.72815 | 37.741506207147005 | -122.414222358085 | (37.741506207147, -122.414222358085) | |||
| 51062 | 51062 | 224245 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 160 Coso Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 6007485.6356 | 2099587.10163 | 37.7454893881214 | -122.41681188667201 | (37.7454893881214, -122.416811886672) | ||||
| 99243 | 99243 | 122535 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 199x Coso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6007478.0 | 2099565.0 | 37.7454282725128 | -122.41683672388399 | (37.7454282725128, -122.416836723884) | |||
| 64417 | 64417 | 224250 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 425 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 34 | Width 5ft | 6007149.05774 | 2097827.31438 | 37.740638468384795 | -122.417851002914 | (37.7406384683848, -122.417851002914) | |||
| 174300 | 174300 | 248219 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Fair Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 38 | 6007128.325540001 | 2099340.74379 | 37.744792840734206 | -122.418029950029 | (37.7447928407342, -122.418029950029) | ||||
| 18271 | 18271 | 28138 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 418 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X5 | 6006975.957669999 | 2097881.62293 | 37.7407778444163 | -122.41845336792801 | (37.7407778444163, -122.418453367928) | |||
| 656 | 656 | 23200 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006725.22564 | 2112390.29825 | 37.7806011691535 | -122.420349841196 | (37.7806011691535, -122.420349841196) | |||
| 8841 | 8841 | 23183 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006719.9876 | 2112427.32903 | 37.780702551515496 | -122.42037059124901 | (37.7807025515155, -122.420370591249) |
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");