trees

1,914 rows where qSpecies_id = 45 sorted by Police Districts

✎ 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                        
388 109369 DPW Maintained 1 :: 45 2061 Hyde St 1 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 5x6   6007159.6 2119443.7 37.7999925365465 -122.419347645872 (37.7999925365465, -122.419347645872) 5 1 1 28858 32
466 116275 Undocumented 4 :: 45 700X Greenwich St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
7740 142745 DPW Maintained 1 :: 45 700x COLUMBUS AVE 8 Median : Cutout Tree DPW 1     0 Width 0ft   6009127.5357 2120116.4029 37.8019502507169 -122.412585395041 (37.8019502507169, -122.412585395041) 3 1 10 308 4
9389 66602 DPW Maintained 1 :: 45 1235 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1991 12:00:00 AM 13   Permit Number 29795 6008012.17093 2115828.01912 37.7901127525459 -122.416141207354 (37.7901127525459, -122.416141207354) 13 1 10 28858 21
10228 142720 Undocumented 4 :: 45 1170 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078) 5 1 10 308 23
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
24942 143066 DPW Maintained 1 :: 45 454 GREENWICH ST 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6010650.2813 2120338.1214 37.8026443775605 -122.407331591384 (37.8026443775605, -122.407331591384) 3 1 10 308 23
26512 114567 Permitted Site 7 :: 45 1930 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/2015 12:00:00 AM   3x3   6008702.7 2119505.5 37.8002490116896 -122.414012289596 (37.8002490116896, -122.414012289596) 3 1 10 308 32
28267 142762 DPW Maintained 1 :: 45 400 FILBERT ST 5 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6010787.7026 2120010.8966 37.8017535888682 -122.40683296647 (37.8017535888682, -122.40683296647) 3 1 10 308 23
37319 105121 Undocumented 4 :: 45 721 BEACH ST   Sidewalk: Curb side : Cutout Tree Private 2     9     6006739.7 2121813.5 37.8064757462399 -122.420969011396 (37.8064757462399, -122.420969011396) 5 1 1 28858 32
37431 143024 DPW Maintained 1 :: 45 455 STOCKTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6009921.899 2120677.5714 37.8035356299689 -122.409876147779 (37.8035356299689, -122.409876147779) 3 1 10 308 23
40034 116284 Undocumented 4 :: 45 700X Greenwich St 11 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
45114 109367 DPW Maintained 1 :: 45 1205 Filbert St 4 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 4.5x6.5   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
45772 110159 Permitted Site 7 :: 45 1041 Broadway 5 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 55966 6008597.3 2118278.8 37.7968748776387 -122.414290174718 (37.7968748776387, -122.414290174718) 5 1 10 308 21
46675 34454 DPW Maintained 1 :: 45 881 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM 14   Permit Number 38198 6008682.26912 2120023.63237 37.8016705265302 -122.414119665415 (37.8016705265302, -122.414119665415) 3 1 10 308 32
46922 129089 DPW Maintained 1 :: 45 190 Lombard St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   6011405.84379 2120790.43469 37.8039285776094 -122.404748812406 (37.8039285776094, -122.404748812406) 3 1 10 28860 6
47978 116279 Undocumented 4 :: 45 700X Greenwich St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
48387 116276 Undocumented 4 :: 45 700X Greenwich St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
52218 129090 DPW Maintained 1 :: 45 190 Lombard St 4 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   6011386.68599 2120789.41334 37.8039247024384 -122.404815037597 (37.8039247024384, -122.404815037597) 3 1 10 28860 6
64175 109535 DPW Maintained 1 :: 45 1234 Filbert St 3 Sidewalk: Property side : Cutout Landscaping Private 2 FUF 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.8001572481983 -122.419877066677 (37.8001572481983, -122.419877066677) 5 1 1 28858 32
66039 109366 DPW Maintained 1 :: 45 1205 Filbert St 3 Sidewalk: Property side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 3.125x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
67611 129086 DPW Maintained 1 :: 45 1201 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008124.6291 2115843.7412 37.7901622440508 -122.415753223646 (37.7901622440508, -122.415753223646) 13 1 10 28858 21
78553 109534 DPW Maintained 1 :: 45 1234 Filbert St 2 Sidewalk: Property side : Cutout Landscaping Private 2 FUF 02/23/2015 12:00:00 AM 3 1.5x2.6   6007007.9 2119506.8 37.8001572481983 -122.419877066677 (37.8001572481983, -122.419877066677) 5 1 1 28858 32
80565 142716 DPW Maintained 1 :: 45 1120 COLUMBUS AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6008073.8404 2121121.2819 37.804650203273 -122.416302902461 (37.804650203273, -122.416302902461) 5 1 10 308 23
83206 142497 DPW Maintained 1 :: 45 555 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6009877.0468 2119393.2664 37.8000067321588 -122.409940644619 (37.8000067321588, -122.409940644619) 3 1 10 308 4
84295 142574 DPW Maintained 1 :: 45 2201 MASON ST 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6008922.4097 2120888.3705 37.8040583666059 -122.413349854276 (37.8040583666059, -122.413349854276) 3 1 10 308 23
84558 142532 DPW Maintained 1 :: 45 2100 POWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6009454.2526 2120892.9113 37.8041006803451 -122.411509688684 (37.8041006803451, -122.411509688684) 3 1 10 308 23
85790 66597 DPW Maintained 1 :: 45 1201 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1991 12:00:00 AM 14   Permit Number 29790 6008070.41503 2115836.67012 37.7901397807808 -122.415940299715 (37.7901397807808, -122.415940299715) 13 1 10 28858 21
94093 116283 Undocumented 4 :: 45 700X Greenwich St 10 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
108038 142538 DPW Maintained 1 :: 45 2100 POWELL ST 7 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6009433.1509 2121013.8406 37.8044315384071 -122.4115912622 (37.8044315384071, -122.4115912622) 3 1 10 308 23
109200 116282 Undocumented 4 :: 45 700X Greenwich St 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
112711 143063 DPW Maintained 1 :: 45 454 GREENWICH ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6010670.2258 2120340.5284 37.8026521028281 -122.407262742811 (37.8026521028281, -122.407262742811) 3 1 10 308 23
114942 142482 DPW Maintained 1 :: 45 1501 GRANT AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6010536.0572 2119686.9897 37.8008501363872 -122.407680928456 (37.8008501363872, -122.407680928456) 3 1 10 308 23
116983 49797 DPW Maintained 1 :: 45 1145 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1991 12:00:00 AM 13 3x3 Permit Number 46589 6008423.57277 2115887.46945 37.7902991118549 -122.41472199442 (37.7902991118549, -122.41472199442) 5 1 10 28858 21
123221 109536 DPW Maintained 1 :: 45 1234 Filbert St 4 Sidewalk: Property side : Cutout Landscaping Private 2 FUF 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.8001572481983 -122.419877066677 (37.8001572481983, -122.419877066677) 5 1 1 28858 32
123405 143326 DPW Maintained 1 :: 45 771 BROADWAY 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6009948.2831 2118449.9038 37.7974204821659 -122.409627518494 (37.7974204821659, -122.409627518494) 3 1 10 308 4
133404 116281 Undocumented 4 :: 45 700X Greenwich St 8 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
134703 129088 DPW Maintained 1 :: 45 190 Lombard St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   6011425.38411 2120792.86026 37.8039363297663 -122.40468136238 (37.8039363297663, -122.40468136238) 3 1 10 28860 6
139953 143072 Undocumented 4 :: 45 644 GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6009782.327 2120221.5354 37.8022756451991 -122.410326926401 (37.8022756451991, -122.410326926401) 3 1 10 308 23
139982 142533 DPW Maintained 1 :: 45 2100 POWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6009449.383 2120911.5782 37.8041516618577 -122.411527859992 (37.8041516618577, -122.411527859992) 3 1 10 308 23
141371 129087 DPW Maintained 1 :: 45 190 Lombard St 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   6011445.1234 2120796.34037 37.8039469885131 -122.404613298068 (37.8039469885131, -122.404613298068) 3 1 10 28860 6
143343 109370 DPW Maintained 1 :: 45 2061 Hyde St 2 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 13x6   6007159.6 2119443.7 37.7999925365465 -122.419347645872 (37.7999925365465, -122.419347645872) 5 1 1 28858 32
151350 143062 DPW Maintained 1 :: 45 454 GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6010688.107 2120341.9039 37.802656880339 -122.407200961563 (37.802656880339, -122.407200961563) 3 1 10 308 23
152658 109368 DPW Maintained 1 :: 45 1205 Filbert St 5 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 3x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
154649 109365 DPW Maintained 1 :: 45 1205 Filbert St 2 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 4.5x16   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
158643 142539 DPW Maintained 1 :: 45 2100 POWELL ST 8 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6009429.9045 2121027.6379 37.8044692402487 -122.411603472126 (37.8044692402487, -122.411603472126) 3 1 10 308 23
162141 143061 DPW Maintained 1 :: 45 448 GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6010702.5496 2120345.6865 37.8026680746888 -122.407151249431 (37.8026680746888, -122.407151249431) 3 1 10 308 23
166540 109364 DPW Maintained 1 :: 45 1205 Filbert St 1 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 4.5x6   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
166962 116277 Undocumented 4 :: 45 700X Greenwich St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
169115 142535 DPW Maintained 1 :: 45 2100 POWELL ST 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6009442.0785 2120948.1005 37.8042515332642 -122.411555719808 (37.8042515332642, -122.411555719808) 3 1 10 308 23
172525 116278 Undocumented 4 :: 45 700X Greenwich St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
176046 142991 DPW Maintained 1 :: 45 1847 GRANT AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6010381.3657 2120852.2682 37.8040410433015 -122.408298464224 (37.8040410433015, -122.408298464224) 3 1 10 308 23
179164 116280 Undocumented 4 :: 45 700X Greenwich St 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
183044 116274 Undocumented 4 :: 45 700X Greenwich St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
191889 143026 DPW Maintained 1 :: 45 2027 POWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6009443.5652 2120635.2508 37.8033926093321 -122.411528458224 (37.8033926093321, -122.411528458224) 3 1 10 308 23
193926 129085 DPW Maintained 1 :: 45 1201 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008098.74192 2115839.1342 37.790148139064 -122.415842465177 (37.790148139064, -122.415842465177) 13 1 10 28858 21
373 200940 DPW Maintained 1 :: 45 1515 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6008432.2434 2109068.8895 37.7715774111529 -122.414209373869 (37.7715774111529, -122.414209373869) 8 2 9 28853 19
8301 114726 Significant Tree 6 :: 45 520 Townsend St 2 Front Yard : Yard Tree Private 2           6012508.1 2109575.3 37.7731959986981 -122.400146236912 (37.7731959986981, -122.400146236912) 14 2 9 28853 34
12997 258944 DPW Maintained 1 :: 45 190 Freelon St 1 Sidewalk: Curb side : Yard Landscaping DPW 1       Width 2ft   6013228 2111376 37.7781804260272 -122.397782321929 (37.7781804260272, -122.397782321929) 6 2 9 28856 34
18457 107144 DPW Maintained 1 :: 45 360 Spear St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   02/12/2020 12:00:00 AM 3     6015708 2115219 37.7888702311939 -122.38947147438 (37.7888702311939, -122.38947147438) 6 2 9 28855 6
25068 246384 DPW Maintained 1 :: 45 1655 Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6006982.6308 2109153.3972 37.7717279173795 -122.419229672629 (37.7717279173795, -122.419229672629) 8 2 9 28853 19
26337 201234 DPW Maintained 1 :: 45 795 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6012343.1682 2112809.9895 37.7820685155731 -122.400944074647 (37.7820685155731, -122.400944074647) 6 2 9 28856 34
29308 190674 DPW Maintained 1 :: 45 446 Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6010985.96747 2112156.82627 37.7801992828204 -122.405593378352 (37.7801992828204, -122.405593378352) 14 2 9 28853 34
30304 190664 DPW Maintained 1 :: 45 153 Freelon St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6013137.75359 2111279.19954 37.7779096079765 -122.398087726493 (37.7779096079765, -122.398087726493) 6 2 9 28856 34
33531 228505 DPW Maintained 1 :: 45 74 Brady St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006699.63588 2109500.73575 37.7726656844924 -122.420233227899 (37.7726656844924, -122.420233227899) 8 2 9 28853 19
39375 246383 DPW Maintained 1 :: 45 1655 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6006970.497 2109128.1185 37.771657824727 -122.419269850794 (37.771657824727, -122.419269850794) 8 2 9 28853 19
40092 228506 DPW Maintained 1 :: 45 74 Brady St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006728.21542 2109473.21902 37.7725917404536 -122.420132414803 (37.7725917404536, -122.420132414803) 8 2 9 28853 19
47890 190672 DPW Maintained 1 :: 45 149 Freelon St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6013276.0134 2111408.93876 37.7782735420174 -122.39761853578 (37.7782735420174, -122.39761853578) 6 2 9 28856 34
52401 190666 DPW Maintained 1 :: 45 153 Freelon St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6013164.18283 2111305.08822 37.7779821643861 -122.397998114425 (37.7779821643861, -122.397998114425) 6 2 9 28856 34
59015 190673 DPW Maintained 1 :: 45 149 Freelon St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6013287.80421 2111419.18552 37.7783023338298 -122.397578465593 (37.7783023338298, -122.397578465593) 6 2 9 28856 34

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