154 rows where Fire Prevention Districts = 3 and qSpecies_id = 54 sorted by Location

View and edit SQL

Fire Prevention Districts

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

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