trees

7,157 rows where qSpecies_id = 36 sorted by Neighborhoods (old)

✎ 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                      
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                    
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                    
1734 262292 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
1976 42727 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1790 Yosemite Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM 11   Permit Number 42732 6013660.48405 2093404.57029 37.7288588208724 -122.395027119533 (37.7288588208724, -122.395027119533) 10 3 8 58 1
2787 194758 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 750 Phelps St 43 : Tree Private 2     1 Width 2ft   6015105.78884 2097790.25184 37.740981275571 -122.390336854658 (37.740981275571, -122.390336854658) 10 3 8 58 1
4007 61209 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 130 Elmira St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/17/1983 12:00:00 AM 4   Permit Number 21077 6011180.72945 2095956.2501 37.7357269919001 -122.403779325271 (37.7357269919001, -122.403779325271) 10 3 8 58 1
4270 4929 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 16 Dedman Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/16/2013 12:00:00 AM 3 3X4   6016491.974751 2096204.2192508 37.7367031453425 -122.385433388359 (37.7367031453425, -122.385433388359) 10 3 8 58 1
5733 83114 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2094 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6012504.25253 2097415.87207 37.7398086567426 -122.399305795219 (37.7398086567426, -122.399305795219) 10 3 8 58 1
6096 71050 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 165 Elmira St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6011229.446 2095779.16104 37.7352434641973 -122.403598436523 (37.7352434641973, -122.403598436523) 10 3 8 58 1
6299 75364 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1335 Griffith St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6017823.2525 2092467.3959 37.7265161261373 -122.380570876773 (37.7265161261373, -122.380570876773) 10 3 8 58 1
6501 194992 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 11 Dedman Ct 7 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6016636.86174 2096261.76833 37.7368691785546 -122.384936454554 (37.7368691785546, -122.384936454554) 10 3 8 58 1
6550 194776 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1 Flora St 1 : Tree Private 2     3 Width 3ft   6013845.42665 2094215.08633 37.731094615529 -122.394444484728 (37.731094615529, -122.394444484728) 10 3 8 58 1
6721 73570 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1500 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6015400.1677 2094895.0317 37.7330479153498 -122.389116887561 (37.7330479153498, -122.389116887561) 10 3 8 58 1
6779 60387 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1436 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1982 12:00:00 AM 15   Permit Number 19967 6015759.6141 2094635.0651 37.7323540184412 -122.387856042206 (37.7323540184412, -122.387856042206) 10 3 8 58 1
6821 61205 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 156 Elmira St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/17/1983 12:00:00 AM 11 3x3 Permit Number 21073 6011187.02596 2095815.71279 37.7353414579279 -122.403747670028 (37.7353414579279, -122.403747670028) 10 3 8 58 1
7149 199777 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1699 Hawes St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6016770.5961 2092171.5667 37.7256456912793 -122.384189310378 (37.7256456912793, -122.384189310378) 10 3 8 58 1
7304 259748 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1539 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/13/2018 12:00:00 AM 3     6015490.3402 2096517.67005 37.7375083497932 -122.388918380926 (37.7375083497932, -122.388918380926) 10 3 8 58 1
7367 262291 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
7594 194986 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 11 Dedman Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6016473.13756 2096210.02869 37.7367180546823 -122.38549892205 (37.7367180546823, -122.38549892205) 10 3 8 58 1
7767 262288 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
9119 18646 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 55 Reuel Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X4   6017250.7089795 2096167.8793556 37.7366453120483 -122.382807560554 (37.7366453120483, -122.382807560554) 10 3 8 58 1
10781 194991 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 11 Dedman Ct 6 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6016579.94443 2096258.22378 37.7368562975712 -122.385132997804 (37.7368562975712, -122.385132997804) 10 3 8 58 1
11210 262290 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
11546 60372 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1447 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1982 12:00:00 AM 16   Permit Number 19950 6015678.2715 2094616.9279 37.7322997108216 -122.388135999617 (37.7322997108216, -122.388135999617) 10 3 8 58 1
11867 262287 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
12719 49732 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1300@ REVERE Griffith St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446) 10 3 8 58 1
12786 261612 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1900x Bay Shore Blvd 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
13413 22337 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 5245X 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6014474 2093834 37.7300831524848 -122.39224473792 (37.7300831524848, -122.39224473792) 10 3 8 58 1
14520 194759 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 901 Phelps St 4 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6014822.60831 2097331.18487 37.7397050602466 -122.391283914518 (37.7397050602466, -122.391283914518) 10 3 8 58 1
14678 96770 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1300X Lane St 6 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 12/08/2012 12:00:00 AM 3 3x3   6015623.8599 2095148.9526 37.7337575287133 -122.388361234061 (37.7337575287133, -122.388361234061) 10 3 8 58 1
15178 26129 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1411 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016032.5768 2094704.0708 37.7325586119483 -122.386917149192 (37.7325586119483, -122.386917149192) 10 3 8 58 1
16266 60348 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1404 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1982 12:00:00 AM 6   Permit Number 19926 6015899.7652 2094527.3411 37.7320659929368 -122.387363991073 (37.7320659929368, -122.387363991073) 10 3 8 58 1
17159 3838 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 55X Dedman Ct 6 Sidewalk: Curb side : Cutout Tree DPW 1   11/16/2013 12:00:00 AM 3 3X4   6016670.3231407 2096336.3389693 37.7370757852971 -122.38482595599 (37.7370757852971, -122.38482595599) 10 3 8 58 1
18011 262289 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
18121 49353 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1875@ EVANS Marin St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2003 12:00:00 AM 6   Permit Number 46338 6013883.32752 2100506.62327 37.7483719742819 -122.394753893798 (37.7483719742819, -122.394753893798) 10 3 8 58 1
18285 4930 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 17 Dedman Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/16/2013 12:00:00 AM 3 3X4   6016453.9870213 2096275.6260294 37.7368971121848 -122.385569704648 (37.7368971121848, -122.385569704648) 10 3 8 58 1
18552 60416 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1551 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1982 12:00:00 AM 9   Permit Number 19997 6015487.5561 2094405.0524 37.7317073747329 -122.388780566326 (37.7317073747329, -122.388780566326) 10 3 8 58 1
19120 75439 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1335 Griffith St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6017811.7945 2092449.5723 37.7264665536825 -122.380609248682 (37.7264665536825, -122.380609248682) 10 3 8 58 1
19664 93051 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1555X Fairfax Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/09/2010 12:00:00 AM 3 3x3 Planted for DPW by FUF 6015509.3 2098161.9 37.7420241196322 -122.388967590374 (37.7420241196322, -122.388967590374) 10 3 8 58 1
21757 199887 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1501 Keith St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6015922.2993 2094373.9993 37.7316461950184 -122.387275392579 (37.7316461950184, -122.387275392579) 10 3 8 58 1
24311 46249 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1675 Hawes St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2002 12:00:00 AM     Permit Number 44536 6016787.6752368 2092188.79463336 37.7256939401069 -122.384131467798 (37.7256939401069, -122.384131467798) 10 3 8 58 1
24856 115880 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1125X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3   Permit Number 773046 6015016.8 2096457.8 37.7373176998372 -122.390551463966 (37.7373176998372, -122.390551463966) 10 3 8 58 1
26057 46250 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1675 Hawes St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2002 12:00:00 AM     Permit Number 44536 6016787.6752368 2092188.79463336 37.7256939401069 -122.384131467798 (37.7256939401069, -122.384131467798) 10 3 8 58 1
26296 200017 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1011 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6018377.4011 2092259.3357 37.7259753973207 -122.378640745776 (37.7259753973207, -122.378640745776) 10 3 8 58 1
27266 199992 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1074 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6017970.2582 2092302.0809 37.7260703143434 -122.380051196154 (37.7260703143434, -122.380051196154) 10 3 8 58 1
27890 3833 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 55X Dedman Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X4   6016670.3231407 2096336.3389693 37.7370757852971 -122.38482595599 (37.7370757852971, -122.38482595599) 10 3 8 58 1
28794 4943 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 47 Dedman Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X4   6016624.9255784 2096337.2776573 37.7370758517684 -122.384982982724 (37.7370758517684, -122.384982982724) 10 3 8 58 1
28986 97431 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1696@ Newhall St McKinnon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014941.5 2096322.6 37.7369422906262 -122.390802367297 (37.7369422906262, -122.390802367297) 10 3 8 58 1
29690 199713 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1510 Wallace Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015204.8816 2092597.8355 37.7267294479999 -122.389631663832 (37.7267294479999, -122.389631663832) 10 3 8 58 1
29958 4939 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 36 Dedman Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/16/2013 12:00:00 AM 3 3X4   6016579.870147 2096241.2722059 37.7368097478482 -122.385132073872 (37.7368097478482, -122.385132073872) 10 3 8 58 1
30237 195016 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1355 Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6016962.32764 2097150.27135 37.7393268260728 -122.38387301165 (37.7393268260728, -122.38387301165) 10 3 8 58 1
30648 195014 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1409 Keith St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6016094.42849 2094603.13506 37.732284887124 -122.386696274914 (37.732284887124, -122.386696274914) 10 3 8 58 1
30823 96774 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1300X Lane St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 12/08/2012 12:00:00 AM 3 3x3   6015407.2 2095381.5 37.7343840488548 -122.389126529878 (37.7343840488548, -122.389126529878) 10 3 8 58 1
31112 96772 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1300X Lane St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x3   6015407.2 2095381.5 37.7343840488548 -122.389126529878 (37.7343840488548, -122.389126529878) 10 3 8 58 1
31388 195010 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 15 Reuel Ct 6 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6017232.0776 2096087.68476 37.7364240843076 -122.382866398677 (37.7364240843076, -122.382866398677) 10 3 8 58 1
31717 194779 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1 Flora St 10 : Tree Private 2     2 Width 3ft   6013891.08255 2094437.3418 37.7317074216406 -122.394302198511 (37.7317074216406, -122.394302198511) 10 3 8 58 1
31799 11399 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1462 Innes Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X4   6016280.69423 2096695.13026 37.7380393961916 -122.386198097279 (37.7380393961916, -122.386198097279) 10 3 8 58 1
32168 97432 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1696@ Newhall St McKinnon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014941.5 2096322.6 37.7369422906262 -122.390802367297 (37.7369422906262, -122.390802367297) 10 3 8 58 1
32508 199751 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1555 Yosemite Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6014809.6379 2092470.5996 37.7263581596153 -122.390989131746 (37.7263581596153, -122.390989131746) 10 3 8 58 1
32792 49723 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1300@ REVERE Griffith St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446) 10 3 8 58 1
33267 26138 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1500 Oakdale Ave 8 Sidewalk: Curb side : Cutout Tree Rec/Park 5   11/05/2005 12:00:00 AM 3 3x3   6015586.3934773 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626) 10 3 8 58 1
35597 194765 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 918 Newhall St 1 : Tree Private 2     10 Width 3ft   6015266.1428 2096893.13558 37.7385268719238 -122.389719760565 (37.7385268719238, -122.389719760565) 10 3 8 58 1
36107 195006 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 50 Dedman Ct 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6016468.53452 2096275.29989 37.7368970215793 -122.385519384306 (37.7368970215793, -122.385519384306) 10 3 8 58 1
36859 201928 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 118 Elmira St 4 : Tree Private 2     9 Width 3ft   6011173.64176 2096032.19931 37.7359351363972 -122.403809172877 (37.7359351363972, -122.403809172877) 10 3 8 58 1
37067 55072 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1200X Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/14/1972 12:00:00 AM 14   Permit Number 10967 6014810.12698 2096284.78904 37.7368311795103 -122.391253943725 (37.7368311795103, -122.391253943725) 10 3 8 58 1
37523 22335 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 5245X 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 0   6014507.8049 2093886.8701 37.7302302000907 -122.392131565196 (37.7302302000907, -122.392131565196) 10 3 8 58 1

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