Street_Tree_List

Data source: data.sfgov.org

351 rows where qLegalStatus = 3 and qSpecies = 18 sorted by Longitude

View and edit SQL

Suggested facets: SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, PermitNotes

qLegalStatus

  • DPW Maintained · 351
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
90446 90655 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3434 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2008 12:00:00 AM 3 3x3   5984935.16156 2110442.47233 37.774001023784706 -122.495587241992 (37.7740010237847, -122.495587241992)
110260 28780 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 6918 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   5985532.54019 2112610.11302 37.7799877082801 -122.493680597714 (37.7799877082801, -122.493680597714)
80522 90634 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3040 Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2008 12:00:00 AM 3 3x3   5986072.775219999 2110484.3905599997 37.774182669931996 -122.49165518484101 (37.774182669932, -122.491655184841)
142580 90633 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3040 Cabrillo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2008 12:00:00 AM 3 3x3   5986086.317840001 2110484.4196099997 37.7741835411504 -122.491608341302 (37.7741835411504, -122.491608341302)
127018 90632 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3040 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2008 12:00:00 AM 3 3x3   5986103.36345 2110484.3741200003 37.774184412397794 -122.491549374976 (37.7741844123978, -122.491549374976)
80739 86034 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1284 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987415.003943 2106546.656914 37.763449099217404 -122.486723028948 (37.7634490992174, -122.486723028948)
109447 86018 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1550 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/16/2007 12:00:00 AM 3 3x3   5987476.600405 2104728.077894 37.758459369903605 -122.48637646604901 (37.7584593699036, -122.486376466049)
84503 86007 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1742 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987522.322672 2103422.5340299997 37.7548773659795 -122.48612250342899 (37.7548773659795, -122.486122503429)
129008 86060 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1869 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987511.195169 2102571.5912409998 37.7525402584661 -122.486098523179 (37.7525402584661, -122.486098523179)
144160 86065 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1939 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987527.802452 2102087.3075490003 37.7512115136965 -122.486005547987 (37.7512115136965, -122.486005547987)
77375 86070 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2115 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987568.946045 2100884.101082 37.7479102288924 -122.485774970523 (37.7479102288924, -122.485774970523)
91229 86519 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1309 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/26/2006 12:00:00 AM 3 3x3   5987691.436672 2106370.804533 37.7629823684162 -122.485754041828 (37.7629823684162, -122.485754041828)
112294 86074 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2237 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/22/2007 12:00:00 AM 3 3x3   5987597.115499 2100061.217249 37.74565245070821 -122.48561718118499 (37.7456524507082, -122.485617181185)
138906 86075 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2241 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/22/2007 12:00:00 AM 3 3x3   5987598.017854 2100035.189447 37.7455810378659 -122.48561215120199 (37.7455810378659, -122.485612151202)
107372 86078 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2253 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/22/2007 12:00:00 AM 3 3x3   5987600.724922 2099957.1059939996 37.7453667992034 -122.485597061296 (37.7453667992034, -122.485597061296)
81351 85991 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2222 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987633.933236 2100153.700526 37.7459085303186 -122.48549665823 (37.7459085303186, -122.48549665823)
81410 85988 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2258 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987642.054438 2099919.450203 37.7452658143921 -122.48545138958299 (37.7452658143921, -122.485451389583)
141412 86539 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1719 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/27/2006 12:00:00 AM 3 3x3   5987787.197497 2103588.458912 37.755348384307105 -122.485218677787 (37.7553483843071, -122.485218677787)
120382 86542 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1731 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/27/2006 12:00:00 AM 3 3x3   5987789.915173001 2103510.132538 37.755133479572294 -122.485203532524 (37.7551334795723, -122.485203532524)
119872 86543 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1739 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2011 12:00:00 AM 3 3x3   5987791.726956 2103457.914967 37.7549902097756 -122.485193435735 (37.7549902097756, -122.485193435735)
107220 86544 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1743 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/27/2006 12:00:00 AM 3 3x3   5987792.632848 2103431.806163 37.75491857482479 -122.48518838735201 (37.7549185748248, -122.485188387352)
144272 86370 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1299X 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5987998.480578 2106474.452955 37.763284845117205 -122.484699699179 (37.7632848451172, -122.484699699179)
113728 85959 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1298X 26TH AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/27/2006 12:00:00 AM 3 3x3   5988007.0 2106798.0 37.764173712799 -122.484693968894 (37.764173712799, -122.484693968894)
79666 86376 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1343 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5988009.291975 2106160.192246 37.7624226008214 -122.484639253233 (37.7624226008214, -122.484639253233)
120983 86378 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1361 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5988013.321416 2106043.0662599998 37.762101239533294 -122.484616725198 (37.7621012395333, -122.484616725198)
84650 85958 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1300 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/21/2006 12:00:00 AM 3 3x3   5988039.866297 2106434.861495 37.7631785479619 -122.48455365718 (37.7631785479619, -122.48455365718)
113189 85956 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1334 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/21/2006 12:00:00 AM 3 3x3   5988047.4774629995 2106213.623528 37.762571532243705 -122.484511104656 (37.7625715322437, -122.484511104656)
100303 86387 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1515 26th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5988049.8019900005 2104982.6702779997 37.7591918054497 -122.4844127767 (37.7591918054497, -122.4844127767)
94546 86392 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1579 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2006 12:00:00 AM 3 3x3   5988064.154428 2104565.481775 37.758047154773294 -122.48433254224199 (37.7580471547733, -122.484332542242)
88698 85946 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1490 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988083.436249 2105168.393711 37.7597037099979 -122.48431007589701 (37.7597037099979, -122.484310075897)
81586 85943 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1538 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988095.160504 2104827.59989 37.7587686653948 -122.484244534442 (37.7587686653948, -122.484244534442)
84020 85942 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1542 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988096.057532 2104801.525596 37.758697124688894 -122.48423951990299 (37.7586971246889, -122.484239519903)
108528 85940 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1554 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988098.748614 2104723.302763 37.7584825026991 -122.48422447635599 (37.7584825026991, -122.484224476356)
116951 85937 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1600X 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988110.016747 2104395.766944 37.7575838341785 -122.484161486754 (37.7575838341785, -122.484161486754)
88119 86581 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2547 27th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/05/2007 12:00:00 AM 3 3x3   5987979.82634 2097967.749244 37.7399266315394 -122.48414034443701 (37.7399266315394, -122.484140344437)
97679 86443 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2450 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 12/29/2006 12:00:00 AM 3 3x3   5987997.37774 2098622.10748 37.741724349066 -122.484127634313 (37.741724349066, -122.484127634313)
82772 85934 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1630 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988116.725594 2104200.7569 37.7570487799795 -122.484123984508 (37.7570487799795, -122.484123984508)
143250 86436 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2574 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/29/2006 12:00:00 AM 3 3x3   5988026.00444 2097787.2202669997 37.7394336348182 -122.48396744726001 (37.7394336348182, -122.48396744726)
117846 90860 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2325 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2008 12:00:00 AM 3 3x3   5988359.69279 2110509.77218 37.7743857485973 -122.483746287708 (37.7743857485973, -122.483746287708)
106913 12834 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2240 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/19/2005 12:00:00 AM 16 5   5988481.054959999 2114714.7558 37.785938514796705 -122.483634834967 (37.7859385147967, -122.483634834967)
120658 12826 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2212 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/02/2010 12:00:00 AM 3 3X3   5988595.84675 2114702.3275900004 37.785911071486396 -122.48323678034299 (37.7859110714864, -122.483236780343)
98643 86320 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1701 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/12/2006 12:00:00 AM 3 3x3   5988402.93355 2103727.2102369997 37.755765207864705 -122.483099472181 (37.7557652078647, -122.483099472181)
84968 86321 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1723 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/12/2006 12:00:00 AM 3 3x3   5988408.134093 2103583.601964 37.7553712008265 -122.483070961912 (37.7553712008265, -122.483070961912)
111406 27310 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2140 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/23/2014 12:00:00 AM 5 5   5988795.04874 2114709.3 37.7859418063725 -122.4825481157 (37.7859418063725, -122.4825481157)
138413 86332 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2263 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988533.319976 2099923.8448349996 37.745329766428 -122.482369901671 (37.745329766428, -122.482369901671)
125543 86250 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2242 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2006 12:00:00 AM 3 3x3   5988568.6306529995 2100055.451314 37.7456931770541 -122.48225744501998 (37.7456931770541, -122.48225744502)
140305 86249 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2266 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2006 12:00:00 AM 3 3x3   5988574.227066 2099899.242089 37.7452645932744 -122.482226651217 (37.7452645932744, -122.482226651217)
88699 86200 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2379 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/19/2007 12:00:00 AM 3 3x3   5988870.37374 2099150.307919 37.743225438056605 -122.481147807758 (37.7432254380566, -122.481147807758)
145745 86213 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2487 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/19/2007 12:00:00 AM 3 3x3   5988895.867106 2098417.748537 37.74121550369679 -122.481006033613 (37.7412155036968, -122.481006033613)
106625 86214 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2491 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/23/2015 04:31:00 PM 3 3x3   5988896.775501 2098391.645558 37.7411438845393 -122.48100098197399 (37.7411438845393, -122.481000981974)
117047 90579 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2050X Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/15/2008 12:00:00 AM 3 3x3   5989191.56818 2110598.34198 37.774677325483 -122.480875193908 (37.774677325483, -122.480875193908)
11292 86217 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2621 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/11/2013 12:00:00 AM 3 3x3   5988925.7787 2097455.0086 37.7385738093546 -122.48083214346799 (37.7385738093546, -122.480832143468)
124769 86219 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2643 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/16/2007 12:00:00 AM 3 3x3   5988933.146151001 2097346.5203529997 37.7382763570454 -122.48079873027201 (37.7382763570454, -122.480798730272)
100006 86109 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2548 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/17/2007 12:00:00 AM 3 3x3   5988950.841471 2097988.149582 37.7400391325334 -122.480784510326 (37.7400391325334, -122.480784510326)
126105 86220 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2663 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/16/2007 12:00:00 AM 3 3x3   5988937.695499 2097215.793619 37.7379176798007 -122.480773433176 (37.7379176798007, -122.480773433176)
120189 86101 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2600X 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/16/2007 12:00:00 AM 3 3x3   5988963.56832 2097622.4377 37.7390357226089 -122.48071374038 (37.7390357226089, -122.48071374038)
121473 89675 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2543 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/07/2008 12:00:00 AM 3 3x3   5990673.7254 2111954.26646 37.7784863623151 -122.47584720917801 (37.7784863623151, -122.475847209178)
79576 89676 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2543 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/07/2008 12:00:00 AM 3 3x3   5990695.40247 2111954.91498 37.778489399756204 -122.47577226813999 (37.7784893997562, -122.47577226814)
111854 89677 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2543 Anza St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/07/2008 12:00:00 AM 3 3x3   5990716.34706 2111955.94773 37.7784934496742 -122.47569988906 (37.7784934496742, -122.47569988906)
107730 89678 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2543 Anza St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/07/2008 12:00:00 AM 3 3x3   5990738.94558 2111956.39246 37.77849598088871 -122.475621745513 (37.7784959808887, -122.475621745513)
103424 89679 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2531 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/07/2008 12:00:00 AM 3 3x3   5990763.229169999 2111957.72376 37.7785010440115 -122.47553783747601 (37.7785010440115, -122.475537837476)
127380 89680 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2501 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/07/2008 12:00:00 AM 3 3x3   5990849.40142 2111961.25142 37.778515724988 -122.47523999566299 (37.778515724988, -122.475239995663)
143190 89681 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2501 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/08/2008 12:00:00 AM 3 3x3   5990870.1336900005 2111960.99815 37.7785162312166 -122.47516825710899 (37.7785162312166, -122.475168257109)
77709 91916 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1555 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5990949.753071 2106534.898314 37.763622247809295 -122.47449673434299 (37.7636222478093, -122.474496734343)
111068 91917 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1555 Irving St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5990949.753071 2106534.898314 37.763622247809295 -122.47449673434299 (37.7636222478093, -122.474496734343)
123551 91915 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1555 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5990949.753071 2106534.898314 37.763622247809295 -122.47449673434299 (37.7636222478093, -122.474496734343)
107318 91905 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1550 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5990960.285269001 2106575.2825419996 37.7637337423119 -122.47446325445 (37.7637337423119, -122.47446325445)
144161 91904 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1550 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5990960.285269001 2106575.2825419996 37.7637337423119 -122.47446325445 (37.7637337423119, -122.47446325445)
96954 91903 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1534 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991007.891482 2106576.913236 37.7637409778654 -122.47429871990299 (37.7637409778654, -122.474298719903)
88045 91918 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1523 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991044.965492 2106538.159703 37.7636367187828 -122.474167665735 (37.7636367187828, -122.474167665735)
83935 91902 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1516 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991061.448475 2106578.7477680002 37.7637491175921 -122.474113618488 (37.7637491175921, -122.474113618488)
103727 91901 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1500 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991109.054689 2106580.378462 37.7637563526576 -122.473949083869 (37.7637563526576, -122.473949083869)
117924 91900 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1450X Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/20/2015 01:07:00 PM 3 3x3   5991277.7628190005 2106586.1574709998 37.763781990932 -122.47336600159201 (37.763781990932, -122.473366001592)
65800 91919 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1445 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991297.838563 2106546.8216959997 37.7636751478808 -122.47329369732799 (37.7636751478808, -122.473293697328)
122988 91920 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1443 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991304.074022 2106547.035288 37.7636760954029 -122.473272146607 (37.7636760954029, -122.473272146607)
86457 91921 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1437 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991322.7803879995 2106547.676066 37.763678937950296 -122.473207494478 (37.7636789379503, -122.473207494478)
109840 91922 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1431 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991341.4867589995 2106548.316844 37.7636817804625 -122.473142842328 (37.7636817804625, -122.473142842328)
118008 91898 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1428 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991346.352841 2106588.506989 37.763792413618106 -122.47312894339198 (37.7637924136181, -122.473128943392)
54134 91923 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1427 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991353.957672 2106548.744029 37.763683675450004 -122.473099740894 (37.76368367545, -122.473099740894)
138599 91924 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1419 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991378.8994970005 2106549.5983990002 37.7636874653776 -122.473013538025 (37.7636874653776, -122.473013538025)
141011 91897 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1410 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991402.471947 2106590.429322 37.7638009409158 -122.47293498664301 (37.7638009409158, -122.472934986643)
105547 91925 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1409 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/25/2012 12:00:00 AM 3 3x3   5991410.076781 2106550.6663619997 37.7636922027 -122.47290578441601 (37.7636922027, -122.472905784416)
111226 91896 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1400 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991433.649229 2106591.497285 37.7638056781662 -122.472827232872 (37.7638056781662, -122.472827232872)
86154 91926 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1401 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991435.018606 2106551.520732 37.7636959924857 -122.472819581527 (37.7636959924857, -122.472819581527)
4797 214559 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1342 Irving St 1 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 Width 3ft   5991532.56497 2106606.32246 37.7638521099028 -122.472486197695 (37.7638521099028, -122.472486197695)
4821 214558 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1340 Irving St 1 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2   02/18/2009 12:00:00 AM 4 Width 3ft   5991564.93185 2106609.34919 37.7638622938456 -122.472374472204 (37.7638622938456, -122.472374472204)
53189 91930 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1201X IRVING ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/11/2014 12:00:00 AM 3 3x3   5992070.0 2106573.0 37.7637917074669 -122.470624962715 (37.7637917074669, -122.470624962715)
87590 91928 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1201X IRVING ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 2 3x3   5992070.0 2106573.0 37.7637917074669 -122.470624962715 (37.7637917074669, -122.470624962715)
98111 91929 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1201X IRVING ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/11/2014 12:00:00 AM 2 3x3   5992070.0 2106573.0 37.7637917074669 -122.470624962715 (37.7637917074669, -122.470624962715)
100903 91931 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5992089.071506 2106573.92474 37.7637953493605 -122.470559068172 (37.7637953493605, -122.470559068172)
115072 91933 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199 Irving St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5992089.071506 2106573.92474 37.7637953493605 -122.470559068172 (37.7637953493605, -122.470559068172)
128216 91932 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5992089.071506 2106573.92474 37.7637953493605 -122.470559068172 (37.7637953493605, -122.470559068172)
143790 91892 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1140 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5992260.438373 2106619.818257 37.7639312683688 -122.46996970970899 (37.7639312683688, -122.469969709709)
93715 91891 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1134 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5992278.307636 2106620.430357 37.7639339819744 -122.469907950407 (37.7639339819744, -122.469907950407)
144626 91890 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1120 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5992320.002593 2106621.8585900003 37.763940313594496 -122.469763845315 (37.7639403135945, -122.469763845315)
19279 91934 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1115 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5992339.241228 2106582.494136 37.7638333412086 -122.46969443927 (37.7638333412086, -122.46969443927)
142920 91935 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1115 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5992339.241228 2106582.494136 37.7638333412086 -122.46969443927 (37.7638333412086, -122.46969443927)
51558 91889 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1112 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5992343.82828 2106622.674723 37.7639439315835 -122.46968149954701 (37.7639439315835, -122.469681499547)
143691 91888 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1104 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 02/18/2009 12:00:00 AM 3 3x3   5992367.653968 2106623.490856 37.763947549515 -122.469599153768 (37.763947549515, -122.469599153768)
20906 89402 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1914 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2008 12:00:00 AM 3 3x3   5992725.997880001 2112086.29643 37.7789676550624 -122.468757294436 (37.7789676550624, -122.468757294436)

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" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 1887.592ms · Data source: data.sfgov.org