trees
1,985 rows where qSpecies_id = 83 sorted by qSiteInfo 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 139061 | 118322 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 720 BATTERY ST | 1 | unknown : Yard | Tree | Private 2 | 6012486 | 2118560 | 37.7978646555778 | -122.400854041686 | (37.7978646555778, -122.400854041686) | 3 | 1 | 10 | 28860 | 6 | |||||
| 25557 | 197109 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 600 De Haro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6012049.36164 | 2105557.39202 | 37.7621381396801 | -122.401450654931 | (37.7621381396801, -122.401450654931) | 10 | 3 | 8 | 28856 | 29 | ||||
| 29411 | 124324 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 109 Jordan Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5996182.48161 | 2113700.35533 | 37.7835985094544 | -122.45691677945 | (37.7835985094544, -122.45691677945) | 11 | 6 | 1 | 54 | 31 | |||
| 31675 | 197094 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6014478.47867 | 2102089.91001 | 37.7527524163908 | -122.392806608832 | (37.7527524163908, -122.392806608832) | 10 | 3 | 8 | 28856 | 29 | |||
| 33350 | 136264 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Montgomery St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6011327.59811 | 2121029.05024 | 37.8045793836809 | -122.405036399426 | (37.8045793836809, -122.405036399426) | 3 | 1 | 10 | 28860 | 6 | |||
| 33554 | 197092 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6014476.97343 | 2102121.40509 | 37.752838811567 | -122.392814017467 | (37.752838811567, -122.392814017467) | 10 | 3 | 8 | 28856 | 29 | |||
| 40402 | 213992 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6001188.39506 | 2095218.69175 | 37.7331385451977 | -122.438273813388 | (37.7331385451977, -122.438273813388) | 9 | 7 | 5 | 63 | 40 | |||
| 45868 | 197111 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 600 De Haro St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6012057.75647 | 2105514.57714 | 37.7620210479412 | -122.401418611192 | (37.7620210479412, -122.401418611192) | 10 | 3 | 8 | 28856 | 29 | ||||
| 46887 | 197089 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6014473.51573 | 2102162.27258 | 37.7529508329366 | -122.392828833791 | (37.7529508329366, -122.392828833791) | 10 | 3 | 8 | 28856 | 29 | |||
| 47479 | 197087 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6014472.10243 | 2102198.29911 | 37.753049675611 | -122.39283624152 | (37.753049675611, -122.39283624152) | 10 | 3 | 8 | 28856 | 29 | |||
| 49918 | 197084 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6014468.76337 | 2102245.03022 | 37.753177803814 | -122.392851057828 | (37.753177803814, -122.392851057828) | 10 | 3 | 8 | 28856 | 29 | |||
| 57741 | 124089 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 601 Funston Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5991892.74244 | 2111106.03462 | 37.7762279504105 | -122.47156838077 | (37.7762279504105, -122.47156838077) | 11 | 6 | 2 | 54 | 11 | ||||
| 58349 | 197085 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6014468.85858 | 2102236.49554 | 37.7531543746906 | -122.392850131521 | (37.7531543746906, -122.392850131521) | 10 | 3 | 8 | 28856 | 29 | |||
| 60124 | 197105 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1468 25th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6014414.64892 | 2102038.89471 | 37.7526087937738 | -122.393023776248 | (37.7526087937738, -122.393023776248) | 10 | 3 | 8 | 28856 | 29 | |||
| 61070 | 197108 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 600 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6012056.73956 | 2105565.85317 | 37.7621617837712 | -122.401425732033 | (37.7621617837712, -122.401425732033) | 10 | 3 | 8 | 28856 | 29 | ||||
| 62836 | 197104 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1468 25th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6014428.85484 | 2102039.85389 | 37.752612216591 | -122.392974716426 | (37.752612216591, -122.392974716426) | 10 | 3 | 8 | 28856 | 29 | |||
| 69106 | 197107 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1468 25th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6014386.38736 | 2102037.52751 | 37.7526034697945 | -122.393121414743 | (37.7526034697945, -122.393121414743) | 10 | 3 | 8 | 28856 | 29 | |||
| 90339 | 197086 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6014471.44073 | 2102209.38753 | 37.7530800852958 | -122.392839305516 | (37.7530800852958, -122.392839305516) | 10 | 3 | 8 | 28856 | 29 | |||
| 98945 | 197110 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 600 De Haro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6012050.80748 | 2105527.22472 | 37.7620553876595 | -122.401443534087 | (37.7620553876595, -122.401443534087) | 10 | 3 | 8 | 28856 | 29 | ||||
| 99499 | 197083 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6014468.24915 | 2102256.69833 | 37.7532098133945 | -122.392853652369 | (37.7532098133945, -122.392853652369) | 10 | 3 | 8 | 28856 | 29 | |||
| 105111 | 197169 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Baldwin Ct | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6017690.0216 | 2093651.3665 | 37.7297597257339 | -122.38111373781 | (37.7297597257339, -122.38111373781) | 10 | 3 | 8 | 58 | 1 | |||
| 113490 | 197093 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6014477.98301 | 2102105.11898 | 37.7527941494528 | -122.392809386851 | (37.7527941494528, -122.392809386851) | 10 | 3 | 8 | 28856 | 29 | |||
| 119192 | 197101 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 37 Arkansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6012884.97292 | 2106850.19296 | 37.7657344728051 | -122.398651302829 | (37.7657344728051, -122.398651302829) | 14 | 3 | 8 | 28856 | 20 | |||
| 120563 | 136261 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 15 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6008598.0245 | 2119155.01738 | 37.7992807940363 | -122.414349696679 | (37.7992807940363, -122.414349696679) | 5 | 1 | 10 | 308 | 32 | ||||
| 139723 | 197090 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6014474.31148 | 2102148.65752 | 37.7529134930813 | -122.39282512948 | (37.7529134930813, -122.39282512948) | 10 | 3 | 8 | 28856 | 29 | |||
| 153472 | 136260 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 740 Francisco St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007759.94756 | 2120993.00482 | 37.8042803312301 | -122.417380065732 | (37.8042803312301, -122.417380065732) | 5 | 1 | 1 | 308 | 32 | |||
| 158764 | 213994 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 132 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5999171.15298 | 2095530.50421 | 37.7338797682181 | -122.445270345553 | (37.7338797682181, -122.445270345553) | 9 | 7 | 4 | 59 | 40 | |||
| 160123 | 197102 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1468 25th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6014466.67746 | 2102042.06403 | 37.7526203860432 | -122.392844072804 | (37.7526203860432, -122.392844072804) | 10 | 3 | 8 | 28856 | 29 | |||
| 161764 | 117917 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 767 41st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5983194.46177 | 2110567.54263 | 37.7742423451733 | -122.501617774429 | (37.7742423451733, -122.501617774429) | 11 | 6 | 2 | 55 | 26 | |||
| 163050 | 197088 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6014473.69906 | 2102184.69274 | 37.753012404101 | -122.39282976819 | (37.753012404101, -122.39282976819) | 10 | 3 | 8 | 28856 | 29 | |||
| 166874 | 197103 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1468 25th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6014438.05571 | 2102040.91433 | 37.7526156394141 | -122.392942972153 | (37.7526156394141, -122.392942972153) | 10 | 3 | 8 | 28856 | 29 | |||
| 169067 | 197106 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1468 25th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6014394.04215 | 2102037.78794 | 37.752604610114 | -122.393094961165 | (37.752604610114, -122.393094961165) | 10 | 3 | 8 | 28856 | 29 | |||
| 170535 | 107696 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2401 MORAGA ST | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | 1 | 8 | 3 | 56 | 35 | ||||
| 171580 | 136205 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Locust St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5997542.32225 | 2115652.46545 | 37.7890364790074 | -122.452353187461 | (37.7890364790074, -122.452353187461) | 11 | 6 | 1 | 54 | 31 | |||
| 174230 | 136263 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Montgomery St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6011331.32037 | 2121003.20622 | 37.804508630427 | -122.40502169731 | (37.804508630427, -122.40502169731) | 3 | 1 | 10 | 28860 | 6 | |||
| 181501 | 197095 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6014479.30677 | 2102077.89395 | 37.7527194688438 | -122.392802904526 | (37.7527194688438, -122.392802904526) | 10 | 3 | 8 | 28856 | 29 | |||
| 184472 | 197091 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6014475.63706 | 2102134.76481 | 37.7528754202862 | -122.392819573486 | (37.7528754202862, -122.392819573486) | 10 | 3 | 8 | 28856 | 29 | |||
| 21703 | 95365 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 661 Broadway | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778058 | 6010478.0762 | 2118518.1883 | 37.797637647797 | -122.407799105269 | (37.797637647797, -122.407799105269) | 3 | 1 | 10 | 308 | 4 | ||
| 37483 | 85089 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
| 52899 | 173663 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 3878 17th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6003109 | 2105964 | 37.7627516946294 | -122.432400964417 | (37.7627516946294, -122.432400964417) | 15 | 4 | 5 | 28862 | 3 | ||||
| 60118 | 95364 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 661 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 7 | 3x3 | Permit Number 778058 | 6010448.4751 | 2118513.479 | 37.797623060035 | -122.407901201302 | (37.797623060035, -122.407901201302) | 3 | 1 | 10 | 308 | 4 | ||
| 105107 | 85090 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
| 110729 | 117314 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 910 Clayton St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | 5998775.9 | 2106883.7 | 37.7650303025851 | -122.447453764259 | (37.7650303025851, -122.447453764259) | 15 | 5 | 11 | 29492 | 9 | |||
| 193247 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
| 449 | 252970 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101X Whipple Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/26/2019 12:00:00 AM | 3 | |||||||||||||
| 3730 | 120250 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 164 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5988365.5517 | 2114845.05893 | 37.7862895663335 | -122.484043998391 | (37.7862895663335, -122.484043998391) | 11 | 6 | 1 | 55 | 33 | |||
| 21171 | 197125 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 31 Apparel Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 6011537.38847 | 2097577.661 | 37.7401989607078 | -122.402660197209 | (37.7401989607078, -122.402660197209) | 10 | 3 | 8 | 58 | 1 | |||
| 28070 | 120249 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 164 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5988365.91336 | 2114852.64965 | 37.7863104293457 | -122.484043303996 | (37.7863104293457, -122.484043303996) | 11 | 6 | 1 | 55 | 33 | |||
| 30941 | 136212 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Spruce St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997026.47763 | 2115953.79939 | 37.7898342954728 | -122.454159706 | (37.7898342954728, -122.454159706) | 11 | 6 | 1 | 54 | 31 | |||
| 33930 | 213991 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1 Merced Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5995344.90173 | 2100199.2685 | 37.7464798897511 | -122.458836668093 | (37.7464798897511, -122.458836668093) | 1 | 8 | 4 | 59 | 40 | |||
| 40382 | 141284 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 305 Anza St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5998229.3925 | 2112598.2057 | 37.7806896223004 | -122.449755833322 | (37.7806896223004, -122.449755833322) | 15 | 6 | 2 | 54 | 16 | |||
| 51039 | 139399 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 896 STEINER ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 6003012.8594 | 2111291.1403 | 37.7773732632111 | -122.433114118747 | (37.7773732632111, -122.433114118747) | 15 | 9 | 11 | 29492 | 10 | |||
| 59318 | 141285 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 303 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5998264.5884 | 2112604.2973 | 37.7807083618514 | -122.449634513412 | (37.7807083618514, -122.449634513412) | 15 | 6 | 2 | 54 | 16 | |||
| 73403 | 141286 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 303 Anza St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5998281.8479 | 2112606.3279 | 37.7807149247435 | -122.449574951116 | (37.7807149247435, -122.449574951116) | 15 | 6 | 2 | 54 | 16 | |||
| 79546 | 179334 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1119 Athens St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6001947.96661 | 2087712.00011 | 37.7125700310481 | -122.435111061438 | (37.7125700310481, -122.435111061438) | 9 | 7 | 6 | 28861 | 5 | |||
| 83246 | 120256 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 140 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5988368.86327 | 2114963.36268 | 37.7866145875471 | -122.484041219882 | (37.7866145875471, -122.484041219882) | 11 | 6 | 1 | 55 | 33 | |||
| 83858 | 179336 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 225 Naylor St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6002643.14283 | 2086748.99011 | 37.7099652661681 | -122.43263957156 | (37.7099652661681, -122.43263957156) | 9 | 7 | 6 | 28861 | 5 | |||
| 92180 | 138832 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 745 BUCHANAN ST | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 6004455.5234 | 2111072.8991 | 37.7768557558926 | -122.428107915053 | (37.7768557558926, -122.428107915053) | 7 | 9 | 11 | 28852 | 10 | |||
| 92920 | 120248 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 164 24th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5988365.09621 | 2114861.46484 | 37.7863345857746 | -122.484046777757 | (37.7863345857746, -122.484046777757) | 11 | 6 | 1 | 55 | 33 | |||
| 105538 | 120251 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 160 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5988366.40775 | 2114885.43189 | 37.7864004688283 | -122.484043998399 | (37.7864004688283, -122.484043998399) | 11 | 6 | 1 | 55 | 33 | |||
| 111047 | 120252 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 160 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5988365.81555 | 2114876.44647 | 37.7863757629455 | -122.484045388081 | (37.7863757629455, -122.484045388081) | 11 | 6 | 1 | 55 | 33 | |||
| 114013 | 239321 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 78 Norwich St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6008940.36814 | 2099480.93118 | 37.7452795843951 | -122.411774130991 | (37.7452795843951, -122.411774130991) | 2 | 7 | 7 | 28859 | 2 | ||||
| 116196 | 139287 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 894 STEINER ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 6003017.2906 | 2111263.9995 | 37.7772989926884 | -122.433096850145 | (37.7772989926884, -122.433096850145) | 15 | 9 | 11 | 29492 | 10 | |||
| 117791 | 213933 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2176 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5991344.08373 | 2100608.05246 | 37.7473715261751 | -122.472700716564 | (37.7473715261751, -122.472700716564) | 1 | 8 | 4 | 29491 | 40 | |||
| 118817 | 120253 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 24th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5988369.64092 | 2114933.75275 | 37.7865333323848 | -122.484036357305 | (37.7865333323848, -122.484036357305) | 11 | 6 | 1 | 55 | 33 | |||
| 119645 | 197126 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 31 Apparel Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 6011547.96771 | 2097644.33103 | 37.7403826130582 | -122.402628305469 | (37.7403826130582, -122.402628305469) | 10 | 3 | 8 | 58 | 1 | |||
| 120896 | 141283 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 305 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5998211.7946 | 2112594.1447 | 37.7806774650063 | -122.449816419899 | (37.7806774650063, -122.449816419899) | 15 | 6 | 2 | 54 | 16 | |||
| 121667 | 120259 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 130 24th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5988369.32629 | 2115004.14379 | 37.7867265878172 | -122.484042609601 | (37.7867265878172, -122.484042609601) | 11 | 6 | 1 | 55 | 33 | |||
| 122452 | 179335 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1119 Athens St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6001959.57443 | 2087726.76645 | 37.7126112352992 | -122.435071996701 | (37.7126112352992, -122.435071996701) | 9 | 7 | 6 | 28861 | 5 | |||
| 127417 | 120257 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 140 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5988368.87318 | 2114954.36452 | 37.7865898817391 | -122.484040525506 | (37.7865898817391, -122.484040525506) | 11 | 6 | 1 | 55 | 33 | |||
| 136855 | 136262 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 11 Filbert St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6012539.85481 | 2120210.2855 | 37.8023989459081 | -122.400783688018 | (37.8023989459081, -122.400783688018) | 3 | 1 | 10 | 28860 | 6 | ||||
| 139056 | 247402 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 944 Page St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 6002027.7583 | 2109490.1505 | 37.7723722659737 | -122.436392970615 | (37.7723722659737, -122.436392970615) | 15 | 5 | 11 | 29492 | 9 | |||
| 141906 | 114383 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 418X SERRANO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
| 141976 | 120254 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5988369.36546 | 2114920.76145 | 37.7864976459369 | -122.4840363573 | (37.7864976459369, -122.4840363573) | 11 | 6 | 1 | 55 | 33 | |||
| 153821 | 120258 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 130 24th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5988366.4287 | 2115019.00218 | 37.7867672160285 | -122.484053724446 | (37.7867672160285, -122.484053724446) | 11 | 6 | 1 | 55 | 33 | |||
| 164932 | 139289 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 818 STEINER ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 6003024.4912 | 2111210.2718 | 37.7771518782412 | -122.433068101317 | (37.7771518782412, -122.433068101317) | 15 | 9 | 11 | 29492 | 10 | |||
| 166209 | 136214 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3601 Jackson St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5996953.55493 | 2115974.46386 | 37.7898868527455 | -122.45441350369 | (37.7898868527455, -122.45441350369) | 11 | 6 | 1 | 54 | 31 | |||
| 173859 | 136211 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Spruce St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5997026.34564 | 2115964.00812 | 37.7898623183414 | -122.454160900321 | (37.7898623183414, -122.454160900321) | 11 | 6 | 1 | 54 | 31 | |||
| 180083 | 120255 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5988367.99594 | 2114912.99225 | 37.7864762341937 | -122.484040525506 | (37.7864762341937, -122.484040525506) | 11 | 6 | 1 | 55 | 33 | |||
| 11751 | 142826 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1731 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 0ft | 6006566.9559 | 2116825.8136 | 37.7927710822258 | -122.421212426745 | (37.7927710822258, -122.421212426745) | 13 | 9 | 10 | 28858 | 32 | |||
| 114724 | 179309 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 213 Edinburgh St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6003911.34447 | 2092391.41197 | 37.7255299641136 | -122.428658376308 | (37.7255299641136, -122.428658376308) | 9 | 7 | 6 | 28861 | 5 | |||
| 134997 | 179284 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 721 Goettingen St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 4ft | 6010763.30464 | 2091319.72205 | 37.7229727292859 | -122.404896194231 | (37.7229727292859, -122.404896194231) | 10 | 3 | 7 | 309 | 28 | |||
| 189553 | 175420 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 211 Edinburgh St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6003926.56795 | 2092414.35505 | 37.7255938222743 | -122.428607384746 | (37.7255938222743, -122.428607384746) | 9 | 7 | 6 | 28861 | 5 | |||
| 193501 | 179308 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 223 Edinburgh St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 6003895.65676 | 2092365.82614 | 37.7254588232518 | -122.428710784278 | (37.7254588232518, -122.428710784278) | 9 | 7 | 6 | 28861 | 5 | |||
| 281 | 136194 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002528.73575 | 2118269.03723 | 37.7965053162169 | -122.435288106477 | (37.7965053162169, -122.435288106477) | 13 | 9 | 1 | 57 | 17 | |||
| 381 | 136202 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1337 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004913.0684 | 2120534.02336 | 37.8028595013299 | -122.427199210075 | (37.8028595013299, -122.427199210075) | 13 | 9 | 1 | 57 | 17 | |||
| 611 | 10613 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 34 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1993 12:00:00 AM | 18 | 3X3 | 6016953.5018076 | 2095595.9312574 | 37.7350584319022 | -122.383795333225 | (37.7350584319022, -122.383795333225) | 10 | 3 | 8 | 58 | 1 | ||
| 670 | 197144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 67 Jennings Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012875.71849 | 2089235.92195 | 37.7173688854414 | -122.397447893917 | (37.7173688854414, -122.397447893917) | 10 | 3 | 8 | 58 | 1 | |||
| 691 | 199940 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1177 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017562.0246 | 2092865.5482 | 37.7275949559017 | -122.381501616556 | (37.7275949559017, -122.381501616556) | 10 | 3 | 8 | 58 | 1 | |||
| 737 | 8938 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 4649X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5992558.61151 | 2112698.79101 | 37.7806397269512 | -122.469380940837 | (37.7806397269512, -122.469380940837) | 11 | 6 | 2 | 54 | 11 | |||
| 810 | 75303 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 376 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6010591.15079 | 2106579.14528 | 37.7648621726769 | -122.406566076957 | (37.7648621726769, -122.406566076957) | 8 | 4 | 8 | 28853 | 19 | |||
| 971 | 16508 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 325 Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016639.93914 | 2098306.03692 | 37.7424824967653 | -122.385068203435 | (37.7424824967653, -122.385068203435) | 10 | 3 | 8 | 58 | 1 | |||
| 1044 | 139272 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 765 FULTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004185.2644 | 2111476.3212 | 37.7779481591061 | -122.429071593475 | (37.7779481591061, -122.429071593475) | 7 | 9 | 11 | 28852 | 10 | |||
| 1241 | 140612 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 880 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003492.8085 | 2111354.3072 | 37.777573917235 | -122.431458329369 | (37.777573917235, -122.431458329369) | 7 | 9 | 11 | 29492 | 10 | |||
| 1245 | 213791 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 209 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 768064 | 5995620.63174 | 2091343.81767 | 37.7221808240739 | -122.45724272857 | (37.7221808240739, -122.45724272857) | 9 | 8 | 4 | 28861 | 24 |
| 1294 | 136237 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008274 | 2116946 | 37.7931971721852 | -122.415314473397 | (37.7931971721852, -122.415314473397) | 5 | 1 | 10 | 28858 | 21 | |||
| 1330 | 239316 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1100 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6010239.40016 | 2102763.26328 | 37.7543649341213 | -122.407513645861 | (37.7543649341213, -122.407513645861) | 2 | 4 | 7 | 28859 | 19 | |||
| 1477 | 112866 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 750 VICENTE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990595 | 2097751 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | 1 | 8 | 4 | 29491 | 40 | ||||
| 1502 | 77647 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | 9 | 3 | 7 | 309 | 5 | ||
| 1561 | 24107 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 105X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 |
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) );