154 rows where Fire Prevention Districts = 7 and qSpecies_id = 54 sorted by Latitude 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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
157202 140051 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 501 FULTON ST 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6005299.4561 2111632.5014 37.7784399990073 -122.42522832358 (37.7784399990073, -122.42522832358) 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
169233 68430 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 501 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/26/1993 12:00:00 AM 6   Permit Number 32281 6005253.5217 2111626.0919 37.7784198049854 -122.425386771844 (37.7784198049854, -122.425386771844) 7 9 11 28852 10
185324 57510 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 630 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/1976 12:00:00 AM 16   Permit Number 16363 6005412.5487 2111488.2587 37.7780503321524 -122.424826828837 (37.7780503321524, -122.424826828837) 7 9 11 28852 10
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
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
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
105786 140059 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 442 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6005650.7649 2111385.4165 37.7777814045245 -122.423995437557 (37.7777814045245, -122.423995437557) 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
125623 140061 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 448 GROVE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6005605.1155 2111378.5953 37.7777600978209 -122.42415286955 (37.7777600978209, -122.42415286955) 7 9 11 28852 10
120810 139440 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 495 Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6005652 2111358 37.7777061952248 -122.423989214784 (37.7777061952248, -122.423989214784) 7 9 11 28852 10
117632 57633 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 486 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1976 12:00:00 AM 19   Permit Number 16531 6005481.2851 2111360.2306 37.7777026803458 -122.424579935329 (37.7777026803458, -122.424579935329) 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
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
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
109156 110469 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 465 Grove St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15 3x3   6005632.4002 2111334.52 37.7776406182957 -122.424055347089 (37.7776406182957, -122.424055347089) 7 9 11 28852 10
114167 110468 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 465 Grove St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15 3x3   6005616.1343 2111331.3718 37.7776310557335 -122.42411139247 (37.7776310557335, -122.42411139247) 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
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
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
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
106385 139439 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 495 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6005453.4757 2111308.2848 37.7775584792902 -122.424672441445 (37.7775584792902, -122.424672441445) 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
173051 140068 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 582 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6005004.7286 2111303.2254 37.7775192332012 -122.426224448803 (37.7775192332012, -122.426224448803) 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
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
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
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
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
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
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
114513 111733 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 313 Ivy St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 2.5x3   6005854.5902 2111208.289 37.777306560799 -122.423277740102 (37.777306560799, -122.423277740102) 7 9 11 28852 10
128250 111732 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 313 Ivy St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 2.5x3   6005836.5524 2111203.7796 37.7772931610788 -122.423339818124 (37.7772931610788, -122.423339818124) 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
158884 111730 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 313 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 2.5x3   6005810.6231 2111200.9612 37.7772839590018 -122.423429315645 (37.7772839590018, -122.423429315645) 7 9 11 28852 10
119689 12265 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 646 Laguna St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004962.1321 2111217.4355 37.7772812673791 -122.426365694654 (37.7772812673791, -122.426365694654) 7 9 11 28852 10
106185 105961 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 313 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2     2     6005800.4768 2111198.1428 37.7772756476903 -122.423464214596 (37.7772756476903, -122.423464214596) 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
120101 139443 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 640 LAGUNA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6004962.1321 2111203.2952 37.777242441577 -122.426364687622 (37.777242441577, -122.426364687622) 7 9 11 28852 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
108929 12264 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 640 Laguna St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004966.4829 2111191.3303 37.7772098348265 -122.426348784703 (37.7772098348265, -122.426348784703) 7 9 11 28852 10
185720 139434 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 406 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6005390.0639 2111164.7368 37.7771607499747 -122.424881589077 (37.7771607499747, -122.424881589077) 7 9 11 28852 10
129493 139435 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 408 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6005375.9537 2111162.1376 37.7771528162036 -122.424930215803 (37.7771528162036, -122.424930215803) 7 9 11 28852 10
181093 139436 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 410 Ivy St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6005361.8436 2111159.167 37.7771438626442 -122.424978815742 (37.7771438626442, -122.424978815742) 7 9 11 28852 10
188275 59956 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 426 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/16/1981 12:00:00 AM 16   Permit Number 19433 6005279.4106 2111149.1414 37.7771116781194 -122.42526326419 (37.7771116781194, -122.42526326419) 7 9 11 28852 10
182947 33693 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 401 Ivy St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM 13   Permit Number 37765 6005397.8063 2111143.0332 37.7771015944949 -122.424853261184 (37.7771015944949, -122.424853261184) 7 9 11 28852 10
187565 33694 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 401 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM 12   Permit Number 37765 6005381.091 2111139.6901 37.7770914710207 -122.424910846803 (37.7770914710207, -122.424910846803) 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
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
87360 108011 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 419X Ivy St 4 Sidewalk: Curb side : Cutout Tree Private 2     6     6005290.828 2111124.4075 37.7770444098803 -122.42522200735 (37.7770444098803, -122.42522200735) 7 9 11 28852 10
174691 108010 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 419X Ivy St 3 Sidewalk: Curb side : Cutout Tree Private 2     7     6005279.8436 2111122.0196 37.7770372327377 -122.42525983588 (37.7770372327377, -122.42525983588) 7 9 11 28852 10
156143 108009 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 419X Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2     8     6005268.3816 2111120.1092 37.7770313396992 -122.425299350558 (37.7770313396992, -122.425299350558) 7 9 11 28852 10
98584 139448 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 508 OCTAVIA ST 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005463.3958 2111104.0081 37.7769981455225 -122.424623589548 (37.7769981455225, -122.424623589548) 7 9 11 28852 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
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
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
97373 30887 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 412 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/08/1995 12:00:00 AM 21 4x5 Permit Number 34719 6005841.0474 2111067.7548 37.7769199237056 -122.423314596484 (37.7769199237056, -122.423314596484) 7 9 11 28852 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
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
115024 139446 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 508 OCTAVIA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6005466.7779 2111071.8783 37.7769101159246 -122.424609603708 (37.7769101159246, -122.424609603708) 7 9 11 28852 10
97369 30888 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 412 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/08/1995 12:00:00 AM 19 4x4 Permit Number 34719 6005821.6341 2111061.5148 37.7769016945255 -122.4233813094 (37.7769016945255, -122.4233813094) 7 9 11 28852 10
100641 30889 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 412 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/08/1995 12:00:00 AM 21 4x4 Permit Number 34719 6005803.6075 2111060.8215 37.7768987734658 -122.42344361968 (37.7768987734658, -122.42344361968) 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
109817 139445 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 508 OCTAVIA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005470.16 2111049.3311 37.7768483978097 -122.424596299715 (37.7768483978097, -122.424596299715) 7 9 11 28852 10
111800 139444 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 508 OCTAVIA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6005475.2331 2111036.3665 37.7768130866772 -122.424577827872 (37.7768130866772, -122.424577827872) 7 9 11 28852 10
144570 58783 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 500 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/28/1979 12:00:00 AM 15 3x3 Permit Number 18026 6005406.4028 2111007.6387 37.7767303197423 -122.424813888538 (37.7767303197423, -122.424813888538) 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
122196 108005 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 520 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2     21 3x3   6005304.2003 2110990.4457 37.7766773388863 -122.425166213949 (37.7766773388863, -122.425166213949) 7 9 11 28852 10
87483 108006 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 520 Hayes St 4 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6005290.3504 2110988.0578 37.7766699998805 -122.425213954913 (37.7766699998805, -122.425213954913) 7 9 11 28852 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
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
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
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
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
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
166303 33642 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 462 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/03/1996 12:00:00 AM 10   Permit Number 37736 6005186.1558 2110786.6502 37.776111096903 -122.42556005737 (37.776111096903, -122.42556005737) 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
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
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
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
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

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