Street_Tree_List

Data source: data.sfgov.org

74 rows where qSpecies = 87

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
498 248943 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1500x Galvez Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/10/2017 01:08:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
499 248944 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1500x Galvez Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/10/2017 12:58:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
513 8263 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1555 Galvez Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 01:25:00 PM 3 3x3   6016021.98279 2097500.00782 37.740235103578 -122.38714872385201 (37.740235103578, -122.387148723852)
517 248948 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1500x Galvez Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/10/2017 01:15:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
525 248950 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1500x Galvez Ave 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/10/2017 01:18:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
527 248946 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1500x Galvez Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/10/2017 01:12:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
530 8262 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1555 Galvez Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/2017 01:22:00 PM 3 3x3   6016000.34735 2097516.43828 37.7402790201492 -122.38722467697501 (37.7402790201492, -122.387224676975)
995 8248 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1515 Galvez Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/27/2017 09:09:00 AM 3 3x3   6016190.1928199995 2097375.14571 37.739901571095 -122.38655841155001 (37.739901571095, -122.38655841155)
996 248949 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1500x Galvez Ave 19 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/18/2017 09:13:00 AM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
1112 38268 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1300 22nd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/03/2017 12:00:00 AM 3 3x3 Permit Number 42733 6014084.1716 2103880.9585 37.757648341819205 -122.39429559298401 (37.7576483418192, -122.394295592984)
1125 38267 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1300 22nd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/03/2017 12:00:00 AM 3   Permit Number 40367 6014066.98761 2103880.20359 37.757645313792295 -122.39435496983299 (37.7576453137923, -122.394354969833)
1128 38275 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 651 Texas St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/03/2017 12:00:00 AM 3   Permit Number 40367 6013943.54254 2103938.72902 37.7577991491248 -122.394785995079 (37.7577991491248, -122.394785995079)
1130 251459 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 651 Texas St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/03/2017 12:00:00 AM 3 3x3            
1146 187771 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1515 Galvez Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/03/2017 02:59:00 PM 3 Width 4ft   6016208.76449 2097362.171 37.7398669732767 -122.38649329343001 (37.7398669732767, -122.38649329343)
3519 253478 Planning Code 138.1 required 4 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1222 Harrison St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984.0 2109753.0 37.7735428603255 -122.40889001076201 (37.7735428603255, -122.408890010762)
3535 253480 Planning Code 138.1 required 4 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1222 Harrison St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984.0 2109753.0 37.7735428603255 -122.40889001076201 (37.7735428603255, -122.408890010762)
3565 253475 Planning Code 138.1 required 4 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1222 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984.0 2109753.0 37.7735428603255 -122.40889001076201 (37.7735428603255, -122.408890010762)
3568 253479 Planning Code 138.1 required 4 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1222 Harrison St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984.0 2109753.0 37.7735428603255 -122.40889001076201 (37.7735428603255, -122.408890010762)
3570 253476 Planning Code 138.1 required 4 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1222 Harrison St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984.0 2109753.0 37.7735428603255 -122.40889001076201 (37.7735428603255, -122.408890010762)
3584 253477 Planning Code 138.1 required 4 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1222 Harrison St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984.0 2109753.0 37.7735428603255 -122.40889001076201 (37.7735428603255, -122.408890010762)
4226 137774 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 900x DIVISADERO ST 7 Median : Cutout 11 Tree 1 DPW 2   10/10/2017 09:09:00 AM 3 Width 0ft   6001464.3665 2111724.7391 37.7784758562415 -122.438501924604 (37.7784758562415, -122.438501924604)
4393 71591 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 187 Goethe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/2017 11:19:00 AM 3     5994642.6055 2086698.5979 37.709369932055004 -122.460287110874 (37.709369932055, -122.460287110874)
4455 253074 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 2849X Alemany Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/13/2017 11:14:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4483 253079 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 2849X Alemany Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/13/2017 11:57:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4498 253084 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 2849X Alemany Blvd 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/13/2017 10:31:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4508 253077 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 2849X Alemany Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/13/2017 11:16:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4511 253075 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 2849X Alemany Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/13/2017 11:04:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4524 253076 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 2849X Alemany Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/13/2017 11:52:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4527 253078 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 2849X Alemany Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/13/2017 10:44:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4529 253073 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 2849X Alemany Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/13/2017 11:54:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
14083 108447 Section 143 8 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 696 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6014378.0974 2104018.3558400003 37.7580419391129 -122.393288684138 (37.7580419391129, -122.393288684138)
18290 567 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 2956 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/30/2015 12:00:00 AM 3 3x3   6009153.931340001 2102188.78939 37.7527267398546 -122.41122691061899 (37.7527267398546, -122.411226910619)
27410 108451 Section 143 8 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 696 Pennsylvania Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x3   6014380.97285 2103975.72487 37.7579250434155 -122.393275756387 (37.7579250434155, -122.393275756387)
30423 104456 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 616 20th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/07/2013 12:00:00 AM 2 3x3 Permit Number 769741 6015916.64617 2104915.06624 37.7605894711477 -122.38803025281601 (37.7605894711477, -122.388030252816)
31684 189114 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 699 Mississippi St 3 : 4 Tree 1 Private 1     6 Width 3ft   6014159.23109 2103944.12495 37.757825955228 -122.394040426527 (37.757825955228, -122.394040426527)
35101 189111 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1290 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6014187.98978 2103886.57813 37.757669542418796 -122.39393693794901 (37.7576695424188, -122.393936937949)
36742 189104 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1210 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6014347.03164 2103896.55008 37.7577057608157 -122.393387599655 (37.7577057608157, -122.393387599655)
37107 189108 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1260 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6014251.8819 2103889.6971400003 37.7576816571866 -122.393716189448 (37.7576816571866, -122.393716189448)
39867 189109 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1260 22nd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6014233.46906 2103889.79401 37.757680899967 -122.39377987586599 (37.757680899967, -122.393779875866)
44308 56547 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 579 Texas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13     6013852.908530001 2104423.88936 37.7591262544015 -122.395133430179 (37.7591262544015, -122.395133430179)
47703 189116 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 699 Mississippi St 5 : 4 Tree 1 Private 1     5 Width 3ft   6014160.30569 2103982.50458 37.7579313971221 -122.394039396809 (37.7579313971221, -122.394039396809)
51815 189110 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1280 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6014210.0262 2103887.6489 37.757673707186 -122.393860801355 (37.757673707186, -122.393860801355)
66781 189115 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 699 Mississippi St 4 : 4 Tree 1 Private 1     7 Width 3ft   6014160.16127 2103962.94719 37.7578776887295 -122.394038527182 (37.7578776887295, -122.394038527182)
76671 104455 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 616 20th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/07/2013 12:00:00 AM 2 3x3 Permit Number 769741 6015933.26699 2104915.91228 37.7605927150107 -122.38797282748301 (37.7605927150107, -122.387972827483)
78773 97390 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1400X Broadway 14 Median : Cutout 11 Tree 1 DPW 2           6006851.0 2118099.6 37.7962845906619 -122.420320069483 (37.7962845906619, -122.420320069483)
89447 96280 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 3207 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/19/2011 12:00:00 AM   2x2 Permit Number 58764 6011955.4 2090682.8 37.721290434233 -122.40073061580799 (37.721290434233, -122.400730615808)
89585 47298 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 2116 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/16/2002 12:00:00 AM     Permit Number 45234 6009545.1120053 2104917.22843549 37.7602403504709 -122.41006673636801 (37.7602403504709, -122.410066736368)
94378 106890 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 268 Madison St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 772526 6005657.744030001 2092444.4985 37.725774410388496 -122.422624985429 (37.7257744103885, -122.422624985429)
96286 97389 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1400X Broadway 13 Median : Cutout 11 Tree 1 DPW 2           6006851.0 2118099.6 37.7962845906619 -122.420320069483 (37.7962845906619, -122.420320069483)
98745 109318 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 3184 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/10/2015 12:00:00 AM 3 3x3 Permit Number 773321 6006634.8 2099829.9 37.7461081640052 -122.419771172989 (37.7461081640052, -122.419771172989)
101017 92728 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1050X Minna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/2009 12:00:00 AM 3 3x3 Permit Number 52961 6007521.6 2109720.7 37.773315935079104 -122.41740554982599 (37.7733159350791, -122.417405549826)
101756 97388 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1400X Broadway 11 Median : Cutout 11 Tree 1 DPW 2           6006851.0 2118099.6 37.7962845906619 -122.420320069483 (37.7962845906619, -122.420320069483)
104003 189106 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1240 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6014286.83976 2103892.9881599997 37.757692636135005 -122.39359552023501 (37.757692636135, -122.393595520235)
105633 96281 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 3217 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/19/2011 12:00:00 AM   2x2 Permit Number 58765 6011946.6 2090709.2 37.7213624324365 -122.400762888856 (37.7213624324365, -122.400762888856)
106439 97376 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1300X Broadway 10 Median : Cutout 11 Tree 1 DPW 2           6007392.5 2118111.1 37.7963466650802 -122.418447178533 (37.7963466650802, -122.418447178533)
110094 92731 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 21 Lafayette St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/2009 12:00:00 AM 3 3x3 Permit Number 52961 6007522.9 2109721.4 37.773317930256 -122.417401102553 (37.773317930256, -122.417401102553)
121405 97387 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1400X Broadway 12 Median : Cutout 11 Tree 1 DPW 2           6006851.0 2118099.6 37.7962845906619 -122.420320069483 (37.7962845906619, -122.420320069483)
121864 92729 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1050X Minna St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/2009 12:00:00 AM 3 3x3 Permit Number 52961 6007521.6 2109720.7 37.773315935079104 -122.41740554982599 (37.7733159350791, -122.417405549826)
128987 92726 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1050X Minna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/2009 12:00:00 AM 3 3x3 Permit Number 52961 6007521.6 2109720.7 37.773315935079104 -122.41740554982599 (37.7733159350791, -122.417405549826)
131002 104454 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 616 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/07/2013 12:00:00 AM 2 3x3 Permit Number 769741 6015946.56461 2104917.06512 37.760596617150604 -122.38792691709499 (37.7605966171506, -122.387926917095)
133700 189107 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1250 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6014268.80299 2103891.1469400004 37.757686578301 -122.39365777040301 (37.757686578301, -122.393657770403)
136446 108453 Section 143 8 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 696 Pennsylvania Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3x3   6014383.1993 2103935.66602 37.7578151741454 -122.39326525319099 (37.7578151741454, -122.393265253191)
138437 97386 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1400X Broadway 10 Median : Cutout 11 Tree 1 DPW 2           6006851.0 2118099.6 37.7962845906619 -122.420320069483 (37.7962845906619, -122.420320069483)
139756 539 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 2862 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2016 07:55:00 AM 3 3X3   6009630.84107 2102242.33848 37.752900508699206 -122.40958144339399 (37.7529005086992, -122.409581443394)
141313 97375 DPW Maintained 3 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1300X Broadway 11 Median : Cutout 11 Tree 1 DPW 2           6007392.5 2118111.1 37.7963466650802 -122.418447178533 (37.7963466650802, -122.418447178533)
141904 92727 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1050X Minna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/2009 12:00:00 AM 3 3x3 Permit Number 52961 6007521.6 2109720.7 37.773315935079104 -122.41740554982599 (37.7733159350791, -122.417405549826)
152861 189113 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 699 Mississippi St 2 : 4 Tree 1 Private 1     6 Width 3ft   6014159.52171 2103926.66115 37.757778019559105 -122.394038198901 (37.7577780195591, -122.394038198901)
155993 78625 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 862 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/07/2000 12:00:00 AM 7     6011556.98841 2104318.55424 37.758709082262605 -122.40306645336099 (37.7587090822626, -122.403066453361)
168484 189102 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 670 Pennsylvania Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6014376.92381 2104041.17817 37.758104539105894 -122.393294339973 (37.7581045391059, -122.393294339973)
168610 189103 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1200 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6014366.46435 2103897.54658 37.7577095766431 -122.393320462565 (37.7577095766431, -122.393320462565)
180403 189112 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 699 Mississippi St 1 : 4 Tree 1 Private 1     8 Width 3ft   6014162.08856 2103908.83128 37.75772920525 -122.39402807344901 (37.75772920525, -122.394028073449)
184427 108452 Section 143 8 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 696 Pennsylvania Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   6014381.40925 2103952.1831400003 37.757860427147 -122.39327259977199 (37.757860427147, -122.393272599772)
185175 189105 Undocumented 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1230 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6014303.7497 2103893.88664 37.757696042764394 -122.39353710115 (37.7576960427644, -122.39353710115)
187247 108450 Section 143 8 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 696 Pennsylvania Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6014379.30863 2103997.39375 37.757984449027795 -122.39328302830799 (37.7579844490278, -122.393283028308)

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