trees

1,914 rows where qSpecies_id = 45 sorted by Zip Codes

✎ View and edit SQL

This data as json, CSV (advanced)

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)
87 259654 DPW Maintained 1 :: 45 101x Cora St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
88 259653 DPW Maintained 1 :: 45 99x Cora St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
89 259623 DPW Maintained 1 :: 45 1498x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
94 260654 Permitted Site 7 :: 45 2590 Buchanan St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   10/03/2019 12:00:00 AM 3 3.5x3                      
103 253831 DPW Maintained 1 :: 45 699X Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3                      
2087 261314 Permitted Site 7 :: 45 2601 Divisadero St 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/31/2019 12:00:00 AM 3 6x106                      
2635 259636 DPW Maintained 1 :: 45 98x Arleta Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
3035 259640 DPW Maintained 1 :: 45 198x Arleta Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
4471 259626 DPW Maintained 1 :: 45 1499x Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
4568 253833 DPW Maintained 1 :: 45 607 Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3                      
4944 259613 DPW Maintained 1 :: 45 1000 Visitacion Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
5006 259624 DPW Maintained 1 :: 45 1401x Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
5098 251531 DPW Maintained 1 :: 45 2100X 20th St 2 Sidewalk: Curb side : Cutout Landscaping Private 2   05/15/2017 12:00:00 AM 3 4x11                      
6366 117001 DPW Maintained 1 :: 45 1X Bernal Heights Blvd 1 Front Yard : Yard Tree DPW 1                              
6535 259627 DPW Maintained 1 :: 45 1499x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
8424 261322 Private 9 :: 45 811 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/02/2020 12:00:00 AM 3 3x3                      
10803 259618 DPW Maintained 1 :: 45 1200x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
12379 259619 DPW Maintained 1 :: 45 1200x Visitacion Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
12908 259612 DPW Maintained 1 :: 45 1000 Visitacion Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
14450 259622 DPW Maintained 1 :: 45 1498x Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
14847 259625 DPW Maintained 1 :: 45 1401x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
15760 251532 DPW Maintained 1 :: 45 2100X 20th St 4 Sidewalk: Curb side : Cutout Landscaping Private 2   05/15/2017 12:00:00 AM 3 4x11                      
15847 259635 DPW Maintained 1 :: 45 98x Arleta Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
16880 259621 DPW Maintained 1 :: 45 1398x Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
17295 259617 DPW Maintained 1 :: 45 1200x Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
17929 259649 DPW Maintained 1 :: 45 700 Delta St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
17931 259643 DPW Maintained 1 :: 45 241 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
18667 259652 DPW Maintained 1 :: 45 99x Cora St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
18887 259638 DPW Maintained 1 :: 45 99x Arleta Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
19114 259651 DPW Maintained 1 :: 45 598x Rutland St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
149 244279 Undocumented 4 :: 45 585 Oak St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004230.7823 2110095.842 37.7741602789386 -122.428815691218 (37.7741602789386, -122.428815691218) 7 9 11 28852 10
214 138888 DPW Maintained 1 :: 45 675 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004166.2354 2110619.5066 37.7755944800015 -122.429076315191 (37.7755944800015, -122.429076315191) 7 9 11 28852 10
320 228444 DPW Maintained 1 :: 45 399 Haight St 1 : Tree Private 2     4 Width 3ft   6004268.91864 2109406.82097 37.7722705538615 -122.428634644993 (37.7722705538615, -122.428634644993) 7 9 11 28852 10
803 105089 Significant Tree 6 :: 45 344 Fulton St 9 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
2959 141420 DPW Maintained 1 :: 45 550 IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004578.5445 2111046.5078 37.7767902513835 -122.427680466931 (37.7767902513835, -122.427680466931) 7 9 11 28852 10
3549 141425 DPW Maintained 1 :: 45 301 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005907.6073 2110863.9151 37.7763639855674 -122.423069853164 (37.7763639855674, -122.423069853164) 7 9 11 28852 10
5583 244247 Undocumented 4 :: 45 200 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005673.0642 2110022.689 37.7740409443959 -122.423821374378 (37.7740409443959, -122.423821374378) 7 9 11 28852 10
7226 139441 DPW Maintained 1 :: 45 501 GROVE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005361.8674 2111299.9206 37.7775303390293 -122.424988750303 (37.7775303390293, -122.424988750303) 7 9 11 28852 10
15911 105081 Significant Tree 6 :: 45 344 Fulton St 1 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
17108 105086 Significant Tree 6 :: 45 344 Fulton St 6 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
21621 37520 Permitted Site 7 :: 45 649 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39973 6008796.59183246 2114756.17350418 37.7872137988014 -122.413351333091 (37.7872137988014, -122.413351333091) 5 1 10 28852 36
27887 140046 DPW Maintained 1 :: 45 666 OCTAVIA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005395.2334 2111605.7927 37.7783720737797 -122.424895092854 (37.7783720737797, -122.424895092854) 7 9 11 28852 10
30541 253834 DPW Maintained 1 :: 45 747 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3   6006860.78535 2113242.76542 37.7829494746502 -122.419941385136 (37.7829494746502, -122.419941385136) 7 9 9 28852 36
31946 245835 Undocumented 4 :: 45 451 Fell St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005269.6444 2110584.5711 37.7755609539167 -122.4252568647 (37.7755609539167, -122.4252568647) 7 9 11 28852 10
32819 142271 DPW Maintained 1 :: 45 556 FELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004757.9319 2110570.0874 37.7754922630352 -122.427025971185 (37.7754922630352, -122.427025971185) 7 9 11 28852 10
33264 138887 DPW Maintained 1 :: 45 679 LINDEN ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004146.8152 2110617.8324 37.7755887837316 -122.429143374995 (37.7755887837316, -122.429143374995) 7 9 11 28852 10
38066 139933 DPW Maintained 1 :: 45 800 GOUGH ST 7 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005708.0541 2112525.3709 37.7809146750444 -122.42387833426 (37.7809146750444, -122.42387833426) 7 9 11 28852 41
45444 10257 DPW Maintained 1 :: 45 155 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/21/2006 12:00:00 AM 6 3X3   6005354.14588 2109555.43017 37.7727399559066 -122.424891318606 (37.7727399559066, -122.424891318606) 7 9 11 28852 10
48617 228447 DPW Maintained 1 :: 45 365 Haight St 1 : Tree Private 2     4 Width 3ft   6004400.01174 2109424.00964 37.7723251679145 -122.428182407399 (37.7723251679145, -122.428182407399) 7 9 11 28852 10
51930 244131 DPW Maintained 1 :: 45 322 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6004550.5333 2109497.9798 37.7725367873822 -122.42766701053 (37.7725367873822, -122.42766701053) 7 9 11 28852 10
55119 43025 Permitted Site 7 :: 45 430 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM     Permit Number 42886 6004125.6708626 2110297.9605007 37.774709297051 -122.429193705112 (37.774709297051, -122.429193705112) 7 9 11 28852 10
57150 10247 DPW Maintained 1 :: 45 112 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/29/1997 12:00:00 AM 8 3X3   6005536.2501 2109637.4907 37.7729755585516 -122.424267236647 (37.7729755585516, -122.424267236647) 7 9 11 28852 10
57155 228475 DPW Maintained 1 :: 45 214 Haight St 5 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6004951.6216 2109548.73886 37.772698838907 -122.426283219097 (37.772698838907, -122.426283219097) 7 9 11 28852 10
66626 30705 Permitted Site 7 :: 45 371 Oak St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM     Permit Number 34615 6005225.74804899 2110232.43831944 37.7745916029272 -122.425383648395 (37.7745916029272, -122.425383648395) 7 9 11 28852 10
72367 141411 DPW Maintained 1 :: 45 530 IVY ST 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004748.0909 2111070.6139 37.776866029845 -122.427095672306 (37.776866029845, -122.427095672306) 7 9 11 28852 10
73450 244942 DPW Maintained 1 :: 45 200 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005544.3019 2109980.4712 37.7739177547615 -122.424263782503 (37.7739177547615, -122.424263782503) 7 9 11 28852 10
75459 105084 Significant Tree 6 :: 45 344 Fulton St 4 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
76428 244138 DPW Maintained 1 :: 45 398 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004318.4145 2109467.7034 37.7724405231997 -122.428467774696 (37.7724405231997, -122.428467774696) 7 9 11 28852 10
77535 142228 DPW Maintained 1 :: 45 550 LINDEN ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004723.2776 2110721.388 37.7759057378537 -122.42715662811 (37.7759057378537, -122.42715662811) 7 9 11 28852 10
79764 141421 DPW Maintained 1 :: 45 550 IVY ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004561.2684 2111044.0972 37.7767826552211 -122.427740058355 (37.7767826552211, -122.427740058355) 7 9 11 28852 10
80835 10233 DPW Maintained 1 :: 45 20 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6005984.609 2109698.904 37.77316949126 -122.422720671561 (37.77316949126, -122.422720671561) 7 9 11 28852 10
91093 105091 Significant Tree 6 :: 45 344 Fulton St 11 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
93102 139926 DPW Maintained 1 :: 45 1001 TURK ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005215.378 2112666.1069 37.7812732756423 -122.425592763682 (37.7812732756423, -122.425592763682) 7 9 11 28852 41
94117 139809 DPW Maintained 1 :: 45 1101 GOUGH ST 9 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005660.0139 2112868.3262 37.7818536339515 -122.424068925498 (37.7818536339515, -122.424068925498) 7 9 11 28852 41
96905 139987 DPW Maintained 1 :: 45 420 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005805.8873 2111752.6705 37.7787985511404 -122.423484930759 (37.7787985511404, -122.423484930759) 7 9 11 28852 41
100085 141426 DPW Maintained 1 :: 45 305 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005885.4207 2110859.7551 37.776351311196 -122.423146307153 (37.776351311196, -122.423146307153) 7 9 11 28852 10
105130 138962 DPW Maintained 1 :: 45 659 IVY ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004224.8748 2110974.4556 37.7765724019201 -122.428898778329 (37.7765724019201, -122.428898778329) 7 9 11 28852 10
107132 30692 DPW Maintained 1 :: 45 20 Haight St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2009 12:00:00 AM 3 3x3 Permit Number 52599 6005954.788 2109697.461 37.7731638465829 -122.422823723873 (37.7731638465829, -122.422823723873) 7 9 11 28852 10
107591 117608 DPW Maintained 1 :: 45 450 Hayes St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   06/29/2016 12:00:00 AM 3     6005708.4 2111040.6 37.776837876057 -122.423771533631 (37.776837876057, -122.423771533631) 7 9 11 28852 10
109054 244127 DPW Maintained 1 :: 45 398 Haight St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6004270.549 2109462.5132 37.7724235634161 -122.428632976075 (37.7724235634161, -122.428632976075) 7 9 11 28852 10
109663 228474 DPW Maintained 1 :: 45 214 Haight St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004967.29881 2109550.52085 37.7727046179541 -122.426229116776 (37.7727046179541, -122.426229116776) 7 9 11 28852 10
110848 141404 DPW Maintained 1 :: 45 500 IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004912.0126 2111093.9165 37.7769392812182 -122.426530276832 (37.7769392812182, -122.426530276832) 7 9 11 28852 10
112698 244966 DPW Maintained 1 :: 45 250 Lily St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005265.6412 2110100.505 37.7742315998648 -122.425236259934 (37.7742315998648, -122.425236259934) 7 9 11 28852 10
117031 228446 DPW Maintained 1 :: 45 379 Haight St 1 : Tree Private 2     5 Width 5ft   6004344.90177 2109415.20014 37.7722978608825 -122.428372409862 (37.7722978608825, -122.428372409862) 7 9 11 28852 10
119097 43024 Permitted Site 7 :: 45 430 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM     Permit Number 42886 6004125.6708626 2110297.9605007 37.774709297051 -122.429193705112 (37.774709297051, -122.429193705112) 7 9 11 28852 10
120025 138897 DPW Maintained 1 :: 45 620 Linden St 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004450.0046 2110683.2919 37.7757856778871 -122.428099234722 (37.7757856778871, -122.428099234722) 7 9 11 28852 10
121332 141428 DPW Maintained 1 :: 45 321 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005839.6607 2110854.2085 37.7763334991213 -122.423304209584 (37.7763334991213, -122.423304209584) 7 9 11 28852 10
126121 119616 DPW Maintained 1 :: 45 400 Grove St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   07/28/2016 12:00:00 AM 3     6005873.69691 2111410.56393 37.7778630368848 -122.423226025705 (37.7778630368848, -122.423226025705) 7 9 11 28852 10
126537 105082 Significant Tree 6 :: 45 344 Fulton St 2 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
128919 139442 DPW Maintained 1 :: 45 501 GROVE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005371.2943 2111301.0083 37.7775338580762 -122.424956216884 (37.7775338580762, -122.424956216884) 7 9 11 28852 10
133179 141407 DPW Maintained 1 :: 45 502 IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004806.3474 2111079.0511 37.7768924904658 -122.426894746357 (37.7768924904658, -122.426894746357) 7 9 11 28852 10
135576 244963 DPW Maintained 1 :: 45 250 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005299.6761 2110107.1904 37.7742518790539 -122.425119002762 (37.7742518790539, -122.425119002762) 7 9 11 28852 10
136026 139988 DPW Maintained 1 :: 45 420 FULTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005784.2761 2111750.2147 37.7787905883012 -122.423559517841 (37.7787905883012, -122.423559517841) 7 9 11 28852 41
141547 139980 DPW Maintained 1 :: 45 755 MCALLISTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005557.6295 2112012.432 37.7794977773155 -122.424362233576 (37.7794977773155, -122.424362233576) 7 9 11 28852 41
143028 228448 DPW Maintained 1 :: 45 353 Haight St 1 : Tree Private 2     4 Width 3ft   6004452.39919 2109432.87501 37.7723524740195 -122.42800182623 (37.7723524740195, -122.42800182623) 7 9 11 28852 10
145102 105085 Significant Tree 6 :: 45 344 Fulton St 5 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
145345 228445 DPW Maintained 1 :: 45 391 Haight St 1 : Tree Private 2     6 Width 3ft   6004290.10245 2109410.45263 37.7722817243588 -122.428561627213 (37.7722817243588, -122.428561627213) 7 9 11 28852 10
146174 108618 Undocumented 4 :: 45 150-198X Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2           6005405 2109611 37.7728954095296 -122.424719362301 (37.7728954095296, -122.424719362301) 7 9 11 28852 10
152913 142256 DPW Maintained 1 :: 45 436 FELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005308.393 2110647.6947 37.7757364649691 -122.425127316281 (37.7757364649691, -122.425127316281) 7 9 11 28852 10
154153 105087 Significant Tree 6 :: 45 344 Fulton St 7 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
157270 228473 DPW Maintained 1 :: 45 214 Haight St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6004983.40723 2109552.71485 37.7727115526285 -122.426173552181 (37.7727115526285, -122.426173552181) 7 9 11 28852 10
161677 105090 Significant Tree 6 :: 45 344 Fulton St 10 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
164946 244368 DPW Maintained 1 :: 45 301 Octavia St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005522.1928 2110360.9128 37.7749611068256 -122.424367326274 (37.7749611068256, -122.424367326274) 7 9 11 28852 10
167444 105083 Significant Tree 6 :: 45 344 Fulton St 3 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
169612 138821 DPW Maintained 1 :: 45 745 BUCHANAN ST 2 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   6004449.5065 2111116.3546 37.7769747335922 -122.428131826933 (37.7769747335922, -122.428131826933) 7 9 11 28852 10
169927 244447 DPW Maintained 1 :: 45 418 Rose St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004438.1156 2109646.5981 37.772938497462 -122.428066467687 (37.772938497462, -122.428066467687) 7 9 11 28852 10
174466 138928 DPW Maintained 1 :: 45 658 IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004198.4672 2110994.6791 37.7766264359363 -122.428991572071 (37.7766264359363, -122.428991572071) 7 9 11 28852 10
176612 141409 DPW Maintained 1 :: 45 530 IVY ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004778.2236 2111075.0334 37.7768798686174 -122.426991748962 (37.7768798686174, -122.426991748962) 7 9 11 28852 10
178313 244976 DPW Maintained 1 :: 45 201 Rose St 8 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005594.1388 2109777.4773 37.7733631964969 -122.42407694939 (37.7733631964969, -122.42407694939) 7 9 11 28852 10
186789 105088 Significant Tree 6 :: 45 344 Fulton St 8 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10

Next page

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)
);