trees

Custom SQL query returning 73 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
37736 101041 6 17 3750 18th St 1 Front Yard : Yard Tree 4   03/15/2012 12:00:00 AM 30   Permit Number 769376 6005230 2105481 37.7615455321967 -122.425030802687 (37.7615455321967, -122.425030802687) 8 4 5 28859 19
42099 234076 1 36 1400 San Bruno Ave 7 Sidewalk: Curb side : Cutout Tree 4     12 Width 4ft   6011147.1312 2101589.6307 37.751193164657 -122.404291863299 (37.751193164657, -122.404291863299) 10 4 8 28859 19
47875 234074 1 36 1400 San Bruno Ave 4 Sidewalk: Curb side : Cutout Tree 4     11 Width 3ft   6011143.5049 2101689.85229 37.751468148542 -122.404311456823 (37.751468148542, -122.404311456823) 10 4 8 28859 19
68939 43903 7 84 1050 York St 2 Sidewalk: Curb side : Cutout Tree 4   04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.7552328939148 -122.408509176777 (37.7552328939148, -122.408509176777) 2 4 7 28859 19
71723 79386 7 11 2355 Folsom St 16 Sidewalk: Curb side : Cutout Tree 4   10/30/2009 12:00:00 AM     Permit Number 53016 6008491.21757684 2104497.38565881 37.7590284322587 -122.4136819767 (37.7590284322587, -122.4136819767) 2 4 7 28859 19
95849 234073 1 36 1400 San Bruno Ave 3 Sidewalk: Curb side : Cutout Tree 4     17 Width 3ft   6011143.13167 2101723.71293 37.7515611015794 -122.404315130536 (37.7515611015794, -122.404315130536) 10 4 8 28859 19
121669 234075 1 36 1400 San Bruno Ave 6 Sidewalk: Curb side : Cutout Tree 4     14 Width 4ft   6011146.17896 2101629.85029 37.7513035456277 -122.404297986789 (37.7513035456277, -122.404297986789) 10 4 8 28859 19
141407 92806 7 17 2355 Folsom St 15 Sidewalk: Curb side : Cutout Tree 4   10/30/2009 12:00:00 AM     Permit Number 53016 6008199.4 2104720.1 37.7596235634815 -122.414706984191 (37.7596235634815, -122.414706984191) 2 4 7 28859 19
176122 253851 1 8 825X Shotwell St 2 Sidewalk: Curb side : Cutout Tree 4       3x3   6008234 2102998 37.7548970135718 -122.414465463083 (37.7548970135718, -122.414465463083) 2 4 7 28859 19
90475 234072 1 36 1400 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree 4 DPW   4 Width 3ft   6011140.67766 2101759.73109 37.7516598624171 -122.404326151746 (37.7516598624171, -122.404326151746) 10 4 8 28859 19
115599 96503 1 32 2360X Harrison St 4 Sidewalk: Curb side : Cutout Tree 4 DPW     3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
5845 96500 1 32 2360X Harrison St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
15357 98942 1 36 1400X San Bruno Ave 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 3x3   6011147.5 2101806.3 37.7517881116631 -122.404305836485 (37.7517881116631, -122.404305836485) 10 4 8 28859 19
17099 96505 1 32 2360X Harrison St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
21524 96504 1 32 2360X Harrison St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
25347 98970 1 8 825 Shotwell St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
28466 98940 1 36 1400X San Bruno Ave 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6011147.5 2101806.3 37.7517881116631 -122.404305836485 (37.7517881116631, -122.404305836485) 10 4 8 28859 19
30370 98969 1 106 825 Shotwell St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
35960 99029 1 8 200X Bartlett St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
38858 98972 1 66 825 Shotwell St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   0 5x5   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
39001 99032 1 8 200X Bartlett St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   5 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
40144 40254 1 8 3351X 23rd St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/13/1999 12:00:00 AM 10 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
40781 99039 1 33 200X Bartlett St 13 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
40964 99037 1 8 200X Bartlett St 11 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
44113 96509 1 32 2360X Harrison St 11 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
46230 99035 1 8 200X Bartlett St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
48192 99026 1 8 3351X 23rd St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3 Permit Number 41415 6006571 2102346.4 37.7530143054678 -122.420170352411 (37.7530143054678, -122.420170352411) 2 4 7 28859 19
49986 96493 1 17 2500X Harrison St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 10/24/2014 12:00:00 AM 3 5x5 Permit Number 774006 6008744 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409) 2 4 7 28859 19
52900 40252 1 8 3351X 23rd St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/13/1999 12:00:00 AM 8 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
55022 96512 1 32 2360X Harrison St 14 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
62996 99030 1 8 200X Bartlett St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
66136 99033 1 8 200X Bartlett St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
68065 98931 1 36 1401X Utah St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6010911 2101810 37.7517850526072 -122.405123950338 (37.7517850526072, -122.405123950338) 10 4 8 28859 19
68245 34754 1 50 825 Shotwell St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 04/07/2010 12:00:00 AM 5 3x3 Permit Number 53353 6007982.56974873 2103121.8781615 37.7552230267666 -122.415343751113 (37.7552230267666, -122.415343751113) 2 4 7 28859 19
75897 96511 1 32 2360X Harrison St 13 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
77291 98936 1 36 2641 25th St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3 Permit Number 48158 6011034 2101686.1 37.7514517258235 -122.404689875871 (37.7514517258235, -122.404689875871) 10 4 8 28859 19
81818 96502 1 32 2360X Harrison St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
83941 98943 1 36 1400X San Bruno Ave 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6011147.5 2101806.3 37.7517881116631 -122.404305836485 (37.7517881116631, -122.404305836485) 10 4 8 28859 19
87632 98968 1 8 825 Shotwell St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 10/16/2015 08:08:00 AM 3 3x3 Permit Number 53353 6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
88213 96513 1 32 2360X Harrison St 15 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
90271 98937 1 36 2641 25th St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3 Permit Number 48158 6011051 2101800 37.7517654203601 -122.404639104893 (37.7517654203601, -122.404639104893) 10 4 8 28859 19
91952 98933 1 36 1401X Utah St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6010911 2101810 37.7517850526072 -122.405123950338 (37.7517850526072, -122.405123950338) 10 4 8 28859 19
95964 51930 1 36 2641 25th St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 07/21/2005 12:00:00 AM 10 3x3 Permit Number 48158 6011052.19017876 2101794.26112893 37.7517497291988 -122.404634585115 (37.7517497291988, -122.404634585115) 10 4 8 28859 19
98389 99034 1 8 200X Bartlett St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
100312 98971 1 8 825 Shotwell St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
100591 96499 1 176 2500X Harrison St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     5x5   6008744 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409) 2 4 7 28859 19
102622 99027 1 8 200X Bartlett St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
105771 99036 1 8 200X Bartlett St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
106047 40253 1 8 3351X 23rd St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/13/1999 12:00:00 AM 5 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
109017 43904 7 84 1050 York St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.7552328939148 -122.408509176777 (37.7552328939148, -122.408509176777) 2 4 7 28859 19
111399 98935 1 36 1401X Utah St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6010911 2101810 37.7517850526072 -122.405123950338 (37.7517850526072, -122.405123950338) 10 4 8 28859 19
111842 98941 1 36 1400X San Bruno Ave 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   5 3x3   6011147.5 2101806.3 37.7517881116631 -122.404305836485 (37.7517881116631, -122.404305836485) 10 4 8 28859 19
113513 96492 1 176 2500X Harrison St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     5x5   6008744 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409) 2 4 7 28859 19
117978 99025 1 8 3351X 23rd St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6006571 2102346.4 37.7530143054678 -122.420170352411 (37.7530143054678, -122.420170352411) 2 4 7 28859 19
123401 98939 1 36 1400X San Bruno Ave 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 3x3   6011147.5 2101806.3 37.7517881116631 -122.404305836485 (37.7517881116631, -122.404305836485) 10 4 8 28859 19
124180 96506 1 32 2360X Harrison St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
127029 99028 1 8 200X Bartlett St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
129647 40250 1 33 3351X 23rd St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/13/1999 12:00:00 AM 3 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
134642 99031 1 8 200X Bartlett St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
146063 96501 1 32 2360X Harrison St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
149681 98932 1 36 1401X Utah St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6010911 2101810 37.7517850526072 -122.405123950338 (37.7517850526072, -122.405123950338) 10 4 8 28859 19
151982 99038 1 8 200X Bartlett St 12 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
152716 96497 1 176 2500X Harrison St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     5x5   6008744 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409) 2 4 7 28859 19
163770 98938 1 36 1400X San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6011147.5 2101806.3 37.7517881116631 -122.404305836485 (37.7517881116631, -122.404305836485) 10 4 8 28859 19
165159 98934 1 36 1401X Utah St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6010911 2101810 37.7517850526072 -122.405123950338 (37.7517850526072, -122.405123950338) 10 4 8 28859 19
165853 40251 1 8 3351X 23rd St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/13/1999 12:00:00 AM 10 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
169917 98974 1 8 825 Shotwell St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   8 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
170036 99040 1 8 200X Bartlett St 14 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
182167 99024 1 8 3351X 23rd St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   6006571 2102346.4 37.7530143054678 -122.420170352411 (37.7530143054678, -122.420170352411) 2 4 7 28859 19
185618 98973 1 8 825 Shotwell St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   8 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
189404 96510 1 32 2360X Harrison St 12 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
190278 96494 1 176 2500X Harrison St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     5x5   6008744 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409) 2 4 7 28859 19
193697 43905 7 84 1050 York St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.7552328939148 -122.408509176777 (37.7552328939148, -122.408509176777) 2 4 7 28859 19