Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97104 | 97104 | 50378 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1620 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | |||
| 128144 | 128144 | 50377 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1620 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | |||
| 7023 | 7023 | 23544 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2800X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005656.2038 | 2120054.10262 | 37.80158375904121 | -122.424593418169 | (37.8015837590412, -122.424593418169) | |||
| 116970 | 116970 | 34459 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1960 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | Permit Number 42077 | 6008233.26269903 | 2119182.7725058 | 37.7993365057546 | -122.415613869084 | (37.7993365057546, -122.415613869084) | ||
| 120244 | 120244 | 34458 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1960 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | 3x3 | Permit Number 42077 | 6008233.26269903 | 2119182.7725058 | 37.7993365057546 | -122.415613869084 | (37.7993365057546, -122.415613869084) | |
| 125997 | 125997 | 34460 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1960 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | 3x3 | Permit Number 38200 | 6008233.26269903 | 2119182.7725058 | 37.7993365057546 | -122.415613869084 | (37.7993365057546, -122.415613869084) | |
| 7523 | 7523 | 87408 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2400X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 6005843.02152 | 2118712.53051 | 37.7979106921903 | -122.42385149366501 | (37.7979106921903, -122.423851493665) | ||
| 8547 | 8547 | 23445 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2100X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005972.56611 | 2117769.9625 | 37.7953299508697 | -122.423336192004 | (37.7953299508697, -122.423336192004) | |||
| 7761 | 7761 | 23444 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2100X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 9 | 6005977.75981 | 2117720.35574 | 37.795194036322705 | -122.423314692816 | (37.7951940363227, -122.423314692816) | |||
| 6470 | 6470 | 110846 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2776 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000368.55091 | 2117170.43785 | 37.793365941237894 | -122.44268387196999 | (37.7933659412379, -122.44268387197) | |||
| 52323 | 52323 | 126606 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3388 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998604.48648 | 2115920.6274200003 | 37.7898335742166 | -122.448697575531 | (37.7898335742166, -122.448697575531) | |||
| 109130 | 109130 | 119808 | Planning Code 138.1 required 4 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773331 | 6006048.0 | 2115627.0 | 37.789450169199796 | -122.422922798032 | (37.7894501691998, -122.422922798032) | |
| 133083 | 133083 | 250094 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 8 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005324.767440001 | 2115623.21527 | 37.789398941767004 | -122.425424835102 | (37.789398941767, -122.425424835102) | |||
| 22805 | 22805 | 17745 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1600X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006152.6648 | 2115617.75127 | 37.7894306797229 | -122.422560011429 | (37.7894306797229, -122.422560011429) | |||
| 169546 | 169546 | 250104 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6006039.94152 | 2115602.86884 | 37.789383456327705 | -122.422948963731 | (37.7893834563277, -122.422948963731) | |||
| 23295 | 23295 | 9894 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/1997 12:00:00 AM | 23 | 3X3 | 6005329.1496 | 2115601.42673 | 37.7893393634754 | -122.425408122112 | (37.7893393634754, -122.425408122112) | ||
| 183607 | 183607 | 250103 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6006023.8446 | 2115600.71368 | 37.7893766304877 | -122.423004504073 | (37.7893766304877, -122.423004504073) | |||
| 139546 | 139546 | 17753 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006028.796019999 | 2115599.444 | 37.7893734236606 | -122.422987282423 | (37.7893734236606, -122.422987282423) | |||
| 63679 | 63679 | 250102 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6006004.13239 | 2115596.49895 | 37.7893639455439 | -122.42307240646099 | (37.7893639455439, -122.423072406461) | |||
| 88515 | 88515 | 17754 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006002.61013 | 2115594.52588 | 37.789358442083 | -122.423077533013 | (37.789358442083, -122.423077533013) | |||
| 9377 | 9377 | 17756 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005973.81147 | 2115593.81965 | 37.7893548777914 | -122.423177122971 | (37.7893548777914, -122.423177122971) | |||
| 90620 | 90620 | 116853 | Planning Code 138.1 required 4 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | 3X3 | Permit Number 773331 | 6005973.81147 | 2115593.81965 | 37.7893548777914 | -122.423177122971 | (37.7893548777914, -122.423177122971) | |
| 159517 | 159517 | 250101 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6005978.51572 | 2115593.66659 | 37.78935472300171 | -122.42316083590299 | (37.7893547230017, -122.423160835903) | |||
| 9298 | 9298 | 17755 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005983.055346799 | 2115593.0882202997 | 37.789353391125104 | -122.42314508816901 | (37.7893533911251, -122.423145088169) | |||
| 26804 | 26804 | 250105 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6005949.70174 | 2115586.76552 | 37.7893341482864 | -122.423260038317 | (37.7893341482864, -122.423260038317) | |||
| 40055 | 40055 | 250106 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005930.7358800005 | 2115585.60481 | 37.7893298908963 | -122.42332557552601 | (37.7893298908963, -122.423325575526) | |||
| 95123 | 95123 | 17757 | Planning Code 138.1 required 4 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773331 | 6005917.49192 | 2115584.99362 | 37.7893274652545 | -122.42337135467699 | (37.7893274652545, -122.423371354677) | |
| 9504 | 9504 | 17758 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005894.5926 | 2115584.1297299997 | 37.7893238007876 | -122.423450522313 | (37.7893238007876, -122.423450522313) | |||
| 35112 | 35112 | 250107 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005911.45005 | 2115583.3816299997 | 37.7893226981327 | -122.423392144226 | (37.7893226981327, -122.423392144226) | |||
| 130217 | 130217 | 250108 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 4 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6005895.20899 | 2115581.5118400003 | 37.7893166475034 | -122.423448203486 | (37.7893166475034, -122.423448203486) | |||
| 158273 | 158273 | 250109 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 5 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6005867.157869999 | 2115579.68143 | 37.7893100383746 | -122.42354512700899 | (37.7893100383746, -122.423545127009) | |||
| 9564 | 9564 | 17759 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005845.8328233 | 2115574.0220236 | 37.7892932953595 | -122.42361850671999 | (37.7892932953595, -122.42361850672) | |||
| 22410 | 22410 | 9892 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005332.72699 | 2115570.2247599997 | 37.7892538927886 | -122.42539352339199 | (37.7892538927886, -122.425393523392) | |||
| 80357 | 80357 | 17764 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005780.4714382 | 2115564.9404688 | 37.789264670055 | -122.423844003631 | (37.789264670055, -122.423844003631) | |||
| 117458 | 117458 | 17765 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005780.4714382 | 2115564.9404688 | 37.789264670055 | -122.423844003631 | (37.789264670055, -122.423844003631) | |||
| 23186 | 23186 | 17762 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 6005688.226009999 | 2115553.43335 | 37.7892278664309 | -122.424162343438 | (37.7892278664309, -122.424162343438) | ||||
| 22570 | 22570 | 9891 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005334.61917 | 2115551.7772 | 37.7892033473078 | -122.425385663344 | (37.7892033473078, -122.425385663344) | |||
| 22450 | 22450 | 17763 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005669.54525 | 2115550.54053 | 37.7892188686951 | -122.42422677084998 | (37.7892188686951, -122.42422677085) | |||
| 1843 | 1843 | 9890 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005344.337040001 | 2115550.48459 | 37.7892003471598 | -122.42535194865299 | (37.7892003471598, -122.425351948653) | |||
| 188187 | 188187 | 250125 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1730 Pine St | 1 | : 4 | Tree 1 | Private 1 | 25 | Width 4ft | 6005649.1110000005 | 2115549.12657 | 37.7892138324921 | -122.424297370338 | (37.7892138324921, -122.424297370338) | |||
| 22500 | 22500 | 17776 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1762 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005516.07608 | 2115531.08967 | 37.7891567948058 | -122.424756371721 | (37.7891567948058, -122.424756371721) | |||
| 22653 | 22653 | 17778 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1770 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005458.75733 | 2115520.73995 | 37.7891251395545 | -122.424953950985 | (37.7891251395545, -122.424953950985) | |||
| 22379 | 22379 | 17784 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1798X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005418.97388 | 2115516.65721 | 37.7891116821071 | -122.42509130621599 | (37.7891116821071, -122.425091306216) | |||
| 37030 | 37030 | 250127 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1798 Pine St | 4 | : 4 | Tree 1 | Private 1 | 22 | Width 5ft | 6005361.6989 | 2115505.86135 | 37.789078803778295 | -122.425288702018 | (37.7890788037783, -122.425288702018) | |||
| 22519 | 22519 | 17782 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1791 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005428.2033400005 | 2115468.32597 | 37.788979497959296 | -122.425055933202 | (37.7889794979593, -122.425055933202) | |||
| 24203 | 24203 | 137837 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1800X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6005085.0 | 2115443.0 | 37.7888905662133 | -122.42624156812799 | (37.7888905662133, -122.426241568128) | |||
| 92028 | 92028 | 17812 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1900X Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004830.0574482 | 2115432.8862429 | 37.7888483829176 | -122.427122914168 | (37.7888483829176, -122.427122914168) | |||
| 140472 | 140472 | 17811 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1900X Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6004830.0574482 | 2115432.8862429 | 37.7888483829176 | -122.427122914168 | (37.7888483829176, -122.427122914168) | |||
| 178608 | 178608 | 137847 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1900 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6004787.7852 | 2115427.8819 | 37.7888322517036 | -122.427268813718 | (37.7888322517036, -122.427268813718) | |||
| 184969 | 184969 | 137848 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1900 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6004770.9565 | 2115424.5161 | 37.7888220583291 | -122.42732679883301 | (37.7888220583291, -122.427326798833) | |||
| 34797 | 34797 | 137849 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1900 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004722.1533 | 2115420.5894 | 37.7888085164114 | -122.42749537127199 | (37.7888085164114, -122.427495371272) | |||
| 171664 | 171664 | 137851 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1900 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6004700.2761 | 2115415.5408 | 37.7887934168266 | -122.427570703503 | (37.7887934168266, -122.427570703503) | |||
| 1153 | 1153 | 17806 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1881 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6004903.5356 | 2115394.9801 | 37.7887484569995 | -122.42686598915199 | (37.7887484569995, -122.426865989152) | |||
| 6636 | 6636 | 2588 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1710 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1999 12:00:00 AM | 18 | 3 | 6005206.687000001 | 2115142.0135 | 37.788071009916 | -122.42579911500499 | (37.788071009916, -122.425799115005) | ||
| 5622 | 5622 | 87285 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1820 Webster St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 50302 | 6003460.507999999 | 2115059.4384 | 37.7877454479518 | -122.43183468665801 | (37.7877454479518, -122.431834686658) | ||
| 7947 | 7947 | 2629 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1872 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004578.2934 | 2115053.5876 | 37.787792683911 | -122.427966943787 | (37.787792683911, -122.427966943787) | |||
| 31839 | 31839 | 108738 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 22 22nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 5x6 | 5988982.34798 | 2115051.76356 | 37.786893008658296 | -122.481925214884 | (37.7868930086583, -122.481925214884) | |||
| 53672 | 53672 | 108737 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 22 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5x6 | 5988982.16462 | 2115033.23873 | 37.786842134064706 | -122.481924491754 | (37.7868421340647, -122.481924491754) | |||
| 139042 | 139042 | 108739 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 22 22ND AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x6 | 5989006.7 | 2115022.6 | 37.786814349999105 | -122.48183882646299 | (37.7868143499991, -122.481838826463) | ||||
| 98034 | 98034 | 106401 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 22 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5x6 | 5988976.53234 | 2115004.21174 | 37.786762106623705 | -122.481941850779 | (37.7867621066237, -122.481941850779) | |||
| 63071 | 63071 | 138599 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2630 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 0ft | 6001313.0958 | 2114947.1478 | 37.7873151619105 | -122.43925625600001 | (37.7873151619105, -122.439256256) | |||
| 61033 | 61033 | 138601 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2650 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6001240.9537 | 2114939.1951 | 37.7872892203341 | -122.439505281612 | (37.7872892203341, -122.439505281612) | |||
| 94012 | 94012 | 17996 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2650X Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001258.2893795 | 2114937.1034436002 | 37.7872844637831 | -122.43944515397101 | (37.7872844637831, -122.439445153971) | |||
| 113234 | 113234 | 17995 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2650X Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001258.2893795 | 2114937.1034436002 | 37.7872844637831 | -122.43944515397101 | (37.7872844637831, -122.439445153971) | |||
| 141075 | 141075 | 17993 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2650X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001258.2893795 | 2114937.1034436002 | 37.7872844637831 | -122.43944515397101 | (37.7872844637831, -122.439445153971) | |||
| 67905 | 67905 | 138602 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2660 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6001218.2318 | 2114936.9229 | 37.7872816882761 | -122.43958373144699 | (37.7872816882761, -122.439583731447) | |||
| 60209 | 60209 | 124039 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 737 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 6ft | 5993203.99509 | 2114811.08925 | 37.7864767964616 | -122.467301904185 | (37.7864767964616, -122.467301904185) | |||
| 101721 | 101721 | 18107 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3067 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3x3 | 5999321.271546599 | 2114616.8679369 | 37.7862947536085 | -122.446123757059 | (37.7862947536085, -122.446123757059) | |||
| 2560 | 2560 | 138642 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3059 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 0ft | 5999277.8969 | 2114611.151 | 37.7862765793233 | -122.446273410182 | (37.7862765793233, -122.446273410182) | |||
| 165437 | 165437 | 138649 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3073 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5999235.7723 | 2114604.2128 | 37.786255122975504 | -122.44641865052 | (37.7862551229755, -122.44641865052) | |||
| 185697 | 185697 | 138647 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 600 PRESIDIO AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999215.4534 | 2114556.1413 | 37.786121970664894 | -122.44648548868099 | (37.7861219706649, -122.446485488681) | |||
| 97378 | 97378 | 18108 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3071X PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999273.0 | 2114556.0 | 37.7861248694209 | -122.44628638333499 | (37.7861248694209, -122.446286383335) | |||
| 151612 | 151612 | 138646 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 600 PRESIDIO AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999217.4357 | 2114545.2385 | 37.786092147648894 | -122.446477845811 | (37.7860921476489, -122.446477845811) | |||
| 57256 | 57256 | 138645 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 600 PRESIDIO AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5999221.4004 | 2114525.9107 | 37.786039305012004 | -122.446462738067 | (37.786039305012, -122.446462738067) | |||
| 148918 | 148918 | 62209 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 227 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1985 12:00:00 AM | 16 | Permit Number 22331 | 5988338.57879 | 2114482.10714 | 37.7852914335725 | -122.48411069019699 | (37.7852914335725, -122.484110690197) | |
| 28860 | 28860 | 51570 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 227 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2005 12:00:00 AM | 17 | Permit Number 47867 | 5988337.51894 | 2114460.53389 | 37.7852321378524 | -122.48411277430401 | (37.7852321378524, -122.484112774304) | |
| 124001 | 124001 | 99698 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1750 Divisadero St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6001124.0 | 2114376.0 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | |||||
| 140716 | 140716 | 99699 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1750 Divisadero St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6001124.0 | 2114376.0 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | |||||
| 52315 | 52315 | 120312 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 160 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5988698.92527 | 2114284.33233 | 37.784769373123005 | -122.482849516634 | (37.784769373123, -122.482849516634) | |||
| 84641 | 84641 | 118343 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 162 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988772.0 | 2114277.0 | 37.784753492132104 | -122.48259616764 | (37.7847534921321, -122.48259616764) | ||||
| 140133 | 140133 | 12381 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1435 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6004345.46385 | 2113763.0093400003 | 37.7842359045501 | -122.42868045552099 | (37.7842359045501, -122.428680455521) | |||
| 171543 | 171543 | 140328 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1435 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004571.2725 | 2113745.3183 | 37.784200106361105 | -122.427897976235 | (37.7842001063611, -122.427897976235) | |||
| 39832 | 39832 | 141203 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1813 ELLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6002244.2596 | 2112941.8731 | 37.7818621312845 | -122.435891094436 | (37.7818621312845, -122.435891094436) | |||
| 31502 | 31502 | 141200 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1825 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002183.0052 | 2112931.3819999998 | 37.7818298455487 | -122.436102254923 | (37.7818298455487, -122.436102254923) | |||
| 92387 | 92387 | 6315 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1829 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002129.29202 | 2112924.84308 | 37.781808839600394 | -122.43628760910102 | (37.7818088396004, -122.436287609101) | |||
| 163721 | 163721 | 141298 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1835 ELLIS ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6002114.3056 | 2112921.2293 | 37.7817980655656 | -122.436339196325 | (37.7817980655656, -122.436339196325) | |||
| 53025 | 53025 | 141296 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1835 ELLIS ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 6002071.6645 | 2112917.5067 | 37.7817854213105 | -122.436486447843 | (37.7817854213105, -122.436486447843) | |||
| 32861 | 32861 | 141292 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1835 ELLIS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6001970.8148 | 2112901.9393 | 37.7817369459936 | -122.436834225266 | (37.7817369459936, -122.436834225266) | |||
| 82431 | 82431 | 6309 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1807 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002200.5977300005 | 2112898.1085099997 | 37.7817394844201 | -122.43603901136999 | (37.7817394844201, -122.43603901137) | |||
| 188514 | 188514 | 141287 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1855 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 0ft | 6001856.4282 | 2112885.6951 | 37.7816858418255 | -122.43722878495701 | (37.7816858418255, -122.437228784957) | |||
| 77690 | 77690 | 6329 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1895X Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | |||
| 79295 | 79295 | 6333 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1895X Ellis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | |||
| 79767 | 79767 | 6335 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1895X Ellis St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | |||
| 96484 | 96484 | 6324 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1895X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | |||
| 166171 | 166171 | 123313 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401 05th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5994324.87447 | 2112727.37957 | 37.7808201355721 | -122.46327271312599 | (37.7808201355721, -122.463272713126) | |||
| 156619 | 156619 | 123312 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401 05th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994326.95545 | 2112691.62436 | 37.7807220812689 | -122.46326291878201 | (37.7807220812689, -122.463262918782) | |||
| 136459 | 136459 | 123281 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400 06th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5994069.81611 | 2112666.40035 | 37.7806380059293 | -122.464150649226 | (37.7806380059293, -122.464150649226) | |||
| 166280 | 166280 | 123309 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401 05th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5994326.71646 | 2112582.77127 | 37.7804231861892 | -122.463255844547 | (37.7804231861892, -122.463255844547) | |||
| 50686 | 50686 | 139597 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1122 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6000883.0425 | 2112553.4494 | 37.7807181991979 | -122.440572393516 | (37.7807181991979, -122.440572393516) | |||
| 35053 | 35053 | 123308 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401 05th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994328.16527 | 2112546.87269 | 37.7803247018036 | -122.46324822682399 | (37.7803247018036, -122.463248226824) |
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");