Street_Tree_List

Data source: data.sfgov.org

171 rows where qCaretaker = 1 and qSpecies = 13

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCareAssistant, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
20 251179 Planning Code 138.1 required 4 Podocarpus gracilor :: Fern Pine 13 1043 Minna St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6007668.0 2109797.0 37.7735336727503 -122.41690453761002 (37.7735336727503, -122.41690453761)
21 251178 Planning Code 138.1 required 4 Podocarpus gracilor :: Fern Pine 13 1043 Minna St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6007668.0 2109797.0 37.7735336727503 -122.41690453761002 (37.7735336727503, -122.41690453761)
3994 159208 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 210 Foote Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 08:54:00 AM 3 Width 0ft   5998556.96811 2088452.2606799998 37.714409480083496 -122.446884596259 (37.7144094800835, -122.446884596259)
3999 181035 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 170 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 04:20:00 PM 3 Width 4ft   6000927.8060099995 2088408.3131900001 37.7144239699579 -122.438686909772 (37.7144239699579, -122.438686909772)
4055 251746 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 700 Rolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 10:33:00 AM 3 3x3   6002943.0 2087289.0 37.711465016812205 -122.431641737098 (37.7114650168122, -122.431641737098)
4078 253099 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 210 Foote Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 08:59:00 AM 3 Width 0ft   5998556.96811 2088452.2606799998 37.714409480083496 -122.446884596259 (37.7144094800835, -122.446884596259)
4083 181036 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 170 Rolph St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 04:16:00 PM 3 Width 4ft   6000944.46471 2088397.62402 37.7143955675655 -122.438628565353 (37.7143955675655, -122.438628565353)
4157 216804 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 297 Lobos St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2017 02:14:00 PM 3 Width 2ft   5994075.3134 2088701.73413 37.7148374215779 -122.462392942697 (37.7148374215779, -122.462392942697)
4229 252890 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 301x Howth St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 03:50:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4261 252888 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 301x Howth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 04:03:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4284 175543 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 187 Seville St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 09:37:00 AM 3 Width 6ft   6001178.343719999 2087386.3168 37.7116320444605 -122.43774780171302 (37.7116320444605, -122.437747801713)
4513 69411 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 400 Rolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/13/2017 12:00:00 PM 3   Permit Number 33516 6002017.91695 2087759.8378400002 37.712705354746106 -122.43487271052601 (37.7127053547461, -122.434872710526)
4627 160610 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 750X France Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/18/2017 04:01:00 PM 3 Width 0ft   6002805.02204 2089330.87742 37.717063742780496 -122.432264357312 (37.7170637427805, -122.432264357312)
4644 160608 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 750X France Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/2017 03:37:00 PM 3 Width 0ft   6002772.883169999 2089351.94517 37.717119767831505 -122.43237694973499 (37.7171197678315, -122.432376949735)
4671 160609 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 750X France Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/18/2017 03:56:00 PM 3 Width 0ft   6002789.45595 2089340.3546099998 37.71708888243629 -122.432318838255 (37.7170888824363, -122.432318838255)
4686 160611 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 750X France Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/2017 04:11:00 PM 3 Width 0ft   6002821.1864599995 2089320.8920099998 37.717037241564 -122.432207771993 (37.717037241564, -122.432207771993)
5242 243740 Planning Code 138.1 required 4 Podocarpus gracilor :: Fern Pine 13 550 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/15/2017 12:00:00 AM 3 3x3 Permit Number 776473 6003047.0557699995 2096015.8076799999 37.7354327831918 -122.431904827248 (37.7354327831918, -122.431904827248)
9792 159358 Planning Code 138.1 required 4 Podocarpus gracilor :: Fern Pine 13 49 Naglee Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998584.62871 2087583.8857099998 37.712026700246 -122.446726546692 (37.712026700246, -122.446726546692)
13290 187642 Significant Tree 6 Podocarpus gracilor :: Fern Pine 13 2526 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006264.0 2119500.0 37.8000966404513 -122.42245076966002 (37.8000966404513, -122.42245076966)
19097 10252 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 124 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3X3   6005490.6368 2109629.255 37.7729503696302 -122.424424432873 (37.7729503696302, -122.424424432873)
19318 10251 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 120 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3X3   6005509.0088 2109632.4226 37.7729601045446 -122.42436110718201 (37.7729601045446, -122.424361107182)
19691 108972 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 10 Dearborn St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/2015 12:00:00 AM 3 3x3 Permit Number 772927 6005770.7 2106026.5 37.7630738748169 -122.42319951773399 (37.7630738748169, -122.423199517734)
20659 53568 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 712 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/11/2014 12:00:00 AM 3 6x7 Permit Number 774472 6002289.86675011 2108835.21130526 37.7705888548661 -122.43543945468201 (37.7705888548661, -122.435439454682)
24689 244218 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1949 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5997251.0447 2108771.6628 37.7701269078181 -122.452864114834 (37.7701269078181, -122.452864114834)
24939 143093 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 487 Greenwich St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   6010518.569 2120277.0289 37.8024692600192 -122.407783074103 (37.8024692600192, -122.407783074103)
26201 212832 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1201 Funston Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 5ft   5992025.01275 2107217.63828 37.765559111278 -122.47082751866999 (37.765559111278, -122.47082751867)
26751 186196 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1701 Sunset Blvd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984756.9045 2103549.1285 37.7550634017723 -122.495695286455 (37.7550634017723, -122.495695286455)
27591 139137 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1750 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6003531.4353 2113968.7391 37.7847546833549 -122.431511396859 (37.7847546833549, -122.431511396859)
27653 186191 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1701 Sunset Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984752.6191 2103570.02 37.7551205130891 -122.49571164730499 (37.7551205130891, -122.495711647305)
28737 92295 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 1372 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2009 12:00:00 AM 2 3x3 Permit Number 52740 5989296.944 2106014.5102 37.762097501928295 -122.480175128724 (37.7620975019283, -122.480175128724)
30906 212833 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 468 Lansdale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5996396.78511 2096388.5906 37.7360771087699 -122.454924099162 (37.7360771087699, -122.454924099162)
31436 91401 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 567 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2009 12:00:00 AM 4 3x3 Permit Number 52097 6010823.9616 2118928.6951 37.7987841568388 -122.406631185904 (37.7987841568388, -122.406631185904)
31901 200087 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2260 Keith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014672.5559 2092688.6734 37.7269493390436 -122.391478260518 (37.7269493390436, -122.391478260518)
34640 139142 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1730 GEARY BLVD 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6003354.1342 2113941.3148 37.784669332502105 -122.432122840709 (37.7846693325021, -122.432122840709)
35328 200091 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2230 Keith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014724.5498 2092764.8713 37.7271614489349 -122.39130384140199 (37.7271614489349, -122.391303841402)
36043 200090 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2250 Keith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014714.6889 2092749.6317 37.7271190567752 -122.391336865844 (37.7271190567752, -122.391336865844)
36445 106365 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1970 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   1 4x2   5981684.7966 2101671.2426 37.7497268716349 -122.506180099858 (37.7497268716349, -122.506180099858)
37888 116710 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1400 BAKER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
38506 185519 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2201 Sunset Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984858.6139 2100160.4269 37.7457649124522 -122.495093683302 (37.7457649124522, -122.495093683302)
39799 116709 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1400 BAKER ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
39842 183135 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2315 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5984823.141 2099420.9741 37.7437324991665 -122.49516182260099 (37.7437324991665, -122.495161822601)
39960 186401 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1801 Sunset Blvd 68 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984842.4701 2102334.3496 37.7517329643959 -122.495309798203 (37.7517329643959, -122.495309798203)
40066 184721 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1630 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5982537.7064 2103994.8819 37.7561571061486 -122.503402789254 (37.7561571061486, -122.503402789254)
40453 92325 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 1451 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2009 12:00:00 AM 2 3x3 Permit Number 52757 5987103.8402 2105396.114 37.760271879713294 -122.487714698332 (37.7602718797133, -122.487714698332)
40595 185530 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2201 Sunset Blvd 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984911.0151 2100096.2189 37.7455916823633 -122.49490775682699 (37.7455916823633, -122.494907756827)
41633 185634 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2100 Sunset Blvd 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985067.4201 2100372.3359 37.746358979048296 -122.49438729000201 (37.7463589790483, -122.494387290002)
41813 112844 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2200 KEITH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014766.0 2092880.0 37.7274798696224 -122.391168591224 (37.7274798696224, -122.391168591224)
42113 200095 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2220 Keith St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014767.5792 2092826.7261 37.727333677806 -122.391159409685 (37.727333677806, -122.391159409685)
43092 31665 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 1813 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/05/1995 12:00:00 AM 3   Permit Number 35173 6006528.4802 2117109.7376 37.7935484974802 -122.42136572658 (37.7935484974802, -122.42136572658)
45002 52035 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 1451 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/22/2005 12:00:00 AM 1   Permit Number 48247 6000914.194 2110330.7938 37.774617124205 -122.44030518181002 (37.774617124205, -122.44030518181)
47763 186107 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1901 Sunset Blvd 53 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984859.3561 2101642.6122 37.7498346320289 -122.495200398918 (37.7498346320289, -122.495200398918)
48688 37070 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 1382 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM 6   Permit Number 39673 5982789.8395 2105718.3045 37.760903956322295 -122.50265840320101 (37.7609039563223, -122.502658403201)
49901 187069 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2600 Sunset Blvd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985177.211 2096899.8078 37.7368307770453 -122.49375180463001 (37.7368307770453, -122.49375180463)
50529 37080 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 1224 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM 8   Permit Number 39681 5982132.793 2106739.5272 37.763669308222795 -122.505006479579 (37.7636693082228, -122.505006479579)
52707 200089 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2260 Keith St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014698.5528 2092729.0135 37.7270615477685 -122.39139120786301 (37.7270615477685, -122.391391207863)
54294 187072 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2600 Sunset Blvd 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985184.617000001 2096917.4415 37.7368796277559 -122.493727498225 (37.7368796277559, -122.493727498225)
55490 139136 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1825 POST ST 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6003489.3422 2114155.6067 37.785265388892 -122.431670371199 (37.785265388892, -122.431670371199)
59017 200092 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2220 Keith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014736.2036 2092780.1109 37.727203940586904 -122.391264618831 (37.7272039405869, -122.391264618831)
59641 182398 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1539 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5988985.656 2104841.7909999997 37.7588594394433 -122.481165865952 (37.7588594394433, -122.481165865952)
63369 73417 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1501 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/1994 12:00:00 AM 5     5982464.5527 2104844.8944 37.7584866992539 -122.503718723326 (37.7584866992539, -122.503718723326)
66718 143220 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 55 BELLAIR PL 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6010031.3343 2121212.8177 37.8050114159252 -122.409535239424 (37.8050114159252, -122.409535239424)
68940 234843 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 141 Albion St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 2ft   6005925.31783 2106426.47013 37.764180822918796 -122.422693171361 (37.7641808229188, -122.422693171361)
69400 140757 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2303 O'Farrell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6000331.3271 2112998.0313 37.7819074748635 -122.442512966292 (37.7819074748635, -122.442512966292)
69983 200088 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2260 Keith St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014685.1061 2092710.1881 37.72700911067479 -122.39143637779101 (37.7270091106748, -122.391436377791)
71416 91402 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 567 Vallejo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2009 12:00:00 AM 4 3x3 Permit Number 52097 6010859.945 2118931.7794 37.7987946386979 -122.40650688851801 (37.7987946386979, -122.406506888518)
71923 183061 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2595 43rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983026.5279 2097492.8315 37.7383329997375 -122.50123139183 (37.7383329997375, -122.50123139183)
72822 66163 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 115 Venus St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/09/2010 12:00:00 AM 4   Permit Number 53981 6012889.431419999 2094249.3979200001 37.7311356371996 -122.39775195381 (37.7311356371996, -122.39775195381)
72838 234841 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 141 Albion St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 2ft   6005926.24374 2106419.53529 37.76416183372571 -122.42268947605 (37.7641618337257, -122.42268947605)
75956 183684 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1323 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983353.1911 2106127.4738 37.762060508953205 -122.50074030741501 (37.7620605089532, -122.500740307415)
77026 200233 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2897 Hawes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6014759.7839 2089478.3596 37.718139294663 -122.390952437444 (37.718139294663, -122.390952437444)
78718 113143 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1375 NORIEGA ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   5989767.0 2103093.0 37.7541031181361 -122.478335773286 (37.7541031181361, -122.478335773286)
79358 108613 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 859 Moultrie St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774597 6007577.26936 2095354.40031 37.7338724793659 -122.416195309142 (37.7338724793659, -122.416195309142)
79733 46187 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 772 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2001 12:00:00 AM   3x3 Permit Number 770441 5997143.11969578 2107935.34407244 37.767824406441704 -122.453177040971 (37.7678244064417, -122.453177040971)
80684 120653 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 4000x 25th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6003791.0 2101344.0 37.750104917900295 -122.42971263777001 (37.7501049179003, -122.42971263777)
81290 112852 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2200 KEITH ST 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014766.0 2092880.0 37.7274798696224 -122.391168591224 (37.7274798696224, -122.391168591224)
81726 112845 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2200 KEITH ST 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014766.0 2092880.0 37.7274798696224 -122.391168591224 (37.7274798696224, -122.391168591224)
82791 109234 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 1888 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/04/2015 12:00:00 AM 3 3x3 Permit Number 773192 6004570.0 2097679.6 37.7400873981114 -122.426757883918 (37.7400873981114, -122.426757883918)
84341 107502 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 998 CHESTNUT ST 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     3 3x3 Permit Number 773456 6007102.0 2120561.3 37.8030579393401 -122.419626302363 (37.8030579393401, -122.419626302363)
84422 107419 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 300 Seacliff Ave 5 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   09/04/2014 12:00:00 AM 3   Permit Number 773970 5986804.62098 2115681.98254 37.788496517491104 -122.489505906992 (37.7884965174911, -122.489505906992)
85088 107418 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 300 Seacliff Ave 4 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   09/04/2014 12:00:00 AM 3   Permit Number 773970 5986804.62098 2115681.98254 37.788496517491104 -122.489505906992 (37.7884965174911, -122.489505906992)
85183 122398 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1 Marne Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5995245.0 2097844.0 37.7400071651049 -122.45901160777099 (37.7400071651049, -122.459011607771)
85566 63398 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 4515 20th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/24/2015 12:00:00 AM 24 3x3 Permit Number 770790 6001413.63019954 2104052.61523798 37.757407217509495 -122.43812770874399 (37.7574072175095, -122.438127708744)
85920 107894 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 230X 11th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/04/2014 12:00:00 AM 3 3X3 Permit Number 770997 6008153.6101 2109447.48188 37.7726012817916 -122.41519998916999 (37.7726012817916, -122.41519998917)
87384 86799 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 71 Miguel St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/10/2016 12:00:00 AM 3 3x3 Permit Number 49752 6003860.0 2097292.0 37.738982969029706 -122.429185143196 (37.7389829690297, -122.429185143196)
89903 115312 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 1125 Holloway Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2016 12:00:00 AM     Permit Number 775539 5992848.6 2091172.9 37.7215519289961 -122.46681247303101 (37.7215519289961, -122.466812473031)
92645 120652 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 4000x 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6003791.0 2101344.0 37.750104917900295 -122.42971263777001 (37.7501049179003, -122.42971263777)
92996 94678 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 160 Randall St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/03/2016 12:00:00 AM 3 3x3 Permit Number 778668 6004537.0 2097560.0 37.7397571378771 -122.426863468968 (37.7397571378771, -122.426863468968)
93096 114666 Private 5 Podocarpus gracilor :: Fern Pine 13 382 Richland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/30/2015 12:00:00 AM     Permit Number 774512 6007233.6 2095963.6 37.7355258779344 -122.41742663990699 (37.7355258779344, -122.417426639907)
93720 106927 Significant Tree 6 Podocarpus gracilor :: Fern Pine 13 4150 24th St   Sidewalk: Property side : Cutout 5 Tree 1 Private 1       1.5X1.5 Permit Number 772519 6002207.56819 2101805.30097 37.7512817512061 -122.435221219626 (37.7512817512061, -122.435221219626)
98270 107984 Significant Tree 6 Podocarpus gracilor :: Fern Pine 13 2401x SCOTT ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001096.0 2116670.0 37.792033311180504 -122.440130949989 (37.7920333111805, -122.440130949989)
98582 122401 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1 Marne Ave 4 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5995245.0 2097844.0 37.7400071651049 -122.45901160777099 (37.7400071651049, -122.459011607771)
98608 115230 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 743 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/20/2016 12:00:00 AM     Permit Number 775535 5987210.9 2110869.6 37.775306795851 -122.487746566566 (37.775306795851, -122.487746566566)
99638 107427 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 222 Parnassus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2016 12:00:00 AM   9x7 Permit Number 774709 5997126.23025 2106741.3016 37.7645449031863 -122.45314925174601 (37.7645449031863, -122.453149251746)
100439 107897 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 230X 11th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/04/2014 12:00:00 AM 3 3X3 Permit Number 770997 6008153.6101 2109447.48188 37.7726012817916 -122.41519998916999 (37.7726012817916, -122.41519998917)
101375 115332 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 735 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/26/2016 12:00:00 AM 3   Permit Number 777441 5995305.9 2110591.8 37.7750128688555 -122.459724160308 (37.7750128688555, -122.459724160308)
101452 112847 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2200 KEITH ST 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014766.0 2092880.0 37.7274798696224 -122.391168591224 (37.7274798696224, -122.391168591224)
101472 106058 Significant Tree 6 Podocarpus gracilor :: Fern Pine 13 301 FILBERT ST 1 Front Yard : Yard 7 Tree 1 Private 1     10     6011273.0 2120044.0 37.8018716248897 -122.40515593659401 (37.8018716248897, -122.405155936594)
101634 115378 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 42 Leese St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/28/2016 12:00:00 AM 3   Permit Number 777462 6005449.5 2096333.6 37.7364412712621 -122.42362125502599 (37.7364412712621, -122.423621255026)
102270 112846 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2200 KEITH ST 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014766.0 2092880.0 37.7274798696224 -122.391168591224 (37.7274798696224, -122.391168591224)
102623 107896 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 230X 11th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/04/2014 12:00:00 AM 3 3X3 Permit Number 770997 6008153.6101 2109447.48188 37.7726012817916 -122.41519998916999 (37.7726012817916, -122.41519998917)

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