508 rows where qSpecies_id = 25

View and edit SQL

Suggested facets: Police Districts

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)
42 221891 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 180 Bartlett St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006685.21207 2102724.39469 37.7540586268078 -122.419802203518 (37.7540586268078, -122.419802203518) 2 4 7 28859 19
636 67551 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 655 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM 8   Permit Number 31099 6011561.87177 2105285.59303 37.7613646282886 -122.403117586111 (37.7613646282886, -122.403117586111) 10 3 8 28856 29
732 181868 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2335 28th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   02/24/2020 12:00:00 AM 3 5x5   5987618.1769 2099375.389 37.7437705756333 -122.485494034638 (37.7437705756333, -122.485494034638) 1 8 3 29491 35
993 67493 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 740 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/08/1992 12:00:00 AM 8   Permit Number 31018 6011800.9294 2105019.52264 37.7606474054712 -122.402272073209 (37.7606474054712, -122.402272073209) 10 3 8 28856 29
1058 160441 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 201 France Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/07/2019 12:00:00 AM 3 4x6   6001628.58163 2090114.34641 37.7191481986061 -122.436386782123 (37.7191481986061, -122.436386782123) 9 7 6 28861 5
1568 172155 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 649 Girard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x5   6011250.4218 2091802.92791 37.7243267296922 -122.403246295306 (37.7243267296922, -122.403246295306) 10 3 7 309 28
1757 261740 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 8 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
1940 43017 Permitted Site 7 Geijera parviflora :: Australian Willow 25   2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
2041 160444 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 201 France Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/07/2019 12:00:00 AM 3 4x6   6001593.49946 2090135.39202 37.7192039916542 -122.436509553078 (37.7192039916542, -122.436509553078) 9 7 6 28861 5
2212 225967 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 3599 24th St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6005877.12817 2101963.64024 37.7519242145407 -122.422542702196 (37.7519242145407, -122.422542702196) 2 4 5 28859 19
2319 34069 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
2617 247759 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 75 Alpine Ter 1 : Tree Private 2     10 Width 3ft   6001668.74952 2108376.80716 37.7692948959648 -122.437555068929 (37.7692948959648, -122.437555068929) 15 5 5 29492 9
2735 262549 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 923 Ingerson Ave 3 unknown : Yard Tree Private 2   08/20/2020 12:00:00 AM   Width 0ft   6014491.3602 2089577.767 37.7183973497527 -122.391887217647 (37.7183973497527, -122.391887217647) 10 3 8 58 1
3374 261742 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 10 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
3438 194171 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 740 Rhode Island St 2 Sidewalk: Property side : Yard Tree Private 2     11 Width 7ft   6011792.75247 2105015.27083 37.7606352745052 -122.402300054726 (37.7606352745052, -122.402300054726) 10 3 8 28856 29
3439 43015 Permitted Site 7 Geijera parviflora :: Australian Willow 25   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
4108 171288 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 337 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 3ft   6003689.73978 2092721.91783 37.7264249154698 -122.429448003531 (37.7264249154698, -122.429448003531) 9 7 6 28861 5
4619 84421 Permitted Site 7 Geijera parviflora :: Australian Willow 25 3450 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50587 6006545.62237249 2104975.62835635 37.7602321285391 -122.420444723128 (37.7602321285391, -122.420444723128) 2 4 7 28859 19
4752 107181 Undocumented 4 Geijera parviflora :: Australian Willow 25 1520 PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 6x9   5999172.7 2109108.7 37.7711622584795 -122.446241403234 (37.7711622584795, -122.446241403234) 15 5 11 29492 9
4771 261101 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1188 Jamestown Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6013127 2090401 37.7205819447786 -122.396660953022 (37.7205819447786, -122.396660953022) 10 3 8 58 1
4939 225906 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 3749 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6005541.4535 2101364.78602 37.7502609561874 -122.423660939909 (37.7502609561874, -122.423660939909) 2 4 5 28859 19
5259 45154 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1683 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2001 12:00:00 AM     Permit Number 44007                    
5319 26546 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 570 Francisco St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/17/2020 12:45:00 PM 3 4X4   6008578.3106 2121094.8201 37.804605899968 -122.414555254943 (37.804605899968, -122.414555254943) 3 1 10 308 23
5483 83664 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 75 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/27/2019 12:00:00 AM 3 3x3 Permit Number 769750 6003631.23676 2092962.7354 37.7270828342867 -122.429667413832 (37.7270828342867, -122.429667413832) 9 7 6 28861 5
5523 38232 Permitted Site 7 Geijera parviflora :: Australian Willow 25 0 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM     Permit Number 40352                    
5885 261744 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 12 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
6572 34068 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
6767 38234 Permitted Site 7 Geijera parviflora :: Australian Willow 25 0 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM     Permit Number 40352                    
6809 65477 Permitted Site 7 Geijera parviflora :: Australian Willow 25 400 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/12/1989 12:00:00 AM     Permit Number 28358 5994782.15079154 2091255.17859292 37.7218892499679 -122.460134715976 (37.7218892499679, -122.460134715976) 9 8 4 28861 24
6826 261100 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1900 Donner Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6011819 2093407 37.7287629192895 -122.401393465775 (37.7287629192895, -122.401393465775) 10 3 8 58 1
7060 38233 Permitted Site 7 Geijera parviflora :: Australian Willow 25 0 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM     Permit Number 40352                    
7097 34072 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
7119 160442 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 201 France Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/07/2019 12:00:00 AM 3 4x6   6001618.67643 2090120.31362 37.7191640203955 -122.436421447404 (37.7191640203955, -122.436421447404) 9 7 6 28861 5
7174 225912 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1038 Guerrero St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6005698.15966 2102902.03106 37.7544907204839 -122.423228299447 (37.7544907204839, -122.423228299447) 2 4 5 28859 19
7369 228945 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 25 Camp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/11/2020 12:00:00 AM 3 3x3   6005777.88967 2106349.43528 37.7639609845445 -122.423197607405 (37.7639609845445, -122.423197607405) 8 4 5 28859 19
7436 43016 Permitted Site 7 Geijera parviflora :: Australian Willow 25   4 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
7461 32089 Permitted Site 7 Geijera parviflora :: Australian Willow 25 3976 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1995 12:00:00 AM     Permit Number 35462 6003168.80356063 2104788.27114216 37.7595268169135 -122.432110159889 (37.7595268169135, -122.432110159889) 2 4 5 28862 3
7887 152881 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 3572 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6005780.88013 2104928.47476 37.7600595303512 -122.42308625784 (37.7600595303512, -122.42308625784) 2 4 5 28859 19
8075 225935 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1250 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/31/1994 12:00:00 AM 10 Width 3ft Permit Number 33274 6008670.47689 2101262.07632 37.7501550682215 -122.412833276033 (37.7501550682215, -122.412833276033) 2 4 7 28859 19
8908 69088 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1474 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/10/1994 12:00:00 AM     Permit Number 33098 5992145.68632685 2105413.48754834 37.7606123691548 -122.470278745237 (37.7606123691548, -122.470278745237) 1 8 4 56 12
9043 43018 Permitted Site 7 Geijera parviflora :: Australian Willow 25   3 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
9064 160443 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 201 France Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/07/2019 12:00:00 AM 3 4x6   6001607.56751 2090126.88906 37.7191814438384 -122.436460317003 (37.7191814438384, -122.436460317003) 9 7 6 28861 5
9398 264655 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1099 Hollister Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/08/2020 04:53:00 PM   3x3                      
9717 56360 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2100 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1973 12:00:00 AM 30   Permit Number 12506 6000958.47841613 2115569.02150374 37.7890024802988 -122.440527774143 (37.7890024802988, -122.440527774143) 13 6 1 29490 27
9850 30919 Permitted Site 7 Geijera parviflora :: Australian Willow 25 212 Granada Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   03/13/1995 12:00:00 AM     Permit Number 34735 5995669.33198455 2091339.19890433 37.722170938941 -122.457074050715 (37.722170938941, -122.457074050715) 9 8 4 28861 24
10034 262181 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 299 Raymond Ave 1 Side Yard : Cutout Tree DPW 1 FUF 09/07/2019 12:00:00 AM 3     6009464.05793 2087979.76345 37.7137291845874 -122.409151878423 (37.7137291845874, -122.409151878423) 9 7 8 309 39
10061 171232 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 83 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/13/2019 12:00:00 AM 3 4x6   6003613.10498 2092939.5829 37.727018235977 -122.429728444518 (37.727018235977, -122.429728444518) 9 7 6 28861 5
10451 225947 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 114 Rousseau St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6003497.57041 2095097.96573 37.7329381267755 -122.430281767707 (37.7329381267755, -122.430281767707) 9 7 5 28861 25
10559 10061 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 490 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1     60 2X2   6005517.65207 2106131.14555 37.7633469229371 -122.424082167969 (37.7633469229371, -122.424082167969) 8 4 5 28859 19
11255 70154 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 339 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     5992446.53753 2113177.4125 37.7819474134806 -122.469803511026 (37.7819474134806, -122.469803511026) 11 6 2 54 11
11311 73919 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 179 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6007979.77962 2109750.06791 37.77342234081 -122.415822718756 (37.77342234081, -122.415822718756) 8 2 9 28853 34
11749 200232 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 923 Ingerson Ave 1 unknown : Yard Tree Private 2   08/20/2020 12:00:00 AM 3 Width 0ft   6014491.3602 2089577.767 37.7183973497527 -122.391887217647 (37.7183973497527, -122.391887217647) 10 3 8 58 1
11951 142340 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 520 Central Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999729.6682 2110321.6281 37.7745244442512 -122.444402018718 (37.7745244442512, -122.444402018718) 15 5 11 29492 16
11961 115127 Permitted Site 7 Geijera parviflora :: Australian Willow 25 499X MAIN ST 5 Sidewalk: Curb side : Cutout Tree Private 2     6     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
12728 256034 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1455 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6015659 2093559 37.729393784799 -122.388128823531 (37.729393784799, -122.388128823531) 10 3 8 58 1
12766 261739 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 7 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
12809 38231 Permitted Site 7 Geijera parviflora :: Australian Willow 25 0 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM     Permit Number 40352                    
13102 200235 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 923 Ingerson Ave 2 unknown : Yard Tree Private 2   08/20/2020 12:00:00 AM 0 Width 0ft   6014534.9569 2089547.5847 37.7183168953073 -122.39173441165 (37.7183168953073, -122.39173441165) 10 3 8 58 1
13467 70988 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 179 11th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6007961.92289 2109767.88075 37.7734702467743 -122.415885749526 (37.7734702467743, -122.415885749526) 8 2 9 28853 34
13543 83275 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1639X Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6008740.14676 2118614.90766 37.7978057691893 -122.413819676732 (37.7978057691893, -122.413819676732) 5 1 10 308 21
13990 142563 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 555 FRANCISCO ST 1 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2020 12:42:00 PM 3 Width 0ft   6008640.5494 2121060.0298 37.8045138709312 -122.414337407838 (37.8045138709312, -122.414337407838) 3 1 10 308 23
14576 34071 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
14624 261099 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1900 Donner Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6011819 2093407 37.7287629192895 -122.401393465775 (37.7287629192895, -122.401393465775) 10 3 8 58 1
14626 225965 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 81 Bernal Heights Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009494.27227 2098224.22173 37.7418599932559 -122.409770124916 (37.7418599932559, -122.409770124916) 10 7 7 28859 2
14638 261745 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 13 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
14658 261743 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 11 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
15108 113387 Permitted Site 7 Geijera parviflora :: Australian Willow 25 185 CASTENADA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     3     5994493 2100782 37.7480309194949 -122.461824674651 (37.7480309194949, -122.461824674651) 1 8 4 29491 40
15134 261076 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1188 Jamestown Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6013127 2090401 37.7205819447786 -122.396660953022 (37.7205819447786, -122.396660953022) 10 3 8 58 1
15256 259564 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 200 Public Park 3 Unaccepted Street : Cutout Tree Private 2       5x10   5994204 2098512 37.741781429361 -122.462659374294 (37.741781429361, -122.462659374294) 1 8 4 59 40
15349 122920 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 330 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/16/2020 12:00:00 AM 3 Width 2ft   5992493.10071 2113220.22773 37.7820676636923 -122.469645543184 (37.7820676636923, -122.469645543184) 11 6 2 54 11
15542 262169 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 111 Raymond Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/07/2019 12:00:00 AM 3     6010514.3033 2087552.92261 37.7126159475575 -122.405491784734 (37.7126159475575, -122.405491784734) 9 7 8 309 39
16190 34502 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1415 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1997 12:00:00 AM 9   Permit Number 38224 6013698.3172 2104744.62684 37.7599983314835 -122.395690557494 (37.7599983314835, -122.395690557494) 10 3 8 28856 29
16452 261741 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 9 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
16692 78621 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2140 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6011632.94564 2104677.50372 37.7596989192821 -122.402829001752 (37.7596989192821, -122.402829001752) 10 3 8 28856 29
16742 34070 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
16772 113034 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 251 06th Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     2 3x3   5993975.1139 2113804.1265 37.7837564355183 -122.464560902617 (37.7837564355183, -122.464560902617) 11 6 2 54 11
17037 264800 Undocumented 4 Geijera parviflora :: Australian Willow 25 330 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011202 2089015 37.7166689455126 -122.403217660421 (37.7166689455126, -122.403217660421) 10 7 8 309 39
17098 34067 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
17201 72137 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1445 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6013608.91395 2104739.63414 37.7599796489713 -122.395999412568 (37.7599796489713, -122.395999412568) 10 3 8 28856 29
17383 258113 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 144 Freelon St   Sidewalk: Curb side : Cutout Tree DPW 1     3     6013235.08289 2111410.77261 37.7782762981131 -122.397760259133 (37.7782762981131, -122.397760259133) 6 2 9 28856 34
17567 150775 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2004 22nd St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/29/2018 12:00:00 AM 3 4x5   6012077.37529 2103767.84682 37.757226007585 -122.401228007969 (37.757226007585, -122.401228007969) 10 3 8 28856 29
18508 79749 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 615 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6015454.74686 2106112.32495 37.7638512843329 -122.389711390588 (37.7638512843329, -122.389711390588) 14 3 8 28856 29
19037 163093 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 207 Minerva St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/30/2020 12:00:00 AM 3 Width 0ft   5994973.89241 2089001.27362 37.7157115895984 -122.459308778876 (37.7157115895984, -122.459308778876) 9 8 6 28861 24
19143 83274 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1639X Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6008741.72565 2118600.65097 37.7977667125146 -122.41381320433 (37.7977667125146, -122.41381320433) 5 1 10 308 21
19459 49782 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 327 Wheeler Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/2020 12:00:00 AM 3   Permit Number 46567 6012093.71999 2087090.74144 37.711435076735 -122.400000354248 (37.711435076735, -122.400000354248) 10 3 8 309 1
19562 62935 Permitted Site 7 Geijera parviflora :: Australian Willow 25 108 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/05/1986 12:00:00 AM     Permit Number 23316 6007129.03577236 2097271.50045175 37.7391111999262 -122.417880841628 (37.7391111999262, -122.417880841628) 2 7 7 28859 2
19983 36067 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1398 Bryant St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/28/1998 12:00:00 AM     Permit Number 39186 6009394 2107812 37.7681802592774 -122.410793808029 (37.7681802592774, -122.410793808029) 8 4 7 28853 19
20477 39576 Permitted Site 7 Geijera parviflora :: Australian Willow 25 300 Montcalm St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM     Permit Number 40993 6009738.16770437 2099629.76502916 37.7457329730731 -122.409025961078 (37.7457329730731, -122.409025961078) 2 7 7 28859 2
21411 10091 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 708 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/07/1992 12:00:00 AM 50 3X3   6005589.43333 2104821.82229 37.7597558823477 -122.423740797923 (37.7597558823477, -122.423740797923) 2 4 5 28859 19
21840 67067 Permitted Site 7 Geijera parviflora :: Australian Willow 25 22 Newman St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1992 12:00:00 AM     Permit Number 30456 6006871.92388007 2096801.0625203 37.7378050085566 -122.418736466303 (37.7378050085566, -122.418736466303) 2 7 7 28859 2
22071 192422 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 80 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   6012207.07921 2107722.19142 37.7680909933277 -122.401057281578 (37.7680909933277, -122.401057281578) 14 3 8 28856 20
22131 49877 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1331@ IRVING 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2003 12:00:00 AM     Permit Number 46643 5992989.81423972 2106408.90402865 37.7633942890183 -122.467431700246 (37.7633942890183, -122.467431700246) 1 8 11 56 12
22267 82278 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 245 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2008 12:00:00 AM 5 3x3 Permit Number 50610 5992733.47806 2113805.1753 37.7836876598148 -122.468856534024 (37.7836876598148, -122.468856534024) 11 6 2 54 11
23044 51908 Permitted Site 7 Geijera parviflora :: Australian Willow 25 490X Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/2009 12:00:00 AM 3 3x3 Permit Number 52601 6002971.47862471 2105361.83743697 37.7610905025589 -122.432833581883 (37.7610905025589, -122.432833581883) 15 4 5 28862 3
23417 128877 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1237x Robert C Levy Tunl 6 Median : Yard Tree DPW 1     3     6007635.08843 2118146.70213 37.796458073045 -122.417610293998 (37.796458073045, -122.417610293998) 5 1 10 28858 32
23576 10026 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 290 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 2x3   6005455.03663 2107324.13866 37.7666190630424 -122.424383592842 (37.7666190630424, -122.424383592842) 8 4 5 28853 19
24456 225946 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 3557 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6005893.76776 2102550.85426 37.7535375074585 -122.422526882211 (37.7535375074585, -122.422526882211) 2 4 5 28859 19
25081 225931 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 337 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6007076.3964 2096610.27498 37.737292658529 -122.418015982652 (37.737292658529, -122.418015982652) 2 7 7 28859 2
25095 244549 Undocumented 4 Geijera parviflora :: Australian Willow 25 1500 Page St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5999267.0062 2109103.195 37.7711525285338 -122.445914799778 (37.7711525285338, -122.445914799778) 15 5 11 29492 9
25269 128865 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2610 Clay St 13 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6001864.71047 2116045.71849 37.7903629286659 -122.437426485651 (37.7903629286659, -122.437426485651) 13 6 1 29490 27

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