2,694 rows where qSpecies_id = 84 sorted by Neighborhoods (old)

View and edit SQL

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) ▼
884 261406 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2                              
3071 31851 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1117 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35299                    
4023 31850 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84   2 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
4740 119761 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 101X Octavia St Frontage West 3 Sidewalk: Curb side : Cutout Tree DPW 1       4x4                      
4940 39332 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 0 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40897                    
5244 261407 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2                              
6169 39333 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 0 21st St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40897                    
7788 39331 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 0 21st St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40897                    
8270 261411 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 7 Sidewalk: Curb side : Cutout Tree Private 2                              
8717 119762 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 101X Octavia St Frontage West 4 Sidewalk: Curb side : Cutout Tree DPW 1       4x4                      
8992 261405 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2                              
10081 119760 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 101X Octavia St Frontage West 2 Sidewalk: Curb side : Cutout Tree DPW 1       4x4                      
11366 53918 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 3 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40897                    
12262 261408 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2                              
14089 261410 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 6 Sidewalk: Curb side : Cutout Tree Private 2                              
14566 31845 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84   3 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
15267 119759 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 101X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout Tree DPW 1       4x4                      
15516 39334 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 0 21st St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40897                    
16965 31849 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84   1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
17187 261409 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 5 Sidewalk: Curb side : Cutout Tree Private 2                              
18369 261412 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 8 Sidewalk: Curb side : Cutout Tree Private 2                              
19387 31852 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1117 Houston St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35299                    
3849 27720 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1300X Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/11/2015 06:49:00 AM 3 3X3   6015137.8598649 2101142.4987414 37.7501876266135 -122.390460137824 (37.7501876266135, -122.390460137824) 10 3 8 28856 1
4233 27745 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1399 Cesar Chavez St 6 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6014867.8526066 2101105.5872465 37.7500712934283 -122.391391267014 (37.7500712934283, -122.391391267014) 10 3 8 28856 1
11092 74333 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1118 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6015132.5367 2090213.511 37.720178552846 -122.389715298726 (37.720178552846, -122.389715298726) 10 3 8 58 1
11462 38558 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1534 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40523 6015743.77247492 2095689.90327715 37.7352495140639 -122.387984392406 (37.7352495140639, -122.387984392406) 10 3 8 58 1
15474 67662 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1544 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1992 12:00:00 AM     Permit Number 31263 6016003.68231462 2097240.31166612 37.739521017402 -122.387193890351 (37.739521017402, -122.387193890351) 10 3 8 58 1
18344 40022 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1535 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 9   Permit Number 41267 6015717.1223 2095636.9971 37.7351027679039 -122.388072841786 (37.7351027679039, -122.388072841786) 10 3 8 58 1
18417 4023 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1900 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/26/2015 02:44:00 PM 3 3X3   6013444.0079121 2101040.051797 37.7498122193832 -122.396310443681 (37.7498122193832, -122.396310443681) 10 3 8 28856 1
20375 27754 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1299 Cesar Chavez St 7 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874) 10 3 8 58 1
25815 27759 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1099X Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/25/2005 12:00:00 AM 4 3x3   6015711.8179102 2101113.2850563 37.750139234821 -122.388473299437 (37.750139234821, -122.388473299437) 10 3 8 58 1
26757 4027 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2150 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
36197 67647 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1980 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1992 12:00:00 AM     Permit Number 31246 6013237.51927358 2096157.49523352 37.7363942565122 -122.396682257399 (37.7363942565122, -122.396682257399) 10 3 8 58 1
42727 67682 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 56 Topeka Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1992 12:00:00 AM     Permit Number 31286 6012201.16288031 2095460.48706817 37.7344226836872 -122.400216460292 (37.7344226836872, -122.400216460292) 10 3 8 58 1
45706 27750 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1299 Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874) 10 3 8 58 1
48725 27758 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1299 Cesar Chavez St 11 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874) 10 3 8 58 1
59660 89359 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 308 Tocoloma Ave 3 Front Yard : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50704 6012556.9 2087009.2 37.7112369933076 -122.398393755853 (37.7112369933076, -122.398393755853) 10 3 8 309 1
62719 178898 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 250 Tocoloma Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6012665.55046 2087301.61111 37.7120459484316 -122.398038730507 (37.7120459484316, -122.398038730507) 10 3 8 309 1
65628 40021 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1530 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 5   Permit Number 41266 6015759.6141 2095683.1757 37.7352319191288 -122.387929152323 (37.7352319191288, -122.387929152323) 10 3 8 58 1
66460 15049 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1125 Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/15/1999 12:00:00 AM 25 8X15   6015485.0268 2096001.9904 37.7360921037992 -122.388900760186 (37.7360921037992, -122.388900760186) 10 3 8 58 1
69218 196424 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1427x Innes Ave 31 Median : Yard Tree DPW 1     3     6016113.33147 2096777.48422 37.7382562587307 -122.386782500139 (37.7382562587307, -122.386782500139) 10 3 8 58 1
90077 29251 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1300X Cesar Chavez St 5 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015137.8598649 2101142.4987414 37.7501876266135 -122.390460137824 (37.7501876266135, -122.390460137824) 10 3 8 28856 1
90801 199985 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1032 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6018147.7753 2092169.4169 37.7257158363369 -122.379428312297 (37.7257158363369, -122.379428312297) 10 3 8 58 1
96168 30770 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1662 Wallace Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2008 12:00:00 AM 2   Permit Number 51077 6014463.7744 2093152.8983 37.7282124168861 -122.392232472861 (37.7282124168861, -122.392232472861) 10 3 8 58 1
100052 46629 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1490 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2002 12:00:00 AM 7   Permit Number 44750 6015847.6531 2095265.1212 37.7340889026671 -122.38759560956 (37.7340889026671, -122.38759560956) 10 3 8 58 1
109178 30767 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1595 Underwood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM     Permit Number 34647 6014606.20359025 2093675.42749231 37.729655084275 -122.39177660647 (37.729655084275, -122.39177660647) 10 3 8 58 1
117015 27743 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1399 Cesar Chavez St 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6014867.8526066 2101105.5872465 37.7500712934283 -122.391391267014 (37.7500712934283, -122.391391267014) 10 3 8 28856 1
119540 178897 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 250 Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6012667.83856 2087309.2144 37.7120669530014 -122.398031355176 (37.7120669530014, -122.398031355176) 10 3 8 309 1
121404 54661 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 345 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1972 12:00:00 AM 2   Permit Number 10485 6012308.35839 2086909.49761 37.7109493816857 -122.399245788885 (37.7109493816857, -122.399245788885) 10 3 8 309 1
129592 4033 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2150 Cesar Chavez St 7 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
132528 51809 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1465 Van Dyke Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2005 12:00:00 AM 2 3x3 Permit Number 48055 6015110.437 2092946.715 37.7276821641004 -122.389982519172 (37.7276821641004, -122.389982519172) 10 3 8 58 1
134499 51808 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1465 Van Dyke Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2005 12:00:00 AM     Permit Number 48055 6015124.97012751 2092940.21442791 37.7276651208235 -122.389931823623 (37.7276651208235, -122.389931823623) 10 3 8 58 1
137148 178896 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 424 Blanken Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6012763.5947 2086999.98496 37.7112232027683 -122.397678716599 (37.7112232027683, -122.397678716599) 10 3 8 309 1
141905 24168 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 95X Whitney Young Cir 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/01/2008 12:00:00 AM 3 3x3   6016412.1769872 2096105.6107164 37.736427970914 -122.38570241579 (37.736427970914, -122.38570241579) 10 3 8 58 1
153037 4025 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1900 Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree DPW 1   06/25/2015 03:01:00 PM 3 3X3   6013444.0079121 2101040.051797 37.7498122193832 -122.396310443681 (37.7498122193832, -122.396310443681) 10 3 8 28856 1
154597 27753 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1299 Cesar Chavez St 6 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874) 10 3 8 58 1
156579 4026 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1900 Cesar Chavez St 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6013444.0079121 2101040.051797 37.7498122193832 -122.396310443681 (37.7498122193832, -122.396310443681) 10 3 8 28856 1
158880 96804 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1200X Revere Ave 1 Median : Tree DPW 1           6017205.4 2092876.1 37.7276042330013 -122.382735217758 (37.7276042330013, -122.382735217758) 10 3 8 58 1
161111 4019 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1760 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/23/2006 12:00:00 AM 3 2X3   6013957.30178 2101067.5315943 37.7499162221241 -122.394537361718 (37.7499162221241, -122.394537361718) 10 3 8 58 1
164897 199981 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1200x Shafter Ave 1 Median : Cutout Tree DPW 1     2 Width 0ft   6017028.9443 2092601.7798 37.7268412531355 -122.383326145908 (37.7268412531355, -122.383326145908) 10 3 8 58 1
166282 178899 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 250 Tocoloma Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6012660.08669 2087284.72268 37.7119992718279 -122.398056430958 (37.7119992718279, -122.398056430958) 10 3 8 309 1
173129 60295 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1469 Van Dyke Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/27/1982 12:00:00 AM 7 3x3 Permit Number 19860 6015087.9595 2092963.5731 37.7277272064476 -122.390061402044 (37.7277272064476, -122.390061402044) 10 3 8 58 1
176433 199678 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1400x Underwood Ave 1 Median : Cutout Tree DPW 1     3 Width 0ft   6015628.2568 2092949.4044 37.7277182533007 -122.388192580507 (37.7277182533007, -122.388192580507) 10 3 8 58 1
188202 4029 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2150 Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
282 119806 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 251X Octavia St Frontage West 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005545 2110174 37.7744491774234 -122.424275134654 (37.7744491774234, -122.424275134654) 7 9 11 28852 10
340 42995 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 436 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM     Permit Number 42871 6004515.16540478 2110012.02065503 37.7739462176361 -122.42782598565 (37.7739462176361, -122.42782598565) 7 9 11 28852 10
4437 244983 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 299 Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2018 12:00:00 AM 3 Width 0ft Permit Number 781995 6005200.9141 2109719.1317 37.7731807843789 -122.425433016756 (37.7731807843789, -122.425433016756) 7 9 11 28852 10
6160 42787 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 413 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM   3x3 Permit Number 42754 6004586.33786017 2109969.42501453 37.7738332863504 -122.427576752843 (37.7738332863504, -122.427576752843) 7 9 11 28852 10
9471 119842 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 350 Octavia St Frontage East 2 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
9852 31300 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 519 Birch St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM 10   Permit Number 34943 6005263.3007 2111469.3023 37.7779898515936 -122.425341782234 (37.7779898515936, -122.425341782234) 7 9 11 28852 10
11107 78786 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1356 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6001332.0848 2110785.1298 37.7758884007732 -122.438892183533 (37.7758884007732, -122.438892183533) 15 5 11 29492 10
11452 110549 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 7 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
13210 244980 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 289 Rose St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005226.4402 2109722.7783 37.7731922392405 -122.425344978098 (37.7731922392405, -122.425344978098) 7 9 11 28852 10
19155 80023 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 632-632 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6001104.7117 2110909.6213 37.7762172841329 -122.439687650862 (37.7762172841329, -122.439687650862) 15 5 11 29492 10
20713 107753 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 400X Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004484.08045 2109981.44374 37.773860502373 -122.427931334456 (37.773860502373, -122.427931334456) 7 9 11 28852 10
21018 110553 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 11 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
23723 30734 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 281 Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM     Permit Number 34629 6005251.19976575 2109714.98569866 37.7731722414546 -122.425258776803 (37.7731722414546, -122.425258776803) 7 9 11 28852 10
23975 142257 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 541 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6004803.1693 2110709.0411 37.7758763538472 -122.426879382419 (37.7758763538472, -122.426879382419) 7 9 11 28852 10
27494 109159 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 200 Octavia St Frontage East 5 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005726 2110076 37.7741903117261 -122.423642051276 (37.7741903117261, -122.423642051276) 7 9 11 28852 10
27984 138926 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 431 OCTAVIA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6005464.9166 2110768.0336 37.7760757272062 -122.424594423557 (37.7760757272062, -122.424594423557) 7 9 11 28852 10
28153 244988 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 260 Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2018 12:00:00 AM 3 Width 0ft   6005214.8927 2109749.52 37.7732650130646 -122.425386825853 (37.7732650130646, -122.425386825853) 7 9 11 28852 10
28839 119865 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451X Octavia St Frontage West 6 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
28979 110554 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 12 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
29442 42763 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 415 Buchanan St 9 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2000 12:00:00 AM     Permit Number 42742 6004604.76721884 2109944.08482631 37.7737647507648 -122.427511197042 (37.7737647507648, -122.427511197042) 7 9 11 28852 10
29485 33704 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 196 Germania St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1996 12:00:00 AM     Permit Number 37772 6003356.08500561 2108810.32684763 37.7705810245056 -122.431749619478 (37.7705810245056, -122.431749619478) 15 9 11 29492 10
29717 107752 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 400X Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x3 Permit Number 772924 6004484.08045 2109981.44374 37.773860502373 -122.427931334456 (37.773860502373, -122.427931334456) 7 9 11 28852 10
31012 42789 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 426 -28 -30 Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2000 12:00:00 AM   3x3 Permit Number 42755 6004546 2110000 37.7739149561089 -122.427718466962 (37.7739149561089, -122.427718466962) 7 9 11 28852 10
31843 119859 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 431 Octavia St Frontage West 3 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
33066 42783 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 202 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42751 6005176.07009417 2109735.98338901 37.7732256513259 -122.425520155041 (37.7732256513259, -122.425520155041) 7 9 11 28852 10
33346 245221 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 341 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6005088.7556 2110037.9678 37.7740498933785 -122.425843687227 (37.7740498933785, -122.425843687227) 7 9 11 28852 10
36097 115453 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 300 Octavia St Frontage East 4 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
38409 110550 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 8 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
38617 119866 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451X Octavia St Frontage West 7 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
39220 33696 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 36 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1996 12:00:00 AM     Permit Number 37767 6004073.12371459 2108909.64468264 37.7708943463194 -122.429276458446 (37.7708943463194, -122.429276458446) 7 9 11 29492 10
39487 244972 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 209 Rose St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005534.5777 2109768.9686 37.7733364706745 -122.424282374507 (37.7733364706745, -122.424282374507) 7 9 11 28852 10
40216 244239 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 253 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6005546.7389 2110177.0116 37.7744575447356 -122.424269333697 (37.7744575447356, -122.424269333697) 7 9 11 28852 10
42803 115684 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 100x Octavia St Frontage East 4 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005589 2109665 37.7730540708525 -122.424086724818 (37.7730540708525, -122.424086724818) 7 9 11 28852 10
43629 119810 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 250 Octavia St Frontage East 2 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005726 2110076 37.7741903117261 -122.423642051276 (37.7741903117261, -122.423642051276) 7 9 11 28852 10
44073 142255 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 521 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004876.8784 2110720.6117 37.7759122912727 -122.426625227687 (37.7759122912727, -122.426625227687) 7 9 11 28852 10
44178 103651 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 307X Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 4x4 Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10

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