Street_Tree_List

Data source: data.sfgov.org

953 rows where qSpecies = 94 sorted by qLegalStatus

View and edit SQL

Link rowid TreeID qLegalStatus ▼ qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
83369 66220 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1 Dolores Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1990 12:00:00 AM     Permit Number 29312 6005304.82019082 2105877.54249684 37.7626385702507 -122.424800241819 (37.7626385702507, -122.424800241819)
83414 61716 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 271 Clinton Park 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/04/1984 12:00:00 AM     Permit Number 21716 6004986.55656035 2108182.89626107 37.7689505396343 -122.426065124893 (37.7689505396343, -122.426065124893)
83657 107775 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 311 PARNASSUS AVE   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5996666.6 2106591.7 37.7641077820156 -122.454728170136 (37.7641077820156, -122.454728170136)
83797 60434 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 461 29th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/07/1987 12:00:00 AM     Permit Number 24099 6003594.47944671 2098910.74347696 37.7434126315981 -122.43021864419201 (37.7434126315981, -122.430218644192)
83967 61715 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 281 Clinton Park 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/04/1984 12:00:00 AM     Permit Number 21715 6004926.94134289 2108179.4823523 37.7689377963385 -122.42627108706002 (37.7689377963385, -122.42627108706)
83973 35231 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 402 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/03/1998 12:00:00 AM     Permit Number 38724 6003567.92997574 2105934.61117361 37.7626970125211 -122.430811591359 (37.7626970125211, -122.430811591359)
84474 33816 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1201 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/21/1997 12:00:00 AM     Permit Number 37831 6008598.80477101 2116262.85239853 37.791339665663294 -122.414142270961 (37.7913396656633, -122.414142270961)
84518 101285 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1236 09th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 11316 5993350.8 2107040.7 37.7651498684815 -122.466229094974 (37.7651498684815, -122.466229094974)
84615 64894 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1450 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/04/1989 12:00:00 AM     Permit Number 25920 6005836.52150612 2100535.66309095 37.7480010261231 -122.42258166386499 (37.7480010261231, -122.422581663865)
84789 57103 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3743 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/1983 12:00:00 AM     Permit Number 20509 6004792.79553424 2102485.90723803 37.7532970057744 -122.426329661558 (37.7532970057744, -122.426329661558)
85104 98237 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1299X 09th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 32025 5993314.0 2106663.0 37.7641106803471 -122.466328924005 (37.7641106803471, -122.466328924005)
85365 30533 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1020 Harrison St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/1995 12:00:00 AM     Permit Number 34535 6011195.92412392 2110919.1949505 37.776812772940005 -122.404779881684 (37.77681277294, -122.404779881684)
85577 60831 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 205 Chattanooga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/1983 12:00:00 AM     Permit Number 20604 6004778.44666437 2102471.31049199 37.753256115419504 -122.426378243722 (37.7532561154195, -122.426378243722)
85612 64334 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 18 Whitney St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/25/1988 12:00:00 AM     Permit Number 25162 6004243.25196821 2098226.95980835 37.7415718437352 -122.427926638771 (37.7415718437352, -122.427926638771)
85639 66379 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 625 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/04/1991 12:00:00 AM     Permit Number 29504 6003563.84234841 2110464.21135378 37.7751339598215 -122.431149051781 (37.7751339598215, -122.431149051781)
85873 38252 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1556 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/27/1998 12:00:00 AM 24 4x6 Permit Number 40362 6007050.76125355 2107358.39166569 37.76680309330379 -122.418866676369 (37.7668030933038, -122.418866676369)
86321 62088 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 474 Connecticut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/20/1985 12:00:00 AM     Permit Number 22174 6013214.9408475 2104861.98073646 37.7602936588903 -122.397370564655 (37.7602936588903, -122.397370564655)
86369 48037 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3350 Mission St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/11/2002 12:00:00 AM     Permit Number 45759 6006080.4837518 2098740.43590211 37.7430854999808 -122.42161056574 (37.7430854999808, -122.42161056574)
86479 61708 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 580 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/06/1984 12:00:00 AM     Permit Number 21707 6004928.75046121 2107826.22237424 37.767967931643 -122.426239675726 (37.767967931643, -122.426239675726)
86617 61763 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 390 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/19/1984 12:00:00 AM     Permit Number 21777 6005479.130443 2106713.50276565 37.764943762720705 -122.424256822517 (37.7649437627207, -122.424256822517)
87072 60836 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 253 Chattanooga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/1983 12:00:00 AM     Permit Number 20609 6004792.25802571 2102204.70843345 37.7525248690267 -122.426311501214 (37.7525248690267, -122.426311501214)
87079 63899 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 719 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/1987 12:00:00 AM     Permit Number 24609 6002042.34774334 2110925.77664223 37.776314966213896 -122.43644527379699 (37.7763149662139, -122.436445273797)
87183 34152 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 30 Steuart St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.794049371853106 -122.394334961669 (37.7940493718531, -122.394334961669)
87287 65844 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 2 Richardson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/07/1990 12:00:00 AM     Permit Number 28834 5999811.44226859 2119196.23574668 37.798896470812004 -122.44475718144301 (37.798896470812, -122.444757181443)
87335 63397 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 4300 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/15/1991 12:00:00 AM     Permit Number 30165 6001730.87094671 2104708.68623731 37.759226666669505 -122.437077536949 (37.7592266666695, -122.437077536949)
87662 60839 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 271 Chattanooga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/1983 12:00:00 AM     Permit Number 20613 6004797.43728628 2102104.7326602 37.7522506515925 -122.42628647311301 (37.7522506515925, -122.426286473113)
87790 32047 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 501 Tunnel Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/13/1999 12:00:00 AM     Permit Number 35428 6012610.0 2086139.0 37.7088505533644 -122.398149216451 (37.7088505533644, -122.398149216451)
88123 97191 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 255 California St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/29/2011 12:00:00 AM     Permit Number 767841 6012839.6 2116825.7 37.7931223970079 -122.399508654361 (37.7931223970079, -122.399508654361)
88721 62360 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 198 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/28/1985 12:00:00 AM     Permit Number 22505 6004608.84494602 2099604.09085689 37.7453738062021 -122.426760590215 (37.7453738062021, -122.426760590215)
89083 60549 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 523 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1982 12:00:00 AM     Permit Number 20159 5985000.44766821 2112307.598992 37.7791259492381 -122.495498998876 (37.7791259492381, -122.495498998876)
89201 63396 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 4326 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/11/1987 12:00:00 AM     Permit Number 23978 6001653.34817436 2104704.40880226 37.759210515065 -122.437345341266 (37.759210515065, -122.437345341266)
89556 60840 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 315 Chattanooga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/1983 12:00:00 AM     Permit Number 20614 6004809.28697134 2101883.59513704 37.7516441291888 -122.426229752639 (37.7516441291888, -122.426229752639)
89586 56750 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 100 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/25/1985 12:00:00 AM     Permit Number 21307 6002862.2859563 2108898.25983772 37.770794463527395 -122.433463958699 (37.7707944635274, -122.433463958699)
89802 66224 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 32 Dorland St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/24/1990 12:00:00 AM     Permit Number 29318 6005343.90687 2105779.62004334 37.762371905949294 -122.424658088706 (37.7623719059493, -122.424658088706)
90068 34157 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 30 Steuart St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.794049371853106 -122.394334961669 (37.7940493718531, -122.394334961669)
90109 60554 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 562 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1982 12:00:00 AM     Permit Number 20164 5985061.1383554 2112041.58145553 37.7783990952425 -122.49526942507799 (37.7783990952425, -122.495269425078)
90199 65243 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1086 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/26/1989 12:00:00 AM     Permit Number 28037 6009165.76758609 2102839.33295033 37.754513650320504 -122.411231929366 (37.7545136503205, -122.411231929366)
90236 48791 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1405 Taylor St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/30/2002 12:00:00 AM     Permit Number 46040 6008874.44924411 2117680.29283989 37.7952470886304 -122.413288823995 (37.7952470886304, -122.413288823995)
90327 61785 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1495 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/06/1987 12:00:00 AM     Permit Number 24636 6012051.50334521 2101403.29784414 37.750732029491296 -122.40115133594601 (37.7507320294913, -122.401151335946)
90546 64702 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 110 Cyril Magnin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/14/1988 12:00:00 AM     Permit Number 25683 6010200.02442425 2113768.63085544 37.7845809377612 -122.40842605163701 (37.7845809377612, -122.408426051637)
90592 62334 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 66 Park St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/1985 12:00:00 AM     Permit Number 22476 6005174.05627534 2096389.57268342 37.7365794079222 -122.424577561345 (37.7365794079222, -122.424577561345)
90716 65402 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 760 Geary St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/02/1989 12:00:00 AM 12 3x3 Permit Number 28251 6008077.0 2114493.0 37.7864507606031 -122.41582233096099 (37.7864507606031, -122.415822330961)
91026 59961 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 444 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/19/1981 12:00:00 AM     Permit Number 19440 6005671.77527769 2111387.84010103 37.7777892453109 -122.4239229277 (37.7777892453109, -122.4239229277)
91059 30886 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1440 Kearny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 34718 6011020.35277298 2119822.53522602 37.8012494094877 -122.40601460797501 (37.8012494094877, -122.406014607975)
91089 65540 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 2154 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/20/1990 12:00:00 AM   3x3 Permit Number 28437 6002291.71421754 2114386.89695038 37.78583249572021 -122.43583034619199 (37.7858324957202, -122.435830346192)
91480 30505 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1500 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 34518 6007587.04685478 2110100.36731732 37.7743620934089 -122.417206068405 (37.7743620934089, -122.417206068405)
91790 36252 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 243 Clinton Park 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1998 12:00:00 AM     Permit Number 39269 6005153.47922718 2108192.45520893 37.7689862189606 -122.42548843025 (37.7689862189606, -122.42548843025)
91896 33764 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1580 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/23/1996 12:00:00 AM     Permit Number 37815 6007223.30298499 2109757.94023834 37.7734013999863 -122.418440043785 (37.7734013999863, -122.418440043785)
92404 55576 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 2309 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/09/1987 12:00:00 AM     Permit Number 24775 6002194.69587728 2107036.79090461 37.76564542937879 -122.43563996790199 (37.7656454293788, -122.435639967902)
92829 63410 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 834 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/20/1987 12:00:00 AM     Permit Number 23993 6007543.2306715 2095481.74721631 37.7342202321398 -122.41632200823601 (37.7342202321398, -122.416322008236)
92840 48042 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3350 Mission St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/11/2002 12:00:00 AM     Permit Number 45759 6006080.4837518 2098740.43590211 37.7430854999808 -122.42161056574 (37.7430854999808, -122.42161056574)
92970 54514 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1221 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/18/1983 12:00:00 AM     Permit Number 20683 5995443.00414725 2107246.09430383 37.7658343190377 -122.459007589279 (37.7658343190377, -122.459007589279)
93573 66119 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 223 Lily St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/15/1990 12:00:00 AM     Permit Number 29179 6005470.38749546 2110092.46405208 37.7742210861409 -122.424527432779 (37.7742210861409, -122.424527432779)
93578 63203 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 2 Shore View Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1986 12:00:00 AM     Permit Number 23745 5984685.41505479 2112889.29978003 37.78070467946971 -122.496631747831 (37.7807046794697, -122.496631747831)
93794 64591 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3375 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1988 12:00:00 AM     Permit Number 25492 6005853.76544152 2103715.18666196 37.756732237337395 -122.422747957423 (37.7567322373374, -122.422747957423)
94045 62670 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1328 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/28/1986 12:00:00 AM     Permit Number 23002 6002790.04269178 2111680.73625558 37.7784303546549 -122.43391276835101 (37.7784303546549, -122.433912768351)
94180 61525 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1341 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/21/1989 12:00:00 AM     Permit Number 28272 5991348.55791434 2114747.92419088 37.7861960776153 -122.47371658077299 (37.7861960776153, -122.473716580773)
94506 58807 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 40 Elsie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/11/1986 12:00:00 AM     Permit Number 23661 6007506.51736783 2099215.13200372 37.744469217231 -122.416713333977 (37.744469217231, -122.416713333977)
94531 65486 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 801 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/15/1989 12:00:00 AM     Permit Number 28370 6009649.36997858 2115707.80146662 37.7898745823318 -122.410468114048 (37.7898745823318, -122.410468114048)
94548 66852 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 805 Leavenworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/15/1991 12:00:00 AM     Permit Number 30158 6008246.52380896 2115214.16051417 37.788440420773796 -122.415286889274 (37.7884404207738, -122.415286889274)
94873 97190 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 255 California St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/29/2011 12:00:00 AM     Permit Number 767841 6012839.6 2116825.7 37.7931223970079 -122.399508654361 (37.7931223970079, -122.399508654361)
94880 34155 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 30 Steuart St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.794049371853106 -122.394334961669 (37.7940493718531, -122.394334961669)
95118 40081 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 22 Rossi Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 41303 5996321.69068784 2112123.86441597 37.7792778762225 -122.456321143761 (37.7792778762225, -122.456321143761)
95201 59876 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 2195X Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/20/1981 12:00:00 AM   3x3 Permit Number 768644 6002471.9091323 2118692.46196613 37.7976647031079 -122.43551504483999 (37.7976647031079, -122.43551504484)
95847 60832 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 210 Chattanooga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/1983 12:00:00 AM     Permit Number 20605 6004728.24272246 2102435.29497545 37.7531543871846 -122.42654929494499 (37.7531543871846, -122.426549294945)
95951 97189 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 255 California St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/29/2011 12:00:00 AM     Permit Number 767841 6012839.6 2116825.7 37.7931223970079 -122.399508654361 (37.7931223970079, -122.399508654361)
96095 31350 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 843 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/12/1995 12:00:00 AM     Permit Number 34960 6003828.78534548 2110731.50789971 37.7758829003399 -122.43025162922702 (37.7758829003399, -122.430251629227)
96102 55379 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1236 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/1972 12:00:00 AM     Permit Number 11316 5993330.37884563 2107053.53607455 37.7651839347095 -122.46630065915501 (37.7651839347095, -122.466300659155)
96162 60279 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 890 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/09/1982 12:00:00 AM     Permit Number 19841 6007951.11915857 2102749.5563076 37.7541989479338 -122.415426159541 (37.7541989479338, -122.415426159541)
96192 65478 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 601 Stockton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/12/1989 12:00:00 AM     Permit Number 28359 6010541.36110634 2116214.27782437 37.7913152098094 -122.407417612453 (37.7913152098094, -122.407417612453)
96257 64024 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 2356 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/09/1987 12:00:00 AM     Permit Number 24781 6001973.19869493 2107076.19337817 37.7657410355678 -122.436408897131 (37.7657410355678, -122.436408897131)
96551 33508 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 235 Coleridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/25/1996 12:00:00 AM     Permit Number 37603 6006396.09682229 2098460.33665401 37.7423342020889 -122.420499380726 (37.7423342020889, -122.420499380726)
96682 66375 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 612 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/04/1991 12:00:00 AM     Permit Number 29499 6003620.76837837 2110432.17499844 37.775049221566206 -122.430949845165 (37.7750492215662, -122.430949845165)
96990 99016 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1133 Taylor St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 29980 6008997.0 2116859.0 37.7929988993441 -122.41280668476999 (37.7929988993441, -122.41280668477)
96992 62435 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 297 Corbett Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/07/1985 12:00:00 AM     Permit Number 22596 5999684.09914601 2105294.09451438 37.760717499173396 -122.44419830300801 (37.7607174991734, -122.444198303008)
97035 47045 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 111 Maiden Ln 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/2002 12:00:00 AM     Permit Number 45035 6011125.92683466 2115044.13243826 37.7881349707775 -122.40531257909599 (37.7881349707775, -122.405312579096)
97042 59954 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 559 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/19/1981 12:00:00 AM     Permit Number 19431 6005185.88290556 2110921.14903305 37.7764803824816 -122.42557057591002 (37.7764803824816, -122.42557057591)
97049 66374 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 600 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/04/1991 12:00:00 AM     Permit Number 29498 6003626.18476729 2110393.01425684 37.7749420027203 -122.430928313262 (37.7749420027203, -122.430928313262)
97387 98238 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1299X 09th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 32025 5993314.0 2106663.0 37.7641106803471 -122.466328924005 (37.7641106803471, -122.466328924005)
97456 61733 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1352 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/15/1984 12:00:00 AM     Permit Number 21738 6004486.387982 2101012.81721841 37.7492349189645 -122.42728435687401 (37.7492349189645, -122.427284356874)
97471 61306 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1494 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/10/1984 12:00:00 AM     Permit Number 21205 6011999.58311152 2101400.41872379 37.7507212274206 -122.401330679383 (37.7507212274206, -122.401330679383)
97475 64063 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1421 Stockton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1988 12:00:00 AM     Permit Number 25296 6010151.38612308 2118964.80181049 37.7988456450066 -122.408961074202 (37.7988456450066, -122.408961074202)
97562 66216 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 438 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1990 12:00:00 AM     Permit Number 29307 6008473.34152559 2106010.06053059 37.763180886532396 -122.41385080311501 (37.7631808865324, -122.413850803115)
97580 48043 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3350 Mission St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/11/2002 12:00:00 AM     Permit Number 45759 6006080.4837518 2098740.43590211 37.7430854999808 -122.42161056574 (37.7430854999808, -122.42161056574)
97722 59421 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 59 Whitney St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/25/1988 12:00:00 AM     Permit Number 25134 6004314.38183356 2097887.85689933 37.7406447683968 -122.42765654126998 (37.7406447683968, -122.42765654127)
97890 104423 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 2362 15th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   18 3x3 Permit Number 24809 6002031.0 2107070.0 37.7657273142687 -122.436208531898 (37.7657273142687, -122.436208531898)
97958 66869 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 640 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/18/1991 12:00:00 AM     Permit Number 30178 6009507.57601331 2115392.34348399 37.789000460867 -122.410936420318 (37.789000460867, -122.410936420318)
98302 63872 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 426 Hill St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/16/1987 12:00:00 AM     Permit Number 24575 6003557.23375757 2103346.48170692 37.7555900208672 -122.43066389151699 (37.7555900208672, -122.430663891517)
98642 64717 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 35 Powell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/14/1988 12:00:00 AM     Permit Number 25671 6010371.58706878 2113906.86566108 37.7849701038252 -122.407842251054 (37.7849701038252, -122.407842251054)
98701 99964 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 2439 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 769385 6003671.0 2116729.0 37.7923415699538 -122.431225642925 (37.7923415699538, -122.431225642925)
99208 56883 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 229 Laussat St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/12/1986 12:00:00 AM     Permit Number 14121 6003628.47766901 2109141.87347388 37.7715068072846 -122.430831075204 (37.7715068072846, -122.430831075204)
99439 39878 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 301 Bryant St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/21/1999 12:00:00 AM     Permit Number 41173 6015620.67363669 2114221.43610992 37.786126305998 -122.389703911477 (37.786126305998, -122.389703911477)
99975 58797 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 772 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/20/1979 12:00:00 AM 24 3x3 Permit Number 53459 6003043.36972634 2103781.55156302 37.756755493530896 -122.43247206616199 (37.7567554935309, -122.432472066162)
100167 61712 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 239 Clinton Park 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/04/1984 12:00:00 AM     Permit Number 21712 6005177.32533199 2108193.82077345 37.768991315779 -122.42540604522301 (37.768991315779, -122.425406045223)
100334 36098 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 299 on 16th Street Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/1998 12:00:00 AM     Permit Number 39198 6004891.74541508 2106619.46330166 37.7646523685012 -122.426281744676 (37.7646523685012, -122.426281744676)
100679 64576 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3524 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/10/1988 12:00:00 AM     Permit Number 25474 6006109.43020381 2104951.42696267 37.760141086622 -122.421951589354 (37.760141086622, -122.421951589354)
100744 62669 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 299 Laussat St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/1992 12:00:00 AM     Permit Number 23001 6003308.50596463 2109097.30161721 37.7713662897526 -122.43193469053101 (37.7713662897526, -122.431934690531)
101030 61727 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 106 Clipper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/15/1984 12:00:00 AM     Permit Number 21732 6004453.38447501 2101057.16682643 37.7493548261549 -122.42740164255501 (37.7493548261549, -122.427401642555)
101209 61524 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 5301 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/20/1984 12:00:00 AM     Permit Number 21481 5991172.88177213 2114060.20768973 37.784297623281105 -122.474274166868 (37.7842976232811, -122.474274166868)
101311 62353 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 113 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/28/1985 12:00:00 AM 18   Permit Number 22497 6005157.02914158 2099582.1696783 37.7453445941022 -122.42486349755501 (37.7453445941022, -122.424863497555)

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