trees

164 rows where Fire Prevention Districts = 8 and qSpecies_id = 53

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

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)
131297 17307 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 51X Otis St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006961.49044 2109420.44821 37.772459985288 -122.419321746309 (37.772459985288, -122.419321746309) 8 2 9 28853 19
131463 120674 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3876 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780.8 2105549.3 37.761651098806 -122.430047862208 (37.761651098806, -122.430047862208) 8 4 5 28862 3
132426 95220 Undocumented 4 Ficus nitida :: Laurel Fig 53 3208 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005461 2106663 37.7648040703693 -122.424315938973 (37.7648040703693, -122.424315938973) 8 4 5 28853 19
133574 100482 Undocumented 4 Ficus nitida :: Laurel Fig 53 1849 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008683 2107773 37.7680332828269 -122.413250335235 (37.7680332828269, -122.413250335235) 8 4 7 28853 19
136552 103634 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 7 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
138208 95414 Undocumented 4 Ficus nitida :: Laurel Fig 53 49X South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Creating record for 3 ficus trees at this address on 2/28/2011. 6007102.30356 2110018.85993 37.7741110108752 -122.418877107651 (37.7741110108752, -122.418877107651) 8 2 9 28853 19
138240 108324 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
139216 18329 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 269 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6010332.3440196 2107072.4168362 37.7662021013824 -122.407496007113 (37.7662021013824, -122.407496007113) 8 4 8 28853 19
140527 15263 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 8 Sidewalk: Curb side : Cutout Tree DPW 1   09/30/2008 12:00:00 AM 12 3x3 Permit Number 51766 6007587.5132074 2110099.4827033 37.7743596907053 -122.417204392502 (37.7743596907053, -122.417204392502) 8 2 9 28853 19
141499 18310 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 140 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 4X4   6010243.055587 2107664.3185897 37.7678223300533 -122.407846582122 (37.7678223300533, -122.407846582122) 8 4 8 28853 19
141769 15252 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1450X Mission St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007671.66057 2110183.15551 37.7745941699553 -122.416919239811 (37.7745941699553, -122.416919239811) 8 2 9 28853 34
143541 28384 Permitted Site 7 Ficus nitida :: Laurel Fig 53 286 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     18     6006047.68288 2107930.23885 37.7683167183705 -122.422376798825 (37.7683167183705, -122.422376798825) 8 4 5 28853 19
145639 112403 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
145766 101765 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
146667 15335 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1720 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6006691.81678 2108397.85831 37.7696370050813 -122.420181988192 (37.7696370050813, -122.420181988192) 8 4 7 28853 19
148003 95416 Undocumented 4 Ficus nitida :: Laurel Fig 53 49X South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Created recoard for tree on 2/28/2011. Tree approx. 20 years old. 6007102.30356 2110018.85993 37.7741110108752 -122.418877107651 (37.7741110108752, -122.418877107651) 8 2 9 28853 19
148177 100480 Undocumented 4 Ficus nitida :: Laurel Fig 53 245 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6007080 2107899 37.7682891227663 -122.418803888241 (37.7682891227663, -122.418803888241) 8 4 7 28853 19
148285 111389 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 19
148347 18327 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 259 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X2   6010329.0895487 2107117.8320658 37.7663266190773 -122.407510465965 (37.7663266190773, -122.407510465965) 8 4 8 28853 19
148523 15253 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1450X Mission St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007637.14046 2110148.71 37.7744976489686 -122.417036210851 (37.7744976489686, -122.417036210851) 8 2 9 28853 34
148648 101767 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 10 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
150296 100481 Undocumented 4 Ficus nitida :: Laurel Fig 53 1849 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3 Permit Number 26048 6008683 2107773 37.7680332828269 -122.413250335235 (37.7680332828269, -122.413250335235) 8 4 7 28853 19
152094 18326 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 259 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6010329.0895487 2107117.8320658 37.7663266190773 -122.407510465965 (37.7663266190773, -122.407510465965) 8 4 8 28853 19
152130 101760 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
153176 112405 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
153446 44127 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1455 Market St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2000 12:00:00 AM     Permit Number 43631 6007204.94423628 2110535.86362082 37.7755363583765 -122.418558723581 (37.7755363583765, -122.418558723581) 8 2 9 28853 34
155474 17322 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 99X Otis St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
156641 15249 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1450X Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007741.56076 2110251.13936 37.7747847690696 -122.416682257719 (37.7747847690696, -122.416682257719) 8 2 9 28853 34
157267 17313 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 86 OTIS ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
159363 58908 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 353 10th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/1980 12:00:00 AM 13 3x3 Permit Number 780019 6009109.47745 2109280.29041 37.7721958858688 -122.411881715065 (37.7721958858688, -122.411881715065) 8 2 9 28853 34
160281 103637 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 10 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
162113 108325 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
162257 97610 Permitted Site 7 Ficus nitida :: Laurel Fig 53 349 10th St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6009106.7 2109348.6 37.7723832922197 -122.411896150488 (37.7723832922197, -122.411896150488) 8 2 9 28853 34
164853 103632 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
165318 93031 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3265 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 5.5x9   6005231 2106625 37.7646867413409 -122.425108746155 (37.7646867413409, -122.425108746155) 8 4 5 28859 19
166088 103636 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 9 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
166186 112407 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
166702 57580 Permitted Site 7 Ficus nitida :: Laurel Fig 53 6 Sharon St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/1976 12:00:00 AM 10   Permit Number 16447 6003825.41823987 2107112.36179244 37.7659454174839 -122.430005049505 (37.7659454174839, -122.430005049505) 8 4 5 28862 3
167163 17304 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 51X Otis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006870.5020453 2109341.6908091 37.7722386113234 -122.419630895813 (37.7722386113234, -122.419630895813) 8 2 9 28853 19
168880 112409 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
170902 18297 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 35X Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   6010274.737783 2108072.9305947 37.7689460585554 -122.407765812226 (37.7689460585554, -122.407765812226) 8 4 8 28853 19
170953 101768 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 11 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
172014 101769 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 12 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
173445 15262 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 6 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6007448.14843 2109975.86864 37.774012434525 -122.417677719037 (37.774012434525, -122.417677719037) 8 2 9 28853 19
173835 17323 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 99X Otis St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
175687 17314 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 86 OTIS ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
177897 100470 Undocumented 4 Ficus nitida :: Laurel Fig 53 5X Pearl St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6005567.3 2108720.4 37.7704592014806 -122.424094599295 (37.7704592014806, -122.424094599295) 8 2 5 28853 19
177969 122633 Undocumented 4 Ficus nitida :: Laurel Fig 53 260 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6006915 2105702 37.7622473847542 -122.419218743707 (37.7622473847542, -122.419218743707) 8 4 7 28859 19
177980 27711 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 175X Otis St 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
180301 96962 Undocumented 4 Ficus nitida :: Laurel Fig 53 3401X 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 5x5   6004198 2106595 37.7645459600586 -122.428679481968 (37.7645459600586, -122.428679481968) 8 4 5 28862 3
181935 17311 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 77 Otis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006769.4589066 2109244.8738273 37.7719670827617 -122.419973541884 (37.7719670827617, -122.419973541884) 8 2 9 28853 19
183049 111628 Undocumented 4 Ficus nitida :: Laurel Fig 53 11X SOUTH VAN NESS AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007074 2110234 37.7747001403616 -122.418990277193 (37.7747001403616, -122.418990277193) 8 2 9 28853 19
183113 18328 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 269 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6010332.3440196 2107072.4168362 37.7662021013824 -122.407496007113 (37.7662021013824, -122.407496007113) 8 4 8 28853 19
185238 15310 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1650 Mission St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6006887.5781181 2109042.9003069 37.7714191656036 -122.41955062575 (37.7714191656036, -122.41955062575) 8 2 9 28853 19
186566 15267 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1531 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6007476.41024 2109891.28194 37.7737817698767 -122.417573960108 (37.7737817698767, -122.417573960108) 8 2 9 28853 19
187371 89021 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1500 Mission St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51766 6007445.1 2110006.7 37.7740969185595 -122.417690449841 (37.7740969185595, -122.417690449841) 8 2 9 28853 19
187641 17308 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 70 Otis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006766.44916 2109389.93705 37.7723652222089 -122.419994248937 (37.7723652222089, -122.419994248937) 8 2 9 28853 19
188704 57306 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3265 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/1992 12:00:00 AM   5.5x9 Permit Number 30983 6005094.29272651 2106604.42467206 37.7646225228273 -122.425580116407 (37.7646225228273, -122.425580116407) 8 4 5 28859 19
189307 111392 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 19
189650 15279 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1551 MISSION ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6007345 2109715.7 37.7732922684508 -122.418016080506 (37.7732922684508, -122.418016080506) 8 2 9 28853 19
190135 15260 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6007445.07805 2110006.65891 37.7740968045009 -122.417690522857 (37.7740968045009, -122.417690522857) 8 2 9 28853 19
190383 17316 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 86 OTIS ST 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
192675 111390 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 19
193673 120592 Undocumented 4 Ficus nitida :: Laurel Fig 53 3773 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003806 2105923 37.7626786166025 -122.429987363922 (37.7626786166025, -122.429987363922) 8 4 5 28862 3

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