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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51449 | 51449 | 179241 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 736 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 5998977.898569999 | 2090313.82891 | 37.7195449597169 | -122.44556348228599 | (37.7195449597169, -122.445563482286) | |||
| 62592 | 62592 | 248217 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 68 Fair Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6007016.13375 | 2099427.55153 | 37.7450248801967 | -122.418424042861 | (37.7450248801967, -122.418424042861) | |||
| 74262 | 74262 | 248215 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 68 Fair Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6006947.08034 | 2099459.96671 | 37.7451099974421 | -122.418665116019 | (37.7451099974421, -122.418665116019) | |||
| 134719 | 134719 | 248218 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 68 Fair Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6007026.57203 | 2099414.74402 | 37.744990301261 | -122.418387041131 | (37.744990301261, -122.418387041131) | |||
| 147630 | 147630 | 248216 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 68 Fair Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6006985.57917 | 2099439.80265 | 37.7450567989249 | -122.41853056393299 | (37.7450567989249, -122.418530563933) | |||
| 157167 | 157167 | 179260 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 498 Capistrano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6000796.69928 | 2092081.07254 | 37.7245010785535 | -122.439403176636 | (37.7245010785535, -122.439403176636) | |||
| 169903 | 169903 | 179261 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 498 Capistrano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6000794.18444 | 2092068.4744799999 | 37.7244663440343 | -122.43941096744899 | (37.7244663440343, -122.439410967449) | |||
| 24905 | 24905 | 196689 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 502 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6015659.73754 | 2114184.09825 | 37.7860259507775 | -122.38956615096701 | (37.7860259507775, -122.389566150967) | |||
| 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) | |||
| 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) | |||
| 27450 | 27450 | 196678 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 501 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6015773.95432 | 2114161.0463099997 | 37.7859689877116 | -122.389169378158 | (37.7859689877116, -122.389169378158) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 43014 | 43014 | 196677 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 501 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6015787.05899 | 2114147.23937 | 37.7859318034411 | -122.389123074786 | (37.7859318034411, -122.389123074786) | |||
| 44483 | 44483 | 196693 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 502 Beale St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6015794.135319999 | 2114043.36166 | 37.7856469710674 | -122.38909133681801 | (37.7856469710674, -122.389091336818) | |||
| 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) | |||
| 46148 | 46148 | 196679 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 501 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015754.90373 | 2114179.70185 | 37.7860191554942 | -122.38923659171499 | (37.7860191554942, -122.389236591715) | |||
| 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) | |||
| 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) | |||
| 53471 | 53471 | 196691 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 502 Beale St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6015776.241230001 | 2114064.68842 | 37.785704537572705 | -122.38915473542 | (37.7857045375727, -122.38915473542) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 61596 | 61596 | 196681 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 501 Beale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6015727.426 | 2114208.63087 | 37.786097064682394 | -122.389333678928 | (37.7860970646824, -122.389333678928) | |||
| 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) | |||
| 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) | |||
| 132225 | 132225 | 196692 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 502 Beale St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6015791.08519 | 2114056.4297700003 | 37.7856826840566 | -122.389102802258 | (37.7856826840566, -122.389102802258) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 135815 | 135815 | 196680 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 501 Beale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6015740.935930001 | 2114193.52624 | 37.7860563397823 | -122.38928588264099 | (37.7860563397823, -122.389285882641) | |||
| 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) | |||
| 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) | |||
| 168995 | 168995 | 196690 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 502 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6015671.94224 | 2114170.65137 | 37.78598970540661 | -122.389522986194 | (37.7859897054066, -122.389522986194) | |||
| 179083 | 179083 | 196694 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 502 Beale St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6015915.20756 | 2113918.4239 | 37.785310630932 | -122.38866373346501 | (37.785310630932, -122.388663733465) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 23900 | 23900 | 136080 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2451 Steiner St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6002277.07488 | 2116237.64468 | 37.7909133434315 | -122.43601347444799 | (37.7909133434315, -122.436013474448) | |||
| 24996 | 24996 | 196826 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Merrimac St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014562.70735 | 2108760.4377599997 | 37.7710729141165 | -122.392981999126 | (37.7710729141165, -122.392981999126) | |||
| 25714 | 25714 | 196574 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 282 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6011149.22911 | 2111419.33677 | 37.7781834362492 | -122.404976637663 | (37.7781834362492, -122.404976637663) | |||
| 26344 | 26344 | 196782 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 209 Channel | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014472.23828 | 2109430.12451 | 37.7729066992149 | -122.393341808879 | (37.7729066992149, -122.393341808879) | |||
| 27776 | 27776 | 196809 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 33 El Dorado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014501.65713 | 2109262.9440200003 | 37.7724492932359 | -122.393228344136 | (37.7724492932359, -122.393228344136) | |||
| 30965 | 30965 | 196830 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 55 Merrimac St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014615.60719 | 2108793.6180000002 | 37.7711669580112 | -122.392801337013 | (37.7711669580112, -122.392801337013) | |||
| 32993 | 32993 | 196632 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 657 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6012241.95048 | 2114468.82602 | 37.7866176471408 | -122.40141085905 | (37.7866176471408, -122.40141085905) | |||
| 33073 | 33073 | 196833 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 55 Merrimac St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014609.63604 | 2108886.05645 | 37.7714204418376 | -122.39282845968799 | (37.7714204418376, -122.392828459688) | |||
| 34134 | 34134 | 196799 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 211 Channel | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014780.254869999 | 2109725.1043599998 | 37.7737337562402 | -122.392296969335 | (37.7737337562402, -122.392296969335) | |||
| 35909 | 35909 | 196842 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014094.5167 | 2109056.2947299997 | 37.771859253444795 | -122.394622219555 | (37.7718592534448, -122.394622219555) | |||
| 37816 | 37816 | 196835 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 55 Merrimac St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014606.40021 | 2108954.09695 | 37.77160708622179 | -122.39284441363998 | (37.7716070862218, -122.39284441364) | |||
| 37922 | 37922 | 196851 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014284.65568 | 2109239.1617 | 37.7723719344444 | -122.3939773139 | (37.7723719344444, -122.3939773139) | |||
| 38364 | 38364 | 196788 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 209 Channel | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014576.02451 | 2109530.42374 | 37.773187864171 | -122.39298981603999 | (37.773187864171, -122.39298981604) | |||
| 40647 | 40647 | 136070 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2322 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6002792.97811 | 2116354.63153 | 37.7912638541958 | -122.434236840357 | (37.7912638541958, -122.434236840357) | |||
| 41381 | 41381 | 239996 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 309 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6004165.10985 | 2101776.62568 | 37.751313984069206 | -122.42844977675699 | (37.7513139840692, -122.428449776757) | |||
| 43196 | 43196 | 239954 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3230 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6007346.18727 | 2105015.85455 | 37.7603876623689 | -122.417678790858 | (37.7603876623689, -122.417678790858) | |||
| 44005 | 44005 | 196734 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 701 05th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013745.07876 | 2109987.26543 | 37.774396056559205 | -122.395896206371 | (37.7743960565592, -122.395896206371) | |||
| 45835 | 45835 | 196813 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 33 El Dorado St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014445.95089 | 2109318.64473 | 37.772599140074895 | -122.393424937713 | (37.7725991400749, -122.393424937713) | |||
| 46252 | 46252 | 196789 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 209 Channel | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014598.537930001 | 2109550.2770700003 | 37.7732436275351 | -122.39291332781201 | (37.7732436275351, -122.392913327812) | |||
| 46326 | 46326 | 196780 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 209 Channel | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014439.83895 | 2109399.1411099997 | 37.772819825609496 | -122.39345171415 | (37.7728198256095, -122.39345171415) | |||
| 46866 | 46866 | 196841 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014074.004 | 2109042.91847 | 37.7718213847826 | -122.39469223806002 | (37.7718213847826, -122.39469223806) | |||
| 47524 | 47524 | 196849 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014250.97804 | 2109206.9561799997 | 37.772281633521 | -122.394091553888 | (37.772281633521, -122.394091553888) | |||
| 49669 | 49669 | 196785 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 209 Channel | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014521.93164 | 2109477.6464299997 | 37.7730399445582 | -122.39317323817801 | (37.7730399445582, -122.393173238178) | |||
| 50788 | 50788 | 196804 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 211 Channel | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014868.70221 | 2109810.10844 | 37.7739720693771 | -122.391996959086 | (37.7739720693771, -122.391996959086) | |||
| 50965 | 50965 | 196904 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 515 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6010247.778969999 | 2112023.6553700003 | 37.7797923215855 | -122.40813772768298 | (37.7797923215855, -122.408137727683) | |||
| 51837 | 51837 | 239938 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 365 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6006232.547809999 | 2101017.27522 | 37.7493457575224 | -122.421246413109 | (37.7493457575224, -122.421246413109) | |||
| 52018 | 52018 | 196807 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 33 El Dorado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014539.12289 | 2109222.91592 | 37.7723414663089 | -122.39309594412701 | (37.7723414663089, -122.393095944127) | |||
| 52940 | 52940 | 196816 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 30 El Dorado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014355.46436 | 2109208.21492 | 37.772290896541705 | -122.393730211682 | (37.7722908965417, -122.393730211682) | |||
| 53617 | 53617 | 196834 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 55 Merrimac St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014607.32823 | 2108931.5726799998 | 37.7715452911214 | -122.392839627459 | (37.7715452911214, -122.392839627459) | |||
| 53656 | 53656 | 196781 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 209 Channel | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014451.45871 | 2109411.09138 | 37.772853283988795 | -122.39341235621299 | (37.7728532839888, -122.393412356213) | |||
| 53878 | 53878 | 196800 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 211 Channel | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014798.00795 | 2109743.12989 | 37.773784236097995 | -122.392236819075 | (37.773784236098, -122.392236819075) | |||
| 53911 | 53911 | 196793 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 211 Channel | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014671.628219999 | 2109618.91734 | 37.773436157993004 | -122.39266529927 | (37.773436157993, -122.39266529927) | |||
| 55916 | 55916 | 196637 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 575 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6012807.875519999 | 2115007.55156 | 37.7881284209279 | -122.399490719228 | (37.7881284209279, -122.399490719228) | |||
| 56021 | 56021 | 196820 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 30 El Dorado St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014434.7702 | 2109131.61209 | 37.772084968887 | -122.393450521637 | (37.772084968887, -122.393450521637) | |||
| 59947 | 59947 | 196819 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 30 El Dorado St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014421.27301 | 2109141.30069 | 37.7721108216959 | -122.393497888041 | (37.7721108216959, -122.393497888041) | |||
| 61300 | 61300 | 239839 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 215 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6006806.365119999 | 2097865.68296 | 37.7407245281215 | -122.419038626033 | (37.7407245281215, -122.419038626033) | |||
| 62648 | 62648 | 196806 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 211 Channel | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014916.1836 | 2109854.46863 | 37.7740965085709 | -122.39183581408301 | (37.7740965085709, -122.391835814083) | |||
| 62776 | 62776 | 196846 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014189.07548 | 2109148.79942 | 37.7721185072929 | -122.394301609455 | (37.7721185072929, -122.394301609455) | |||
| 63297 | 63297 | 196797 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 211 Channel | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014744.34957 | 2109690.55757 | 37.7736369046569 | -122.39241875554501 | (37.7736369046569, -122.392418755545) | |||
| 63483 | 63483 | 196827 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Merrimac St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014561.24201 | 2108734.73312 | 37.77100225348 | -122.39298526908001 | (37.77100225348, -122.39298526908) | |||
| 63515 | 63515 | 196838 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014014.12331 | 2108979.4165 | 37.7716436931411 | -122.39489492276002 | (37.7716436931411, -122.39489492276) | |||
| 63563 | 63563 | 196831 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 55 Merrimac St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014614.72558 | 2108818.43764 | 37.7712350582719 | -122.392806123212 | (37.7712350582719, -122.392806123212) | |||
| 68194 | 68194 | 196634 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 575 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6012777.305 | 2114982.35129 | 37.7880575228893 | -122.399594718626 | (37.7880575228893, -122.399594718626) | |||
| 70115 | 70115 | 196850 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014268.35997 | 2109223.57854 | 37.7723282408876 | -122.394032591628 | (37.7723282408876, -122.394032591628) | |||
| 71052 | 71052 | 196898 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 132 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6010274.30322 | 2112218.62997 | 37.780329161097605 | -122.4080597223 | (37.7803291610976, -122.4080597223) | |||
| 71957 | 71957 | 196815 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 30 El Dorado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014339.53373 | 2109223.38685 | 37.77233167001071 | -122.39378637974801 | (37.7723316700107, -122.393786379748) | |||
| 75015 | 75015 | 240051 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 360 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6001771.64348 | 2103752.54269 | 37.756603645247004 | -122.436868077727 | (37.756603645247, -122.436868077727) | |||
| 75099 | 75099 | 196795 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 211 Channel | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014706.19873 | 2109651.13937 | 37.7735265524341 | -122.39254796833401 | (37.7735265524341, -122.392547968334) | |||
| 75126 | 75126 | 196848 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014231.50905 | 2109192.4978099996 | 37.7722408519556 | -122.394157886978 | (37.7722408519556, -122.394157886978) | |||
| 75329 | 75329 | 196837 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6013992.255369999 | 2108965.52306 | 37.7716043288955 | -122.394969592582 | (37.7716043288955, -122.394969592582) | |||
| 129889 | 129889 | 196733 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 701 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6013775.54248 | 2109956.07989 | 37.7743121228255 | -122.395788640256 | (37.7743121228255, -122.395788640256) | |||
| 130477 | 130477 | 196576 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 282 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6011180.61208 | 2111415.8824299998 | 37.778175705672204 | -122.40486782869301 | (37.7781757056722, -122.404867828693) | |||
| 131665 | 131665 | 196783 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 209 Channel | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014488.64812 | 2109445.3982599997 | 37.7729495492131 | -122.39328611386601 | (37.7729495492131, -122.393286113866) | |||
| 131847 | 131847 | 239953 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3224 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6007361.50136 | 2105016.10537 | 37.7603892128084 | -122.417625844174 | (37.7603892128084, -122.417625844174) | |||
| 133066 | 133066 | 196802 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 211 Channel | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014835.62577 | 2109777.4282400003 | 37.773880500412396 | -122.392109091073 | (37.7738805004124, -122.392109091073) | |||
| 133074 | 133074 | 196840 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014051.1897599995 | 2109021.1019 | 37.771760212905896 | -122.39476962654 | (37.7717602129059, -122.39476962654) | |||
| 134409 | 134409 | 196575 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 282 Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6011169.83524 | 2111407.3037 | 37.7781515480829 | -122.40490450574801 | (37.7781515480829, -122.404904505748) | |||
| 135284 | 135284 | 196811 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 33 El Dorado St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014469.99213 | 2109295.24269 | 37.7725362189995 | -122.39334013795201 | (37.7725362189995, -122.393340137952) | |||
| 136361 | 136361 | 196803 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 211 Channel | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014852.45129 | 2109792.0525 | 37.7739215895446 | -122.39205191127199 | (37.7739215895446, -122.392051911272) | |||
| 137212 | 137212 | 196847 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014214.062419999 | 2109172.69419 | 37.7721855058991 | -122.39421685013001 | (37.7721855058991, -122.39421685013) |
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");