Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93295 | 93295 | 104872 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1753 Noe St | 1 | Hanging basket : Yard 27 | Tree 1 | Private 1 | 11/22/2013 12:00:00 AM | Permit Number 770054 | 6003434.1 | 2098036.1 | 37.7410019772539 | -122.430710793678 | (37.7410019772539, -122.430710793678) | |||
| 66105 | 66105 | 98309 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 401X Newhall St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 6 | 3x3 | 6016081.14502 | 2097910.9401599998 | 37.741366715992896 | -122.386972815546 | (37.7413667159929, -122.386972815546) | |||
| 114979 | 114979 | 118322 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 720 BATTERY ST | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 6012486.0 | 2118560.0 | 37.7978646555778 | -122.400854041686 | (37.7978646555778, -122.400854041686) | |||||
| 19725 | 19725 | 114507 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 10 LOMBARD ST | 2 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 83194 | 83194 | 87400 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | |||
| 91163 | 91163 | 16010 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | 4 | 6001411.931226401 | 2094682.0759854 | 37.7316778334432 | -122.437462576871 | (37.7316778334432, -122.437462576871) | |||
| 96662 | 96662 | 87399 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | |||
| 99327 | 99327 | 16156 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
| 103676 | 103676 | 26760 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 930X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5995872.4804074 | 2094645.0571617 | 37.731259698358 | -122.456610772668 | (37.731259698358, -122.456610772668) | ||
| 113103 | 113103 | 16159 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
| 114141 | 114141 | 27681 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
| 117485 | 117485 | 87401 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | |||
| 120810 | 120810 | 16331 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 800X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996797.9550648 | 2094752.6454838002 | 37.7316082025531 | -122.453419021963 | (37.7316082025531, -122.453419021963) | ||
| 121740 | 121740 | 16161 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 3 | G | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | ||
| 4390 | 4390 | 175420 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 211 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6003926.56795 | 2092414.35505 | 37.7255938222743 | -122.428607384746 | (37.7255938222743, -122.428607384746) | |||
| 50427 | 50427 | 179309 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 213 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6003911.34447 | 2092391.41197 | 37.725529964113605 | -122.42865837630801 | (37.7255299641136, -122.428658376308) | |||
| 130186 | 130186 | 142826 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1725 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006566.9559 | 2116825.8136 | 37.7927710822258 | -122.421212426745 | (37.7927710822258, -122.421212426745) | |||
| 131782 | 131782 | 179284 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 721 Goettingen St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 6010763.30464 | 2091319.72205 | 37.7229727292859 | -122.404896194231 | (37.7229727292859, -122.404896194231) | |||
| 181259 | 181259 | 179308 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 223 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6003895.65676 | 2092365.8261400003 | 37.7254588232518 | -122.428710784278 | (37.7254588232518, -122.428710784278) | |||
| 27161 | 27161 | 197088 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014473.69906 | 2102184.6927400003 | 37.753012404101 | -122.39282976818998 | (37.753012404101, -122.39282976819) | |||
| 30381 | 30381 | 197107 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014386.38736 | 2102037.52751 | 37.7526034697945 | -122.393121414743 | (37.7526034697945, -122.393121414743) | |||
| 30856 | 30856 | 197169 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Baldwin Ct | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6017690.0216 | 2093651.3665 | 37.7297597257339 | -122.38111373781 | (37.7297597257339, -122.38111373781) | |||
| 36178 | 36178 | 197095 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6014479.30677 | 2102077.89395 | 37.7527194688438 | -122.39280290452601 | (37.7527194688438, -122.392802904526) | |||
| 36783 | 36783 | 136264 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Montgomery St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6011327.59811 | 2121029.0502400002 | 37.804579383680895 | -122.40503639942601 | (37.8045793836809, -122.405036399426) | |||
| 40908 | 40908 | 197109 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6012049.36164 | 2105557.39202 | 37.7621381396801 | -122.401450654931 | (37.7621381396801, -122.401450654931) | ||||
| 41596 | 41596 | 197086 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014471.44073 | 2102209.38753 | 37.7530800852958 | -122.39283930551599 | (37.7530800852958, -122.392839305516) | |||
| 45418 | 45418 | 197094 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014478.47867 | 2102089.9100099998 | 37.7527524163908 | -122.392806608832 | (37.7527524163908, -122.392806608832) | |||
| 45516 | 45516 | 117917 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 767 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5983194.46177 | 2110567.54263 | 37.7742423451733 | -122.501617774429 | (37.7742423451733, -122.501617774429) | |||
| 55248 | 55248 | 197103 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014438.05571 | 2102040.91433 | 37.7526156394141 | -122.392942972153 | (37.7526156394141, -122.392942972153) | |||
| 57011 | 57011 | 136263 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Montgomery St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6011331.32037 | 2121003.20622 | 37.804508630427 | -122.40502169731 | (37.804508630427, -122.40502169731) | |||
| 62833 | 62833 | 197084 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014468.76337 | 2102245.03022 | 37.753177803814 | -122.39285105782801 | (37.753177803814, -122.392851057828) | |||
| 65149 | 65149 | 197108 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6012056.73956 | 2105565.85317 | 37.762161783771205 | -122.401425732033 | (37.7621617837712, -122.401425732033) | ||||
| 69725 | 69725 | 124089 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 601 Funston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5991892.74244 | 2111106.03462 | 37.7762279504105 | -122.47156838077 | (37.7762279504105, -122.47156838077) | ||||
| 70424 | 70424 | 124324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Jordan Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5996182.48161 | 2113700.3553299997 | 37.7835985094544 | -122.45691677945 | (37.7835985094544, -122.45691677945) | |||
| 73613 | 73613 | 136261 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008598.0245 | 2119155.01738 | 37.7992807940363 | -122.414349696679 | (37.7992807940363, -122.414349696679) | ||||
| 76745 | 76745 | 197102 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014466.67746 | 2102042.06403 | 37.752620386043205 | -122.392844072804 | (37.7526203860432, -122.392844072804) | |||
| 121744 | 121744 | 107696 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2401 MORAGA ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | ||||
| 134067 | 134067 | 197110 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6012050.80748 | 2105527.2247200003 | 37.7620553876595 | -122.40144353408701 | (37.7620553876595, -122.401443534087) | ||||
| 134469 | 134469 | 197089 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014473.51573 | 2102162.27258 | 37.7529508329366 | -122.39282883379101 | (37.7529508329366, -122.392828833791) | |||
| 136568 | 136568 | 136260 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 740 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6007759.94756 | 2120993.00482 | 37.8042803312301 | -122.417380065732 | (37.8042803312301, -122.417380065732) | |||
| 137657 | 137657 | 197111 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6012057.756469999 | 2105514.57714 | 37.762021047941204 | -122.401418611192 | (37.7620210479412, -122.401418611192) | ||||
| 149097 | 149097 | 197092 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014476.97343 | 2102121.40509 | 37.752838811567 | -122.392814017467 | (37.752838811567, -122.392814017467) | |||
| 150842 | 150842 | 136205 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Locust St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5997542.32225 | 2115652.46545 | 37.78903647900739 | -122.452353187461 | (37.7890364790074, -122.452353187461) | |||
| 157085 | 157085 | 197085 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014468.858580001 | 2102236.49554 | 37.7531543746906 | -122.392850131521 | (37.7531543746906, -122.392850131521) | |||
| 157309 | 157309 | 197105 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014414.64892 | 2102038.8947099997 | 37.752608793773796 | -122.393023776248 | (37.7526087937738, -122.393023776248) | |||
| 160169 | 160169 | 197087 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014472.10243 | 2102198.29911 | 37.753049675611 | -122.39283624152 | (37.753049675611, -122.39283624152) | |||
| 168763 | 168763 | 213992 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6001188.39506 | 2095218.69175 | 37.733138545197704 | -122.43827381338801 | (37.7331385451977, -122.438273813388) | |||
| 170402 | 170402 | 197083 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014468.24915 | 2102256.69833 | 37.7532098133945 | -122.392853652369 | (37.7532098133945, -122.392853652369) | |||
| 171068 | 171068 | 197090 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014474.311480001 | 2102148.65752 | 37.752913493081294 | -122.39282512948 | (37.7529134930813, -122.39282512948) | |||
| 172109 | 172109 | 213994 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 132 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999171.152980001 | 2095530.50421 | 37.7338797682181 | -122.445270345553 | (37.7338797682181, -122.445270345553) | |||
| 176731 | 176731 | 197101 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 37 Arkansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6012884.97292 | 2106850.1929599997 | 37.7657344728051 | -122.398651302829 | (37.7657344728051, -122.398651302829) | |||
| 178466 | 178466 | 197104 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014428.85484 | 2102039.8538900004 | 37.752612216591004 | -122.392974716426 | (37.752612216591, -122.392974716426) | |||
| 178725 | 178725 | 197106 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014394.04215 | 2102037.78794 | 37.752604610114005 | -122.393094961165 | (37.752604610114, -122.393094961165) | |||
| 181135 | 181135 | 197093 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014477.98301 | 2102105.11898 | 37.7527941494528 | -122.392809386851 | (37.7527941494528, -122.392809386851) | |||
| 181973 | 181973 | 197091 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014475.63706 | 2102134.7648099996 | 37.7528754202862 | -122.39281957348601 | (37.7528754202862, -122.392819573486) | |||
| 104090 | 104090 | 87073 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 395 Byxbee St | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 110241 | 110241 | 87072 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 395 Byxbee St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 81776 | 81776 | 114391 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 23x PINTO AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988521.0 | 2090808.0 | 37.720299292258794 | -122.481744923362 | (37.7202992922588, -122.481744923362) | ||||
| 93217 | 93217 | 114390 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 23x PINTO AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988521.0 | 2090808.0 | 37.720299292258794 | -122.481744923362 | (37.7202992922588, -122.481744923362) | ||||
| 93327 | 93327 | 112843 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1415 EVANS AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016481.0 | 2097724.0 | 37.7408755487739 | -122.385577218432 | (37.7408755487739, -122.385577218432) | |||||
| 109838 | 109838 | 98274 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 766 Anderson St | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/23/2012 12:00:00 AM | 18 | Permit Number 768445 | 6007723.0 | 2095324.0 | 37.7337971999422 | -122.41568932106199 | (37.7337971999422, -122.415689321062) | |||
| 138436 | 138436 | 114384 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 418X SERRANO DR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 152567 | 152567 | 249824 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 285 Kearny St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6010866.76079 | 2120642.6759099998 | 37.8034927229673 | -122.40660393393999 | (37.8034927229673, -122.40660393394) | |||
| 160304 | 160304 | 247591 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 800 Tompkins Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6008974.65943 | 2096434.5209700002 | 37.736916732029705 | -122.411440373668 | (37.7369167320297, -122.411440373668) | ||||
| 5925 | 5925 | 95365 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 661 Broadway | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 778058 | 6010478.0762 | 2118518.1883 | 37.797637647796996 | -122.40779910526899 | (37.797637647797, -122.407799105269) | ||
| 9726 | 9726 | 173663 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 3878 17th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003109.0 | 2105964.0 | 37.7627516946294 | -122.432400964417 | (37.7627516946294, -122.432400964417) | ||||
| 53643 | 53643 | 95364 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 661 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 3x3 | Permit Number 778058 | 6010448.4751 | 2118513.4790000003 | 37.797623060035 | -122.407901201302 | (37.797623060035, -122.407901201302) | ||
| 98119 | 98119 | 117314 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 910 Clayton St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 5998775.9 | 2106883.7 | 37.7650303025851 | -122.447453764259 | (37.7650303025851, -122.447453764259) | |||
| 102660 | 102660 | 85090 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 125168 | 125168 | 85089 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 146084 | 146084 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 652 | 652 | 237023 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:44:00 PM | 3 | Width 6ft | 6005765.01716 | 2109438.39176 | 37.7724417955802 | -122.423461745458 | (37.7724417955802, -122.423461745458) | ||
| 661 | 661 | 237024 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 5 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:48:00 PM | 3 | Width 6ft | 6005763.84021 | 2109451.72322 | 37.772478334130994 | -122.423466764586 | (37.772478334131, -122.423466764586) | ||
| 663 | 663 | 237022 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 3 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:40:00 PM | 3 | Width 6ft | 6005770.133230001 | 2109412.50366 | 37.772371001847 | -122.423442207693 | (37.772371001847, -122.423442207693) | ||
| 665 | 665 | 239151 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Octavia St | 2 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:58:00 PM | 3 | Width 4ft | 6005731.03459 | 2109700.90805 | 37.7731606839629 | -122.423597962203 | (37.7731606839629, -122.423597962203) | ||
| 666 | 666 | 237028 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 9 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:55:00 PM | 3 | Width 6ft | 6005756.39315 | 2109517.28856 | 37.7726579404383 | -122.423497186858 | (37.7726579404383, -122.423497186858) | ||
| 23424 | 23424 | 197132 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016788.78445 | 2098277.43468 | 37.742412193171795 | -122.384551543811 | (37.7424121931718, -122.384551543811) | |||
| 23930 | 23930 | 246508 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 241 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6004932.15845 | 2099866.5422 | 37.7461127118493 | -122.425661300149 | (37.7461127118493, -122.425661300149) | |||
| 25564 | 25564 | 197127 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Newhall St | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017303.080490001 | 2098110.9339400004 | 37.7419834431736 | -122.382761660942 | (37.7419834431736, -122.382761660942) | |||
| 28183 | 28183 | 246963 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 238 Noe St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6002871.51875 | 2106887.2406200003 | 37.765273220394796 | -122.433288301134 | (37.7652732203948, -122.433288301134) | |||
| 32581 | 32581 | 197122 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Napoleon St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013973.73168 | 2100142.08459 | 37.747376054258105 | -122.394415755007 | (37.7473760542581, -122.394415755007) | |||
| 34091 | 34091 | 197124 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Napoleon St | 12 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6013733.0286 | 2100130.5529400003 | 37.747331007214896 | -122.395247287949 | (37.7473310072149, -122.395247287949) | |||
| 40754 | 40754 | 247569 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6008658.24946 | 2095385.97007 | 37.7340198862064 | -122.41246025166299 | (37.7340198862064, -122.412460251663) | |||
| 44172 | 44172 | 247564 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6008777.64172 | 2095456.26862 | 37.7342196103425 | -122.412052440585 | (37.7342196103425, -122.412052440585) | |||
| 44291 | 44291 | 247563 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6008788.9631 | 2095462.99791 | 37.734238722726495 | -122.41201377422199 | (37.7342387227265, -122.412013774222) | |||
| 44502 | 44502 | 202037 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 75 Crane St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012270.3118199995 | 2090901.9422 | 37.7219097135375 | -122.399657426574 | (37.7219097135375, -122.399657426574) | |||
| 46583 | 46583 | 246509 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 241 Duncan St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6004948.2324 | 2099866.59265 | 37.7461137586439 | -122.425605722044 | (37.7461137586439, -122.425605722044) | |||
| 48422 | 48422 | 197116 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1015 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6011950.215340001 | 2103491.63171 | 37.75646048668521 | -122.40164836548 | (37.7564604866852, -122.40164836548) | |||
| 49322 | 49322 | 197128 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016765.196409999 | 2098282.20265 | 37.7424239805909 | -122.384633436999 | (37.7424239805909, -122.384633436999) | |||
| 55329 | 55329 | 249399 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 222 Hyde St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6008090.577380001 | 2113215.48771 | 37.78294378436429 | -122.41568486886999 | (37.7829437843643, -122.41568486887) | |||
| 55551 | 55551 | 197118 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Texas St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6013784.73559 | 2105658.04133 | 37.7625111748734 | -122.39545566804199 | (37.7625111748734, -122.395455668042) | |||
| 56227 | 56227 | 197135 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015262.92854 | 2096819.7411099998 | 37.738325167482294 | -122.389725749154 | (37.7383251674823, -122.389725749154) | |||
| 56408 | 56408 | 197131 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 Newhall St | 17 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015885.54456 | 2097735.3383299997 | 37.740873716654 | -122.38763689115 | (37.740873716654, -122.38763689115) | |||
| 60831 | 60831 | 247567 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 320 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6008730.40268 | 2095427.8255 | 37.7341388611064 | -122.412213751984 | (37.7341388611064, -122.412213751984) | |||
| 67268 | 67268 | 197120 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6014065.797040001 | 2105649.96536 | 37.7625046287026 | -122.394483006312 | (37.7625046287026, -122.394483006312) | |||
| 68861 | 68861 | 197140 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 53 Pomona St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6014151.58684 | 2094423.9633799999 | 37.7316851643341 | -122.39340063984 | (37.7316851643341, -122.39340063984) | |||
| 69161 | 69161 | 247568 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 322 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6008688.67784 | 2095404.14208 | 37.734071490194296 | -122.41235633497101 | (37.7340714901943, -122.412356334971) | |||
| 70907 | 70907 | 197139 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 139 Venus St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012870.02823 | 2094155.1374099997 | 37.730875736712704 | -122.39781242511101 | (37.7308757367127, -122.397812425111) | |||
| 73028 | 73028 | 197130 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 Newhall St | 16 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015893.1870800005 | 2097747.64492 | 37.7409079313583 | -122.38761132431299 | (37.7409079313583, -122.387611324313) | |||
| 73273 | 73273 | 197136 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6015282.23394 | 2096844.32451 | 37.7383937389821 | -122.38966071648998 | (37.7383937389821, -122.38966071649) |
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");