82 rows where qSpecies_id = 140

View and edit SQL

rowid ▼ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
785 262387 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1525 Galvez Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/03/2017 12:18:00 PM       6016246.49948 2097351.8889 37.739840829559 -122.38636210374 (37.739840829559, -122.38636210374) 10 3 8 58 1
2809 251459 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 651 Texas St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/03/2017 12:00:00 AM 3 3x3                      
5719 108450 Section 806 (d) 5 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 696 Pennsylvania Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6014379.30863 2103997.39375 37.7579844490278 -122.393283028308 (37.7579844490278, -122.393283028308) 10 3 8 28856 29
6006 253478 Planning Code 138.1 required 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1222 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984 2109753 37.7735428603255 -122.408890010762 (37.7735428603255, -122.408890010762) 8 2 9 28853 34
7842 108451 Section 806 (d) 5 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 696 Pennsylvania Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6014380.97285 2103975.72487 37.7579250434155 -122.393275756387 (37.7579250434155, -122.393275756387) 10 3 8 28856 29
8951 108447 Section 806 (d) 5 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 696 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6014378.0974 2104018.35584 37.7580419391129 -122.393288684138 (37.7580419391129, -122.393288684138) 10 3 8 28856 29
10200 261331 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 831 Broadway 4 Median : Cutout Tree DPW 1       3x3   6009625 2118347 37.7971198129045 -122.410738895692 (37.7971198129045, -122.410738895692) 3 1 10 308 4
10248 108452 Section 806 (d) 5 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 696 Pennsylvania Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6014381.40925 2103952.18314 37.757860427147 -122.393272599772 (37.757860427147, -122.393272599772) 10 3 8 28856 29
11656 8248 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1515 Galvez Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/27/2017 09:09:00 AM 3 3x3   6016190.19282 2097375.14571 37.739901571095 -122.38655841155 (37.739901571095, -122.38655841155) 10 3 8 58 1
11659 78625 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 862 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6011556.98841 2104318.55424 37.7587090822626 -122.403066453361 (37.7587090822626, -122.403066453361) 10 3 8 28856 29
14750 108453 Section 806 (d) 5 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 696 Pennsylvania Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6014383.1993 2103935.66602 37.7578151741454 -122.393265253191 (37.7578151741454, -122.393265253191) 10 3 8 28856 29
15523 248949 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1500x Galvez Ave 19 Sidewalk: Curb side : Cutout Tree DPW 1 Private 03/18/2017 09:13:00 AM 3 3x3   6016393 2097292 37.7396844950272 -122.385851388433 (37.7396844950272, -122.385851388433) 10 3 8 58 1
16018 150373 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 542 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2018 12:00:00 AM 3 Width 4ft   6014345.99828 2104577.56891 37.7595756339334 -122.393438832261 (37.7595756339334, -122.393438832261) 10 3 8 28856 29
26799 189110 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1280 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6014210.0262 2103887.6489 37.757673707186 -122.393860801355 (37.757673707186, -122.393860801355) 10 3 8 28856 29
28453 248943 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1500x Galvez Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1 Private 04/10/2017 01:08:00 PM 3 3x3   6016393 2097292 37.7396844950272 -122.385851388433 (37.7396844950272, -122.385851388433) 10 3 8 58 1
28553 189109 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1260 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6014233.46906 2103889.79401 37.757680899967 -122.393779875866 (37.757680899967, -122.393779875866) 10 3 8 28856 29
33157 92726 Permitted Site 7 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1050X Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/25/2009 12:00:00 AM 3 3x3 Permit Number 52961 6007521.6 2109720.7 37.7733159350791 -122.417405549826 (37.7733159350791, -122.417405549826) 8 2 9 28853 19
34752 248944 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1500x Galvez Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1 Private 04/10/2017 12:58:00 PM 3 3x3   6016393 2097292 37.7396844950272 -122.385851388433 (37.7396844950272, -122.385851388433) 10 3 8 58 1
37476 253074 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2849X Alemany Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/2017 11:14:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.450099227424 (37.7132258706419, -122.450099227424) 9 7 6 28861 25
37836 71591 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 187 Goethe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/2017 11:19:00 AM 3     5994642.6055 2086698.5979 37.709369932055 -122.460287110874 (37.709369932055, -122.460287110874) 9 8 6 28861 25
42190 253480 Planning Code 138.1 required 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1222 Harrison St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984 2109753 37.7735428603255 -122.408890010762 (37.7735428603255, -122.408890010762) 8 2 9 28853 34
48229 189105 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1230 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6014303.7497 2103893.88664 37.7576960427644 -122.39353710115 (37.7576960427644, -122.39353710115) 10 3 8 28856 29
49008 189107 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1250 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6014268.80299 2103891.14694 37.757686578301 -122.393657770403 (37.757686578301, -122.393657770403) 10 3 8 28856 29
52942 56547 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 579 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2     13     6013852.90853 2104423.88936 37.7591262544015 -122.395133430179 (37.7591262544015, -122.395133430179) 10 3 8 28856 29
54631 189106 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1240 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6014286.83976 2103892.98816 37.757692636135 -122.393595520235 (37.757692636135, -122.393595520235) 10 3 8 28856 29
55132 97390 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1400X Broadway 14 Median : Cutout Tree DPW 1           6006851 2118099.6 37.7962845906619 -122.420320069483 (37.7962845906619, -122.420320069483) 13 9 10 28858 32
59810 47298 Permitted Site 7 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2116 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2002 12:00:00 AM     Permit Number 45234 6009545.1120053 2104917.22843549 37.7602403504709 -122.410066736368 (37.7602403504709, -122.410066736368) 2 4 7 28859 19
67479 38275 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 651 Texas St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/03/2017 12:00:00 AM 3   Permit Number 40367 6013943.54254 2103938.72902 37.7577991491248 -122.394785995079 (37.7577991491248, -122.394785995079) 10 3 8 28856 29
67579 567 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2956 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/30/2015 12:00:00 AM 3 3x3   6009153.93134 2102188.78939 37.7527267398546 -122.411226910619 (37.7527267398546, -122.411226910619) 2 4 7 28859 19
69261 253088 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2849X Alemany Blvd 21 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   5997618.33471 2088040.74004 37.7132258706419 -122.450099227424 (37.7132258706419, -122.450099227424) 9 7 6 28861 25
70250 96280 Permitted Site 7 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 3207 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/19/2011 12:00:00 AM   2x2 Permit Number 58764 6011955.4 2090682.8 37.721290434233 -122.400730615808 (37.721290434233, -122.400730615808) 10 7 8 309 28
75269 253079 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2849X Alemany Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/2017 11:57:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.450099227424 (37.7132258706419, -122.450099227424) 9 7 6 28861 25
76355 109318 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 3184 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/2015 12:00:00 AM 3 3x3 Permit Number 773321 6006634.8 2099829.9 37.7461081640052 -122.419771172989 (37.7461081640052, -122.419771172989) 2 7 7 28859 2
76856 189108 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1260 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6014251.8819 2103889.69714 37.7576816571866 -122.393716189448 (37.7576816571866, -122.393716189448) 10 3 8 28856 29
80426 38268 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1300 22nd St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2017 12:00:00 AM 3 3x3 Permit Number 42733 6014084.1716 2103880.9585 37.7576483418192 -122.394295592984 (37.7576483418192, -122.394295592984) 10 3 8 28856 29
83260 189103 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1200 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6014366.46435 2103897.54658 37.7577095766431 -122.393320462565 (37.7577095766431, -122.393320462565) 10 3 8 28856 29
84585 38267 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1300 22nd St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/03/2017 12:00:00 AM 3   Permit Number 40367 6014066.98761 2103880.20359 37.7576453137923 -122.394354969833 (37.7576453137923, -122.394354969833) 10 3 8 28856 29
86801 137774 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 900x DIVISADERO ST 7 Median : Cutout Tree DPW 1   10/10/2017 09:09:00 AM 3 Width 0ft   6001464.3665 2111724.7391 37.7784758562415 -122.438501924604 (37.7784758562415, -122.438501924604) 15 5 11 29490 41
87938 97389 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1400X Broadway 13 Median : Cutout Tree DPW 1           6006851 2118099.6 37.7962845906619 -122.420320069483 (37.7962845906619, -122.420320069483) 13 9 10 28858 32
89889 189104 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1210 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6014347.03164 2103896.55008 37.7577057608157 -122.393387599655 (37.7577057608157, -122.393387599655) 10 3 8 28856 29
91729 189115 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 699 Mississippi St 4 : Tree Private 2     7 Width 3ft   6014160.16127 2103962.94719 37.7578776887295 -122.394038527182 (37.7578776887295, -122.394038527182) 10 3 8 28856 29
95173 106890 Permitted Site 7 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 268 Madison St   Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 772526 6005657.74403 2092444.4985 37.7257744103885 -122.422624985429 (37.7257744103885, -122.422624985429) 9 7 7 309 5
98977 189102 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 670 Pennsylvania Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6014376.92381 2104041.17817 37.7581045391059 -122.393294339973 (37.7581045391059, -122.393294339973) 10 3 8 28856 29
99757 8263 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1555 Galvez Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 01:25:00 PM 3 3x3   6016021.98279 2097500.00782 37.740235103578 -122.387148723852 (37.740235103578, -122.387148723852) 10 3 8 58 1
100683 104454 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 616 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2013 12:00:00 AM 2 3x3 Permit Number 769741 6015946.56461 2104917.06512 37.7605966171506 -122.387926917095 (37.7605966171506, -122.387926917095) 10 3 8 28856 29
100931 248948 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1500x Galvez Ave 18 Sidewalk: Curb side : Cutout Tree DPW 1 Private 04/10/2017 01:15:00 PM 3 3x3   6016393 2097292 37.7396844950272 -122.385851388433 (37.7396844950272, -122.385851388433) 10 3 8 58 1
102512 92728 Permitted Site 7 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1050X Minna St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/25/2009 12:00:00 AM 3 3x3 Permit Number 52961 6007521.6 2109720.7 37.7733159350791 -122.417405549826 (37.7733159350791, -122.417405549826) 8 2 9 28853 19
106497 253089 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2849X Alemany Blvd 22 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   5997618.33471 2088040.74004 37.7132258706419 -122.450099227424 (37.7132258706419, -122.450099227424) 9 7 6 28861 25
106516 253084 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2849X Alemany Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/2017 10:31:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.450099227424 (37.7132258706419, -122.450099227424) 9 7 6 28861 25
107414 189114 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 699 Mississippi St 3 : Tree Private 2     6 Width 3ft   6014159.23109 2103944.12495 37.757825955228 -122.394040426527 (37.757825955228, -122.394040426527) 10 3 8 28856 29
113840 97388 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1400X Broadway 11 Median : Cutout Tree DPW 1           6006851 2118099.6 37.7962845906619 -122.420320069483 (37.7962845906619, -122.420320069483) 13 9 10 28858 32
113997 189112 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 699 Mississippi St 1 : Tree Private 2     8 Width 3ft   6014162.08856 2103908.83128 37.75772920525 -122.394028073449 (37.75772920525, -122.394028073449) 10 3 8 28856 29
118208 97376 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1300X Broadway 10 Median : Cutout Tree DPW 1           6007392.5 2118111.1 37.7963466650802 -122.418447178533 (37.7963466650802, -122.418447178533) 5 1 10 28858 32
121637 253479 Planning Code 138.1 required 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1222 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984 2109753 37.7735428603255 -122.408890010762 (37.7735428603255, -122.408890010762) 8 2 9 28853 34
121724 1161 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2849X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/2017 11:11:00 AM 3 4x4   5997197.16244 2087689.8729 37.7122383601778 -122.451529643197 (37.7122383601778, -122.451529643197) 9 7 6 28861 25
122981 96281 Permitted Site 7 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 3217 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/19/2011 12:00:00 AM   2x2 Permit Number 58765 6011946.6 2090709.2 37.7213624324365 -122.400762888856 (37.7213624324365, -122.400762888856) 10 7 8 309 28
125556 92731 Permitted Site 7 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 21 Lafayette St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/25/2009 12:00:00 AM 3 3x3 Permit Number 52961 6007522.9 2109721.4 37.773317930256 -122.417401102553 (37.773317930256, -122.417401102553) 8 2 9 28853 19
128863 253475 Planning Code 138.1 required 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1222 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984 2109753 37.7735428603255 -122.408890010762 (37.7735428603255, -122.408890010762) 8 2 9 28853 34
134557 189111 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1290 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6014187.98978 2103886.57813 37.7576695424188 -122.393936937949 (37.7576695424188, -122.393936937949) 10 3 8 28856 29
135281 253476 Planning Code 138.1 required 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1222 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984 2109753 37.7735428603255 -122.408890010762 (37.7735428603255, -122.408890010762) 8 2 9 28853 34
137810 248950 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1500x Galvez Ave 26 Sidewalk: Curb side : Cutout Tree DPW 1 Private 04/10/2017 01:18:00 PM 3 3x3   6016393 2097292 37.7396844950272 -122.385851388433 (37.7396844950272, -122.385851388433) 10 3 8 58 1
141246 253077 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2849X Alemany Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/2017 11:16:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.450099227424 (37.7132258706419, -122.450099227424) 9 7 6 28861 25
147102 253075 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2849X Alemany Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/2017 11:04:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.450099227424 (37.7132258706419, -122.450099227424) 9 7 6 28861 25
147738 248946 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1500x Galvez Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1 Private 04/10/2017 01:12:00 PM 3 3x3   6016393 2097292 37.7396844950272 -122.385851388433 (37.7396844950272, -122.385851388433) 10 3 8 58 1
152133 92729 Permitted Site 7 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1050X Minna St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/25/2009 12:00:00 AM 3 3x3 Permit Number 52961 6007521.6 2109720.7 37.7733159350791 -122.417405549826 (37.7733159350791, -122.417405549826) 8 2 9 28853 19
154647 189113 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 699 Mississippi St 2 : Tree Private 2     6 Width 3ft   6014159.52171 2103926.66115 37.7577780195591 -122.394038198901 (37.7577780195591, -122.394038198901) 10 3 8 28856 29
158111 97387 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1400X Broadway 12 Median : Cutout Tree DPW 1           6006851 2118099.6 37.7962845906619 -122.420320069483 (37.7962845906619, -122.420320069483) 13 9 10 28858 32
158801 255310 Permitted Site 7 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 78 Ringold St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2018 12:00:00 AM 3 3x3 Permit Number 781832 6009441.63714 2109802.01847 37.77364705863 -122.41076959437 (37.77364705863, -122.41076959437) 8 2 9 28853 34
161297 189116 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 699 Mississippi St 5 : Tree Private 2     5 Width 3ft   6014160.30569 2103982.50458 37.7579313971221 -122.394039396809 (37.7579313971221, -122.394039396809) 10 3 8 28856 29
162182 104456 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 616 20th St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2013 12:00:00 AM 2 3x3 Permit Number 769741 6015916.64617 2104915.06624 37.7605894711477 -122.388030252816 (37.7605894711477, -122.388030252816) 10 3 8 28856 29
171083 253076 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2849X Alemany Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/2017 11:52:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.450099227424 (37.7132258706419, -122.450099227424) 9 7 6 28861 25
171171 253477 Planning Code 138.1 required 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1222 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984 2109753 37.7735428603255 -122.408890010762 (37.7735428603255, -122.408890010762) 8 2 9 28853 34
176273 97386 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1400X Broadway 10 Median : Cutout Tree DPW 1           6006851 2118099.6 37.7962845906619 -122.420320069483 (37.7962845906619, -122.420320069483) 13 9 10 28858 32
179484 97375 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1300X Broadway 11 Median : Cutout Tree DPW 1           6007392.5 2118111.1 37.7963466650802 -122.418447178533 (37.7963466650802, -122.418447178533) 5 1 10 28858 32
180130 92727 Permitted Site 7 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1050X Minna St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/25/2009 12:00:00 AM 3 3x3 Permit Number 52961 6007521.6 2109720.7 37.7733159350791 -122.417405549826 (37.7733159350791, -122.417405549826) 8 2 9 28853 19
181922 8262 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1555 Galvez Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2017 01:22:00 PM 3 3x3   6016000.34735 2097516.43828 37.7402790201492 -122.387224676975 (37.7402790201492, -122.387224676975) 10 3 8 58 1
185044 104455 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 616 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2013 12:00:00 AM 2 3x3 Permit Number 769741 6015933.26699 2104915.91228 37.7605927150107 -122.387972827483 (37.7605927150107, -122.387972827483) 10 3 8 28856 29
188686 539 Permitted Site 7 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2862 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/2016 07:55:00 AM 3 3X3   6009630.84107 2102242.33848 37.7529005086992 -122.409581443394 (37.7529005086992, -122.409581443394) 2 4 7 28859 19
190759 187771 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1515 Galvez Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/03/2017 02:59:00 PM 3 Width 4ft   6016208.76449 2097362.171 37.7398669732767 -122.38649329343 (37.7398669732767, -122.38649329343) 10 3 8 58 1
190813 253078 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2849X Alemany Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/2017 10:44:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.450099227424 (37.7132258706419, -122.450099227424) 9 7 6 28861 25
190976 253073 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2849X Alemany Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/2017 11:54:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.450099227424 (37.7132258706419, -122.450099227424) 9 7 6 28861 25
192467 117198 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 78 Ringold St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2018 12:00:00 AM 3 2.5x2.5 Permit Number 781832 6009460.13147 2109802.88553 37.7736504763223 -122.410705680637 (37.7736504763223, -122.410705680637) 8 2 9 28853 34

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);