Street_Tree_List

Data source: data.sfgov.org

5,577 rows where qSpecies = 12 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH ▼ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
294 294 251266 Private 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 10x Paloma Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
675 675 47038 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 716 Walter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/2002 12:00:00 AM     Permit Number 45030          
752 752 251380 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 731 Huron Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       2x5   5997668.0 2087467.0 37.7116533538928 -122.449886244657 (37.7116533538928, -122.449886244657)
783 783 251381 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 731 Huron Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       2x5   5997668.0 2087467.0 37.7116533538928 -122.449886244657 (37.7116533538928, -122.449886244657)
820 820 251223 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 80X Junipero Serra Blvd 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/2008 12:00:00 AM   Width 3ft   5991438.54417 2088636.90192 37.714507218415 -122.47150190860901 (37.714507218415, -122.471501908609)
844 844 251224 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 80X Junipero Serra Blvd 23 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/2008 12:00:00 AM   Width 3ft   5991438.54417 2088636.90192 37.714507218415 -122.47150190860901 (37.714507218415, -122.471501908609)
1556 1556 251583 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 75 Rice St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5995352.0 2086409.0 37.7086155444167 -122.45781440192499 (37.7086155444167, -122.457814401925)
1828 1828 35192 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
1869 1869 35202 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
1878 1878 251764 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 187 Seville St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 6ft   6001178.343719999 2087386.3168 37.7116320444605 -122.43774780171302 (37.7116320444605, -122.437747801713)
2080 2080 34119 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37980          
2480 2480 253100 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 501x Tompkins Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6008413.0 2096458.0 37.736949681186296 -122.41338394609 (37.7369496811863, -122.41338394609)
2749 2749 253209 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1129 Naples St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001432.0 2087854.0 37.712930619101 -122.43690455890899 (37.712930619101, -122.436904558909)
2849 2849 253236 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 101 Paloma Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2862 2862 253241 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 101 Paloma Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2866 2866 253244 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 299X Moncada Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2884 2884 253239 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 101 Paloma Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2888 2888 253238 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 101 Paloma Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2901 2901 253237 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 101 Paloma Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2902 2902 253245 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 299X Moncada Way 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
3032 3032 253284 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1711 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5987766.0 2103624.0 37.7554447356639 -122.48529459198 (37.7554447356639, -122.48529459198)
3062 3062 34116 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37979          
3077 3077 35211 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
3212 3212 34102 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37975          
3420 3420 35199 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
3622 3622 34463 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1521 Ralston Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/15/1997 12:00:00 AM     Permit Number 38201          
3637 3637 253235 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 101 Paloma Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2 Permit Number 780627 5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
3647 3647 253240 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 101 Paloma Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2 Permit Number 780627 5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
3654 3654 253242 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 299X Moncada Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2 Permit Number 780627 5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
3663 3663 36860 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
3679 3679 253243 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 299X Moncada Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2 Permit Number 780627 5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
3723 3723 253167 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1X Brotherhood Way 1 Front Yard : Yard 7 Tree 1 DPW 2                    
5124 5124 56265 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 15 Liberty St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/2006 12:00:00 AM     Permit Number 12391 6006208.27079513 2104027.08283356 37.7576086269531 -122.42154409690501 (37.7576086269531, -122.421544096905)
5605 5605 34138 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37987          
5673 5673 46713 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
5690 5690 34100 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37975          
5885 5885 46715 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
6242 6242 35188 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
6282 6282 46717 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
7169 7169 34120 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37980          
7188 7188 34462 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1521 Ralston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/15/1997 12:00:00 AM     Permit Number 38201          
7206 7206 46718 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
7464 7464 35185 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
7694 7694 36863 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
7712 7712 35193 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
8041 8041 46716 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
8802 8802 50777 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47304          
8884 8884 34133 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37986          
9418 9418 34114 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37978          
9430 9430 47039 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 771 Walter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/2002 12:00:00 AM     Permit Number 45031          
9498 9498 36866 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
9542 9542 34136 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37986          
9591 9591 36856 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
9614 9614 36864 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
10129 10129 173878 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 89 Montana St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5995989.0 2089223.0 37.7163787086702 -122.455816142362 (37.7163787086702, -122.455816142362)
10275 10275 32464 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 99x Deming St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/10/1996 12:00:00 AM     Permit Number 36974 5999085.33670349 2105174.9537063 37.7603561904001 -122.446260575093 (37.7603561904001, -122.446260575093)
10854 10854 34134 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37986          
10862 10862 34464 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1521 Ralston Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/15/1997 12:00:00 AM     Permit Number 38201          
10907 10907 34118 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37979          
10955 10955 109923 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 214 state st 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
11057 11057 46152 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2001 12:00:00 AM     Permit Number 44491          
11070 11070 34466 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1521 Ralston Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/15/1997 12:00:00 AM     Permit Number 38201          
11107 11107 34137 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37987          
11262 11262 34121 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37980          
11449 11449 35191 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
11627 11627 88529 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12     Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51479          
11728 11728 35200 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
11762 11762 47040 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 771 Walter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/2002 12:00:00 AM     Permit Number 45031          
12079 12079 46714 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
12275 12275 35186 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
12401 12401 36861 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
12589 12589 34135 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37986          
13016 13016 35189 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
13086 13086 34123 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37981          
13329 13329 60277 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2690 Harrison St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/03/2008 12:00:00 AM   3x3 Permit Number 51145 6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657)
13445 13445 36857 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
13457 13457 36874 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
14227 14227 35184 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
14448 14448 34465 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1521 Ralston Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/15/1997 12:00:00 AM     Permit Number 38201          
14687 14687 35195 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
14730 14730 34101 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37975          
14763 14763 50776 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47304          
14818 14818 35190 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
14890 14890 36859 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
14897 14897 36862 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
15003 15003 34117 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37979          
15057 15057 34122 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37981          
15117 15117 36858 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
15124 15124 35187 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
15510 15510 34461 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1521 Ralston Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/15/1997 12:00:00 AM     Permit Number 38201          
15551 15551 34115 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37978          
15779 15779 50775 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47304          
15869 15869 46153 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2001 12:00:00 AM     Permit Number 44491          
15972 15972 34132 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37986          
16027 16027 35201 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
16469 16469 35182 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
16677 16677 36865 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
16819 16819 34124 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37982          
16829 16829 35194 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
16890 16890 34103 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37975          

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