trees

1,914 rows where qSpecies_id = 45 sorted by Supervisor 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                        
120 141225 DPW Maintained 1 :: 45 3 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5996479.075 2114520.1031 37.7858663452689 -122.455949967769 (37.7858663452689, -122.455949967769) 11 6 1 54 31
179 113995 DPW Maintained 1 :: 45 3221 Washington St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   10/27/2015 12:00:00 AM   39x3   5999265.7 2115942.6 37.789931692457 -122.446411428366 (37.789931692457, -122.446411428366) 13 6 1 29490 31
192 137920 DPW Maintained 1 :: 45 2028 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6002940.7431 2115305.2702 37.7883909617368 -122.433650548643 (37.7883909617368, -122.433650548643) 13 9 1 29490 27
258 139105 DPW Maintained 1 :: 45 1310 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5999792.0294 2113376.32 37.7829154028675 -122.444405875371 (37.7829154028675, -122.444405875371) 15 6 1 29490 31
386 143336 DPW Maintained 1 :: 45 1858 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004106.6848 2118733.7418 37.797870758582 -122.429861223474 (37.797870758582, -122.429861223474) 13 9 1 57 17
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
397 253904 DPW Maintained 1 :: 45 3637 Sacramento St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5997456 2115038 37.7873443747179 -122.4526074861 (37.7873443747179, -122.4526074861) 11 6 1 54 31
532 261313 Permitted Site 7 :: 45 2700 Broadway 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/31/2019 12:00:00 AM 3 6x40   6000687.88763 2117206.96839 37.7934844433083 -122.441581569821 (37.7934844433083, -122.441581569821) 13 9 1 57 27
1416 109762 DPW Maintained 1 :: 45 1801 Scott St 1 Sidewalk: Property side : Cutout Landscaping Private 2       1.5x6.5   6001511.7 2114646.3 37.7865004107291 -122.438547564751 (37.7865004107291, -122.438547564751) 13 6 1 29490 27
3262 143122 DPW Maintained 1 :: 45 1965 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6003008.0203 2119542.9474 37.8000303489096 -122.433720773421 (37.8000303489096, -122.433720773421) 13 9 1 57 17
7664 261543 Permitted Site 7 :: 45 1305 Lombard St 2 Sidewalk: Property side : Cutout Landscaping Private 2   01/17/2020 12:00:00 AM 3 20x5   6006114.74348 2120010.24127 37.8014892121583 -122.423003541085 (37.8014892121583, -122.423003541085) 13 9 1 28858 32
8883 261542 Permitted Site 7 :: 45 1305 Lombard St 1 Sidewalk: Property side : Cutout Landscaping Private 2   01/17/2020 12:00:00 AM 3 10x5   6006114.74348 2120010.24127 37.8014892121583 -122.423003541085 (37.8014892121583, -122.423003541085) 13 9 1 28858 32
12753 253419 Planning Code 138.1 required 2 :: 45 3499 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997570 2115996 37.7899813188913 -122.452282225129 (37.7899813188913, -122.452282225129) 11 6 1 54 31
12777 137758 DPW Maintained 1 :: 45 101 Saint Joseph's Ave 19 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000707.9938 2112291.934 37.7799901751967 -122.441159201538 (37.7799901751967, -122.441159201538) 15 5 1 29490 16
15771 259520 Private 9 :: 45 190 Parker Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2019 12:00:00 AM 3     5996965.93026 2113053.17261 37.7818664738231 -122.454159603161 (37.7818664738231, -122.454159603161) 11 6 1 54 31
17116 138648 DPW Maintained 1 :: 45 600 PRESIDIO AVE 5 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5999215.949 2114570.5132 37.7861614604528 -122.446484808381 (37.7861614604528, -122.446484808381) 15 6 1 29490 31
18444 259521 Private 9 :: 45 190 Parker Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2019 12:00:00 AM 3     5996965.93026 2113053.17261 37.7818664738231 -122.454159603161 (37.7818664738231, -122.454159603161) 11 6 1 54 31
22031 254088 DPW Maintained 1 :: 45 2520 Broadway 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/22/2017 12:00:00 AM 3 3.5x4.9   6001556.59478 2117325.5311 37.7938594403451 -122.438584281493 (37.7938594403451, -122.438584281493) 13 9 1 57 27
22093 254089 DPW Maintained 1 :: 45 2520 Broadway 2 Sidewalk: Property side : Cutout Landscaping Private 2   12/22/2017 12:00:00 AM 3 5x4.9   6001556.59478 2117325.5311 37.7938594403451 -122.438584281493 (37.7938594403451, -122.438584281493) 13 9 1 57 27
26240 115259 DPW Maintained 1 :: 45 2130 Jackson St   Sidewalk: Curb side : Cutout Landscaping Private 2   01/21/2016 12:00:00 AM   6x12   6003918.8 2117004 37.7931106894063 -122.430387878845 (37.7931106894063, -122.430387878845) 13 9 1 29490 27
29616 140863 DPW Maintained 1 :: 45 106 JORDAN AVE 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5996246.41 2113718.2127 37.7836512118011 -122.456696904969 (37.7836512118011, -122.456696904969) 11 6 1 54 31
30863 95250 DPW Maintained 1 :: 45 57 Avila St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/2011 12:00:00 AM 4 3x3 Permit Number 767151 6001050.95383 2119955.94053 37.8010530753849 -122.440522591565 (37.8010530753849, -122.440522591565) 13 9 1 57 17
36178 108990 Undocumented 4 :: 45 2073-2099X Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501) 13 9 1 57 17
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
41043 255920 Permitted Site 7 :: 45 3990 Washington St 4 Side Yard : Yard Tree Private 2   08/03/2018 12:00:00 AM 3     5995569.1162 2115494.21463 37.7884887239215 -122.459168714213 (37.7884887239215, -122.459168714213) 11 6 1 54 31
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
53078 255962 Permitted Site 7 :: 45 2518 Buchanan St 2 Sidewalk: Curb side : Cutout Landscaping Private 2   08/08/2018 12:00:00 AM 3 5x7   6003674.59495 2116996.308 37.7930757331753 -122.431232293197 (37.7930757331753, -122.431232293197) 13 9 1 29490 27
55750 143238 DPW Maintained 1 :: 45 1734 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004092.1528 2119775.7189 37.8007309359716 -122.429985874998 (37.8007309359716, -122.429985874998) 13 9 1 57 17
56508 113997 DPW Maintained 1 :: 45 58 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5989321.8 2114884.9 37.7864545841357 -122.480738581989 (37.7864545841357, -122.480738581989) 11 6 1 55 33
59373 109769 DPW Maintained 1 :: 45 2502X Bush St 2 Sidewalk: Property side : Cutout Landscaping Private 2       1.5x12.75   6001313.62368 2114572.17699 37.7862856185892 -122.439227543381 (37.7862856185892, -122.439227543381) 13 6 1 29490 27
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
67891 255961 Permitted Site 7 :: 45 2518 Buchanan St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   08/08/2018 12:00:00 AM 3 5x7   6003674.59495 2116996.308 37.7930757331753 -122.431232293197 (37.7930757331753, -122.431232293197) 13 9 1 29490 27
71605 109344 DPW Maintained 1 :: 45 3211 Baker St 3 Sidewalk: Property side : Yard Landscaping Private 2   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385) 13 9 1 57 17
73574 141003 DPW Maintained 1 :: 45 166 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5996581.6168 2113251.3598 37.7823885984174 -122.455503470264 (37.7823885984174, -122.455503470264) 11 6 1 54 31
75690 141030 DPW Maintained 1 :: 45 2 Masonic Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5998905.3901 2112810.7346 37.7813118242763 -122.447432543811 (37.7813118242763, -122.447432543811) 15 5 1 54 16
77837 114785 Permitted Site 7 :: 45 2459 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/2015 12:00:00 AM       6000398.9 2113706 37.7838552262656 -122.442330036457 (37.7838552262656, -122.442330036457) 15 6 1 29490 13
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
79210 109345 DPW Maintained 1 :: 45 3211 Baker St 4 Sidewalk: Property side : Yard Landscaping Private 2   02/11/2015 12:00:00 AM 3 8.75x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385) 13 9 1 57 17
79490 137739 DPW Maintained 1 :: 45 101 Saint Joseph's Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000676.859 2112512.2466 37.7805933238275 -122.441282722586 (37.7805933238275, -122.441282722586) 15 5 1 29490 16
79912 254090 DPW Maintained 1 :: 45 2520 Broadway 3 Sidewalk: Property side : Cutout Landscaping Private 2   12/22/2017 12:00:00 AM 3 1.75x4.9   6001556.59478 2117325.5311 37.7938594403451 -122.438584281493 (37.7938594403451, -122.438584281493) 13 9 1 57 27
82433 109343 DPW Maintained 1 :: 45 3211 Baker St 2 Sidewalk: Property side : Yard Landscaping Private 2   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385) 13 9 1 57 17
87032 137836 DPW Maintained 1 :: 45 2275 CALIFORNIA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6003502.6074 2115546.0928 37.7890840639569 -122.431723790267 (37.7890840639569, -122.431723790267) 13 9 1 29490 27
87596 137740 DPW Maintained 1 :: 45 101 Saint Joseph's Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000679.5664 2112493.295 37.7805414418009 -122.441271996241 (37.7805414418009, -122.441271996241) 15 5 1 29490 16
87646 138623 DPW Maintained 1 :: 45 2580 BUSH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6001132.7512 2114573.2069 37.7862781523948 -122.439853387833 (37.7862781523948, -122.439853387833) 13 6 1 29490 27
88682 108989 Undocumented 4 :: 45 2073-2099X Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501) 13 9 1 57 17
104455 255919 Permitted Site 7 :: 45 3990 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2018 12:00:00 AM 3     5995569.1162 2115494.21463 37.7884887239215 -122.459168714213 (37.7884887239215, -122.459168714213) 11 6 1 54 31
105257 78131 DPW Maintained 1 :: 45 2040 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/2010 12:00:00 AM 6 3x3 Permit Number 53996 6000457.66404 2121004.4785 37.8038982794373 -122.442650952296 (37.8038982794373, -122.442650952296) 13 9 1 57 17
107574 140085 DPW Maintained 1 :: 45 220 Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000673.3902 2112844.9998 37.7815067814228 -122.441318605518 (37.7815067814228, -122.441318605518) 15 5 1 29490 41
110859 109342 DPW Maintained 1 :: 45 3211 Baker St 1 Sidewalk: Property side : Yard Landscaping Private 2   02/11/2015 12:00:00 AM 3 1x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385) 13 9 1 57 17
110973 138614 DPW Maintained 1 :: 45 2605 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6001446.0479 2114908.9608 37.7872178749778 -122.438793533195 (37.7872178749778, -122.438793533195) 13 6 1 29490 27
113379 108992 Undocumented 4 :: 45 2073-2099X Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501) 13 9 1 57 17
118904 138698 DPW Maintained 1 :: 45 1600 BAKER ST 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000125.4805 2114462.3047 37.7859162558141 -122.443330304354 (37.7859162558141, -122.443330304354) 15 6 1 29490 27
120615 113719 Undocumented 4 :: 45 1705 BRODERICK ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000536 2114563 37.7862161402131 -122.441917253951 (37.7862161402131, -122.441917253951) 13 6 1 29490 27
122321 113996 DPW Maintained 1 :: 45 58 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5989321.8 2114884.9 37.7864545841357 -122.480738581989 (37.7864545841357, -122.480738581989) 11 6 1 55 33
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
126891 143541 DPW Maintained 1 :: 45 2145 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6002743.898 2118498.8394 37.7971485097359 -122.434560038838 (37.7971485097359, -122.434560038838) 13 9 1 57 17
127177 115258 DPW Maintained 1 :: 45 2150 Jackson St   : Cutout Landscaping Private 2   01/21/2016 12:00:00 AM   6x12   6003858 2116995.5 37.7930839063862 -122.430597643601 (37.7930839063862, -122.430597643601) 13 9 1 29490 27
128768 108370 DPW Maintained 1 :: 45 823 Euclid Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/11/2015 12:00:00 AM 3 3x3 Permit Number 774572 5995757.23416 2113775.59974 37.783780682228 -122.458393411251 (37.783780682228, -122.458393411251) 11 6 1 54 31
131471 7948 DPW Maintained 1 :: 45 1701 Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2014 12:00:00 AM 6 3X3   6005705.32484 2116013.75926 37.790492771869 -122.424135933935 (37.790492771869, -122.424135933935) 13 9 1 28858 27
132183 140786 DPW Maintained 1 :: 45 72 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5996552.5125 2114073.3864 37.784643994956 -122.455663594493 (37.784643994956, -122.455663594493) 11 6 1 54 31
133267 139696 DPW Maintained 1 :: 45 345 Saint Joseph's Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000314.3725 2113207.157 37.7824807138402 -122.442586640867 (37.7824807138402, -122.442586640867) 15 5 1 29490 16
133786 138319 DPW Maintained 1 :: 45 1915 PIERCE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6001944.4165 2115111.5373 37.7878024384193 -122.437083797069 (37.7878024384193, -122.437083797069) 13 6 1 29490 27
135422 123610 DPW Maintained 1 :: 45 135 03rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5994873.21088 2114645.23418 37.7861176222016 -122.461514846643 (37.7861176222016, -122.461514846643) 11 6 1 54 11
136924 149033 DPW Maintained 1 :: 45 3916 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2017 12:00:00 AM 3 5.5x12   5996085.36444 2114918.02173 37.7869363183091 -122.457340885983 (37.7869363183091, -122.457340885983) 11 6 1 54 31
137408 108988 Undocumented 4 :: 45 2073-2099X Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501) 13 9 1 57 17
140904 139551 DPW Maintained 1 :: 45 230 Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000668.9907 2112886.9641 37.7816217540269 -122.441336837605 (37.7816217540269, -122.441336837605) 15 5 1 29490 41
141783 110320 Property Tree 8 :: 45 9 Imperial Aly   Back Yard : Yard Landscaping Private 2           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274) 13 9 1 57 17
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
143607 254234 DPW Maintained 1 :: 45 2651 Baker St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   01/23/2018 12:00:00 AM 3 7x3.6   5999602.71876 2117913.49531 37.7953624938231 -122.445387148979 (37.7953624938231, -122.445387148979) 13 9 1 57 17

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