Street_Tree_List

Data source: data.sfgov.org

11,493 rows where qSpecies = 17

View and edit SQL

Suggested facets: PlantType, qCaretaker, qCareAssistant

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
27 244214 Private 5 Tree(s) :: 17 342 Scott St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   03/20/2017 12:00:00 AM 3 Width 0ft Permit Number 779666 6002262.2202 2109717.5413 37.7730099442883 -122.43559821674499 (37.7730099442883, -122.435598216745)
50 138938 Private 5 Tree(s) :: 17 632 HAYES ST 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   03/21/2017 12:00:00 AM 3 Width 0ft Permit Number 779650 6004797.9634 2110922.1515 37.7764612085261 -122.426912572117 (37.7764612085261, -122.426912572117)
51 60867 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/1983 12:00:00 AM     Permit Number 20649          
57 44642 Permitted Site 1 Tree(s) :: 17   60 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
59 44994 Permitted Site 1 Tree(s) :: 17   106 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
77 49739 Permitted Site 1 Tree(s) :: 17 145 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/22/2017 12:00:00 AM 3   Permit Number 779552 6013462.1222 2106403.54987 37.764540227980206 -122.396623740816 (37.7645402279802, -122.396623740816)
89 251189 Permitted Site 1 Tree(s) :: 17 1493 Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/22/2017 12:00:00 AM 3 3x3   6016267.45517 2096986.6643299998 37.7388391569445 -122.38626419104999 (37.7388391569445, -122.38626419105)
136 213016 Undocumented 2 Tree(s) :: 17 120 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/27/2017 12:00:00 AM 3 Width 2ft Permit Number 779661 5993626.83548 2102594.2327400004 37.7529569465285 -122.4649514087 (37.7529569465285, -122.4649514087)
169 251221 Permitted Site 1 Tree(s) :: 17 2401X Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:00:00 AM 3 3x3 Permit Number 778039          
172 48332 Permitted Site 1 Tree(s) :: 17   142 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
204 61453 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/22/1984 12:00:00 AM     Permit Number 21392          
235 45975 Permitted Site 1 Tree(s) :: 17   132 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
245 251255 Undocumented 2 Tree(s) :: 17 4089x Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991686.0 2086822.0 37.7095382490701 -122.47051450746099 (37.7095382490701, -122.470514507461)
252 182864 DPW Maintained 3 Tree(s) :: 17 1674 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/02/2016 10:49:00 AM 1 Width 0ft   5987818.6474 2103915.1987 37.7562473553988 -122.485133888104 (37.7562473553988, -122.485133888104)
266 173827 Undocumented 2 Tree(s) :: 17 1200 04th St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
274 173825 Undocumented 2 Tree(s) :: 17 1200 04th St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
276 173808 Undocumented 2 Tree(s) :: 17 1201 04th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
279 48153 Permitted Site 1 Tree(s) :: 17   263 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
282 173829 Undocumented 2 Tree(s) :: 17 1200 04th St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
283 173821 Undocumented 2 Tree(s) :: 17 1200 04th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
287 173824 Undocumented 2 Tree(s) :: 17 1200 04th St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
289 173826 Undocumented 2 Tree(s) :: 17 1200 04th St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
290 173809 Undocumented 2 Tree(s) :: 17 1201 04th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
297 32804 Permitted Site 1 Tree(s) :: 17 1683 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779644 5999817.40523345 2110171.54968226 37.774117372599896 -122.44408773423099 (37.7741173725999, -122.444087734231)
298 173822 Undocumented 2 Tree(s) :: 17 1200 04th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
301 173819 Undocumented 2 Tree(s) :: 17 1200 04th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
302 187663 Undocumented 2 Tree(s) :: 17 1155 04th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779411 6015039.0 2109715.0 37.77372037595529 -122.391401215397 (37.7737203759553, -122.391401215397)
304 173811 Undocumented 2 Tree(s) :: 17 1201 04th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
306 173816 Undocumented 2 Tree(s) :: 17 1200 04th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
307 173828 Undocumented 2 Tree(s) :: 17 1200 04th St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
308 46059 Permitted Site 1 Tree(s) :: 17   101 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
311 173810 Undocumented 2 Tree(s) :: 17 1201 04th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
314 173820 Undocumented 2 Tree(s) :: 17 1200 04th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
316 67789 Permitted Site 1 Tree(s) :: 17 7 4384 St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/17/1992 12:00:00 AM     Permit Number 31429          
318 142205 Permitted Site 1 Tree(s) :: 17 1683 HAYES ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft Permit Number 779644 5999834.1012 2110180.6204 37.774143230926 -122.44403063203698 (37.774143230926, -122.444030632037)
320 48259 Permitted Site 1 Tree(s) :: 17   123 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
321 65143 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/1989 12:00:00 AM     Permit Number 27118          
427 251307 Undocumented 2 Tree(s) :: 17 200 Cashmere St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6016315.0 2096328.0 37.7370332293639 -122.38605389871 (37.7370332293639, -122.38605389871)
434 136390 Undocumented 2 Tree(s) :: 17 3395 Sacramento St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/2017 12:00:00 AM 3 Width 5ft Permit Number 779746 5998765.27001 2115243.09553 37.787982442971604 -122.448092477507 (37.7879824429716, -122.448092477507)
439 136984 Undocumented 2 Tree(s) :: 17 454 Walnut St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/2017 12:00:00 AM 3 Width 4ft Permit Number 779785 5998641.89853 2115102.68231 37.7875898520492 -122.448509202661 (37.7875898520492, -122.448509202661)
444 44838 Permitted Site 1 Tree(s) :: 17   12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
515 48129 Permitted Site 1 Tree(s) :: 17   297 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
536 45913 Permitted Site 1 Tree(s) :: 17   59 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
563 173951 Significant Tree 6 Tree(s) :: 17 2646 Union St 1 Front Yard : Cutout 8 Tree 1 Private 1   04/11/2017 12:00:00 AM 3 10x10 Permit Number 779549 6000338.0 2118225.0 37.796259749404605 -122.442865342513 (37.7962597494046, -122.442865342513)
580 48268 Permitted Site 1 Tree(s) :: 17   132 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
588 251328 Undocumented 2 Tree(s) :: 17 95x Tompkins Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 779511 6007651.0 2096616.0 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695)
597 251329 Permitted Site 1 Tree(s) :: 17 95x Tompkins Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/2017 12:00:00 AM   3x3 Permit Number 779511 6007651.0 2096616.0 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695)
604 171523 Permitted Site 1 Tree(s) :: 17 281 Harvard St 1 Front Yard : Yard 7 Tree 1 Private 1   04/12/2017 12:00:00 AM 3 3x3 Permit Number 779632 6006304.03409 2092571.58308 37.7261597980302 -122.420399821019 (37.7261597980302, -122.420399821019)
607 65964 Permitted Site 1 Tree(s) :: 17 2655 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/12/2017 12:00:00 AM 3 3x3 Permit Number 779612 5989236.70778952 2097278.67232438 37.738107703581704 -122.479744212489 (37.7381077035817, -122.479744212489)
610 251327 Permitted Site 1 Tree(s) :: 17 95x Tompkins Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/2017 12:00:00 AM   3x3 Permit Number 779511 6007651.0 2096616.0 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695)
617 57850 Permitted Site 1 Tree(s) :: 17 1700 S. Amaylett Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/14/1977 12:00:00 AM     Permit Number 16791          
632 44905 Permitted Site 1 Tree(s) :: 17   139 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
633 48204 Permitted Site 1 Tree(s) :: 17   47 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
689 48269 Permitted Site 1 Tree(s) :: 17   120 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
705 105051 Permitted Site 1 Tree(s) :: 17 1244 Masonic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/17/2017 12:00:00 AM 3   Permit Number 779926 5999515.4 2108544.9 37.769633771891606 -122.445015457708 (37.7696337718916, -122.445015457708)
726 44958 Permitted Site 1 Tree(s) :: 17   82 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
729 48266 Permitted Site 1 Tree(s) :: 17   130 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
734 173936 Permitted Site 1 Tree(s) :: 17 614 Alabama St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008960.61704517 2105361.82717089 37.7614283394777 -122.41211965835899 (37.7614283394777, -122.412119658359)
743 224663 Permitted Site 1 Tree(s) :: 17 614 Alabama St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008964.71968 2105285.1997599998 37.761218168313704 -122.412100053373 (37.7612181683137, -122.412100053373)
751 224664 Permitted Site 1 Tree(s) :: 17 614 Alabama St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008962.07625 2105304.40117 37.761270742678704 -122.412110552966 (37.7612707426787, -122.412110552966)
755 224665 Permitted Site 1 Tree(s) :: 17 614 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008961.65131 2105333.13094 37.7613496042185 -122.412114053139 (37.7613496042185, -122.412114053139)
771 224662 Permitted Site 1 Tree(s) :: 17 614 Alabama St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008966.3106 2105264.00424 37.7611600595223 -122.412093053058 (37.7611600595223, -122.412093053058)
774 231034 Permitted Site 1 Tree(s) :: 17 3050 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008943.01244 2104996.16235 37.760423319597294 -122.412154701577 (37.7604233195973, -122.412154701577)
788 173935 Permitted Site 1 Tree(s) :: 17 614 Alabama St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008960.61704517 2105361.82717089 37.7614283394777 -122.41211965835899 (37.7614283394777, -122.412119658359)
793 65876 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/1990 12:00:00 AM     Permit Number 28874          
809 46145 Permitted Site 1 Tree(s) :: 17   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2001 12:00:00 AM     Permit Number 44490          
814 44650 Permitted Site 1 Tree(s) :: 17   70 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
862 141567 Permitted Site 1 Tree(s) :: 17 501X Baker St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/20/2017 12:00:00 AM 3 Width 0ft Permit Number 779825 6000588.8239 2110706.7362 37.7756308363396 -122.44145768074499 (37.7756308363396, -122.441457680745)
882 187661 Undocumented 2 Tree(s) :: 17 1155 04th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/21/2017 12:00:00 AM 3 3x3 Permit Number 779411 6015039.0 2109715.0 37.77372037595529 -122.391401215397 (37.7737203759553, -122.391401215397)
921 30278 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 128          
933 203966 Undocumented 2 Tree(s) :: 17 200 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft Permit Number 779992 5992562.812059999 2097843.65033 37.739851654243296 -122.46828540055901 (37.7398516542433, -122.468285400559)
937 45898 Permitted Site 1 Tree(s) :: 17   26 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
944 211703 Undocumented 2 Tree(s) :: 17 248 Lobos St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2017 12:00:00 AM 3 Width 3ft Permit Number 779802 5994526.77657 2088729.78807 37.7149404380179 -122.460834540792 (37.7149404380179, -122.460834540792)
952 48321 Permitted Site 1 Tree(s) :: 17   187 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
953 46022 Permitted Site 1 Tree(s) :: 17   215 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
983 235091 Permitted Site 1 Tree(s) :: 17 100 Putnam St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779715 6009129.80831 2096850.9527 37.7380688642945 -122.410933356597 (37.7380688642945, -122.410933356597)
993 235090 Permitted Site 1 Tree(s) :: 17 100 Putnam St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779715 6009124.9466 2096834.17608 37.7380225267172 -122.410948981415 (37.7380225267172, -122.410948981415)
1010 45949 Permitted Site 1 Tree(s) :: 17   146 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
1015 48313 Permitted Site 1 Tree(s) :: 17   179 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
1032 164022 Permitted Site 1 Tree(s) :: 17 101X Downey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/28/2017 12:00:00 AM 3 Width 3ft Permit Number 779959 5998844.0 2107514.0 37.7667648389525 -122.447263591802 (37.7667648389525, -122.447263591802)
1038 57888 Permitted Site 1 Tree(s) :: 17 2382 Fost St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/04/1977 12:00:00 AM     Permit Number 16841          
1039 186954 DPW Maintained 3 Tree(s) :: 17 2800 Sunset Blvd 28 Median : Yard 3 Tree 1 DPW 2     2 Width 0ft   5985211.8854 2096092.27 37.734615522028896 -122.493572437422 (37.7346155220289, -122.493572437422)
1067 48140 Permitted Site 1 Tree(s) :: 17   250 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
1086 48227 Permitted Site 1 Tree(s) :: 17   9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
1113 45845 Permitted Site 1 Tree(s) :: 17   81 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
1210 44727 Permitted Site 1 Tree(s) :: 17 1234 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 3x3 Permit Number 779706 5990135.3835 2102474.7725 37.752427007324 -122.47701665532301 (37.752427007324, -122.477016655323)
1215 218931 Permitted Site 1 Tree(s) :: 17 1353 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 5ft Permit Number 779656 5994855.14791 2106335.8141799998 37.7633011159875 -122.460974863827 (37.7633011159875, -122.460974863827)
1225 44628 Permitted Site 1 Tree(s) :: 17   156 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
1232 182646 Permitted Site 1 Tree(s) :: 17 1234 Ortega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 3x3 Permit Number 779706 5990115.3264 2102475.6639 37.7524282912752 -122.47708608048 (37.7524282912752, -122.47708608048)
1239 187690 Permitted Site 1 Tree(s) :: 17 876 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779712 6008536.0 2103448.0 37.7561495727301 -122.413452882223 (37.7561495727301, -122.413452882223)
1251 225915 Permitted Site 1 Tree(s) :: 17 1115 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779648 6010030.36922 2102582.89023 37.7538579673932 -122.408223810779 (37.7538579673932, -122.408223810779)
1305 251497 Undocumented 2 Tree(s) :: 17 329x Warren Dr 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   5994610.0 2103362.0 37.7551216790189 -122.461607123764 (37.7551216790189, -122.461607123764)
1321 131728 Undocumented 2 Tree(s) :: 17 2951 Buchanan St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/10/2017 12:00:00 AM 3 Width 4ft Permit Number 779933 6003422.05081 2118487.47605 37.7971557823578 -122.432212651716 (37.7971557823578, -122.432212651716)
1323 41265 Permitted Site 1 Tree(s) :: 17 2929 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/10/2017 12:00:00 AM 3 3x3 Permit Number 779089 6002901.9749300005 2118724.9020700003 37.7977781914725 -122.434029221987 (37.7977781914725, -122.434029221987)
1327 132224 Undocumented 2 Tree(s) :: 17 3720 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/10/2017 12:00:00 AM 3 Width 2ft Permit Number 779917 5997037.00688 2115048.93067 37.7873503715741 -122.454057896478 (37.7873503715741, -122.454057896478)
1334 250499 Undocumented 2 Tree(s) :: 17 540 El Camino Del Mar 2 : 4 Tree 1 Private 1   05/10/2017 12:00:00 AM 3 Width 3ft Permit Number 779924 5986884.24135 2115388.89729 37.7876964378791 -122.489208879795 (37.7876964378791, -122.489208879795)
1342 187633 Undocumented 2 Tree(s) :: 17 148 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/10/2017 12:00:00 AM 3 3x3 Permit Number 779931 5987142.0 2114987.0 37.786607985699604 -122.48828755026399 (37.7866079856996, -122.488287550264)
1357 173636 Significant Tree 6 Tree(s) :: 17 2590 Pacific Ave 2 Front Yard : Yard 7 Tree 1 Private 1   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760.0 2117029.0 37.7930568116395 -122.43785923271999 (37.7930568116395, -122.43785923272)
1358 173635 Significant Tree 6 Tree(s) :: 17 2590 Pacific Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760.0 2117029.0 37.7930568116395 -122.43785923271999 (37.7930568116395, -122.43785923272)
1360 125405 Undocumented 2 Tree(s) :: 17 2500X Pierce St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/11/2017 12:00:00 AM 3 Width 4ft Permit Number 779167 6001716.65019 2117116.43684 37.7932944253528 -122.438015491236 (37.7932944253528, -122.438015491236)

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