195 rows where Supervisor Districts = 10 and qSpecies_id = 54 sorted by TreeID

View and edit SQL

Supervisor Districts

  • 10 · 195
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)
186082 108616 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 289 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6010459.7673 2120958.2392 37.8043364033733 -122.408034626667 (37.8043364033733, -122.408034626667) 3 1 10 308 23
158367 115983 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 900 Kearny St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6011256.8768 2118034.0404 37.796351862759 -122.405070122367 (37.796351862759, -122.405070122367) 3 1 10 308 4
153254 115984 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 900 Kearny St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6011255.4785 2118051.2862 37.7963991373929 -122.405076175742 (37.7963991373929, -122.405076175742) 3 1 10 308 4
76001 115985 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 900 Kearny St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6011253.148 2118063.4049 37.7964322821358 -122.405085093558 (37.7964322821358, -122.405085093558) 3 1 10 308 4
191640 12985 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 306 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 3X3   6010818.9339 2120706.9936 37.8036666476299 -122.406773977327 (37.8036666476299, -122.406773977327) 3 1 10 308 23
66267 12998 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 348 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 3X3   6010660.6396 2120687.9769 37.8036055743317 -122.407320424126 (37.8036055743317, -122.407320424126) 3 1 10 308 23
67375 13020 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 423 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 3X3   6010295.8571 2120595.8738 37.8033322591341 -122.40857627636 (37.8033322591341, -122.40857627636) 3 1 10 308 23
122435 13021 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 423 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3   6010315.0722 2120598.0088 37.803339197434 -122.408509932207 (37.803339197434, -122.408509932207) 3 1 10 308 23
184369 13052 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 557 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6009686.1191 2120512.8313 37.8030700779734 -122.410680437216 (37.8030700779734, -122.410680437216) 3 1 10 308 23
184353 142464 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1456 Kearny St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6010990.4041 2119956.0656 37.8016143761567 -122.406127656852 (37.8016143761567, -122.406127656852) 3 1 10 308 23
173263 142465 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1457 Kearny St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6010961.892 2119955.2575 37.8016105625065 -122.406226265244 (37.8016105625065, -122.406226265244) 3 1 10 308 23
116619 142466 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1454 Kearny St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6010993.6362 2119929.285 37.8015410239646 -122.406114584446 (37.8015410239646, -122.406114584446) 3 1 10 308 23
8143 142468 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1455 Kearny St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6010964.6624 2119932.1708 37.8015473270449 -122.406215050843 (37.8015473270449, -122.406215050843) 3 1 10 308 23
7583 142470 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1443 Kearny St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6010970.8958 2119887.8443 37.8014259659921 -122.406190355577 (37.8014259659921, -122.406190355577) 3 1 10 308 23
102869 142471 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1439 Kearny St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6010974.128 2119867.5279 37.8013703629213 -122.406177738482 (37.8013703629213, -122.406177738482) 3 1 10 308 23
50609 142472 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1429 Kearny St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6010978.9762 2119829.6657 37.8012666737636 -122.406158292447 (37.8012666737636, -122.406158292447) 3 1 10 308 23
83261 142473 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1429 Kearny St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6010981.054 2119812.8124 37.8012205149436 -122.406149914275 (37.8012205149436, -122.406149914275) 3 1 10 308 23
131870 142488 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 651 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6009640.0611 2119612.4195 37.8005951877983 -122.410776194648 (37.8005951877983, -122.410776194648) 3 1 10 308 4
98101 142489 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 651 COLUMBUS AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009636.3672 2119608.7257 37.8005848384211 -122.410788716085 (37.8005848384211, -122.410788716085) 3 1 10 308 4
118494 142490 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 651 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6009644.6785 2119609.6491 37.8005878398576 -122.41076002073 (37.8005878398576, -122.41076002073) 3 1 10 308 4
44783 142491 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 651 COLUMBUS AVE 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6009641.4463 2119604.1083 37.8005724449635 -122.410770813978 (37.8005724449635, -122.410770813978) 3 1 10 308 4
28001 142492 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 651 COLUMBUS AVE 5 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6009649.7576 2119605.0318 37.8005754466702 -122.410742118634 (37.8005754466702, -122.410742118634) 3 1 10 308 4
146897 142493 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 651 COLUMBUS AVE 6 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6009645.6019 2119599.491 37.8005599999984 -122.410756107582 (37.8005599999984, -122.410756107582) 3 1 10 308 4
21231 142496 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 523 UNION ST 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6010454.4069 2119574.2954 37.8005361345001 -122.40795552252 (37.8005361345001, -122.40795552252) 3 1 10 308 23
128630 142499 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 521 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6009964.3012 2119317.683 37.7998040885057 -122.40963337214 (37.7998040885057, -122.40963337214) 3 1 10 308 4
39745 142504 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 610 Vallejo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/29/1999 12:00:00 AM 12 Width 0ft   6010596.4955 2118942.3174 37.7988088315184 -122.407419256939 (37.7988088315184, -122.407419256939) 3 1 10 308 23
45570 142505 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 620 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2014 12:00:00 AM 22 Width 0ft Permit Number 774306 6010566.6807 2118940.2612 37.7988015168915 -122.407522281284 (37.7988015168915, -122.407522281284) 3 1 10 308 23
77347 142506 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1223 KEARNY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6011074.9884 2119120.527 37.7993249217375 -122.405776067035 (37.7993249217375, -122.405776067035) 3 1 10 308 23
102293 142508 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 358 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6010579.9175 2118839.2508 37.798524907896 -122.407469352253 (37.798524907896, -122.407469352253) 3 1 10 308 23
109050 142510 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 401 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6010260.5653 2119044.3559 37.7990701962332 -122.408588891831 (37.7990701962332, -122.408588891831) 3 1 10 308 4
134953 142512 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 427 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree DPW 1     13 Width 0ft   6010331.5039 2118981.6421 37.7989019721603 -122.408338993416 (37.7989019721603, -122.408338993416) 3 1 10 308 4
142221 142513 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 419 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 Width 0ft   6010363.8889 2118953.3694 37.7988261556788 -122.408224935007 (37.7988261556788, -122.408224935007) 3 1 10 308 4
52068 142514 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 624 VALLEJO ST 4 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2014 12:00:00 AM 20 Width 0ft Permit Number 774306 6010535.3238 2118936.1488 37.7987884700296 -122.407630496745 (37.7987884700296, -122.407630496745) 3 1 10 308 23
138054 142515 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 624 VALLEJO ST 5 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2014 12:00:00 AM 21 Width 0ft Permit Number 774306 6010502.9388 2118931.0084 37.7987725428783 -122.407742197219 (37.7987725428783, -122.407742197219) 3 1 10 308 23
48538 142516 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1205 KEARNY ST 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6011083.7416 2119059.5323 37.7991579346332 -122.405741479105 (37.7991579346332, -122.405741479105) 3 1 10 308 23
184765 142517 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 402 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     19 Width 0ft   6010454.8754 2118953.3694 37.798831249998 -122.407910090593 (37.798831249998, -122.407910090593) 3 1 10 308 23
42890 142518 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 420 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   6010399.3582 2119003.2321 37.7989650524767 -122.408105717547 (37.7989650524767, -122.408105717547) 3 1 10 308 23
39581 142525 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 301 FRANCISCO ST 15 Sidewalk: Curb side : Cutout Tree SFUSD 4     23 Width 0ft   6009759.5801 2121214.59 37.8050010513122 -122.410475804946 (37.8050010513122, -122.410475804946) 3 1 10 308 23
34438 142561 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2145 POWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009379.1154 2121092.3828 37.8046441645077 -122.41178381072 (37.8046441645077, -122.41178381072) 3 1 10 308 23
170149 142562 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2145 POWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6009382.2185 2121078.4189 37.804605997205 -122.4117720848 (37.804605997205, -122.4117720848) 3 1 10 308 23
114205 142566 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2125 POWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6009390.752 2120983.7745 37.8043466060205 -122.41173586211 (37.8043466060205, -122.41173586211) 3 1 10 308 23
111305 142591 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008291.5451 2120841.4416 37.8038940717069 -122.41552968724 (37.8038940717069, -122.41552968724) 5 1 10 308 32
108538 142592 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6008300.8769 2120835.2204 37.803877514381 -122.415496953155 (37.803877514381, -122.415496953155) 5 1 10 308 32
50942 142593 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008314.0969 2120822.0003 37.8038419583694 -122.415450267897 (37.8038419583694, -122.415450267897) 5 1 10 308 32
139018 142594 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008329.6499 2120808.0026 37.8038043983711 -122.415395454094 (37.8038043983711, -122.415395454094) 5 1 10 308 32
94505 142595 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008339.7594 2120798.6708 37.8037793437918 -122.415359808453 (37.8037793437918, -122.415359808453) 5 1 10 308 32
31104 142596 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008359.2007 2120780.7848 37.8037313259866 -122.415291263605 (37.8037313259866, -122.415291263605) 5 1 10 308 32
127703 142597 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 8 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008368.5325 2120773.0083 37.8037104981311 -122.41525841948 (37.8037104981311, -122.41525841948) 5 1 10 308 32
153905 142598 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 9 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008376.309 2120765.2318 37.8036895828586 -122.415230957587 (37.8036895828586, -122.415230957587) 5 1 10 308 32
114293 142599 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 10 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6008384.0855 2120756.6777 37.8036665324855 -122.415203440632 (37.8036665324855, -122.415203440632) 5 1 10 308 32
168911 142600 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 11 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6008394.1949 2120748.9012 37.803645748305 -122.415167905628 (37.803645748305, -122.415167905628) 5 1 10 308 32
109992 142604 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 700 CHESTNUT ST 4 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6008306.3204 2120712.3516 37.8035404535195 -122.415469411535 (37.8035404535195, -122.415469411535) 5 1 10 308 32
47497 142605 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 700 CHESTNUT ST 5 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6008282.9909 2120710.7963 37.8035348717489 -122.415550034395 (37.8035348717489, -122.415550034395) 5 1 10 308 32
153779 142620 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1 Scotland St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6009140.6951 2120065.1504 37.8018102626301 -122.412536232083 (37.8018102626301, -122.412536232083) 3 1 10 308 4
184752 142629 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 725 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6009330.2372 2119895.0012 37.8013537106151 -122.41186829545 (37.8013537106151, -122.41186829545) 3 1 10 308 4
121443 142630 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 707 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6009347.3214 2119879.3022 37.8013115634868 -122.411808066362 (37.8013115634868, -122.411808066362) 3 1 10 308 4
41625 142631 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 241 BAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6009683.097 2121540.8838 37.8058926846956 -122.410763542627 (37.8058926846956, -122.410763542627) 3 1 10 308 23
101324 142632 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 241 BAY ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6009699.071 2121543.9755 37.8059020693628 -122.410708480373 (37.8059020693628, -122.410708480373) 3 1 10 308 23
50284 142633 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 241 BAY ST 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6009714.0145 2121546.0367 37.8059085667329 -122.410656911507 (37.8059085667329, -122.410656911507) 3 1 10 308 23
37790 142634 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 241 BAY ST 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6009751.1154 2121551.1896 37.8059247953292 -122.410528881628 (37.8059247953292, -122.410528881628) 3 1 10 308 23
104792 142635 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 241 BAY ST 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6009773.7882 2121554.2814 37.8059345556962 -122.410450636982 (37.8059345556962, -122.410450636982) 3 1 10 308 23
6549 142706 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 567 BAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6008189.6261 2121340.372 37.8052582795068 -122.415917737693 (37.8052582795068, -122.415917737693) 5 1 10 308 23
147078 142746 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 661 LOMBARD ST 12 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 0ft   6009447.7459 2120475.7434 37.8029548762002 -122.411502714696 (37.8029548762002, -122.411502714696) 3 1 10 308 23
159684 142820 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1754 POLK ST 2 Sidewalk: Curb side : Pot Tree Private 2     1 Width 0ft   6006598.3556 2116937.7026 37.7930800716409 -122.421111730561 (37.7930800716409, -122.421111730561) 13 9 10 28858 32
25242 142827 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1714 POLK ST 1 Sidewalk: Curb side : Pot Tree Private 2     5 Width 0ft   6006619.3625 2116773.8493 37.7926313555217 -122.421027406021 (37.7926313555217, -122.421027406021) 13 9 10 28858 32
114918 142918 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 509 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6010018.2099 2119266.553 37.7996667187629 -122.409443216757 (37.7996667187629, -122.409443216757) 3 1 10 308 4
128165 142920 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1339 KEARNY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6011019.5196 2119515.0732 37.800405147287 -122.405995819069 (37.800405147287, -122.405995819069) 3 1 10 308 23
49360 142923 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1249 KEARNY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6011057.7598 2119245.0173 37.7996657782982 -122.405844458331 (37.7996657782982, -122.405844458331) 3 1 10 308 23
67040 142933 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 502 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6011075.0739 2119008.1155 37.7990162718949 -122.405767848781 (37.7990162718949, -122.405767848781) 3 1 10 308 23
41482 142934 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1201 KEARNY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6011088.1877 2119032.3 37.7990834099948 -122.405724174807 (37.7990834099948, -122.405724174807) 3 1 10 308 23
90895 142938 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1160 BROADWAY 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6010744.0272 2118552.2837 37.7977461503426 -122.406881242638 (37.7977461503426, -122.406881242638) 3 1 10 308 4
42465 142940 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 318 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   6010703.4174 2118721.6624 37.7982089506036 -122.407033709348 (37.7982089506036, -122.407033709348) 3 1 10 308 23
148028 142943 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 112 PFEIFFER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6010269.581 2121139.6226 37.8048237870919 -122.408705588917 (37.8048237870919, -122.408705588917) 3 1 10 308 23
172748 142944 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 152 PFEIFFER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6010124.6433 2121121.924 37.8047670723213 -122.409205913626 (37.8047670723213, -122.409205913626) 3 1 10 308 23
45707 142945 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 152 PFEIFFER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6010109.3364 2121119.0539 37.8047583341863 -122.409258682298 (37.8047583341863, -122.409258682298) 3 1 10 308 23
57394 142946 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 154 Pfeiffer St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6010096.4211 2121116.6622 37.8047510435874 -122.409303208326 (37.8047510435874, -122.409303208326) 3 1 10 308 23
38348 142947 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 21 Bellair Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6010050.2611 2121139.8618 37.8048121576562 -122.40946458873 (37.8048121576562, -122.40946458873) 3 1 10 308 23
78294 142948 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 20 BELLAIR PL 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6010061.9805 2121140.5793 37.8048147843729 -122.409424083009 (37.8048147843729, -122.409424083009) 3 1 10 308 23
46642 142949 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 20 BELLAIR PL 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6010058.1538 2121167.8448 37.8048894342531 -122.40943925119 (37.8048894342531, -122.40943925119) 3 1 10 308 23
29651 142950 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 156 Pfeiffer St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6010083.0275 2121115.7055 37.8047476663275 -122.409349490891 (37.8047476663275, -122.409349490891) 3 1 10 308 23
159446 142953 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 19 Bellair Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6010052.6528 2121119.7714 37.804757128417 -122.409454893216 (37.804757128417, -122.409454893216) 3 1 10 308 23
116180 142958 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 172 Pfeiffer St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009982.8149 2121100.1594 37.8046993654404 -122.40969519031 (37.8046993654404, -122.40969519031) 3 1 10 308 23
166162 142959 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 178 Pfeiffer St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009960.8111 2121097.7677 37.8046915653635 -122.409771168052 (37.8046915653635, -122.409771168052) 3 1 10 308 23
151577 142960 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 180 Pfeiffer St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6009952.201 2121096.811 37.8046884559914 -122.409800896711 (37.8046884559914, -122.409800896711) 3 1 10 308 23
173201 142961 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 188 Pfeiffer St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6009941.6774 2121096.811 37.8046878662366 -122.409837314827 (37.8046878662366, -122.409837314827) 3 1 10 308 23
144865 142962 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 192 Pfeiffer St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009928.7622 2121093.4626 37.8046779485644 -122.409881772835 (37.8046779485644, -122.409881772835) 3 1 10 308 23
191595 142969 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 155 PFEIFFER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6010117.5609 2121101.8588 37.8047115814823 -122.409229006305 (37.8047115814823, -122.409229006305) 3 1 10 308 23
117293 142970 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 175 PFEIFFER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6010034.7291 2121089.9447 37.8046742274183 -122.409514813908 (37.8046742274183, -122.409514813908) 3 1 10 308 23
66122 142987 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1871 Grant Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6010368.8695 2120931.1728 37.8042569960583 -122.408347277199 (37.8042569960583, -122.408347277199) 3 1 10 308 23
68433 142988 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1861 Grant Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6010372.0828 2120911.5359 37.804203257928 -122.408334771369 (37.804203257928, -122.408334771369) 3 1 10 308 23
120534 142989 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1851 Grant Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6010373.868 2120901.896 37.8041768891146 -122.408327913174 (37.8041768891146, -122.408327913174) 3 1 10 308 23
82265 142992 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 455 CHESTNUT ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6009662.0127 2120854.6155 37.8040071808412 -122.410788010808 (37.8040071808412, -122.410788010808) 3 1 10 308 23
120153 142993 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008349.8689 2120789.339 37.8037542892016 -122.415324162836 (37.8037542892016, -122.415324162836) 5 1 10 308 32
80199 143012 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 336 LOMBARD ST 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   6010686.888 2120692.5302 37.8036195456032 -122.40722991099 (37.8036195456032, -122.40722991099) 3 1 10 308 23
41771 143014 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 488 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6010067.5326 2120604.4864 37.8033431173057 -122.409367013095 (37.8033431173057, -122.409367013095) 3 1 10 308 23
32198 143018 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 404 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 Width 0ft   6010387.0782 2120648.4016 37.8034815958882 -122.408264308054 (37.8034815958882, -122.408264308054) 3 1 10 308 23
192123 143020 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 560 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     21 Width 0ft   6009678.016 2120549.6995 37.8031708545804 -122.410711083519 (37.8031708545804, -122.410711083519) 3 1 10 308 23
132132 143034 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 670 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/23/2016 12:36:00 PM 25 Width 0ft   6009144.7897 2120475.5959 37.8029374735533 -122.412551093577 (37.8029374735533, -122.412551093577) 3 1 10 308 23
148262 143049 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 475 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     21 Width 0ft   6010056.7368 2120562.2475 37.8032265348731 -122.409401389822 (37.8032265348731, -122.409401389822) 3 1 10 308 23
193541 143069 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1709 Grant Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6010441.5711 2120399.4535 37.8028010970412 -122.408058165055 (37.8028010970412, -122.408058165055) 3 1 10 308 23

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)
);