Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2490 | 2490 | 119764 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2496 | 2496 | 119765 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2509 | 2509 | 119763 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 3007 | 3007 | 253279 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10x10 | ROW IS 10' tree is street tree | ||||||||
| 59350 | 59350 | 84206 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 655 Sunnydale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50698 | 6009700.46384 | 2086497.5066400003 | 37.7096724504982 | -122.40823029041 | (37.7096724504982, -122.40823029041) | |
| 70211 | 70211 | 84207 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 655 Sunnydale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50698 | 6009673.82964 | 2086513.38985 | 37.7097145711409 | -122.408323462874 | (37.7097145711409, -122.408323462874) | |
| 151992 | 151992 | 84208 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 655 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50698 | 6009650.10329 | 2086520.7766900002 | 37.709733525243394 | -122.40840598644199 | (37.7097335252434, -122.408405986442) | |
| 149413 | 149413 | 84209 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 655 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50698 | 6009625.62268 | 2086528.94568 | 37.7097545846723 | -122.408491172057 | (37.7097545846723, -122.408491172057) | |
| 174381 | 174381 | 84210 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 655 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50698 | 6009606.75025 | 2086539.9182400003 | 37.709783656161605 | -122.408557172383 | (37.7097836561616, -122.408557172383) | |
| 166186 | 166186 | 112969 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 701 Sunnydale Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009537.04857 | 2086566.80096 | 37.7098535667562 | -122.408799970467 | (37.7098535667562, -122.408799970467) | |||
| 163187 | 163187 | 112968 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 701 Sunnydale Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009509.441330001 | 2086572.7332900001 | 37.709868309348394 | -122.40889580489299 | (37.7098683093484, -122.408895804893) | |||
| 148831 | 148831 | 112967 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 701 Sunnydale Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009490.41259 | 2086583.85945 | 37.709897793608896 | -122.408962356547 | (37.7098977936089, -122.408962356547) | |||
| 31640 | 31640 | 112966 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 701 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009445.28541 | 2086599.3527799998 | 37.709937807151704 | -122.409119417731 | (37.7099378071517, -122.409119417731) | |||
| 64815 | 64815 | 112965 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 701 Sunnydale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009423.83756 | 2086605.1592 | 37.7099525488346 | -122.409193955337 | (37.7099525488346, -122.409193955337) | |||
| 32246 | 32246 | 187491 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 750 Velasco Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6006526.88476 | 2086669.8859599999 | 37.7099675513223 | -122.419210983794 | (37.7099675513223, -122.419210983794) | ||||
| 48198 | 48198 | 112964 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 701 Sunnydale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009407.05623 | 2086613.17163 | 37.7099736091697 | -122.409252520091 | (37.7099736091697, -122.409252520091) | |||
| 74253 | 74253 | 112963 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 701 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009387.902419999 | 2086618.16453 | 37.709986245537294 | -122.40931907171199 | (37.7099862455373, -122.409319071712) | |||
| 151648 | 151648 | 187492 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 750 Velasco Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6006524.35531 | 2086677.42218 | 37.7099881017507 | -122.419220260308 | (37.7099881017507, -122.419220260308) | ||||
| 146989 | 146989 | 112962 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 701 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009373.36818 | 2086623.06286 | 37.7099988810277 | -122.409369650496 | (37.7099988810277, -122.409369650496) | |||
| 156294 | 156294 | 112961 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 701 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009358.8024 | 2086626.42802 | 37.710007304956605 | -122.409420230177 | (37.7100073049566, -122.409420230177) | |||
| 54048 | 54048 | 179198 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 122 Santos St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6006476.020330001 | 2086698.2398299999 | 37.7100425404106 | -122.41938879147 | (37.7100425404106, -122.41938879147) | |||
| 4087 | 4087 | 159329 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 556 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:09:00 AM | 3 | Width 0ft | 5997921.94288 | 2087046.44589 | 37.7105131349458 | -122.448978278232 | (37.7105131349458, -122.448978278232) | ||
| 31551 | 31551 | 179200 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 65 Blythdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6006727.82618 | 2086918.41314 | 37.7106612694605 | -122.418534101884 | (37.7106612694605, -122.418534101884) | |||
| 26875 | 26875 | 179199 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 65 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006710.21835 | 2086918.77417 | 37.710661269476 | -122.41859498419 | (37.710661269476, -122.41859498419) | |||
| 160335 | 160335 | 179202 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 50 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6006615.933569999 | 2086979.4031 | 37.710822435165205 | -122.41892515139799 | (37.7108224351652, -122.418925151398) | |||
| 39093 | 39093 | 179201 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 50 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6006633.11275 | 2086991.19455 | 37.7108557793466 | -122.418866611803 | (37.7108557793466, -122.418866611803) | |||
| 3998 | 3998 | 159324 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 516 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:39:00 AM | 3 | Width 0ft | 5998061.98233 | 2087178.88925 | 37.710884802276205 | -122.44850380581998 | (37.7108848022762, -122.44850380582) | ||
| 55470 | 55470 | 179197 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 165 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6005726.28272 | 2087133.8162 | 37.7111962851662 | -122.42201095643499 | (37.7111962851662, -122.422010956435) | |||
| 50936 | 50936 | 179196 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 178 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6005626.77881 | 2087137.8945099998 | 37.7112018708407 | -122.42235515666599 | (37.7112018708407, -122.422355156666) | |||
| 4015 | 4015 | 159294 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 118 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:12:00 PM | 3 | Width 0ft | 5998151.37307 | 2087303.3135799998 | 37.7112315538724 | -122.44820380548799 | (37.7112315538724, -122.448203805488) | ||
| 44669 | 44669 | 179195 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 178 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6005631.155180001 | 2087152.0442 | 37.7112409697606 | -122.422341035527 | (37.7112409697606, -122.422341035527) | |||
| 49167 | 49167 | 179194 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 178 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6005636.53153 | 2087165.1563799998 | 37.7112772763038 | -122.422323384518 | (37.7112772763038, -122.422323384518) | |||
| 188341 | 188341 | 179203 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 145 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6005739.90981 | 2087176.84104 | 37.711315190823996 | -122.42196691216101 | (37.711315190824, -122.421966912161) | |||
| 63599 | 63599 | 179204 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 145 Blythdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 6ft | 6005707.03107 | 2087192.3586400002 | 37.711355944501 | -122.422081651264 | (37.711355944501, -122.422081651264) | |||
| 26179 | 26179 | 179193 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 170 Brookdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6005644.83636 | 2087196.5165400002 | 37.7113638531203 | -122.422296907583 | (37.7113638531203, -122.422296907583) | |||
| 184195 | 184195 | 179192 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 170 Brookdale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6005649.34848 | 2087217.2749299998 | 37.711421105778996 | -122.422282786434 | (37.711421105779, -122.422282786434) | |||
| 57344 | 57344 | 179191 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 170 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6005654.25627 | 2087232.43068 | 37.711462997092205 | -122.42226689991999 | (37.7114629970922, -122.42226689992) | |||
| 28265 | 28265 | 179185 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1500 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6007214.91098 | 2087479.51248 | 37.7122293408956 | -122.41689035163401 | (37.7122293408956, -122.416890351634) | |||
| 148480 | 148480 | 179186 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1500 Sunnydale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6007201.69456 | 2087483.6172599997 | 37.712239868336894 | -122.416936322255 | (37.7122398683369, -122.416936322255) | |||
| 134919 | 134919 | 179187 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1500 Sunnydale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007159.282430001 | 2087497.73072 | 37.712276235134794 | -122.41708391091998 | (37.7122762351348, -122.41708391092) | |||
| 74136 | 74136 | 179188 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1500 Sunnydale Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007144.00968 | 2087503.96893 | 37.7122925047707 | -122.41713713998199 | (37.7122925047707, -122.417137139982) | |||
| 185866 | 185866 | 179189 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1600 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6007006.17756 | 2087541.64708 | 37.712388206122 | -122.417616198935 | (37.712388206122, -122.417616198935) | |||
| 4025 | 4025 | 159222 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 384 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 09:28:00 AM | 3 | Width 0ft | 5998624.92984 | 2087716.64467 | 37.712393528324206 | -122.446596800611 | (37.7123935283242, -122.446596800611) | ||
| 133095 | 133095 | 179190 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1600 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006848.67689 | 2087568.72125 | 37.71245368215921 | -122.418162488524 | (37.7124536821592, -122.418162488524) | |||
| 4104 | 4104 | 159219 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 366 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 09:32:00 AM | 3 | Width 0ft | 5998673.37335 | 2087760.7240000002 | 37.7125173271842 | -122.446432534932 | (37.7125173271842, -122.446432534932) | ||
| 4042 | 4042 | 179821 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 364 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:07:00 AM | 3 | Width 2ft | 5998698.94465 | 2087786.79601 | 37.712590375508796 | -122.446346027354 | (37.7125903755088, -122.446346027354) | ||
| 63898 | 63898 | 179230 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1725 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6006577.9120000005 | 2087637.98608 | 37.712628624579395 | -122.41910324683998 | (37.7126286245794, -122.41910324684) | |||
| 51456 | 51456 | 179205 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1700 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6006698.43617 | 2087637.4256 | 37.7126338721354 | -122.418686636782 | (37.7126338721354, -122.418686636782) | |||
| 54258 | 54258 | 179206 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1700 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6006680.55061 | 2087645.0552700001 | 37.712653814591 | -122.418748995784 | (37.712653814591, -122.418748995784) | |||
| 185850 | 185850 | 179229 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1725 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6006523.82481 | 2087658.59053 | 37.712682154019 | -122.41929165028999 | (37.712682154019, -122.41929165029) | |||
| 69779 | 69779 | 179228 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1725 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6006500.20711 | 2087667.48458 | 37.7127052450291 | -122.419373911274 | (37.7127052450291, -122.419373911274) | |||
| 155573 | 155573 | 179227 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1751 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6006428.508719999 | 2087690.36193 | 37.7127640229211 | -122.419623346348 | (37.7127640229211, -122.419623346348) | |||
| 24120 | 24120 | 179207 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1750 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6006573.63704 | 2087691.58982 | 37.7127755684169 | -122.41912182232402 | (37.7127755684169, -122.419121822324) | |||
| 44475 | 44475 | 179208 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1750 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6006534.036859999 | 2087707.31011 | 37.712816502856796 | -122.419259808007 | (37.7128165028568, -122.419259808007) | |||
| 147788 | 147788 | 179226 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1751 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6006357.33519 | 2087720.1094 | 37.7128416937526 | -122.419871454925 | (37.7128416937526, -122.419871454925) | |||
| 78036 | 78036 | 41518 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 208 Peninsula Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42062 | 6012484.96446964 | 2087604.06197755 | 37.712866358901294 | -122.398684103253 | (37.7128663589013, -122.398684103253) | |||
| 81458 | 81458 | 41517 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 208 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42062 | 6012484.96446964 | 2087604.06197755 | 37.712866358901294 | -122.398684103253 | (37.7128663589013, -122.398684103253) | |||
| 104292 | 104292 | 41511 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 208 Peninsula Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42062 | 6012484.96446964 | 2087604.06197755 | 37.712866358901294 | -122.398684103253 | (37.7128663589013, -122.398684103253) | |||
| 104945 | 104945 | 41513 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 208 Peninsula Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42062 | 6012484.96446964 | 2087604.06197755 | 37.712866358901294 | -122.398684103253 | (37.7128663589013, -122.398684103253) | |||
| 105710 | 105710 | 41514 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 208 Peninsula Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42062 | 6012484.96446964 | 2087604.06197755 | 37.712866358901294 | -122.398684103253 | (37.7128663589013, -122.398684103253) | |||
| 119767 | 119767 | 41512 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 208 Peninsula Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42062 | 6012484.96446964 | 2087604.06197755 | 37.712866358901294 | -122.398684103253 | (37.7128663589013, -122.398684103253) | |||
| 125677 | 125677 | 41516 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 208 Peninsula Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42062 | 6012484.96446964 | 2087604.06197755 | 37.712866358901294 | -122.398684103253 | (37.7128663589013, -122.398684103253) | |||
| 142479 | 142479 | 41520 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 208 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42062 | 6012484.96446964 | 2087604.06197755 | 37.712866358901294 | -122.398684103253 | (37.7128663589013, -122.398684103253) | |||
| 143714 | 143714 | 41515 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 208 Peninsula Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42062 | 6012484.96446964 | 2087604.06197755 | 37.712866358901294 | -122.398684103253 | (37.7128663589013, -122.398684103253) | |||
| 143880 | 143880 | 41519 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 208 Peninsula Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42062 | 6012484.96446964 | 2087604.06197755 | 37.712866358901294 | -122.398684103253 | (37.7128663589013, -122.398684103253) | |||
| 28483 | 28483 | 179209 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1772 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6006471.88428 | 2087727.6982 | 37.712868983682604 | -122.419476073376 | (37.7128689836826, -122.419476073376) | |||
| 131276 | 131276 | 87955 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 240 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50979 | 6009689.61 | 2087667.18 | 37.712883527737006 | -122.40835025024599 | (37.712883527737, -122.408350250246) | |
| 69086 | 69086 | 179225 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1801 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006308.59662 | 2087739.45788 | 37.71289207468671 | -122.420041283778 | (37.7128920746867, -122.420041283778) | |||
| 73849 | 73849 | 179210 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1772 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6006450.99959 | 2087738.82958 | 37.7128983717435 | -122.41954904706499 | (37.7128983717435, -122.419549047065) | |||
| 154768 | 154768 | 179224 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1801 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006288.05669 | 2087748.6711799998 | 37.7129162151802 | -122.420112930068 | (37.7129162151802, -122.420112930068) | |||
| 4119 | 4119 | 159216 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 326 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:09:00 AM | 3 | Width 0ft | 5998830.44796 | 2087909.1779599998 | 37.712933918350394 | -122.445900308946 | (37.7129339183504, -122.445900308946) | ||
| 73852 | 73852 | 179223 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1801 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 6006254.517659999 | 2087760.44493 | 37.7129466536263 | -122.42022968726299 | (37.7129466536263, -122.420229687263) | |||
| 165777 | 165777 | 179211 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1800 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006359.89696 | 2087770.1325599998 | 37.7129791911096 | -122.419866148013 | (37.7129791911096, -122.419866148013) | |||
| 48309 | 48309 | 179212 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1800 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6006336.27941 | 2087779.02675 | 37.713002282110295 | -122.419948408995 | (37.7130022821103, -122.419948408995) | |||
| 75489 | 75489 | 179213 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1800 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6006300.8377 | 2087791.60426 | 37.7130348204719 | -122.420071799571 | (37.7130348204719, -122.420071799571) | |||
| 117034 | 117034 | 179222 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1825 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 6006153.59555 | 2087799.59528 | 37.7130484649775 | -122.420581285317 | (37.7130484649775, -122.420581285317) | |||
| 162500 | 162500 | 179231 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 321 Ellington Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998927.87734 | 2087954.11713 | 37.7130628739226 | -122.445566791793 | (37.7130628739226, -122.445566791793) | |||
| 137277 | 137277 | 179221 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1851 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006089.55617 | 2087821.5515700001 | 37.713105142972296 | -122.420804184985 | (37.7131051429723, -122.420804184985) | |||
| 120602 | 120602 | 115341 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1514 SUNNYDALE AVE | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Housing Authority 20 | Private 3 | 3x3 | 6006572.0 | 2087815.0 | 37.7131143345755 | -122.41913622882099 | (37.7131143345755, -122.419136228821) | |||
| 26907 | 26907 | 179220 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1851 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006068.28025 | 2087832.3093700001 | 37.7131334823856 | -122.420878485149 | (37.7131334823856, -122.420878485149) | |||
| 30562 | 30562 | 179219 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1901 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6005910.8454 | 2087904.7300099998 | 37.7133234587798 | -122.42142777398399 | (37.7133234587798, -122.421427773984) | |||
| 65999 | 65999 | 179218 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1901 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6005890.39204 | 2087918.14698 | 37.713359145694795 | -122.42149942028401 | (37.7133591456948, -122.421499420284) | |||
| 42567 | 42567 | 179214 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1900 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6005943.70452 | 2087934.63592 | 37.7134074266914 | -122.421316323695 | (37.7134074266914, -122.421316323695) | |||
| 40967 | 40967 | 179215 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1900 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6005901.26281 | 2087961.5006799998 | 37.7134787986892 | -122.421464924083 | (37.7134787986892, -122.421464924083) | |||
| 103237 | 103237 | 69394 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 40 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33498 | 6001207.260514401 | 2088075.42261957 | 37.7135258204231 | -122.437697178946 | (37.7135258204231, -122.437697178946) | ||
| 170574 | 170574 | 179216 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1924 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6005874.75653 | 2087979.24642 | 37.7135260301628 | -122.42155779887699 | (37.7135260301628, -122.421557798877) | |||
| 43869 | 43869 | 179217 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2055 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005575.94717 | 2088046.16302 | 37.7136929155569 | -122.42259534402001 | (37.7136929155569, -122.42259534402) | |||
| 35869 | 35869 | 179244 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 917 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6001618.54316 | 2088748.06741 | 37.7153961307972 | -122.436323752237 | (37.7153961307972, -122.436323752237) | |||
| 135686 | 135686 | 179245 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 917 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6001629.43176 | 2088767.7080400002 | 37.7154506782843 | -122.436287521258 | (37.7154506782843, -122.436287521258) | |||
| 96302 | 96302 | 43704 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 279 Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43347 | 5993731.25212267 | 2089033.11150067 | 37.7157274860875 | -122.46360618846 | (37.7157274860875, -122.46360618846) | ||
| 136708 | 136708 | 213819 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 279 Bright St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993740.04713 | 2089048.21868 | 37.7157694735569 | -122.46357688488101 | (37.7157694735569, -122.463576884881) | |||
| 87874 | 87874 | 43705 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 283 Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43348 | 5993731.55292772 | 2089058.73633294 | 37.7157978630843 | -122.463607007411 | (37.7157978630843, -122.463607007411) | ||
| 129983 | 129983 | 213818 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 283 Bright St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993740.2865699995 | 2089076.61519 | 37.715847457382104 | -122.463578116946 | (37.7158474573821, -122.463578116946) | |||
| 57091 | 57091 | 179247 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 353 Prague St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6003781.052759999 | 2089121.49913 | 37.7165441288874 | -122.42887576852199 | (37.7165441288874, -122.428875768522) | |||
| 184857 | 184857 | 213807 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 235 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992444.29236 | 2089435.87285 | 37.7167591325169 | -122.46808375276501 | (37.7167591325169, -122.468083752765) | |||
| 161665 | 161665 | 213800 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 114 Majestic Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997059.55329 | 2089349.83232 | 37.7167883433744 | -122.452124952113 | (37.7167883433744, -122.452124952113) | |||
| 76251 | 76251 | 213799 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 114 Majestic Ave | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5997066.26777 | 2089358.12222 | 37.7168114901382 | -122.452102341364 | (37.7168114901382, -122.452102341364) | |||
| 132573 | 132573 | 213798 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 114 Majestic Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997074.19184 | 2089369.0687 | 37.716842000536296 | -122.45207574122601 | (37.7168420005363, -122.452075741226) | |||
| 114301 | 114301 | 97408 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201@Majestic Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43358 | 5997066.9 | 2089403.7 | 37.7169366723432 | -122.452103442674 | (37.7169366723432, -122.452103442674) | ||||
| 114851 | 114851 | 97407 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201@Majestic Lakeview Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43358 | 5997066.9 | 2089403.7 | 37.7169366723432 | -122.452103442674 | (37.7169366723432, -122.452103442674) |
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");