trees
195 rows where Supervisor Districts = 10 and qSpecies_id = 54 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );