154 rows where Fire Prevention Districts = 3 and qSpecies_id = 54

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)
127974 143213 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 175 FRANCISCO ST 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6010427.9747 2121297.8273 37.8052670481181 -122.40816861291 (37.8052670481181, -122.40816861291) 3 1 10 308 23
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
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
131288 53752 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 251 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/27/1972 12:00:00 AM 13   Permit Number 9432 6010125.6 2121266.3833 37.8051637752792 -122.409212803017 (37.8051637752792, -122.409212803017) 3 1 10 308 23
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
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
132656 143185 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 184 FRANCISCO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6010419.6313 2121347.0095 37.8054016230717 -122.408200957332 (37.8054016230717, -122.408200957332) 3 1 10 308 23
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
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
135675 97935 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2133 Stockton St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6009806.2516 2121504.2981 37.8057991338594 -122.410334760405 (37.8057991338594, -122.410334760405) 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
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
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
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
144865 142962 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 192 Pfeiffer St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009928.7622 2121093.4626 37.8046779485644 -122.409881772835 (37.8046779485644, -122.409881772835) 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
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
148028 142943 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 112 PFEIFFER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6010269.581 2121139.6226 37.8048237870919 -122.408705588917 (37.8048237870919, -122.408705588917) 3 1 10 308 23
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
151577 142960 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 180 Pfeiffer St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6009952.201 2121096.811 37.8046884559914 -122.409800896711 (37.8046884559914, -122.409800896711) 3 1 10 308 23
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
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
155158 143189 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 184 FRANCISCO ST 5 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6010358.1536 2121339.5444 37.8053776832044 -122.408413183131 (37.8053776832044, -122.408413183131) 3 1 10 308 23
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
159446 142953 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 19 Bellair Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6010052.6528 2121119.7714 37.804757128417 -122.409454893216 (37.804757128417, -122.409454893216) 3 1 10 308 23
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
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
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
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
165733 143210 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 175 FRANCISCO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6010365.1796 2121277.1884 37.8052068625476 -122.408384467587 (37.8052068625476, -122.408384467587) 3 1 10 308 23
166162 142959 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 178 Pfeiffer St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009960.8111 2121097.7677 37.8046915653635 -122.409771168052 (37.8046915653635, -122.409771168052) 3 1 10 308 23
167542 143170 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 179 Bay St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6009922.0853 2121576.7805 37.8060046449874 -122.409939018662 (37.8060046449874, -122.409939018662) 3 1 10 308 23
167831 97937 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2133 Stockton St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2011 12:00:00 AM 8 3x3 Permit Number 768327 6009817.588 2121415.668 37.8055564131765 -122.410289267199 (37.8055564131765, -122.410289267199) 3 1 10 308 23
169613 143218 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 251 FRANCISCO ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6010143.2987 2121269.7317 37.8051739606787 -122.409151790672 (37.8051739606787, -122.409151790672) 3 1 10 308 23
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
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
172748 142944 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 152 PFEIFFER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6010124.6433 2121121.924 37.8047670723213 -122.409205913626 (37.8047670723213, -122.409205913626) 3 1 10 308 23
173201 142961 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 188 Pfeiffer St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6009941.6774 2121096.811 37.8046878662366 -122.409837314827 (37.8046878662366, -122.409837314827) 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
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
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
181493 143163 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2130 STOCKTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6009857.4165 2121454.9705 37.8056665605493 -122.410154211058 (37.8056665605493, -122.410154211058) 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
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
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
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
185698 143162 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 175 Bay St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6009943.6415 2121579.1756 37.8060124294215 -122.409864588833 (37.8060124294215, -122.409864588833) 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
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
191595 142969 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 155 PFEIFFER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6010117.5609 2121101.8588 37.8047115814823 -122.409229006305 (37.8047115814823, -122.409229006305) 3 1 10 308 23
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
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
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
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

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