trees

1,521 rows where qSpecies_id = 37 sorted by Police Districts

✎ View and edit SQL

This data as json, CSV (advanced)

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)
1055 35449 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 10 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
1179 251578 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 6 Median : Cutout Tree DPW 1                              
1581 19590 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 100 STAIRWAY4 13 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
1619 95785 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 347 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2011 12:00:00 AM   3x3 Permit Number 767529                    
1648 35048 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 700 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
1759 35455 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 12 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
4255 19806 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 100 STAIRWAY23 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 60ST                      
5065 35446 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 13 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
5174 35453 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
6154 35450 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
6797 35457 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
7338 35458 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
8645 35454 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
9213 35448 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 11 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
9360 35444 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 17 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
9761 19588 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 100 STAIRWAY4 11 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
10105 35452 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
10497 35451 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
10741 19589 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 100 STAIRWAY4 12 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
12586 37973 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 630 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/1998 12:00:00 AM     Permit Number 40203                    
13454 35445 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 18 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
15277 37971 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 620 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/1998 12:00:00 AM     Permit Number 40201                    
15848 35456 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
16975 35442 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 14 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
16978 37972 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 624 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/1998 12:00:00 AM     Permit Number 40202                    
16995 35459 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 15 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
17365 35447 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 19 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
17582 35443 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 16 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
18523 35047 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 700 Peninsula Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
19069 35460 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
19546 19591 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 100 STAIRWAY4 14 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
9902 258348 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1760 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/1988 12:00:00 AM   3x3 Permit Number 25361 6009198 2119365 37.7998910391876 -122.412288414988 (37.7998910391876, -122.412288414988) 3 1 10 308 4
10294 129716 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1087 Chestnut St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6006809.35 2120459.56601 37.8027621146536 -122.420631800213 (37.8027621146536, -122.420631800213) 5 1 1 28858 32
13561 129718 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1087 Chestnut St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6006845.74669 2120464.39586 37.8027774273877 -122.420506191927 (37.8027774273877, -122.420506191927) 5 1 1 28858 32
21514 129744 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1 John Maher St 13 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6012609.98453 2119710.6419 37.8010309565634 -122.400505885653 (37.8010309565634, -122.400505885653) 3 1 10 28860 6
26304 4719 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 6 Median : Cutout Tree DPW 1     70 3   6008486.129587 2120728.7244 37.803595514004 -122.414848331144 (37.803595514004, -122.414848331144) 5 1 10 308 23
30204 129724 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1055 Greenwich St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007826.23151 2119905.33102 37.8012975821652 -122.417073568702 (37.8012975821652, -122.417073568702) 5 1 1 308 32
32341 4731 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1175X Columbus Ave 2 Median : Cutout Tree DPW 1     14 3x3   6007886.21988 2121257.05551 37.8050124513131 -122.416961809043 (37.8050124513131, -122.416961809043) 5 1 10 308 32
32751 4718 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 5 Median : Cutout Tree DPW 1     80 3   6008205.1504 2120957.4944 37.8042078669522 -122.415836885075 (37.8042078669522, -122.415836885075) 5 1 10 308 23
34487 142721 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100x COLUMBUS AVE 1 Median : Cutout Tree DPW 1     17 Width 0ft   6008079.1516 2121077.7294 37.8045309177557 -122.416281435895 (37.8045309177557, -122.416281435895) 5 1 10 308 23
34668 4669 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 600X Columbus Ave 4 Median : Cutout Tree DPW 1   06/25/2014 12:00:00 AM 8 3 Permit Number 769286 6009537.0943 2119751.1708 37.8009703907309 -122.411142309711 (37.8009703907309, -122.411142309711) 3 1 10 308 23
40137 4634 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 500X Columbus Ave 1 Median : Cutout Tree DPW 1   08/19/2006 12:00:00 AM 8 3   6010031.5482 2119295.5915 37.799747198685 -122.409399111615 (37.799747198685, -122.409399111615) 3 1 10 308 4
40505 129715 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1087 Chestnut St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6006786.67092 2120456.10735 37.8027513398688 -122.420710035851 (37.8027513398688, -122.420710035851) 5 1 1 28858 32
42280 129720 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1087 Chestnut St 8 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6006876.11825 2120468.72973 37.8027910386287 -122.42040139843 (37.8027910386287, -122.42040139843) 5 1 1 28858 32
42311 142722 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100x COLUMBUS AVE 2 Median : Cutout Tree DPW 1     11 Width 0ft   6008044.6283 2121108.5348 37.8046135602745 -122.416403090609 (37.8046135602745, -122.416403090609) 5 1 10 308 23
44681 129743 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1 John Maher St 12 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6012600.30896 2119709.91151 37.8010284114971 -122.400539316148 (37.8010284114971, -122.400539316148) 3 1 10 28860 6
47997 4675 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 700X Columbus Ave 2 Median : Cutout Tree DPW 1   04/06/2013 12:00:00 AM 3 3x3   6009477.5527626 2119836.3917307 37.8012010470299 -122.41135437342 (37.8012010470299, -122.41135437342) 3 1 10 308 23
50207 129745 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1 John Maher St 14 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6012618.68817 2119711.1441 37.8010328208639 -122.400475802435 (37.8010328208639, -122.400475802435) 3 1 10 28860 6
50665 129713 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1087 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6006753.58301 2120450.79663 37.8027348930675 -122.420824159811 (37.8027348930675, -122.420824159811) 5 1 1 28858 32
53295 129723 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1055 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007809.59166 2119903.72607 37.8012922393028 -122.417131036286 (37.8012922393028, -122.417131036286) 5 1 1 308 32
55638 129730 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 332 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6011945.29217 2119133.13593 37.7994081740128 -122.40276538192 (37.7994081740128, -122.40276538192) 3 1 10 308 23
60344 129721 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1087 Chestnut St 9 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6006892.13335 2120470.8795 37.8027978438157 -122.420346130572 (37.8027978438157, -122.420346130572) 5 1 1 28858 32
63710 4716 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 3 Median : Cutout Tree DPW 1     70 3   6008306.8566 2120868.0824 37.8039680812692 -122.415478587922 (37.8039680812692, -122.415478587922) 5 1 10 308 23
65821 4736 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100X Columbus Ave 7 Median : Cutout Tree DPW 1     60 3x3   6008154.5819477 2121037.0963081 37.8044235907504 -122.41601752221 (37.8044235907504, -122.41601752221) 5 1 10 308 23
69636 258346 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1760 Mason St 1 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6009177.94606 2119334.21946 37.7998053981265 -122.412355632582 (37.7998053981265, -122.412355632582) 3 1 10 308 4
72793 4635 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 500X Columbus Ave 2 Median : Cutout Tree DPW 1   01/05/1990 12:00:00 AM 35 3   6010009.8735 2119314.4873 37.7997978674726 -122.409475448708 (37.7997978674726, -122.409475448708) 3 1 10 308 4
73122 4679 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 700X Columbus Ave 6 Median : Cutout Tree DPW 1   08/19/2006 12:00:00 AM 6 3x3   6009212.7257 2120043.218 37.8017540838713 -122.412285420728 (37.8017540838713, -122.412285420728) 3 1 10 308 4
73290 4674 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 700X Columbus Ave 1 Median : Cutout Tree DPW 1   09/05/1991 12:00:00 AM 15 3x4   6009400.8826 2119872.8379 37.8012968187356 -122.411622263241 (37.8012968187356, -122.411622263241) 3 1 10 308 23
74458 4670 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 610X Columbus Ave 5 Median : Cutout Tree DPW 1   02/13/2003 12:00:00 AM 12 3   6009783.7006387 2119558.1544154 37.8004542419844 -122.41027530759 (37.8004542419844, -122.41027530759) 3 1 10 308 23
78180 129740 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1 John Maher St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6012353.73266 2119674.76843 37.8009181627066 -122.401390109871 (37.8009181627066, -122.401390109871) 3 1 10 28860 6
79315 4668 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 600X Columbus Ave 3 Median : Cutout Tree DPW 1     60 3   6009590.6555 2119701.3035 37.8008364710267 -122.410953440286 (37.8008364710267, -122.410953440286) 3 1 10 308 23
81901 4714 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 1 Median : Cutout Tree DPW 1     80 3   6008373.9156 2120808.2881 37.8038076701269 -122.415242289828 (37.8038076701269, -122.415242289828) 5 1 10 308 23
88615 69193 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1151 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/31/1994 12:00:00 AM 8   Permit Number 33239 6008629.33261 2117936.93941 37.7959380121873 -122.414155135563 (37.7959380121873, -122.414155135563) 5 1 10 308 21
90376 129738 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 6 John Maher St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6012361.06687 2119691.76403 37.8009652377192 -122.401365925298 (37.8009652377192, -122.401365925298) 3 1 10 28860 6
92139 129746 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1310 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6011484.09994 2119879.99013 37.801433092922 -122.404413877014 (37.801433092922, -122.404413877014) 3 1 10 308 23
94507 129729 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 332 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6011961.72119 2119134.66813 37.7994132983523 -122.402708639193 (37.7994132983523, -122.402708639193) 3 1 10 308 23
95326 4717 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 4 Median : Cutout Tree DPW 1   08/19/2006 12:00:00 AM 6 3   6008242.0329 2120925.0825 37.804120945419 -122.415706953629 (37.804120945419, -122.415706953629) 5 1 10 308 23
100388 129727 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 333 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6011976.37318 2119087.45755 37.7992844875525 -122.402654616021 (37.7992844875525, -122.402654616021) 3 1 10 308 23
100453 129726 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1055 Greenwich St 6 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007892.05327 2119913.90484 37.8013248262425 -122.416846403543 (37.8013248262425, -122.416846403543) 5 1 1 308 32
102894 258349 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1760 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009198 2119365 37.7998910391876 -122.412288414988 (37.7998910391876, -122.412288414988) 3 1 10 308 4
104796 4667 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 600X Columbus Ave 2 Median : Cutout Tree DPW 1   10/03/2012 12:00:00 AM 12 3 Permit Number 769286 6009690.8519 2119608.7257 37.8005878932088 -122.410600176031 (37.8005878932088, -122.410600176031) 3 1 10 308 23
115114 4734 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100X Columbus Ave 5 Median : Cutout Tree DPW 1     60 3x3   6007950.0877 2121194.0464 37.8048430366334 -122.416736319981 (37.8048430366334, -122.416736319981) 5 1 10 308 23
122218 129732 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 332 Vallejo St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6011915.1636 2119126.05063 37.799387037239 -122.40286913942 (37.799387037239, -122.40286913942) 3 1 10 308 23
122350 129737 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 6 John Maher St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6012370.9979 2119693.9388 37.8009717631911 -122.401331712415 (37.8009717631911, -122.401331712415) 3 1 10 28860 6
124962 129736 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 John Maher St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6012597.85597 2119726.16529 37.8010729036559 -122.400548947 (37.8010729036559, -122.400548947) 3 1 10 28860 6
129365 13002 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 359 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/23/1995 12:00:00 AM 8 3X3   6010611.1408 2120633.1017 37.8034521300977 -122.407487846811 (37.8034521300977, -122.407487846811) 3 1 10 308 23
130870 4638 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 500X Columbus Ave 5 Median : Cutout Tree DPW 1     60 3   6009905.4204 2119408.7236 37.8000507639755 -122.40984355245 (37.8000507639755, -122.40984355245) 3 1 10 308 4
135295 4636 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 500X Columbus Ave 3 Median : Cutout Tree DPW 1     45 3   6009974.2224 2119345.7236 37.7998816370329 -122.409601021151 (37.7998816370329, -122.409601021151) 3 1 10 308 4
135694 4730 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1175X Columbus Ave 1 Median : Cutout Tree DPW 1     100 3x3   6007911.57425 2121225.41132 37.8049269905411 -122.41687182377 (37.8049269905411, -122.41687182377) 5 1 10 308 32
137251 129731 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 332 Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6011929.52293 2119129.49117 37.7993972859062 -122.402819692899 (37.7993972859062, -122.402819692899) 3 1 10 308 23
139549 129719 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1087 Chestnut St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6006860.09044 2120465.96022 37.8027825310508 -122.420456666246 (37.8027825310508, -122.420456666246) 5 1 1 28858 32
147987 4666 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 600X Columbus Ave 1 Median : Cutout Tree DPW 1   10/03/2012 12:00:00 AM 60 3 Permit Number 769286 6009738.4106 2119565.7843 37.8004726529456 -122.41043256902 (37.8004726529456, -122.41043256902) 3 1 10 308 23
151815 129717 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1087 Chestnut St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6006827.22257 2120461.26491 37.8027677866551 -122.420570072569 (37.8027677866551, -122.420570072569) 5 1 1 28858 32
155443 4676 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 700X Columbus Ave 3 Median : Cutout Tree DPW 1     24 3x4   6009334.3928 2119933.7869 37.8014604396574 -122.411856657471 (37.8014604396574, -122.411856657471) 3 1 10 308 23
155755 129725 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1055 Greenwich St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007869.33544 2119911.25736 37.8013162790827 -122.416924829814 (37.8013162790827, -122.416924829814) 5 1 1 308 32
158468 129734 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 John Maher St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6012615.27565 2119730.0838 37.8010846344059 -122.400488942433 (37.8010846344059, -122.400488942433) 3 1 10 28860 6
161212 4639 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 500X Columbus Ave 6 Median : Cutout Tree DPW 1     75 3   6009873.724 2119435.9713 37.8001238030697 -122.409955159162 (37.8001238030697, -122.409955159162) 3 1 10 308 4
165158 30568 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 2681 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 34545 6008703.52928477 2122408.3500681 37.8082195561589 -122.414214912471 (37.8082195561589, -122.414214912471) 3 1 10 308 23
167216 129714 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1087 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6006770.61766 2120452.09935 37.8027394301331 -122.420765303696 (37.8027394301331, -122.420765303696) 5 1 1 28858 32
168231 4733 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100X Columbus Ave 4 Median : Cutout Tree DPW 1     20 3x3   6007980.3619 2121165.8966 37.8047674470958 -122.416629557244 (37.8047674470958, -122.416629557244) 5 1 10 308 23
172831 4637 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 500X Columbus Ave 4 Median : Cutout Tree DPW 1     60 3   6009937.8119 2119380.0857 37.7999739465801 -122.409729442456 (37.7999739465801, -122.409729442456) 3 1 10 308 4
173855 4732 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100X Columbus Ave 3 Median : Cutout Tree DPW 1     14 3x3   6008014.3541 2121137.2157 37.8046906082857 -122.416509890538 (37.8046906082857, -122.416509890538) 5 1 10 308 23
182835 75814 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 300X Vallejo St 7 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2013 12:00:00 AM     Permit Number 769917 6011998.05472036 2119270.81717993 37.7997891592695 -122.402592490972 (37.7997891592695, -122.402592490972) 3 1 10 308 23
183081 26685 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 610X Columbus Ave 6 Median : Cutout Tree DPW 1   01/27/1999 12:00:00 AM 20 3   6009783.7006387 2119558.1544154 37.8004542419844 -122.41027530759 (37.8004542419844, -122.41027530759) 3 1 10 308 23
183949 129739 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 6 John Maher St 7 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6012352.16177 2119689.7384 37.8009591789808 -122.401396598486 (37.8009591789808, -122.401396598486) 3 1 10 28860 6
185283 4715 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 2 Median : Cutout Tree DPW 1   08/19/2006 12:00:00 AM 6 3   6008330.3273 2120843.4941 37.8039018871772 -122.415395624015 (37.8039018871772, -122.415395624015) 5 1 10 308 32
187705 129722 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 998 Chestnut St 1 Sidewalk: Property side : Yard Tree Private 2     13 Width 3ft   6007108.76695 2120556.67401 37.8030456187175 -122.419602556719 (37.8030456187175, -122.419602556719) 5 1 1 28858 32
190204 129742 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1 John Maher St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6012372.32254 2119675.23965 37.8009204937473 -122.401325813756 (37.8009204937473, -122.401325813756) 3 1 10 28860 6
190277 129733 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 332 Vallejo St 6 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6011893.56883 2119123.92391 37.7993799919624 -122.402943715694 (37.7993799919624, -122.402943715694) 3 1 10 308 23
190710 129735 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 John Maher St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6012606.41703 2119728.02865 37.8010784974329 -122.400519452825 (37.8010784974329, -122.400519452825) 3 1 10 28860 6

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