154 rows where Fire Prevention Districts = 7 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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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