Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104863 | 104863 | 106838 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 735 Battery St | 1 | Front Yard : Pot 30 | Tree 1 | Private 1 | Permit Number 773117 | 6012413.67639 | 2118682.92207 | 37.798198135735895 | -122.40111294506201 | (37.7981981357359, -122.401112945062) | ||||
| 111357 | 111357 | 96617 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ Valencia 19th St | 251 | Sidewalk: Property side : 26 | Tree 1 | Rec/Park 3 | Permit Number 771218 | 6006277.0 | 2104934.0 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | ||||
| 139364 | 139364 | 96618 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ 19th St 19th St | 268 | Sidewalk: Property side : 26 | Tree 1 | Rec/Park 3 | Permit Number 771218 | 6006277.0 | 2104934.0 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | ||||
| 1905 | 1905 | 251810 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 3 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 1912 | 1912 | 251809 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 2 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 1921 | 1921 | 251811 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 4 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 86677 | 86677 | 121161 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 92297 | 92297 | 121163 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 92655 | 92655 | 121162 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 100141 | 100141 | 121157 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 100583 | 100583 | 121159 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 108310 | 108310 | 121160 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 145551 | 145551 | 121158 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 25385 | 25385 | 228907 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 7ft | 6002320.43591 | 2108252.4902 | 37.7689905824786 | -122.435292027503 | (37.7689905824786, -122.435292027503) | |||
| 26526 | 26526 | 228904 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6002231.23378 | 2108246.83249 | 37.7689699817064 | -122.435600166732 | (37.7689699817064, -122.435600166732) | ||||
| 74783 | 74783 | 228905 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6002259.19878 | 2108248.90212 | 37.768977252715295 | -122.43550358581801 | (37.7689772527153, -122.435503585818) | ||||
| 160452 | 160452 | 228906 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | 6002292.02781 | 2108250.42967 | 37.768983311465 | -122.435390141758 | (37.768983311465, -122.435390141758) | ||||
| 1149 | 1149 | 19194 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 150 Sanchez St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003510.8594 | 2107438.4604 | 37.7668229855288 | -122.43111632094801 | (37.7668229855288, -122.431116320948) | |||
| 1293 | 1293 | 87727 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2238X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 3 | 3x3 | 6005927.4039 | 2118140.07713 | 37.7963436433 | -122.42351878677799 | (37.7963436433, -122.423518786778) | ||
| 1355 | 1355 | 29680 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006072.343230001 | 2117086.04016 | 37.7934577026643 | -122.422942314134 | (37.7934577026643, -122.422942314134) | ||||
| 1392 | 1392 | 29683 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/11/2012 12:00:00 AM | 5 | 6006051.34304 | 2117188.93929 | 37.793739052873704 | -122.423022293545 | (37.7937390528737, -122.423022293545) | |||
| 1703 | 1703 | 29682 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006057.50051 | 2117137.8264200003 | 37.7935990572132 | -122.422997353566 | (37.7935990572132, -122.422997353566) | ||||
| 1796 | 1796 | 29783 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2000X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 6006016.33701 | 2117432.70817 | 37.794406405577 | -122.423160753176 | (37.794406405577, -122.423160753176) | |||
| 2677 | 2677 | 23213 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 602X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006690.71989 | 2112642.67217 | 37.7812921821228 | -122.42048713258998 | (37.7812921821228, -122.42048713259) | ||
| 2871 | 2871 | 16699 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900 Noriega St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/10/2017 12:00:00 AM | 3 | 8 | 5991131.39821 | 2103159.65216 | 37.7543652389679 | -122.473622260865 | (37.7543652389679, -122.473622260865) | ||
| 3104 | 3104 | 23477 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2400X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | 9 | 6005826.46835 | 2118791.49543 | 37.7981265753418 | -122.423914390454 | (37.7981265753418, -122.423914390454) | |||
| 3615 | 3615 | 23181 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 520X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 3 | 3X3 | 6006739.72815 | 2112299.86395 | 37.7803536757274 | -122.420293249536 | (37.7803536757274, -122.420293249536) | ||
| 4712 | 4712 | 29681 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006062.7062 | 2117112.9687900003 | 37.79353109814161 | -122.42297757386001 | (37.7935310981416, -122.42297757386) | ||||
| 4960 | 4960 | 29281 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/03/2017 12:00:00 AM | 3 | 3X3 | 5998275.9673 | 2100041.3119 | 37.746214221005395 | -122.44869003923701 | (37.7462142210054, -122.448690039237) | ||
| 5715 | 5715 | 23219 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 602X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006682.87351 | 2112699.3573 | 37.7814473835175 | -122.420518302185 | (37.7814473835175, -122.420518302185) | ||
| 5747 | 5747 | 23218 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 602X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006687.798690001 | 2112675.92876 | 37.781383332005795 | -122.420499599884 | (37.7813833320058, -122.420499599884) | ||
| 6071 | 6071 | 29679 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006078.2689 | 2117059.9303200003 | 37.7933863459523 | -122.422919954291 | (37.7933863459523, -122.422919954291) | ||||
| 6504 | 6504 | 87726 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2238X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 3 | 3x3 | 6005930.7522 | 2118113.00552 | 37.796269500484 | -122.42350527534599 | (37.796269500484, -122.423505275346) | ||
| 6688 | 6688 | 87724 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2238X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 6005939.31579 | 2118054.71962 | 37.796109945467 | -122.423471497734 | (37.796109945467, -122.423471497734) | ||
| 7940 | 7940 | 29678 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006081.198059999 | 2117033.1392200002 | 37.793312949587396 | -122.42290791419599 | (37.7933129495874, -122.422907914196) | ||||
| 7950 | 7950 | 29665 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006305.69135 | 2115420.12127 | 37.7888966685937 | -122.422016510665 | (37.7888966685937, -122.422016510665) | ||||
| 8368 | 8368 | 29666 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006311.52888 | 2115387.29695 | 37.7888068703781 | -122.42199398086099 | (37.7888068703781, -122.421993980861) | ||||
| 8805 | 8805 | 87728 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2238X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 3 | 3x3 | 6005924.02898 | 2118165.85324 | 37.7964142274953 | -122.423532298198 | (37.7964142274953, -122.423532298198) | ||
| 8860 | 8860 | 29672 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006314.6376 | 2115355.15166 | 37.788718782705395 | -122.421980940669 | (37.7887187827054, -122.421980940669) | ||||
| 9879 | 9879 | 173721 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 922 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 3x3 | 6012422.0 | 2103621.0 | 37.7568420188621 | -122.40002584196199 | (37.7568420188621, -122.400025841962) | |||
| 9894 | 9894 | 3744 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 906 Carolina St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012418.0 | 2103694.0 | 37.757042237838796 | -122.400044801952 | (37.7570422378388, -122.400044801952) | |||
| 9897 | 9897 | 3762 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1068 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012456.0 | 2103003.0 | 37.7551470216138 | -122.39986486171499 | (37.7551470216138, -122.399864861715) | |||
| 9900 | 9900 | 3764 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1074 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012456.6037355 | 2102966.9856684 | 37.7550481677782 | -122.39986024500799 | (37.7550481677782, -122.399860245008) | |||
| 11332 | 11332 | 1303 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 10 | 5991684.008830001 | 2086976.4673900001 | 37.709962264210404 | -122.47053263188299 | (37.7099622642104, -122.470532631883) | |||
| 12049 | 12049 | 1300 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991824.5048400005 | 2087077.28239 | 37.7102472009077 | -122.470054391311 | (37.7102472009077, -122.470054391311) | |||
| 13013 | 13013 | 1304 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 10 | 5991645.96929 | 2086939.8139900002 | 37.7098594231521 | -122.470661434599 | (37.7098594231521, -122.470661434599) | |||
| 16995 | 16995 | 29288 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998060.68791 | 2099984.96724 | 37.74604719981421 | -122.449430386304 | (37.7460471998142, -122.449430386304) | ||
| 17062 | 17062 | 29260 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5999192.471390001 | 2100264.06623 | 37.746878215651705 | -122.44553690822599 | (37.7468782156517, -122.445536908226) | ||
| 17215 | 17215 | 29296 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997789.65443 | 2099947.6050400003 | 37.745929104439796 | -122.450364887145 | (37.7459291044398, -122.450364887145) | ||
| 17217 | 17217 | 29295 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997814.38842 | 2099950.16176 | 37.745937540096705 | -122.450279545065 | (37.7459375400967, -122.450279545065) | ||
| 17225 | 17225 | 29319 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5994043.25824 | 2097888.70202 | 37.7400607501907 | -122.46316994614901 | (37.7400607501907, -122.463169946149) | ||
| 17418 | 17418 | 16691 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900X Noriega St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/07/2014 11:22:00 AM | 3 | 8 | 5991165.10155 | 2103160.5603099996 | 37.754369684334605 | -122.473505773496 | (37.7543696843346, -122.473505773496) | ||
| 17498 | 17498 | 29269 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998912.29808 | 2100220.6513 | 37.7467430097923 | -122.44650259483 | (37.7467430097923, -122.44650259483) | ||
| 17515 | 17515 | 29294 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997840.39461 | 2099954.53533 | 37.7459510371212 | -122.45018993482799 | (37.7459510371212, -122.450189934828) | ||
| 17543 | 17543 | 29278 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998653.8721 | 2100156.73057 | 37.7465527348295 | -122.447391602559 | (37.7465527348295, -122.447391602559) | ||
| 17679 | 17679 | 29282 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998248.67682 | 2100034.50687 | 37.7461939754832 | -122.44878391585699 | (37.7461939754832, -122.448783915857) | ||
| 17719 | 17719 | 29272 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998824.92396 | 2100202.06446 | 37.7466869838152 | -122.446803387487 | (37.7466869838152, -122.446803387487) | ||
| 17720 | 17720 | 29259 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5999220.77002 | 2100268.2598200003 | 37.7468913457549 | -122.445439356037 | (37.7468913457549, -122.445439356037) | ||
| 17725 | 17725 | 29321 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5994018.9916 | 2097886.0203400003 | 37.740051989006204 | -122.46325365505899 | (37.7400519890062, -122.463253655059) | ||
| 17790 | 17790 | 29316 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5994153.38944 | 2097903.94312 | 37.7401089421748 | -122.462790265877 | (37.7401089421748, -122.462790265877) | ||
| 17944 | 17944 | 29334 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1370X Portola Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5993258.06057 | 2097656.08205 | 37.7393767699331 | -122.465867917696 | (37.7393767699331, -122.465867917696) | ||
| 18092 | 18092 | 16700 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900 Noriega St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 5991103.62763 | 2103160.8111 | 37.754366812778294 | -122.473718382209 | (37.7543668127783, -122.473718382209) | |||
| 18143 | 18143 | 29265 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5999025.51534 | 2100236.39083 | 37.746792692825 | -122.44611223420401 | (37.746792692825, -122.446112234204) | ||
| 18548 | 18548 | 29266 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998997.2091 | 2100232.35941 | 37.7467800070095 | -122.446209824123 | (37.7467800070095, -122.446209824123) | ||
| 18572 | 18572 | 29323 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/22/2012 12:00:00 AM | 3 | 3X3 | 5993969.04975 | 2097881.39537 | 37.7400364127391 | -122.46342599661001 | (37.7400364127391, -122.46342599661) | ||
| 18597 | 18597 | 29287 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998091.100880001 | 2099993.55039 | 37.74607250674529 | -122.44932584102101 | (37.7460725067453, -122.449325841021) | ||
| 18745 | 18745 | 29267 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998970.03803 | 2100227.14985 | 37.7467641510585 | -122.446303403979 | (37.7467641510585, -122.446303403979) | ||
| 18783 | 18783 | 29330 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1370X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5993366.67631 | 2097732.50409 | 37.7395928707266 | -122.46549792578699 | (37.7395928707266, -122.465497925787) | ||
| 18784 | 18784 | 29268 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998941.37722 | 2100224.66623 | 37.746755694716896 | -122.446402331222 | (37.7467556947169, -122.446402331222) | ||
| 18820 | 18820 | 29289 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998035.9028 | 2099979.9539 | 37.7460320165688 | -122.44951572839099 | (37.7460320165688, -122.449515728391) | ||
| 18977 | 18977 | 29313 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5994231.76792 | 2097910.09113 | 37.7401303370506 | -122.462519712915 | (37.7401303370506, -122.462519712915) | ||
| 19044 | 19044 | 29270 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998883.210659999 | 2100216.2513900003 | 37.7467292672476 | -122.446602859341 | (37.7467292672476, -122.446602859341) | ||
| 19299 | 19299 | 2010 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 500X Bosworth St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002516.8064 | 2095305.3641599999 | 37.73345199401611 | -122.4336873366 | (37.7334519940161, -122.4336873366) | |||
| 19438 | 19438 | 29284 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998192.81111 | 2100018.4665 | 37.7461467376997 | -122.448975936387 | (37.7461467376997, -122.448975936387) | ||
| 19570 | 19570 | 29257 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5999277.42958 | 2100279.63386 | 37.7469258104704 | -122.445244250841 | (37.7469258104704, -122.445244250841) | ||
| 19571 | 19571 | 29320 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5994095.3356099995 | 2097893.2819999997 | 37.7400763255621 | -122.46299021752701 | (37.7400763255621, -122.462990217527) | ||
| 19608 | 19608 | 18111 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 800X Portola Dr | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5996440.99331 | 2099037.01768 | 37.7433515782233 | -122.454962561367 | (37.7433515782233, -122.454962561367) | |||
| 19929 | 19929 | 29331 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1370X Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5993344.402430001 | 2097719.44913 | 37.7395557404015 | -122.46557399044201 | (37.7395557404015, -122.465573990442) | ||
| 20019 | 20019 | 29275 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998740.190880001 | 2100180.3435 | 37.746622502434604 | -122.447094821775 | (37.7466225024346, -122.447094821775) | ||
| 20198 | 20198 | 29322 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5993993.68719 | 2097884.77834 | 37.740047120975795 | -122.46334105655001 | (37.7400471209758, -122.46334105655) | ||
| 20269 | 20269 | 18110 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 800X Portola Dr | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5996459.60487 | 2099059.48795 | 37.743414343713496 | -122.454899830974 | (37.7434143437135, -122.454899830974) | |||
| 20310 | 20310 | 29332 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1370X Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5993324.09151 | 2097709.32761 | 37.7395267777402 | -122.46564348107599 | (37.7395267777402, -122.465643481076) | ||
| 20325 | 20325 | 29327 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5993837.34412 | 2097865.72316 | 37.7399857917194 | -122.463880239694 | (37.7399857917194, -122.463880239694) | ||
| 20344 | 20344 | 29279 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998626.66083 | 2100149.5969599998 | 37.7465315926684 | -122.447485182414 | (37.7465315926684, -122.447485182414) | ||
| 20359 | 20359 | 2009 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 500X Bosworth St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002500.74236 | 2095308.75952 | 37.733460405376896 | -122.433743117057 | (37.7334604053769, -122.433743117057) | |||
| 20530 | 20530 | 29293 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997866.991830001 | 2099957.66738 | 37.7459611589878 | -122.450098191397 | (37.7459611589878, -122.450098191397) | ||
| 20732 | 20732 | 29280 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998304.529680001 | 2100049.9335 | 37.7462395270381 | -122.448591895321 | (37.7462395270381, -122.448591895321) | ||
| 20786 | 20786 | 29273 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998795.79674 | 2100195.7409 | 37.746667956864705 | -122.446903651091 | (37.7466679568647, -122.446903651091) | ||
| 20820 | 20820 | 29258 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5999250.29373 | 2100273.6231400003 | 37.7469077575053 | -122.445337651705 | (37.7469077575053, -122.445337651705) | ||
| 20940 | 20940 | 29291 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997922.049269999 | 2099964.50784 | 37.745983091647794 | -122.449908304018 | (37.7459830916478, -122.449908304018) | ||
| 21114 | 21114 | 29333 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1370X Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5993273.372359999 | 2097673.8811 | 37.739426524925705 | -122.46581626961999 | (37.7394265249257, -122.46581626962) | ||
| 21209 | 21209 | 29264 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/22/2012 12:00:00 AM | 3 | 3X3 | 5999080.203980001 | 2100244.87798 | 37.7468191194128 | -122.445923737208 | (37.7468191194128, -122.445923737208) | ||
| 21256 | 21256 | 29314 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/22/2012 12:00:00 AM | 3 | 3X3 | 5994206.18495 | 2097907.75688 | 37.7401224544761 | -122.462607998475 | (37.7401224544761, -122.462607998475) | ||
| 21271 | 21271 | 29317 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5994128.99841 | 2097899.53327 | 37.7400954289716 | -122.462874279628 | (37.7400954289716, -122.462874279628) | ||
| 21286 | 21286 | 29318 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5994068.94113 | 2097890.9993 | 37.740068537431796 | -122.46308131256 | (37.7400685374318, -122.46308131256) | ||
| 21298 | 21298 | 29263 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5999110.43452 | 2100248.4843 | 37.7468307476434 | -122.4458194626 | (37.7468307476434, -122.4458194626) | ||
| 21414 | 21414 | 29328 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5993805.9299800005 | 2097861.77346 | 37.7399731364485 | -122.463988569318 | (37.7399731364485, -122.463988569318) | ||
| 21481 | 21481 | 29283 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998220.11441 | 2100025.88533 | 37.7461686694535 | -122.44888205975599 | (37.7461686694535, -122.448882059756) | ||
| 21558 | 21558 | 29276 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5998710.28271 | 2100173.65077 | 37.7466024169627 | -122.44719775908399 | (37.7466024169627, -122.447197759084) | ||
| 21567 | 21567 | 29297 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997761.734019999 | 2099940.1995 | 37.7459071726754 | -122.45046089786501 | (37.7459071726754, -122.450460897865) |
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");