Street_Tree_List

Data source: data.sfgov.org

1,397 rows where qSpecies = 19 sorted by qSiteInfo

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo ▼ PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
4190 100829 Undocumented 2 Juniperus chinensis :: Juniper 19 1601X North Point St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6003036.60353 2120959.36193 37.803921074561295 -122.43372315391198 (37.8039210745613, -122.433723153912)
5604 19964 DPW Maintained 3 Juniperus chinensis :: Juniper 19 100 STAIRWAY41 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 25ST            
8096 19962 DPW Maintained 3 Juniperus chinensis :: Juniper 19 100 STAIRWAY41 -2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 25ST            
8375 100825 Undocumented 2 Juniperus chinensis :: Juniper 19 3661 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6003069.70231 2120954.84645 37.803910554290795 -122.43360829069401 (37.8039105542908, -122.433608290694)
8632 99720 Undocumented 2 Juniperus chinensis :: Juniper 19 2164 Hyde St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6007185.20399 2119756.67852 37.8008533386708 -122.41928126041701 (37.8008533386708, -122.419281260417)
9264 19963 DPW Maintained 3 Juniperus chinensis :: Juniper 19 100 STAIRWAY41 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 25ST            
10717 25296 Permitted Site 1 Juniperus chinensis :: Juniper 19 158 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6000552.574130001 2091731.5353 37.723527432941204 -122.44022202823 (37.7235274329412, -122.44022202823)
11045 27100 Permitted Site 1 Juniperus chinensis :: Juniper 19 675 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 3X3   6005860.0759 2093589.7540900002 37.728930444682206 -122.422006859139 (37.7289304446822, -122.422006859139)
11331 1100 DPW Maintained 3 Juniperus chinensis :: Juniper 19 2328 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   5999423.31284 2089282.1433599999 37.71673760544579 -122.44394976577298 (37.7167376054458, -122.443949765773)
11566 16410 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1186X Munich St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 TR   6001066.26402 2087197.59203 37.7111074743937 -122.43812166787501 (37.7111074743937, -122.438121667875)
12269 106828 Undocumented 2 Juniperus chinensis :: Juniper 19 631 Hamilton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   6009794.12958 2091448.15219 37.7232711495323 -122.40825550289 (37.7232711495323, -122.40825550289)
14463 110915 Undocumented 2 Juniperus chinensis :: Juniper 19 77 Federal St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 2x1   6014720.0191 2113052.86526 37.7828676936327 -122.39273818212 (37.7828676936327, -122.39273818212)
14648 19819 DPW Maintained 3 Juniperus chinensis :: Juniper 19 100 STAIRWAY25 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 100ST            
15377 25938 DPW Maintained 3 Juniperus chinensis :: Juniper 19 2000 Oakdale Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/22/1997 12:00:00 AM 12 3x3   6012867.3394 2097145.5573099998 37.739086658519895 -122.39803142710899 (37.7390866585199, -122.398031427109)
15925 25939 DPW Maintained 3 Juniperus chinensis :: Juniper 19 2000 Oakdale Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/22/1997 12:00:00 AM 10 3x3   6012857.31615 2097153.53613 37.7391080084261 -122.39806664277201 (37.7391080084261, -122.398066642772)
16907 16140 Permitted Site 1 Juniperus chinensis :: Juniper 19 370 Monterey Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   5999741.99698 2094725.2386 37.7317012657937 -122.44323895423099 (37.7317012657937, -122.443238954231)
16920 19979 DPW Maintained 3 Juniperus chinensis :: Juniper 19 100 STAIRWAY45 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 30ST            
17854 4283 Permitted Site 1 Juniperus chinensis :: Juniper 19 4301 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/07/1995 12:00:00 AM 3 3X3   6001860.11761 2100274.84005 37.7470597321331 -122.436313221179 (37.7470597321331, -122.436313221179)
17954 16098 DPW Maintained 3 Juniperus chinensis :: Juniper 19 300 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/17/1997 12:00:00 AM 6 2X3   6000050.52204 2094718.8331 37.7317012658005 -122.442171864536 (37.7317012658005, -122.442171864536)
18293 4370 Permitted Site 1 Juniperus chinensis :: Juniper 19 998 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/1992 12:00:00 AM 12 3X3   6001204.190330001 2096097.5771700002 37.7355526592134 -122.438282146497 (37.7355526592134, -122.438282146497)
18654 16099 DPW Maintained 3 Juniperus chinensis :: Juniper 19 300 Monterey Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000036.69943 2094718.89433 37.7317006461483 -122.442219656332 (37.7317006461483, -122.442219656332)
18666 19313 DPW Maintained 3 Juniperus chinensis :: Juniper 19 21 Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   5993901.63447 2089816.98545 37.7178896324771 -122.463074115289 (37.7178896324771, -122.463074115289)
19631 16102 DPW Maintained 3 Juniperus chinensis :: Juniper 19 300 Monterey Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000017.68556 2094719.9660099999 37.7317025050652 -122.442285467815 (37.7317025050652, -122.442285467815)
21152 4284 Permitted Site 1 Juniperus chinensis :: Juniper 19 4301 Cesar Chavez St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/07/1995 12:00:00 AM 3 3X3   6001863.40945 2100279.02786 37.747071417908 -122.43630213795299 (37.747071417908, -122.436302137953)
21395 16100 DPW Maintained 3 Juniperus chinensis :: Juniper 19 300 Monterey Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000028.57256 2094720.41703 37.7317043639536 -122.442247861742 (37.7317043639536, -122.442247861742)
21593 16127 DPW Maintained 3 Juniperus chinensis :: Juniper 19 330 Monterey Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   5999874.93833 2094721.1240700001 37.7316975479954 -122.442779055318 (37.7316975479954, -122.442779055318)
22554 17779 Permitted Site 1 Juniperus chinensis :: Juniper 19 1777 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6005479.2802 2115475.38688 37.789001770571296 -122.424879716433 (37.7890017705713, -122.424879716433)
23567 137685 Undocumented 2 Juniperus chinensis :: Juniper 19 720 BAKER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6000552.856000001 2111474.7278 37.7777374972355 -122.441637228704 (37.7777374972355, -122.441637228704)
24920 226888 Undocumented 2 Juniperus chinensis :: Juniper 19 295 Coso Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6007787.28925 2099470.27806 37.745185579151396 -122.415760542322 (37.7451855791514, -122.415760542322)
25548 71937 Undocumented 2 Juniperus chinensis :: Juniper 19 1053 Montgomery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/21/1995 12:00:00 AM 4     6011562.24883 2118965.23166 37.7989257551836 -122.404079031531 (37.7989257551836, -122.404079031531)
26965 66051 Permitted Site 1 Juniperus chinensis :: Juniper 19 1632 North Point St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/31/1990 12:00:00 AM 12   Permit Number 29090 6002925.71156 2121006.29112 37.8040436368686 -122.434110258988 (37.8040436368686, -122.434110258988)
27010 61931 Permitted Site 1 Juniperus chinensis :: Juniper 19 1407 Montgomery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/11/1985 12:00:00 AM 11   Permit Number 21986 6011381.98525 2120211.6051 37.8023379197065 -122.404790601229 (37.8023379197065, -122.404790601229)
27285 118936 Undocumented 2 Juniperus chinensis :: Juniper 19 882 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5981106.21349 2109713.8297599996 37.7717754261179 -122.508777876355 (37.7717754261179, -122.508777876355)
28070 190826 Undocumented 2 Juniperus chinensis :: Juniper 19 256 Terry A Francois Blvd 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 6ft   6016386.63874 2108737.40916 37.771110828636296 -122.38667129537 (37.7711108286363, -122.38667129537)
28089 94904 Permitted Site 1 Juniperus chinensis :: Juniper 19 3701 Clay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x3   5997050.00292 2115323.90542 37.788106124051 -122.454032799976 (37.788106124051, -122.454032799976)
28768 110918 Undocumented 2 Juniperus chinensis :: Juniper 19 77 Federal St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 2x1   6014775.51071 2113108.67341 37.7830240119856 -122.392550107818 (37.7830240119856, -122.392550107818)
30388 226889 Undocumented 2 Juniperus chinensis :: Juniper 19 21 Bradford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6009640.71829 2098586.38073 37.7428626087272 -122.409289311345 (37.7428626087272, -122.409289311345)
30510 30812 Permitted Site 1 Juniperus chinensis :: Juniper 19 100 Joost Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/06/1995 12:00:00 AM 5   Permit Number 34674 6001381.93618 2094967.05294 37.7324586091634 -122.43758667648001 (37.7324586091634, -122.43758667648)
30977 226957 Undocumented 2 Juniperus chinensis :: Juniper 19 4415 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6001675.32551 2104070.79205 37.75747200635521 -122.437223965526 (37.7574720063552, -122.437223965526)
32407 866 DPW Maintained 3 Juniperus chinensis :: Juniper 19 600X Alemany Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 1X1   6007241.9784 2095034.8696299999 37.7329762592527 -122.41733187808398 (37.7329762592527, -122.417331878084)
33037 60417 Permitted Site 1 Juniperus chinensis :: Juniper 19 1409 Keith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/26/1982 12:00:00 AM 8   Permit Number 19998 6016082.74679 2094573.4644900002 37.732202770925205 -122.386734593253 (37.7322027709252, -122.386734593253)
35096 103483 Permitted Site 1 Juniperus chinensis :: Juniper 19 116 Merrill St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/03/2013 12:00:00 AM 2 3x3 Permit Number 770307 6009546.84586 2094694.0586599999 37.73216987282029 -122.409339274108 (37.7321698728203, -122.409339274108)
35098 142469 Undocumented 2 Juniperus chinensis :: Juniper 19 548 VARENNES ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6010746.4928 2119899.9648 37.8014466914345 -122.40696774883999 (37.8014466914345, -122.40696774884)
35180 68976 Permitted Site 1 Juniperus chinensis :: Juniper 19 2550 Chestnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/04/1994 12:00:00 AM 7   Permit Number 32966 5999654.77227 2119511.53893 37.7997532672523 -122.44532199182301 (37.7997532672523, -122.445321991823)
35782 190765 Undocumented 2 Juniperus chinensis :: Juniper 19 1050 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6015259.20985 2101616.65669 37.751496295539106 -122.39007361861601 (37.7514962955391, -122.390073618616)
36439 226890 Undocumented 2 Juniperus chinensis :: Juniper 19 257 Montcalm St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   6009790.06992 2099605.20569 37.7456684458592 -122.408844757605 (37.7456684458592, -122.408844757605)
36482 226955 Undocumented 2 Juniperus chinensis :: Juniper 19 160 Bradford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6009521.12916 2097699.3584 37.7404203378164 -122.409640225031 (37.7404203378164, -122.409640225031)
37590 176608 Undocumented 2 Juniperus chinensis :: Juniper 19 245 Chicago Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 2ft   6002866.9269 2086792.03649 37.710096150800794 -122.431869203328 (37.7100961508008, -122.431869203328)
38511 245190 Undocumented 2 Juniperus chinensis :: Juniper 19 1165 Page St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6000954.6073 2109297.4919 37.7717822376068 -122.440091274084 (37.7717822376068, -122.440091274084)
38642 176865 Undocumented 2 Juniperus chinensis :: Juniper 19 1142 Munich St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6001491.17517 2087075.7451099998 37.7107970662038 -122.436644357861 (37.7107970662038, -122.436644357861)
38700 64762 Permitted Site 1 Juniperus chinensis :: Juniper 19 648 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/09/1988 12:00:00 AM 8   Permit Number 25739 5991956.18292 2111010.7557900003 37.7759700106605 -122.471341981082 (37.7759700106605, -122.471341981082)
39031 118935 Undocumented 2 Juniperus chinensis :: Juniper 19 882 48th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5981106.559230001 2109729.9345299997 37.7718196654774 -122.50877787634701 (37.7718196654774, -122.508777876347)
39856 129108 Undocumented 2 Juniperus chinensis :: Juniper 19 155 Retiro Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001855.64531 2121684.5263400003 37.805845102121296 -122.43786189781 (37.8058451021213, -122.43786189781)
39860 42981 Permitted Site 1 Juniperus chinensis :: Juniper 19 387 Princeton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2000 12:00:00 AM 9   Permit Number 42865 6007925.78486 2092082.5600700001 37.7249083014575 -122.414758909799 (37.7249083014575, -122.414758909799)
40280 227021 Undocumented 2 Juniperus chinensis :: Juniper 19 123 Manchester St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6008281.58077 2099209.78469 37.7444980969188 -122.414032936584 (37.7444980969188, -122.414032936584)
40696 219275 Undocumented 2 Juniperus chinensis :: Juniper 19 1651 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 2ft   5993370.433230001 2104236.7588299997 37.7574521115395 -122.465957429918 (37.7574521115395, -122.465957429918)
41354 184569 Undocumented 2 Juniperus chinensis :: Juniper 19 3943 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5981967.8868 2103494.6521 37.7547501020315 -122.505336310147 (37.7547501020315, -122.505336310147)
44115 31115 Permitted Site 1 Juniperus chinensis :: Juniper 19 450 Edna St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/21/1995 12:00:00 AM 5   Permit Number 34839 5998792.06252 2094332.58617 37.7305689213091 -122.44649481749201 (37.7305689213091, -122.446494817492)
44382 54527 Permitted Site 1 Juniperus chinensis :: Juniper 19 4550 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/31/1972 12:00:00 AM 8 3x5 Permit Number 10322 5981462.67511 2111006.65453 37.775346149152 -122.507640822085 (37.775346149152, -122.507640822085)
44824 68547 Permitted Site 1 Juniperus chinensis :: Juniper 19 526 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/18/1993 12:00:00 AM 9   Permit Number 32434 5982567.23967 2112157.10709 37.7785699651083 -122.50390516811599 (37.7785699651083, -122.503905168116)
45751 248141 Undocumented 2 Juniperus chinensis :: Juniper 19 274 Rutledge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 2ft   6009875.37752 2099433.39728 37.745201475562794 -122.408537657996 (37.7452014755628, -122.408537657996)
46536 176864 Undocumented 2 Juniperus chinensis :: Juniper 19 1142 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6001508.44833 2087074.49051 37.710794602952106 -122.436584568222 (37.7107946029521, -122.436584568222)
46668 32026 Permitted Site 1 Juniperus chinensis :: Juniper 19 910 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/15/2005 12:00:00 AM 2   Permit Number 48084 6011942.61594 2111635.52885 37.7788213676447 -122.40224721144399 (37.7788213676447, -122.402247211444)
46998 44750 Permitted Site 1 Juniperus chinensis :: Juniper 19 524 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/2001 12:00:00 AM 3   Permit Number 43866 5987216.13778 2112350.62215 37.779373569745104 -122.487837284703 (37.7793735697451, -122.487837284703)
48359 66778 Permitted Site 1 Juniperus chinensis :: Juniper 19 1335 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/20/1991 12:00:00 AM 5   Permit Number 30043 6006555.48078 2119018.76457 37.798791728305396 -122.42140793763001 (37.7987917283054, -122.42140793763)
49176 190825 Undocumented 2 Juniperus chinensis :: Juniper 19 256 Terry A Francois Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 6ft   6016379.81466 2108741.5288400003 37.771121762579604 -122.38669518764699 (37.7711217625796, -122.386695187647)
49793 53948 Permitted Site 1 Juniperus chinensis :: Juniper 19 106 Gaven St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/15/2012 12:00:00 AM 10   Permit Number 769123 6009998.5111 2095243.6282 37.733704169294 -122.407816497929 (37.733704169294, -122.407816497929)
50164 107054 Undocumented 2 Juniperus chinensis :: Juniper 19 98X ROTTECK ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 2x2   6003385.0 2094496.0 37.731278888142704 -122.43062801306999 (37.7312788881427, -122.43062801307)
51393 190771 Undocumented 2 Juniperus chinensis :: Juniper 19 15 Tubbs St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 2ft   6015464.37774 2103329.09363 37.7562096621716 -122.389483695716 (37.7562096621716, -122.389483695716)
52562 219270 Undocumented 2 Juniperus chinensis :: Juniper 19 1220 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   5991777.52525 2107074.159 37.7651508397576 -122.47167305767701 (37.7651508397576, -122.471673057677)
52693 219257 Undocumented 2 Juniperus chinensis :: Juniper 19 1948 16th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 1ft   5991302.37835 2102159.67648 37.7516294680371 -122.47295805847 (37.7516294680371, -122.47295805847)
54321 70512 Undocumented 2 Juniperus chinensis :: Juniper 19 75 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/25/1994 12:00:00 AM 5     6004917.4216 2092965.0192099998 37.7271618505134 -122.425221249286 (37.7271618505134, -122.425221249286)
54348 183004 Undocumented 2 Juniperus chinensis :: Juniper 19 2550 Ulloa St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5988132.401000001 2098265.1638 37.7407521359399 -122.483634610884 (37.7407521359399, -122.483634610884)
54473 103306 Undocumented 2 Juniperus chinensis :: Juniper 19 611 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15     6011832.19369 2105491.00064 37.7619437242424 -122.402197092231 (37.7619437242424, -122.402197092231)
54634 184594 Undocumented 2 Juniperus chinensis :: Juniper 19 1738 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5984424.6596 2103325.6175 37.754430240283796 -122.496827772507 (37.7544302402838, -122.496827772507)
55719 110572 Undocumented 2 Juniperus chinensis :: Juniper 19 46 COOK ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15     5997534.0 2113434.0 37.782944683725 -122.45222184269899 (37.782944683725, -122.452221842699)
56126 123951 Undocumented 2 Juniperus chinensis :: Juniper 19 394 08th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   5993436.16113 2112921.30545 37.7813013648658 -122.46636127827101 (37.7813013648658, -122.466361278271)
56417 190827 Undocumented 2 Juniperus chinensis :: Juniper 19 256 Terry A Francois Blvd 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 6ft   6016391.891340001 2108709.42861 37.771034290942204 -122.386651174818 (37.7710342909422, -122.386651174818)
56530 129361 Undocumented 2 Juniperus chinensis :: Juniper 19 555 California St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6011684.8742 2116686.03693 37.7926744848808 -122.403494267154 (37.7926744848808, -122.403494267154)
56672 96034 Permitted Site 1 Juniperus chinensis :: Juniper 19 1075 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/02/2011 12:00:00 AM 3 3x3 Permit Number 767673 6008986.730930001 2117980.65751 37.7960781193685 -122.41292155709999 (37.7960781193685, -122.4129215571)
56837 65503 Permitted Site 1 Juniperus chinensis :: Juniper 19 2727 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/1989 12:00:00 AM 5   Permit Number 28387 6000480.85647 2117478.59942 37.7942184733604 -122.442317420725 (37.7942184733604, -122.442317420725)
58086 190766 Undocumented 2 Juniperus chinensis :: Juniper 19 1400 Minnesota St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6015346.06271 2101819.81527 37.752058942870995 -122.389787457026 (37.752058942871, -122.389787457026)
58423 226867 Undocumented 2 Juniperus chinensis :: Juniper 19 23 Juri St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   6005990.48773 2101222.9851599997 37.7498969403125 -122.422098075583 (37.7498969403125, -122.422098075583)
59244 71583 Undocumented 2 Juniperus chinensis :: Juniper 19 266 Flournoy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 7     5993925.4185 2086705.1573599998 37.7093466620935 -122.462766282735 (37.7093466620935, -122.462766282735)
61110 92458 Permitted Site 1 Juniperus chinensis :: Juniper 19 3319 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/30/2009 12:00:00 AM 1 3x3 Permit Number 52848 5983933.4582 2104246.8072 37.756930776386795 -122.498594490514 (37.7569307763868, -122.498594490514)
61376 43140 Permitted Site 1 Juniperus chinensis :: Juniper 19 1 Gambier St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/11/2000 12:00:00 AM 3   Permit Number 42953 6005716.6320400005 2093488.3927799999 37.7286440375939 -122.42249555614299 (37.7286440375939, -122.422495556143)
61910 245187 Undocumented 2 Juniperus chinensis :: Juniper 19 1195 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6000895.0351 2109289.4071 37.7717566471657 -122.44029675786501 (37.7717566471657, -122.440296757865)
62195 84689 Undocumented 2 Juniperus chinensis :: Juniper 19 3632 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   3     6002195.05393 2120739.39081 37.80326930438871 -122.436619630107 (37.8032693043887, -122.436619630107)
62256 226935 Undocumented 2 Juniperus chinensis :: Juniper 19 1487 Noe St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6003327.81293 2099584.98733 37.7452488410797 -122.431188824809 (37.7452488410797, -122.431188824809)
62290 184570 Undocumented 2 Juniperus chinensis :: Juniper 19 3941 Moraga St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5981986.5378 2103495.1429 37.754752547113206 -122.505271847368 (37.7547525471132, -122.505271847368)
63477 184595 Undocumented 2 Juniperus chinensis :: Juniper 19 1738 38th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5984423.6443 2103335.7702 37.7544580572925 -122.496832032885 (37.7544580572925, -122.496832032885)
64687 31118 Permitted Site 1 Juniperus chinensis :: Juniper 19 450 Edna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/21/1995 12:00:00 AM 7   Permit Number 34839 5998792.48559 2094316.2837 37.730524182724 -122.446492182475 (37.730524182724, -122.446492182475)
65282 118037 Undocumented 2 Juniperus chinensis :: Juniper 19 3421 Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   5984874.28781 2113152.5227900003 37.7814384776062 -122.49599778017401 (37.7814384776062, -122.495997780174)
69062 35257 Permitted Site 1 Juniperus chinensis :: Juniper 19 2363 Larkin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/26/2001 12:00:00 AM 2   Permit Number 43818 6006687.16748 2119377.40243 37.799783881083606 -122.420977735243 (37.7997838810836, -122.420977735243)
70097 58139 Permitted Site 1 Juniperus chinensis :: Juniper 19 378 Gaven St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/07/1978 12:00:00 AM 7   Permit Number 17123 6008540.16815 2094753.5725900002 37.7322768319131 -122.412823801697 (37.7322768319131, -122.412823801697)
70285 190830 Undocumented 2 Juniperus chinensis :: Juniper 19 256 Terry A Francois Blvd 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 6ft   6016394.93406 2108680.04428 37.770953776427895 -122.38663860051001 (37.7709537764279, -122.38663860051)
71205 190824 Undocumented 2 Juniperus chinensis :: Juniper 19 256 Terry A Francois Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 6ft   6016384.03812 2108752.66613 37.7711525769716 -122.38668135517901 (37.7711525769716, -122.386681355179)
73520 226921 Undocumented 2 Juniperus chinensis :: Juniper 19 75 Zircon Pl 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002389.45965 2098613.58305 37.7425283720786 -122.434364050378 (37.7425283720786, -122.434364050378)
75317 34709 Permitted Site 1 Juniperus chinensis :: Juniper 19 727 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1997 12:00:00 AM 25   Permit Number 38365 5981632.43118 2110780.81019 37.7747360459971 -122.50703684968501 (37.7747360459971, -122.507036849685)
76264 44486 Permitted Site 1 Juniperus chinensis :: Juniper 19 390 Harvard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/26/2001 12:00:00 AM 16   Permit Number 43792 6006402.34332 2092081.2102700002 37.724818880074395 -122.420025186814 (37.7248188800744, -122.420025186814)

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 964.975ms · Data source: data.sfgov.org