Street_Tree_List

Data source: data.sfgov.org

1,397 rows where qSpecies = 19

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
37 226924 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Newburg St 1 Sidewalk: Property side : Pot 6 Tree 1 Private 1     11 Width 4ft   6002558.65829 2099967.6575700003 37.7462559468486 -122.433875776072 (37.7462559468486, -122.433875776072)
44 226925 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Newburg St 2 Sidewalk: Property side : Pot 6 Tree 1 Private 1     19 Width 4ft   6002565.841680001 2099976.66752 37.746281093695 -122.433851580699 (37.746281093695, -122.433851580699)
49 251186 Undocumented 2 Juniperus chinensis :: Juniper 19 3042 Steiner St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6002010.0 2118654.0 37.7975328515761 -122.437110618013 (37.7975328515761, -122.437110618013)
65 226926 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Newburg St 3 Sidewalk: Property side : Pot 6 Tree 1 Private 1     15 Width 4ft   6002574.76935 2099983.89995 37.7463014588644 -122.433821226777 (37.7463014588644, -122.433821226777)
265 109354 Undocumented 2 Juniperus chinensis :: Juniper 19 900x Chestnut St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     6 5x45   6007474.1784 2120601.5824599997 37.803189502164294 -122.418341225173 (37.8031895021643, -122.418341225173)
3534 253482 Significant Tree 6 Juniperus chinensis :: Juniper 19 2179 41st Ave 1 Front Yard : Yard 7 Tree 1 Private 1       3x5   5983532.0 2100331.0 37.74615550514321 -122.49969345420799 (37.7461555051432, -122.499693454208)
3549 253470 Significant Tree 6 Juniperus chinensis :: Juniper 19 3 Valletta Ct 2 Side Yard : Cutout 18 Tree 1 Private 1       6x10   5999319.0 2096479.0 37.736492551957895 -122.44482735214198 (37.7364925519579, -122.444827352142)
3709 253265 Significant Tree 6 Juniperus chinensis :: Juniper 19 180 San Aleso Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   09/19/2017 12:00:00 AM 3 3x3   5993319.0 2094440.0 37.730549723890206 -122.465423653439 (37.7305497238902, -122.465423653439)
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)
4549 226945 Significant Tree 6 Juniperus chinensis :: Juniper 19 998 Chenery St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 1ft   6001140.61217 2096125.6115299999 37.735626018710896 -122.438503967885 (37.7356260187109, -122.438503967885)
5604 19964 DPW Maintained 3 Juniperus chinensis :: Juniper 19 100 STAIRWAY41 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 25ST            
6044 107491 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 20 Median : Cutout 11 Tree 1 DPW 2     8     6011446.048280001 2119975.7461599996 37.8016938891322 -122.40455229795 (37.8016938891322, -122.40455229795)
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            
9555 105225 Private 5 Juniperus chinensis :: Juniper 19 175 Spruce St 1 Front Yard : Yard 7 Tree 1 Private 1     9     5997195.09596 2114417.64894 37.785626103218895 -122.453465347546 (37.7856261032189, -122.453465347546)
9867 118924 Undocumented 2 Juniperus chinensis :: Juniper 19 855 La Playa 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1   01/05/2017 12:00:00 AM 3 Width 4ft   5980738.40206 2109808.86226 37.772014669966396 -122.510057198601 (37.7720146699664, -122.510057198601)
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)
23498 176772 Undocumented 2 Juniperus chinensis :: Juniper 19 937 Silver Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 5ft   6007351.78047 2093548.13266 37.72890017978 -122.41684696742901 (37.72890017978, -122.416846967429)
23542 176768 Undocumented 2 Juniperus chinensis :: Juniper 19 955 Silver Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 4ft   6007502.25565 2093569.5745700002 37.7289675174267 -122.416328280725 (37.7289675174267, -122.416328280725)
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)
23730 219413 Undocumented 2 Juniperus chinensis :: Juniper 19 845 Detroit St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 6ft   5999418.48835 2095681.2919599998 37.734307911173204 -122.444426068323 (37.7343079111732, -122.444426068323)
23847 226860 Undocumented 2 Juniperus chinensis :: Juniper 19 99 Elk St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 2ft   6000812.22961 2096323.57705 37.7361509008315 -122.43965349751801 (37.7361509008315, -122.439653497518)
23881 129298 Undocumented 2 Juniperus chinensis :: Juniper 19 1287 Filbert St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   6006767.5192599995 2119403.73147 37.799860702966 -122.420701557924 (37.799860702966, -122.420701557924)
24179 226965 Undocumented 2 Juniperus chinensis :: Juniper 19 26 Danvers St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 1ft   5999778.9374 2105368.70326 37.7609277664162 -122.44387566164801 (37.7609277664162, -122.443875661648)
24188 247556 Undocumented 2 Juniperus chinensis :: Juniper 19 815 Buena Vista Ave West 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19 Width 2ft   6000035.32206 2108353.94379 37.7691391145131 -122.443203353661 (37.7691391145131, -122.443203353661)
24248 219332 Undocumented 2 Juniperus chinensis :: Juniper 19 1025 Junipero Serra Blvd 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5991262.77441 2090479.13965 37.719555381949206 -122.47224364333 (37.7195553819492, -122.47224364333)
24254 219293 Undocumented 2 Juniperus chinensis :: Juniper 19 480 Hearst Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 2ft   5998219.47976 2094421.4454299998 37.7307801864506 -122.448480709434 (37.7307801864506, -122.448480709434)
24631 176638 Undocumented 2 Juniperus chinensis :: Juniper 19 65 Santa Barbara Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 8ft   5993323.454919999 2086371.47099 37.7083957495352 -122.46482253315399 (37.7083957495352, -122.464822533154)
24727 129157 Undocumented 2 Juniperus chinensis :: Juniper 19 175 Spruce St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 3ft   5997198.13027 2114418.3589 37.785628226512706 -122.45345490104499 (37.7856282265127, -122.453454901045)
24753 129266 Undocumented 2 Juniperus chinensis :: Juniper 19 24 Priest St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 10ft   6008334.4403800005 2117141.01825 37.7937360410291 -122.41511915572399 (37.7937360410291, -122.415119155724)
24785 129216 Undocumented 2 Juniperus chinensis :: Juniper 19 2711 Vallejo St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 4ft   6000537.3614300005 2117487.89488 37.794247216575606 -122.442122575399 (37.7942472165756, -122.442122575399)
24884 109356 Undocumented 2 Juniperus chinensis :: Juniper 19 900x Chestnut St 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     11 5x45   6007464.49344 2120601.01033 37.8031873860571 -122.41837469975 (37.8031873860571, -122.41837469975)
24886 219309 Undocumented 2 Juniperus chinensis :: Juniper 19 322 Havelock St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 2ft   5998711.42236 2092939.4829099998 37.7267391799504 -122.446673405767 (37.7267391799504, -122.446673405767)
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)
25043 190777 Undocumented 2 Juniperus chinensis :: Juniper 19 1250 20th St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 3ft   6014189.92463 2104827.29978 37.760252667849706 -122.393996098953 (37.7602526678497, -122.393996098953)
25101 206960 Undocumented 2 Juniperus chinensis :: Juniper 19 546 Joost Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     5998473.38947 2095013.2793400001 37.7324197368658 -122.44764549463899 (37.7324197368658, -122.447645494639)
25117 219340 Undocumented 2 Juniperus chinensis :: Juniper 19 217 Orizaba Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 4ft   5993976.2548 2087899.9330400003 37.7126301615391 -122.462677198595 (37.7126301615391, -122.462677198595)
25137 129270 Undocumented 2 Juniperus chinensis :: Juniper 19 1369 Hyde St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 2ft   6007506.26777 2117001.25195 37.793305701954004 -122.417974800922 (37.793305701954, -122.417974800922)
25301 190759 Undocumented 2 Juniperus chinensis :: Juniper 19 960 Rhode Island St 1 : 4 Tree 1 Private 1     6 Width 2ft   6011851.68946 2103937.20655 37.757678438529894 -122.40202042759701 (37.7576784385299, -122.402020427597)
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)
25718 176724 Undocumented 2 Juniperus chinensis :: Juniper 19 1800 Silliman St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   6005480.83826 2092738.2956599998 37.7265711308422 -122.423257411423 (37.7265711308422, -122.423257411423)
26195 129135 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Chestnut St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 2ft   5999824.8933 2119535.0164400004 37.7998274397471 -122.444735000739 (37.7998274397471, -122.444735000739)
26334 129315 Undocumented 2 Juniperus chinensis :: Juniper 19 1847 Leavenworth St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   6007744.83863 2118772.65589 37.7981829610394 -122.417274913428 (37.7981829610394, -122.417274913428)
26463 226989 Undocumented 2 Juniperus chinensis :: Juniper 19 18 Arlington St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 4ft   6005175.47841 2097541.63022 37.739742778711204 -122.424654572944 (37.7397427787112, -122.424654572944)
26608 219368 Undocumented 2 Juniperus chinensis :: Juniper 19 151 Elmwood Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5994978.25407 2092702.73333 37.72587516529521 -122.45956163048099 (37.7258751652952, -122.459561630481)
26630 206935 Undocumented 2 Juniperus chinensis :: Juniper 19 105 Flood Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 8ft   6000034.8522 2094044.21533 37.7298480292542 -122.442177629193 (37.7298480292542, -122.442177629193)
26634 190806 Undocumented 2 Juniperus chinensis :: Juniper 19 1924 22nd St 3 : 4 Tree 1 Private 1     8 Width 2ft   6012287.449569999 2103786.76177 37.7572896615996 -122.400502813555 (37.7572896615996, -122.400502813555)
26732 219280 Undocumented 2 Juniperus chinensis :: Juniper 19 25 Paradise Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 1ft   6001093.95551 2095893.7470200001 37.734986718566105 -122.438648668815 (37.7349867185661, -122.438648668815)
26877 176791 Undocumented 2 Juniperus chinensis :: Juniper 19 241 Bowdoin St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19 Width 2ft   6008533.10117 2094294.56275 37.731016093010204 -122.41281579411199 (37.7310160930102, -122.412815794112)
26942 129350 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 38 Median : Yard 3 Tree 1 DPW 2     1 Width 8ft   6011425.50986 2120159.17711 37.8021963979046 -122.404636291051 (37.8021963979046, -122.404636291051)
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)
26975 129323 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Florence St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6008475.1891 2118345.56468 37.7970513368976 -122.414717435764 (37.7970513368976, -122.414717435764)
26978 176852 Undocumented 2 Juniperus chinensis :: Juniper 19 339 Athens St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 2ft   6004182.999 2091286.4234200001 37.7225112799465 -122.427640598252 (37.7225112799465, -122.427640598252)
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)
27272 206957 Undocumented 2 Juniperus chinensis :: Juniper 19 546 Joost Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1     5998473.21835 2095005.05828 37.7323971540007 -122.447645494648 (37.7323971540007, -122.447645494648)
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)
27303 129201 Undocumented 2 Juniperus chinensis :: Juniper 19 245 Marina Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6002306.14505 2121870.94259 37.8063825585658 -122.43631622670799 (37.8063825585658, -122.436316226708)
27318 176739 Undocumented 2 Juniperus chinensis :: Juniper 19 318 Princeton St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 4ft   6007769.14827 2092407.95318 37.725792959174 -122.41532341065 (37.725792959174, -122.41532341065)
27332 176698 Undocumented 2 Juniperus chinensis :: Juniper 19 283 Moscow St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6004617.240230001 2091470.03605 37.72303999319411 -122.42615258897 (37.7230399931941, -122.42615258897)
27490 129348 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 33 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   6011427.80927 2120135.82348 37.802132403051 -122.404626688974 (37.802132403051, -122.404626688974)
27504 117817 Undocumented 2 Juniperus chinensis :: Juniper 19 3900 Balboa St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 6ft   5983396.39556 2111078.07387 37.7756559745836 -122.50095702488899 (37.7756559745836, -122.500957024889)
27530 249494 Undocumented 2 Juniperus chinensis :: Juniper 19 1801 California St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 2ft   6005708.87609 2115852.08373 37.790049051771 -122.42411214416401 (37.790049051771, -122.424112144164)
27573 249744 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 28 : 4 Tree 1 Private 1     10 Width 1ft   6000231.5353 2117259.0230400003 37.793601361269396 -122.44316431948799 (37.7936013612694, -122.443164319488)
27727 129285 Undocumented 2 Juniperus chinensis :: Juniper 19 1725 Jones St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 2ft   6008285.46318 2118399.2200599997 37.79718799969079 -122.41537773598999 (37.7971879996908, -122.41537773599)
27860 176667 Undocumented 2 Juniperus chinensis :: Juniper 19 285 Santa Rosa Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 4ft   6000731.05105 2093595.2382 37.7286548942011 -122.43973861924499 (37.7286548942011, -122.439738619245)
27868 226847 Undocumented 2 Juniperus chinensis :: Juniper 19 565 Duncan St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   6002862.54514 2099747.2239599996 37.7456679278515 -122.43280922866501 (37.7456679278515, -122.432809228665)
27887 176613 Undocumented 2 Juniperus chinensis :: Juniper 19 263 Rome St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5998491.328480001 2088788.6230099997 37.7153293039925 -122.447135664507 (37.7153293039925, -122.447135664507)
27937 176651 Undocumented 2 Juniperus chinensis :: Juniper 19 314 Cayuga Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 2ft   6002207.18384 2094067.78615 37.730036314028 -122.434669323428 (37.730036314028, -122.434669323428)
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)
28072 176805 Undocumented 2 Juniperus chinensis :: Juniper 19 472 Gaven St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   6008072.53583 2094580.3018900002 37.7317748087483 -122.41442826236099 (37.7317748087483, -122.414428262361)
28078 129229 Undocumented 2 Juniperus chinensis :: Juniper 19 2711 Vallejo St 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 4ft   6000617.83995 2117501.7173200003 37.794289755430796 -122.44184510397 (37.7942897554308, -122.44184510397)
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)
28264 176811 Undocumented 2 Juniperus chinensis :: Juniper 19 77 Colby St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6008163.14276 2093697.53873 37.729356020957105 -122.414052586778 (37.7293560209571, -122.414052586778)
28290 124056 Undocumented 2 Juniperus chinensis :: Juniper 19 648 Funston Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 5ft   5991955.56775 2111031.62491 37.776027276009 -122.471345630007 (37.776027276009, -122.471345630007)
28378 226920 Undocumented 2 Juniperus chinensis :: Juniper 19 4112 23rd St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 2ft   6002387.67518 2102409.13417 37.75294995968729 -122.43464156316001 (37.7529499596873, -122.43464156316)
28406 219344 Undocumented 2 Juniperus chinensis :: Juniper 19 81 Byxbee St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   5991912.69269 2089165.54418 37.71598616072 -122.469901542523 (37.71598616072, -122.469901542523)
28529 129173 Undocumented 2 Juniperus chinensis :: Juniper 19 2901 Steiner St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 2ft   6001992.763069999 2118215.18241 37.7963269932617 -122.437138827596 (37.7963269932617, -122.437138827596)
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)

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