trees
725 rows where qCaretaker_id = 6 sorted by SiteOrder descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31657 | 3663 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 99 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/12/1990 12:00:00 AM | 3 | 3X3 | 6017184.0839 | 2098879.25737 | 37.744086528482 | -122.383226584333 | (37.744086528482, -122.383226584333) | 10 | 3 | 8 | 58 | 1 | ||
129031 | 3661 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 97 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 12:21:00 PM | 3 | 3X3 | 6017220.32274 | 2098859.87245 | 37.7440353039781 | -122.383099928312 | (37.7440353039781, -122.383099928312) | 10 | 3 | 8 | 58 | 1 | ||
181394 | 3660 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 96 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6017231.85716 | 2098842.1766 | 37.7439873521291 | -122.383058813116 | (37.7439873521291, -122.383058813116) | 10 | 3 | 8 | 58 | 1 | |||
125045 | 3659 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 95 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017251.66004 | 2098826.19142 | 37.7439445542915 | -122.382989226284 | (37.7439445542915, -122.382989226284) | 10 | 3 | 8 | 58 | 1 | |||
116226 | 3658 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 94 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3x3 | 6017265.72601 | 2098814.03291 | 37.7439119466908 | -122.382939742901 | (37.7439119466908, -122.382939742901) | 10 | 3 | 8 | 58 | 1 | |||
79530 | 3657 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 93 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017283.49959 | 2098800.90892 | 37.7438768929081 | -122.382877372202 | (37.7438768929081, -122.382877372202) | 10 | 3 | 8 | 58 | 1 | |||
146138 | 3656 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 92 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017299.77103 | 2098787.22136 | 37.7438402086508 | -122.382820156452 | (37.7438402086508, -122.382820156452) | 10 | 3 | 8 | 58 | 1 | ||
185865 | 3655 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 91 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017319.27606 | 2098771.24223 | 37.7437974108278 | -122.382751600221 | (37.7437974108278, -122.382751600221) | 10 | 3 | 8 | 58 | 1 | |||
111667 | 3654 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 90 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017326.20806 | 2098774.96233 | 37.7438080084417 | -122.382727889579 | (37.7438080084417, -122.382727889579) | 10 | 3 | 8 | 58 | 1 | |||
22525 | 25795 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 9 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012764.87501 | 2119980.67701 | 37.8017810445969 | -122.399988868692 | (37.8017810445969, -122.399988868692) | 3 | 1 | 10 | 28860 | 6 | ||
27053 | 28041 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011990.99673 | 2120961.47906 | 37.8044309119265 | -122.402735877865 | (37.8044309119265, -122.402735877865) | 3 | 1 | 10 | 28860 | 6 | ||
45116 | 83043 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/18/2017 02:49:00 PM | 3 | 6018760.27201 | 2097656.07243 | 37.7408148829885 | -122.377691543139 | (37.7408148829885, -122.377691543139) | 10 | 3 | 8 | 58 | 1 | |||
45885 | 27915 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015885.75101 | 2112369.77501 | 37.7810567572813 | -122.388657501594 | (37.7810567572813, -122.388657501594) | 6 | 2 | 9 | 28856 | 20 | ||
47018 | 27972 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
57168 | 27558 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
63790 | 25623 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015040.91701 | 2116748.90601 | 37.7930339912858 | -122.391886530718 | (37.7930339912858, -122.391886530718) | 12 | 2 | 9 | 28855 | 6 | ||
67552 | 27792 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X The Embarcadero | 9 | Median : Cutout | Tree | Port 6 | 12 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
69024 | 28053 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
89590 | 25813 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012345.50187 | 2120516.10099 | 37.8032277988787 | -122.401477754221 | (37.8032277988787, -122.401477754221) | 3 | 1 | 10 | 28860 | 6 | ||
99012 | 25833 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.9996834 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | 3 | 1 | 10 | 28860 | 6 | ||
100275 | 27810 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
102058 | 27879 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015993.923 | 2113447.225 | 37.7840211872639 | -122.388358500511 | (37.7840211872639, -122.388358500511) | 6 | 2 | 9 | 28856 | 6 | |||
105856 | 3574 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
117657 | 28012 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014204.97801 | 2117711.57201 | 37.7956308037617 | -122.394846399273 | (37.7956308037617, -122.394846399273) | 4 | 2 | 10 | 28860 | 6 | ||
119858 | 27836 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
129131 | 22096 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/16/1995 12:00:00 AM | 3 | 3X3 | 6016015.13995 | 2099327.44393 | 37.7452524895199 | -122.38729982623 | (37.7452524895199, -122.38729982623) | 10 | 3 | 8 | 58 | 1 | ||
133427 | 25744 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 9 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
147859 | 25892 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
166741 | 25845 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013327.75405 | 2119068.43707 | 37.799307618121 | -122.397977001961 | (37.799307618121, -122.397977001961) | 3 | 1 | 10 | 28860 | 6 | ||
183502 | 25656 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
187664 | 28029 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 9 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014304.80501 | 2117713.74201 | 37.7956423121436 | -122.394501129585 | (37.7956423121436, -122.394501129585) | 4 | 2 | 10 | 28860 | 6 | ||
49765 | 3653 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 89 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017331.73303 | 2098760.60047 | 37.7437688789233 | -122.382707786159 | (37.7437688789233, -122.382707786159) | 10 | 3 | 8 | 58 | 1 | |||
100284 | 3652 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 88 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017348.88964 | 2098746.4497 | 37.7437309716031 | -122.382647477613 | (37.7437309716031, -122.382647477613) | 10 | 3 | 8 | 58 | 1 | ||
74679 | 3651 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 87 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6017363.38197 | 2098733.24342 | 37.7436955104472 | -122.382596447366 | (37.7436955104472, -122.382596447366) | 10 | 3 | 8 | 58 | 1 | ||
185227 | 3650 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 86 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:18:00 AM | 3 | 3X3 | 6017379.34335 | 2098718.96834 | 37.7436571957134 | -122.382540263146 | (37.7436571957134, -122.382540263146) | 10 | 3 | 8 | 58 | 1 | ||
188967 | 3649 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 85 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017394.85513 | 2098704.55396 | 37.7436184736271 | -122.382485623916 | (37.7436184736271, -122.382485623916) | 10 | 3 | 8 | 58 | 1 | ||
185262 | 3648 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 84 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017409.48154 | 2098690.6025 | 37.7435809736936 | -122.382434078367 | (37.7435809736936, -122.382434078367) | 10 | 3 | 8 | 58 | 1 | ||
76384 | 3647 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 83 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017425.17191 | 2098677.66921 | 37.7435463281955 | -122.382378924746 | (37.7435463281955, -122.382378924746) | 10 | 3 | 8 | 58 | 1 | ||
141162 | 3646 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 82 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:16:00 AM | 3 | 3X3 | 6017441.11571 | 2098662.50366 | 37.7435055673357 | -122.3823227396 | (37.7435055673357, -122.3823227396) | 10 | 3 | 8 | 58 | 1 | ||
84328 | 3645 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 81 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017457.23238 | 2098648.52258 | 37.7434680683118 | -122.382266039154 | (37.7434680683118, -122.382266039154) | 10 | 3 | 8 | 58 | 1 | ||
81580 | 3644 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 80 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:15:00 AM | 3 | 3X3 | 6017471.84094 | 2098633.68097 | 37.7434281231236 | -122.382214493629 | (37.7434281231236, -122.382214493629) | 10 | 3 | 8 | 58 | 1 | ||
9581 | 28011 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014191.95801 | 2117739.78401 | 37.795707543335 | -122.394893427962 | (37.795707543335, -122.394893427962) | 4 | 2 | 10 | 28860 | 6 | ||
21692 | 25812 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012332.09199 | 2120538.66398 | 37.803289003136 | -122.401525746517 | (37.803289003136, -122.401525746517) | 3 | 1 | 10 | 28860 | 6 | ||
32522 | 28040 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011973.34792 | 2120976.9306 | 37.8044723526732 | -122.402798040815 | (37.8044723526732, -122.402798040815) | 3 | 1 | 10 | 28860 | 6 | ||
55797 | 25655 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
71485 | 27847 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 280 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.7974866246707 | -122.395833154489 | (37.7974866246707, -122.395833154489) | 3 | 1 | 10 | 28860 | 6 | |||
79273 | 26024 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6012483.6012207 | 2120310.1113669 | 37.8026699057947 | -122.400985372375 | (37.8026699057947, -122.400985372375) | 3 | 1 | 10 | 28860 | 6 | ||
87700 | 25891 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
89464 | 27878 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015996.527 | 2113472.746 | 37.784091406469 | -122.388351273372 | (37.784091406469, -122.388351273372) | 6 | 2 | 9 | 28856 | 6 | |||
92662 | 27557 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
94317 | 3573 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 09:44:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
116952 | 27791 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 12 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
124214 | 25844 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013309.3136 | 2119095.04373 | 37.7993796466195 | -122.398042680326 | (37.7993796466195, -122.398042680326) | 3 | 1 | 10 | 28860 | 6 | ||
129757 | 27951 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
145567 | 25743 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
152226 | 27914 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015893.34601 | 2112392.56101 | 37.7811197434466 | -122.388632817528 | (37.7811197434466, -122.388632817528) | 6 | 2 | 9 | 28856 | 20 | ||
152629 | 28052 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
152632 | 25794 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012712.79201 | 2120057.50001 | 37.8019890781012 | -122.400174499685 | (37.8019890781012, -122.400174499685) | 3 | 1 | 10 | 28860 | 6 | ||
157798 | 27971 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
162174 | 27939 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 36 | 4X4 | 6013788.66429 | 2118525.16075 | 37.7978415693921 | -122.396343981507 | (37.7978415693921, -122.396343981507) | 3 | 1 | 10 | 28860 | 6 | |||
162873 | 27835 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
163950 | 27809 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
167448 | 22095 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6016014.43703 | 2099301.13659 | 37.7451802160606 | -122.387300422076 | (37.7451802160606, -122.387300422076) | 10 | 3 | 8 | 58 | 1 | |||
172631 | 27853 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015772.90401 | 2112134.31501 | 37.7804039822192 | -122.389031454309 | (37.7804039822192, -122.389031454309) | 6 | 2 | 9 | 28856 | 20 | ||
182446 | 25832 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.9996834 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | 3 | 1 | 10 | 28860 | 6 | ||
191559 | 28028 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014289.61401 | 2117737.61301 | 37.7957070117951 | -122.394555365911 | (37.7957070117951, -122.394555365911) | 4 | 2 | 10 | 28860 | 6 | ||
193365 | 25622 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015012.27101 | 2116778.85401 | 37.7931146312154 | -122.391987743488 | (37.7931146312154, -122.391987743488) | 12 | 2 | 9 | 28855 | 6 | ||
6877 | 3643 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 79 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017487.6627 | 2098619.8542 | 37.7433910314633 | -122.382158823763 | (37.7433910314633, -122.382158823763) | 10 | 3 | 8 | 58 | 1 | |||
152854 | 3642 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 78 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017503.4842 | 2098606.02713 | 37.7433539389383 | -122.382103154832 | (37.7433539389383, -122.382103154832) | 10 | 3 | 8 | 58 | 1 | |||
147473 | 3641 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 77 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/01/2017 03:31:00 PM | 3 | 3X3 | 6017517.08856 | 2098593.13553 | 37.7433192925522 | -122.38205521739 | (37.7433192925522, -122.38205521739) | 10 | 3 | 8 | 58 | 1 | ||
147659 | 3640 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 76 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017536.43295 | 2098576.56598 | 37.7432748642351 | -122.381987176477 | (37.7432748642351, -122.381987176477) | 10 | 3 | 8 | 58 | 1 | |||
42308 | 3639 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 75 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017551.66161 | 2098562.89956 | 37.743238180002 | -122.381933568796 | (37.743238180002, -122.381933568796) | 10 | 3 | 8 | 58 | 1 | ||
47874 | 3638 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 74 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017567.18226 | 2098548.9302 | 37.7432006800566 | -122.381878930467 | (37.7432006800566, -122.381878930467) | 10 | 3 | 8 | 58 | 1 | |||
94777 | 3637 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 73 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017581.37685 | 2098535.7297 | 37.7431652179942 | -122.381828930869 | (37.7431652179942, -122.381828930869) | 10 | 3 | 8 | 58 | 1 | |||
123427 | 3636 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 72 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017599.14752 | 2098522.45762 | 37.7431297568333 | -122.381766561086 | (37.7431297568333, -122.381766561086) | 10 | 3 | 8 | 58 | 1 | |||
176316 | 3635 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 71 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/31/1996 12:00:00 AM | 3 | 3x3 | 6017615.70257 | 2098508.02238 | 37.7430910347139 | -122.381708313812 | (37.7430910347139, -122.381708313812) | 10 | 3 | 8 | 58 | 1 | ||
49190 | 3634 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 70 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017632.60306 | 2098495.95511 | 37.7430588336066 | -122.381649036799 | (37.7430588336066, -122.381649036799) | 10 | 3 | 8 | 58 | 1 | |||
9569 | 25843 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013291.71436 | 2119122.7738 | 37.7994548065492 | -122.398105526769 | (37.7994548065492, -122.398105526769) | 3 | 1 | 10 | 28860 | 6 | ||
21464 | 25831 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.9996834 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | 3 | 1 | 10 | 28860 | 6 | ||
22521 | 25890 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
26048 | 27877 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6016000.173 | 2113494.1 | 37.7841502417687 | -122.388340150307 | (37.7841502417687, -122.388340150307) | 6 | 2 | 9 | 28856 | 6 | |||
35010 | 26023 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6012483.6012207 | 2120310.1113669 | 37.8026699057947 | -122.400985372375 | (37.8026699057947, -122.400985372375) | 3 | 1 | 10 | 28860 | 6 | ||
41379 | 28039 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011949.43377 | 2121001.73319 | 37.8045391192453 | -122.402882543817 | (37.8045391192453, -122.402882543817) | 3 | 1 | 10 | 28860 | 6 | ||
42378 | 27556 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
44312 | 27834 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
51450 | 22094 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6016017.00918 | 2099367.08567 | 37.7453614410817 | -122.38729612742 | (37.7453614410817, -122.38729612742) | 10 | 3 | 8 | 58 | 1 | |||
83247 | 27970 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
86229 | 25621 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014992.74001 | 2116800.99001 | 37.7931743271891 | -122.392056871184 | (37.7931743271891, -122.392056871184) | 12 | 2 | 9 | 28855 | 6 | ||
91923 | 25642 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 550X The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.8234673 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | 3 | 1 | 10 | 28860 | 6 | ||
96291 | 25811 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012315.25762 | 2120560.32708 | 37.8033475454092 | -122.401585526252 | (37.8033475454092, -122.401585526252) | 3 | 1 | 10 | 28860 | 6 | ||
99231 | 25742 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
108085 | 28010 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014178.93701 | 2117764.74001 | 37.7957753426227 | -122.394940232051 | (37.7957753426227, -122.394940232051) | 4 | 1 | 10 | 28860 | 6 | ||
110564 | 25654 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
111729 | 28027 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014263.57201 | 2117754.97501 | 37.795753235969 | -122.394646693031 | (37.795753235969, -122.394646693031) | 4 | 2 | 10 | 28860 | 6 | ||
122064 | 27549 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1301X Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/05/2001 12:00:00 AM | 10 | 3X3 | 6016173.411126 | 2103023.95301 | 37.7554110972717 | -122.387010312465 | (37.7554110972717, -122.387010312465) | 10 | 3 | 8 | 28856 | 29 | ||
124280 | 25793 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012660.70901 | 2120133.02101 | 37.802193536328 | -122.400360040215 | (37.802193536328, -122.400360040215) | 3 | 1 | 10 | 28860 | 6 | ||
132259 | 28003 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
135109 | 27957 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.393196597915 | (37.7940982979938, -122.393196597915) | 12 | 2 | 10 | 28855 | 6 | |||
136776 | 25754 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011423.5148387 | 2121491.4283584 | 37.805854321699 | -122.404737040358 | (37.805854321699, -122.404737040358) | 3 | 1 | 10 | 28860 | 23 | ||
138931 | 27784 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 20 | 6013580.1568022 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | 3 | 1 | 10 | 28860 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );