trees
27,746 rows where qCaretaker_id = 1 sorted by Supervisor Districts 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10234 | 85811 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1675 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007516 | 2108769 | 37.7707024771995 | -122.417357464156 | (37.7707024771995, -122.417357464156) | 8 | 2 | 9 | 28853 | 19 | ||
| 10535 | 258146 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1048 Folsom St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010642.12041 | 2111257.36423 | 37.7777103373451 | -122.406719502289 | (37.7777103373451, -122.406719502289) | 14 | 2 | 9 | 28853 | 34 | ||||
| 10663 | 264778 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 10695 | 258140 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x3 | 6014765.94263 | 2115143.61778 | 37.7886109721909 | -122.39272561329 | (37.7886109721909, -122.39272561329) | 6 | 2 | 9 | 28855 | 6 | ||
| 10834 | 25708 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 586 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6012145.80041 | 2110254.86265 | 37.7750417149432 | -122.401447254602 | (37.7750417149432, -122.401447254602) | 14 | 2 | 9 | 28853 | 34 | |||
| 10885 | 13675 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011805.84433 | 2114919.40836 | 37.7878304980227 | -122.402951392291 | (37.7878304980227, -122.402951392291) | 12 | 2 | 9 | 28855 | 6 | |
| 10899 | 85668 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 595 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013195 | 2111894 | 37.7796008978727 | -122.397932828244 | (37.7796008978727, -122.397932828244) | 6 | 2 | 9 | 28856 | 34 | ||
| 10971 | 261558 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 900 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011458 | 2112074 | 37.7799982447009 | -122.403954562266 | (37.7799982447009, -122.403954562266) | 14 | 2 | 9 | 28853 | 34 | ||||
| 11086 | 242374 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x McCoppin St | 2 | Median : Yard | Tree | DPW 1 | 5 | Width 9ft | 6006546.0037 | 2109148.19709 | 37.7716890396519 | -122.420739627149 | (37.7716890396519, -122.420739627149) | 8 | 2 | 9 | 28853 | 19 | |||
| 11260 | 28200 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2014 01:37:00 PM | 3 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | |||
| 11274 | 13515 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 333 Market St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/25/2019 10:27:00 AM | 3 | 4X4 | 6013400.91851 | 2116448.99876 | 37.7921193351998 | -122.397540013255 | (37.7921193351998, -122.397540013255) | 12 | 2 | 9 | 28855 | 6 | ||
| 11369 | 28185 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 11514 | 258968 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 11646 | 23200 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 520X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006725.22564 | 2112390.29825 | 37.7806011691535 | -122.420349841196 | (37.7806011691535, -122.420349841196) | 7 | 9 | 9 | 28852 | 36 | |||
| 11719 | 264769 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 11739 | 264780 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 11906 | 13674 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011788.8197 | 2114903.8104 | 37.787786719038 | -122.403009197144 | (37.787786719038, -122.403009197144) | 12 | 2 | 9 | 28855 | 6 | |
| 12025 | 261554 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 900 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011458 | 2112074 | 37.7799982447009 | -122.403954562266 | (37.7799982447009, -122.403954562266) | 14 | 2 | 9 | 28853 | 34 | ||||
| 12086 | 264891 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
| 12378 | 195679 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102x King St | 8 | Median : Yard | Tree | DPW 1 | 9 | Width 10ft | 6015392.54447 | 2111760.15634 | 37.7793555352731 | -122.390321157906 | (37.7793555352731, -122.390321157906) | 6 | 2 | 9 | 28856 | 20 | |||
| 12491 | 85685 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 690X Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012554.937239 | 2111333.645207 | 37.7780266247864 | -122.400107730612 | (37.7780266247864, -122.400107730612) | 6 | 2 | 9 | 28856 | 34 | ||
| 12524 | 29159 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 532 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2005 12:00:00 AM | 8 | 3x3 | 6008904.683107 | 2114354.7787345 | 37.7861177338401 | -122.412948968266 | (37.7861177338401, -122.412948968266) | 5 | 10 | 9 | 28852 | 36 | ||
| 12634 | 264775 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 90x Guy Pl | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 12886 | 13992 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1159X Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 4X4 | 6008630.3431005 | 2111901.9984248 | 37.7793675842244 | -122.413724560263 | (37.7793675842244, -122.413724560263) | 8 | 2 | 9 | 28853 | 34 | |||
| 12931 | 264773 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 12997 | 258944 | DPW Maintained 1 | :: 45 | 190 Freelon St | 1 | Sidewalk: Curb side : Yard | Landscaping | DPW 1 | Width 2ft | 6013228 | 2111376 | 37.7781804260272 | -122.397782321929 | (37.7781804260272, -122.397782321929) | 6 | 2 | 9 | 28856 | 34 | ||||
| 13023 | 14150 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1693 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/1994 12:00:00 AM | 6 | 4X4 | 6006142.83121 | 2109505.65956 | 37.7726478140652 | -122.422159627874 | (37.7726478140652, -122.422159627874) | 8 | 2 | 9 | 28853 | 19 | ||
| 13225 | 13427 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6014172.84776 | 2117212.91542 | 37.7942598232708 | -122.394922634488 | (37.7942598232708, -122.394922634488) | 12 | 2 | 9 | 28855 | 6 | |||
| 13415 | 264888 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
| 13451 | 261552 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 900 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011458 | 2112074 | 37.7799982447009 | -122.403954562266 | (37.7799982447009, -122.403954562266) | 14 | 2 | 9 | 28853 | 34 | ||||
| 13492 | 261464 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101x King St | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 6015505 | 2111943 | 37.7798638201711 | -122.3899448996 | (37.7798638201711, -122.3899448996) | 6 | 2 | 9 | 28856 | 20 | ||||
| 13723 | 28995 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 405 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6009327.356374 | 2109037.9792973 | 37.7715427770518 | -122.41111093135 | (37.7715427770518, -122.41111093135) | 8 | 2 | 9 | 28853 | 34 | ||
| 13946 | 13996 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1169 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4X4 | 6008486.6991 | 2111764.6137 | 37.7789822910049 | -122.414211764042 | (37.7789822910049, -122.414211764042) | 8 | 2 | 9 | 28853 | 34 | |||
| 14092 | 23172 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 214 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006926.9126711 | 2111261.9734357 | 37.7775144249112 | -122.419572031751 | (37.7775144249112, -122.419572031751) | 7 | 9 | 9 | 28852 | 36 | |||
| 14289 | 113566 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | |||||
| 14331 | 13971 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1150X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6008925.3091 | 2112314.2981 | 37.780516220741 | -122.412733301341 | (37.780516220741, -122.412733301341) | 7 | 2 | 9 | 28852 | 36 | |||
| 14526 | 15114 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014005.1464 | 2116140.60731 | 37.7913061897683 | -122.39542774681 | (37.7913061897683, -122.39542774681) | 12 | 2 | 9 | 28855 | 6 | |||
| 14687 | 261555 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 900 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011458 | 2112074 | 37.7799982447009 | -122.403954562266 | (37.7799982447009, -122.403954562266) | 14 | 2 | 9 | 28853 | 34 | ||||
| 14760 | 14019 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1202X Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008302.0435949 | 2111690.8561203 | 37.7787693964066 | -122.414845342067 | (37.7787693964066, -122.414845342067) | 7 | 2 | 9 | 28852 | 36 | |||
| 14862 | 14092 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1455 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007204.2526311 | 2110536.5858952 | 37.7755383026332 | -122.418561167244 | (37.7755383026332, -122.418561167244) | 8 | 2 | 9 | 28853 | 34 | |||
| 14967 | 108631 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 501 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008465.6 | 2113811.6 | 37.7846016393538 | -122.4144296353 | (37.7846016393538, -122.4144296353) | 7 | 10 | 9 | 28852 | 36 | ||||
| 15114 | 264890 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
| 15137 | 258158 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1180 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6009302.702 | 2110851.89805 | 37.7765219905974 | -122.411324376274 | (37.7765219905974, -122.411324376274) | 8 | 2 | 9 | 28853 | 34 | |||
| 15169 | 15317 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1680 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/05/2012 12:00:00 AM | 3 | 3x3 | 6006793.132 | 2108776.031 | 37.770681085644 | -122.419858380205 | (37.770681085644, -122.419858380205) | 8 | 2 | 9 | 28853 | 19 | ||
| 15226 | 13516 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 333 Market St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/25/2019 10:28:00 AM | 3 | 4X4 | 6013416.01001 | 2116477.20786 | 37.7921976310616 | -122.397489775359 | (37.7921976310616, -122.397489775359) | 12 | 2 | 9 | 28855 | 6 | ||
| 15329 | 264906 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 15384 | 258139 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6014765.94263 | 2115143.61778 | 37.7886109721909 | -122.39272561329 | (37.7886109721909, -122.39272561329) | 6 | 2 | 9 | 28855 | 6 | ||
| 15449 | 85521 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2013 12:00:00 AM | 3 | 6008760.539184 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | 8 | 2 | 9 | 28853 | 19 | |||
| 15460 | 28991 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 455 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | Permit Number 768492 | 6009536.6012657 | 2108818.9260503 | 37.7709530398216 | -122.410371669109 | (37.7709530398216, -122.410371669109) | 8 | 2 | 9 | 28853 | 34 | |
| 15562 | 13517 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 333 Market St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/25/2019 10:29:00 AM | 3 | 4X4 | 6013425.11955 | 2116468.99078 | 37.7921755761007 | -122.397457679444 | (37.7921755761007, -122.397457679444) | 12 | 2 | 9 | 28855 | 6 | ||
| 15597 | 91581 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007370.010963 | 2108444.137303 | 37.7698022661703 | -122.417839412441 | (37.7698022661703, -122.417839412441) | 8 | 4 | 9 | 28853 | 19 | ||
| 15616 | 264771 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 15765 | 258114 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 22 Isis St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6008329.87381 | 2108642.20827 | 37.7704000939468 | -122.414533279126 | (37.7704000939468, -122.414533279126) | 8 | 2 | 9 | 28853 | 19 | |||||
| 15778 | 261461 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101x King St | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6015315 | 2111580 | 37.7788565647244 | -122.390576826723 | (37.7788565647244, -122.390576826723) | 6 | 2 | 9 | 28856 | 20 | ||||
| 15880 | 13817 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 954 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6009970.251578 | 2113291.7135456 | 37.7832585661446 | -122.409187326391 | (37.7832585661446, -122.409187326391) | 14 | 2 | 9 | 28852 | 36 | |||
| 16115 | 194311 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 21 | Width 7ft | 6015171.22981 | 2116694.38601 | 37.7928915254696 | -122.391431824244 | (37.7928915254696, -122.391431824244) | 12 | 2 | 9 | 28855 | 6 | |||
| 16125 | 260551 | DPW Maintained 1 | Tree(s) :: 17 | 937 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011850 | 2111438 | 37.7782738288903 | -122.402553714468 | (37.7782738288903, -122.402553714468) | 14 | 2 | 9 | 28856 | 34 | ||||
| 16208 | 194334 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 88x King St | 10 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6015942.04821 | 2112270.67914 | 37.7807877820727 | -122.388455820993 | (37.7807877820727, -122.388455820993) | 6 | 2 | 9 | 28856 | 20 | |||
| 16417 | 13739 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 801 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4X4 | 6010847.3962 | 2114014.37863 | 37.7852919349113 | -122.406203672671 | (37.7852919349113, -122.406203672671) | 12 | 2 | 9 | 28853 | 34 | |||
| 16521 | 26389 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1615X Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007051.37729 | 2109286.78339 | 37.7720980355412 | -122.419001335981 | (37.7720980355412, -122.419001335981) | 8 | 2 | 9 | 28853 | 19 | |||
| 16534 | 27463 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 470X 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6011688.33242 | 2110736.1333 | 37.7763376380098 | -122.403063604325 | (37.7763376380098, -122.403063604325) | 14 | 2 | 9 | 28853 | 34 | |||
| 16582 | 19309 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 375 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6010658.6989499 | 2110585.1273498 | 37.7758654588782 | -122.406614766861 | (37.7758654588782, -122.406614766861) | 14 | 2 | 9 | 28853 | 34 | |||
| 16747 | 13745 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 831 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6010771.0950994 | 2113942.20162 | 37.7850894857101 | -122.406462564861 | (37.7850894857101, -122.406462564861) | 12 | 2 | 9 | 28853 | 34 | |||
| 16824 | 13677 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011836.71983 | 2114948.58904 | 37.7879123453203 | -122.402846621288 | (37.7879123453203, -122.402846621288) | 12 | 2 | 9 | 28855 | 6 | |
| 16903 | 261559 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 900 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011458 | 2112074 | 37.7799982447009 | -122.403954562266 | (37.7799982447009, -122.403954562266) | 14 | 2 | 9 | 28853 | 34 | ||||
| 16982 | 19368 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 352-360 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 54655 | 6011200.48284 | 2111246.22274 | 37.7777109702346 | -122.404787140633 | (37.7777109702346, -122.404787140633) | 14 | 2 | 9 | 28853 | 34 | |
| 16987 | 17305 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 51X Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006870.5020453 | 2109341.6908091 | 37.7722386113234 | -122.419630895813 | (37.7722386113234, -122.419630895813) | 8 | 2 | 9 | 28853 | 19 | |||
| 17002 | 264889 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
| 17114 | 29134 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 60 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/13/2015 12:00:00 AM | 3 | 3x3 | 6008669.2299 | 2112549.0897 | 37.7811465261229 | -122.413635814866 | (37.7811465261229, -122.413635814866) | 7 | 10 | 9 | 28852 | 36 | ||
| 17301 | 13943 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1101 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Permit Number 780155 | 6008953.3362 | 2112197.3558 | 37.7801966980589 | -122.412628072717 | (37.7801966980589, -122.412628072717) | 8 | 2 | 9 | 28853 | 34 | |||
| 17355 | 258161 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 335 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6009797.86626 | 2110165.76552 | 37.7746657903123 | -122.409563015883 | (37.7746657903123, -122.409563015883) | 8 | 2 | 9 | 28853 | 34 | |||
| 17383 | 258113 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 144 Freelon St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6013235.08289 | 2111410.77261 | 37.7782762981131 | -122.397760259133 | (37.7782762981131, -122.397760259133) | 6 | 2 | 9 | 28856 | 34 | |||||
| 17682 | 258962 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 17763 | 85665 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 655 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012806 | 2111523 | 37.7785605448609 | -122.399252504881 | (37.7785605448609, -122.399252504881) | 6 | 2 | 9 | 28856 | 34 | ||
| 17809 | 14069 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1390 Market St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007575.3554 | 2111000.5411 | 37.7768330981624 | -122.417310315452 | (37.7768330981624, -122.417310315452) | 7 | 2 | 9 | 28852 | 36 | |||
| 17830 | 261553 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 900 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011458 | 2112074 | 37.7799982447009 | -122.403954562266 | (37.7799982447009, -122.403954562266) | 14 | 2 | 9 | 28853 | 34 | ||||
| 17933 | 264904 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 17998 | 85553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 332 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6008375 | 2108695 | 37.7705475827471 | -122.414380922989 | (37.7705475827471, -122.414380922989) | 8 | 2 | 9 | 28853 | 19 | |||
| 17999 | 264779 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 18037 | 7422 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X 07TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/1991 12:00:00 AM | 8 | 6010388 | 2110913 | 37.7767505721368 | -122.407574310337 | (37.7767505721368, -122.407574310337) | 14 | 2 | 9 | 28853 | 34 | |||
| 18084 | 258157 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1180 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6009302.702 | 2110851.89805 | 37.7765219905974 | -122.411324376274 | (37.7765219905974, -122.411324376274) | 8 | 2 | 9 | 28853 | 34 | |||
| 18107 | 14035 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1255 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6008109.1756533 | 2111402.6049434 | 37.7779670885842 | -122.415492136821 | (37.7779670885842, -122.415492136821) | 8 | 2 | 9 | 28853 | 34 | |||
| 18389 | 264893 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
| 18544 | 258969 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 19057 | 251711 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 3 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
| 19625 | 261379 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 420 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008383 | 2113512 | 37.7837743694769 | -122.414694194891 | (37.7837743694769, -122.414694194891) | 7 | 10 | 9 | 28858 | 36 | ||||
| 19694 | 91181 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
| 19715 | 13634 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 575 Market St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6012469.4718261 | 2115563.4150291 | 37.7896358234539 | -122.400700610323 | (37.7896358234539, -122.400700610323) | 12 | 2 | 9 | 28855 | 6 | |||
| 19796 | 9959 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 199 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6006863.679918 | 2111512.223478 | 37.7781979892315 | -122.419808536864 | (37.7781979892315, -122.419808536864) | 7 | 9 | 9 | 28852 | 36 | |||
| 19800 | 13790 | DPW Maintained 1 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 | 925 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/1992 12:00:00 AM | 20 | 4X4 | 6010172.1312849 | 2113372.8551837 | 37.7834926696549 | -122.408494625591 | (37.7834926696549, -122.408494625591) | 14 | 2 | 9 | 28853 | 34 | ||
| 19974 | 28151 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
| 20050 | 13714 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 755X Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6011317.3735797 | 2114463.3908616 | 37.7865510936424 | -122.404609305043 | (37.7865510936424, -122.404609305043) | 12 | 2 | 9 | 28853 | 6 | |||
| 20076 | 13882 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 1027 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2016 08:40:00 AM | 3 | 4X4 | 6009489.4233125 | 2112722.2987067 | 37.7816681394186 | -122.410810578934 | (37.7816681394186, -122.410810578934) | 14 | 2 | 9 | 28853 | 34 | ||
| 20190 | 90411 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006552.3 | 2109010.7 | 37.771311860318 | -122.420708085152 | (37.771311860318, -122.420708085152) | 8 | 2 | 9 | 28853 | 19 | ||
| 20195 | 90386 | DPW Maintained 1 | Tree(s) :: 17 | 20 12th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2013 03:31:00 PM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
| 20274 | 28206 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | ||||
| 20306 | 121801 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1235 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6008572.2717 | 2110960.39862 | 37.7767789137416 | -122.413858829626 | (37.7767789137416, -122.413858829626) | 8 | 2 | 9 | 28853 | 34 | |||
| 20348 | 86615 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1090 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/03/2011 12:00:00 AM | 3 | 3x3 | 6010138.02723 | 2109041.45906 | 37.7715977602665 | -122.40830700887 | (37.7715977602665, -122.40830700887) | 14 | 2 | 9 | 28853 | 34 | ||
| 20351 | 13932 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008956.4875906 | 2112317.4497791 | 37.7805266244044 | -122.412625662667 | (37.7805266244044, -122.412625662667) | 7 | 2 | 9 | 28852 | 36 | |||
| 20418 | 29117 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 611 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2005 12:00:00 AM | 6 | 3x3 | 6007933.8996656 | 2113732.3857582 | 37.7843542527477 | -122.416263532231 | (37.7843542527477, -122.416263532231) | 7 | 10 | 9 | 28858 | 36 |
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) );