trees

Custom SQL query returning 33 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
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
68964 113434 1 57 198x HIGHLAND AVE 1 Sidewalk: Curb side : Cutout Tree 4     12 4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
27818 98647 1 57 2110 Greenwich St 4 Sidewalk: Curb side : Cutout Tree 4 DPW   12 5x5   6002751.94545 2119240.19821 37.7991845449763 -122.434585229619 (37.7991845449763, -122.434585229619) 13 9 1 57 17
39667 95239 4 36 1220 Noe St 6 Sidewalk: Curb side : Cutout Tree 4 DPW   12     6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
170711 95240 4 36 1220 Noe St 7 Sidewalk: Curb side : Cutout Tree 4 DPW   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
175564 95236 4 36 1220 Noe St 2 Sidewalk: Curb side : Cutout Tree 4 DPW   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
9319 77642 1 57 1300X Silliman St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 4x4   6006942.10409 2093179.93326 37.7278661320969 -122.418237156514 (37.7278661320969, -122.418237156514) 9 3 7 309 5
10546 77641 1 57 1300X Silliman St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 4x4   6006964.98892 2093186.85252 37.7278864190206 -122.418158533295 (37.7278864190206, -122.418158533295) 9 3 7 309 5
12999 38424 1 246 1451 Jackson St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/24/2005 12:00:00 AM 12 3x3 Permit Number 48015 6007280.79709 2117415.82487 37.7944313239892 -122.418784361633 (37.7944313239892, -122.418784361633) 5 1 10 28858 32
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
18070 99372 1 16 499X 29th Ave 26 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 3x3   5986859.5 2112566.5 37.7799454996166 -122.489086903101 (37.7799454996166, -122.489086903101) 11 6 2 55 26
37806 71177 1 70 4235 19th St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 08/05/1995 12:00:00 AM 12 4x4   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
43418 99345 1 16 450 30th Ave 23 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 4x4   5986571.27659 2113136.01167 37.7814923890114 -122.490125885703 (37.7814923890114, -122.490125885703) 11 6 2 55 26
44945 99261 1 16 3099X Polk St 1 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency   12 3x6   6005936.6 2121383.7 37.8052503240173 -122.42371770971 (37.8052503240173, -122.42371770971) 5 1 1 28858 32
50714 97069 1 17 1551 Newcomb Ave 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 6x6   6015475.3 2095481.7 37.7346629526589 -122.388898077079 (37.7346629526589, -122.388898077079) 10 3 8 58 1
54545 42985 1 57 2X Yale St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 09/16/2000 12:00:00 AM 12 9x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
60137 98622 1 38 3500X Fillmore St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 6x6   6002297.34528 2119958.59074 37.8011312453645 -122.436209738003 (37.8011312453645, -122.436209738003) 13 9 1 57 17
65075 76344 1 16 3899X Kirkham St 12 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/14/1994 12:00:00 AM 12 3x30   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
68707 32729 1 103 200X Farallones St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 10/29/1996 12:00:00 AM 12 3x3 Permit Number 37116 5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
77066 99693 1 36 1550X Washington St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 3x3   6007274.7 2117123.2 37.7936275055362 -122.418784695641 (37.7936275055362, -122.418784695641) 5 1 10 28858 32
111390 92750 1 62 2049 Grove St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 10/02/2009 12:00:00 AM 12 3x3 Permit Number 52971 5998090.3691 2110284.0117 37.7743274908907 -122.450069934151 (37.7743274908907, -122.450069934151) 15 5 11 29492 16
115408 99355 1 16 451X 29th Ave 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 3x3   5986839.02344 2113010.76146 37.7811641198035 -122.489190411627 (37.7811641198035, -122.489190411627) 11 6 2 55 26
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
132120 98636 1 38 3500X Fillmore St 15 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 6x6   6002249.05694 2120273.69699 37.8019937006086 -122.436399401415 (37.8019937006086, -122.436399401415) 13 9 1 57 17
132288 97076 1 17 1551 Newcomb Ave 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 4x4   6015475.3 2095481.7 37.7346629526589 -122.388898077079 (37.7346629526589, -122.388898077079) 10 3 8 58 1
132313 73528 1 70 4235 19th St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 08/05/1995 12:00:00 AM 12 4x4   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
136468 95150 1 16 250 23rd Ave 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12     5988721.36117 2113591.74757 37.7828690364709 -122.482721124926 (37.7828690364709, -122.482721124926) 11 6 2 55 26
155407 99339 1 16 450 30th Ave 17 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 3.5x3.5   5986576.13047 2112991.43823 37.7810957151351 -122.490098456538 (37.7810957151351, -122.490098456538) 11 6 2 55 26
156907 98623 1 38 3500X Fillmore St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 6x6   6002295.23154 2119980.02637 37.80118998188 -122.436218587333 (37.80118998188, -122.436218587333) 13 9 1 57 17
170345 42643 1 103 1600X GREEN ST 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/26/2000 12:00:00 AM 12 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
171361 98624 1 38 3500X Fillmore St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 6x6   6002286.82962 2120018.90884 37.801296265561 -122.436250445798 (37.801296265561, -122.436250445798) 13 9 1 57 17
178939 47202 1 42 2801X Clement St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/08/2002 12:00:00 AM 12 3x3 Permit Number 45157 5986698.68199 2113217.08014 37.7817224192006 -122.489691093913 (37.7817224192006, -122.489691093913) 11 6 2 55 26
188415 99369 1 16 451X 29th Ave 23 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   12 3x3   5986847.81361 2112672.32158 37.7802353734381 -122.489135113122 (37.7802353734381, -122.489135113122) 11 6 2 55 26