Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 624 | 624 | 70356 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1912 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 5 | 6006535.5562 | 2117410.9094 | 37.7943758388735 | -122.42136264060801 | (37.7943758388735, -122.421362640608) | ||
| 735 | 735 | 24812 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2425 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1996 12:00:00 AM | 5 | 3X3 | 6002709.02465 | 2116620.06864 | 37.7919879109555 | -122.434546304291 | (37.7919879109555, -122.434546304291) | ||
| 1422 | 1422 | 196745 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1201X 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2002 12:00:00 AM | 5 | Width 3ft | Permit Number 45465 | 6012738.02923 | 2107105.72844 | 37.7664279283277 | -122.399177491654 | (37.7664279283277, -122.399177491654) | |
| 2197 | 2197 | 24571 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2252 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1996 12:00:00 AM | 5 | 3X3 | 6002831.271980001 | 2116073.36845 | 37.7904937512412 | -122.434084229923 | (37.7904937512412, -122.434084229923) | ||
| 3211 | 3211 | 239952 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2900 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | 5 | Width 3ft | Permit Number 42822 | 6008805.731790001 | 2103926.75101 | 37.7574792557704 | -122.412553896246 | (37.7574792557704, -122.412553896246) | |
| 3905 | 3905 | 196577 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 365x 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011360.0 | 2111196.0 | 37.7775819849571 | -122.404231777509 | (37.7775819849571, -122.404231777509) | |||
| 6148 | 6148 | 24577 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2100 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1996 12:00:00 AM | 5 | 3X3 | 6002897.54633 | 2115611.42006 | 37.7892291200774 | -122.433821893176 | (37.7892291200774, -122.433821893176) | ||
| 16867 | 16867 | 84834 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1011 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 5 | Permit No. 49303 | 6010439.60599 | 2111868.75172 | 37.7793777314294 | -122.40746318667 | (37.7793777314294, -122.40746318667) | ||
| 23007 | 23007 | 22285 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4800 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6014905.6735 | 2095512.4095 | 37.7347156849635 | -122.390869630779 | (37.7347156849635, -122.390869630779) | ||||
| 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) | |||
| 24463 | 24463 | 238876 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1491 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007784.85752 | 2101047.0876700003 | 37.7495150081106 | -122.415880587419 | (37.7495150081106, -122.415880587419) | |||
| 24909 | 24909 | 196684 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 5 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015730.46543 | 2114303.5098599996 | 37.7863577493517 | -122.389329791131 | (37.7863577493517, -122.389329791131) | |||
| 27913 | 27913 | 196955 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1554 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015618.84002 | 2096830.91128 | 37.738375568171705 | -122.38849595054701 | (37.7383755681717, -122.388495950547) | |||
| 28358 | 28358 | 196700 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 65 Colin P Kelly Jr St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015488.795 | 2112563.5723900003 | 37.7815668737626 | -122.39004432408599 | (37.7815668737626, -122.390044324086) | |||
| 29995 | 29995 | 50578 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2245 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49800 | 6003975.63649 | 2116622.71373 | 37.79206699374971 | -122.430164007776 | (37.7920669937497, -122.430164007776) | |
| 30511 | 30511 | 239972 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4200 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001826.476430001 | 2101785.40484 | 37.75120547275579 | -122.436537651507 | (37.7512054727558, -122.436537651507) | |||
| 30829 | 30829 | 238903 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 815 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007571.757780001 | 2104901.12224 | 37.7600853247075 | -122.416890516207 | (37.7600853247075, -122.416890516207) | |||
| 32438 | 32438 | 200818 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4546 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015120.7734 | 2096250.4975 | 37.7367542570299 | -122.39017749840599 | (37.7367542570299, -122.390177498406) | |||
| 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) | |||
| 33382 | 33382 | 213811 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 543 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993242.44119 | 2090786.21501 | 37.72051290812121 | -122.46542300596501 | (37.7205129081212, -122.465423005965) | |||
| 33504 | 33504 | 238917 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1200 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007632.60235 | 2102619.43354 | 37.753823752685705 | -122.416518455865 | (37.7538237526857, -122.416518455865) | |||
| 33939 | 33939 | 200639 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4699 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015071.4996 | 2095853.5555 | 37.7356616021026 | -122.390320135783 | (37.7356616021026, -122.390320135783) | |||
| 34021 | 34021 | 239929 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 400 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007196.94954 | 2104930.89202 | 37.7601459758787 | -122.41818891238199 | (37.7601459758787, -122.418188912382) | |||
| 34833 | 34833 | 238904 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 809 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007570.3109 | 2104924.90534 | 37.760150546224295 | -122.416897205338 | (37.7601505462243, -122.416897205338) | |||
| 35049 | 35049 | 200904 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4434 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015202.5255 | 2096515.6301 | 37.737486791139 | -122.38991335798 | (37.737486791139, -122.38991335798) | |||
| 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) | |||
| 35937 | 35937 | 240052 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 390 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002087.59987 | 2103628.6569 | 37.756281437061794 | -122.435766525125 | (37.7562814370618, -122.435766525125) | |||
| 36309 | 36309 | 238949 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 601 Alabama St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009021.3896699995 | 2105195.78397 | 37.760975832475296 | -122.4118977365 | (37.7609758324753, -122.4118977365) | |||
| 36385 | 36385 | 136071 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2408 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6002762.77731 | 2116555.7447900004 | 37.791814345406706 | -122.434355719034 | (37.7918143454067, -122.434355719034) | |||
| 36803 | 36803 | 239756 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4125 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002357.60672 | 2101772.74522 | 37.751200879940704 | -122.434700042488 | (37.7512008799407, -122.434700042488) | |||
| 37057 | 37057 | 84835 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1011 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 5 | Permit No. 49303 | 6010454.595980001 | 2111882.01804 | 37.7794149966465 | -122.40741226527399 | (37.7794149966465, -122.407412265274) | ||
| 38033 | 38033 | 239951 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3280 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006491.37088 | 2103215.34867 | 37.7553957514279 | -122.420507401522 | (37.7553957514279, -122.420507401522) | |||
| 38201 | 38201 | 43525 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1664 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2000 12:00:00 AM | 5 | Permit Number 43200 | 5999846.7791 | 2110578.6022 | 37.775236710967 | -122.444015378674 | (37.775236710967, -122.444015378674) | ||
| 38389 | 38389 | 240118 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 579 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002970.18491 | 2108878.26351 | 37.7707456796077 | -122.433089305431 | (37.7707456796077, -122.433089305431) | |||
| 39225 | 39225 | 239124 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 161 Newman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007369.11931 | 2096772.41825 | 37.7377543389925 | -122.417015387067 | (37.7377543389925, -122.417015387067) | |||
| 41131 | 41131 | 123329 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 753 04th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994716.769280001 | 2110453.4308599997 | 37.7745990479225 | -122.46175204141399 | (37.7745990479225, -122.461752041414) | |||
| 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) | |||
| 41514 | 41514 | 240089 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4725 18th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5999807.85553 | 2105040.70574 | 37.7600288158025 | -122.44375208219 | (37.7600288158025, -122.44375208219) | |||
| 41862 | 41862 | 138868 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 400 OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005576.9955 | 2110701.2449 | 37.77589867067179 | -122.424201961303 | (37.7758986706718, -122.424201961303) | |||
| 42106 | 42106 | 200686 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4705 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014997.3019 | 2095604.0315 | 37.734972343996894 | -122.390559237601 | (37.7349723439969, -122.390559237601) | |||
| 43114 | 43114 | 200687 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4705 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015001.1492 | 2095618.871 | 37.7350133036799 | -122.39054697260299 | (37.7350133036799, -122.390546972603) | |||
| 43217 | 43217 | 239122 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 165 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007432.2789900005 | 2096764.65731 | 37.7377365818786 | -122.416796463312 | (37.7377365818786, -122.416796463312) | |||
| 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) | |||
| 45845 | 45845 | 182751 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1799 30th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986864.4626 | 2103079.1022 | 37.753896033260396 | -122.48837229934601 | (37.7538960332604, -122.488372299346) | |||
| 47091 | 47091 | 238875 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1499 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007788.0752 | 2100970.31178 | 37.7493043797015 | -122.415864024627 | (37.7493043797015, -122.415864024627) | |||
| 47096 | 47096 | 239918 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1128 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009444.69761 | 2102597.65239 | 37.753865688972205 | -122.410250249564 | (37.7538656889722, -122.410250249564) | |||
| 47501 | 47501 | 200737 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 5005 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014783.8279 | 2094883.0386 | 37.732980798996394 | -122.391246916267 | (37.7329807989964, -122.391246916267) | |||
| 47815 | 47815 | 136076 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2501 Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001468.15322 | 2116599.52865 | 37.7918609950398 | -122.438838246815 | (37.7918609950398, -122.438838246815) | |||
| 48763 | 48763 | 196944 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 99 12th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007258.22618 | 2109464.26228 | 37.7725969960897 | -122.41829841296499 | (37.7725969960897, -122.418298412965) | |||
| 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) | |||
| 49195 | 49195 | 240091 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 27 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002079.22664 | 2106210.86143 | 37.763371069731 | -122.435980245403 | (37.763371069731, -122.435980245403) | |||
| 49459 | 49459 | 239822 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 459 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007877.86373 | 2096695.5467400001 | 37.737571871947395 | -122.415250966677 | (37.7375718719474, -122.415250966677) | |||
| 50584 | 50584 | 238858 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1288 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008682.8920599995 | 2101066.7241700003 | 37.749619371747606 | -122.412776534224 | (37.7496193717476, -122.412776534224) | |||
| 50825 | 50825 | 196587 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 219 Dore St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009517.96758 | 2109174.60645 | 37.7719286109601 | -122.41046124311899 | (37.7719286109601, -122.410461243119) | |||
| 51390 | 51390 | 30772 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 650 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 5 | Permit Number 34651 | 6015119.06429 | 2112403.324 | 37.7811063552192 | -122.39131222069099 | (37.7811063552192, -122.391312220691) | |
| 53107 | 53107 | 200750 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 5099 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014760.935 | 2094799.3159999999 | 37.732749643215 | -122.391320213097 | (37.732749643215, -122.391320213097) | |||
| 54452 | 54452 | 213838 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997839.253880001 | 2096312.46068 | 37.7359507162569 | -122.449931439105 | (37.7359507162569, -122.449931439105) | |||
| 56241 | 56241 | 140924 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 151 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5996522.7314 | 2113355.9321 | 37.7826723470915 | -122.45571474796101 | (37.7826723470915, -122.455714747961) | |||
| 56770 | 56770 | 239994 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 333 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004167.87446 | 2101737.1491 | 37.7512057470475 | -122.42843740296999 | (37.7512057470475, -122.42843740297) | |||
| 57043 | 57043 | 240112 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 95 Saturn St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000090.42535 | 2105952.01065 | 37.762547146862204 | -122.442840252374 | (37.7625471468622, -122.442840252374) | |||
| 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) | |||
| 57828 | 57828 | 136068 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2311 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6002757.38982 | 2116271.99757 | 37.7910349425641 | -122.434354064289 | (37.7910349425641, -122.434354064289) | |||
| 58686 | 58686 | 240067 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 675 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002426.71696 | 2104319.1294400003 | 37.75819656583229 | -122.434643113601 | (37.7581965658323, -122.434643113601) | |||
| 60298 | 60298 | 196647 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 91 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013361.45364 | 2114377.17154 | 37.786428383895505 | -122.39753119271201 | (37.7864283838955, -122.397531192712) | |||
| 60537 | 60537 | 238910 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 884 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007527.591030001 | 2104523.25064 | 37.7590452920142 | -122.41701649411101 | (37.7590452920142, -122.417016494111) | |||
| 60599 | 60599 | 213797 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 67 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996487.46258 | 2090324.34968 | 37.7194313519583 | -122.454172723693 | (37.7194313519583, -122.454172723693) | |||
| 60801 | 60801 | 136123 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 151 Alice B Toklas Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006565.20687 | 2114077.13535 | 37.785223793281006 | -122.421023227451 | (37.785223793281, -122.421023227451) | |||
| 61168 | 61168 | 239755 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4131 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002327.757540001 | 2101770.26625 | 37.7511923786438 | -122.434803086796 | (37.7511923786438, -122.434803086796) | |||
| 61350 | 61350 | 141277 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 341 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998077.1027 | 2112573.1625 | 37.7806121460547 | -122.450280868806 | (37.7806121460547, -122.450280868806) | |||
| 62506 | 62506 | 238874 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1515 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007794.43679 | 2100852.13502 | 37.748980250554204 | -122.415833659 | (37.7489802505542, -122.415833659) | |||
| 62975 | 62975 | 142685 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2335 MASON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008872.4562 | 2121205.4097 | 37.8049260720114 | -122.413545158922 | (37.8049260720114, -122.413545158922) | |||
| 63039 | 63039 | 59759 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 351 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1981 12:00:00 AM | 5 | Permit Number 19197 | 6003911.2246 | 2091379.68793 | 37.722751987086 | -122.428586705712 | (37.722751987086, -122.428586705712) | ||
| 63253 | 63253 | 200828 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 5024 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014695.3185 | 2094829.1509999998 | 37.7328279221911 | -122.391549152699 | (37.7328279221911, -122.391549152699) | |||
| 63278 | 63278 | 47780 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2230 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 45556 | 6008949.7245 | 2120970.9742 | 37.8042867092291 | -122.41326117407101 | (37.8042867092291, -122.413261174071) | |
| 63330 | 63330 | 240069 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 235 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002090.070169999 | 2104494.79608 | 37.7586597868329 | -122.435819951153 | (37.7586597868329, -122.435819951153) | |||
| 64404 | 64404 | 238946 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 601 Alabama St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009024.20585 | 2105119.9651900004 | 37.7607678094011 | -122.41188263869302 | (37.7607678094011, -122.411882638693) | |||
| 64643 | 64643 | 239823 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 453 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007883.51576 | 2096771.36892 | 37.7377803806675 | -122.415236790653 | (37.7377803806675, -122.415236790653) | |||
| 65462 | 65462 | 239991 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3909 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003654.83495 | 2102422.60575 | 37.753058804636204 | -122.430260446578 | (37.7530588046362, -122.430260446578) | |||
| 65734 | 65734 | 69232 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 371 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | 5 | Permit Number 33286 | 6006088.9496 | 2111042.98864 | 37.7768659096682 | -122.42245526559401 | (37.7768659096682, -122.422455265594) | |
| 65761 | 65761 | 238992 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3629 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006051.36387 | 2100805.85011 | 37.748755016236295 | -122.421857935908 | (37.7487550162363, -122.421857935908) | |||
| 65968 | 65968 | 239851 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 197 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006470.7983 | 2098607.88807 | 37.7427435546605 | -122.420251555175 | (37.7427435546605, -122.420251555175) | |||
| 65974 | 65974 | 142899 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1590 POLK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6006539.0942 | 2117389.2392 | 37.794316537399 | -122.421348859061 | (37.794316537399, -122.421348859061) | |||
| 66369 | 66369 | 213801 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 25 Josiah Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5996904.0394 | 2089968.34068 | 37.718477713562 | -122.452707098549 | (37.718477713562, -122.452707098549) | |||
| 66388 | 66388 | 196771 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 545 08th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010917.75796 | 2109009.10487 | 37.7715525549262 | -122.40560758224701 | (37.7715525549262, -122.405607582247) | |||
| 66876 | 66876 | 196707 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 50 Colin P Kelly Jr St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015436.41724 | 2112559.83996 | 37.781553720277294 | -122.390225266791 | (37.7815537202773, -122.390225266791) | |||
| 67401 | 67401 | 239107 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 24 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6008123.10233 | 2100021.59375 | 37.746718241557495 | -122.41463836197599 | (37.7467182415575, -122.414638361976) | |||
| 67712 | 67712 | 82139 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 380 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50623 | 5991883.59134 | 2112911.44883 | 37.7811845951736 | -122.47173163881 | (37.7811845951736, -122.47173163881) | |
| 68040 | 68040 | 239849 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 193 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006477.57533 | 2098623.26669 | 37.74278616276379 | -122.42022921331899 | (37.7427861627638, -122.420229213319) | |||
| 68132 | 68132 | 239843 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 349 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006145.3816599995 | 2098012.02177 | 37.741089097975895 | -122.42133444954901 | (37.7410890979759, -122.421334449549) | |||
| 68762 | 68762 | 200641 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4699 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015083.0415 | 2095916.7609 | 37.7358357914796 | -122.39028464519 | (37.7358357914796, -122.39028464519) | |||
| 68857 | 68857 | 240054 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 390 Collingwood St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002091.16033 | 2103595.61886 | 37.75619092479 | -122.435751848174 | (37.75619092479, -122.435751848174) | |||
| 69101 | 69101 | 238890 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1245 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007714.29188 | 2102335.95562 | 37.7530499804841 | -122.416215878057 | (37.7530499804841, -122.416215878057) | |||
| 69147 | 69147 | 36158 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 124 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2011 12:00:00 AM | 5 | Permit Number 768284 | 5996572.4794 | 2113546.8019999997 | 37.7831992799989 | -122.455556442282 | (37.7831992799989, -122.455556442282) | |
| 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) | |||
| 71464 | 71464 | 239921 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 814 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007932.06599 | 2103164.3870599996 | 37.7553369078912 | -122.41552141798 | (37.7553369078912, -122.41552141798) | |||
| 72133 | 72133 | 238919 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1240 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007642.65123 | 2102428.61952 | 37.753300385921996 | -122.41647018925501 | (37.753300385922, -122.416470189255) | |||
| 72199 | 72199 | 200816 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4726 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014939.4147 | 2095631.5580000002 | 37.735044714597294 | -122.39076129880199 | (37.7350447145973, -122.390761298802) | |||
| 72246 | 72246 | 213767 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 25 Burnside Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6001267.03069 | 2096006.5243900002 | 37.7353062233869 | -122.438058363701 | (37.7353062233869, -122.438058363701) | |||
| 72262 | 72262 | 196713 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 64 Townsend St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015474.7402800005 | 2112394.5786 | 37.781102075353395 | -122.390081137831 | (37.7811020753534, -122.390081137831) | |||
| 72546 | 72546 | 239850 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 193 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006485.42198 | 2098635.21704 | 37.742819417873 | -122.42020292972799 | (37.742819417873, -122.420202929728) |
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");