Street_Tree_List

Data source: data.sfgov.org

104 rows where qSpecies = 306

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
18212 18212 16145 DPW Maintained 3 Pinus thunbergii :: Japanese Black Pine 306 370 Monterey Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   5999721.38347 2094725.6667 37.7317012658025 -122.443310249792 (37.7317012658025, -122.443310249792)
19761 19761 4282 DPW Maintained 3 Pinus thunbergii :: Japanese Black Pine 306 4301 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/1995 12:00:00 AM 3 3X3   6001859.22547 2100283.37005 37.7470831028056 -122.436316916491 (37.7470831028056, -122.436316916491)
21814 21814 11202 DPW Maintained 3 Pinus thunbergii :: Japanese Black Pine 306 100 Idora Ave 5 Median : Cutout 11 Tree 1 DPW 2     3 8   5995328.17404 2099416.28223 37.744329043248 -122.458837831796 (37.744329043248, -122.458837831796)
21902 21902 1342 DPW Maintained 3 Pinus thunbergii :: Japanese Black Pine 306 175 Amber Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     11 3x3   5999365.68441 2099383.1046 37.7444691945119 -122.444874639375 (37.7444691945119, -122.444874639375)
25843 25843 121699 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 1002 Pennsylvania Ave 1 Front Yard : Yard 7 Tree 1 Private 1     13     6014459.10408 2102474.46412 37.753807243829 -122.392900512462 (37.753807243829, -122.392900512462)
25864 25864 211289 DPW Maintained 3 Pinus thunbergii :: Japanese Black Pine 306 100x Idora Ave 8 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   5995366.53481 2099407.6063200003 37.744307426259205 -122.45870456127399 (37.7443074262592, -122.458704561274)
25944 25944 233355 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 45 Clarendon Ave 1 : 4 Tree 1 Private 1     1 Width 3ft   5998067.992430001 2104637.9237599997 37.758823486839 -122.449740378141 (37.758823486839, -122.449740378141)
26840 26840 194523 DPW Maintained 3 Pinus thunbergii :: Japanese Black Pine 306 900x Carolina St 72 Median : Yard 3 Tree 1 DPW 2     3     6012512.869530001 2102814.17539 37.7546317206991 -122.399654931846 (37.7546317206991, -122.399654931846)
30041 30041 185552 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 2201 Sunset Blvd 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984872.5433 2099849.2038 37.7449111938902 -122.49502257363001 (37.7449111938902, -122.49502257363)
31310 31310 249769 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 295 Kearny St 1 Side Yard : Yard 17 Tree 1 Private 1     17 Width 0ft   6010840.59654 2120830.53405 37.8040070713206 -122.40670772380399 (37.8040070713206, -122.406707723804)
34597 34597 211298 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 401 Orizaba Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     17 Width 5ft   5993996.41913 2089243.4812200002 37.7163203865396 -122.462704908526 (37.7163203865396, -122.462704908526)
35606 35606 194522 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 1901 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6012357.59837 2104667.69844 37.7597124315988 -122.400322083115 (37.7597124315988, -122.400322083115)
38355 38355 211292 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 611 Joost Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     5998050.98458 2094962.27649 37.7322555449463 -122.44910216795401 (37.7322555449463, -122.449102167954)
39042 39042 117760 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 446 39th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   5983798.11714 2112817.23967 37.780454798053704 -122.49969596271002 (37.7804547980537, -122.49969596271)
41326 41326 211296 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 131 De Montfort Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5994879.33842 2091873.5319299998 37.7235926895479 -122.459843534659 (37.7235926895479, -122.459843534659)
43348 43348 178349 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 111 Brunswick St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 1ft   6000769.98227 2087401.03003 37.7116492152228 -122.439160258941 (37.7116492152228, -122.439160258941)
44232 44232 233346 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 4330 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     48 Width 8ft   6001739.83131 2100612.12981 37.747979014615396 -122.436753300851 (37.7479790146154, -122.436753300851)
46389 46389 248236 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 298 Esmeralda Ave 1 Side Yard : Yard 17 Tree 1 Private 1     15     6006718.26384 2099043.39902 37.743953311000396 -122.419426777927 (37.7439533110004, -122.419426777927)
47043 47043 218382 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 398 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 0ft   5993337.236740001 2100038.78351 37.745923633871605 -122.465767234987 (37.7459236338716, -122.465767234987)
47582 47582 211308 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 279 Staples Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10     5998250.2565 2093776.2866900002 37.7290104924178 -122.448327868763 (37.7290104924178, -122.448327868763)
49375 49375 247234 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 760 Duboce Ave 6 : 4 Tree 1 Private 1     14 Width 3ft   6001984.23869 2108361.47681 37.7692707347891 -122.43646271190399 (37.7692707347891, -122.436462711904)
49584 49584 178353 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 648 Peru Ave 5 Side Yard : Yard 17 Tree 1 Private 1     5     6005050.25442 2092601.27902 37.7261706033722 -122.42473618194599 (37.7261706033722, -122.424736181946)
52121 52121 124178 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 8X Almaden Ct 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   5995876.0 2112606.0 37.7805760973259 -122.457897862346 (37.7805760973259, -122.457897862346)
52644 52644 211300 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 414 Bright St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   5993792.16913 2089952.0558 37.7182541969442 -122.463462282481 (37.7182541969442, -122.463462282481)
57593 57593 233350 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 565 Duncan St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   6002880.03103 2099748.3618799997 37.7456720440331 -122.43274884639 (37.7456720440331, -122.43274884639)
58150 58150 211299 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 212 Vernon St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 3ft   5992481.14355 2089300.95007 37.71639079536521 -122.46794656929701 (37.7163907953652, -122.467946569297)
58927 58927 250343 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 26 25th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 3ft   5988241.896240001 2115839.31927 37.7890123214057 -122.484544764541 (37.7890123214057, -122.484544764541)
59074 59074 118585 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 110 Point Lobos Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     5982437.76166 2112637.90018 37.779882467259704 -122.504388702469 (37.7798824672597, -122.504388702469)
59530 59530 182723 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 1711 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5988092.6268 2103646.3239 37.7555250536563 -122.484166667612 (37.7555250536563, -122.484166667612)
60252 60252 72619 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 1501 25th St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/01/1997 12:00:00 AM 3     6014112.41044 2101961.52593 37.752379561976596 -122.394063561604 (37.7523795619766, -122.394063561604)
60870 60870 185958 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 2001 Sunset Blvd 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984827.369 2101371.4447 37.749088207557996 -122.495291014826 (37.749088207558, -122.495291014826)
62367 62367 247233 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 760 Duboce Ave 5 : 4 Tree 1 Private 1     14 Width 3ft   6001988.83207 2108291.886 37.7690799166222 -122.43644184221701 (37.7690799166222, -122.436441842217)
62800 62800 211305 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 517 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   5998007.82489 2095231.9936 37.732993655423705 -122.449270805203 (37.7329936554237, -122.449270805203)
62843 62843 250469 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 330 Seacliff Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5986766.23887 2115556.12451 37.78814870693171 -122.489629442364 (37.7881487069317, -122.489629442364)
64395 64395 194525 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 3525 Jennings St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6013063.15415 2089423.8639099998 37.7178953710405 -122.3968131803 (37.7178953710405, -122.3968131803)
64607 64607 117689 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 420 43rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5982541.98731 2112946.86538 37.780736924401495 -122.50405103744 (37.7807369244015, -122.50405103744)
66580 66580 183499 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 2547 22nd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5989528.9054 2098003.0930000003 37.740113745672396 -122.47878691773701 (37.7401137456724, -122.478786917737)
67070 67070 233354 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 4371 21st St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 10ft   6000771.43115 2103216.78059 37.7550756746059 -122.440288742632 (37.7550756746059, -122.440288742632)
69922 69922 250705 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 50 McLaren Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     5986855.9140800005 2114891.44355 37.786328919774704 -122.489270296302 (37.7863289197747, -122.489270296302)
69938 69938 233348 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 500 Grand View Ave 2 Front Yard : Yard 7 Tree 1 Private 1     2     5999981.0891 2101715.6786 37.7509089833601 -122.442914174867 (37.7509089833601, -122.442914174867)
72293 72293 183498 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 2547 22nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5989527.6597 2098025.0998 37.740174098306206 -122.47879283391701 (37.7401740983062, -122.478792833917)
72496 72496 233342 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 515 Powhattan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23     6008414.51458 2098134.88784 37.7415541329249 -122.413497270696 (37.7415541329249, -122.413497270696)
72794 72794 211301 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 22 Sargent St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 4ft   5993918.24857 2089205.7501299998 37.716212283538106 -122.462972366002 (37.7162122835381, -122.462972366002)
73793 73793 132210 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 21 Hastings Ter 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 10ft   6007287.11511 2119268.83757 37.79951958921961 -122.418893985392 (37.7995195892196, -122.418893985392)
74267 74267 178350 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 239 Peninsula Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6012479.39817 2087413.73927 37.7123434603661 -122.398689994354 (37.7123434603661, -122.398689994354)
74286 74286 95709 Permitted Site 1 Pinus thunbergii :: Japanese Black Pine 306 277 Athens St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/12/2009 12:00:00 AM 6 3x3 Permit Number 767467 6004405.4193400005 2091654.9700099998 37.7235358065292 -122.42689797588699 (37.7235358065292, -122.426897975887)
76620 76620 211304 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 100 Melrose Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 5ft   5999410.34082 2095532.95691 37.7339001531733 -122.444443579902 (37.7339001531733, -122.444443579902)
94574 94574 114097 Significant Tree 6 Pinus thunbergii :: Japanese Black Pine 306 221x VIDAL DR 1 Front Yard : Yard 7 Tree 1 Private 1     14     5987664.0 2090556.0 37.7195574904968 -122.484688777519 (37.7195574904968, -122.484688777519)
112600 112600 113194 DPW Maintained 3 Pinus thunbergii :: Japanese Black Pine 306 699X Noe St 1 Median : Yard 3 Tree 1 DPW 2     12     6003039.779709999 2104315.51778 37.7582214335608 -122.432522620301 (37.7582214335608, -122.432522620301)
125116 125116 806 DPW Maintained 3 Pinus thunbergii :: Japanese Black Pine 306 600X 39th Ave 4 Median : Cutout 11 Tree 1 DPW 2     6 6-HOA   5983808.23309 2111660.7549099997 37.777280020650295 -122.499575472587 (37.7772800206503, -122.499575472587)
130534 130534 201524 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 740 Earl St 1 Front Yard : Yard 7 Tree 1 Private 1     4     6020392.93719 2093745.64338 37.730167421677606 -122.371775862971 (37.7301674216776, -122.371775862971)
131479 131479 233339 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 4750 17th St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   5998413.4057599995 2105689.21442 37.7617298240875 -122.448621500105 (37.7617298240875, -122.448621500105)
132657 132657 132209 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 2430 Francisco St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 4ft   5999675.04653 2119861.25281 37.8007146452294 -122.445276993363 (37.8007146452294, -122.445276993363)
132894 132894 233338 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 284 28th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6004000.477109999 2099567.8974900004 37.7452400124089 -122.42886164733999 (37.7452400124089, -122.42886164734)
133608 133608 211295 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 139 De Montfort Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5994867.97921 2091874.32239 37.7235942066902 -122.459882858411 (37.7235942066902, -122.459882858411)
135495 135495 233358 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 297 Addison St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   6002502.18245 2097693.83155 37.7400093458678 -122.433908560839 (37.7400093458678, -122.433908560839)
135702 135702 211288 DPW Maintained 3 Pinus thunbergii :: Japanese Black Pine 306 800x Miramar Ave 6 Median : Yard 3 Tree 1 DPW 2     16     5995401.87913 2094414.4819 37.7305995639058 -122.458221033587 (37.7305995639058, -122.458221033587)
136168 136168 233347 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 630 Alvarado St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10 Width 4ft   6002310.34466 2102682.0745599996 37.753694998543 -122.43492850446 (37.753694998543, -122.43492850446)
137567 137567 178354 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 103 Bowdoin St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6008475.657869999 2094541.35345 37.731690502712496 -122.41303182924901 (37.7316905027125, -122.413031829249)
137842 137842 233341 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 181 Elsie St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13     6006970.42421 2098142.10929 37.7414927703813 -122.418490966799 (37.7414927703813, -122.418490966799)
138040 138040 248089 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 14 Montcalm St 3 Side Yard : Yard 17 Tree 1 Private 1     6     6010641.03165 2100300.14916 37.7476242374868 -122.405951190707 (37.7476242374868, -122.405951190707)
140259 140259 114217 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 2X ACEVEDO AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     5987907.0 2090895.0 37.720502447579996 -122.483873669144 (37.72050244758, -122.483873669144)
141371 141371 114216 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 2X ACEVEDO AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14     5987907.0 2090895.0 37.720502447579996 -122.483873669144 (37.72050244758, -122.483873669144)
149168 149168 211309 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 200 Judson Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5998727.094190001 2093528.8423900001 37.728358318478996 -122.446661614764 (37.728358318479, -122.446661614764)
149569 149569 123318 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 614 05th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5994420.934169999 2111300.6241599997 37.7769081808925 -122.46283686042801 (37.7769081808925, -122.462836860428)
149765 149765 233349 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 1847 Castro St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10     6002644.4365300005 2100086.75284 37.7465878218663 -122.433587675538 (37.7465878218663, -122.433587675538)
151254 151254 178352 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 326 Naglee Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     5997716.4842 2088561.01593 37.71466004470761 -122.449797461695 (37.7146600447076, -122.449797461695)
152434 152434 211302 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 90 Melrose Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 8ft   5999487.07126 2095531.52008 37.7339005857431 -122.444178197174 (37.7339005857431, -122.444178197174)
153052 153052 66366 Permitted Site 1 Pinus thunbergii :: Japanese Black Pine 306 2 Collins St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/04/1991 12:00:00 AM 6   Permit Number 29488 5998129.63122 2114497.84593 37.7858998280554 -122.45023792356501 (37.7858998280554, -122.450237923565)
153360 153360 194521 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 331 Pennsylvania Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 7ft   6014370.45648 2105571.44717 37.7623059666689 -122.39342379736799 (37.7623059666689, -122.393423797368)
153380 153380 118582 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 110 Point Lobos Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     5982455.82259 2112616.16545 37.779823852339504 -122.504324612183 (37.7798238523395, -122.504324612183)
155251 155251 233351 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 554 Duncan St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 2ft   6002951.610280001 2099802.94851 37.745825985493795 -122.432505234436 (37.7458259854938, -122.432505234436)
155621 155621 186068 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 1901 Sunset Blvd 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984805.0303 2102059.3421 37.750975677225 -122.495418987844 (37.750975677225, -122.495418987844)
155877 155877 250706 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 50 McLaren Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     5986887.673719999 2114887.1088099997 37.7863188716619 -122.489160098754 (37.7863188716619, -122.489160098754)
156406 156406 185707 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 2101 Sunset Blvd 39 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984860.1074 2100466.1424 37.746604411412896 -122.49511105856399 (37.7466044114129, -122.495111058564)
156767 156767 248090 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 14 Montcalm St 4 Side Yard : Yard 17 Tree 1 Private 1     10     6010640.27543 2100283.5284 37.74757855821579 -122.40595263501001 (37.7475785582158, -122.40595263501)
157137 157137 178351 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 20 Tucker Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 5ft   6011047.67899 2088492.73765 37.7152262992376 -122.403714347453 (37.7152262992376, -122.403714347453)
159851 159851 211306 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 380 Monterey Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 8ft   5999601.46819 2094724.09535 37.731690112403605 -122.443724706826 (37.7316901124036, -122.443724706826)
160690 160690 118626 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 499 46th Ave 1 Side Yard : Yard 17 Tree 1 Private 1     7 Width 10ft   5981578.2503 2112431.17888 37.7792642811872 -122.507346739716 (37.7792642811872, -122.507346739716)
160886 160886 233344 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 729 Duncan St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   6001803.82877 2099686.32578 37.745440612497795 -122.43646574800199 (37.7454406124978, -122.436465748002)
161494 161494 233340 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 181 Elsie St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     16     6006969.35222 2098138.0175 37.741481474889795 -122.418494383305 (37.7414814748898, -122.418494383305)
162384 162384 211307 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 370 Monterey Blvd 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   5999716.58895 2094723.96092 37.731696308723 -122.443326702883 (37.731696308723, -122.443326702883)
163775 163775 233337 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 251 Coso Ave 1 Back Yard : Yard 13 Tree 1 Private 1     8     6007732.48322 2099500.473 37.7452654065818 -122.415952190562 (37.7452654065818, -122.415952190562)
164743 164743 194524 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 776 Rhode Island St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 6ft   6011804.85621 2104776.18304 37.759979468185 -122.402241382936 (37.759979468185, -122.402241382936)
165326 165326 233356 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 174 Moreland St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 4ft   6002109.14644 2097518.88743 37.7395066779031 -122.435255005132 (37.7395066779031, -122.435255005132)
166863 166863 250463 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 285 Seacliff Ave 1 : 4 Tree 1 Private 1     12 Width 4ft   5986841.007119999 2115627.98923 37.788350391596104 -122.489376046686 (37.7883503915961, -122.489376046686)
167076 167076 211293 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 532 Flood Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     5997196.70248 2094134.43006 37.729933579069204 -122.451995894888 (37.7299335790692, -122.451995894888)
170796 170796 211291 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 733 Joost Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   5997213.95847 2094973.7768 37.732239213275 -122.451996771739 (37.732239213275, -122.451996771739)
171040 171040 211297 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 915 Capitol Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 8ft   5994996.28556 2090021.9914900002 37.7185155264564 -122.459305252661 (37.7185155264564, -122.459305252661)
173046 173046 233353 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 470 Beacon St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 10ft   6002255.72146 2098533.86414 37.742301890412605 -122.43482077735001 (37.7423018904126, -122.43482077735)
173872 173872 211287 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 1549 15th Ave 8 Side Yard : Yard 17 Tree 1 Private 1     8     5991543.24459 2104910.37541 37.759196107445796 -122.472325621056 (37.7591961074458, -122.472325621056)
174199 174199 233357 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 100 Beacon St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 9ft   6003400.532869999 2097174.07927 37.7386331645932 -122.43076535563 (37.7386331645932, -122.43076535563)
174513 174513 118584 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 110 Point Lobos Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     5982432.95165 2112629.5696900003 37.7798593112778 -122.504404724819 (37.7798593112778, -122.504404724819)
175341 175341 233343 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 880 Duncan St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 3ft   6000897.1676 2099687.4857799998 37.7453922361643 -122.439600913267 (37.7453922361643, -122.439600913267)
177650 177650 211303 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 806 Detroit St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 8ft   5999473.71224 2095555.4257099999 37.733965462838896 -122.444226100474 (37.7339654628389, -122.444226100474)
182362 182362 233345 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 719 Duncan St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 6ft   6001851.32104 2099690.11771 37.7454537228095 -122.436301798912 (37.7454537228095, -122.436301798912)
183114 183114 74252 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 1501 25th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/01/1997 12:00:00 AM 9     6014087.4266 2101965.31447 37.7523885758791 -122.394150225664 (37.7523885758791, -122.394150225664)
184223 184223 211290 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 415 Flood Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 8ft   5998037.33347 2094068.5883900002 37.729800908375104 -122.449085005264 (37.7298009083751, -122.449085005264)
184584 184584 211294 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 166 Marston Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5998423.334869999 2093227.8006400003 37.7275143721919 -122.447690057855 (37.7275143721919, -122.447690057855)
185043 185043 233352 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 592 Duncan St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 5ft   6002775.3019199995 2099794.2981 37.7457922339331 -122.433114265229 (37.7457922339331, -122.433114265229)

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