Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1500 | 1500 | 251574 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 191 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999731.0 | 2100707.0 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | ||||
| 4446 | 4446 | 253627 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 5991061.0 | 2093828.0 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | ||||
| 10116 | 10116 | 173859 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 118 Saint Mary's Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
| 10123 | 10123 | 173857 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 118 Saint Mary's Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
| 10125 | 10125 | 173858 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 118 Saint Mary's Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
| 16111 | 16111 | 102843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 90127 | 90127 | 89023 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Hollywood Ct | 1 | unknown : Cutout 12 | Tree 1 | DPW 2 | 6000329.0 | 2088600.0 | 37.714916215224 | -122.440770357879 | (37.714916215224, -122.440770357879) | |||||
| 123948 | 123948 | 29904 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 Fell St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6004657.19551 | 2110576.88809 | 37.7755052392808 | -122.427374927138 | (37.7755052392808, -122.427374927138) | ||||||
| 145878 | 145878 | 89262 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Polk St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||||
| 1171 | 1171 | 172952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3000X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 0 | Width 3ft | 6005556.34576 | 2120733.12845 | 37.8034425497953 | -122.42498731221201 | (37.8034425497953, -122.424987312212) | ||
| 17534 | 17534 | 5492 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 719 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 8 | 6005040.753830001 | 2104151.1903 | 37.7578834965409 | -122.425590680889 | (37.7578834965409, -122.425590680889) | |||
| 54812 | 54812 | 175058 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1132x Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003548.97454 | 2094354.07012 | 37.7308984688672 | -122.430051002559 | (37.7308984688672, -122.430051002559) | |||
| 55316 | 55316 | 200609 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 49 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016412.3996 | 2095168.4353 | 37.7338546875634 | -122.385636349995 | (37.7338546875634, -122.385636349995) | |||
| 62628 | 62628 | 200574 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016364.4111 | 2095326.6015 | 37.734286324847005 | -122.385813282871 | (37.734286324847, -122.385813282871) | |||
| 106349 | 106349 | 22188 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3955X 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 6x4 | 6015734.92142 | 2098004.1287700003 | 37.74160341581771 | -122.388176448398 | (37.7416034158177, -122.388176448398) | |||
| 133833 | 133833 | 188653 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6017421.68385 | 2098629.86939 | 37.7434148869 | -122.382387660761 | (37.7434148869, -122.382387660761) | ||||
| 175369 | 175369 | 188654 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6017424.39169 | 2098619.4012 | 37.7433862929421 | -122.382377569482 | (37.7433862929421, -122.382377569482) | ||||
| 2529 | 2529 | 141382 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1294X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001285.0 | 2110102.0 | 37.7740100190711 | -122.439006092772 | (37.7740100190711, -122.439006092772) | |||
| 119608 | 119608 | 188659 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6017103.6349 | 2098887.87453 | 37.744105743386 | -122.383505361577 | (37.744105743386, -122.383505361577) | ||||
| 1059 | 1059 | 186952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 0ft | 5985204.8226 | 2096075.4539 | 37.734568936321295 | -122.493595616872 | (37.7345689363213, -122.493595616872) | |||
| 3196 | 3196 | 9420 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6005985.41292 | 2112474.4888400002 | 37.780790619431706 | -122.422915195091 | (37.7807906194317, -122.422915195091) | |||
| 8111 | 8111 | 6041 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1830 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/1990 12:00:00 AM | 3 | 3X3 | 6001487.9166 | 2112537.6047 | 37.78070911887679 | -122.438478710972 | (37.7807091188768, -122.438478710972) | ||
| 13955 | 13955 | 97226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016643.51258 | 2094941.1276900002 | 37.7332433315076 | -122.38482148523899 | (37.7332433315076, -122.384821485239) | ||
| 14140 | 14140 | 6797 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1375 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 6016896.75135 | 2097199.75019 | 37.7394590596789 | -122.384103192232 | (37.7394590596789, -122.384103192232) | |||
| 14947 | 14947 | 24225 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 58 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6017167.401959999 | 2094982.30239 | 37.7333853506538 | -122.38301310328698 | (37.7333853506538, -122.383013103287) | ||
| 15245 | 15245 | 11544 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Jennings St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018840.43674 | 2097157.24182 | 37.7394496095988 | -122.37737975539 | (37.7394496095988, -122.37737975539) | ||
| 16107 | 16107 | 97223 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016661.55982 | 2094959.63165 | 37.733295137843 | -122.384760378985 | (37.733295137843, -122.384760378985) | ||
| 16363 | 16363 | 6635 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1499 Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2016 08:50:00 AM | 3 | 3X3 | 6016265.445719999 | 2098016.2601900003 | 37.741666106596796 | -122.38634290341801 | (37.7416661065968, -122.386342903418) | ||
| 16543 | 16543 | 15277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1563X Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777705 | 6007250.560819999 | 2109703.40074 | 37.7732531819334 | -122.418341887077 | (37.7732531819334, -122.418341887077) | |
| 18211 | 18211 | 11709 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.83406 | 2092750.4086799999 | 37.7257930014245 | -122.472332875878 | (37.7257930014245, -122.472332875878) | ||
| 19829 | 19829 | 10274 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 218 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/2016 03:07:00 PM | 3 | 3x3 | 6004921.53459 | 2109545.1488200002 | 37.772687280827604 | -122.426387037745 | (37.7726872808276, -122.426387037745) | ||
| 20767 | 20767 | 5601 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1120-1122 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/2016 12:00:00 AM | 3 | 6X6 | 6005089.20528 | 2101804.2581 | 37.7514421059774 | -122.425256113291 | (37.7514421059774, -122.425256113291) | ||
| 21068 | 21068 | 29972 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991341.172 | 2093706.68724 | 37.7284219643784 | -122.47220779725299 | (37.7284219643784, -122.472207797253) | ||
| 21269 | 21269 | 5395 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 347 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/2014 12:00:00 AM | 3 | 3x3 | 6004924.31069 | 2106310.22613 | 37.763805117627896 | -122.426147093211 | (37.7638051176279, -122.426147093211) | ||
| 21937 | 21937 | 29584 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 3 | 3X3 | 5991345.88941 | 2093701.3780900002 | 37.728407659786 | -122.47219110225299 | (37.728407659786, -122.472191102253) | ||
| 42702 | 42702 | 200540 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6016179.8101 | 2095650.1621 | 37.7351645401576 | -122.38647406665501 | (37.7351645401576, -122.386474066655) | |||
| 69580 | 69580 | 188649 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700x Quesada Ave | 50 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 7ft | 6014280.17751 | 2095342.33163 | 37.734213959905205 | -122.393020304839 | (37.7342139599052, -122.393020304839) | |||
| 81565 | 81565 | 443 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700x 23rd Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988815.988030001 | 2110428.99683 | 37.774190512498706 | -122.482161976658 | (37.7741905124987, -122.482161976658) | ||||
| 83214 | 83214 | 448 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700x 23rd Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988818.05287 | 2110350.21953 | 37.773974331987795 | -122.482149061597 | (37.7739743319878, -122.482149061597) | ||||
| 88164 | 88164 | 12734 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/2015 12:00:00 AM | 3 | 3X3 | 5990479.84568 | 2114768.877 | 37.7862032574553 | -122.476723596597 | (37.7862032574553, -122.476723596597) | ||
| 93273 | 93273 | 21282 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2492X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) | |||
| 93717 | 93717 | 25437 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2555 Bay Shore Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/1998 12:00:00 AM | 3 | 3x3 | 6010830.95304 | 2086585.06609 | 37.7099761086624 | -122.40432925767401 | (37.7099761086624, -122.404329257674) | ||
| 108793 | 108793 | 17197 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1675X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6004367.95797 | 2119722.65234 | 37.8006008446769 | -122.42902768903099 | (37.8006008446769, -122.429027689031) | |||
| 123767 | 123767 | 22132 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3795X 03rd St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6015998.68116 | 2098857.5612 | 37.743961376796996 | -122.387323966992 | (37.743961376797, -122.387323966992) | |||
| 141992 | 141992 | 89458 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3500X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987773.9063 | 2111900.8711599996 | 37.7781711994801 | -122.48587473348199 | (37.7781711994801, -122.485874733482) | ||
| 51216 | 51216 | 200556 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016262.7203 | 2095558.3918 | 37.734917146653 | -122.38618101771601 | (37.734917146653, -122.386181017716) | |||
| 59915 | 59915 | 200610 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 50 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016417.2964 | 2095161.5798 | 37.733836134681795 | -122.385618942498 | (37.7338361346818, -122.385618942498) | |||
| 23087 | 23087 | 6567 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/2004 12:00:00 AM | 5 | 3X3 | 6017004.85053 | 2097463.70294 | 37.7401897966309 | -122.383747801739 | (37.7401897966309, -122.383747801739) | ||
| 55759 | 55759 | 188646 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6018092.675340001 | 2098102.14022 | 37.74200288923021 | -122.380030855133 | (37.7420028892302, -122.380030855133) | ||||
| 130923 | 130923 | 188582 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012479.86277 | 2103522.41115 | 37.7565745414011 | -122.39981880719999 | (37.7565745414011, -122.3998188072) | ||||
| 131211 | 131211 | 200607 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016406.5235 | 2095183.1256 | 37.73389469904829 | -122.385657689133 | (37.7338946990483, -122.385657689133) | |||
| 133052 | 133052 | 203807 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 335x Pacheco St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5994179.6676199995 | 2101287.15386 | 37.7493999011887 | -122.46294480178699 | (37.7493999011887, -122.462944801787) | |||
| 133432 | 133432 | 203808 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 335x Pacheco St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5994148.64523 | 2101441.5060099997 | 37.7498219260394 | -122.46306327486 | (37.7498219260394, -122.46306327486) | |||
| 137116 | 137116 | 188583 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012480.57258 | 2103516.6299400004 | 37.7565587070348 | -122.399815946472 | (37.7565587070348, -122.399815946472) | ||||
| 137306 | 137306 | 125295 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1306x Montgomery St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6011445.958380001 | 2119999.7387 | 37.801759761770604 | -122.40455429893998 | (37.8017597617706, -122.40455429894) | |||
| 137749 | 137749 | 200543 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016187.8616 | 2095644.6304 | 37.7351497969246 | -122.38644584387501 | (37.7351497969246, -122.386445843875) | |||
| 166461 | 166461 | 188581 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012475.30485 | 2103528.81943 | 37.75659188303771 | -122.39983502019 | (37.7565918830377, -122.39983502019) | ||||
| 188905 | 188905 | 200550 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016212.9331 | 2095623.1152 | 37.7350921083386 | -122.386357662249 | (37.7350921083386, -122.386357662249) | |||
| 613 | 613 | 20019 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 1084 | 1084 | 8287 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1601 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2017 12:00:00 AM | 6 | 3x3 | 6015799.31492 | 2097666.33838 | 37.7406794801837 | -122.387930230222 | (37.7406794801837, -122.387930230222) | ||
| 3819 | 3819 | 19829 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY25 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 5371 | 5371 | 18271 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1949 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002897.9436 | 2114073.452 | 37.785006273193495 | -122.43371055367399 | (37.7850062731935, -122.433710553674) | |||
| 6495 | 6495 | 26421 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2235X Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 6004624.1328 | 2116974.76242 | 37.793070338586205 | -122.427945300259 | (37.7930703385862, -122.427945300259) | |||
| 6982 | 6982 | 17878 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2189 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003500.3079 | 2115200.4578 | 37.78813490757079 | -122.431707058922 | (37.7881349075708, -122.431707058922) | |||
| 8001 | 8001 | 20026 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 8245 | 8245 | 20020 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 9882 | 9882 | 173729 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
| 10951 | 10951 | 24278 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350X Winding Way | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000808.42529 | 2086790.5767400002 | 37.709975233345 | -122.438983668972 | (37.709975233345, -122.438983668972) | |||
| 11240 | 11240 | 19966 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY41 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 12225 | 12225 | 24277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350X Winding Way | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000814.16949 | 2086790.4577099998 | 37.709975233345496 | -122.43896380743999 | (37.7099752333455, -122.43896380744) | |||
| 15525 | 15525 | 3745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900 Carolina St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 18 | 6012461.71984 | 2103674.63492 | 37.7569915030708 | -122.39989224135799 | (37.7569915030708, -122.399892241358) | |||
| 16079 | 16079 | 19828 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY25 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 16094 | 16094 | 20027 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 16182 | 16182 | 6428 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100X Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/29/1990 12:00:00 AM | 6 | 3x3 | 6018145.74781 | 2096700.42192 | 37.7381569780515 | -122.379749980697 | (37.7381569780515, -122.379749980697) | ||
| 16240 | 16240 | 97228 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 15x200 | 6016642.6726 | 2094934.5266099998 | 37.733225159799204 | -122.384823929606 | (37.7332251597992, -122.384823929606) | |||
| 16309 | 16309 | 6731 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6017098.09908 | 2097131.4743700002 | 37.7392827179327 | -122.38340226151699 | (37.7392827179327, -122.383402261517) | ||
| 23028 | 23028 | 97224 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 6 | 15x200 | 6016653.042219999 | 2094950.9325 | 37.733270780626995 | -122.38478922115499 | (37.733270780627, -122.384789221155) | ||
| 38644 | 38644 | 200553 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016224.312999999 | 2095613.1578 | 37.7350653972301 | -122.38631762348301 | (37.7350653972301, -122.386317623483) | |||
| 72358 | 72358 | 124133 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3500x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5996054.79965 | 2112880.00292 | 37.781338707390105 | -122.45729914105499 | (37.7813387073901, -122.457299141055) | ||||
| 77165 | 77165 | 24211 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 80X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016364.4746918 | 2096121.5533417999 | 37.736469106467 | -122.38586845516501 | (37.736469106467, -122.385868455165) | |||
| 83174 | 83174 | 111552 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x BOSWORTH ST | 30 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 101329 | 101329 | 18212 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1575 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/1998 12:00:00 AM | 6 | 3X3 | 6004651.317293701 | 2114317.5621297 | 37.7857758731644 | -122.427661834419 | (37.7857758731644, -122.427661834419) | ||
| 107225 | 107225 | 41576 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/22/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53640 | 6004804.85382115 | 2107218.95663379 | 37.7662935218736 | -122.426624972491 | (37.7662935218736, -122.426624972491) | |
| 136589 | 136589 | 188651 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6017373.9642900005 | 2098663.52344 | 37.7435046581055 | -122.38255500572399 | (37.7435046581055, -122.382555005724) | ||||
| 138777 | 138777 | 22638 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/1990 12:00:00 AM | 6 | 3X3 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | ||
| 143355 | 143355 | 111556 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x BOSWORTH ST | 34 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 172385 | 172385 | 200555 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016252.4072 | 2095574.3949 | 37.7349605171331 | -122.386217789361 | (37.7349605171331, -122.386217789361) | |||
| 49943 | 49943 | 200538 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016175.1953 | 2095654.7768 | 37.7351769557335 | -122.38649034349899 | (37.7351769557335, -122.386490343499) | |||
| 121090 | 121090 | 200539 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016182.3272 | 2095656.8744 | 37.735183110122 | -122.38646583191401 | (37.735183110122, -122.386465831914) | |||
| 169431 | 169431 | 200546 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016197.8191 | 2095632.8949 | 37.735118124804394 | -122.386410598906 | (37.7351181248044, -122.386410598906) | |||
| 9906 | 9906 | 173728 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
| 15842 | 15842 | 97227 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 15x200 | 6016638.64484 | 2094938.128 | 37.733234825728296 | -122.384838105605 | (37.7332348257283, -122.384838105605) | |||
| 72616 | 72616 | 188650 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700x Quesada Ave | 51 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6014234.97615 | 2095377.1002900002 | 37.734306916536 | -122.39317901359699 | (37.734306916536, -122.393179013597) | ||||
| 93197 | 93197 | 6832 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1485 FAIRFAX AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6016296.0 | 2097688.0 | 37.7407664622153 | -122.38621437638201 | (37.7407664622153, -122.386214376382) | |||
| 180983 | 180983 | 200531 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016156.3167 | 2095682.0459 | 37.7352507861079 | -122.386557515095 | (37.7352507861079, -122.386557515095) | |||
| 125197 | 125197 | 110465 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1485 FAIRFAX AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 9 | 3x3 | 6016296.0 | 2097688.0 | 37.7407664622153 | -122.38621437638201 | (37.7407664622153, -122.386214376382) | |||
| 137314 | 137314 | 200611 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6016421.2138 | 2095153.2552 | 37.7338134937512 | -122.385604818769 | (37.7338134937512, -122.385604818769) | |||
| 143150 | 143150 | 24212 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 80X Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/2002 12:00:00 AM | 9 | 3x3 | 6016364.4746918 | 2096121.5533417999 | 37.736469106467 | -122.38586845516501 | (37.736469106467, -122.385868455165) | ||
| 159406 | 159406 | 200605 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 46 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6016398.6886 | 2095199.7747 | 37.7339399806144 | -122.385685937001 | (37.7339399806144, -122.385685937001) | |||
| 168459 | 168459 | 188642 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Cargo Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6018846.51114 | 2097536.89048 | 37.7404923843103 | -122.377385089264 | (37.7404923843103, -122.377385089264) |
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");