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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 684 | 684 | 24323 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 600X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006332.380890001 | 2112512.31586 | 37.7809140549901 | -122.42171754994101 | (37.7809140549901, -122.421717549941) | |||
| 966 | 966 | 251417 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5990003.0 | 2112517.0 | 37.779992561868504 | -122.478208632121 | (37.7799925618685, -122.478208632121) | ||||
| 1070 | 1070 | 19942 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 2603 | 2603 | 253136 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 3059 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x5 | 5999298.0 | 2114593.0 | 37.786227889505604 | -122.446202552789 | (37.7862278895056, -122.446202552789) | ||||
| 3884 | 3884 | 20320 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 6027 | 6027 | 20016 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY48 | 0 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 6772 | 6772 | 20314 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 6891 | 6891 | 7808 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 700X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006239.03041 | 2112534.82936 | 37.7809706070447 | -122.422042095466 | (37.7809706070447, -122.422042095466) | |||
| 7805 | 7805 | 19939 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 8002 | 8002 | 19938 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 8496 | 8496 | 20017 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY48 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 9488 | 9488 | 17957 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 2500 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6001928.8852 | 2115030.4127 | 37.7875788082428 | -122.437131721785 | (37.7875788082428, -122.437131721785) | |||
| 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) | |||
| 12003 | 12003 | 20316 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 14348 | 14348 | 19941 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 14547 | 14547 | 19940 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 16276 | 16276 | 20315 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 17047 | 17047 | 20318 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 17109 | 17109 | 20319 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 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) | |||
| 18477 | 18477 | 4843 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 146 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6006528.82493 | 2097534.91084 | 37.739800668952604 | -122.419974789699 | (37.7398006689526, -122.419974789699) | |||
| 20364 | 20364 | 4837 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 127 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006404.24922 | 2097646.68025 | 37.7401005434118 | -122.420413452032 | (37.7401005434118, -122.420413452032) | |||
| 20653 | 20653 | 2618 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
| 33426 | 33426 | 224248 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 512 Clipper St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6001839.26935 | 2100907.02963 | 37.7487943903519 | -122.43643055213998 | (37.7487943903519, -122.43643055214) | |||
| 36877 | 36877 | 138087 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1611 Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6004894.5944 | 2114873.9606 | 37.7873173623789 | -122.426859803648 | (37.7873173623789, -122.426859803648) | |||
| 36905 | 36905 | 224255 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 388 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999122.55283 | 2104753.1321799997 | 37.7592000986313 | -122.446101520571 | (37.7592000986313, -122.446101520571) | |||
| 41245 | 41245 | 138027 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1631 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 39 | Width 0ft | 6004885.3328 | 2114935.3188 | 37.7874853129815 | -122.426896218405 | (37.7874853129815, -122.426896218405) | |||
| 42995 | 42995 | 52091 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 300 Dorantes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2005 12:00:00 AM | Permit Number 48287 | 5993176.51233561 | 2099718.04340733 | 37.745033690620396 | -122.46629968747601 | (37.7450336906204, -122.466299687476) | |||
| 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) | ||
| 48548 | 48548 | 65198 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 371 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 34 | Permit Number 27183 | 6003158.74485 | 2091706.4873099998 | 37.7236066919673 | -122.431211180179 | (37.7236066919673, -122.431211180179) | |
| 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) | |||
| 69421 | 69421 | 224263 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 11 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004229.44428 | 2108900.2308400003 | 37.770877346636205 | -122.42873507047399 | (37.7708773466362, -122.428735070474) | |||
| 70742 | 70742 | 138025 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1651 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 49 | Width 0ft | 6004878.9655 | 2114979.8902 | 37.7876073348692 | -122.42692142358601 | (37.7876073348692, -122.426921423586) | |||
| 78601 | 78601 | 92035 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 78801 | 78801 | 2617 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
| 78981 | 78981 | 113860 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 456 HILL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2103347.0 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | ||||
| 80756 | 80756 | 2614 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
| 84894 | 84894 | 105492 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1575 07TH AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 773490 | 5993962.3 | 2104771.9 | 37.7589555970933 | -122.463949378571 | (37.7589555970933, -122.463949378571) | ||
| 89069 | 89069 | 138024 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1661 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 48 | Width 0ft | 6004873.7558 | 2115028.5137 | 37.7877405482561 | -122.42694291248002 | (37.7877405482561, -122.42694291248) | |||
| 89710 | 89710 | 92040 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 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) | ||||
| 92750 | 92750 | 113861 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 456 HILL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2103347.0 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | ||||
| 92823 | 92823 | 116020 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2023 09TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 5993447.0 | 2101700.0 | 37.7504912419676 | -122.46550835159401 | (37.7504912419676, -122.465508351594) | ||||
| 95756 | 95756 | 92036 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 97315 | 97315 | 113859 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 456 HILL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2103347.0 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | ||||
| 97794 | 97794 | 92038 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 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) | |||
| 108603 | 108603 | 114396 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 35 HIGUERA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||||
| 109893 | 109893 | 114409 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 500X ARBALLO DR | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | ||||
| 113582 | 113582 | 114403 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1X HIGUERA AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||
| 115215 | 115215 | 92034 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 116196 | 116196 | 92033 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 116419 | 116419 | 2615 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
| 121824 | 121824 | 92039 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 122260 | 122260 | 66251 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 35 HIGUERA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1990 12:00:00 AM | Permit Number 29352 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||
| 126390 | 126390 | 2619 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 10X10 | 6004877.75733 | 2115027.26874 | 37.7877373561683 | -122.42692897924101 | (37.7877373561683, -122.426928979241) | |||
| 128237 | 128237 | 92037 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 128787 | 128787 | 116019 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2023 09TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 5993447.0 | 2101700.0 | 37.7504912419676 | -122.46550835159401 | (37.7504912419676, -122.465508351594) | ||||
| 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) | |||
| 132331 | 132331 | 208961 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1575 07th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 5993977.82871 | 2104681.32491 | 37.75870779624321 | -122.463889098911 | (37.7587077962432, -122.463889098911) | |||
| 138324 | 138324 | 2616 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
| 141326 | 141326 | 113862 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 456 HILL ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2103347.0 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | ||||
| 141824 | 141824 | 121089 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 1X Grand View Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000227.0 | 2103854.0 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | ||||
| 149384 | 149384 | 207754 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1364 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5993663.7534300005 | 2106217.17575 | 37.7629067380829 | -122.46508685559999 | (37.7629067380829, -122.4650868556) | |||
| 151444 | 151444 | 208979 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 46 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5992891.21268 | 2101728.13425 | 37.7505364203394 | -122.467432335147 | (37.7505364203394, -122.467432335147) | |||
| 153710 | 153710 | 138026 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1641 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 57 | Width 0ft | 6004881.8597 | 2114953.8419999997 | 37.787535976676395 | -122.426909554358 | (37.7875359766764, -122.426909554358) | |||
| 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) | |||
| 175100 | 175100 | 207765 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 356 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5992543.86147 | 2094436.1305 | 37.7304943639181 | -122.46810311696998 | (37.7304943639181, -122.46810311697) | |||
| 176724 | 176724 | 138028 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1621 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 49 | Width 0ft | 6004887.6482 | 2114917.9533 | 37.7874377625804 | -122.426886970359 | (37.7874377625804, -122.426886970359) | |||
| 177301 | 177301 | 245010 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1480 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5999484.2143 | 2109133.9912 | 37.7712494874058 | -122.44516568603999 | (37.7712494874058, -122.44516568604) | |||
| 183205 | 183205 | 245009 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1466 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5999558.6674 | 2109145.6245 | 37.7712856788974 | -122.44490898697701 | (37.7712856788974, -122.444908986977) | |||
| 186323 | 186323 | 224264 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 11 Germania St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004254.57068 | 2108904.38845 | 37.770890184456796 | -122.42864845406 | (37.7708901844568, -122.42864845406) | |||
| 3850 | 3850 | 207785 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 290 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 09/28/2017 12:00:00 AM | 3 | Width 10ft | 5993081.87997 | 2096205.8056700001 | 37.7353845093885 | -122.46637169180299 | (37.7353845093885, -122.466371691803) | ||
| 23367 | 23367 | 208982 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 320 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 45 | Width 3ft | 5993096.565780001 | 2095876.3159599998 | 37.7344806601409 | -122.46629697974501 | (37.7344806601409, -122.466296979745) | |||
| 23922 | 23922 | 208951 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 440 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | Width 10ft | 5993021.57409 | 2096009.5815299999 | 37.734842246953896 | -122.46656593187099 | (37.7348422469539, -122.466565931871) | |||
| 24218 | 24218 | 208954 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 600 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 8ft | 5993495.97502 | 2095994.9515900002 | 37.7348294415148 | -122.464924714122 | (37.7348294415148, -122.464924714122) | |||
| 24602 | 24602 | 208981 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 310 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | Width 3ft | 5993092.40274 | 2095921.0497 | 37.7346032476459 | -122.466314622626 | (37.7346032476459, -122.466314622626) | |||
| 25657 | 25657 | 208945 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 234 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | Width 10ft | 5992554.30272 | 2095990.82137 | 37.73476376044329 | -122.46818007286001 | (37.7347637604433, -122.46818007286) | |||
| 26365 | 26365 | 208940 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 10ft | 5992201.32921 | 2095978.5342700002 | 37.7347096311457 | -122.469399518468 | (37.7347096311457, -122.469399518468) | |||
| 26956 | 26956 | 208920 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 135 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 10ft | 5992288.77396 | 2096040.55395 | 37.734884974665 | -122.46910170710301 | (37.734884974665, -122.469101707103) | |||
| 28258 | 28258 | 208938 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 66 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 10ft | 5991979.81471 | 2095977.19537 | 37.7346931510662 | -122.470165265142 | (37.7346931510662, -122.470165265142) | |||
| 28820 | 28820 | 209004 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 156 Kensington Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5994803.6888 | 2098556.09355 | 37.7419370183784 | -122.460589057359 | (37.7419370183784, -122.460589057359) | |||
| 29038 | 29038 | 208963 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 90 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 6ft | 5993939.166669999 | 2096822.57013 | 37.7371274206966 | -122.463452499655 | (37.7371274206966, -122.463452499655) | |||
| 29186 | 29186 | 209002 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 115 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 4ft | 5994119.61861 | 2096725.9639 | 37.736872559114104 | -122.462821593742 | (37.7368725591141, -122.462821593742) | |||
| 29388 | 29388 | 207794 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 213 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 10ft | 5993149.25155 | 2096563.99491 | 37.736371894833 | -122.46616478658999 | (37.736371894833, -122.46616478659) | |||
| 30634 | 30634 | 207776 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 110 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 10ft | 5993235.98614 | 2096867.2882599998 | 37.7372096663776 | -122.46588694193001 | (37.7372096663776, -122.46588694193) | |||
| 30943 | 30943 | 208922 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 201 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 10ft | 5992403.02946 | 2096048.0013299999 | 37.7349120244605 | -122.46870723116899 | (37.7349120244605, -122.468707231169) | |||
| 32381 | 32381 | 207778 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 124 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 10ft | 5993200.08857 | 2096786.31561 | 37.7369852648432 | -122.46600517310699 | (37.7369852648432, -122.466005173107) | |||
| 33664 | 33664 | 207789 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 275 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 10ft | 5993131.90761 | 2096210.54353 | 37.735400404893 | -122.46619907325199 | (37.735400404893, -122.466199073252) | |||
| 33873 | 33873 | 208955 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 630 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 8ft | 5993530.979180001 | 2095998.56422 | 37.7348413791301 | -122.464803955838 | (37.7348413791301, -122.464803955838) | |||
| 34400 | 34400 | 207800 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Santa Clara Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | Width 10ft | 5993292.571380001 | 2096874.95335 | 37.737233976861205 | -122.465691859205 | (37.7372339768612, -122.465691859205) | |||
| 36584 | 36584 | 208984 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 354 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 3ft | 5993109.71634 | 2095669.50335 | 37.7339135629453 | -122.466236489538 | (37.7339135629453, -122.466236489538) | |||
| 36761 | 36761 | 208976 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 6ft | 5994151.01662 | 2096664.6627200001 | 37.7367060496466 | -122.462708592139 | (37.7367060496466, -122.462708592139) | |||
| 36907 | 36907 | 208993 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 31 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5993535.26127 | 2097150.77507 | 37.7380053101076 | -122.46487280074899 | (37.7380053101076, -122.464872800749) | |||
| 40168 | 40168 | 208995 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 21 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 4ft | 5993486.0432 | 2097190.73028 | 37.7381121792369 | -122.465045871672 | (37.7381121792369, -122.465045871672) | |||
| 40215 | 40215 | 207788 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 285 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 10ft | 5993135.10109 | 2096167.2284099997 | 37.7352816566244 | -122.46618488553001 | (37.7352816566244, -122.46618488553) | |||
| 40777 | 40777 | 207799 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 10ft | 5993278.012180001 | 2096833.03373 | 37.7371180362587 | -122.465739151856 | (37.7371180362587, -122.465739151856) | |||
| 41418 | 41418 | 207775 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 110 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 10ft | 5993244.34274 | 2096906.29835 | 37.737317260394 | -122.465860883191 | (37.737317260394, -122.465860883191) | |||
| 41832 | 41832 | 208941 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 130 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 10ft | 5992287.573419999 | 2095984.60456 | 37.734731282309106 | -122.469101787134 | (37.7347312823091, -122.469101787134) |
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");