trees

575 rows where qSpecies_id = 123 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
8545 241289 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 7 Sidewalk: Property side : Yard Tree Private 2     9 Width 9ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
19316 241287 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 6 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
54319 241288 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 16 Sidewalk: Property side : Yard Tree Private 2     8 Width 8ft   6011465.27105 2102063.55943 37.7525122416483 -122.403225029932 (37.7525122416483, -122.403225029932) 10 4 8 28859 19
73623 247601 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Tompkins Ave 6 Sidewalk: Property side : Yard Tree Private 2     10 Width 8ft   6009211.63365 2096404.06359 37.7368463915456 -122.410618895163 (37.7368463915456, -122.410618895163) 10 7 7 28859 2
137034 241359 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 707 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 8ft   6008539.21153 2104376.13627 37.7586982040894 -122.413507415061 (37.7586982040894, -122.413507415061) 2 4 7 28859 19
141436 247600 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Tompkins Ave 5 Sidewalk: Property side : Yard Tree Private 2     10 Width 8ft   6009197.59612 2096407.47189 37.7368549629719 -122.410667669902 (37.7368549629719, -122.410667669902) 10 7 7 28859 2
13557 220140 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 5 Sidewalk: Property side : Yard Tree Private 2     1 Width 7ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
32834 241370 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2877 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 7ft   6009531.75591 2102750.92335 37.7542914163323 -122.409959999651 (37.7542914163323, -122.409959999651) 2 4 7 28859 19
135886 241369 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2877 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 7ft   6009515.68514 2102750.48038 37.7542892993236 -122.410015545387 (37.7542892993236, -122.410015545387) 2 4 7 28859 19
4592 196983 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 6ft   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097) 10 3 8 58 1
16388 241286 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
16406 241355 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2970 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009659.81185 2101050.9246 37.7496307742409 -122.409397182327 (37.7496307742409, -122.409397182327) 2 4 7 28859 19
16583 241346 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 6ft   6009581.66758 2105919.15522 37.7629934624139 -122.410011039795 (37.7629934624139, -122.410011039795) 8 4 8 28859 19
18173 241284 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 6 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6011470.02474 2101959.91095 37.7522279111039 -122.403201300403 (37.7522279111039, -122.403201300403) 10 4 8 28859 19
22119 241283 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 5 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   6011469.09548 2101944.76887 37.7521862823701 -122.403203448894 (37.7521862823701, -122.403203448894) 10 4 8 28859 19
37335 241348 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009609.90256 2105923.09061 37.7630058505491 -122.409913662092 (37.7630058505491, -122.409913662092) 8 4 8 28859 19
42648 241281 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   6011465.9993 2101906.42682 37.7520808305785 -122.403211459137 (37.7520808305785, -122.403211459137) 10 4 8 28859 19
43080 241352 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009685.74216 2105928.63246 37.7630253172965 -122.409651748936 (37.7630253172965, -122.409651748936) 8 4 8 28859 19
74677 197008 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 503 Beale St 15 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6015819.96471 2114109.17282 37.7858291053701 -122.389006570307 (37.7858291053701, -122.389006570307) 6 2 9 28856 6
87499 197007 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 503 Beale St 14 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 6ft   6015822.85417 2114091.9182 37.7857818882589 -122.388995368366 (37.7857818882589, -122.388995368366) 6 2 9 28856 6
87745 241345 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009569.08803 2105916.84613 37.7629864171226 -122.410054385304 (37.7629864171226, -122.410054385304) 8 4 8 28859 19
91402 241353 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 9 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 6ft   6009702.25291 2105928.94008 37.7630270871447 -122.409594665358 (37.7630270871447, -122.409594665358) 8 4 8 28859 19
92727 241365 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1475 York St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 6ft   6010134.56863 2100721.5441 37.7487529567978 -122.407732226982 (37.7487529567978, -122.407732226982) 2 4 7 28859 19
93792 241347 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009595.63011 2105921.4482 37.7630005409651 -122.409962909868 (37.7630005409651, -122.409962909868) 8 4 8 28859 19
103971 241282 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 6ft   6011466.58759 2101921.66983 37.7521227174025 -122.403210496885 (37.7521227174025, -122.403210496885) 10 4 8 28859 19
112988 241350 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009654.92584 2105925.07195 37.7630138140553 -122.409758081181 (37.7630138140553, -122.409758081181) 8 4 8 28859 19
114516 241358 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1081 Treat Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 6ft   6008654.31002 2102275.26835 37.7529361586965 -122.412960810713 (37.7529361586965, -122.412960810713) 2 4 7 28859 19
122969 241351 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 6ft   6009671.13273 2105926.35263 37.7630182387282 -122.409702117253 (37.7630182387282, -122.409702117253) 8 4 8 28859 19
149145 197006 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 503 Beale St 9 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 6ft   6015876.10983 2114035.38454 37.7856296114719 -122.388807169036 (37.7856296114719, -122.388807169036) 6 2 9 28856 6
153220 241354 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 10 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 6ft   6009719.71418 2105928.26145 37.7630262022081 -122.409534224627 (37.7630262022081, -122.409534224627) 8 4 8 28859 19
160670 241349 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009630.95541 2105923.95007 37.7630093903014 -122.409840907855 (37.7630093903014, -122.409840907855) 8 4 8 28859 19
176314 196982 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 6ft   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097) 10 3 8 58 1
187496 241285 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 7 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6011473.17853 2101977.48291 37.75227633599 -122.403191629999 (37.75227633599, -122.403191629999) 10 4 8 28859 19
10563 220139 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
36145 241371 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2865 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6009580.01982 2102754.75587 37.7543046444459 -122.40979336069 (37.7543046444459, -122.40979336069) 2 4 7 28859 19
62748 196988 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 8 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   6011818.89895 2100809.64818 37.7490890172439 -122.401913980245 (37.7490890172439, -122.401913980245) 10 3 8 58 1
88879 241357 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1081 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   6008659.53051 2102232.08888 37.7528178906343 -122.412939704518 (37.7528178906343, -122.412939704518) 2 4 7 28859 19
102562 241293 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1300 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6011113.70254 2102244.24348 37.7529887195714 -122.404453537112 (37.7529887195714, -122.404453537112) 10 4 8 28859 19
103612 241364 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 826 York St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   6009889.67634 2104361.42581 37.7587335483391 -122.408835831807 (37.7587335483391, -122.408835831807) 2 4 7 28859 19
111720 196987 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 7 Sidewalk: Property side : Yard Tree Private 2     7 Width 5ft   6011820.27046 2100794.29001 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805) 10 3 8 58 1
141990 196989 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 8 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   6011818.89895 2100809.64818 37.7490890172439 -122.401913980245 (37.7490890172439, -122.401913980245) 10 3 8 58 1
146245 196984 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 6 Sidewalk: Property side : Yard Tree Private 2     8 Width 5ft   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295) 10 3 8 58 1
168607 196986 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 7 Sidewalk: Property side : Yard Tree Private 2     7 Width 5ft   6011820.27046 2100794.29001 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805) 10 3 8 58 1
170158 196985 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 6 Sidewalk: Property side : Yard Tree Private 2     8 Width 5ft   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295) 10 3 8 58 1
4053 196973 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Pennsylvania Ave 11 Sidewalk: Curb side : Cutout Tree Private 2   11/04/2019 12:00:00 AM 3 Width 4ft   6014457.83967 2102608.37301 37.7541748588033 -122.392914253189 (37.7541748588033, -122.392914253189) 10 3 8 28856 29
5120 197001 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 16 : Tree Private 2     9 Width 4ft   6013598.90827 2100122.82985 37.7473023413409 -122.395710528743 (37.7473023413409, -122.395710528743) 10 3 8 58 1
11064 196994 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 7 : Tree Private 2     7 Width 4ft   6013884.28274 2100137.93009 37.7473596740254 -122.394724774624 (37.7473596740254, -122.394724774624) 10 3 8 58 1
11610 241384 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008146.34247 2105906.05304 37.7628769363446 -122.414974425147 (37.7628769363446, -122.414974425147) 8 4 7 28859 19
20599 196997 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 11 : Tree Private 2     7 Width 4ft   6013762.67186 2100131.60985 37.7473355578075 -122.395144856947 (37.7473355578075, -122.395144856947) 10 3 8 58 1
21871 246838 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 399 Broderick St 1 : Tree Private 2     5 Width 4ft   6001188.47767 2109990.61312 37.7736986862745 -122.439331993472 (37.7736986862745, -122.439331993472) 15 5 11 29492 10
46530 136183 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1100 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6006523.02231 2120459.93681 37.8027469916359 -122.421622667864 (37.8027469916359, -122.421622667864) 5 9 1 28858 32
53461 196972 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Pennsylvania Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6014458.90845 2102627.41024 37.7542271903342 -122.392911888877 (37.7542271903342, -122.392911888877) 10 3 8 28856 29
70671 196993 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 6 : Tree Private 2     7 Width 4ft   6013912.09606 2100139.02388 37.7473642236913 -122.394628673985 (37.7473642236913, -122.394628673985) 10 3 8 58 1
71899 136184 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1100 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6006503.30451 2120455.88239 37.8027347473741 -122.421690613452 (37.8027347473741, -122.421690613452) 5 9 1 28858 32
88076 196990 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 1 : Tree Private 2     6 Width 4ft   6014143.12746 2100151.41021 37.7474110756645 -122.393830644379 (37.7474110756645, -122.393830644379) 10 3 8 58 1
92182 196991 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 2 : Tree Private 2     5 Width 4ft   6014086.84637 2100149.18925 37.7474018495283 -122.394025106589 (37.7474018495283, -122.394025106589) 10 3 8 58 1
97589 196999 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 14 : Tree Private 2     4 Width 4ft   6013629.21679 2100123.8728 37.7473068910098 -122.395605796394 (37.7473068910098, -122.395605796394) 10 3 8 58 1
104412 119966 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 524 28th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5987215.94672 2112352.18936 37.7793778617147 -122.487838060827 (37.7793778617147, -122.487838060827) 11 6 2 55 26
105683 241297 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1534 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007142.6566 2107359.78421 37.7668120908263 -122.418548923599 (37.7668120908263, -122.418548923599) 8 4 7 28853 19
106021 136178 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2400 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6001367.93231 2119047.53981 37.798576891075 -122.439360561339 (37.798576891075, -122.439360561339) 13 9 1 57 17
111775 241385 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6008146.20784 2105935.07496 37.7629566162671 -122.41497694503 (37.7629566162671, -122.41497694503) 8 4 7 28859 19
121622 197000 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 15 : Tree Private 2     6 Width 4ft   6013614.06576 2100123.51682 37.7473050707808 -122.395658162994 (37.7473050707808, -122.395658162994) 10 3 8 58 1
123616 241386 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008144.96622 2105963.39406 37.763034304202 -122.414983243884 (37.763034304202, -122.414983243884) 8 4 7 28859 19
124135 196995 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 8 : Tree Private 2     8 Width 4ft   6013853.97089 2100136.72086 37.7473546683845 -122.394829506973 (37.7473546683845, -122.394829506973) 10 3 8 58 1
125452 196979 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1551 20th St 2 : Tree Private 2     5 Width 4ft   6013315.21298 2104723.80911 37.7599198521353 -122.397014079838 (37.7599198521353, -122.397014079838) 10 3 8 28856 29
133550 241356 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3041 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6009354.55363 2100986.01535 37.749435439707 -122.410448197535 (37.749435439707, -122.410448197535) 2 4 7 28859 19
143289 241382 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008151.18943 2105840.29781 37.762696660032 -122.414953006889 (37.762696660032, -122.414953006889) 8 4 7 28859 19
148213 136179 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2400 Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6001333.81043 2119043.17386 37.7985629614603 -122.439478320365 (37.7985629614603, -122.439478320365) 13 9 1 57 17
148421 196998 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 13 : Tree Private 2     5 Width 4ft   6013702.50003 2100126.86267 37.7473191766464 -122.395352595851 (37.7473191766464, -122.395352595851) 10 3 8 58 1
157100 122016 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1633 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5990486.56458 2110588.66917 37.7747259547528 -122.476394881461 (37.7747259547528, -122.476394881461) 11 6 2 55 26
160886 196978 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1551 20th St 1 : Tree Private 2     6 Width 4ft   6013296.03231 2104723.49575 37.7599179239891 -122.397080394946 (37.7599179239891, -122.397080394946) 10 3 8 28856 29
165115 241383 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008148.21617 2105873.00555 37.7627863008585 -122.414965605482 (37.7627863008585, -122.414965605482) 8 4 7 28859 19
180734 241381 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6008153.50864 2105811.23118 37.7626169800981 -122.414942928177 (37.7626169800981, -122.414942928177) 8 4 7 28859 19
184445 196996 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 10 : Tree Private 2     8 Width 4ft   6013793.66265 2100133.46781 37.7473423827584 -122.395037822335 (37.7473423827584, -122.395037822335) 10 3 8 58 1
190579 241272 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 67 Webster St 1 : Tree Private 2     13 Width 4ft   6004275.92505 2108860.93687 37.7707720854826 -122.428571490982 (37.7707720854826, -122.428571490982) 7 9 11 29492 10
193907 196992 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 5 : Tree Private 2     7 Width 4ft   6013942.24849 2100140.56785 37.7473701394162 -122.394524516312 (37.7473701394162, -122.394524516312) 10 3 8 58 1
1297 241324 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 490 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/16/2019 12:00:00 AM 3 Width 3ft   6007395.81182 2106861.74234 37.765458833278 -122.417637995807 (37.765458833278, -122.417637995807) 8 4 7 28853 19
2223 241387 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 43 Whitney St 1 Sidewalk: Curb side : Cutout Tree DPW 1     4 Width 3ft   6004298.90777 2098020.68858 37.7410086185538 -122.42771950655 (37.7410086185538, -122.42771950655) 2 7 5 63 7
5764 241323 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 490 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/16/2019 12:00:00 AM 3 Width 3ft   6007394.41265 2106888.07859 37.7655310677289 -122.417644702035 (37.7655310677289, -122.417644702035) 8 4 7 28853 19
7828 196969 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 500 18th St 7 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6015866.24342 2105844.60301 37.763138987107 -122.388269449981 (37.763138987107, -122.388269449981) 14 3 8 28856 29
9715 196963 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 500 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6015947.26389 2105849.11258 37.7631558583726 -122.387989539601 (37.7631558583726, -122.387989539601) 14 3 8 28856 29
15698 241342 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2122 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009546.72381 2104789.44467 37.7598895755605 -122.410052140597 (37.7598895755605, -122.410052140597) 2 4 7 28859 19
16220 179280 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 16 Hale St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010456.33755 2094955.50587 37.7329386663832 -122.406213356571 (37.7329386663832, -122.406213356571) 10 3 7 309 28
20176 196977 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 209 Mississippi St 6 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6014040.95878 2106120.30389 37.7637946944947 -122.394601850808 (37.7637946944947, -122.394601850808) 14 3 8 28856 29
20202 136176 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2134 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002833.9768 2118210.69092 37.7963624418193 -122.434227733841 (37.7963624418193, -122.434227733841) 13 9 1 57 17
21100 241341 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2701 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009762.27519 2105459.58065 37.7617416960496 -122.409353942929 (37.7617416960496, -122.409353942929) 2 4 8 28859 19
22095 241295 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1350 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007154.42592 2107655.79566 37.7676255312226 -122.418529207767 (37.7676255312226, -122.418529207767) 8 4 7 28853 19
22157 197002 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2251 Silver Ave 3 : Tree Private 2     6 Width 3ft   6012830.37736 2096288.90355 37.7367324078692 -122.398099143384 (37.7367324078692, -122.398099143384) 10 3 8 58 1
25076 241291 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1225 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011156.6405 2102469.67171 37.7536100953402 -122.404320914102 (37.7536100953402, -122.404320914102) 10 4 8 28859 19
25956 241315 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 754 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007487.69135 2105254.04954 37.7610496524471 -122.417206271746 (37.7610496524471, -122.417206271746) 2 4 7 28859 19
30264 241366 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1399 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6010111.5288 2101104.25474 37.7498025060946 -122.40783888207 (37.7498025060946, -122.40783888207) 2 4 7 28859 19
31202 246856 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 425 Divisadero St 1 : Tree Private 2     4 Width 3ft   6001680.71036 2109929.19364 37.773558043107 -122.437624887779 (37.773558043107, -122.437624887779) 15 5 11 29492 10
39352 136186 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 800 Powell St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6010043.14101 2116645.97985 37.7924726608324 -122.40917192557 (37.7924726608324, -122.40917192557) 3 1 10 28857 4
42098 241379 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3702 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008438.87775 2097614.97452 37.7401279331501 -122.413376271417 (37.7401279331501, -122.413376271417) 2 7 7 28859 2
42736 241305 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 697 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 Width 3ft   6007530.22491 2105637.84626 37.7621058621135 -122.417086361543 (37.7621058621135, -122.417086361543) 8 4 7 28859 19
48378 213853 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 339 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5996569.29854 2106950.59972 37.7650876471008 -122.455090641935 (37.7650876471008, -122.455090641935) 15 5 11 29492 12
50595 241318 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 280 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007336.81249 2108065.49507 37.7687607355409 -122.417927400355 (37.7687607355409, -122.417927400355) 8 4 7 28853 19
52753 241325 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 425 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007441.87524 2107194.22963 37.766374357512 -122.417502238664 (37.766374357512, -122.417502238664) 8 4 7 28853 19
52926 241317 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 270 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007335.93397 2108086.9588 37.7688196204438 -122.417931960818 (37.7688196204438, -122.417931960818) 8 4 7 28853 19
54649 241274 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2616 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6010311.63301 2104008.02665 37.7577868194278 -122.407351591615 (37.7577868194278, -122.407351591615) 10 4 7 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);