home / trees

Street_Tree_List

Data source: data.sfgov.org

141 rows where qSpecies = 16

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
53 100047 DPW Maintained 1 Ceanothus Sps :: California lilac 16 191@ 23rd Ave 23rd Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1     5988664.0 2114068.0 37.7841733536199 -122.48295448443399 (37.7841733536199, -122.482954484434) 11 6 2 55 26
5624 106433 DPW Maintained 1 Ceanothus Sps :: California lilac 16 571 29th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/28/2014 12:00:00 AM 1 3x4 Permit Number 772463 5986872.987869999 2112036.42636 37.778490855299204 -122.489001264146 (37.7784908552992, -122.489001264146) 11 6 2 55 26
7810 108908 DPW Maintained 1 Ceanothus Sps :: California lilac 16 85 Concord St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772733 5999781.28744 2087663.9934900003 37.7123149446499 -122.442596312184 (37.7123149446499, -122.442596312184) 9 7 6 28861 5
15861 117730 DPW Maintained 1 Ceanothus Sps :: California lilac 16 454 40th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 2ft   5983478.41225 2112771.8045099997 37.780311281435 -122.500798593525 (37.780311281435, -122.500798593525) 11 6 2 55 26
15862 117731 DPW Maintained 1 Ceanothus Sps :: California lilac 16 454 40th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 2ft   5983478.40513 2112756.72866 37.780269887136704 -122.500797502973 (37.7802698871367, -122.500797502973) 11 6 2 55 26
15989 117879 DPW Maintained 1 Ceanothus Sps :: California lilac 16 600 42nd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 4ft   5982899.694730001 2111629.29997 37.777140304321705 -122.502716018744 (37.7771403043217, -122.502716018744) 11 6 2 55 26
17056 119542 DPW Maintained 1 Ceanothus Sps :: California lilac 16 791 30th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/16/2018 12:00:00 AM 3 Width 3ft Permit Number 781594 5986618.95807 2110548.82595 37.7743914964818 -122.48977060648899 (37.7743914964818, -122.489770606489) 11 6 2 55 26
19344 121924 DPW Maintained 1 Ceanothus Sps :: California lilac 16 634 16th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   5990987.34247 2111070.84307 37.776078902206294 -122.4746978058 (37.7760789022063, -122.4746978058) 11 6 2 54 26
19591 122169 DPW Maintained 1 Ceanothus Sps :: California lilac 16 773 15th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   5991300.41308 2110156.21664 37.7735857231524 -122.473548090693 (37.7735857231524, -122.473548090693) 11 6 2 54 26
19653 122243 DPW Maintained 1 Ceanothus Sps :: California lilac 16 1602 Lake St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 4ft   5990412.22012 2114764.44305 37.7861871602654 -122.476957236709 (37.7861871602654, -122.476957236709) 11 6 1 55 33
46877 175817 DPW Maintained 1 Ceanothus Sps :: California lilac 16 1601 San Jose Ave 12 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7     6001662.2391 2094184.27122 37.7303252032495 -122.436561595945 (37.7303252032495, -122.436561595945) 9 7 6 28861 25
46878 175818 DPW Maintained 1 Ceanothus Sps :: California lilac 16 12 Newton St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 Width 5ft   6000786.090009999 2088431.87786 37.7144806101721 -122.439178423455 (37.7144806101721, -122.439178423455) 9 7 6 28861 5
46879 175819 DPW Maintained 1 Ceanothus Sps :: California lilac 16 357 Allison St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 1ft   6000300.689180001 2087012.0311900002 37.7105543958389 -122.440754372043 (37.7105543958389, -122.440754372043) 9 7 6 28861 5
46881 175820 DPW Maintained 1 Ceanothus Sps :: California lilac 16 261 Pope St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     12 Width 5ft   6000467.452330001 2087520.4423 37.711959875208 -122.440214438857 (37.711959875208, -122.440214438857) 9 7 6 28861 5
46882 175821 DPW Maintained 1 Ceanothus Sps :: California lilac 16 1703 San Jose Ave 11 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 8ft   6001663.95995 2094186.51128 37.7303314517312 -122.436555807014 (37.7303314517312, -122.436555807014) 9 7 6 28861 25
46883 175822 DPW Maintained 1 Ceanothus Sps :: California lilac 16 687 University St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     8 Width 5ft   6008710.17343 2090890.41562 37.7216789654874 -122.41196315138201 (37.7216789654874, -122.411963151382) 9 3 7 309 28
59644 188419 DPW Maintained 1 Ceanothus Sps :: California lilac 16 1300x De Haro St 7 Median : Cutout 1 Tree 1 DPW 1     8 Width 6ft   6012288.5470199995 2102174.31533 37.7528622973756 -122.40038576319901 (37.7528622973756, -122.400385763199) 10 3 8 28856 29
59646 188420 DPW Maintained 1 Ceanothus Sps :: California lilac 16 602 Arthur Ave 27 Front Yard : Yard 4 Tree 1 Private 2     5     6015754.64256 2099883.72463 37.746765491048706 -122.38823940633301 (37.7467654910487, -122.388239406333)   3 8 58 1
59647 188421 DPW Maintained 1 Ceanothus Sps :: California lilac 16 602 Arthur Ave 38 Front Yard : Yard 4 Tree 1 Private 2     7     6015740.2817 2099823.35637 37.7465989366059 -122.388284852668 (37.7465989366059, -122.388284852668) 10 3 8 58 1
59648 188422 DPW Maintained 1 Ceanothus Sps :: California lilac 16 602 Arthur Ave 39 Front Yard : Yard 4 Tree 1 Private 2     12     6015740.58656 2099810.1489 37.746562688524996 -122.38828287686 (37.746562688525, -122.38828287686) 10 3 8 58 1
59649 188423 DPW Maintained 1 Ceanothus Sps :: California lilac 16 602 Arthur Ave 40 Front Yard : Yard 4 Tree 1 Private 2     6     6015745.55798 2099807.317 37.7465551881795 -122.38826548846201 (37.7465551881795, -122.388265488462) 10 3 8 58 1
76126 204705 DPW Maintained 1 Ceanothus Sps :: California lilac 16 1550 10th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   5993090.57371 2104919.01452 37.7593092592319 -122.466974886903 (37.7593092592319, -122.466974886903) 1 8 4 56 12
76127 204706 DPW Maintained 1 Ceanothus Sps :: California lilac 16 368 Cresta Vista Dr 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     5 Width 3ft   5997198.1227 2096218.6359599999 37.735656390616995 -122.45214130629 (37.735656390617, -122.45214130629) 9 7 4 59 40
76128 204707 DPW Maintained 1 Ceanothus Sps :: California lilac 16 368 Cresta Vista Dr 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     5 Width 3ft   5997187.85064 2096211.7529900002 37.7356369032136 -122.4521763241 (37.7356369032136, -122.4521763241) 9 7 4 59 40
76129 204708 DPW Maintained 1 Ceanothus Sps :: California lilac 16 60 Sequoia Way 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 Width 3ft   5998200.81211 2097480.11593 37.7391774990296 -122.448765470767 (37.7391774990296, -122.448765470767) 9 7 4 59 40
76130 204709 DPW Maintained 1 Ceanothus Sps :: California lilac 16 545 Teresita Blvd 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 3ft   5998992.2871199995 2097331.34526 37.7388142385985 -122.446018219969 (37.7388142385985, -122.446018219969) 9 7 4 59 40
76132 204710 DPW Maintained 1 Ceanothus Sps :: California lilac 16 545 Teresita Blvd 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     4 Width 3ft   5998992.31443 2097369.41624 37.7389187739861 -122.446020863095 (37.7389187739861, -122.446020863095) 9 7 4 59 40
76133 204711 DPW Maintained 1 Ceanothus Sps :: California lilac 16 400x Marietta Dr 37 Median : Cutout 1 Tree 1 DPW 1     5 Width 3ft   5999138.58947 2096999.87001 37.737912439812796 -122.445488548067 (37.7379124398128, -122.445488548067) 9 7 4 59 40
76134 204712 DPW Maintained 1 Ceanothus Sps :: California lilac 16 400x Marietta Dr 33 Median : Cutout 1 Tree 1 DPW 1     1 Width 3ft   5999156.87837 2097007.3059599998 37.7379339012297 -122.44542584913201 (37.7379339012297, -122.445425849132) 9 7 4 59 40
77370 205924 DPW Maintained 1 Ceanothus Sps :: California lilac 16 1680 08th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 Width 4ft   5993739.53974 2104078.9229900003 37.7570400215039 -122.46466946133499 (37.7570400215039, -122.464669461335) 1 8 4 56 12
77371 205925 DPW Maintained 1 Ceanothus Sps :: California lilac 16 339 Kirkham St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 4ft   5993786.38841 2105256.23483 37.7602753154789 -122.46459292724501 (37.7602753154789, -122.464592927245) 1 8 4 56 12
77372 205926 DPW Maintained 1 Ceanothus Sps :: California lilac 16 2266 15th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 3ft   5991750.33901 2100031.2106 37.7458111754419 -122.471253906169 (37.7458111754419, -122.471253906169) 1 8 4 29491 40
77373 205927 DPW Maintained 1 Ceanothus Sps :: California lilac 16 351 Magellan Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 4ft   5994099.7296 2099750.24687 37.7451753385886 -122.463109727528 (37.7451753385886, -122.463109727528) 1 8 4 29491 40
77374 205928 DPW Maintained 1 Ceanothus Sps :: California lilac 16 201 Granville Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 5ft   5994258.7191699995 2098719.4731 37.7423542498388 -122.46248522033501 (37.7423542498388, -122.462485220335) 1 8 4 59 40
77375 205929 DPW Maintained 1 Ceanothus Sps :: California lilac 16 30 Northgate Dr 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 2ft   5994458.86462 2093951.3949900002 37.7292738076366 -122.461447593334 (37.7292738076366, -122.461447593334) 9 8 4 59 40
77377 205930 DPW Maintained 1 Ceanothus Sps :: California lilac 16 235 Hazelwood Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 2ft   5996324.55462 2094916.82803 37.7320318610725 -122.45506751047701 (37.7320318610725, -122.455067510477) 9 7 4 59 40
77378 205931 DPW Maintained 1 Ceanothus Sps :: California lilac 16 75 Fairfield Way 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 2ft   5993781.54533 2093460.7417099997 37.7278875863259 -122.463753529699 (37.7278875863259, -122.463753529699) 9 8 4 59 40
77379 205932 DPW Maintained 1 Ceanothus Sps :: California lilac 16 381 Flood Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 10ft   5998139.098569999 2094067.5739099998 37.7298039426763 -122.44873312034599 (37.7298039426763, -122.448733120346) 9 7 4 28861 40
77380 205933 DPW Maintained 1 Ceanothus Sps :: California lilac 16 491 Dewey Blvd 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     6 Width 3ft   5994722.91121 2099956.84307 37.745778478803295 -122.46096985907499 (37.7457784788033, -122.460969859075) 1 8 4 59 40
77381 205934 DPW Maintained 1 Ceanothus Sps :: California lilac 16 906 Teresita Blvd 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     4 Width 10ft   5998837.85984 2095588.97571 37.734021286451004 -122.44642684135201 (37.734021286451, -122.446426841352) 9 7 4 59 40
77382 205935 DPW Maintained 1 Ceanothus Sps :: California lilac 16 494 Joost Ave 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     5     5998796.69025 2094999.7727 37.732401122707 -122.44652680099199 (37.732401122707, -122.446526800992) 9 7 4 59 40
77383 205936 DPW Maintained 1 Ceanothus Sps :: California lilac 16 16 Foerster St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 8ft   5998119.51434 2093651.58316 37.7286606102943 -122.448770873875 (37.7286606102943, -122.448770873875) 9 7 4 28861 40
77384 205937 DPW Maintained 1 Ceanothus Sps :: California lilac 16 50 Circular Ave 1 : Yard 25 Tree 1 Private 2     6     6000127.5419 2093913.2935099998 37.7294938303644 -122.44184779835501 (37.7294938303644, -122.441847798355) 9 7 4 63 40
93630 222623 DPW Maintained 1 Ceanothus Sps :: California lilac 16 165 Prospect Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   6006768.24548 2098530.20309 37.7425470051393 -122.41921755605101 (37.7425470051393, -122.419217556051) 2 7 7 28859 2
93631 222624 DPW Maintained 1 Ceanothus Sps :: California lilac 16 132 Elsie St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 3ft   6007118.4311 2098486.84364 37.742447665140396 -122.418003641253 (37.7424476651404, -122.418003641253) 2 7 7 28859 2
93632 222625 DPW Maintained 1 Ceanothus Sps :: California lilac 16 29 Santa Marina St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   6005844.30057 2097770.6143400003 37.740409268065704 -122.422358332172 (37.7404092680657, -122.422358332172) 2 7 7 28859 2
93633 222626 DPW Maintained 1 Ceanothus Sps :: California lilac 16 101 Santa Marina St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 Width 3ft   6006239.659469999 2097553.04485 37.7398341651269 -122.42097589073201 (37.7398341651269, -122.420975890732) 2 7 7 28859 2
93634 222627 DPW Maintained 1 Ceanothus Sps :: California lilac 16 322x Elsie St 1 Median : Cutout 1 Tree 1 DPW 1     5 Width 3ft   6006329.86925 2096925.87693 37.7381171866669 -122.42061947320299 (37.7381171866669, -122.420619473203) 2 7 7 28859 2
93635 222628 DPW Maintained 1 Ceanothus Sps :: California lilac 16 625 Holly Park Cir 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   6006154.8131 2096494.16604 37.7369219373074 -122.42119408424401 (37.7369219373074, -122.421194084244) 2 7 7 28859 2
93636 222629 DPW Maintained 1 Ceanothus Sps :: California lilac 16 625 Holly Park Cir 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   6006159.030730001 2096465.73343 37.73684410546029 -122.421177483659 (37.7368441054603, -122.421177483659) 2 7 7 28859 2
93638 222630 DPW Maintained 1 Ceanothus Sps :: California lilac 16 625 Holly Park Cir 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   6006168.95016 2096431.03637 37.736749394259206 -122.421140724779 (37.7367493942592, -122.421140724779) 2 7 7 28859 2
93639 222631 DPW Maintained 1 Ceanothus Sps :: California lilac 16 625 Holly Park Cir 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   6006175.49755 2096399.14047 37.736662184315 -122.421115823447 (37.736662184315, -122.421115823447) 2 7 7 28859 2
93640 222632 DPW Maintained 1 Ceanothus Sps :: California lilac 16 520 Powhattan Ave 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     5 Width 3ft   6008348.90203 2098105.91719 37.7414709015567 -122.413722088623 (37.7414709015567, -122.413722088623) 2 7 7 28859 2
93641 222633 DPW Maintained 1 Ceanothus Sps :: California lilac 16 520 Powhattan Ave 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     6 Width 3ft   6008371.35926 2098103.14981 37.74146456403 -122.413644243307 (37.74146456403, -122.413644243307) 2 7 7 28859 2
93642 222634 DPW Maintained 1 Ceanothus Sps :: California lilac 16 520 Powhattan Ave 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     6 Width 3ft   6008398.79416 2098100.9403 37.7414600377437 -122.413549226327 (37.7414600377437, -122.413549226327) 2 7 7 28859 2
93643 222635 DPW Maintained 1 Ceanothus Sps :: California lilac 16 520 Powhattan Ave 4 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     6 Width 3ft   6008405.39649 2098099.49386 37.7414564368646 -122.41352629539499 (37.7414564368646, -122.413526295395) 2 7 7 28859 2
93644 222636 DPW Maintained 1 Ceanothus Sps :: California lilac 16 500 Powhattan Ave 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     4 Width 3ft   6008413.653 2098098.9879900003 37.741455511461204 -122.413497711367 (37.7414555114612, -122.413497711367) 2 7 7 28859 2
93645 222637 DPW Maintained 1 Ceanothus Sps :: California lilac 16 500 Powhattan Ave 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     5 Width 3ft   6008432.5305699995 2098099.2612799997 37.7414573218076 -122.413432458347 (37.7414573218076, -122.413432458347) 2 7 7 28859 2
93646 222638 DPW Maintained 1 Ceanothus Sps :: California lilac 16 500 Powhattan Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6008447.3692 2098096.32026 37.7414500795592 -122.41338094337 (37.7414500795592, -122.41338094337) 2 7 7 28859 2
93647 222639 DPW Maintained 1 Ceanothus Sps :: California lilac 16 189 Powhattan Ave 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     3 Width 3ft   6008550.17911 2098088.6135 37.741434690349706 -122.41302491618099 (37.7414346903497, -122.413024916181) 10 7 7 28859 2
93649 222640 DPW Maintained 1 Ceanothus Sps :: California lilac 16 189 Powhattan Ave 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     4 Width 3ft   6008566.69278 2098086.62744 37.7414301640605 -122.41296767703501 (37.7414301640605, -122.412967677035) 10 7 7 28859 2
93650 222641 DPW Maintained 1 Ceanothus Sps :: California lilac 16 121 Montcalm St 6 Sidewalk: Property side : Yard 5 Tree 1 Private 2     8 Width 3ft   6010335.8633 2099846.97477 37.7463628474829 -122.40697451397699 (37.7463628474829, -122.406974513977) 2 7 7 28859 2
93651 222642 DPW Maintained 1 Ceanothus Sps :: California lilac 16 121 Montcalm St 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 3ft   6010304.9642199995 2099829.75812 37.7463138452157 -122.407080146555 (37.7463138452157, -122.407080146555) 2 7 7 28859 2
93652 222643 DPW Maintained 1 Ceanothus Sps :: California lilac 16 2892 Harrison St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 3ft   6008956.86387 2101628.0145900003 37.751175923754204 -122.41186878462099 (37.7511759237542, -122.411868784621) 2 4 7 28859 19
93653 222644 DPW Maintained 1 Ceanothus Sps :: California lilac 16 121 Richland Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 3ft   6005291.14603 2096211.0656 37.736095879417796 -122.424160040259 (37.7360958794178, -122.424160040259) 2 7 7 28859 2
93654 222645 DPW Maintained 1 Ceanothus Sps :: California lilac 16 123 Richland Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   6005341.09942 2096203.92936 37.7360791052728 -122.423986823631 (37.7360791052728, -122.423986823631) 2 7 7 28859 2
93655 222646 Planning Code 138.1 required 8 Ceanothus Sps :: California lilac 16 4209 24th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/06/2018 12:00:00 AM 3 Width 3ft   6001770.77195 2101738.59247 37.7510737715579 -122.43672693271499 (37.7510737715579, -122.436726932715) 2 4 5 28862 22
93656 222647 DPW Maintained 1 Ceanothus Sps :: California lilac 16 820 Sanchez St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6003702.48516 2103374.94949 37.755676414553 -122.43016359769699 (37.755676414553, -122.430163597697) 2 4 5 28862 22
93657 222648 DPW Maintained 1 Ceanothus Sps :: California lilac 16 400 Hill St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   6003683.04706 2103350.38442 37.75560786372171 -122.43022906832898 (37.7556078637217, -122.430229068329) 2 4 5 28862 22
93658 222649 DPW Maintained 1 Ceanothus Sps :: California lilac 16 545 Sanchez St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   6003665.9595 2105128.1203 37.7604881355293 -122.430414996875 (37.7604881355293, -122.430414996875) 2 4 5 28862 3
93660 222650 DPW Maintained 1 Ceanothus Sps :: California lilac 16 91 Seward St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 3ft   6000677.8334 2104602.16707 37.7588742787364 -122.44071179810899 (37.7588742787364, -122.440711798109) 2 4 5 28862 38
93661 222651 DPW Maintained 1 Ceanothus Sps :: California lilac 16 11 Corwin St 1 Front Yard : Yard 4 Tree 1 Private 2     6 Width 3ft   6001073.475459999 2103923.13331 37.7570323403783 -122.439294815506 (37.7570323403783, -122.439294815506) 2 4 5 28862 38
93662 222652 DPW Maintained 1 Ceanothus Sps :: California lilac 16 11 Corwin St 2 Front Yard : Yard 4 Tree 1 Private 2     12 Width 3ft   6001110.99108 2103921.57138 37.7570301865074 -122.439164960595 (37.7570301865074, -122.439164960595) 2 4 5 28862 38
93663 222653 DPW Maintained 1 Ceanothus Sps :: California lilac 16 168 Caselli Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 5ft   6000185.103019999 2104897.86614 37.7596581233442 -122.44243711328501 (37.7596581233442, -122.442437113285) 2 4 5 28862 3
93664 222654 DPW Maintained 1 Ceanothus Sps :: California lilac 16 352 Diamond St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   6001768.69391 2103784.5826 37.7566914514695 -122.43688057198999 (37.7566914514695, -122.43688057199) 2 4 5 28862 3
93665 222655 DPW Maintained 1 Ceanothus Sps :: California lilac 16 310 Liberty St 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     7 Width 3ft   6004252.67601 2103946.69939 37.7572774515136 -122.428301610753 (37.7572774515136, -122.428301610753) 2 4 5 28862 3
93666 222656 DPW Maintained 1 Ceanothus Sps :: California lilac 16 310 Liberty St 21 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     8 Width 3ft   6004069.16963 2103935.80533 37.757237153785795 -122.428935470922 (37.7572371537858, -122.428935470922) 2 4 5 28862 3
93667 222657 DPW Maintained 1 Ceanothus Sps :: California lilac 16 397 Liberty St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   6003712.18229 2103887.0958 37.7570831961356 -122.430166596908 (37.7570831961356, -122.430166596908) 2 4 5 28862 3
93668 222658 DPW Maintained 1 Ceanothus Sps :: California lilac 16 397 Liberty St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   6003726.119969999 2103884.92664 37.7570780295385 -122.430118240357 (37.7570780295385, -122.430118240357) 2 4 5 28862 3
93669 222659 DPW Maintained 1 Ceanothus Sps :: California lilac 16 397 Liberty St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   6003738.16873 2103882.79645 37.757072862943296 -122.430076419198 (37.7570728629433, -122.430076419198) 2 4 5 28862 3
93671 222660 DPW Maintained 1 Ceanothus Sps :: California lilac 16 737 Sanchez St 4 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     9 Width 3ft   6003698.27718 2104074.03497 37.7575956991109 -122.43022802242201 (37.7575956991109, -122.430228022422) 2 4 5 28862 3
93672 222661 DPW Maintained 1 Ceanothus Sps :: California lilac 16 737 Sanchez St 5 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     10 Width 3ft   6003696.567000001 2104082.72525 37.757619463688606 -122.43023455689199 (37.7576194636886, -122.430234556892) 2 4 5 28862 3
93673 222662 DPW Maintained 1 Ceanothus Sps :: California lilac 16 396 Cumberland St 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 3ft   6003135.7572800005 2104484.9325599996 37.7586920482127 -122.43220278703899 (37.7586920482127, -122.432202787039) 2 4 5 28862 3
93674 222663 DPW Maintained 1 Ceanothus Sps :: California lilac 16 4090 20th St 2 : Yard 25 Tree 1 Private 2     9 Width 3ft   6003162.223809999 2104187.96649 37.7578781509761 -122.43209004713002 (37.7578781509761, -122.43209004713) 2 4 5 28862 3
93675 222664 DPW Maintained 1 Ceanothus Sps :: California lilac 16 4090 20th St 3 : Yard 25 Tree 1 Private 2     9 Width 3ft   6003149.42788 2104190.19818 37.7578835531891 -122.432134460156 (37.7578835531891, -122.432134460156) 2 4 5 28862 3
93676 222665 DPW Maintained 1 Ceanothus Sps :: California lilac 16 4090 20th St 4 : Yard 25 Tree 1 Private 2     8 Width 3ft   6003145.04093 2104185.04238 37.7578691478694 -122.432149263871 (37.7578691478694, -122.432149263871) 2 4 5 28862 3
93677 222666 DPW Maintained 1 Ceanothus Sps :: California lilac 16 4090 20th St 5 : Yard 25 Tree 1 Private 2     8 Width 3ft   6003140.83414 2104172.66898 37.7578349349576 -122.432162929082 (37.7578349349576, -122.432162929082) 2 4 5 28862 3
93678 222667 DPW Maintained 1 Ceanothus Sps :: California lilac 16 645 Noe St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   6003055.60188 2104525.93514 37.7588000864676 -122.432482929452 (37.7588000864676, -122.432482929452) 2 4 5 28862 3
93679 222668 DPW Maintained 1 Ceanothus Sps :: California lilac 16 645 Noe St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6003056.97537 2104549.20276 37.7588640516623 -122.43247984119199 (37.7588640516623, -122.432479841192) 2 4 5 28862 3
93680 222669 DPW Maintained 1 Ceanothus Sps :: California lilac 16 740 Sanchez St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 3ft   6003665.94004 2103977.3690299997 37.757328445773204 -122.43033296071998 (37.7573284457732, -122.43033296072) 2 4 5 28862 3
93682 222670 DPW Maintained 1 Ceanothus Sps :: California lilac 16 790 Sanchez St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 3ft   6003687.86635 2103677.4965 37.7565063089475 -122.430235737705 (37.7565063089475, -122.430235737705) 2 4 5 28862 3
93683 222671 DPW Maintained 1 Ceanothus Sps :: California lilac 16 841 Church St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   6004365.5079 2104119.71112 37.7577588846739 -122.42792372191002 (37.7577588846739, -122.42792372191) 2 4 5 28862 3
93684 222672 DPW Maintained 1 Ceanothus Sps :: California lilac 16 841 Church St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   6004365.3419699995 2104133.78232 37.75779751147579 -122.427925298424 (37.7577975114758, -122.427925298424) 2 4 5 28862 3
93685 222673 DPW Maintained 1 Ceanothus Sps :: California lilac 16 190 Storrie St 10 Front Yard : Yard 4 Tree 1 Private 2     8 Width 3ft   6000769.8265 2105310.91905 37.7608255764675 -122.440444475527 (37.7608255764675, -122.440444475527) 15 4 5 28862 3
93686 222674 DPW Maintained 1 Ceanothus Sps :: California lilac 16 190 Storrie St 12 Front Yard : Yard 4 Tree 1 Private 2     9 Width 3ft   6000781.07373 2105315.7314400002 37.760839430522104 -122.440405921593 (37.7608394305221, -122.440405921593) 15 4 5 28862 3
93687 222675 DPW Maintained 1 Ceanothus Sps :: California lilac 16 110 Henry St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6002794.36582 2107408.76473 37.766700821303395 -122.433592429354 (37.7667008213034, -122.433592429354) 15 5 5 28862 3
93688 222676 DPW Maintained 1 Ceanothus Sps :: California lilac 16 701 Church St 36 Front Yard : Yard 4 Tree 1 Private 2     8 Width 3ft   6004317.3839 2104765.72552 37.7595299645462 -122.428136192139 (37.7595299645462, -122.428136192139) 2 4 5 28862 3
93726 222711 DPW Maintained 1 Ceanothus Sps :: California lilac 16 276 Bemis St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     10 Width 8ft   6002996.93111 2096284.15675 37.7361667666773 -122.432097283983 (37.7361667666773, -122.432097283983) 2 7 5 63 7
93727 222712 DPW Maintained 1 Ceanothus Sps :: California lilac 16 1101 San Jose Ave 4 Front Yard : Yard 4 Tree 1 Private 2     12     6004716.12579 2096285.00945 37.7362664286601 -122.426153382197 (37.7362664286601, -122.426153382197) 2 7 5 28859 2
93728 222713 DPW Maintained 1 Ceanothus Sps :: California lilac 16 1101 San Jose Ave 5 Front Yard : Yard 4 Tree 1 Private 2     12     6004721.26774 2096288.8896299999 37.7362773733874 -122.426135880489 (37.7362773733874, -122.426135880489) 2 7 5 28859 2

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" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 22.604ms · Data source: data.sfgov.org