trees

302 rows where qSpecies_id = 167 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) ▼
1517 19783 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY19 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 50ST                      
2582 19774 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY17 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 20ST                      
3812 19927 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY37 7 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
3853 19924 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY37 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
6216 19931 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY37 11 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
7721 19582 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY4 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
8077 19587 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY4 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
10276 20049 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY52 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 10                      
10775 19839 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY25 23 Sidewalk: Curb side : Cutout Tree DPW 1     6 60X                      
13835 20004 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY46 24 Sidewalk: Curb side : Cutout Tree DPW 1     3 2                      
16360 19788 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY19 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 50ST                      
18770 19796 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY21 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
19416 20072 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY55 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 45X                      
1951 196519 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 3 Sidewalk: Curb side : Yard Tree Private 2     1     6014493.82827 2101802.94838 37.7519653333515 -122.392733453506 (37.7519653333515, -122.392733453506) 10 3 8 28856 1
12154 61218 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 175 Elmira St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/17/1983 12:00:00 AM 8   Permit Number 21087 6011233.77043 2095695.97338 37.7350152900164 -122.403577634297 (37.7350152900164, -122.403577634297) 10 3 8 58 1
17389 61219 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 179 Elmira St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/17/1983 12:00:00 AM 7   Permit Number 21088 6011237.71128 2095645.35601 37.7348765255373 -122.403560449172 (37.7348765255373, -122.403560449172) 10 3 8 58 1
27193 196521 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 7 Sidewalk: Curb side : Yard Tree Private 2     1     6014496.49753 2101766.20536 37.7518645930792 -122.392721652585 (37.7518645930792, -122.392721652585) 10 3 8 28856 1
54150 196518 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1     6014492.91389 2101810.69981 37.7519865663454 -122.392737157804 (37.7519865663454, -122.392737157804) 10 3 8 28856 1
79931 60386 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1432 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1982 12:00:00 AM     Permit Number 19966 6015791.47503069 2094604.97930734 37.7322731738529 -122.387743792201 (37.7322731738529, -122.387743792201) 10 3 8 58 1
102825 196517 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1     6014492.80276 2101818.43499 37.7520077993331 -122.392738083189 (37.7520077993331, -122.392738083189) 10 3 8 28856 1
128132 196520 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 6 Sidewalk: Curb side : Yard Tree Private 2     1     6014495.9358 2101776.59314 37.7518930845169 -122.392724321763 (37.7518930845169, -122.392724321763) 10 3 8 28856 1
143285 60381 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1350 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1982 12:00:00 AM     Permit Number 19961 6016233.53392592 2094275.31577425 37.7313924611256 -122.386192505476 (37.7313924611256, -122.386192505476) 10 3 8 58 1
158240 60370 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1439 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1982 12:00:00 AM     Permit Number 19948 6015729.73368672 2094586.16842125 37.7322181026296 -122.387955935836 (37.7322181026296, -122.387955935836) 10 3 8 58 1
28698 63544 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1457 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/1987 12:00:00 AM 5   Permit Number 24160 6000753.318 2110998.5304 37.776441399194 -122.440909593922 (37.776441399194, -122.440909593922) 15 5 11 29492 10
31945 141596 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1457 FULTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6000792.6568 2111003.6819 37.7764577843183 -122.440773879837 (37.7764577843183, -122.440773879837) 15 5 11 29492 10
73664 110661 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 650 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6003108.683 2110599.6041 37.7754799116102 -122.432733221791 (37.7754799116102, -122.432733221791) 15 9 11 29492 10
149859 35161 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 515 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/02/1998 12:00:00 AM 6   Permit Number 38692 6002615.109 2110357.4935 37.7747871313025 -122.434423295825 (37.7747871313025, -122.434423295825) 15 5 11 29492 10
181649 67772 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 146 Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1992 12:00:00 AM     Permit Number 31403 6004564.19848572 2108804.14815363 37.7706324670974 -122.427570300779 (37.7706324670974, -122.427570300779) 7 9 11 28852 10
9760 74773 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2650 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5995110.10491 2110290.17085 37.7741734136379 -122.460379593502 (37.7741734136379, -122.460379593502) 11 6 2 54 11
15367 74918 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2650 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5995120.86057 2110292.38931 37.7741801236558 -122.460342548793 (37.7741801236558, -122.460342548793) 11 6 2 54 11
30195 123321 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 678 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5994436.02989 2110905.44736 37.7758240001959 -122.462755965315 (37.7758240001959, -122.462755965315) 11 6 2 54 11
38211 123559 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 131 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 7ft   5994253.7419 2114658.86132 37.7861193636966 -122.463659017412 (37.7861193636966, -122.463659017412) 11 6 1 54 11
41074 123858 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 346 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5994396.82631 2114914.43525 37.7868293438726 -122.463182538439 (37.7868293438726, -122.463182538439) 11 6 1 54 11
62720 52648 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 542@ ANZA 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/24/2010 12:00:00 AM 2   Permit Number 48732 5993472.64423 2111791.25598 37.7782006595283 -122.466152920318 (37.7782006595283, -122.466152920318) 11 6 2 54 11
85134 123200 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1310 09th Ave 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 9ft   5993097.33077 2112035.35395 37.7788492259481 -122.467469010607 (37.7788492259481, -122.467469010607) 11 6 2 54 11
97673 123560 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 131 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 7ft   5994254.42812 2114646.46204 37.7860853581858 -122.463655743051 (37.7860853581858, -122.463655743051) 11 6 1 54 11
122376 41957 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2638 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 4   Permit Number 42313 5995143.69116 2110295.91032 37.7741911046961 -122.460263829424 (37.7741911046961, -122.460263829424) 11 6 2 54 11
123721 122919 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 342 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5992497.47697 2113139.63077 37.7818466194185 -122.469624534307 (37.7818466194185, -122.469624534307) 11 6 2 54 11
123939 123558 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 127 05th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 7ft   5994253.98001 2114683.08774 37.7861858965782 -122.463659952565 (37.7861858965782, -122.463659952565) 11 6 1 54 11
129448 123859 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 346 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994390.43638 2114914.64585 37.7868295540161 -122.463204661228 (37.7868295540161, -122.463204661228) 11 6 1 54 11
156175 123146 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 560 10th Ave 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 5ft   5992867.54706 2111680.63893 37.7778620058506 -122.468238105016 (37.7778620058506, -122.468238105016) 11 6 2 54 11
164715 123860 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 346 Lake St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994375.95206 2114914.31886 37.7868278217721 -122.463254749485 (37.7868278217721, -122.463254749485) 11 6 1 54 11
172046 1641 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 859 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3X3   5995651.21865 2110512.9681 37.774816268938 -122.458523928345 (37.774816268938, -122.458523928345) 11 6 2 54 11
192207 84853 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1338 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2007 12:00:00 AM 6   Permit No. 49311 5994481.6608 2112148.58575 37.779239954215 -122.462688317698 (37.779239954215, -122.462688317698) 11 6 2 54 11
23016 60906 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1443 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1983 12:00:00 AM     Permit Number 20696 5994564.62076665 2105704.92459357 37.7615521348608 -122.461933943385 (37.7615521348608, -122.461933943385) 1 5 11 56 12
26232 54232 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1265 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1983 12:00:00 AM     Permit Number 9972 5995143.28929522 2106927.58636529 37.7649425453263 -122.460021156774 (37.7649425453263, -122.460021156774) 15 5 11 56 12
28226 46608 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1166 Noriega St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2002 12:00:00 AM     Permit Number 44731 5990419.11281219 2103161.32215556 37.7543285475592 -122.476085621892 (37.7543285475592, -122.476085621892) 1 8 4 56 12
31006 44821 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1608 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/2001 12:00:00 AM     Permit Number 43913 5993106.95790851 2104515.64796333 37.7582026654605 -122.466888899121 (37.7582026654605, -122.466888899121) 1 8 4 56 12
78768 50189 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 350 Noriega St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2003 12:00:00 AM     Permit Number 46896 5992966.98430504 2103249.49310039 37.7547180534592 -122.467280921215 (37.7547180534592, -122.467280921215) 1 8 4 56 12
89930 67744 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1460 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1992 12:00:00 AM     Permit Number 31363 5994310.57601305 2105578.84704093 37.7611913298083 -122.462803426682 (37.7611913298083, -122.462803426682) 1 5 11 56 12
98612 213708 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1330 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5990694.19648 2105216.19153 37.7599866214079 -122.475284333917 (37.7599866214079, -122.475284333917) 1 8 4 56 12
101584 213709 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1330 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5990679.02857 2105217.07181 37.7599881592429 -122.475336856123 (37.7599881592429, -122.475336856123) 1 8 4 56 12
103090 60911 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 9 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1983 12:00:00 AM     Permit Number 20703 5995767.1919331 2107036.52457374 37.7652775252135 -122.457871132491 (37.7652775252135, -122.457871132491) 15 5 11 56 12
110536 46606 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1166 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2002 12:00:00 AM     Permit Number 44731 5990419.11281219 2103161.32215556 37.7543285475592 -122.476085621892 (37.7543285475592, -122.476085621892) 1 8 4 56 12
113099 46607 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1166 Noriega St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2002 12:00:00 AM     Permit Number 44731 5990419.11281219 2103161.32215556 37.7543285475592 -122.476085621892 (37.7543285475592, -122.476085621892) 1 8 4 56 12
121892 46605 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1166 Noriega St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2002 12:00:00 AM     Permit Number 44731 5990419.11281219 2103161.32215556 37.7543285475592 -122.476085621892 (37.7543285475592, -122.476085621892) 1 8 4 56 12
133366 50190 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 350 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2003 12:00:00 AM     Permit Number 46896 5992966.98430504 2103249.49310039 37.7547180534592 -122.467280921215 (37.7547180534592, -122.467280921215) 1 8 4 56 12
140030 60907 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1491 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1983 12:00:00 AM     Permit Number 20697 5994575.4199228 2105392.22311625 37.7606941592004 -122.461873918454 (37.7606941592004, -122.461873918454) 1 5 11 56 12
186986 59836 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1271 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1983 12:00:00 AM     Permit Number 19290 5995144.61588097 2106889.02596139 37.7648367447545 -122.46001377482 (37.7648367447545, -122.46001377482) 15 5 11 56 12
22520 12417 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1691 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/1989 12:00:00 AM 6 4X4   6004447.0274 2114613.1852 37.7865760223406 -122.428389697922 (37.7865760223406, -122.428389697922) 13 9 11 29490 13
39527 139116 Undocumented 4 Prunus blireiana :: Flowering Plum 167 1501 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6004490.8408 2114272.6601 37.7856435047825 -122.428213836711 (37.7856435047825, -122.428213836711) 13 9 11 29490 13
106985 12418 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1691 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/13/1989 12:00:00 AM 6 4X4   6004450.1666 2114579.9986 37.7864850778881 -122.428376470838 (37.7864850778881, -122.428376470838) 13 9 11 29490 13
153765 139117 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1501 LAGUNA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6004494.7186 2114242.7456 37.785561586454 -122.428198287945 (37.785561586454, -122.428198287945) 13 9 11 29490 13
154216 139122 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1501 LAGUNA ST 7 Sidewalk: Curb side : Cutout Tree DPW 1     4 Width 0ft   6004515.7696 2114102.0367 37.7851764260276 -122.428115426505 (37.7851764260276, -122.428115426505) 13 9 11 29490 13
16161 140280 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2099 Grove St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2019 12:00:00 AM 3 Width 0ft   5997824 2110223 37.774144722636 -122.450986949191 (37.774144722636, -122.450986949191) 15 5 11 29492 16
45196 124234 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1 Paramount Ter 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5996623.51945 2111013.40479 37.7762461678144 -122.455196729351 (37.7762461678144, -122.455196729351) 11 6 2 54 16
45629 140281 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2099 Grove St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5997824 2110223 37.774144722636 -122.450986949191 (37.774144722636, -122.450986949191) 15 5 11 29492 16
50258 124235 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1 Paramount Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5996597.66018 2111009.83191 37.7762348739685 -122.455285924869 (37.7762348739685, -122.455285924869) 11 6 2 54 16
53759 124233 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1 Paramount Ter 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5996645.22941 2111016.06725 37.7762547237702 -122.455121821521 (37.7762547237702, -122.455121821521) 11 6 2 54 16
77356 60791 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 276 Ewing Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/14/1983 12:00:00 AM     Permit Number 20465 5998453.93543616 2112227.70718861 37.7796851739557 -122.44895233828 (37.7796851739557, -122.44895233828) 15 6 2 54 16
111552 61603 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 51 Temescal Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/1984 12:00:00 AM 5   Permit Number 21576 5997451.8044 2111351.7774 37.777222737132 -122.452355902086 (37.777222737132, -122.452355902086) 15 6 2 54 16
133777 249614 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2350 Golden Gate Ave 5 Sidewalk: Property side : Yard Tree Private 2     3 Width 10ft   5998151.85452 2111390.96303 37.7773704113412 -122.449937040973 (37.7773704113412, -122.449937040973) 15 6 2 54 16
135646 249615 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2350 Golden Gate Ave 6 Sidewalk: Property side : Yard Tree Private 2     5 Width 10ft   5998136.14994 2111389.29333 37.7773649281729 -122.449991247621 (37.7773649281729, -122.449991247621) 15 6 2 54 16
144154 142051 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 32 ATALAYA TER 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5998845.9761 2110971.5149 37.7762584069 -122.447505657858 (37.7762584069, -122.447505657858) 15 6 2 29492 16
169133 140279 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2099 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5997824 2110223 37.774144722636 -122.450986949191 (37.774144722636, -122.450986949191) 15 5 11 29492 16
171935 60803 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 120 Ewing Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1983 12:00:00 AM     Permit Number 20479 5998693.79228565 2112443.24923504 37.7802907109033 -122.448138097032 (37.7802907109033, -122.448138097032) 15 6 2 54 16
191968 60785 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 126 Ewing Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/14/1983 12:00:00 AM     Permit Number 20455 5998690.69552191 2112465.2130408 37.7803508407843 -122.448150392076 (37.7803508407843, -122.448150392076) 15 6 2 54 16
42336 136034 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1798 Bay St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002280.33301 2120565.85402 37.8027976639548 -122.436312092548 (37.8027976639548, -122.436312092548) 13 9 1 57 17
48436 13239 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2335X Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6001220.66377 2119285.57244 37.7992220840374 -122.439887231455 (37.7992220840374, -122.439887231455) 13 9 1 57 17
89391 64617 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1635 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1988 12:00:00 AM 6   Permit Number 25522 6004008.12859 2120059.46677 37.8015052752171 -122.43029688889 (37.8015052752171, -122.43029688889) 13 9 1 57 17
116017 136033 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1798 Bay St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002299.69392 2120568.99271 37.8028073820088 -122.436245318762 (37.8028073820088, -122.436245318762) 13 9 1 57 17
139799 35587 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 3600 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1998 12:00:00 AM 5   Permit Number 38951 6002200.57544 2120594.56512 37.8028719650354 -122.436590150328 (37.8028719650354, -122.436590150328) 13 9 1 57 17
142417 35588 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 3600 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1998 12:00:00 AM 5   Permit Number 38951 6002194.35784 2120633.11747 37.8029774662898 -122.436614427534 (37.8029774662898, -122.436614427534) 13 9 1 57 17
163362 35583 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 3600 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1998 12:00:00 AM 7   Permit Number 38951 6002198.46328 2120613.57109 37.8029240303879 -122.436598820686 (37.8029240303879, -122.436598820686) 13 9 1 57 17
164404 136031 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1635 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6004020.9595 2120061.85215 37.8015125516123 -122.430252658446 (37.8015125516123, -122.430252658446) 13 9 1 57 17
192734 136035 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1798 Bay St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002262.26199 2120563.69941 37.8027907211793 -122.436374473117 (37.8027907211793, -122.436374473117) 13 9 1 57 17
34044 39132 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 786 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40812 6007317.12360596 2102737.01571967 37.7541288594826 -122.417617789975 (37.7541288594826, -122.417617789975) 2 4 7 28859 19
37361 63891 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 61 Brady St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1987 12:00:00 AM     Permit Number 24600 6006704.26059714 2109561.52554736 37.7728328593412 -122.420221545678 (37.7728328593412, -122.420221545678) 8 2 9 28853 19
38111 98123 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 900 York St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2015 12:00:00 AM 3 3x3 Permit Number 774687 6009897 2103882.5 37.7574189360449 -122.40877671519 (37.7574189360449, -122.40877671519) 2 4 7 28859 19
43973 64675 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 827 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/07/1988 12:00:00 AM     Permit Number 25611 6005699.53822151 2104160.47613012 37.7579461954401 -122.423312985478 (37.7579461954401, -122.423312985478) 2 4 5 28859 19
51191 56269 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 27 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2001 12:00:00 AM     Permit Number 44402 6006135.85394887 2104023.0641993 37.7575935091812 -122.421794258753 (37.7575935091812, -122.421794258753) 2 4 5 28859 19
56501 45755 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 27 Liberty St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2001 12:00:00 AM     Permit Number 44402 6006135.85394887 2104023.0641993 37.7575935091812 -122.421794258753 (37.7575935091812, -122.421794258753) 2 4 5 28859 19
57104 238543 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 3765 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6005249.86202 2104271.17824 37.7582247685753 -122.4248760328 (37.7582247685753, -122.4248760328) 2 4 5 28859 19
84667 98122 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 900 York St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2015 12:00:00 AM 3 3x3 Permit Number 774687 6009897 2103882.5 37.7574189360449 -122.40877671519 (37.7574189360449, -122.40877671519) 2 4 7 28859 19
89330 10116 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 842 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3X3   6005634.91055 2104075.87142 37.7577102430435 -122.423530480645 (37.7577102430435, -122.423530480645) 2 4 5 28859 19
105028 39133 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 786 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/1999 12:00:00 AM     Permit Number 40812 6007317.12360596 2102737.01571967 37.7541288594826 -122.417617789975 (37.7541288594826, -122.417617789975) 2 4 7 28859 19
111333 109267 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 900 York St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2015 12:00:00 AM 3 3x3 Permit Number 774687 6009897 2103882.5 37.7574189360449 -122.40877671519 (37.7574189360449, -122.40877671519) 2 4 7 28859 19
113719 238560 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 3329 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6007360.6242 2105555.31734 37.7618697145455 -122.417667096959 (37.7618697145455, -122.417667096959) 2 4 7 28859 19
159664 238542 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 38 Ramona Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6005184.86734 2107563.56231 37.7672612032636 -122.425335101659 (37.7672612032636, -122.425335101659) 8 4 5 28853 19
166319 238541 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 31 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6005390.57049 2103524.39032 37.7561822103525 -122.424336286693 (37.7561822103525, -122.424336286693) 2 4 5 28859 19

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