trees
154 rows where Fire Prevention Districts = 3 and qSpecies_id = 54 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109940 | 258056 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
120425 | 258058 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
137907 | 258057 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
191059 | 258059 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
78902 | 143556 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 848 KEARNY ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6011275.0549 | 2117918.4465 | 37.7960354859857 | -122.404999078913 | (37.7960354859857, -122.404999078913) | 3 | 1 | 10 | 28857 | 4 | |||
180082 | 143557 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 848 KEARNY ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6011271.7921 | 2117938.489 | 37.7960903354635 | -122.405011780806 | (37.7960903354635, -122.405011780806) | 3 | 1 | 10 | 28857 | 4 | |||
37866 | 67753 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1992 12:00:00 AM | 11 | 3x3 | Permit Number 31377 | 6011258.7412 | 2118020.5233 | 37.79631485229 | -122.405062718866 | (37.79631485229, -122.405062718866) | 3 | 1 | 10 | 308 | 4 | |
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 | |||
22448 | 143498 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 857 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6011217.724 | 2117930.0991 | 37.7960642762572 | -122.405198277055 | (37.7960642762572, -122.405198277055) | 3 | 1 | 10 | 28857 | 4 | |||
39600 | 143497 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 867 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6011217.2579 | 2117938.9551 | 37.7960885666374 | -122.40520051379 | (37.7960885666374, -122.40520051379) | 3 | 1 | 10 | 28857 | 4 | |||
170680 | 143496 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 877 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6011215.3935 | 2117948.7433 | 37.7961153384403 | -122.405207654625 | (37.7961153384403, -122.405207654625) | 3 | 1 | 10 | 28857 | 4 | |||
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 | |||
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 | |||
17669 | 64062 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1205 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/18/1990 12:00:00 AM | 7 | Permit Number 29268 | 6011082.0743 | 2119072.3147 | 37.799192938755 | -122.405748149412 | (37.799192938755, -122.405748149412) | 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 | |||
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 | |||
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 | |||
161089 | 98347 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1331 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6011023.1341 | 2119487.8255 | 37.8003305339083 | -122.40598139082 | (37.8003305339083, -122.40598139082) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
38413 | 4600 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 256 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6010961.6739 | 2118493.2807 | 37.7975963184564 | -122.406123962239 | (37.7975963184564, -122.406123962239) | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
125469 | 143491 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 270 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6010925.3503 | 2118525.7809 | 37.7976835243641 | -122.40625194332 | (37.7976835243641, -122.40625194332) | 3 | 1 | 10 | 308 | 23 | |||
89471 | 143492 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 270 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6010909.4189 | 2118541.7123 | 37.7977263769575 | -122.406308193671 | (37.7977263769575, -122.406308193671) | 3 | 1 | 10 | 308 | 23 | |||
164628 | 4605 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 270 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6010895.3992 | 2118554.4574 | 37.7977605876582 | -122.406357604418 | (37.7977605876582, -122.406357604418) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
24988 | 143085 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 463 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6010679.3104 | 2120299.3653 | 37.8025395875062 | -122.40722840197 | (37.8025395875062, -122.40722840197) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
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 | ||
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 | |||
87344 | 143503 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 24 GERKE ALY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6010601.2344 | 2120203.101 | 37.8022708995748 | -122.407491794352 | (37.8022708995748, -122.407491794352) | 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 | |
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 | |
159544 | 143505 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 11 Gerke Aly | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010554.2854 | 2120185.3922 | 37.802219647583 | -122.407653012156 | (37.802219647583, -122.407653012156) | 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 | |
56468 | 143504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3 Gerke Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010525.4571 | 2120179.6266 | 37.8022022028818 | -122.407752365718 | (37.8022022028818, -122.407752365718) | 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 | |||
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 | |||
162693 | 62689 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 523 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/1986 12:00:00 AM | 14 | Permit Number 23025 | 6010433.276 | 2119569.2907 | 37.8005212097535 | -122.408028291205 | (37.8005212097535, -122.408028291205) | 3 | 1 | 10 | 308 | 23 | ||
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 | |||
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 | |||
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 | |||
127974 | 143213 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 175 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010427.9747 | 2121297.8273 | 37.8052670481181 | -122.40816861291 | (37.8052670481181, -122.40816861291) | 3 | 1 | 10 | 308 | 23 | |||
132656 | 143185 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 184 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6010419.6313 | 2121347.0095 | 37.8054016230717 | -122.408200957332 | (37.8054016230717, -122.408200957332) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
84580 | 143186 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 184 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010406.8966 | 2121345.6921 | 37.805397292747 | -122.408244934675 | (37.805397292747, -122.408244934675) | 3 | 1 | 10 | 308 | 23 | |||
95252 | 143212 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 175 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010402.9445 | 2121293.4361 | 37.8052535894305 | -122.408254923564 | (37.8052535894305, -122.408254923564) | 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 | |||
16546 | 143187 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 184 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010390.2098 | 2121342.6183 | 37.8053879184635 | -122.408302464879 | (37.8053879184635, -122.408302464879) | 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 | |||
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 | |||
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 | |||
126823 | 143211 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 175 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010376.5969 | 2121289.0448 | 37.8052400566335 | -122.408345793229 | (37.8052400566335, -122.408345793229) | 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 | |||
61057 | 143188 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 184 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010371.7665 | 2121341.3009 | 37.8053832684295 | -122.40836619766 | (37.8053832684295, -122.40836619766) | 3 | 1 | 10 | 308 | 23 | |||
165733 | 143210 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 175 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010365.1796 | 2121277.1884 | 37.8052068625476 | -122.408384467587 | (37.8052068625476, -122.408384467587) | 3 | 1 | 10 | 308 | 23 | |||
155158 | 143189 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 184 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6010358.1536 | 2121339.5444 | 37.8053776832044 | -122.408413183131 | (37.8053776832044, -122.408413183131) | 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 | |||
123304 | 143227 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 106 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010308.3267 | 2121146.7978 | 37.8048456584244 | -122.408572011197 | (37.8048456584244, -122.408572011197) | 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 | |||
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 | |||
65586 | 59151 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 112 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1980 12:00:00 AM | 13 | Permit Number 18460 | 6010290.1497 | 2121142.971 | 37.8048341329685 | -122.408634644798 | (37.8048341329685, -122.408634644798) | 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 | |||
126969 | 143217 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 235 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010187.3061 | 2121274.0368 | 37.80518824668 | -122.40899980098 | (37.80518824668, -122.40899980098) | 3 | 1 | 10 | 308 | 23 | |||
169613 | 143218 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 251 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010143.2987 | 2121269.7317 | 37.8051739606787 | -122.409151790672 | (37.8051739606787, -122.409151790672) | 3 | 1 | 10 | 308 | 23 | |||
98500 | 143247 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 153 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010131.5523 | 2121103.7243 | 37.8047174875245 | -122.40918071917 | (37.8047174875245, -122.40918071917) | 3 | 1 | 10 | 308 | 23 | |||
72010 | 56572 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 238 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6010130.9034 | 2121308.9776 | 37.805281025756 | -122.409197457422 | (37.805281025756, -122.409197457422) | 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 | |||
131288 | 53752 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 251 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/1972 12:00:00 AM | 13 | Permit Number 9432 | 6010125.6 | 2121266.3833 | 37.8051637752792 | -122.409212803017 | (37.8051637752792, -122.409212803017) | 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 | |||
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 | |||
20967 | 64425 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 259 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/1988 12:00:00 AM | 9 | Permit Number 25277 | 6010096.4211 | 2121261.5999 | 37.8051490065079 | -122.409313442808 | (37.8051490065079, -122.409313442808) | 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 | |||
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 | |||
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 | |||
80867 | 59153 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 20 Bellair Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/1982 12:00:00 AM | 11 | Permit Number 19779 | 6010063.4155 | 2121130.5341 | 37.8047872831513 | -122.409418407658 | (37.8047872831513, -122.409418407658) | 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 | |||
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 | |||
40786 | 143180 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 37 MIDWAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010061.0151 | 2121485.1789 | 37.8057609150954 | -122.409451758875 | (37.8057609150954, -122.409451758875) | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 |
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) );