trees

4,014 rows where qSpecies_id = 40 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)
10602 104255 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8X Octavia St Frontage East 9 Sidewalk: Curb side : Cutout Tree DPW 1     3 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
14747 260897 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 65 Colin P Kelly Jr St 10 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6015356.8087 2112701.67439 37.7819387497011 -122.390510590187 (37.7819387497011, -122.390510590187) 6 2 9 28856 6
17422 260898 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 65 Colin P Kelly Jr St 11 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6015356.8087 2112701.67439 37.7819387497011 -122.390510590187 (37.7819387497011, -122.390510590187) 6 2 9 28856 6
20340 238038 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 99 Elgin Park 3 : Tree Private 2     5 Width 2ft   6005844.52457 2108573.0044 37.7700701367551 -122.423125198471 (37.7700701367551, -122.423125198471) 8 2 5 28853 19
22165 108189 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 490X 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013735.53307 2112587.71036 37.7815357570631 -122.396111508062 (37.7815357570631, -122.396111508062) 6 2 9 28856 6
25662 196496 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 27 Boardman Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6011659.04329 2110178.7456 37.7748055439625 -122.403125707899 (37.7748055439625, -122.403125707899) 14 2 9 28853 34
34005 238037 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 99 Elgin Park 2 : Tree Private 2     3 Width 2ft   6005845.91582 2108560.69634 37.770036420279 -122.423119511166 (37.770036420279, -122.423119511166) 8 2 5 28853 19
37357 196493 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 728 Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6012209.40916 2110147.41872 37.7747502473676 -122.401219664968 (37.7747502473676, -122.401219664968) 14 2 9 28853 34
42333 237115 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Hwy 101 Southbound 6 Back Yard : Yard Tree Private 2     6     6005846.05822 2108984.84199 37.7712010306339 -122.423149171694 (37.7712010306339, -122.423149171694) 8 2 5 28853 19
45597 51890 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 475 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2005 12:00:00 AM 1   Permit Number 48103 6010867.53759 2112000.42013 37.7797632051362 -122.405992062203 (37.7797632051362, -122.405992062203) 14 2 9 28853 34
47299 104364 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 57 Stillman St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013954.4 2112927.1 37.7824798185974 -122.39537811084 (37.7824798185974, -122.39537811084) 6 2 9 28856 6
49146 104249 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Octavia St Frontage East 3 Sidewalk: Curb side : Cutout Tree DPW 1     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
49289 196487 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Jack London Aly 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6014260.97705 2112675.46167 37.7818059234575 -122.394299855773 (37.7818059234575, -122.394299855773) 6 2 9 28856 6
53799 237116 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Hwy 101 Southbound 4 Back Yard : Yard Tree Private 2     5     6005840.35144 2109000.46624 37.7712436090254 -122.423170022474 (37.7712436090254, -122.423170022474) 8 2 5 28853 19
59525 88201 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 436 Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM 1 3x3 Permit Number 51208 6011209.66735 2112097.91592 37.7800500349251 -122.404815345178 (37.7800500349251, -122.404815345178) 14 2 9 28853 34
62451 91030 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1086 Howard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6009941.213427 2111462.810786 37.7782352043229 -122.409158690819 (37.7782352043229, -122.409158690819) 14 2 9 28853 34
62747 40637 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 142 Russ St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/10/1999 12:00:00 AM 13   Permit Number 41636 6010361.02696 2111479.70343 37.7783050974438 -122.407707586435 (37.7783050974438, -122.407707586435) 14 2 9 28853 34
65480 196425 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 282 Shipley St 1 : Tree Private 2     1 Width 5ft   6011155.75972 2111427.64984 37.7782066270623 -122.404954631245 (37.7782066270623, -122.404954631245) 14 2 9 28856 34
68283 196492 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Jack London Aly 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6014449.0241 2112477.93082 37.7812739996458 -122.393635466299 (37.7812739996458, -122.393635466299) 6 2 9 28856 6
72077 196426 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 55 Sherman St 24 : Tree Private 2     4 Width 10ft   6010646.14926 2111067.55451 37.7771893895099 -122.406692185292 (37.7771893895099, -122.406692185292) 14 2 9 28853 34
72271 238036 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1345 Stevenson St 1 : Tree Private 2     9 Width 3ft   6006282.85406 2108818.1643 37.7707680133637 -122.421626435124 (37.7707680133637, -122.421626435124) 8 2 9 28853 19
73934 104256 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8X Octavia St Frontage East 10 Sidewalk: Curb side : Cutout Tree DPW 1     3 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
75075 238039 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 89 Elgin Park 1 : Tree Private 2     3 Width 3ft   6005843.94387 2108584.75014 37.7701023549756 -122.423128042119 (37.7701023549756, -122.423128042119) 8 2 5 28853 19
75212 196491 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Jack London Aly 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6014437.84547 2112488.65371 37.7813028211009 -122.393674889898 (37.7813028211009, -122.393674889898) 6 2 9 28856 6
82671 196501 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 351 Tehama St 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6011701.40176 2112798.07009 37.7819999683719 -122.403163468629 (37.7819999683719, -122.403163468629) 6 2 9 28853 34
85090 196485 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Jack London Aly 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6014233.73328 2112701.00373 37.7818745417214 -122.394395896169 (37.7818745417214, -122.394395896169) 6 2 9 28856 6
89932 104250 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8x Octavia St Frontage East 4 Sidewalk: Curb side : Cutout Tree DPW 1     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
90448 38235 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 81 Langton St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM 10   Permit Number 40353 6010102.82343 2110824.83764 37.7764925318532 -122.408554604827 (37.7764925318532, -122.408554604827) 8 2 9 28853 34
90536 196502 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 351 Tehama St 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 2ft   6011719.28839 2112815.50725 37.7820488456301 -122.403102815636 (37.7820488456301, -122.403102815636) 6 2 9 28853 34
92242 47388 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 476Howard Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2002 12:00:00 AM 1   Permit Number 45304 6010838.51311 2112011.8477 37.7797929592141 -122.406093276399 (37.7797929592141, -122.406093276399) 14 2 9 28853 34
97227 51393 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 12 Rausch St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/13/2004 12:00:00 AM     Permit Number 47720 6009581.33332398 2110978.5612901 37.7768854013703 -122.410369452214 (37.7768854013703, -122.410369452214) 8 2 9 28853 34
98261 36732 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 South Park 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM 9   Permit Number 39511 6014611.90402 2112877.28923 37.7823795964711 -122.393099929045 (37.7823795964711, -122.393099929045) 6 2 9 28856 6
99732 51392 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 12 Rausch St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/13/2004 12:00:00 AM     Permit Number 47720 6009581.33332398 2110978.5612901 37.7768854013703 -122.410369452214 (37.7768854013703, -122.410369452214) 8 2 9 28853 34
103467 32690 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 480 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM 1   Permit Number 37101 6010817.62236 2111993.44255 37.7797412544913 -122.406164249981 (37.7797412544913, -122.406164249981) 14 2 9 28853 34
105172 238532 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1345 Stevenson St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6006282.94694 2108817.86368 37.7707671931702 -122.421626092496 (37.7707671931702, -122.421626092496) 8 2 9 28853 19
111639 95831 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 520 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/29/2011 12:00:00 AM 1 3x3 Permit Number 767565 6010225.58113 2112036.57812 37.7798265614898 -122.408215431797 (37.7798265614898, -122.408215431797) 14 2 9 28853 34
111674 196497 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3 Decatur St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6010842.88512 2109312.67957 37.7723819142361 -122.405887961173 (37.7723819142361, -122.405887961173) 14 2 9 28853 34
115124 90437 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 34 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/14/2014 12:00:00 AM 3 3x3   6006497.945377 2109373.750238 37.7723056459237 -122.420921880831 (37.7723056459237, -122.420921880831) 8 2 9 28853 19
115591 104252 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8X Octavia St Frontage East 6 Sidewalk: Curb side : Cutout Tree DPW 1     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
115597 196503 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 351 Tehama St 3 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6011737.82052 2112830.87734 37.7820920832107 -122.403039783975 (37.7820920832107, -122.403039783975) 6 2 9 28853 34
116975 196498 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 649 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6012784.03099 2111475.7584 37.7784296058662 -122.399325187321 (37.7784296058662, -122.399325187321) 6 2 9 28856 34
123585 85007 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 850 Bryant St   Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49366 6010976 2110190 37.7747982776561 -122.40548930108 (37.7747982776561, -122.40548930108) 14 2 9 28853 34
125890 32691 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 480 Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM 1   Permit Number 37101 6010795.05101 2111971.34075 37.7796793055824 -122.406240776896 (37.7796793055824, -122.406240776896) 14 2 9 28853 34
126194 65922 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 22 South Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM 6   Permit Number 28938 6014500.58115 2112811.20719 37.7821919655182 -122.393480434 (37.7821919655182, -122.393480434) 6 2 9 28856 6
126486 196483 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 65 Colin P Kelly Jr St 9 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6015356.8087 2112701.67439 37.7819387497011 -122.390510590187 (37.7819387497011, -122.390510590187) 6 2 9 28856 6
128145 196504 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 142 Russ St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6010369.66301 2111467.46147 37.778271967325 -122.40767684761 (37.778271967325, -122.40767684761) 14 2 9 28853 34
129562 196489 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Jack London Aly 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6014409.66856 2112518.16121 37.7813822762217 -122.393774434946 (37.7813822762217, -122.393774434946) 6 2 9 28856 6
130909 104361 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 57 Stillman St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013954.4 2112927.1 37.7824798185974 -122.39537811084 (37.7824798185974, -122.39537811084) 6 2 9 28856 6
141339 196499 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 468 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6010888.37201 2112059.86341 37.779927587715 -122.405924175061 (37.779927587715, -122.405924175061) 14 2 9 28853 34
143063 196490 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Jack London Aly 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6014419.45189 2112508.88507 37.7813573497108 -122.393739939655 (37.7813573497108, -122.393739939655) 6 2 9 28856 6
143687 238531 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 32 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006504.27757 2109384.99653 37.7723368824788 -122.420900775765 (37.7723368824788, -122.420900775765) 8 2 9 28853 19
144364 238040 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 49 Pearl St 1 : Tree Private 2     10 Width 3ft   6005642.22428 2108761.00256 37.7705749163322 -122.423838323102 (37.7705749163322, -122.423838323102) 8 2 5 28853 19
147096 196495 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 728 Brannan St 7 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012138.91764 2110082.47387 37.7745679907399 -122.401458945783 (37.7745679907399, -122.401458945783) 14 2 9 28853 34
147470 196484 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 22 South Park 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6014481.0981 2112803.55306 37.7821698664821 -122.393547301273 (37.7821698664821, -122.393547301273) 6 2 9 28856 6
147787 57783 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 132 Langton St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/08/1977 12:00:00 AM 5   Permit Number 16708 6010300.60698 2110589.59695 37.7758576905205 -122.407853819819 (37.7758576905205, -122.407853819819) 8 2 9 28853 34
148214 38237 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 81 Langton St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM 8   Permit Number 40353 6010112.77454 2110816.57283 37.7764703959168 -122.408519597801 (37.7764703959168, -122.408519597801) 8 2 9 28853 34
152349 88202 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 436 Clementina St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM 1 3x3 Permit Number 51208 6011181.03672 2112067.6395 37.7799653025987 -122.404912259701 (37.7799653025987, -122.404912259701) 14 2 9 28853 34
161112 196494 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 728 Brannan St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012174.00966 2110114.91402 37.7746590219179 -122.401339835074 (37.7746590219179, -122.401339835074) 14 2 9 28853 34
165233 104251 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8X Octavia St Frontage East 5 Sidewalk: Curb side : Cutout Tree DPW 1     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
168679 196500 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 468 Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010880.72676 2112052.38014 37.7799066128255 -122.405950096213 (37.7799066128255, -122.405950096213) 14 2 9 28853 34
172790 196486 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Jack London Aly 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6014249.44841 2112687.41636 37.7818381074737 -122.394340577066 (37.7818381074737, -122.394340577066) 6 2 9 28856 6
173357 104362 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 57 Stillman St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013954.4 2112927.1 37.7824798185974 -122.39537811084 (37.7824798185974, -122.39537811084) 6 2 9 28856 6
174057 44031 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 96 Lafayette St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM 3 3x3 Permit Number 52444 6007775.95033 2109430.42042 37.7725332035812 -122.416505148587 (37.7725332035812, -122.416505148587) 8 2 9 28853 19
177022 196427 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 25 McLea Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6010117 2109248 37.7721636964118 -122.408394314545 (37.7721636964118, -122.408394314545) 14 2 9 28853 34
180426 104366 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 57 Stillman St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013954.4 2112927.1 37.7824798185974 -122.39537811084 (37.7824798185974, -122.39537811084) 6 2 9 28856 6
180637 63769 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 55 Hawthorne St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2013 12:00:00 AM 18 3x3 Permit Number 768706 6013040.47104 2113998.55413 37.7853709106802 -122.398615140189 (37.7853709106802, -122.398615140189) 6 2 9 28855 6
184202 40853 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 126 South Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/2002 12:00:00 AM 11   Permit Number 45449 6014213.93466 2112556.76874 37.781477404701 -122.394454288235 (37.781477404701, -122.394454288235) 6 2 9 28856 6
185536 104254 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8X Octavia St Frontage East 8 Sidewalk: Curb side : Cutout Tree DPW 1     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
188046 104253 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8X Octavia St Frontage East 7 Sidewalk: Curb side : Cutout Tree DPW 1     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
188115 104360 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 57 Stillman St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013954.4 2112927.1 37.7824798185974 -122.39537811084 (37.7824798185974, -122.39537811084) 6 2 9 28856 6
191463 85006 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 850 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49366 6010976 2110190 37.7747982776561 -122.40548930108 (37.7747982776561, -122.40548930108) 14 2 9 28853 34
191703 104979 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 423 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 2x3   6011155.37894 2112276.30906 37.7805368262604 -122.405015718617 (37.7805368262604, -122.405015718617) 14 2 9 28853 34
192366 38239 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 81 Langton St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM 11   Permit Number 40353 6010121.79913 2110806.9834 37.7764445709857 -122.408487702448 (37.7764445709857, -122.408487702448) 8 2 9 28853 34
2321 48402 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 706 Wisconsin St 1 Sidewalk: Property side : Yard Tree Private 2   11/19/2010 12:00:00 AM     Permit Number 53935 6012689.64928807 2104214.1545054 37.7584856101735 -122.399141839868 (37.7584856101735, -122.399141839868) 10 3 8 28856 29
2569 49452 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1483 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/02/2003 12:00:00 AM 4   Permit Number 46386 6011771.85534 2101466.16969 37.7508890570981 -122.402122808245 (37.7508890570981, -122.402122808245) 10 3 8 28856 29
2608 94102 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 252 Holyoke St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2010 12:00:00 AM 5 3x3 Permit Number 53477 6009512.58757 2093214.72689 37.7281060226502 -122.409353352981 (37.7281060226502, -122.409353352981) 10 3 7 309 28
3431 80385 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1754 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6011729.10125 2092748.56003 37.7269499630479 -122.401657992736 (37.7269499630479, -122.401657992736) 10 3 8 58 1
3608 71395 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1553 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6015450.35777 2096531.9462 37.7375453329415 -122.389057616714 (37.7375453329415, -122.389057616714) 10 3 8 58 1
3765 37799 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 425 Somerset St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/06/1998 12:00:00 AM 6   Permit Number 40126 6010088.32636 2092511.70686 37.7262079180568 -122.407313455853 (37.7262079180568, -122.407313455853) 10 3 7 309 28
4965 70417 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 124 Yale St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6007053.10759 2093048.17382 37.7275105968359 -122.417844078137 (37.7275105968359, -122.417844078137) 9 3 7 309 5
5062 80388 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1746 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6011768.66094 2092717.74347 37.7268675545821 -122.401519069956 (37.7268675545821, -122.401519069956) 10 3 8 58 1
7072 179119 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 621 Bowdoin St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008944.10696 2093176.6835 37.7279696962286 -122.411315930896 (37.7279696962286, -122.411315930896) 9 3 7 309 28
7115 4034 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2150 Cesar Chavez St 8 Sidewalk: Curb side : Cutout Tree DPW 1   04/28/1995 12:00:00 AM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
9279 196461 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 615 Mississippi St 1 : Tree Private 2     1 Width 3ft   6014144.28645 2104277.08263 37.7587393543665 -122.39411542099 (37.7587393543665, -122.39411542099) 10 3 8 28856 29
9716 91569 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 301 Girard St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2009 12:00:00 AM   3x3 Permit Number 52142 6010768 2093361 37.7285779166605 -122.405023621917 (37.7285779166605, -122.405023621917) 10 3 7 309 28
10577 76677 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 423 Burrows St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6010109 2093148 37.7279562025478 -122.407286823302 (37.7279562025478, -122.407286823302) 10 3 7 309 28
11922 78132 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 738 Dartmouth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6009313.83221 2090783.01669 37.7214179201914 -122.409868876754 (37.7214179201914, -122.409868876754) 9 3 7 309 28
13155 196442 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 971 Kansas St 3 Sidewalk: Curb side : Pot Tree Private 2     1 Width 5ft   6011633.49107 2103859.13783 37.7574518984069 -122.402769561075 (37.7574518984069, -122.402769561075) 10 3 8 28856 29
13441 82704 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 67 Jennings Ct 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6012930.12709 2089200.71503 37.7172752435332 -122.397257359943 (37.7172752435332, -122.397257359943) 10 3 8 58 1
15749 108724 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 566 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773100 6011759.6093 2105732.18704 37.7626019164795 -122.402465094694 (37.7626019164795, -122.402465094694) 8 3 8 28856 29
16544 84392 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2101 Jerrold Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6012504.25768 2099077.65785 37.7443715685998 -122.399422411225 (37.7443715685998, -122.399422411225) 10 3 8 58 1
16871 83424 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 987 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6012206.17554 2103813.08601 37.7573574093248 -122.400785742066 (37.7573574093248, -122.400785742066) 10 3 8 28856 29
17185 78318 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 605 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5 3x6   6008900.36842 2091273.56909 37.7227416934471 -122.411332749116 (37.7227416934471, -122.411332749116) 9 3 7 309 28
18514 79061 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1006 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6012156.57413 2103666.55961 37.7569523133274 -122.400946989616 (37.7569523133274, -122.400946989616) 10 3 8 28856 29
19073 78215 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 869 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6010959.76408 2090685.67745 37.7212427529373 -122.404172468398 (37.7212427529373, -122.404172468398) 10 3 7 309 28
19321 78229 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 605 Colby St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6 3x9   6008895.81383 2091285.82356 37.7227750861924 -122.411349358704 (37.7227750861924, -122.411349358704) 9 3 7 309 28
19539 102037 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3601X Jennings St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3 Permit Number 52501 6012999.572 2089254.628 37.7174271437906 -122.397021097837 (37.7174271437906, -122.397021097837) 10 3 8 58 1
21578 38140 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 423 Burrows St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1998 12:00:00 AM 2   Permit Number 40297 6010109 2093148 37.7279562025478 -122.407286823302 (37.7279562025478, -122.407286823302) 10 3 7 309 28
22830 68274 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 530 Bowdoin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM 2   Permit Number 32081 6008779.93848 2093554.15422 37.7289969414408 -122.411910130973 (37.7289969414408, -122.411910130973) 9 3 7 309 28
22886 27724 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1200 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015353.11348 2101161.82636 37.750252634764 -122.389717121075 (37.750252634764, -122.389717121075) 10 3 8 28856 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)
);