home / trees

Street_Tree_List

Data source: data.sfgov.org

255 rows where PlantType = 2

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

PlantType

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
240 100242 DPW Maintained 1 Tree(s) :: 13 76 Linda St   Sidewalk: Curb side : Pot 3 Landscaping 2 Private 2           6005815.0 2105046.0 37.76038415245 -122.422976606568 (37.76038415245, -122.422976606568) 2 4 5 28859 19
340 100355 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 591 Waller St   Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2   12/30/2014 12:00:00 AM 3 27x6 Permit Number 769031 6002899.6 2108847.2 37.770656382716396 -122.43333123962 (37.7706563827164, -122.43333123962) 15 5 5 29492 9
1989 102275 Property Tree 5 Tree(s) :: 13 267 Topaz Way   Back Yard : Yard 6 Landscaping 2 Private 2           6001225.6 2097744.2 37.740075118911705 -122.438326054857 (37.7400751189117, -122.438326054857) 2 7 5 63 7
1990 102276 DPW Maintained 1 Tree(s) :: 13 279 Topaz Way   Back Yard : Yard 6 Landscaping 2 Private 2           6001205.6 2097796.6 37.7402178594385 -122.43839895973301 (37.7402178594385, -122.438398959733) 2 7 5 63 7
2119 102414 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 5 1301 Page St 2 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2           6000345.0 2109213.0 37.77151552050871 -122.44219387377399 (37.7715155205087, -122.442193873774) 15 5 11 29492 9
3248 103619 DPW Maintained 1 Tree(s) :: 13 1200 Monterey Blvd 1 Front Yard : Yard 4 Landscaping 2 Private 2           5994284.3 2094292.0 37.7301989768893 -122.46207576474701 (37.7301989768893, -122.462075764747) 9 8 4 59 40
3252 103623 DPW Maintained 1 Taxus baccata :: Irish Yew 81 333 El Camino Del Mar 1 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2   06/04/2013 12:00:00 AM   13x2 Permit Number 770205 5987603.5 2115303.5 37.787503918723395 -122.48671414227199 (37.7875039187234, -122.486714142272) 11 6 1 55 33
3703 104151 DPW Maintained 1 :: 55 525X Church St 1 Sidewalk: Property side : Cutout 9 Landscaping 2 SFUSD 4 DPW 3     2x58   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
3704 104152 DPW Maintained 1 :: 55 525X Church St 2 Sidewalk: Property side : Cutout 9 Landscaping 2 SFUSD 4 DPW 3     2x68   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
3705 104153 DPW Maintained 1 :: 55 525X Church St 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 SFUSD 4 DPW 3     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
3706 104154 DPW Maintained 1 :: 55 525X Church St 2 Sidewalk: Curb side : Cutout 2 Landscaping 2 SFUSD 4 DPW 3     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
3707 104155 DPW Maintained 1 :: 55 525X Church St 3 Sidewalk: Curb side : Cutout 2 Landscaping 2 SFUSD 4 DPW 3     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
3708 104156 DPW Maintained 1 :: 55 525X Church St 4 Sidewalk: Curb side : Cutout 2 Landscaping 2 SFUSD 4 DPW 3     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
3709 104157 DPW Maintained 1 :: 55 525X Church St 5 Sidewalk: Curb side : Cutout 2 Landscaping 2 SFUSD 4 DPW 3     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
3710 104158 DPW Maintained 1 :: 55 525X Church St 6 Sidewalk: Curb side : Cutout 2 Landscaping 2 SFUSD 4 DPW 3     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
3883 104374 DPW Maintained 1 Tree(s) :: 13 22 GARDENSIDE DR 1 Median : Yard 11 Landscaping 2 Private 2       50x50   5999468.0 2101996.0 37.7516494117124 -122.444708626009 (37.7516494117124, -122.444708626009) 2 5 5 63 38
3884 104375 DPW Maintained 1 Tree(s) :: 13 30 GARDENSIDE DR 1 Median : Yard 11 Landscaping 2 Private 2       50x50   5999465.0 2102094.0 37.7519183246276 -122.444726043725 (37.7519183246276, -122.444726043725) 2 5 5 63 38
4058 104564 DPW Maintained 1 Private shrub :: Private Shrub 212 18 FLOOD AVE 1 Front Yard : Yard 4 Landscaping 2 Private 2           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042) 9 7 4 63 40
4059 104565 DPW Maintained 1 Private shrub :: Private Shrub 212 18 FLOOD AVE 1 Front Yard : Yard 4 Landscaping 2 Private 2           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042) 9 7 4 63 40
4123 104634 DPW Maintained 1 :: 55 217 Montcalm St   Front Yard : Yard 4 Landscaping 2 Private 2       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229) 2 7 7 28859 2
4124 104635 DPW Maintained 1 :: 55 217 Montcalm St   Front Yard : Yard 4 Landscaping 2 Private 2       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229) 2 7 7 28859 2
4125 104636 DPW Maintained 1 :: 55 217 Montcalm St   Front Yard : Yard 4 Landscaping 2 Private 2       16x16   6010036.0 2099691.0 37.7459177905176 -122.40800041337499 (37.7459177905176, -122.408000413375) 2 7 7 28859 2
4126 104637 DPW Maintained 1 :: 55 217 Montcalm St   Front Yard : Yard 4 Landscaping 2 Private 2       16x16   6010036.0 2099691.0 37.7459177905176 -122.40800041337499 (37.7459177905176, -122.408000413375) 2 7 7 28859 2
4144 104667 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 172 Clipper St 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2 FUF 2 01/19/2016 12:00:00 AM   6x12 Permit Number 777366 6003998.6 2101043.1 37.749290469922705 -122.42897329466999 (37.7492904699227, -122.42897329467) 2 4 5 28862 22
4315 104856 DPW Maintained 1 :: 55 739 27th St   Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2   02/12/2015 12:00:00 AM 3     6001722.3 2099959.7 37.746186600460604 -122.43676722664301 (37.7461866004606, -122.436767226643) 2 7 5 63 22
4316 104857 DPW Maintained 1 :: 55 2555 46th Ave   Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2           5982069.8 2097707.6 37.7388664658919 -122.504555139124 (37.7388664658919, -122.504555139124) 1 8 3 29491 35
4317 104858 DPW Maintained 1 :: 55 4205 24th St   Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2           6001816.0 2101720.7 37.7510272133613 -122.43656924920201 (37.7510272133613, -122.436569249202) 2 4 5 28862 22
4318 104859 DPW Maintained 1 :: 55 650 Fillmore St   Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2           6003597.7 2110555.4 37.775386259915 -122.43103844044701 (37.775386259915, -122.431038440447) 7 9 11 29492 10
4320 104860 DPW Maintained 1 :: 55 283 Randall St   Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2           6003774.7 2097827.3 37.7404479510811 -122.429518236565 (37.7404479510811, -122.429518236565) 2 7 5 63 7
4321 104861 DPW Maintained 1 :: 55 3458A 18th St   Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2           6006508.0 2105569.9 37.7618617394874 -122.42061702780899 (37.7618617394874, -122.420617027809) 8 4 7 28859 19
4324 104864 DPW Maintained 1 :: 55 45 Hoffman Ave   Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2           6000629.3 2102650.0 37.7535113392088 -122.440739618385 (37.7535113392088, -122.440739618385) 2 4 5 28862 22
4457 105003 DPW Maintained 1 Shrub :: Shrub 47 607 CONGO ST   Sidewalk: Property side : Yard 5 Landscaping 2 Private 2           6000094.1 2095817.0 37.73471905904071 -122.44210000591002 (37.7347190590407, -122.44210000591) 9 7 4 63 40
4488 105039 DPW Maintained 1 :: 55 2660 Harrison St 1 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2       2x7   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586) 2 4 7 28859 19
4489 105040 DPW Maintained 1 :: 55 2660 Harrison St 2 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2       2x7   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586) 2 4 7 28859 19
4490 105041 DPW Maintained 1 :: 55 2660 Harrison St 3 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2       2x2   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586) 2 4 7 28859 19
4491 105042 DPW Maintained 1 :: 55 2660 Harrison St 4 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2       2x10   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586) 2 4 7 28859 19
4492 105043 DPW Maintained 1 :: 55 2660 Harrison St 5 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2       2x4   6008902.0 2102968.0 37.754852144595795 -122.41215320319701 (37.7548521445958, -122.412153203197) 2 4 7 28859 19
4565 105147 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 52 Mirabel Ave   Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2   12/26/2013 12:00:00 AM   3X3 Permit Number 771012 6007663.7 2099931.8 37.7464458666696 -122.41622057503099 (37.7464458666696, -122.416220575031) 2 7 7 28859 2
5686 106516 DPW Maintained 1 Tree(s) :: 13 366 Hill St   Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2   05/07/2014 12:00:00 AM   3X3 Permit Number 772751 6003996.2 2103381.7 37.755711581068795 -122.42914832014 (37.7557115810688, -122.42914832014) 2 4 5 28862 22
5741 106576 DPW Maintained 1 Private shrub :: Private Shrub 212 507 STEINER ST 1 Front Yard : Yard 4 Landscaping 2 Private 2           6003113.3 2110111.6 37.7741402349502 -122.432682383122 (37.7741402349502, -122.432682383122) 15 5 11 29492 10
5783 106639 DPW Maintained 1 Private shrub :: Private Shrub 212 1321X CLAYTON ST 1 Back Yard : Yard 6 Landscaping 2 Private 2           5998910.0 2105100.0 37.7601403710114 -122.44686158716699 (37.7601403710114, -122.446861587167) 15 5 5 28862 12
5785 106641 DPW Maintained 1 Private shrub :: Private Shrub 212 1323X CLAYTON ST 1 Back Yard : Yard 6 Landscaping 2 Private 2           5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866) 15 5 5 28862 12
6012 106932 DPW Maintained 1 Shrub :: Shrub 47 358 SHOTWELL ST 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2       8x10   6007793.2 2105846.4 37.7626932925098 -122.416191600332 (37.7626932925098, -122.416191600332) 8 4 7 28859 19
6135 107078 DPW Maintained 1 Tree(s) :: 13 92 Homestead St   Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2   07/25/2014 12:00:00 AM   3x3.5 Permit Number 773562 6000948.33481 2101213.46128 37.7495851129185 -122.439533357227 (37.7495851129185, -122.439533357227) 2 4 5 28862 22
6176 107144 DPW Maintained 1 :: 55 360 Spear St 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2           6015708.0 2115219.0 37.7888702311939 -122.38947147438 (37.7888702311939, -122.38947147438) 6 2 9 28855 6
6337 107348 DPW Maintained 1 Private shrub :: Private Shrub 212 260 LANSDALE AVE 1 Back Yard : Yard 6 Landscaping 2 Private 2           5995019.0 2096651.7 37.7367204092857 -122.459706678853 (37.7367204092857, -122.459706678853) 9 7 4 59 40
6396 107409 DPW Maintained 1 Shrub :: Shrub 47 125 VILLA TER 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2           5999028.2 2104385.8 37.758186107000796 -122.44640141076401 (37.7581861070008, -122.446401410764) 2 5 5 28862 3
6662 107716 DPW Maintained 1 Tree(s) :: 13 2400X 25th Ave 2 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2 Port 9 10/16/2014 12:00:00 AM 3 3x3 Permit Number 773973 5985789.0 2098909.0 37.7423832554664 -122.49178447783899 (37.7423832554664, -122.491784477839) 1 8 3 29491 35
6663 107717 DPW Maintained 1 Tree(s) :: 13 2400X 25th Ave 3 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2 Port 9 10/16/2014 12:00:00 AM 3 3x3 Permit Number 773973 5985789.0 2098909.0 37.7423832554664 -122.49178447783899 (37.7423832554664, -122.491784477839) 1 8 3 29491 35
7458 108576 Property Tree 5 :: 55 2479 Diamond St 1 Front Yard : Yard 4 Landscaping 2 Private 2           6002240.0 2097369.0 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338) 2 7 5 63 7
7590 108701 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 478 30th St   Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2 FUF 2 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774626 6003507.49152 2098366.3309400002 37.7419128730633 -122.43048058961 (37.7419128730633, -122.43048058961) 2 7 5 63 22
7813 108910 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 102 129 Ellert St 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2 FUF 2 01/09/2015 12:00:00 AM 3 3x3 Permit Number 773054 6007361.2 2097016.9 37.7384251864379 -122.417060086005 (37.7384251864379, -122.417060086005) 2 7 7 28859 2
8146 109242 Property Tree 5 Private shrub :: Private Shrub 212 2479 DIAMOND ST   Sidewalk: Curb side : Yard 7 Landscaping 2 Private 2           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916) 2 7 5 63 7
8157 109253 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 110 1355 46th Ave 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2 FUF 2 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773041 5981790.7 2105864.5 37.7612466017789 -122.50612476738199 (37.7612466017789, -122.506124767382) 1 8 3 56 35
8228 109322 DPW Maintained 1 Private shrub :: Private Shrub 212 191 24TH AVE 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2       3x3   5988309.1 2114757.6 37.7860461422813 -122.484232887865 (37.7860461422813, -122.484232887865) 11 6 1 55 33
8240 109342 DPW Maintained 1 :: 55 3211 Baker St 1 Sidewalk: Property side : Yard 5 Landscaping 2 Private 2   02/11/2015 12:00:00 AM 3 1x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385) 13 9 1 57 17
8241 109343 DPW Maintained 1 :: 55 3211 Baker St 2 Sidewalk: Property side : Yard 5 Landscaping 2 Private 2   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385) 13 9 1 57 17
8242 109344 DPW Maintained 1 :: 55 3211 Baker St 3 Sidewalk: Property side : Yard 5 Landscaping 2 Private 2   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385) 13 9 1 57 17
8243 109345 DPW Maintained 1 :: 55 3211 Baker St 4 Sidewalk: Property side : Yard 5 Landscaping 2 Private 2   02/11/2015 12:00:00 AM 3 8.75x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385) 13 9 1 57 17
8245 109348 DPW Maintained 1 Ficus Spp. :: 267 2505 Pacific Ave 1 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269) 13 6 1 29490 27
8246 109349 DPW Maintained 1 Ficus Spp. :: 267 2505 Pacific Ave 2 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269) 13 6 1 29490 27
8248 109350 DPW Maintained 1 Ficus Spp. :: 267 2505 Pacific Ave 3 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269) 13 6 1 29490 27
8249 109351 DPW Maintained 1 Ficus Spp. :: 267 2505 Pacific Ave 4 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269) 13 6 1 29490 27
8250 109352 DPW Maintained 1 Ficus Spp. :: 267 2505 Pacific Ave 5 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269) 13 6 1 29490 27
8251 109353 DPW Maintained 1 Ficus Spp. :: 267 2505 Pacific Ave 6 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269) 13 6 1 29490 27
8263 109364 DPW Maintained 1 :: 55 1205 Filbert St 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2 FUF 2 02/11/2015 12:00:00 AM 3 4.5x6   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
8264 109365 DPW Maintained 1 :: 55 1205 Filbert St 2 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2 FUF 2 02/11/2015 12:00:00 AM 3 4.5x16   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
8265 109366 DPW Maintained 1 :: 55 1205 Filbert St 3 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2 FUF 2 02/11/2015 12:00:00 AM 3 3.125x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
8266 109367 DPW Maintained 1 :: 55 1205 Filbert St 4 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2 FUF 2 02/11/2015 12:00:00 AM 3 4.5x6.5   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
8267 109368 DPW Maintained 1 :: 55 1205 Filbert St 5 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2 FUF 2 02/11/2015 12:00:00 AM 3 3x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
8268 109369 DPW Maintained 1 :: 55 2061 Hyde St 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2 FUF 2 02/11/2015 12:00:00 AM 3 5x6   6007159.6 2119443.7 37.799992536546505 -122.41934764587201 (37.7999925365465, -122.419347645872) 5 1 1 28858 32
8270 109370 DPW Maintained 1 :: 55 2061 Hyde St 2 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2 FUF 2 02/11/2015 12:00:00 AM 3 13x6   6007159.6 2119443.7 37.799992536546505 -122.41934764587201 (37.7999925365465, -122.419347645872) 5 1 1 28858 32
8366 109486 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 110 1314 POLK ST 1 Sidewalk: Curb side : Pot 3 Landscaping 2 DPW 1   01/23/2016 04:50:00 AM 3 3x3   6006825.7 2115468.8 37.7890596427133 -122.420220804515 (37.7890596427133, -122.420220804515) 13 9 10 28858 21
8378 109499 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 102 99 Surrey St 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2 FUF 2 02/19/2015 12:00:00 AM 3 3x3 Permit Number 774984 6002392.9 2096233.9 37.7359945088656 -122.43418207236999 (37.7359945088656, -122.43418207237) 2 7 5 63 7
8410 109534 DPW Maintained 1 :: 55 1234 Filbert St 2 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2 FUF 2 02/23/2015 12:00:00 AM 3 1.5x2.6   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677) 5 1 1 28858 32
8411 109535 DPW Maintained 1 :: 55 1234 Filbert St 3 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2 FUF 2 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677) 5 1 1 28858 32
8412 109536 DPW Maintained 1 :: 55 1234 Filbert St 4 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2 FUF 2 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677) 5 1 1 28858 32
8462 109607 DPW Maintained 1 Shrub :: Shrub 47 775 Congo St 1 Front Yard : Yard 4 Landscaping 2 Private 2           6000381.8 2095947.7 37.7350943222142 -122.44111470541901 (37.7350943222142, -122.441114705419) 9 7 4 63 40
8589 109754 Permitted Site 2 :: 55 601 Steiner St 1 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531) 15 5 11 29492 10
8590 109755 DPW Maintained 1 :: 55 601 Steiner St 2 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531) 15 5 11 29492 10
8591 109756 DPW Maintained 1 :: 55 601 Steiner St 3 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531) 15 5 11 29492 10
8597 109762 DPW Maintained 1 :: 55 1801 Scott St 1 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2       1.5x6.5   6001511.7 2114646.3 37.786500410729104 -122.43854756475099 (37.7865004107291, -122.438547564751) 13 6 1 29490 27
8602 109767 DPW Maintained 1 :: 55 1801 Scott St 2 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2       11.75x1.5+3.6x3.6   6001511.7 2114646.3 37.786500410729104 -122.43854756475099 (37.7865004107291, -122.438547564751) 13 6 1 29490 27
8603 109768 DPW Maintained 1 :: 55 2502X Bush St 1 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2       1.5x13   6001313.62368 2114572.17699 37.786285618589204 -122.43922754338101 (37.7862856185892, -122.439227543381) 13 6 1 29490 27
8604 109769 DPW Maintained 1 :: 55 2502X Bush St 2 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2       1.5x12.75   6001313.62368 2114572.17699 37.786285618589204 -122.43922754338101 (37.7862856185892, -122.439227543381) 13 6 1 29490 27
8605 109770 DPW Maintained 1 Olea Majestic Beauty :: 236 9 Pomona St 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2   12/29/2015 12:00:00 AM   6x7 Permit Number 774437 6014227.8 2094671.9 37.7323701819213 -122.393154495945 (37.7323701819213, -122.393154495945) 10 3 8 58 1
8633 109831 DPW Maintained 1 :: 55 146 Staples Ave 1 Sidewalk: Property side : Cutout 9 Landscaping 2 Private 2       12x15.3   5999109.5 2093827.3 37.7291996500545 -122.445361075989 (37.7291996500545, -122.445361075989) 9 7 4 28861 40
8922 110246 DPW Maintained 1 :: 55 1706 28th Ave 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2   04/01/2015 12:00:00 AM 3 1.5x12   5987540.7 2103643.4 37.755484875136204 -122.486075162345 (37.7554848751362, -122.486075162345) 1 8 3 56 35
8971 110320 Property Tree 5 :: 55 9 Imperial Aly   Back Yard : Yard 6 Landscaping 2 Private 2           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274) 13 9 1 57 17
9210 110613 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 246 200 McAllister St 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2   04/27/2015 12:00:00 AM 3 12.8x7.8 Permit Number 773269 6008108.0 2112443.0 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338) 7 10 9 28852 36
9211 110614 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 246 200 McAllister St 2 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2   12/31/2015 12:00:00 AM 3 21.4x7.8 Permit Number 773269 6008108.0 2112443.0 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338) 7 10 9 28852 36
9212 110615 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 246 200 McAllister St 3 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2   12/31/2015 12:00:00 AM 3 13.2x7.8 Permit Number 773269 6008108.0 2112443.0 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338) 7 10 9 28852 36
10269 111758 DPW Maintained 1 :: 55 1235 47th Ave 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2   06/23/2015 12:00:00 AM 3 6x6   5981472.7 2106671.7 37.7634442160317 -122.50728446314301 (37.7634442160317, -122.507284463143) 1 8 3 56 35
10270 111759 DPW Maintained 1 :: 55 1235 47th Ave 2 Sidewalk: Curb side : Yard 7 Landscaping 2 Private 2   06/23/2015 12:00:00 AM 3 6x4   5981472.7 2106671.7 37.7634442160317 -122.50728446314301 (37.7634442160317, -122.507284463143) 1 8 3 56 35
11038 112605 DPW Maintained 1 :: 55 1534 Hayes St 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2   08/10/2015 12:00:00 AM   5.6x12   6000465.0 2110329.2 37.7745871625182 -122.441858914128 (37.7745871625182, -122.441858914128) 15 5 11 29492 16
12306 113995 DPW Maintained 1 :: 55 3221 Washington St 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2   10/27/2015 12:00:00 AM   39x3   5999265.7 2115942.6 37.789931692456996 -122.44641142836599 (37.789931692457, -122.446411428366) 13 6 1 29490 31
12623 114321 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 2118 47th Ave 1 Front Yard : Cutout 10 Landscaping 2 Private 2   01/14/2016 12:00:00 AM   5x16 Permit Number 777356 5981743.9 2100646.6 37.7469169691931 -122.505899765145 (37.7469169691931, -122.505899765145) 1 8 3 29491 35
13488 115258 DPW Maintained 1 :: 55 2150 Jackson St   : Cutout 18 Landscaping 2 Private 2   01/21/2016 12:00:00 AM   6x12   6003858.0 2116995.5 37.7930839063862 -122.430597643601 (37.7930839063862, -122.430597643601) 13 9 1 29490 27
13489 115259 DPW Maintained 1 :: 55 2130 Jackson St   Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2   01/21/2016 12:00:00 AM   6x12   6003918.8 2117004.0 37.7931106894063 -122.43038787884501 (37.7931106894063, -122.430387878845) 13 9 1 29490 27
14740 116580 Significant Tree 4 Shrub :: Shrub 47 3000x 19TH AVE 3 Sidewalk: Property side : Cutout 9 Landscaping 2 MTA 11 DPW 3     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251) 1 8 4 64 40

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 24.965ms · Data source: data.sfgov.org