trees

7,157 rows where qSpecies_id = 36 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)
808 19837 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 100 STAIRWAY25 21 Sidewalk: Curb side : Cutout Tree DPW 1     6 60X                      
1090 260553 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 151x Palm Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD 09/21/2019 12:00:00 AM 3                        
1751 121138 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1388x Minna St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2016 12:00:00 AM 3 3x3                      
2214 20033 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 100 STAIRWAY51 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 ST                      
5450 36847 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
5539 20007 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 100 STAIRWAY46 27 Sidewalk: Curb side : Cutout Tree DPW 1     6 2                      
5645 19799 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 100 STAIRWAY21 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
6426 36849 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   3 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
6811 36853 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   7 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
7680 259798 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 599x Brussels St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
7823 19798 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 100 STAIRWAY21 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
8244 20067 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 100 STAIRWAY54 14 Sidewalk: Curb side : Cutout Tree DPW 1     6 15ST                      
8526 20030 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 100 STAIRWAY51 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 ST                      
8598 121137 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1388x Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2016 12:00:00 AM 3 3x3                      
9496 36851 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   5 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
9583 259871 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 901x Rutland St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
9825 259868 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 99x Peabody St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
11236 36848 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   2 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
11314 36850 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   4 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
11320 87812 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 4850 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2008 12:00:00 AM   3x3 Permit Number 50626                    
12111 20037 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 100 STAIRWAY51 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 ST                      
12367 20005 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 100 STAIRWAY46 25 Sidewalk: Curb side : Cutout Tree DPW 1     6 2                      
12732 36844 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   8 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
13476 259858 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 200x Wilde Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
14719 20008 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 100 STAIRWAY46 28 Sidewalk: Curb side : Cutout Tree DPW 1     3 2                      
14729 259859 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 200x Wilde Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
15566 121139 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1388x Minna St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2016 12:00:00 AM 3 3x3                      
15705 260554 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 151x Palm Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD 08/26/2017 12:00:00 AM 3                        
15935 259870 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 99x Peabody St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
17026 259869 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 99x Peabody St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
17331 20381 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 262X Sunset Blvd 27 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
17894 20031 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 100 STAIRWAY51 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 ST                      
18045 36852 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   6 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
19332 20006 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 100 STAIRWAY46 26 Sidewalk: Curb side : Cutout Tree DPW 1     6 2                      
40765 32225 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 196 Riley Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/22/1995 12:00:00 AM     Permit Number 35544 5995435.34413163 2120227.18780964 37.8014764801815 -122.45997454226 (37.8014764801815, -122.45997454226) 11   1 61 30
100024 258333 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 215X Raccoon Dr 2 Sidewalk: Property side : Yard Tree Private 2   04/29/2019 12:00:00 AM 3 3X3 Permit Number 776074                    
135989 32223 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 196 Riley Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   08/22/1995 12:00:00 AM     Permit Number 35544 5995435.34413163 2120227.18780964 37.8014764801815 -122.45997454226 (37.8014764801815, -122.45997454226) 11   1 61 30
149059 32224 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 196 Riley Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/22/1995 12:00:00 AM     Permit Number 35544 5995435.34413163 2120227.18780964 37.8014764801815 -122.45997454226 (37.8014764801815, -122.45997454226) 11   1 61 30
172077 258332 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 215X Raccoon Dr 1 Sidewalk: Property side : Yard Tree Private 2   04/29/2019 12:00:00 AM 3 3X3 Permit Number 776074                    
1444 256097 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2 North Point St 15 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2020 12:12:00 PM 3 3x3   6010298.36751 2122029.07931 37.8072676263732 -122.408668755752 (37.8072676263732, -122.408668755752) 3 1 10 308 23
1827 133032 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1170 Clay St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009033.32157 2117038.62296 37.7934941386994 -122.412693713858 (37.7934941386994, -122.412693713858) 3 1 10 28857 21
2575 62964 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 75 Glover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/1986 12:00:00 AM 7   Permit Number 23350 6007969.66121 2118374.9398 37.7971035776345 -122.416468771935 (37.7971035776345, -122.416468771935) 5 1 10 28858 21
2728 73494 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1550 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6007943.92592 2117747.18516 37.7953784719812 -122.41651333244 (37.7953784719812, -122.41651333244) 5 1 10 28858 21
2859 31668 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 215#3 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1995 12:00:00 AM 11   Permit Number 35176 6010250.9256 2121284.082 37.8052193918816 -122.408780346054 (37.8052193918816, -122.408780346054) 3 1 10 308 23
3131 66639 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1047 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/05/1991 12:00:00 AM 8   Permit Number 29850 6008486.64732 2115539.47023 37.7893471345134 -122.414479125336 (37.7893471345134, -122.414479125336) 5 1 10 28858 21
3327 99692 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1550X Washington St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 2x2   6007274.7 2117123.2 37.7936275055362 -122.418784695641 (37.7936275055362, -122.418784695641) 5 1 10 28858 32
3738 120612 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2 North Point St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2020 12:15:00 PM 3 3x3   6010461.28086 2122053.16069 37.8073428708526 -122.408106655207 (37.8073428708526, -122.408106655207) 3 1 10 308 23
4265 129451 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1147 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2018 12:00:00 AM 3 3x3 Permit Number 779607 6007395.89235 2119499.90916 37.8001601781003 -122.418533970572 (37.8001601781003, -122.418533970572) 5 1 1 28858 32
4528 120611 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2 North Point St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2020 12:17:00 PM 3 3x3   6010487.77863 2122056.40729 37.8073532688065 -122.408015182448 (37.8073532688065, -122.408015182448) 3 1 10 308 23
4657 110962 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2025x Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008581.83695 2119828.07528 37.8011279340648 -122.414453362433 (37.8011279340648, -122.414453362433) 5 1 10 308 32
5801 68207 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2048 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1993 12:00:00 AM 10   Permit Number 31989 6009891.7858 2121179.0457 37.8049108661303 -122.410015779346 (37.8049108661303, -122.410015779346) 3 1 10 308 23
7757 133120 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2031 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007676.88675 2119304.67898 37.7996399400933 -122.417547774034 (37.7996399400933, -122.417547774034) 5 1 1 28858 32
7916 133157 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2200 Grant Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2020 12:39:00 PM 3 Width 4ft   6010238.59911 2122044.66703 37.8073070787122 -122.408876698811 (37.8073070787122, -122.408876698811) 3 1 10 308 23
8014 72029 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2049 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6007657.13445 2119469.15821 37.8000904473654 -122.417627788486 (37.8000904473654, -122.417627788486) 5 1 1 28858 32
8590 142524 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 14 Sidewalk: Curb side : Cutout Tree SFUSD 4   03/23/2016 02:52:00 PM 20 Width 0ft   6009733.2838 2121208.6135 37.8049831671154 -122.410566384357 (37.8049831671154, -122.410566384357) 3 1 10 308 23
9236 133244 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 221 Jackson St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/02/2018 12:00:00 AM 3 Width 3ft   6012682.67669 2118166.8825 37.7967962172142 -122.40014585736 (37.7967962172142, -122.40014585736) 3 1 10 28860 6
9892 258923 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 900 Hyde St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007771 2115657 37.7896296127826 -122.416963519552 (37.7896296127826, -122.416963519552) 13 1 10 28858 21
11158 70931 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1550 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6007940.72744 2117762.47273 37.7954202679833 -122.416525483181 (37.7954202679833, -122.416525483181) 5 1 10 28858 21
12731 107057 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 601X Davis St 2 Front Yard : Yard Tree Private 2   07/23/2014 12:00:00 AM 9   Permit Number 771755 6013145.32204 2118507.86888 37.7977582696821 -122.398568926718 (37.7977582696821, -122.398568926718) 3 1 10 28860 6
13305 133145 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 900 Front St 6 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6012734.11136 2119356.39641 37.8000652052121 -122.400051459122 (37.8000652052121, -122.400051459122) 3 1 10 28860 6
13445 133254 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 207 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6012977.55273 2118208.4936 37.7969269085009 -122.399128433635 (37.7969269085009, -122.399128433635) 3 1 10 28860 6
13807 71448 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1030 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6011614.73256 2118874.74994 37.7986802465545 -122.403891048929 (37.7986802465545, -122.403891048929) 3 1 10 308 23
15016 261205 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 2301 Leavenworth St 2 Side Yard : Yard Tree Private 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
15390 60892 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 940 Filbert St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/11/1983 12:00:00 AM 16 5x5 Permit Number 20677 6008514.66964 2119698.45237 37.8007682484075 -122.414676612845 (37.8007682484075, -122.414676612845) 5 1 10 308 32
15909 133179 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 150 Francisco St 14 Front Yard : Yard Tree Private 2     4     6010446.38311 2121337.68774 37.8053775257257 -122.408107720898 (37.8053775257257, -122.408107720898) 3 1 10 308 23
16037 135812 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1147 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 779607 6007418.27175 2119501.50723 37.8001658258642 -122.418456642358 (37.8001658258642, -122.418456642358) 5 1 1 28858 32
16340 96970 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 900 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     8   Permit Number 17188 6009149.94694 2116056.12479 37.7908029831285 -122.412220707334 (37.7908029831285, -122.412220707334) 5 1 10 28857 21
16511 72028 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2034 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6007710.76257 2119396.18485 37.7998930983429 -122.417437039611 (37.7998930983429, -122.417437039611) 5 1 1 308 32
16593 133150 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 240 Vallejo St 5 Sidewalk: Curb side : Yard Tree Private 2     8 Width 8ft   6012279.1399 2119168.16848 37.7995229994372 -122.401612607536 (37.7995229994372, -122.401612607536) 3 1 10 28860 6
16736 73545 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1620 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6007910.76881 2117984.0068 37.7960268607141 -122.4166448466 (37.7960268607141, -122.4166448466) 5 1 10 28858 21
17448 133232 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 640 Front St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6012837.89426 2118606.89163 37.7980130305278 -122.399639674828 (37.7980130305278, -122.399639674828) 3 1 10 28860 6
17614 133070 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1113 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008218.03134 2118571.19198 37.79765640168 -122.415623250015 (37.79765640168, -122.415623250015) 5 1 10 28858 21
17836 72303 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 665 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6009725.8283 2120167.3092 37.8021235862289 -122.410518608839 (37.8021235862289, -122.410518608839) 3 1 10 308 23
18134 133248 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 221 Jackson St 9 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6012761.91766 2118178.24274 37.796831827677 -122.399872461643 (37.796831827677, -122.399872461643) 3 1 10 28860 6
18275 110955 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 940 Filbert St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   9 5x5   6008486.88199 2119694.39066 37.8007555347125 -122.414772482377 (37.8007555347125, -122.414772482377) 5 1 10 308 32
19619 133182 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 165 Francisco St 3 Front Yard : Yard Tree Private 2     5     6010494.593 2121305.47712 37.8052917825441 -122.4079386106 (37.8052917825441, -122.4079386106) 3 1 10 308 23
19651 143153 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2090 Grant Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6010318.2551 2121458.3909 37.8057017717955 -122.408559646613 (37.8057017717955, -122.408559646613) 3 1 10 308 23
19835 133137 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2801 Leavenworth St 7 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6007292.2429 2122109.53275 37.8073197069963 -122.419077842767 (37.8073197069963, -122.419077842767) 5 1 1 308 32
19887 30431 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 255 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1956 12:00:00 AM 9   Permit Number 84 6010587.196 2120972.0532 37.8043814669615 -122.407594621587 (37.8043814669615, -122.407594621587) 3 1 10 308 23
19899 109490 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1315x PINE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007628 2115744 37.789860448493 -122.417464454457 (37.789860448493, -122.417464454457) 13 1 10 28858 21
20915 133143 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 900 Front St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6012737.74039 2119327.45477 37.7999859407596 -122.400036867607 (37.7999859407596, -122.400036867607) 3 1 10 28860 6
21316 249915 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 356 Greenwich St 4 Front Yard : Yard Tree Private 2     8 Width 0ft   6011213.4228 2120410.23377 37.8028738823843 -122.405387909344 (37.8028738823843, -122.405387909344) 3 1 10 308 23
21601 133071 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1113 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008234.06247 2118574.57277 37.7976665856107 -122.415568017275 (37.7976665856107, -122.415568017275) 5 1 10 28858 21
22258 133152 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 240 Vallejo St 9 Sidewalk: Curb side : Yard Tree Private 2     12 Width 10ft   6012234.00402 2119168.15298 37.7995204381723 -122.401768793705 (37.7995204381723, -122.401768793705) 3 1 10 28860 6
22612 91357 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2121 Leavenworth St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2009 12:00:00 AM   3x3 Permit Number 52063 6007640 2119628 37.8005256228645 -122.41769834526 (37.8005256228645, -122.41769834526) 5 1 1 28858 32
24599 133170 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1900 The Embarcadero 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6010397.4572 2122193.47677 37.8077245700979 -122.408337435631 (37.8077245700979, -122.408337435631) 3 1 10 308 23
24675 103503 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1028 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009840.22204 2116824.48974 37.7929514356157 -122.409886641058 (37.7929514356157, -122.409886641058) 3 1 10 28857 21
24846 99691 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1550X Washington St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   14 3x3   6007274.7 2117123.2 37.7936275055362 -122.418784695641 (37.7936275055362, -122.418784695641) 5 1 10 28858 32
24891 61253 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2038 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/1983 12:00:00 AM 8   Permit Number 21134 6007708.75142 2119423.18068 37.7999671089664 -122.417445913212 (37.7999671089664, -122.417445913212) 5 1 1 308 32
24959 98573 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
25380 116004 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 945 Front St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6012685.45612 2119344.92547 37.8000309958941 -122.400219019899 (37.8000309958941, -122.400219019899) 3 1 10 28860 6
25459 142601 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 700 CHESTNUT ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6008384.8631 2120724.794 37.8035790315569 -122.415198491391 (37.8035790315569, -122.415198491391) 5 1 10 308 32
25687 120610 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2 North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6010501.50248 2122058.02124 37.8073584686759 -122.407967801668 (37.8073584686759, -122.407967801668) 3 1 10 308 23
25938 133194 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 199 Union St 2 Sidewalk: Property side : Yard Tree Private 2     20     6012010.58946 2119782.84112 37.8011957528417 -122.402585141603 (37.8011957528417, -122.402585141603) 3 1 10 28860 6
27221 133034 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1140 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008647.68395 2117973.21451 37.7960386454118 -122.414094203805 (37.7960386454118, -122.414094203805) 5 1 10 308 21
27913 142912 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1365x Kearny St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6010980 2119621 37.8006937860332 -122.406140040303 (37.8006937860332, -122.406140040303) 3 1 10 308 23
28656 133141 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 407 Vallejo St 1 Sidewalk: Curb side : Yard Tree Private 2     19     6011477.96138 2119029.17792 37.7990966263734 -122.404375198961 (37.7990966263734, -122.404375198961) 3 1 10 308 23
29264 133119 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2031 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6007673.99432 2119333.32299 37.799718426613 -122.417559814154 (37.799718426613, -122.417559814154) 5 1 1 28858 32
29475 133162 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2200 Grant Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6010218.20069 2122178.33315 37.8076729499204 -122.408956729491 (37.8076729499204, -122.408956729491) 3 1 10 308 23
29939 30471 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 535 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/1956 12:00:00 AM     Permit Number 116 6010391.91073115 2119560.70154745 37.8004953099758 -122.408170826336 (37.8004953099758, -122.408170826336) 3 1 10 308 23

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