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

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)
81789 98493 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1703 Polk St 1 Sidewalk: Curb side : Pot Tree Private 2     5     6006578.8967 2116733.3834 37.7925179651008 -122.421164544764 (37.7925179651008, -122.421164544764) 13 9 10 28858 32
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
159445 58051 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1609 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/1977 12:00:00 AM 5   Permit Number 17020 6006619.5836 2116449.4594 37.7917406740828 -122.421003598405 (37.7917406740828, -122.421003598405) 13 9 10 28858 21
63070 92953 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1338 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2     12     6006789.4485 2115574.9476 37.7893490550841 -122.420353767408 (37.7893490550841, -122.420353767408) 13 9 10 28858 21
72034 92952 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1334 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2     12     6006791.0528 2115558.9055 37.789305097845 -122.420347077615 (37.789305097845, -122.420347077615) 13 9 10 28858 21
88548 99210 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007993.4855 2121112.3432 37.8046211410646 -122.416580345595 (37.8046211410646, -122.416580345595) 5 1 10 308 32
192594 99227 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   6008003.9616 2121103.5041 37.8045974602939 -122.416543465428 (37.8045974602939, -122.416543465428) 5 1 10 308 32
96661 99228 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   6008013.4555 2121093.6827 37.8045710271276 -122.416509914664 (37.8045710271276, -122.416509914664) 5 1 10 308 32
109841 99229 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   6008022.9494 2121084.5162 37.8045463921415 -122.416476410342 (37.8045463921415, -122.416476410342) 5 1 10 308 32
176662 99230 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   6008035.3898 2121073.3853 37.8045165290969 -122.416432570152 (37.8045165290969, -122.416432570152) 5 1 10 308 32
172700 99231 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   6008046.5206 2121063.2366 37.8044892892651 -122.416393331612 (37.8044892892651, -122.416393331612) 5 1 10 308 32
147046 99232 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008054.705 2121057.3439 37.8044735696368 -122.416364591045 (37.8044735696368, -122.416364591045) 5 1 10 308 32
46849 99233 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008063.2168 2121048.832 37.8044506767497 -122.416334531861 (37.8044506767497, -122.416334531861) 5 1 10 308 32
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
48457 4725 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1050 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     30 4x4   6008238.1211 2120976.4945 37.8042618899237 -122.415724133248 (37.8042618899237, -122.415724133248) 5 1 10 308 23
156904 4726 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1075 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     9     6008251.3021 2120879.612 37.8039966159278 -122.415671655323 (37.8039966159278, -122.415671655323) 5 1 10 308 32
4593 4724 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1050 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     30 4x4   6008259.9153 2120954.1415 37.8042017393393 -122.415647128831 (37.8042017393393, -122.415647128831) 5 1 10 308 23
150356 28073 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1075 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6008262.9463 2120869.8064 37.8039703467655 -122.415630664984 (37.8039703467655, -122.415630664984) 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
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
81395 4723 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1050 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     36 5x5   6008295.1213 2120922.8472 37.8041177920118 -122.415523078458 (37.8041177920118, -122.415523078458) 5 1 10 308 23
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
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
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
82332 4722 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1040 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     22 4x4   6008317.4743 2120903.2884 37.8040653448727 -122.415444338519 (37.8040653448727, -122.415444338519) 5 1 10 308 23
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
60133 4721 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1040 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 5x5   6008335.3567 2120887.0824 37.8040218523597 -122.415381307054 (37.8040218523597, -122.415381307054) 5 1 10 308 23
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
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
139954 4720 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1040 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     24 5x5   6008353.7979 2120870.8765 37.8039783914932 -122.415316341899 (37.8039783914932, -122.415316341899) 5 1 10 308 23
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
76877 53483 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 647 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1969 12:00:00 AM 16   Permit Number 6392 6008737.1169 2120721.7235 37.8035903907477 -122.413979278997 (37.8035903907477, -122.413979278997) 3 1 10 308 23
59458 143246 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 647 CHESTNUT ST 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6008746.811 2120723.5878 37.8035960540957 -122.413945863948 (37.8035960540957, -122.413945863948) 3 1 10 308 23
29451 7685 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 521 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6008756.4018 2121076.0419 37.8045643433196 -122.41393762212 (37.8045643433196, -122.41393762212) 3 1 10 308 23
135245 7686 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 521 Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6008772.4139 2121077.9257 37.8045704150203 -122.413882343906 (37.8045704150203, -122.413882343906) 3 1 10 308 23
137208 4702 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 900 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/02/1989 12:00:00 AM 30 3X3   6008773.44 2120486.1314 37.8029455537581 -122.413836905739 (37.8029455537581, -122.413836905739) 3 1 10 308 23
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
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
63571 4684 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 722 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6009311.9987 2119994.7358 37.8016265338502 -122.411938460907 (37.8016265338502, -122.411938460907) 3 1 10 308 23
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
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
194465 63910 Prune Opt Out 3 Ficus retusa nitida :: Banyan Fig 54 2135 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1991 12:00:00 AM 14   Permit Number 788005 6009385.3216 2121038.8544 37.8044975370449 -122.411758548847 (37.8044975370449, -122.411758548847) 3 1 10 308 23
177769 63908 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2125 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/1987 12:00:00 AM 14   Permit Number 24623 6009389.9763 2121003.9446 37.8044019445665 -122.411739972568 (37.8044019445665, -122.411739972568) 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
36126 63909 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2119 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/1987 12:00:00 AM 12   Permit Number 24624 6009399.6734 2120957.786 37.8042757485475 -122.411703151333 (37.8042757485475, -122.411703151333) 3 1 10 308 23
108496 143259 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 661 LOMBARD ST 11 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   6009421.8295 2120470.7273 37.8029396495373 -122.411592044604 (37.8029396495373, -122.411592044604) 3 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
55400 18519 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1700X Powell St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     30 3X3   6009627.5943 2119520.0726 37.8003409270103 -122.410812809398 (37.8003409270103, -122.410812809398) 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
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
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
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
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
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
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
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
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
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
5517 4664 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 600X Columbus Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     90 5X5   6009692.468 2119649.5892 37.8007001848924 -122.410597470914 (37.8007001848924, -122.410597470914) 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
12953 4663 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 600X Columbus Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1     60 5X5   6009710.0139 2119634.3519 37.8006593307081 -122.41053567802 (37.8006593307081, -122.41053567802) 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
5587 4662 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 600X Columbus Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     80 5X5   6009727.0981 2119617.2678 37.8006133797513 -122.410475352391 (37.8006133797513, -122.410475352391) 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
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
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
9158 4659 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 600X Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     90 5X5   6009780.1976 2119571.0943 37.8004895753531 -122.410288343699 (37.8004895753531, -122.410288343699) 3 1 10 308 23
45716 97934 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2133 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009804.1904 2121525.9403 37.8058584423979 -122.410343422594 (37.8058584423979, -122.410343422594) 3 1 10 308 23
135675 97935 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2133 Stockton St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6009806.2516 2121504.2981 37.8057991338594 -122.410334760405 (37.8057991338594, -122.410334760405) 3 1 10 308 23
21039 97936 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2133 Stockton St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6009809.8586 2121486.2629 37.8057498158932 -122.410321003577 (37.8057498158932, -122.410321003577) 3 1 10 308 23
167831 97937 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2133 Stockton St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2011 12:00:00 AM 8 3x3 Permit Number 768327 6009817.588 2121415.668 37.8055564131765 -122.410289267199 (37.8055564131765, -122.410289267199) 3 1 10 308 23
49487 143166 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2130 STOCKTON ST 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6009846.1251 2121530.2463 37.8058726162247 -122.410198604722 (37.8058726162247, -122.410198604722) 3 1 10 308 23
21747 143165 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2130 STOCKTON ST 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6009847.836 2121509.3744 37.8058154030924 -122.410191209337 (37.8058154030924, -122.410191209337) 3 1 10 308 23
100156 143164 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2130 STOCKTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009854.6792 2121476.1846 37.8057246557504 -122.410165182597 (37.8057246557504, -122.410165182597) 3 1 10 308 23
181493 143163 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2130 STOCKTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6009857.4165 2121454.9705 37.8056665605493 -122.410154211058 (37.8056665605493, -122.410154211058) 3 1 10 308 23
26414 143167 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 195 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6009865.9706 2121568.5686 37.8059789520686 -122.410132633272 (37.8059789520686, -122.410132633272) 3 1 10 308 23
22696 143168 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 189 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6009887.869 2121571.9902 37.8059895743176 -122.410057091761 (37.8059895743176, -122.410057091761) 3 1 10 308 23
51491 143169 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 185 Bay St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6009906.0036 2121573.3589 37.8059943488203 -122.4099944305 (37.8059943488203, -122.4099944305) 3 1 10 308 23
167542 143170 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 179 Bay St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6009922.0853 2121576.7805 37.8060046449874 -122.409939018662 (37.8060046449874, -122.409939018662) 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
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
185698 143162 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 175 Bay St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6009943.6415 2121579.1756 37.8060124294215 -122.409864588833 (37.8060124294215, -122.409864588833) 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
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
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
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
119949 56977 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 177 Pfeiffer St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1974 12:00:00 AM 14   Permit Number 14230 6009999.8042 2121084.2658 37.8046566775876 -122.40963527441 (37.8046566775876, -122.40963527441) 3 1 10 308 23
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
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
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
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
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
34527 143179 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 37 MIDWAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6010057.031 2121502.7089 37.8058088248802 -122.409466784469 (37.8058088248802, -122.409466784469) 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)
);