Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
869 | 869 | 124177 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 8X Almaden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10 | Width 9ft | 5995876.0 | 2112606.0 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | |||
25864 | 25864 | 211289 | DPW Maintained 3 | Pinus thunbergii :: Japanese Black Pine 306 | 100x Idora Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 5995366.53481 | 2099407.6063200003 | 37.744307426259205 | -122.45870456127399 | (37.7443074262592, -122.458704561274) | |||
26492 | 26492 | 242374 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 6006546.0037 | 2109148.1970900004 | 37.771689039651896 | -122.42073962714899 | (37.7716890396519, -122.420739627149) | |||
27503 | 27503 | 208879 | DPW Maintained 3 | Malus :: Crab Apple 235 | 100x Idora Ave | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 9ft | 5995727.40355 | 2099320.3409700003 | 37.74408855195821 | -122.457450449475 | (37.7440885519582, -122.457450449475) | |||
28868 | 28868 | 208175 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Lawton St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 9ft | 5991060.8036 | 2104516.28775 | 37.758086113802904 | -122.473965364836 | (37.7580861138029, -122.473965364836) | |||
37375 | 37375 | 211161 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Idora Ave | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 41 | Width 9ft | 5995684.4738300005 | 2099331.0800900003 | 37.7441155729727 | -122.45759966680599 | (37.7441155729727, -122.457599666806) | |||
38489 | 38489 | 214330 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 100x Idora Ave | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 9ft | 5995527.4625 | 2099368.48178 | 37.7442092481691 | -122.458145280077 | (37.7442092481691, -122.458145280077) | |||
44924 | 44924 | 217728 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100x Lincoln Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 9ft | 5995225.13962 | 2107407.04812 | 37.766263730121004 | -122.45977279128901 | (37.766263730121, -122.459772791289) | |||
50547 | 50547 | 211162 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Idora Ave | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995762.15632 | 2099312.39681 | 37.744068735376295 | -122.457329708294 | (37.7440687353763, -122.457329708294) | |||
51364 | 51364 | 214329 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 100x Idora Ave | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 9ft | 5995487.46893 | 2099377.84768 | 37.744232666505106 | -122.45828424602301 | (37.7442326665051, -122.458284246023) | |||
57260 | 57260 | 242793 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2x Coso Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 9ft | 6007083.58829 | 2099965.0449 | 37.746504513177 | -122.418228897148 | (37.746504513177, -122.418228897148) | |||
60126 | 60126 | 205301 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100x Idora Ave | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 9ft | 5995644.80929 | 2099340.4392 | 37.7441389922109 | -122.45773749420799 | (37.7441389922109, -122.457737494208) | |||
65522 | 65522 | 205300 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100x Idora Ave | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 9ft | 5995637.606269999 | 2099342.55805 | 37.7441443962476 | -122.457762553794 | (37.7441443962476, -122.457762553794) | |||
67961 | 67961 | 206836 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100x Idora Ave | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 66 | Width 9ft | 5995604.17085 | 2099350.4744700002 | 37.7441642119029 | -122.45787873812799 | (37.7441642119029, -122.457878738128) | |||
73631 | 73631 | 211163 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Idora Ave | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 5995808.0564 | 2099301.9235400003 | 37.744042614569295 | -122.45717023961001 | (37.7440426145693, -122.45717023961) | |||
115432 | 115432 | 210682 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100x Idora Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 9ft | 5995339.29404 | 2099412.4410200003 | 37.7443191354124 | -122.4587991034 | (37.7443191354124, -122.4587991034) | |||
134715 | 134715 | 211077 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 100x Idora Ave | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 9ft | 5995433.6180300005 | 2099390.76131 | 37.7442650295015 | -122.45847138416799 | (37.7442650295015, -122.458471384168) | |||
136941 | 136941 | 211477 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 100x Idora Ave | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | Width 9ft | 5995466.33774 | 2099382.46662 | 37.7442441346666 | -122.45835764690001 | (37.7442441346666, -122.4583576469) | |||
137327 | 137327 | 214332 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 100x Idora Ave | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 9ft | 5995718.21124 | 2099321.8453599997 | 37.7440921546362 | -122.457482343055 | (37.7440921546362, -122.457482343055) | |||
146356 | 146356 | 199366 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300x Division St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 9ft | 6009946.07759 | 2108167.65587 | 37.769187748042704 | -122.40890931543801 | (37.7691877480427, -122.408909315438) | |||
146780 | 146780 | 214408 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Idora Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 9ft | 5995751.653580001 | 2099314.25679 | 37.7440732391823 | -122.457366158726 | (37.7440732391823, -122.457366158726) | |||
148511 | 148511 | 212576 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100x Idora Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995353.74805 | 2099410.49817 | 37.74431463161879 | -122.458748984199 | (37.7443146316188, -122.458748984199) | |||
160927 | 160927 | 242373 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 6006573.34583 | 2109150.3275 | 37.771696430266 | -122.420645200112 | (37.771696430266, -122.420645200112) | |||
166774 | 166774 | 242781 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 95x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 9ft | 6006152.38517 | 2109124.27435 | 37.771601160584 | -122.42209948031099 | (37.771601160584, -122.422099480311) | |||
167931 | 167931 | 124291 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4401x Cornwall St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 9ft | 5993813.763719999 | 2114194.95027 | 37.7848202285685 | -122.465147505193 | (37.7848202285685, -122.465147505193) | |||
174532 | 174532 | 214331 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 100x Idora Ave | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995540.56521 | 2099364.9270200003 | 37.7442002405496 | -122.458099716827 | (37.7442002405496, -122.458099716827) | |||
185473 | 185473 | 242779 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 9ft | 6006556.42632 | 2109149.52189 | 37.77169326466979 | -122.420703668659 | (37.7716932646698, -122.420703668659) | |||
185898 | 185898 | 188406 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1300x De Haro St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 9ft | 6012288.20028 | 2102185.92507 | 37.75289415586 | -122.400387777694 | (37.75289415586, -122.400387777694) | |||
187642 | 187642 | 206837 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100x Idora Ave | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 63 | Width 9ft | 5995840.17489 | 2099294.03492 | 37.7440227989188 | -122.45705861128401 | (37.7440227989188, -122.457058611284) | |||
187703 | 187703 | 187521 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 100x Mary Teresa St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 9ft | 6012597.41848 | 2087914.4030799998 | 37.7137247587658 | -122.398317184005 | (37.7137247587658, -122.398317184005) | |||
455 | 455 | 234501 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2423 Market St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 12 | Width 8ft | 6002117.5892 | 2105782.84009 | 37.7621980066439 | -122.435816935712 | (37.7621980066439, -122.435816935712) | |||
868 | 868 | 219533 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3794 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 5 | Width 8ft | 5990481.81422 | 2090701.1507700002 | 37.7201197416248 | -122.474959308131 | (37.7201197416248, -122.474959308131) | |||
24519 | 24519 | 206820 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 5994214.91647 | 2101031.13143 | 37.7486989587999 | -122.462804340247 | (37.7486989587999, -122.462804340247) | |||
25072 | 25072 | 126288 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500x Van Ness Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 8ft | 6005772.33142 | 2119211.18315 | 37.7992758747311 | -122.424131583019 | (37.7992758747311, -122.424131583019) | |||
25236 | 25236 | 194362 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6016123.073030001 | 2114362.8388099996 | 37.786542411639 | -122.38797559828899 | (37.786542411639, -122.387975598289) | |||
25391 | 25391 | 132190 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1306x Montgomery St | 44 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6011409.46246 | 2120250.86119 | 37.802447243101 | -122.40469828132 | (37.802447243101, -122.40469828132) | |||
25644 | 25644 | 126371 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 1306x Montgomery St | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6011427.3089 | 2120158.66 | 37.8021950785935 | -122.404630029046 | (37.8021950785935, -122.404630029046) | |||
25946 | 25946 | 126425 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1306x Montgomery St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 6011438.821769999 | 2120037.4711599997 | 37.8018629670555 | -122.40458165273701 | (37.8018629670555, -122.404581652737) | |||
25996 | 25996 | 194361 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6016114.70966 | 2114269.45463 | 37.786285536482296 | -122.38799801482 | (37.7862855364823, -122.38799801482) | |||
26925 | 26925 | 208266 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5996189.57852 | 2098600.11131 | 37.7421375150253 | -122.455800307749 | (37.7421375150253, -122.455800307749) | |||
26942 | 26942 | 129350 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011425.50986 | 2120159.17711 | 37.8021963979046 | -122.404636291051 | (37.8021963979046, -122.404636291051) | |||
27329 | 27329 | 194334 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015942.04821 | 2112270.67914 | 37.7807877820727 | -122.388455820993 | (37.7807877820727, -122.388455820993) | |||
27490 | 27490 | 129348 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011427.80927 | 2120135.82348 | 37.802132403051 | -122.404626688974 | (37.802132403051, -122.404626688974) | |||
27523 | 27523 | 197764 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6015565.1078 | 2103547.1261299998 | 37.7568139175333 | -122.389150557161 | (37.7568139175333, -122.389150557161) | |||
27830 | 27830 | 195766 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6014104.3852699995 | 2110532.00713 | 37.7759117775522 | -122.394691443959 | (37.7759117775522, -122.394691443959) | |||
28285 | 28285 | 206831 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5994089.87141 | 2101545.69318 | 37.7501046117408 | -122.463274075037 | (37.7501046117408, -122.463274075037) | |||
28399 | 28399 | 211132 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 5994073.5471 | 2101557.9336599996 | 37.750137280527 | -122.463331413139 | (37.750137280527, -122.463331413139) | |||
29064 | 29064 | 194335 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015932.5598 | 2112347.87113 | 37.7809992081901 | -122.38849403588999 | (37.7809992081901, -122.38849403589) | |||
29492 | 29492 | 194379 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015888.45756 | 2115624.95631 | 37.7899948982019 | -122.388875463533 | (37.7899948982019, -122.388875463533) | |||
29552 | 29552 | 211129 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 8ft | 5994111.36343 | 2101512.4621099997 | 37.7500146058056 | -122.463197343983 | (37.7500146058056, -122.463197343983) | |||
29638 | 29638 | 197767 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6015569.446690001 | 2103464.9174599997 | 37.756588430534 | -122.38912981161002 | (37.756588430534, -122.38912981161) | |||
29681 | 29681 | 211122 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 8ft | 5994167.1459 | 2101393.52573 | 37.749691250071 | -122.462995818511 | (37.749691250071, -122.462995818511) | |||
29957 | 29957 | 187712 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 51x Executive Park Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 8ft | 6013733.01886 | 2087017.8562099999 | 37.7113262093072 | -122.39432937061301 | (37.7113262093072, -122.394329370613) | |||
30017 | 30017 | 187699 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 8ft | 6014113.89856 | 2087000.13929 | 37.7112987269205 | -122.393011704639 | (37.7112987269205, -122.393011704639) | |||
30288 | 30288 | 195777 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 6013688.74919 | 2110125.02195 | 37.774771170975704 | -122.396100718491 | (37.7747711709757, -122.396100718491) | |||
32164 | 32164 | 188743 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 8ft | 6014538.0462 | 2086963.8159 | 37.711222541749 | -122.391543193559 | (37.711222541749, -122.391543193559) | |||
33038 | 33038 | 217725 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 150x Lincoln Way | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 5995229.4341400005 | 2107380.1669099997 | 37.766190168267 | -122.45975599017099 | (37.766190168267, -122.459755990171) | |||
33192 | 33192 | 194377 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6016027.16358 | 2115370.7776 | 37.789304668530896 | -122.388377800289 | (37.7893046685309, -122.388377800289) | |||
34409 | 34409 | 211112 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 44 | Width 8ft | 5994184.95875 | 2101126.7807299998 | 37.748959862029096 | -122.46291487144501 | (37.7489598620291, -122.462914871445) | |||
35206 | 35206 | 195775 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6013821.82406 | 2110259.84157 | 37.7751487585315 | -122.395649829891 | (37.7751487585315, -122.395649829891) | |||
35368 | 35368 | 194364 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6016200.86003 | 2114659.13107 | 37.78736027221179 | -122.387727152497 | (37.7873602722118, -122.387727152497) | |||
35716 | 35716 | 194337 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6015953.29851 | 2112409.5704799998 | 37.781169770014294 | -122.38842659752198 | (37.7811697700143, -122.388426597522) | |||
36397 | 36397 | 195772 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 8ft | 6013930.44742 | 2110363.9939599996 | 37.7754407791936 | -122.395281372244 | (37.7754407791936, -122.395281372244) | |||
36478 | 36478 | 133192 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1306x Montgomery St | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011420.83782 | 2120184.50099 | 37.8022656699768 | -122.404654242423 | (37.8022656699768, -122.404654242423) | |||
37068 | 37068 | 208271 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 5996099.48169 | 2098476.66946 | 37.7417934029459 | -122.456102909823 | (37.7417934029459, -122.456102909823) | |||
37384 | 37384 | 211111 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 8ft | 5994189.10111 | 2101103.38332 | 37.7488958572711 | -122.462898850009 | (37.7488958572711, -122.462898850009) | |||
37578 | 37578 | 206829 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 5994178.99702 | 2101301.67665 | 37.749439738457 | -122.46294817423599 | (37.749439738457, -122.462948174236) | |||
37820 | 37820 | 188744 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 6014566.93251 | 2086961.4469700002 | 37.7112176404424 | -122.391443188965 | (37.7112176404424, -122.391443188965) | |||
38094 | 38094 | 231477 | DPW Maintained 3 | Malus :: Crab Apple 235 | 600x San Jose Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6005974.01132 | 2099648.68915 | 37.7455733533412 | -122.422043227715 | (37.7455733533412, -122.422043227715) | |||
39141 | 39141 | 119936 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6500x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 5986709.57611 | 2112539.19718 | 37.7798617820891 | -122.489603541423 | (37.7798617820891, -122.489603541423) | |||
39298 | 39298 | 126628 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013814.15262 | 2118039.92484 | 37.7965106447043 | -122.396221758237 | (37.7965106447043, -122.396221758237) | |||
39759 | 39759 | 126424 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1306x Montgomery St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6011439.456040001 | 2120033.94187 | 37.801853311934096 | -122.404579209268 | (37.8018533119341, -122.404579209268) | |||
39986 | 39986 | 211113 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 5994180.049769999 | 2101148.49465 | 37.7490192001903 | -122.462933421744 | (37.7490192001903, -122.462933421744) | |||
40192 | 40192 | 246545 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6005664.26886 | 2109539.08097 | 37.7727125769595 | -122.423817404855 | (37.7727125769595, -122.423817404855) | |||
41103 | 41103 | 195768 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6014054.2182599995 | 2110478.98946 | 37.775763413678 | -122.394861271956 | (37.775763413678, -122.394861271956) | |||
42530 | 42530 | 194380 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015792.97899 | 2115653.31942 | 37.79006748427221 | -122.38920779542102 | (37.7900674842722, -122.389207795421) | |||
42729 | 42729 | 194375 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 8ft | 6016059.60857 | 2115304.2736400003 | 37.7891238616108 | -122.388260900137 | (37.7891238616108, -122.388260900137) | |||
43461 | 43461 | 194341 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 418x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 8ft | 6016036.61123 | 2112738.53497 | 37.7820776491035 | -122.388161338867 | (37.7820776491035, -122.388161338867) | |||
43669 | 43669 | 246542 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 6005675.49099 | 2109463.50167 | 37.772505687922 | -122.42377321126001 | (37.772505687922, -122.42377321126) | |||
45853 | 45853 | 206826 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 5994179.978069999 | 2101226.44078 | 37.7492332163602 | -122.462939324011 | (37.7492332163602, -122.462939324011) | |||
46468 | 46468 | 194330 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | Width 8ft | 6015863.586519999 | 2112149.96757 | 37.780451986896296 | -122.38871883132 | (37.7804519868963, -122.38871883132) | |||
47222 | 47222 | 206821 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 5994174.99878 | 2101175.06788 | 37.7490918726007 | -122.46295281564501 | (37.7490918726007, -122.462952815645) | |||
47369 | 47369 | 126370 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 1306x Montgomery St | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 8ft | 6011433.37611 | 2120083.33032 | 37.801988580770995 | -122.40460372750601 | (37.801988580771, -122.404603727506) | |||
47847 | 47847 | 125865 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1306x Montgomery St | 47 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6011401.82838 | 2120281.49833 | 37.8025309385205 | -122.404726857271 | (37.8025309385205, -122.404726857271) | |||
48046 | 48046 | 194385 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 8ft | 6015616.39603 | 2115848.18198 | 37.7905927414207 | -122.38983237995701 | (37.7905927414207, -122.389832379957) | |||
48107 | 48107 | 132184 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1306x Montgomery St | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6011444.3716 | 2120015.20461 | 37.8018021387065 | -122.404560879294 | (37.8018021387065, -122.404560879294) | |||
48494 | 48494 | 195774 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6013840.56716 | 2110278.0449099997 | 37.7751997833822 | -122.39558626849701 | (37.7751997833822, -122.395586268497) | |||
48962 | 48962 | 195770 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6014000.92339 | 2110427.4645700003 | 37.7756189744596 | -122.395042023971 | (37.7756189744596, -122.395042023971) | |||
49204 | 49204 | 211120 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 5994172.8828300005 | 2101376.40838 | 37.7496445806313 | -122.46297473838699 | (37.7496445806313, -122.462974738387) | |||
49253 | 49253 | 197768 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6015570.7208 | 2103442.3208 | 37.7565264555391 | -122.389123827518 | (37.7565264555391, -122.389123827518) | |||
50390 | 50390 | 246538 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005690.17012 | 2109380.36656 | 37.7722782475712 | -122.423716522495 | (37.7722782475712, -122.423716522495) | |||
50688 | 50688 | 206828 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5994181.13078 | 2101275.53768 | 37.749368090385104 | -122.462938899523 | (37.7493680903851, -122.462938899523) | |||
51701 | 51701 | 208264 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 5996224.40551 | 2098673.0355 | 37.742339745598706 | -122.45568515764299 | (37.7423397455987, -122.455685157643) | |||
51725 | 51725 | 194333 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | Width 8ft | 6015903.377169999 | 2112286.3418900003 | 37.78082864545979 | -122.38859069771999 | (37.7808286454598, -122.38859069772) | |||
52412 | 52412 | 211125 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5994142.00989 | 2101462.2847 | 37.7498785968185 | -122.463087727432 | (37.7498785968185, -122.463087727432) | |||
53093 | 53093 | 194359 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | Width 8ft | 6016151.3585 | 2114078.17293 | 37.785762350501706 | -122.38785786627199 | (37.7857623505017, -122.387857866272) | |||
55101 | 55101 | 194331 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015869.7392 | 2112229.4323400003 | 37.7806705203569 | -122.388703094985 | (37.7806705203569, -122.388703094985) | |||
55150 | 55150 | 208267 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5996171.153059999 | 2098570.8040400003 | 37.742055987003496 | -122.455861898701 | (37.7420559870035, -122.455861898701) | |||
55186 | 55186 | 194332 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | Width 8ft | 6015905.66871 | 2112206.70701 | 37.7806101129033 | -122.38857720969601 | (37.7806101129033, -122.388577209696) | |||
55905 | 55905 | 195769 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6014035.25222 | 2110463.93544 | 37.77572102415021 | -122.394925826163 | (37.7757210241502, -122.394925826163) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");