154 rows where Fire Prevention Districts = 7 and qSpecies_id = 54 sorted by Zip Codes descending

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)
1614 140208 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 708 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003569 2110758 37.7759409231905 -122.431152184499 (37.7759409231905, -122.431152184499) 7 9 11 29492 10
11382 140207 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 708 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6003569 2110758 37.7759409231905 -122.431152184499 (37.7759409231905, -122.431152184499) 7 9 11 29492 10
11850 66378 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 624 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM 8   Permit Number 29503 6003604.7588 2110527.1817 37.7753091794017 -122.431012007993 (37.7753091794017, -122.431012007993) 7 9 11 29492 10
17483 247328 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 696X Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft Permit Number 785235 6003691.2873 2110070.3794 37.7740598153428 -122.430680081912 (37.7740598153428, -122.430680081912) 7 9 11 29492 10
23704 7163 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 730 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     21 3X3   6003538.8779 2111021.3343 37.7766622670699 -122.431275186 (37.7766622670699, -122.431275186) 7 9 11 29492 10
50205 244507 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 480 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6003680.127 2109976.8678 37.7738024231986 -122.430712012932 (37.7738024231986, -122.430712012932) 7 9 11 29492 10
57601 7155 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 710 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6003553.4142 2110901.6518 37.776334472306 -122.431216355856 (37.776334472306, -122.431216355856) 7 9 11 29492 10
66733 140608 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 840 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6003502.6081 2111278.9255 37.7773674931794 -122.431419046703 (37.7773674931794, -122.431419046703) 7 9 11 29492 10
73394 10639 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 877 Hayes St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003685.3267 2110714.3548 37.7758276754833 -122.430746665053 (37.7758276754833, -122.430746665053) 7 9 11 29492 10
74359 140630 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 808 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6003528.2379 2111115.3472 37.7769198002338 -122.431318705355 (37.7769198002338, -122.431318705355) 7 9 11 29492 10
76970 244502 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 607 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6003992.8339 2110059.3818 37.7740466976962 -122.429636195865 (37.7740466976962, -122.429636195865) 7 9 11 29492 10
77575 23736 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 815 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2005 12:00:00 AM 8 4X4   6003952.5765 2110750.7086 37.7759426316052 -122.429824773698 (37.7759426316052, -122.429824773698) 7 9 11 29492 10
92546 244501 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 607 Oak St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6004030.4942 2110064.8827 37.7740639341827 -122.429506314812 (37.7740639341827, -122.429506314812) 7 9 11 29492 10
99019 140702 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 710 FILLMORE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003550.9915 2110923.9408 37.776395535095 -122.43122632799 (37.776395535095, -122.43122632799) 7 9 11 29492 10
99064 244499 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 605 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6004067.3081 2110070.8068 37.7740822846104 -122.429379391728 (37.7740822846104, -122.429379391728) 7 9 11 29492 10
109783 64843 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 618 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM 11   Permit Number 29500 6003607.7064 2110511.4611 37.7752661815317 -122.431000689329 (37.7752661815317, -122.431000689329) 7 9 11 29492 10
111367 244503 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 625 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003964.483 2110055.5735 37.7740346356873 -122.429733994804 (37.7740346356873, -122.429733994804) 7 9 11 29492 10
118687 140621 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 814 FILLMORE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6003510.9001 2111228.4198 37.7772292869927 -122.431386755732 (37.7772292869927, -122.431386755732) 7 9 11 29492 10
122397 140223 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 610 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6003617.0405 2110448.5788 37.7750940511339 -122.43096391169 (37.7750940511339, -122.43096391169) 7 9 11 29492 10
123680 140224 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 610 FILLMORE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6003614.5841 2110462.3343 37.7751316811611 -122.430973390858 (37.7751316811611, -122.430973390858) 7 9 11 29492 10
125577 140609 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 850 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6003501.1005 2111292.4942 37.777404664022 -122.431425230844 (37.777404664022, -122.431425230844) 7 9 11 29492 10
138681 16953 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 643 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6003890.8551 2110044.9948 37.7740014196611 -122.429987931494 (37.7740014196611, -122.429987931494) 7 9 11 29492 10
140176 140213 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 658 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6003592.9683 2110633.2956 37.7755998738913 -122.431060369379 (37.7755998738913, -122.431060369379) 7 9 11 29492 10
140575 7160 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 722 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 3X3   6003546.1461 2110964.158 37.7765056869903 -122.431245960959 (37.7765056869903, -122.431245960959) 7 9 11 29492 10
149100 60603 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 630 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM 9   Permit Number 29505 6003603.285 2110552.7276 37.775379238631 -122.431018929857 (37.775379238631, -122.431018929857) 7 9 11 29492 10
152841 140214 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 668 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6003589.5295 2110658.3502 37.7756684727789 -122.43107405366 (37.7756684727789, -122.43107405366) 7 9 11 29492 10
155347 10637 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 843 Hayes St 2 Sidewalk: Curb side : Cutout Tree DPW 1   08/02/1990 12:00:00 AM 12 3X3   6003821.4079 2110734.0055 37.7758893402664 -122.430277327931 (37.7758893402664, -122.430277327931) 7 9 11 29492 10
156612 140631 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 810 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6003522.9612 2111140.977 37.7769898742733 -122.431338789049 (37.7769898742733, -122.431338789049) 7 9 11 29492 10
165292 66381 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 648 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM 13   Permit Number 29507 6003596.4072 2110594.4854 37.775493505524 -122.431045702786 (37.775493505524, -122.431045702786) 7 9 11 29492 10
166492 247345 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 604 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6004033.5399 2110118.9664 37.7742126072073 -122.429499636998 (37.7742126072073, -122.429499636998) 7 9 11 29492 10
167006 112132 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 630 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6003600.3374 2110567.9569 37.7754208875098 -122.431030213476 (37.7754208875098, -122.431030213476) 7 9 11 29492 10
170449 10636 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 843 Hayes St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/02/1990 12:00:00 AM 12 3X3   6003811.0913 2110732.5317 37.7758847092198 -122.430312910525 (37.7758847092198, -122.430312910525) 7 9 11 29492 10
176648 140610 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 860 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6003498.0852 2111306.0629 37.7774417494141 -122.431436630621 (37.7774417494141, -122.431436630621) 7 9 11 29492 10
177613 244504 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 697 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6003691.552 2110018.3364 37.773916933054 -122.430675451783 (37.773916933054, -122.430675451783) 7 9 11 29492 10
188166 7161 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 726 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003541.3006 2110998.0762 37.7765985433792 -122.431265144599 (37.7765985433792, -122.431265144599) 7 9 11 29492 10
189603 244508 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 470 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003685.2048 2109943.0159 37.7737097618778 -122.430692031876 (37.7737097618778, -122.430692031876) 7 9 11 29492 10
192110 140209 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 708 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003569 2110758 37.7759409231905 -122.431152184499 (37.7759409231905, -122.431152184499) 7 9 11 29492 10
192358 10629 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 817 Hayes St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/02/1990 12:00:00 AM 12 3X3   6003911.8012 2110745.3047 37.7759254847018 -122.429965440473 (37.7759254847018, -122.429965440473) 7 9 11 29492 10
30992 141781 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1480 ELLIS ST 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6003816.5092 2113214.7018 37.7827004390473 -122.430471315153 (37.7827004390473, -122.430471315153) 7 9 11 29490 41
72409 141798 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1280 WEBSTER ST 9 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003785.6349 2113107.9429 37.7824055567974 -122.430570506849 (37.7824055567974, -122.430570506849) 7 9 11 29490 41
81765 141777 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 7 Hollis St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6003915.306 2113275.4592 37.7828728597693 -122.430133856067 (37.7828728597693, -122.430133856067) 7 9 11 29490 41
107562 141779 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1480 ELLIS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6003870.3983 2113222.6267 37.7827252513684 -122.430285447411 (37.7827252513684, -122.430285447411) 7 9 11 29490 41
122119 141768 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3 Hollis St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6003889.1539 2113490.7518 37.7834625181939 -122.430239695918 (37.7834625181939, -122.430239695918) 7 9 11 29490 41
137918 141793 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1280 WEBSTER ST 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6003797.3488 2112989.7381 37.7820816595285 -122.430521544957 (37.7820816595285, -122.430521544957) 7 9 11 29490 41
148172 141792 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1280 WEBSTER ST 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6003805.1483 2112935.1558 37.7819322319873 -122.430490666465 (37.7819322319873, -122.430490666465) 7 9 11 29490 41
149390 141767 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1 Hollis St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003884.399 2113511.8848 37.7835202748029 -122.430257654213 (37.7835202748029, -122.430257654213) 7 9 11 29490 41
163587 141799 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1280 WEBSTER ST 10 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003782.7951 2113127.1113 37.782458027558 -122.430581699509 (37.782458027558, -122.430581699509) 7 9 11 29490 41
183700 141776 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5 Hollis St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6003896.2863 2113355.7647 37.783092281356 -122.430205387238 (37.783092281356, -122.430205387238) 7 9 11 29490 41
189942 141780 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1480 ELLIS ST 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6003842.3971 2113219.4567 37.7827149612606 -122.430382093414 (37.7827149612606, -122.430382093414) 7 9 11 29490 41
190297 141778 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 9 Hollis St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6003916.891 2113262.7794 37.7828381339765 -122.430127467778 (37.7828381339765, -122.430127467778) 7 9 11 29490 41
40612 6232 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1220 Ellis St 4 Sidewalk: Curb side : Cutout Tree DPW 1   01/02/1991 12:00:00 AM 12 3X3   6005007.0756 2113377.0261 37.7832135118405 -122.426364020332 (37.7832135118405, -122.426364020332) 7 9 11 28858 41
59417 6235 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1250 Ellis St 3 Sidewalk: Curb side : Cutout Tree DPW 1   01/02/1991 12:00:00 AM 12 3X3   6004904.9664 2113362.05 37.7831666187465 -122.426716210533 (37.7831666187465, -122.426716210533) 7 9 11 28858 41
128466 6224 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1220 Ellis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X4   6005090.9413 2113387.3731 37.7832466624445 -122.426074615309 (37.7832466624445, -122.426074615309) 7 9 11 28858 41
131718 6245 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1280 Ellis St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/20/1995 12:00:00 AM 18 3X3   6004753.0279 2113338.633 37.7830937301366 -122.427240188063 (37.7830937301366, -122.427240188063) 7 9 11 28858 41
136758 6242 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1250 Ellis St 5 Sidewalk: Curb side : Cutout Tree DPW 1   01/02/1991 12:00:00 AM 12 3X3   6004855.4094 2113352.7921 37.7831383969133 -122.426886998286 (37.7831383969133, -122.426886998286) 7 9 11 28858 41
2553 140071 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 601X Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
3207 111734 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 313 Ivy St 6 Sidewalk: Curb side : Cutout Tree Private 2     11 2.5x3   6005865.3001 2111209.4164 37.777310260787 -122.423240771205 (37.777310260787, -122.423240771205) 7 9 11 28852 10
3486 12249 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 511 Laguna St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004989.1563 2110705.1842 37.7758762780635 -122.426235730542 (37.7758762780635, -122.426235730542) 7 9 11 28852 10
3763 73629 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 530 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   20 5x7   6005222.8265 2111323.2215 37.7775864626885 -122.425471398253 (37.7775864626885, -122.425471398253) 7 9 11 28852 10
6485 71703 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 530 Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6005189.8095 2111320.4314 37.7775769362179 -122.425585416633 (37.7775769362179, -122.425585416633) 7 9 11 28852 10
8024 59162 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 465 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/16/1981 12:00:00 AM 16 3x3 Permit Number 19443 6005553.1697 2111320.8777 37.7775986862615 -122.424328461999 (37.7775986862615, -122.424328461999) 7 9 11 28852 10
8341 16938 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 595X Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6004175.1129 2110087.9596 37.7741354848182 -122.429007699423 (37.7741354848182, -122.429007699423) 7 9 11 28852 10
9948 16864 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 230 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6005857.5291 2110371.9412 37.7750103183132 -122.423208108745 (37.7750103183132, -122.423208108745) 7 9 11 28852 10
12129 57526 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 501 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/16/1981 12:00:00 AM 13 3x3 Permit Number 19437 6005352.078 2111299.9206 37.7775297860553 -122.425022615137 (37.7775297860553, -122.425022615137) 7 9 11 28852 10
12468 9697 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 423 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6005890.102 2111192.506 37.7772652286056 -122.423153770988 (37.7772652286056, -122.423153770988) 7 9 11 28852 10
18163 140072 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 601X Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
19361 61824 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 568 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/1985 12:00:00 AM 19   Permit Number 21857 6005139.9121 2110969.4321 37.7766103583758 -122.425733039566 (37.7766103583758, -122.425733039566) 7 9 11 28852 10
22833 244381 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 221 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6005910.0454 2110329.5608 37.7748969155572 -122.423023430361 (37.7748969155572, -122.423023430361) 7 9 11 28852 10
23337 142265 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 500 FELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6004973.0459 2110598.408 37.7755821860494 -122.426283856756 (37.7755821860494, -122.426283856756) 7 9 11 28852 10
23351 33662 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 453 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/2016 12:00:00 AM 3   Permit Number 37750 6005235.3039 2110769.7304 37.7760674161616 -122.425388836438 (37.7760674161616, -122.425388836438) 7 9 11 28852 10
24303 139447 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 508 OCTAVIA ST 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6005464.5232 2111090.4798 37.7769610637771 -122.424618726949 (37.7769610637771, -122.424618726949) 7 9 11 28852 10
28061 244147 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 405 Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6004529.1957 2109628.6007 37.7728942335898 -122.427750128017 (37.7728942335898, -122.427750128017) 7 9 11 28852 10
29165 108003 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 520 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 4x4   6005338.5862 2110997.1319 37.7766976400209 -122.425047738741 (37.7766976400209, -122.425047738741) 7 9 11 28852 10
30158 244277 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 595 Oak St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 Width 0ft   6004143 2110087 37.7741310322057 -122.429118715156 (37.7741310322057, -122.429118715156) 7 9 11 28852 10
32066 110467 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 465 Grove St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15 3x3   6005585.7014 2111327.1742 37.7776178118347 -122.424216371681 (37.7776178118347, -122.424216371681) 7 9 11 28852 10
33826 59960 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 492 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/1981 12:00:00 AM 21   Permit Number 19438 6005457.1486 2111358.1318 37.7776955544263 -122.424663282479 (37.7776955544263, -122.424663282479) 7 9 11 28852 10
33837 138854 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 519 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6004884.6976 2111071.1642 37.7768752647693 -122.426623147275 (37.7768752647693, -122.426623147275) 7 9 11 28852 10
37910 244243 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 150 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6005806.4217 2110019.2116 37.7740389237303 -122.423359820085 (37.7740389237303, -122.423359820085) 7 9 11 28852 10
38313 31337 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 745 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1995 12:00:00 AM 16 6x18 Permit Number 34951 6004453.62375 2111092.99154 37.7769108173179 -122.428115918737 (37.7769108173179, -122.428115918737) 7 9 11 28852 10
38809 140069 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 582 GROVE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6005006.5887 2111294.3898 37.7774950779447 -122.426217384893 (37.7774950779447, -122.426217384893) 7 9 11 28852 10
39578 140070 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 601X Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
40947 111735 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 313 Ivy St 7 Sidewalk: Curb side : Cutout Tree Private 2     11 2.5x3   6005874.8827 2111210.5438 37.7773138971451 -122.423207702005 (37.7773138971451, -122.423207702005) 7 9 11 28852 10
42302 16867 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 235 Oak St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x5   6005854.7098 2110323.2964 37.7748765923478 -122.423214402753 (37.7748765923478, -122.423214402753) 7 9 11 28852 10
43203 30704 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 369 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM 12   Permit Number 34615 6005232.8948 2110236.794 37.7746039663436 -122.42535923638 (37.7746039663436, -122.42535923638) 7 9 11 28852 10
43620 12248 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 511 Linden St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004985.728 2110723.6115 37.7759266811529 -122.426248902156 (37.7759266811529, -122.426248902156) 7 9 11 28852 10
43861 111731 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 313 Ivy St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 2.5x3   6005824.7151 2111202.6522 37.7772893974301 -122.423380687053 (37.7772893974301, -122.423380687053) 7 9 11 28852 10
45674 9652 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 75 Gough St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/07/1995 12:00:00 AM 3 2x3   6006083.2108 2109791.7339 37.7734299424642 -122.42238619159 (37.7734299424642, -122.42238619159) 7 9 11 28852 10
50842 142266 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 503 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6004999.4413 2110629.3324 37.7756685888616 -122.426194750692 (37.7756685888616, -122.426194750692) 7 9 11 28852 10
54245 139449 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 508 OCTAVIA ST 6 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005461.1411 2111122.6096 37.7770490933731 -122.42463271281 (37.7770490933731, -122.42463271281) 7 9 11 28852 10
55824 110470 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 465 Grove St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15 3x3   6005644.9931 2111337.1436 37.7776485330384 -122.424011970547 (37.7776485330384, -122.424011970547) 7 9 11 28852 10
61349 140050 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 501 FULTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6005278.6254 2111629.2967 37.7784300228635 -122.425300156764 (37.7784300228635, -122.425300156764) 7 9 11 28852 10
61814 110466 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 465 Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16 3x3   6005573.1085 2111325.0754 37.7776113379896 -122.424259785517 (37.7776113379896, -122.424259785517) 7 9 11 28852 10
74257 244278 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 595 Oak St 3 Sidewalk: Curb side : Cutout Tree DPW 1     13 Width 0ft   6004143 2110087 37.7741310322057 -122.429118715156 (37.7741310322057, -122.429118715156) 7 9 11 28852 10
75673 12271 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 700X Laguna St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004951.5507 2111300.9055 37.7775098574182 -122.426408243779 (37.7775098574182, -122.426408243779) 7 9 11 28852 10
76159 110471 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 465 Grove St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12 3x3   6005689.0684 2111342.3906 37.7776654283212 -122.423859872139 (37.7776654283212, -122.423859872139) 7 9 11 28852 10
77520 33692 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 401 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM 11   Permit Number 37765 6005361.9877 2111137.3022 37.7770838353758 -122.42497676123 (37.7770838353758, -122.42497676123) 7 9 11 28852 10
80103 244379 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 219 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6005931.9708 2110333.2151 37.7749081865836 -122.422947845445 (37.7749081865836, -122.422947845445) 7 9 11 28852 10
81768 16876 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 274 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6005679.4463 2110349.1101 37.7749375780539 -122.423822512667 (37.7749375780539, -122.423822512667) 7 9 11 28852 10
82036 140060 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 448 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6005624.0049 2111381.7435 37.777769808526 -122.424087748475 (37.777769808526, -122.424087748475) 7 9 11 28852 10
85107 138831 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 745 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6004451.1778 2111098.9724 37.7769271009021 -122.428124806353 (37.7769271009021, -122.428124806353) 7 9 11 28852 10

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