Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47801 | 47801 | 234359 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x Dolores St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6005116.63925 | 2102018.48994 | 37.752031886768705 | -122.42517648553302 | (37.7520318867687, -122.425176485533) | ||||
| 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) | |||
| 27286 | 27286 | 132113 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6013330.52243 | 2119204.92075 | 37.7996825238869 | -122.39797700193701 | (37.7996825238869, -122.397977001937) | |||
| 62709 | 62709 | 132071 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6013261.919290001 | 2119233.02284 | 37.7997558644996 | -122.39821636821199 | (37.7997558644996, -122.398216368212) | |||
| 66065 | 66065 | 132114 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6013298.81612 | 2119255.09608 | 37.799818527453105 | -122.39809024008001 | (37.7998185274531, -122.39809024008) | |||
| 68393 | 68393 | 132116 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6013189.6161 | 2119421.22304 | 37.800268589579204 | -122.39847977871901 | (37.8002685895792, -122.398479778719) | |||
| 115831 | 115831 | 132073 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6013155.58738 | 2119398.1180000002 | 37.800203252927105 | -122.39859590999501 | (37.8002032529271, -122.398595909995) | |||
| 131771 | 131771 | 132074 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6013098.86351 | 2119482.52775 | 37.800431861502396 | -122.39879812525601 | (37.8004318615024, -122.398798125256) | |||
| 133036 | 133036 | 132072 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6013209.184309999 | 2119314.66631 | 37.799977100409 | -122.39840458371201 | (37.799977100409, -122.398404583712) | |||
| 137882 | 137882 | 132117 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 10ft | 6013132.776319999 | 2119506.7755299998 | 37.800500329583 | -122.398682475136 | (37.800500329583, -122.398682475136) | |||
| 147998 | 147998 | 132115 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6013243.85901 | 2119336.7003900004 | 37.8000395322586 | -122.398286142085 | (37.8000395322586, -122.398286142085) | |||
| 10203 | 10203 | 106598 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001X SAN JOSE AVE | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 85292 | 85292 | 106578 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 95732 | 95732 | 106583 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 101111 | 101111 | 106599 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 101240 | 101240 | 106579 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 107987 | 107987 | 106584 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 108041 | 108041 | 106585 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 115315 | 115315 | 106597 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 118789 | 118789 | 106592 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 121315 | 121315 | 106581 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 125322 | 125322 | 106587 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 141868 | 141868 | 106586 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 11046 | 11046 | 116538 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 3x3 | 6001578.1015800005 | 2088233.43486 | 37.7139807660769 | -122.436426724612 | (37.7139807660769, -122.436426724612) | |||
| 27784 | 27784 | 177494 | DPW Maintained 3 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1002x Naples St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6001533.96245 | 2088133.73568 | 37.7137045060241 | -122.43657215399901 | (37.7137045060241, -122.436572153999) | ||||
| 30642 | 30642 | 176917 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6001514.03799 | 2088123.65893 | 37.7136757052349 | -122.436640299224 | (37.7136757052349, -122.436640299224) | ||||
| 44260 | 44260 | 116540 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001555.506159999 | 2088195.95431 | 37.713876568835396 | -122.43650214175399 | (37.7138765688354, -122.436502141754) | |||
| 51303 | 51303 | 116542 | DPW Maintained 3 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1002x Naples St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001553.5279 | 2088171.08536 | 37.7138081717955 | -122.436507200445 | (37.7138081717955, -122.436507200445) | |||
| 59010 | 59010 | 116551 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 3x3 | 6001523.56178 | 2088140.13665 | 37.713721490625 | -122.43660856033199 | (37.713721490625, -122.436608560332) | |||
| 151872 | 151872 | 116550 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 3x3 | 6001534.78323 | 2088160.3445099997 | 37.7137776146169 | -122.43657122050399 | (37.7137776146169, -122.436571220504) | |||
| 156295 | 156295 | 116548 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001544.87474 | 2088178.1549900002 | 37.713827091712396 | -122.436537614614 | (37.7138270917124, -122.436537614614) | |||
| 158635 | 158635 | 116539 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001567.487380001 | 2088213.7256900002 | 37.7139260459311 | -122.436462001442 | (37.7139260459311, -122.436462001442) | |||
| 40010 | 40010 | 113539 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | ||||
| 88481 | 88481 | 113536 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
| 96850 | 96850 | 113535 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12/05/2015 12:49:00 PM | 3 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||
| 103732 | 103732 | 113537 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
| 104927 | 104927 | 113538 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
| 149526 | 149526 | 226828 | DPW Maintained 3 | Jubaea chilensis :: Chilean Wine Palm 425 | 100x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6004803.7155 | 2107705.9695200003 | 37.7676306780299 | -122.42666359364901 | (37.7676306780299, -122.426663593649) | ||||
| 188023 | 188023 | 234407 | DPW Maintained 3 | Phoenix dactylifera :: Date Palm 65 | 100x Dolores St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6004812.29017 | 2107562.9589 | 37.7672384899902 | -122.426623750084 | (37.7672384899902, -122.426623750084) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 30261 | 30261 | 239066 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100x McCoppin St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6005897.29527 | 2109110.01262 | 37.7715476104631 | -122.42298083840001 | (37.7715476104631, -122.4229808384) | ||||
| 50862 | 50862 | 221283 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 7ft | 6005964.92172 | 2109129.81976 | 37.771605811889295 | -122.422748322291 | (37.7716058118893, -122.422748322291) | |||
| 53164 | 53164 | 221287 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 7ft | 6005922.32152 | 2109128.4640099998 | 37.7715996856938 | -122.42289558268601 | (37.7715996856938, -122.422895582686) | |||
| 58158 | 58158 | 221288 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 7ft | 6005916.40156 | 2109112.96669 | 37.7715567997353 | -122.422914958583 | (37.7715567997353, -122.422914958583) | |||
| 71410 | 71410 | 239065 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100x McCoppin St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6005891.38819 | 2109122.4059599997 | 37.7715813062758 | -122.42300215235399 | (37.7715813062758, -122.423002152354) | ||||
| 75407 | 75407 | 239068 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100x McCoppin St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6005906.41313 | 2109090.3017599997 | 37.771494003666504 | -122.422947898021 | (37.7714940036665, -122.422947898021) | ||||
| 123750 | 123750 | 239067 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100x McCoppin St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6005903.21381 | 2109098.1768400003 | 37.7715154462189 | -122.422959524459 | (37.7715154462189, -122.422959524459) | ||||
| 149997 | 149997 | 221282 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 7ft | 6005974.66789 | 2109113.44306 | 37.7715613952811 | -122.42271344567301 | (37.7715613952811, -122.422713445673) | |||
| 166628 | 166628 | 221284 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 7ft | 6005955.036180001 | 2109112.17277 | 37.7715567997324 | -122.42278126266001 | (37.7715567997324, -122.42278126266) | |||
| 177458 | 177458 | 221286 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6005932.045 | 2109110.97186 | 37.77155220509079 | -122.42286070518 | (37.7715522050908, -122.42286070518) | |||
| 187319 | 187319 | 221285 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 7ft | 6005941.9303 | 2109128.61885 | 37.771601217256396 | -122.422827765695 | (37.7716012172564, -122.422827765695) | |||
| 129469 | 129469 | 101030 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1010X Portola Dr | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | ||||
| 115289 | 115289 | 105020 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101X ORD ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6000863.0 | 2105739.0 | 37.7620062865301 | -122.44015292861602 | (37.7620062865301, -122.440152928616) | ||||
| 26428 | 26428 | 195683 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 10ft | 6015319.49651 | 2111685.54707 | 37.7791466227626 | -122.390568648644 | (37.7791466227626, -122.390568648644) | |||
| 27977 | 27977 | 195679 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 10ft | 6015392.54447 | 2111760.15634 | 37.779355535273105 | -122.390321157906 | (37.7793555352731, -122.390321157906) | |||
| 32361 | 32361 | 195685 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 10ft | 6015271.08065 | 2111640.36137 | 37.7790198669015 | -122.390732981757 | (37.7790198669015, -122.390732981757) | |||
| 38581 | 38581 | 195678 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 10ft | 6015414.68674 | 2111779.65655 | 37.779410306669796 | -122.39024592062 | (37.7794103066698, -122.39024592062) | |||
| 45105 | 45105 | 195677 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 10ft | 6015444.73624 | 2111808.1158 | 37.779490116104 | -122.39014395459 | (37.779490116104, -122.39014395459) | |||
| 56412 | 56412 | 195676 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 10ft | 6015463.68033 | 2111825.11578 | 37.7795378449375 | -122.39007960629401 | (37.7795378449375, -122.390079606294) | |||
| 133285 | 133285 | 195673 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 10ft | 6015527.8527 | 2111885.3712299997 | 37.779706851835 | -122.38986181478201 | (37.779706851835, -122.389861814782) | |||
| 154428 | 154428 | 195674 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 10ft | 6015508.64587 | 2111869.51632 | 37.779662252656294 | -122.389927152313 | (37.7796622526563, -122.389927152313) | |||
| 170260 | 170260 | 195684 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 10ft | 6015289.74436 | 2111657.65185 | 37.779068378153 | -122.39066962450799 | (37.779068378153, -122.390669624508) | |||
| 170418 | 170418 | 195682 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 10ft | 6015332.35887 | 2111698.96547 | 37.7791841802313 | -122.39052508997 | (37.7791841802313, -122.39052508997) | |||
| 175056 | 175056 | 195675 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 10ft | 6015482.36105 | 2111843.26089 | 37.7795887033991 | -122.390016249049 | (37.7795887033991, -122.390016249049) | |||
| 181577 | 181577 | 195680 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 10ft | 6015377.63395 | 2111744.49968 | 37.779311718508 | -122.390371645854 | (37.779311718508, -122.390371645854) | |||
| 186361 | 186361 | 195681 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 10ft | 6015351.95562 | 2111719.9418200003 | 37.779242863700794 | -122.390458762259 | (37.7792428637008, -122.390458762259) | |||
| 23771 | 23771 | 116544 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 3x3 | 6001586.02621 | 2088182.95127 | 37.713842599620904 | -122.436395723209 | (37.7138425996209, -122.436395723209) | |||
| 24383 | 24383 | 116552 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001598.03525 | 2088202.06693 | 37.7138957693564 | -122.436355582838 | (37.7138957693564, -122.436355582838) | |||
| 51471 | 51471 | 116543 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 3x3 | 6001574.8493099995 | 2088164.89401 | 37.713792383287796 | -122.43643306305 | (37.7137923832878, -122.43643306305) | |||
| 64250 | 64250 | 116547 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 3x3 | 6001554.67745 | 2088129.8106 | 37.7136949057732 | -122.436500274771 | (37.7136949057732, -122.436500274771) | |||
| 137930 | 137930 | 116541 | DPW Maintained 3 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1041x Naples St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 3x3 | 6001548.78537 | 2088145.26253 | 37.7137369985308 | -122.436521745206 | (37.7137369985308, -122.436521745206) | |||
| 146422 | 146422 | 116546 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001545.434780001 | 2088113.86518 | 37.7136505979649 | -122.43653108014401 | (37.7136505979649, -122.436531080144) | |||
| 157761 | 157761 | 116545 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 3x3 | 6001537.057630001 | 2088100.5912 | 37.7136136745151 | -122.436559085032 | (37.7136136745151, -122.436559085032) | |||
| 158984 | 158984 | 116549 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 3x3 | 6001562.82912 | 2088145.2407900002 | 37.713737736870705 | -122.43647320339599 | (37.7137377368707, -122.436473203396) | |||
| 171144 | 171144 | 176918 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6001604.803669999 | 2088215.9120200002 | 37.713934169489704 | -122.43633317895599 | (37.7139341694897, -122.436333178956) | ||||
| 45535 | 45535 | 211042 | DPW Maintained 3 | Pinus halepensis :: Allepo Pine 164 | 1050x Moraga St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 5990982.70719 | 2103833.6403200002 | 37.756207220509204 | -122.47418564296001 | (37.7562072205092, -122.47418564296) | |||
| 79307 | 79307 | 107935 | DPW Maintained 3 | Tree(s) :: 17 | 1099X Market St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6009025.86197 | 2112294.38137 | 37.7804671773494 | -122.41238403194401 | (37.7804671773494, -122.412384031944) | |||||
| 19618 | 19618 | 102860 | DPW Maintained 3 | Calocedrus decurrens :: Incense Cedar 177 | 10X CRANLEIGH DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 03/06/2013 12:00:00 AM | 6 | 5991339.0 | 2095700.0 | 37.7338949747581 | -122.472360557436 | (37.7338949747581, -122.472360557436) | |||
| 79067 | 79067 | 116722 | DPW Maintained 3 | Calocedrus decurrens :: Incense Cedar 177 | 10X CRANLEIGH DR | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 3x3 | 5991371.0 | 2095902.0 | 37.7344514677467 | -122.472264644795 | (37.7344514677467, -122.472264644795) | |||
| 37447 | 37447 | 220241 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 10x Benton Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 6004791.23434 | 2095030.3631099998 | 37.7328256962469 | -122.425804423654 | (37.7328256962469, -122.425804423654) | ||||
| 116920 | 116920 | 234415 | DPW Maintained 3 | Phoenix dactylifera :: Date Palm 65 | 10x Benton Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6004760.79404 | 2095007.84902 | 37.732762157335 | -122.425908061504 | (37.732762157335, -122.425908061504) |
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");