trees
27,746 rows where qCaretaker_id = 1 sorted by PlotSize 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1899 | 211289 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 100x Idora Ave | 8 | Median : Yard | Tree | DPW 1 | 5 | Width 9ft | 5995366.53481 | 2099407.60632 | 37.7443074262592 | -122.458704561274 | (37.7443074262592, -122.458704561274) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 14757 | 208879 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100x Idora Ave | 19 | Median : Yard | Tree | DPW 1 | 7 | Width 9ft | 5995727.40355 | 2099320.34097 | 37.7440885519582 | -122.457450449475 | (37.7440885519582, -122.457450449475) | 1 | 8 | 4 | 59 | 40 | |||
| 23810 | 214330 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100x Idora Ave | 12 | Median : Yard | Tree | DPW 1 | 10 | Width 9ft | 5995527.4625 | 2099368.48178 | 37.7442092481691 | -122.458145280077 | (37.7442092481691, -122.458145280077) | 1 | 8 | 4 | 59 | 40 | |||
| 26812 | 211161 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100x Idora Ave | 17 | Median : Yard | Tree | DPW 1 | 41 | Width 9ft | 5995684.47383 | 2099331.08009 | 37.7441155729727 | -122.457599666806 | (37.7441155729727, -122.457599666806) | 1 | 8 | 4 | 59 | 40 | |||
| 33140 | 208175 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000x Lawton St | 3 | Median : Yard | Tree | DPW 1 | 1 | Width 9ft | 5991060.8036 | 2104516.28775 | 37.7580861138029 | -122.473965364836 | (37.7580861138029, -122.473965364836) | 1 | 8 | 4 | 56 | 12 | |||
| 41745 | 211162 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100x Idora Ave | 21 | Median : Yard | Tree | DPW 1 | 2 | Width 9ft | 5995762.15632 | 2099312.39681 | 37.7440687353763 | -122.457329708294 | (37.7440687353763, -122.457329708294) | 1 | 8 | 4 | 59 | 40 | |||
| 46330 | 217728 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100x Lincoln Way | 3 | Median : Yard | Tree | DPW 1 | 10 | Width 9ft | 5995225.13962 | 2107407.04812 | 37.766263730121 | -122.459772791289 | (37.766263730121, -122.459772791289) | 15 | 5 | 11 | 29492 | 8 | |||
| 62477 | 205301 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100x Idora Ave | 16 | Median : Yard | Tree | DPW 1 | 6 | Width 9ft | 5995644.80929 | 2099340.4392 | 37.7441389922109 | -122.457737494208 | (37.7441389922109, -122.457737494208) | 1 | 8 | 4 | 59 | 40 | |||
| 63930 | 214329 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100x Idora Ave | 11 | Median : Yard | Tree | DPW 1 | 11 | Width 9ft | 5995487.46893 | 2099377.84768 | 37.7442326665051 | -122.458284246023 | (37.7442326665051, -122.458284246023) | 1 | 8 | 4 | 59 | 40 | |||
| 70794 | 242793 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2x Coso Ave | 1 | Median : Yard | Tree | DPW 1 | 30 | Width 9ft | 6007083.58829 | 2099965.0449 | 37.746504513177 | -122.418228897148 | (37.746504513177, -122.418228897148) | 2 | 7 | 7 | 28859 | 2 | |||
| 79535 | 206836 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100x Idora Ave | 14 | Median : Yard | Tree | DPW 1 | 66 | Width 9ft | 5995604.17085 | 2099350.47447 | 37.7441642119029 | -122.457878738128 | (37.7441642119029, -122.457878738128) | 1 | 8 | 4 | 59 | 40 | |||
| 94755 | 205300 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100x Idora Ave | 15 | Median : Yard | Tree | DPW 1 | 6 | Width 9ft | 5995637.60627 | 2099342.55805 | 37.7441443962476 | -122.457762553794 | (37.7441443962476, -122.457762553794) | 1 | 8 | 4 | 59 | 40 | |||
| 101385 | 210682 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100x Idora Ave | 6 | Median : Yard | Tree | DPW 1 | 15 | Width 9ft | 5995339.29404 | 2099412.44102 | 37.7443191354124 | -122.4587991034 | (37.7443191354124, -122.4587991034) | 1 | 8 | 4 | 59 | 40 | |||
| 104731 | 211163 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100x Idora Ave | 24 | Median : Yard | Tree | DPW 1 | 5 | Width 9ft | 5995808.0564 | 2099301.92354 | 37.7440426145693 | -122.45717023961 | (37.7440426145693, -122.45717023961) | 1 | 8 | 4 | 59 | 40 | |||
| 105224 | 211077 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 100x Idora Ave | 9 | Median : Yard | Tree | DPW 1 | 9 | Width 9ft | 5995433.61803 | 2099390.76131 | 37.7442650295015 | -122.458471384168 | (37.7442650295015, -122.458471384168) | 1 | 8 | 4 | 59 | 40 | |||
| 128972 | 214332 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100x Idora Ave | 18 | Median : Yard | Tree | DPW 1 | 9 | Width 9ft | 5995718.21124 | 2099321.84536 | 37.7440921546362 | -122.457482343055 | (37.7440921546362, -122.457482343055) | 1 | 8 | 4 | 59 | 40 | |||
| 130590 | 199366 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 300x Division St | 5 | Median : Yard | Tree | DPW 1 | 28 | Width 9ft | 6009946.07759 | 2108167.65587 | 37.7691877480427 | -122.408909315438 | (37.7691877480427, -122.408909315438) | 8 | 4 | 8 | 28853 | 19 | |||
| 131923 | 211477 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 100x Idora Ave | 10 | Median : Yard | Tree | DPW 1 | 37 | Width 9ft | 5995466.33774 | 2099382.46662 | 37.7442441346666 | -122.4583576469 | (37.7442441346666, -122.4583576469) | 1 | 8 | 4 | 59 | 40 | |||
| 132234 | 212576 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100x Idora Ave | 7 | Median : Yard | Tree | DPW 1 | 2 | Width 9ft | 5995353.74805 | 2099410.49817 | 37.7443146316188 | -122.458748984199 | (37.7443146316188, -122.458748984199) | 1 | 8 | 4 | 59 | 40 | |||
| 132799 | 214408 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100x Idora Ave | 20 | Median : Yard | Tree | DPW 1 | 3 | Width 9ft | 5995751.65358 | 2099314.25679 | 37.7440732391823 | -122.457366158726 | (37.7440732391823, -122.457366158726) | 1 | 8 | 4 | 59 | 40 | |||
| 138201 | 242373 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x McCoppin St | 1 | Median : Yard | Tree | DPW 1 | 5 | Width 9ft | 6006573.34583 | 2109150.3275 | 37.771696430266 | -122.420645200112 | (37.771696430266, -122.420645200112) | 8 | 2 | 9 | 28853 | 19 | |||
| 160825 | 124291 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4401x Cornwall St | 3 | Median : Yard | Tree | DPW 1 | 16 | Width 9ft | 5993813.76372 | 2114194.95027 | 37.7848202285685 | -122.465147505193 | (37.7848202285685, -122.465147505193) | 11 | 6 | 2 | 54 | 11 | |||
| 163843 | 242781 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 95x McCoppin St | 2 | Median : Yard | Tree | DPW 1 | 4 | Width 9ft | 6006152.38517 | 2109124.27435 | 37.771601160584 | -122.422099480311 | (37.771601160584, -122.422099480311) | 8 | 2 | 9 | 28853 | 19 | |||
| 168191 | 214331 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100x Idora Ave | 13 | Median : Yard | Tree | DPW 1 | 2 | Width 9ft | 5995540.56521 | 2099364.92702 | 37.7442002405496 | -122.458099716827 | (37.7442002405496, -122.458099716827) | 1 | 8 | 4 | 59 | 40 | |||
| 174179 | 188406 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1300x De Haro St | 6 | Median : Yard | Tree | DPW 1 | 6 | Width 9ft | 6012288.20028 | 2102185.92507 | 37.75289415586 | -122.400387777694 | (37.75289415586, -122.400387777694) | 10 | 3 | 8 | 28856 | 29 | |||
| 178645 | 242779 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x McCoppin St | 2 | Median : Yard | Tree | DPW 1 | 4 | Width 9ft | 6006556.42632 | 2109149.52189 | 37.7716932646698 | -122.420703668659 | (37.7716932646698, -122.420703668659) | 8 | 2 | 9 | 28853 | 19 | |||
| 189570 | 206837 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100x Idora Ave | 25 | Median : Yard | Tree | DPW 1 | 63 | Width 9ft | 5995840.17489 | 2099294.03492 | 37.7440227989188 | -122.457058611284 | (37.7440227989188, -122.457058611284) | 1 | 8 | 4 | 59 | 40 | |||
| 192472 | 187521 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 100x Mary Teresa St | 1 | Median : Yard | Tree | DPW 1 | 15 | Width 9ft | 6012597.41848 | 2087914.40308 | 37.7137247587658 | -122.398317184005 | (37.7137247587658, -122.398317184005) | 10 | 3 | 8 | 309 | 1 | |||
| 193653 | 124177 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 8X Almaden Ct | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10 | Width 9ft | 5995876 | 2112606 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | 11 | 6 | 2 | 54 | 16 | |||
| 3244 | 208266 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 4 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 5996189.57852 | 2098600.11131 | 37.7421375150253 | -122.455800307749 | (37.7421375150253, -122.455800307749) | 9 | 7 | 4 | 59 | 40 | |||
| 5167 | 126631 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 7 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6013670.6132 | 2118002.84349 | 37.796400840179 | -122.39671583859 | (37.796400840179, -122.39671583859) | 3 | 1 | 10 | 28860 | 6 | |||
| 5925 | 206820 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 335x Pacheco St | 2 | Median : Yard | Tree | DPW 1 | 28 | Width 8ft | 5994214.91647 | 2101031.13143 | 37.7486989587999 | -122.462804340247 | (37.7486989587999, -122.462804340247) | 1 | 8 | 4 | 29491 | 40 | |||
| 7212 | 195766 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 700x King St | 2 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6014104.38527 | 2110532.00713 | 37.7759117775522 | -122.394691443959 | (37.7759117775522, -122.394691443959) | 6 | 2 | 9 | 310 | 20 | |||
| 8267 | 119175 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 742 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 8ft | 5980756.90149 | 2110662.55033 | 37.7743597371632 | -122.510056642513 | (37.7743597371632, -122.510056642513) | 11 | 6 | 2 | 55 | 26 | |||
| 9224 | 132190 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1306x Montgomery St | 44 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6011409.46246 | 2120250.86119 | 37.802447243101 | -122.40469828132 | (37.802447243101, -122.40469828132) | 3 | 1 | 10 | 308 | 23 | |||
| 9676 | 194361 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 28 | Width 8ft | 6016114.70966 | 2114269.45463 | 37.7862855364823 | -122.38799801482 | (37.7862855364823, -122.38799801482) | 6 | 2 | 9 | 28856 | 6 | |||
| 9755 | 194362 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6016123.07303 | 2114362.83881 | 37.786542411639 | -122.387975598289 | (37.786542411639, -122.387975598289) | 6 | 2 | 9 | 28856 | 6 | |||
| 13545 | 129348 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1306x Montgomery St | 33 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6011427.80927 | 2120135.82348 | 37.802132403051 | -122.404626688974 | (37.802132403051, -122.404626688974) | 3 | 1 | 10 | 308 | 23 | |||
| 14228 | 211132 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 39 | Median : Yard | Tree | DPW 1 | 13 | Width 8ft | 5994073.5471 | 2101557.93366 | 37.750137280527 | -122.463331413139 | (37.750137280527, -122.463331413139) | 1 | 8 | 4 | 29491 | 40 | |||
| 15721 | 126288 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500x Van Ness Ave | 7 | Median : Yard | Tree | DPW 1 | 27 | Width 8ft | 6005772.33142 | 2119211.18315 | 37.7992758747311 | -122.424131583019 | (37.7992758747311, -122.424131583019) | 13 | 9 | 1 | 28858 | 32 | |||
| 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 | |||
| 17041 | 197764 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 9 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6015565.1078 | 2103547.12613 | 37.7568139175333 | -122.389150557161 | (37.7568139175333, -122.389150557161) | 10 | 3 | 8 | 28856 | 29 | |||
| 17076 | 126371 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1306x Montgomery St | 37 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6011427.3089 | 2120158.66 | 37.8021950785935 | -122.404630029046 | (37.8021950785935, -122.404630029046) | 3 | 1 | 10 | 308 | 23 | |||
| 17115 | 129350 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1306x Montgomery St | 38 | Median : Yard | Tree | DPW 1 | 1 | Width 8ft | 6011425.50986 | 2120159.17711 | 37.8021963979046 | -122.404636291051 | (37.8021963979046, -122.404636291051) | 3 | 1 | 10 | 308 | 23 | |||
| 18954 | 126425 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1306x Montgomery St | 27 | Median : Yard | Tree | DPW 1 | 13 | Width 8ft | 6011438.82177 | 2120037.47116 | 37.8018629670555 | -122.404581652737 | (37.8018629670555, -122.404581652737) | 3 | 1 | 10 | 308 | 23 | |||
| 20406 | 188744 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 12 | Median : Yard | Tree | DPW 1 | 20 | Width 8ft | 6014566.93251 | 2086961.44697 | 37.7112176404424 | -122.391443188965 | (37.7112176404424, -122.391443188965) | 10 | 3 | 8 | 58 | 1 | |||
| 23475 | 211127 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335X Pacheco St | 33 | Median : Yard | Tree | DPW 1 | 24 | Width 8ft | 5994124.86854 | 2101482.06932 | 37.7499319329208 | -122.463148437947 | (37.7499319329208, -122.463148437947) | 1 | 8 | 4 | 29491 | 40 | |||
| 23782 | 194377 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 14 | Median : Yard | Tree | DPW 1 | 28 | Width 8ft | 6016027.16358 | 2115370.7776 | 37.7893046685309 | -122.388377800289 | (37.7893046685309, -122.388377800289) | 6 | 2 | 9 | 28855 | 6 | |||
| 25236 | 211122 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 27 | Median : Yard | Tree | DPW 1 | 26 | Width 8ft | 5994167.1459 | 2101393.52573 | 37.749691250071 | -122.462995818511 | (37.749691250071, -122.462995818511) | 1 | 8 | 4 | 29491 | 40 | |||
| 25284 | 194337 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 88x King St | 13 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6015953.29851 | 2112409.57048 | 37.7811697700143 | -122.388426597522 | (37.7811697700143, -122.388426597522) | 6 | 2 | 9 | 28856 | 20 | |||
| 26964 | 206829 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 335x Pacheco St | 21 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 5994178.99702 | 2101301.67665 | 37.749439738457 | -122.462948174236 | (37.749439738457, -122.462948174236) | 1 | 8 | 4 | 29491 | 40 | |||
| 28718 | 194364 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6016200.86003 | 2114659.13107 | 37.7873602722118 | -122.387727152497 | (37.7873602722118, -122.387727152497) | 6 | 2 | 9 | 28855 | 6 | |||
| 28824 | 188743 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 11 | Median : Yard | Tree | DPW 1 | 22 | Width 8ft | 6014538.0462 | 2086963.8159 | 37.711222541749 | -122.391543193559 | (37.711222541749, -122.391543193559) | 10 | 3 | 8 | 58 | 1 | |||
| 29177 | 187712 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 51x Executive Park Blvd | 3 | Median : Yard | Tree | DPW 1 | 10 | Width 8ft | 6013733.01886 | 2087017.85621 | 37.7113262093072 | -122.394329370613 | (37.7113262093072, -122.394329370613) | 10 | 3 | 8 | 58 | 1 | |||
| 29515 | 217725 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150x Lincoln Way | 2 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 5995229.43414 | 2107380.16691 | 37.766190168267 | -122.459755990171 | (37.766190168267, -122.459755990171) | 15 | 5 | 11 | 29492 | 8 | |||
| 31259 | 187699 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Executive Park Blvd | 8 | Median : Yard | Tree | DPW 1 | 24 | Width 8ft | 6014113.89856 | 2087000.13929 | 37.7112987269205 | -122.393011704639 | (37.7112987269205, -122.393011704639) | 10 | 3 | 8 | 58 | 1 | |||
| 31774 | 195775 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 700x King St | 12 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6013821.82406 | 2110259.84157 | 37.7751487585315 | -122.395649829891 | (37.7751487585315, -122.395649829891) | 6 | 2 | 9 | 28856 | 20 | |||
| 32182 | 195777 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 700x King St | 18 | Median : Yard | Tree | DPW 1 | 13 | Width 8ft | 6013688.74919 | 2110125.02195 | 37.7747711709757 | -122.396100718491 | (37.7747711709757, -122.396100718491) | 6 | 2 | 9 | 28856 | 20 | |||
| 33234 | 208271 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 9 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 5996099.48169 | 2098476.66946 | 37.7417934029459 | -122.456102909823 | (37.7417934029459, -122.456102909823) | 9 | 7 | 4 | 59 | 40 | |||
| 34393 | 211111 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 5 | Median : Yard | Tree | DPW 1 | 21 | Width 8ft | 5994189.10111 | 2101103.38332 | 37.7488958572711 | -122.462898850009 | (37.7488958572711, -122.462898850009) | 1 | 8 | 4 | 29491 | 40 | |||
| 34420 | 211112 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 6 | Median : Yard | Tree | DPW 1 | 44 | Width 8ft | 5994184.95875 | 2101126.78073 | 37.7489598620291 | -122.462914871445 | (37.7489598620291, -122.462914871445) | 1 | 8 | 4 | 29491 | 40 | |||
| 35381 | 231477 | DPW Maintained 1 | Malus :: Crab Apple 82 | 600x San Jose Ave | 1 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6005974.01132 | 2099648.68915 | 37.7455733533412 | -122.422043227715 | (37.7455733533412, -122.422043227715) | 2 | 7 | 5 | 28859 | 2 | |||
| 35397 | 194379 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6015888.45756 | 2115624.95631 | 37.7899948982019 | -122.388875463533 | (37.7899948982019, -122.388875463533) | 6 | 2 | 9 | 28855 | 6 | |||
| 35809 | 133192 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1306x Montgomery St | 41 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6011420.83782 | 2120184.50099 | 37.8022656699768 | -122.404654242423 | (37.8022656699768, -122.404654242423) | 3 | 1 | 10 | 308 | 23 | |||
| 36152 | 119936 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 6500x Geary Blvd | 7 | Median : Yard | Tree | DPW 1 | 1 | Width 8ft | 5986709.57611 | 2112539.19718 | 37.7798617820891 | -122.489603541423 | (37.7798617820891, -122.489603541423) | 11 | 6 | 2 | 55 | 26 | |||
| 36180 | 206831 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 335x Pacheco St | 38 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 5994089.87141 | 2101545.69318 | 37.7501046117408 | -122.463274075037 | (37.7501046117408, -122.463274075037) | 1 | 8 | 4 | 29491 | 40 | |||
| 36252 | 197767 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 14 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6015569.44669 | 2103464.91746 | 37.756588430534 | -122.38912981161 | (37.756588430534, -122.38912981161) | 10 | 3 | 8 | 28856 | 29 | |||
| 36330 | 211129 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 35 | Median : Yard | Tree | DPW 1 | 25 | Width 8ft | 5994111.36343 | 2101512.46211 | 37.7500146058056 | -122.463197343983 | (37.7500146058056, -122.463197343983) | 1 | 8 | 4 | 29491 | 40 | |||
| 36559 | 195772 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 700x King St | 9 | Median : Yard | Tree | DPW 1 | 10 | Width 8ft | 6013930.44742 | 2110363.99396 | 37.7754407791936 | -122.395281372244 | (37.7754407791936, -122.395281372244) | 6 | 2 | 9 | 28856 | 20 | |||
| 37457 | 194335 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 88x King St | 11 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6015932.5598 | 2112347.87113 | 37.7809992081901 | -122.38849403589 | (37.7809992081901, -122.38849403589) | 6 | 2 | 9 | 28856 | 20 | |||
| 39154 | 206826 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 335x Pacheco St | 15 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 5994179.97807 | 2101226.44078 | 37.7492332163602 | -122.462939324011 | (37.7492332163602, -122.462939324011) | 1 | 8 | 4 | 29491 | 40 | |||
| 39582 | 211113 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 7 | Median : Yard | Tree | DPW 1 | 20 | Width 8ft | 5994180.04977 | 2101148.49465 | 37.7490192001903 | -122.462933421744 | (37.7490192001903, -122.462933421744) | 1 | 8 | 4 | 29491 | 40 | |||
| 39631 | 195770 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 700x King St | 6 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6014000.92339 | 2110427.46457 | 37.7756189744596 | -122.395042023971 | (37.7756189744596, -122.395042023971) | 6 | 2 | 9 | 28856 | 20 | |||
| 39756 | 194385 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 26 | Width 8ft | 6015616.39603 | 2115848.18198 | 37.7905927414207 | -122.389832379957 | (37.7905927414207, -122.389832379957) | 6 | 2 | 9 | 28855 | 6 | |||
| 40416 | 206821 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 335x Pacheco St | 9 | Median : Yard | Tree | DPW 1 | 3 | Width 8ft | 5994174.99878 | 2101175.06788 | 37.7490918726007 | -122.462952815645 | (37.7490918726007, -122.462952815645) | 1 | 8 | 4 | 29491 | 40 | |||
| 40502 | 195774 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 700x King St | 11 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6013840.56716 | 2110278.04491 | 37.7751997833822 | -122.395586268497 | (37.7751997833822, -122.395586268497) | 6 | 2 | 9 | 28856 | 20 | |||
| 40530 | 206828 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 335x Pacheco St | 19 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 5994181.13078 | 2101275.53768 | 37.7493680903851 | -122.462938899523 | (37.7493680903851, -122.462938899523) | 1 | 8 | 4 | 29491 | 40 | |||
| 41118 | 119176 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 742 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 8ft | 5980756.08521 | 2110656.0073 | 37.7743417237871 | -122.510058979927 | (37.7743417237871, -122.510058979927) | 11 | 6 | 2 | 55 | 26 | |||
| 43824 | 246542 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 8 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 6005675.49099 | 2109463.50167 | 37.772505687922 | -122.42377321126 | (37.772505687922, -122.42377321126) | 7 | 9 | 11 | 28852 | 10 | |||
| 45641 | 126424 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1306x Montgomery St | 26 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6011439.45604 | 2120033.94187 | 37.8018533119341 | -122.404579209268 | (37.8018533119341, -122.404579209268) | 3 | 1 | 10 | 308 | 23 | |||
| 46684 | 125865 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 47 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6011401.82838 | 2120281.49833 | 37.8025309385205 | -122.404726857271 | (37.8025309385205, -122.404726857271) | 3 | 1 | 10 | 308 | 23 | |||
| 47375 | 132184 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1306x Montgomery St | 25 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6011444.3716 | 2120015.20461 | 37.8018021387065 | -122.404560879294 | (37.8018021387065, -122.404560879294) | 3 | 1 | 10 | 308 | 23 | |||
| 48140 | 194380 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6015792.97899 | 2115653.31942 | 37.7900674842722 | -122.389207795421 | (37.7900674842722, -122.389207795421) | 6 | 2 | 9 | 28855 | 6 | |||
| 50705 | 246545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 12 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6005664.26886 | 2109539.08097 | 37.7727125769595 | -122.423817404855 | (37.7727125769595, -122.423817404855) | 7 | 9 | 11 | 28852 | 10 | |||
| 50815 | 194375 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 12 | Median : Yard | Tree | DPW 1 | 27 | Width 8ft | 6016059.60857 | 2115304.27364 | 37.7891238616108 | -122.388260900137 | (37.7891238616108, -122.388260900137) | 6 | 2 | 9 | 28855 | 6 | |||
| 50904 | 194330 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 88x King St | 6 | Median : Yard | Tree | DPW 1 | 32 | Width 8ft | 6015863.58652 | 2112149.96757 | 37.7804519868963 | -122.38871883132 | (37.7804519868963, -122.38871883132) | 6 | 2 | 9 | 28856 | 20 | |||
| 52277 | 126370 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1306x Montgomery St | 31 | Median : Yard | Tree | DPW 1 | 10 | Width 8ft | 6011433.37611 | 2120083.33032 | 37.801988580771 | -122.404603727506 | (37.801988580771, -122.404603727506) | 3 | 1 | 10 | 308 | 23 | |||
| 52511 | 211120 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 25 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 5994172.88283 | 2101376.40838 | 37.7496445806313 | -122.462974738387 | (37.7496445806313, -122.462974738387) | 1 | 8 | 4 | 29491 | 40 | |||
| 52850 | 197768 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 15 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 6015570.7208 | 2103442.3208 | 37.7565264555391 | -122.389123827518 | (37.7565264555391, -122.389123827518) | 10 | 3 | 8 | 28856 | 29 | |||
| 56148 | 246538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 4 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005690.17012 | 2109380.36656 | 37.7722782475712 | -122.423716522495 | (37.7722782475712, -122.423716522495) | 7 | 9 | 11 | 28852 | 10 | |||
| 57209 | 194341 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 418x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 25 | Width 8ft | 6016036.61123 | 2112738.53497 | 37.7820776491035 | -122.388161338867 | (37.7820776491035, -122.388161338867) | 6 | 2 | 9 | 28856 | 6 | |||
| 57410 | 195768 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 700x King St | 4 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6014054.21826 | 2110478.98946 | 37.775763413678 | -122.394861271956 | (37.775763413678, -122.394861271956) | 6 | 2 | 9 | 28856 | 20 | |||
| 57949 | 126628 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 3 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6013814.15262 | 2118039.92484 | 37.7965106447043 | -122.396221758237 | (37.7965106447043, -122.396221758237) | 3 | 1 | 10 | 28860 | 6 | |||
| 58811 | 194359 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 33 | Width 8ft | 6016151.3585 | 2114078.17293 | 37.7857623505017 | -122.387857866272 | (37.7857623505017, -122.387857866272) | 6 | 2 | 9 | 28856 | 6 | |||
| 59962 | 211118 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 23 | Median : Yard | Tree | DPW 1 | 32 | Width 8ft | 5994177.42572 | 2101348.87467 | 37.7495692417302 | -122.462957031657 | (37.7495692417302, -122.462957031657) | 1 | 8 | 4 | 29491 | 40 | |||
| 60705 | 211115 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 10 | Median : Yard | Tree | DPW 1 | 48 | Width 8ft | 5994174.89833 | 2101193.52417 | 37.749142543105 | -122.462954501858 | (37.749142543105, -122.462954501858) | 1 | 8 | 4 | 29491 | 40 | |||
| 60709 | 199365 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 300x Division St | 4 | Median : Yard | Tree | DPW 1 | 36 | Width 8ft | 6009969.14716 | 2108168.58479 | 37.7691915908542 | -122.408829584245 | (37.7691915908542, -122.408829584245) | 8 | 4 | 8 | 28853 | 19 | |||
| 61019 | 132188 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1306x Montgomery St | 42 | Median : Yard | Tree | DPW 1 | 17 | Width 8ft | 6011420.08981 | 2120201.09522 | 37.8023111918729 | -122.404657999787 | (37.8023111918729, -122.404657999787) | 3 | 1 | 10 | 308 | 23 | |||
| 61365 | 211136 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 45 | Median : Yard | Tree | DPW 1 | 40 | Width 8ft | 5993981.68965 | 2101619.35066 | 37.7503006234743 | -122.463653516122 | (37.7503006234743, -122.463653516122) | 1 | 8 | 4 | 29491 | 40 |
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) );