trees
725 rows where qCaretaker_id = 6 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3206 | 83039 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 6018611.72965 | 2097767.00037 | 37.7411112833697 | -122.378212851336 | (37.7411112833697, -122.378212851336) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
7035 | 3622 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 58 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017832.21147 | 2098347.65106 | 37.7426626399605 | -122.380948529647 | (37.7426626399605, -122.380948529647) | 10 | 3 | 8 | 58 | 1 | |||
7185 | 3603 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 39 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6018171.24251 | 2098094.76588 | 37.7419869748341 | -122.379758679838 | (37.7419869748341, -122.379758679838) | 10 | 3 | 8 | 58 | 1 | |||
8437 | 83050 | DPW Maintained 1 | Rhamnus californica :: Coffeeberry Tree 320 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 1 | 6018877.26977 | 2097567.07885 | 37.7405769700435 | -122.377280830842 | (37.7405769700435, -122.377280830842) | 10 | 3 | 8 | 58 | 1 | ||||
9540 | 83049 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 11 | 6018864.16071 | 2097578.25634 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | 10 | 3 | 8 | 58 | 1 | ||||
10036 | 83037 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 5 | 6018575.81097 | 2097793.86484 | 37.7411830681528 | -122.378338911137 | (37.7411830681528, -122.378338911137) | 10 | 3 | 8 | 58 | 1 | ||||
10762 | 3628 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 64 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017730.69941 | 2098422.13413 | 37.7428615520079 | -122.381304710649 | (37.7428615520079, -122.381304710649) | 10 | 3 | 8 | 58 | 1 | |||
14274 | 3580 | Permitted Site 7 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
15140 | 83033 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 1 | 6018894.74802 | 2097554.01331 | 37.7405420574702 | -122.377219490814 | (37.7405420574702, -122.377219490814) | 10 | 3 | 8 | 58 | 1 | ||||
16204 | 114507 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 10 LOMBARD ST | 2 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
18663 | 83040 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 6018704.22704 | 2097697.64106 | 37.740925933998 | -122.377888212277 | (37.740925933998, -122.377888212277) | 10 | 3 | 8 | 58 | 1 | ||||
18840 | 83046 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 1 | 6018811.25128 | 2097616.11187 | 37.740707968002 | -122.377512501614 | (37.740707968002, -122.377512501614) | 10 | 3 | 8 | 58 | 1 | ||||
21026 | 114508 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 10 LOMBARD ST | 3 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
26841 | 3665 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 101 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6017153.34624 | 2098900.71457 | 37.7441437469313 | -122.383334362693 | (37.7441437469313, -122.383334362693) | 10 | 3 | 8 | 58 | 1 | |||
26941 | 3606 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 42 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6018122.20462 | 2098131.02661 | 37.7420838344896 | -122.379930757907 | (37.7420838344896, -122.379930757907) | 10 | 3 | 8 | 58 | 1 | |||
29089 | 27944 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | |||
33186 | 3613 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 49 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6018003.94992 | 2098219.94993 | 37.7423214758653 | -122.380345828295 | (37.7423214758653, -122.380345828295) | 10 | 3 | 8 | 58 | 1 | |||
33883 | 3629 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 65 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017712.66324 | 2098437.04484 | 37.7429014981049 | -122.381368111942 | (37.7429014981049, -122.381368111942) | 10 | 3 | 8 | 58 | 1 | |||
34219 | 3678 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 114 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6016900.55326 | 2099090.71493 | 37.7446514753884 | -122.384221703094 | (37.7446514753884, -122.384221703094) | 10 | 3 | 8 | 58 | 1 | |||
35108 | 3688 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 2 | Median : Cutout | Tree | Port 6 | 18 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
35347 | 3691 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 5 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
35545 | 3632 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 68 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017663.5913 | 2098472.76802 | 37.7429968775117 | -122.381540274588 | (37.7429968775117, -122.381540274588) | 10 | 3 | 8 | 58 | 1 | |||
35762 | 3690 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 4 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
38829 | 22089 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6016009.5802 | 2099538.74144 | 37.7458323609698 | -122.387333787882 | (37.7458323609698, -122.387333787882) | 10 | 3 | 8 | 58 | 1 | |||
40398 | 3671 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 107 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6017047.36981 | 2098978.83891 | 37.7443524031345 | -122.38370624765 | (37.7443524031345, -122.38370624765) | 10 | 3 | 8 | 58 | 1 | |||
41537 | 3684 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 120 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6016817.82171 | 2099151.76391 | 37.7448145287778 | -122.384512026728 | (37.7448145287778, -122.384512026728) | 10 | 3 | 8 | 58 | 1 | |||
44228 | 3670 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 106 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6017067.53558 | 2098965.30929 | 37.7443163682077 | -122.383635576218 | (37.7443163682077, -122.383635576218) | 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 | |||
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 | |||
49192 | 27705 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501X The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 6010670.1386197 | 2122042.3573555 | 37.807324899499 | -122.407383090822 | (37.807324899499, -122.407383090822) | 3 | 1 | 10 | 308 | 23 | ||||
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 | |||
50873 | 3679 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 115 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6016884.1224 | 2099103.28613 | 37.7446850848489 | -122.384279393677 | (37.7446850848489, -122.384279393677) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
51968 | 15089 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 30 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | 12 | 2 | 10 | 28855 | 6 | |||
58070 | 3633 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 69 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017649.0599 | 2098484.04513 | 37.7430270398604 | -122.381591304811 | (37.7430270398604, -122.381591304811) | 10 | 3 | 8 | 58 | 1 | |||
58595 | 114506 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 10 LOMBARD ST | 1 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
61953 | 22093 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3400X 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6016015.95987 | 2099423.81611 | 37.745517153054 | -122.387303712363 | (37.745517153054, -122.387303712363) | 10 | 3 | 8 | 58 | 1 | |||
62632 | 3577 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
66260 | 3682 | Permitted Site 7 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 118 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||||
70222 | 3618 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 54 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017899.85524 | 2098296.735 | 37.7425265680461 | -122.380711096061 | (37.7425265680461, -122.380711096061) | 10 | 3 | 8 | 58 | 1 | |||
76120 | 3625 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 61 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017781.37492 | 2098384.59743 | 37.7427612812112 | -122.38112687781 | (37.7427612812112, -122.38112687781) | 10 | 3 | 8 | 58 | 1 | |||
78382 | 121470 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 120X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 8 | 4x4 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
80135 | 121444 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 400X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3x3 | 6013767 | 2118587 | 37.7980101597556 | -122.396423283327 | (37.7980101597556, -122.396423283327) | 3 | 1 | 10 | 28860 | 6 | ||||
81887 | 3680 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 116 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6016866.69606 | 2099115.15257 | 37.7447167041098 | -122.384340477447 | (37.7447167041098, -122.384340477447) | 10 | 3 | 8 | 58 | 1 | |||
85583 | 27704 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 6010670.1386197 | 2122042.3573555 | 37.807324899499 | -122.407383090822 | (37.807324899499, -122.407383090822) | 3 | 1 | 10 | 308 | 23 | ||||
88529 | 3604 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 40 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6018155.72802 | 2098107.78819 | 37.7420218757003 | -122.37981322912 | (37.7420218757003, -122.37981322912) | 10 | 3 | 8 | 58 | 1 | |||
90761 | 28372 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 18 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
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 | |||
95018 | 3626 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 62 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017765.80037 | 2098395.89545 | 37.7427914435713 | -122.381181516112 | (37.7427914435713, -122.381181516112) | 10 | 3 | 8 | 58 | 1 | |||
98286 | 27706 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1801 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 6008269.247115 | 2122709.555122 | 37.8090221854411 | -122.415739206432 | (37.8090221854411, -122.415739206432) | 1 | 10 | 308 | 23 | |||||
100477 | 22088 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 6016008.97261 | 2099546.31799 | 37.7458531309618 | -122.387336417288 | (37.7458531309618, -122.387336417288) | 10 | 3 | 8 | 58 | 1 | ||||
102544 | 27697 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 36 | 10 | 6012224.9996834 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | 3 | 1 | 10 | 28860 | 6 | |||
103402 | 3610 | Private 9 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 46 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6018056.23038 | 2098180.90993 | 37.7422171644003 | -122.380162344118 | (37.7422171644003, -122.380162344118) | 10 | 3 | 8 | 58 | 1 | |||
104325 | 3689 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 3 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
105726 | 3685 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout | Tree | Port 6 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767872 | (37.744924332395, -122.38470767872) | 10 | 3 | 8 | 58 | 1 | |||
109278 | 3570 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
110174 | 27789 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 12 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
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 | |||
112118 | 27788 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 14 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
112320 | 3614 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 50 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017985.84349 | 2098232.4529 | 37.7423548074344 | -122.380409304248 | (37.7423548074344, -122.380409304248) | 10 | 3 | 8 | 58 | 1 | |||
115474 | 22092 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6016011.14545 | 2099476.05696 | 37.7456603290167 | -122.387324003523 | (37.7456603290167, -122.387324003523) | 10 | 3 | 8 | 58 | 1 | |||
116149 | 3609 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 45 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 9 | 3X3 | 6018070.77279 | 2098169.47823 | 37.7421865775631 | -122.380111266222 | (37.7421865775631, -122.380111266222) | 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 | |||
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 | ||||
121228 | 15087 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 30 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | 12 | 2 | 10 | 28855 | 6 | |||
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 | |||
123687 | 3607 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 43 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3x3 | 6018106.23722 | 2098142.91565 | 37.7421155985579 | -122.37998679465 | (37.7421155985579, -122.37998679465) | 10 | 3 | 8 | 58 | 1 | |||
124660 | 3616 | Permitted Site 7 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 52 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017954.33608 | 2098256.07975 | 37.7424179434233 | -122.380519890289 | (37.7424179434233, -122.380519890289) | 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 | |||
125354 | 253413 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 2433 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 3x3 | 5989193.66308 | 2098780.80152 | 37.7422296590049 | -122.480002935505 | (37.7422296590049, -122.480002935505) | 1 | 8 | 3 | 29491 | 35 | |||
125862 | 27707 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1801 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 6008269.247115 | 2122709.555122 | 37.8090221854411 | -122.415739206432 | (37.8090221854411, -122.415739206432) | 1 | 10 | 308 | 23 | |||||
131819 | 3672 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 108 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6017032.37511 | 2098991.89434 | 37.7443874218329 | -122.383759005485 | (37.7443874218329, -122.383759005485) | 10 | 3 | 8 | 58 | 1 | |||
132588 | 3619 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 55 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017883.84962 | 2098309.76703 | 37.7425614680523 | -122.380767345063 | (37.7425614680523, -122.380767345063) | 10 | 3 | 8 | 58 | 1 | |||
133087 | 3612 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 48 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6018020.62827 | 2098207.76094 | 37.7422889275932 | -122.380287312129 | (37.7422889275932, -122.380287312129) | 10 | 3 | 8 | 58 | 1 | |||
137662 | 27936 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 599X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 36 | 4X4 | 6012976.7050293 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | 3 | 1 | 10 | 28860 | 6 | |||
137815 | 27793 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 12 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
140108 | 3669 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 105 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 17 | 3X3 | 6017084.93156 | 2098953.56707 | 37.7442850879842 | -122.383574606702 | (37.7442850879842, -122.383574606702) | 10 | 3 | 8 | 58 | 1 | |||
144881 | 106120 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 849X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 6x9 | 5992954.7 | 2110649.6 | 37.7750360842588 | -122.467861605393 | (37.7750360842588, -122.467861605393) | 11 | 6 | 2 | 54 | 11 | |||
145831 | 27790 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 12 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
146265 | 27698 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 11 | Median : Cutout | Tree | Port 6 | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | |||
147220 | 27937 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 36 | 4X4 | 6013847.17816 | 2118440.89284 | 37.7976134455542 | -122.396135596873 | (37.7976134455542, -122.396135596873) | 3 | 1 | 10 | 28860 | 6 | |||
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 | |||
147907 | 15088 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 30 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | 12 | 2 | 10 | 28855 | 6 | |||
152465 | 27785 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 18 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
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 | |||
157848 | 15086 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 30 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | 12 | 2 | 10 | 28855 | 6 | |||
158492 | 3686 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Cargo Way | 1 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
165984 | 108830 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 46 Ney St | Sidewalk: Curb side : Cutout | Tree | Port 6 | FUF | 3x3 | 6003763.1265 | 2093992.42876 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | 9 | 7 | 6 | 28861 | 5 | ||||
166227 | 121471 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102X King St | 1 | Median : Cutout | Tree | Port 6 | 9 | 3x3 | 6015546.21298 | 2111901.81315 | 37.7797530158304 | -122.389799446797 | (37.7797530158304, -122.389799446797) | 6 | 2 | 9 | 28856 | 20 | |||
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 | |||
171667 | 3630 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 100X Cargo Way | 66 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017698.24794 | 2098446.68655 | 37.7429271764597 | -122.381418626885 | (37.7429271764597, -122.381418626885) | 10 | 3 | 8 | 58 | 1 | |||
179402 | 3687 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 1 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
180464 | 27938 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 36 | 4X4 | 6013758.52527 | 2118508.28044 | 37.7977935429048 | -122.396447087875 | (37.7977935429048, -122.396447087875) | 3 | 1 | 10 | 28860 | 6 | |||
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 | |||
182850 | 3683 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 119 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6016838.58943 | 2099135.269 | 37.7447703855426 | -122.384439066524 | (37.7447703855426, -122.384439066524) | 10 | 3 | 8 | 58 | 1 | |||
183143 | 27786 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 14 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 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) );