trees

1,194 rows where qSpecies_id = 50 sorted by PlantDate descending

✎ View and edit SQL

This data as json, CSV (advanced)

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)
17504 261109 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 20 Latona St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2019 12:00:00 AM 3 4x6   6014376 2094477 37.7318432579921 -122.392628501141 (37.7318432579921, -122.392628501141) 10 3 8 58 1
14333 68480 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1218 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32350 6010273.43286101 2102111.66598921 37.7525776974999 -122.407350018785 (37.7525776974999, -122.407350018785) 2 4 7 28859 19
61102 68472 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2753 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32338 6009679.35333294 2103342.23929983 37.7559233085758 -122.409491298475 (37.7559233085758, -122.409491298475) 2 4 7 28859 19
180711 68479 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1216 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32349 6010272.81628211 2102122.83184257 37.7526083219498 -122.407352938123 (37.7526083219498, -122.407352938123) 2 4 7 28859 19
14099 38381 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1464 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/17/2005 12:00:00 AM 5   Permit Number 48279 6011990.10357 2101552.61207 37.7511385883967 -122.401374155011 (37.7511385883967, -122.401374155011) 10 3 8 28856 29
51702 97477 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3000 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2011 12:00:00 AM 3 3x3 Permit Number 768380 6009497.8 2101066.6 37.7496647366653 -122.409958533785 (37.7496647366653, -122.409958533785) 2 4 7 28859 19
106402 61391 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3006 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2011 12:00:00 AM 3 3x3 Permit Number 768380 6009515.29830856 2101045.50817637 37.7496078038852 -122.409896535031 (37.7496078038852, -122.409896535031) 2 4 7 28859 19
107178 97476 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3000 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2011 12:00:00 AM 3 3x3 Permit Number 768380 6009497.8 2101066.6 37.7496647366653 -122.409958533785 (37.7496647366653, -122.409958533785) 2 4 7 28859 19
136750 59221 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 62 Landers St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/13/2009 12:00:00 AM   3x3 Permit Number 52989 6004451.77295889 2107409.78146369 37.7667975133385 -122.427859811231 (37.7667975133385, -122.427859811231) 8 4 5 28862 3
64830 40096 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 359 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2001 12:00:00 AM 8   Permit Number 44400 6014088.36289 2105304.3939 37.7615570193592 -122.394380761457 (37.7615570193592, -122.394380761457) 10 3 8 28856 29
102215 67601 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 559 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1992 12:00:00 AM 13   Permit Number 31171 6013574.79686 2104468.1921 37.7592324301472 -122.396098384735 (37.7592324301472, -122.396098384735) 10 3 8 28856 29
45524 67540 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 619 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM 5   Permit Number 31080 6012728.40675 2104463.00984 37.7591710721042 -122.399025265205 (37.7591710721042, -122.399025265205) 10 3 8 28856 29
141895 67581 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 321 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM 10   Permit Number 31145 6013230.15205 2105558.36958 37.7622066365616 -122.39736679307 (37.7622066365616, -122.39736679307) 10 3 8 28856 29
194421 257937 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 430 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2020 12:00:00 AM 3 3x3   6005729.4209 2111051.1148 37.7768679337671 -122.423699563703 (37.7768679337671, -122.423699563703) 7 9 11 28852 10
113498 67792 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 4252 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/2009 12:00:00 AM 2 3x3 Permit Number 52966 6002229.57555078 2101227.41307609 37.7496962578989 -122.435103788069 (37.7496962578989, -122.435103788069) 2 4 5 28862 22
25889 52052 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 84 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/2005 12:00:00 AM     Permit Number 48254 6005362.31259493 2099645.76538508 37.7455308063117 -122.424158182307 (37.7455308063117, -122.424158182307) 2 7 5 28859 22
146209 74729 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 3174-3190 25th St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/29/1996 12:00:00 AM       6008516.4229759 2101575.33994414 37.7510065716159 -122.413388156863 (37.7510065716159, -122.413388156863) 2 4 7 28859 19
121545 104351 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3732 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/24/2013 12:00:00 AM   3x3 Permit Number 769484 6005428.9 2104316.5 37.7583593225521 -122.424260064239 (37.7583593225521, -122.424260064239) 2 4 5 28859 19
174641 67525 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1237 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/22/1992 12:00:00 AM 5   Permit Number 31063 6013863.96904 2105222.10332 37.7613185911004 -122.395151089252 (37.7613185911004, -122.395151089252) 10 3 8 28856 29
10372 260929 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 925 Cole St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/21/2019 12:00:00 AM 3     5998050.49977 2107087.50026 37.7655484062222 -122.449977421621 (37.7655484062222, -122.449977421621) 15 5 11 29492 9
10488 260919 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 630 Cole St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/21/2019 12:00:00 AM 3     5997903.7812 2108434.36371 37.7692381539002 -122.450581995995 (37.7692381539002, -122.450581995995) 15 5 11 29492 9
16507 260930 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 515 Shrader St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/21/2019 12:00:00 AM 3     5997474.23163 2108775.61542 37.7701505477721 -122.452092402813 (37.7701505477721, -122.452092402813) 15 5 11 29492 9
6402 94573 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3978 18th St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/2010 12:00:00 AM   3x3 Permit Number 53752 6003116 2105363 37.761101890414 -122.432333828196 (37.761101890414, -122.432333828196) 15 4 5 28862 3
24874 37335 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 822 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/2010 12:00:00 AM   3x3 Permit Number 53759 6003062.69037898 2103433.56920909 37.7558011125208 -122.432380395486 (37.7558011125208, -122.432380395486) 2 4 5 28862 22
58895 94579 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 615 Noe St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/2010 12:00:00 AM   3x3 Permit Number 53757 6003043 2104661 37.7591702275755 -122.432536159886 (37.7591702275755, -122.432536159886) 2 4 5 28862 3
104313 226800 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 611 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/20/2010 12:00:00 AM 3 Width 3ft Permit Number 53757 6003049.61247 2104666.39775 37.7591854234811 -122.432513676359 (37.7591854234811, -122.432513676359) 2 4 5 28862 3
183347 68748 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3974 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/2010 12:00:00 AM   3x3 Permit Number 53751 6003148.31037661 2105371.6272327 37.7611274107355 -122.432222696746 (37.7611274107355, -122.432222696746) 15 4 5 28862 3
147729 54450 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 435 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/2008 12:00:00 AM 2 3x3 Permit Number 51720 6011224.5432 2106327.02843 37.7642053321404 -122.40435757586 (37.7642053321404, -122.40435757586) 8 3 8 28856 29
685 151339 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 1411 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2019 12:00:00 AM 3 6x6 Permit Number 781016 6009578.8057 2100900.01209 37.7492118628581 -122.409666655187 (37.7492118628581, -122.409666655187) 2 4 7 28859 19
61281 58816 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1939 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/1992 12:00:00 AM 11   Permit Number 31012 6012209.88383 2104659.20803 37.7596808806999 -122.400832361144 (37.7596808806999, -122.400832361144) 10 3 8 28856 29
187364 67473 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 880 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/1992 12:00:00 AM 6   Permit Number 30995 6012731.18304 2103360.24925 37.7561432876862 -122.398938264795 (37.7561432876862, -122.398938264795) 10 3 8 28856 29
191321 52004 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1242 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/06/2005 12:00:00 AM 3   Permit Number 48221 6012214.20801 2102602.19108 37.7540330051314 -122.400672898747 (37.7540330051314, -122.400672898747) 10 3 8 28856 29
72482 64228 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 24 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2012 12:00:00 AM     Permit Number 769264 6003122.11049357 2108174.45220479 37.7688218028269 -122.43251351352 (37.7688218028269, -122.43251351352) 15 5 5 28862 3
50377 18386 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 816 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/03/1997 12:00:00 AM 12 3X3   6010411.4798 2104364.47697 37.7587711399879 -122.407031402383 (37.7587711399879, -122.407031402383) 10 4 7 28859 19
84643 57319 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2719 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/1976 12:00:00 AM 2   Permit Number 16144 5999557.8231 2113954.6853 37.7844900782456 -122.445257725615 (37.7844900782456, -122.445257725615) 15 6 11 29490 31
35462 50281 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2890 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM     Permit Number 46985 6009507.79940806 2102799.18720578 37.7544225953783 -122.410046254665 (37.7544225953783, -122.410046254665) 2 4 7 28859 19
173888 51288 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1143 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/2004 12:00:00 AM     Permit Number 47660 6009497.00762937 2102519.03673443 37.7536527600356 -122.410063798952 (37.7536527600356, -122.410063798952) 2 4 7 28859 19
16474 253340 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 1045 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2017 12:00:00 AM 3 3x3 Permit Number 780536 6004464 2102825 37.7542094840672 -122.427490860103 (37.7542094840672, -122.427490860103) 2 4 5 28862 22
158498 35323 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 209 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/2002 12:00:00 AM     Permit Number 45862 6006709.88986016 2104895.8779561 37.76002240815 -122.419870939027 (37.76002240815, -122.419870939027) 2 4 7 28859 19
35141 32262 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 10 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/1995 12:00:00 AM 3   Permit Number 35561 6005748.8799 2099664.71545 37.7456046578383 -122.422822837406 (37.7456046578383, -122.422822837406) 2 7 5 28859 22
61958 34774 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1139 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/1999 12:00:00 AM     Permit Number 38415 6008083.82317224 2101294.64403942 37.750211545435 -122.414864270544 (37.750211545435, -122.414864270544) 2 4 7 28859 19
104 260590 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3099x Jennings St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/20/2020 12:00:00 AM 3                        
12203 260589 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3099x Jennings St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/20/2020 12:00:00 AM 3                        
12527 260588 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3099x Jennings St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/20/2020 12:00:00 AM 3                        
130836 62086 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 508 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1985 12:00:00 AM 4   Permit Number 22172 6013224.51154 2104585.93548 37.7595362319382 -122.397318105545 (37.7595362319382, -122.397318105545) 10 3 8 28856 29
23830 34752 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 667 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2000 12:00:00 AM     Permit Number 38399 6007930.97034241 2104052.78354238 37.7577761801817 -122.415588103657 (37.7577761801817, -122.415588103657) 2 4 7 28859 19
59383 34753 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 667 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2000 12:00:00 AM     Permit Number 38399 6007930.97034241 2104052.78354238 37.7577761801817 -122.415588103657 (37.7577761801817, -122.415588103657) 2 4 7 28859 19
13592 162301 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 238 Olmstead St 1 Sidewalk: Property side : Cutout Tree Private 2   08/17/2019 12:00:00 AM 3 Width 0ft   6010941.2062 2091035.49966 37.7222022558199 -122.404261226995 (37.7222022558199, -122.404261226995) 10 3 7 309 28
90056 28275 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 304 Winfield St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/17/2016 12:00:00 AM 6 2X3   6006647.7252044 2098034.3646343 37.7411787556411 -122.419599108791 (37.7411787556411, -122.419599108791) 2 7 7 28859 2
94159 97024 Property Tree 8 Jacaranda mimosifolia :: Jacaranda 50 1455 Alabama St   Sidewalk: Curb side : Cutout Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768189 6009349 2100759.5 37.7488131674601 -122.410451409671 (37.7488131674601, -122.410451409671) 2 4 7 28859 19
122314 97023 Property Tree 8 Jacaranda mimosifolia :: Jacaranda 50 1443 Alabama St   Sidewalk: Curb side : Cutout Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768190 6009347.4 2100788.9 37.7488938036461 -122.410459018192 (37.7488938036461, -122.410459018192) 2 4 7 28859 19
2489 224583 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2701 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 12:00:00 AM 3 6x3 Permit Number 781047 6008562.45401 2106796.83945 37.7653462039852 -122.413598242063 (37.7653462039852, -122.413598242063) 8 4 7 28859 19
14632 224584 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2701 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 12:00:00 AM 3 6x3 Permit Number 781047 6008542.99689 2106795.22797 37.76534068665 -122.413665425938 (37.76534068665, -122.413665425938) 8 4 7 28859 19
15185 223092 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2719 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 12:00:00 AM 3 3x3 Permit Number 782363 6010376.57029 2102801.69474 37.7544781353795 -122.407041982913 (37.7544781353795, -122.407041982913) 10 4 7 28859 19
17882 240751 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2500 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 12:00:00 AM 3 Width 3ft   6008841.50071 2103703.05088 37.7568670332937 -122.412414380831 (37.7568670332937, -122.412414380831) 2 4 7 28859 19
8056 224581 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2701 16th St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 09:45:00 PM 3 6x3 Permit Number 781047 6008597.08192 2106800.15076 37.7653572404576 -122.413478706001 (37.7653572404576, -122.413478706001) 8 4 7 28859 19
19464 224582 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2701 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 09:45:00 PM 3 6x3 Permit Number 781047 6008579.87348 2106797.48808 37.7653489631036 -122.413538037855 (37.7653489631036, -122.413538037855) 8 4 7 28859 19
1698 244767 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2500 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 09:35:00 PM 3 Width 3ft   6008837.10491 2103758.81421 37.7570199000752 -122.412433524704 (37.7570199000752, -122.412433524704) 2 4 7 28859 19
70598 40721 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 58 Bronte St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/12/1999 12:00:00 AM     Permit Number 41700 6009320.76573459 2097115.38530681 37.7388056449049 -122.410291784296 (37.7388056449049, -122.410291784296) 10 7 7 28859 2
74571 40729 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 23 Porter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/12/1999 12:00:00 AM     Permit Number 41708 6007052.60593678 2095671.4040371 37.7347133867785 -122.418031698759 (37.7347133867785, -122.418031698759) 2 7 7 28859 2
9710 239955 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3448 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2017 12:00:00 AM 3 2x3 Permit Number 50576 6006541.34834 2105555.19292 37.7618232366876 -122.420500644884 (37.7618232366876, -122.420500644884) 8 4 7 28859 19
40910 50150 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 541@ 20TH ST Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/07/2003 12:00:00 AM 6   Permit Number 46869 6014129.22762 2104572.8122 37.7595505266559 -122.394188205843 (37.7595505266559, -122.394188205843) 10 3 8 28856 29
68317 228832 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 517 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2018 12:00:00 AM 3 4x4   6006836.21643 2100716.23735 37.7485531903885 -122.419137558645 (37.7485531903885, -122.419137558645) 2 4 7 28859 19
176666 96068 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1055 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2011 12:00:00 AM   3x3 Permit Number 767693 6008044 2101787 37.7515612062089 -122.415036827298 (37.7515612062089, -122.415036827298) 2 4 7 28859 19
30569 44068 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 304 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/02/2003 12:00:00 AM     Permit Number 43592 6006646.88740951 2098034.91768842 37.741180227012 -122.419602044821 (37.741180227012, -122.419602044821) 2 7 7 28859 2
181781 49967 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3228@ PRECITA Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/02/2003 12:00:00 AM     Permit Number 46719 6008983.82935555 2099882.83427264 37.7463855595114 -122.411652240395 (37.7463855595114, -122.411652240395) 2 7 7 28859 2
27597 34735 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3246 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38385 6008060.11038004 2101550.08300487 37.7509115908716 -122.41496434851 (37.7509115908716, -122.41496434851) 2 4 7 28859 19
35536 34771 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1112 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 11   Permit Number 38413 6008023.83866277 2101437.17080746 37.7505995211504 -122.415081788574 (37.7505995211504, -122.415081788574) 2 4 7 28859 19
56905 34792 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1171 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38428 6008691.00817577 2101734.24862099 37.7514527000041 -122.412795655117 (37.7514527000041, -122.412795655117) 2 4 7 28859 19
67944 34742 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2901 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38391 6008387.19520521 2101524.63770013 37.7508600981217 -122.413831454694 (37.7508600981217, -122.413831454694) 2 4 7 28859 19
93171 34746 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2633 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38394 6008932.99171324 2103129.73681544 37.7552979763123 -122.412057454279 (37.7552979763123, -122.412057454279) 2 4 7 28859 19
94268 34748 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2752 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 1 5x12 Permit Number 38396 6008918.26554882 2102430.84513518 37.7533781509064 -122.412058993069 (37.7533781509064, -122.412058993069) 2 4 7 28859 19
98393 34741 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2901 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38391 6008387.19520521 2101524.63770013 37.7508600981217 -122.413831454694 (37.7508600981217, -122.413831454694) 2 4 7 28859 19
101742 34743 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2901 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38391 6008387.19520521 2101524.63770013 37.7508600981217 -122.413831454694 (37.7508600981217, -122.413831454694) 2 4 7 28859 19
117197 34779 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1153 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38418 6008088.1654875 2101216.34832832 37.7499968070134 -122.414843713866 (37.7499968070134, -122.414843713866) 2 4 7 28859 19
117701 34729 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3171 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38382 6008528.73936526 2101523.94206267 37.7508661360797 -122.413341931038 (37.7508661360797, -122.413341931038) 2 4 7 28859 19
121695 34770 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1112 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 11   Permit Number 38413 6008023.83866277 2101437.17080746 37.7505995211504 -122.415081788574 (37.7505995211504, -122.415081788574) 2 4 7 28859 19
124310 34772 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1112 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 11   Permit Number 38413 6008023.83866277 2101437.17080746 37.7505995211504 -122.415081788574 (37.7505995211504, -122.415081788574) 2 4 7 28859 19
126449 34733 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1417 Valencia St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1997 12:00:00 AM     Permit Number 38383 6006486.84635329 2101329.65317057 37.7502178094357 -122.420389210833 (37.7502178094357, -122.420389210833) 2 4 7 28859 19
137953 34734 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3175 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38384 6008507.54779719 2101522.76910569 37.7508617255783 -122.413415130751 (37.7508617255783, -122.413415130751) 2 4 7 28859 19
141115 34778 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1153 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38418 6008088.1654875 2101216.34832832 37.7499968070134 -122.414843713866 (37.7499968070134, -122.414843713866) 2 4 7 28859 19
146261 34732 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1417 Valencia St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1997 12:00:00 AM     Permit Number 38383 6006486.84635329 2101329.65317057 37.7502178094357 -122.420389210833 (37.7502178094357, -122.420389210833) 2 4 7 28859 19
153942 34730 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1417 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1997 12:00:00 AM     Permit Number 38383 6006486.84635329 2101329.65317057 37.7502178094357 -122.420389210833 (37.7502178094357, -122.420389210833) 2 4 7 28859 19
156928 34731 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1417 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1997 12:00:00 AM     Permit Number 38383 6006486.84635329 2101329.65317057 37.7502178094357 -122.420389210833 (37.7502178094357, -122.420389210833) 2 4 7 28859 19
182567 34728 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3171 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38382 6008528.73936526 2101523.94206267 37.7508661360797 -122.413341931038 (37.7508661360797, -122.413341931038) 2 4 7 28859 19
183689 34745 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2531 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38393 6008900.83649709 2103723.81151617 37.756927366913 -122.4122106421 (37.756927366913, -122.4122106421) 2 4 7 28859 19
991 38251 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1475 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40361 6007534.04468586 2107333.12590687 37.7667609198383 -122.417193284079 (37.7667609198383, -122.417193284079) 8 4 7 28853 19
130713 38280 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 651 Texas St 9 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1998 12:00:00 AM 12   Permit Number 40367 6013876.1493 2104054.99501 37.7581146430008 -122.395027213942 (37.7581146430008, -122.395027213942) 10 3 8 28856 29
137130 38274 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 645 Texas St 9 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1998 12:00:00 AM     Permit Number 40367 6014125.41454299 2103884.52035605 37.7576604143577 -122.394153206319 (37.7576604143577, -122.394153206319) 10 3 8 28856 29
155492 38276 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 651 Texas St 10 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1998 12:00:00 AM 3   Permit Number 40367 6013924.79961 2103962.8321 37.7578642888268 -122.394852504434 (37.7578642888268, -122.394852504434) 10 3 8 28856 29
157743 38250 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1471 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40360 6007553.94098134 2107334.22981902 37.7667650702265 -122.417124544174 (37.7667650702265, -122.417124544174) 8 4 7 28853 19
184588 38249 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1471 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40360 6007553.94098134 2107334.22981902 37.7667650702265 -122.417124544174 (37.7667650702265, -122.417124544174) 8 4 7 28853 19
39242 49995 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 908@ 20TH ST Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2003 12:00:00 AM 7   Permit Number 46738 6011567.97706 2104146.58896 37.7582375173758 -122.403016353927 (37.7582375173758, -122.403016353927) 10 3 8 28856 29
93777 32977 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 448 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2003 12:00:00 AM 4   Permit Number 46744 6014321.91414 2105021.23892 37.7607925173727 -122.393553179256 (37.7607925173727, -122.393553179256) 10 3 8 28856 29
147463 49994 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 908@ 20TH ST Kansas St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2003 12:00:00 AM 8   Permit Number 46738 6011568.01566 2104131.09801 37.7581949848158 -122.403015130859 (37.7581949848158, -122.403015130859) 10 3 8 28856 29
53978 34556 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2 Nebraska St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1997 12:00:00 AM     Permit Number 38265 6009291.02762051 2098031.45158376 37.7413192965243 -122.410459272722 (37.7413192965243, -122.410459272722) 10 7 7 28859 2
168394 34557 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2 Nebraska St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1997 12:00:00 AM     Permit Number 38265 6009291.02762051 2098031.45158376 37.7413192965243 -122.410459272722 (37.7413192965243, -122.410459272722) 10 7 7 28859 2
75595 63245 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3676 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/23/1988 12:00:00 AM 3 3x3 Permit Number 24178 6005805.15699581 2104348.35401431 37.7584680245234 -122.422961063691 (37.7584680245234, -122.422961063691) 2 4 5 28859 19
85315 33045 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 435 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/2000 12:00:00 AM     Permit Number 37322 6005530.37891091 2101176.15171839 37.7497423846708 -122.423685826158 (37.7497423846708, -122.423685826158) 2 4 5 28859 19
2916 53252 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 18 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1969 12:00:00 AM 7   Permit Number 6139 6004056.10022951 2102948.9340362 37.754526698445 -122.428910313961 (37.754526698445, -122.428910313961) 2 4 5 28862 22

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