trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
127 119777 1 59 204x Octavia St 12 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
215 119692 1 59 4x Octavia St 10 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
248 119766 1 59 204x Octavia St 1 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
313 119729 1 59 104x Octavia St 9 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
413 119686 1 59 4x Octavia St 4 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
431 119778 1 59 204x Octavia St 13 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
1959 19904 1 59 100 STAIRWAY34 2 Sidewalk: Curb side : Cutout Tree 1     12 6X6                      
6805 19781 1 59 100 STAIRWAY19 3 Sidewalk: Curb side : Cutout Tree 1     36 50ST                      
12376 119696 1 59 4x Octavia St 14 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
12447 19841 1 59 100 STAIRWAY25 25 Sidewalk: Curb side : Cutout Tree 1     12 60X                      
12956 119689 1 59 4x Octavia St 7 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
13169 20051 1 59 100 STAIRWAY52 7 Sidewalk: Curb side : Cutout Tree 1     12 10                      
14005 119780 1 59 204x Octavia St 15 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
15701 254211 1 59 300X Esmeralda Ave 3 Unaccepted Street : Yard Tree 1                              
16277 119724 1 59 104x Octavia St 4 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
16362 119731 1 59 104x Octavia St 11 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
18074 19903 1 59 100 STAIRWAY34 1 Sidewalk: Curb side : Cutout Tree 1     12 6X6                      
21014 119730 1 59 104x Octavia St 10 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
31585 119691 1 59 4x Octavia St 9 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
35418 119732 1 59 104x Octavia St 12 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
46759 119728 1 59 104x Octavia St 8 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
53212 119723 1 59 104x Octavia St 3 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
56641 119767 1 59 204x Octavia St 2 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
58975 119683 1 59 4x Octavia St 1 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
60290 119690 1 59 4x Octavia St 8 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
62466 119770 1 59 204x Octavia St 5 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
64025 119685 1 59 4x Octavia St 3 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
64910 119734 1 59 104x Octavia St 14 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
74269 119684 1 59 4x Octavia St 2 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
75461 119727 1 59 104x Octavia St 7 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
84324 119697 1 59 4x Octavia St 15 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
90812 119733 1 59 104x Octavia St 13 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
104758 119774 1 59 204x Octavia St 9 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
106853 119772 1 59 204x Octavia St 7 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
106915 119693 1 59 4x Octavia St 11 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
107339 119694 1 59 4x Octavia St 12 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
113560 119722 1 59 104x Octavia St 2 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
113742 119769 1 59 204x Octavia St 4 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
119609 119771 1 59 204x Octavia St 6 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
126751 119726 1 59 104x Octavia St 6 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
135794 119725 1 59 104x Octavia St 5 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
153309 119768 1 59 204x Octavia St 3 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
158897 119775 1 59 204x Octavia St 10 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
159585 119687 1 59 4x Octavia St 5 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
160546 119721 1 59 104x Octavia St 1 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
173837 119695 1 59 4x Octavia St 13 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
178614 119779 1 59 204x Octavia St 14 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
179144 119773 1 59 204x Octavia St 8 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
180133 119735 1 59 104x Octavia St 15 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
187388 119776 1 59 204x Octavia St 11 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
189536 119688 1 59 4x Octavia St 6 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
1376 263620 4 59 900 Beach St 3 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
4419 260950 6 59 460x Davis Ct 2 Side Yard : Yard Tree 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 6
10225 263619 4 59 900 Beach St 2 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10567 263621 4 59 900 Beach St 4 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
11694 263618 4 59 900 Beach St 1 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
12617 249797 1 59 199 Chestnut St 5 Front Yard : Yard Tree 2     13 Width 0ft   6010839.41961 2121064.72571 37.8046500380318 -122.406728311085 (37.8046500380318, -122.406728311085) 3 1 10 308 23
13002 260949 6 59 460x Davis Ct 1 Side Yard : Yard Tree 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 6
24272 117475 4 59 1200x MONTGOMERY ST 2 Unaccepted Street : Cutout Tree 2           6011580 2119440 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068) 3 1 10 308 23
26017 109376 8 59 111 BAY ST 3 Back Yard : Yard Tree 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
27833 249798 1 59 199 Chestnut St 6 Front Yard : Yard Tree 2     14 Width 0ft   6010832.73906 2121063.1197 37.8046452545423 -122.406751316639 (37.8046452545423, -122.406751316639) 3 1 10 308 23
35274 249899 1 59 1497 Montgomery St 3 Side Yard : Yard Tree 2     17 Width 0ft   6011381.09793 2120471.14228 37.8030504957345 -122.404811954701 (37.8030504957345, -122.404811954701) 3 1 10 28860 6
42959 117474 4 59 1200x MONTGOMERY ST 1 Unaccepted Street : Cutout Tree 2           6011580 2119440 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068) 3 1 10 308 23
64778 109377 8 59 111 BAY ST 4 Back Yard : Yard Tree 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
66019 249894 1 59 230 Greenwich St 30 Back Yard : Yard Tree 2     24 Width 0ft   6011403.76038 2120447.63681 37.8029872221404 -122.404731874586 (37.8029872221404, -122.404731874586) 3 1 10 28860 6
77598 249893 1 59 230 Greenwich St 29 Back Yard : Yard Tree 2     13 Width 0ft   6011394.80053 2120441.53452 37.8029699659579 -122.404762450627 (37.8029699659579, -122.404762450627) 3 1 10 28860 6
78217 249800 1 59 199 Chestnut St 8 Front Yard : Yard Tree 2     16 Width 0ft   6010811.58408 2121055.18857 37.8046222939481 -122.406823966551 (37.8046222939481, -122.406823966551) 3 1 10 308 23
84676 109375 8 59 111 BAY ST 2 Back Yard : Yard Tree 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
86942 103067 7 59 255 Broadway 6 Sidewalk: Curb side : Cutout Tree 2   12/11/2014 12:00:00 AM 3 6x6 Permit Number 769997 6012256.1 2118721.6 37.7982955442476 -122.401660929382 (37.7982955442476, -122.401660929382) 3 1 10 28860 6
95955 117473 4 59 1201x MONTGOMERY ST 1 Unaccepted Street : Cutout Tree 2           6011733 2119731 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239) 3 1 10 308 23
98514 249895 1 59 230 Greenwich St 31 Back Yard : Yard Tree 2     18 Width 0ft   6011395.76102 2120447.38073 37.8029860719045 -122.404759538639 (37.8029860719045, -122.404759538639) 3 1 10 28860 6
114094 117472 4 59 1201x MONTGOMERY ST 2 Unaccepted Street : Cutout Tree 2           6011733 2119731 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239) 3 1 10 308 23
137889 109378 8 59 111 BAY ST 5 Back Yard : Yard Tree 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
142161 249896 1 59 230 Greenwich St 32 Back Yard : Yard Tree 2     24 Width 0ft   6011386.30387 2120437.51769 37.8029584618196 -122.404791570676 (37.8029584618196, -122.404791570676) 3 1 10 28860 6
150059 249897 1 59 1497 Montgomery St 5 Side Yard : Yard Tree 2     20 Width 0ft   6011384.61876 2120458.08201 37.8030148322229 -122.404798850701 (37.8030148322229, -122.404798850701) 3 1 10 28860 6
155569 109374 8 59 111 BAY ST 1 Back Yard : Yard Tree 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
67051 113134 6 59 50 03rd St 2 Front Yard : Yard Tree 2   09/09/2015 12:00:00 AM   10x10 Permit Number 775860 6011822.9 2114512.2 37.7867133521926 -122.402863731968 (37.7867133521926, -122.402863731968) 12 2 9 28853 6
93639 91056 7 59 750 FOLSOM ST 6 Sidewalk: Curb side : Cutout Tree 2       6x4   6012569 2113092 37.7828554456154 -122.400182606689 (37.7828554456154, -122.400182606689) 6 2 9 28853 34
148445 91057 7 59 750 FOLSOM ST 7 Sidewalk: Curb side : Cutout Tree 2     25 6x4   6012569 2113092 37.7828554456154 -122.400182606689 (37.7828554456154, -122.400182606689) 6 2 9 28853 34
184663 113133 6 59 50 03rd St 1 Front Yard : Yard Tree 2   09/09/2015 12:00:00 AM   10x10 Permit Number 775860 6011822.9 2114512.2 37.7867133521926 -122.402863731968 (37.7867133521926, -122.402863731968) 12 2 9 28853 6
6092 196018 1 59 212 Terry A Francois Blvd 22 Sidewalk: Property side : Yard Tree 2     15     6015632.04702 2110689.93838 37.7764302375944 -122.389417852744 (37.7764302375944, -122.389417852744) 14 3 9 310 20
10408 195999 1 59 212 Terry A Francois Blvd 3 Sidewalk: Property side : Yard Tree 2     16     6016051.5903 2110711.60548 37.7765129824099 -122.387968033214 (37.7765129824099, -122.387968033214) 14 3 9 310 20
21224 196043 1 59 1 Lane St 15 Sidewalk: Property side : Yard Tree 2     13 Width 10ft   6017069.89025 2097009.95172 37.7389474821301 -122.383491338448 (37.7389474821301, -122.383491338448) 10 3 8 58 1
21347 201996 1 59 1799 Carroll Ave 4 Sidewalk: Curb side : Yard Tree 2     2     6013312.67339 2092499.74696 37.7263550129554 -122.396166145968 (37.7263550129554, -122.396166145968) 10 3 8 58 1
23490 196012 1 59 212 Terry A Francois Blvd 16 Sidewalk: Property side : Yard Tree 2     16     6015764.41678 2110694.68671 37.7764506135265 -122.388960275907 (37.7764506135265, -122.388960275907) 14 3 9 310 20
28533 195986 1 59 401 Amador St 7 Sidewalk: Curb side : Yard Tree 2     3     6018468.61509 2099561.76349 37.7460314544851 -122.378832298987 (37.7460314544851, -122.378832298987) 10 3 8 58 1
29793 195970 1 59 200 Tulare St 16 Back Yard : Yard Tree 2     8     6015399.1088 2100325.42161 37.7479585928282 -122.389499659601 (37.7479585928282, -122.389499659601)   3 8 58 1
30255 196014 1 59 212 Terry A Francois Blvd 18 Sidewalk: Property side : Yard Tree 2     17     6015720.48392 2110692.27541 37.7764415573597 -122.389112085054 (37.7764415573597, -122.389112085054) 14 3 9 310 20
32210 195994 1 59 2101 Newcomb Ave 3 Side Yard : Yard Tree 2     20 Width 3ft   6012438.11131 2097750.05558 37.7407225675882 -122.39955794175 (37.7407225675882, -122.39955794175) 10 3 8 58 1
32582 196000 1 59 212 Terry A Francois Blvd 4 Sidewalk: Property side : Yard Tree 2     17     6016029.90141 2110710.35403 37.7765083446095 -122.38804297462 (37.7765083446095, -122.38804297462) 14 3 9 310 20
35055 196038 1 59 1 Lane St 7 Sidewalk: Property side : Yard Tree 2     15 Width 10ft   6017052.09274 2096987.35134 37.7388844423585 -122.38355130167 (37.7388844423585, -122.38355130167) 10 3 8 58 1
37731 196046 1 59 1 Lane St 20 Sidewalk: Property side : Yard Tree 2     15 Width 10ft   6017076.84536 2097020.98628 37.7389781652152 -122.383468058608 (37.7389781652152, -122.383468058608) 10 3 8 58 1
37957 196010 1 59 212 Terry A Francois Blvd 14 Sidewalk: Property side : Yard Tree 2     17     6015807.5178 2110696.90854 37.7764591031505 -122.38881133109 (37.7764591031505, -122.38881133109) 14 3 9 310 20
38227 196030 1 59 2 Lane St 9 Sidewalk: Property side : Yard Tree 2     9 Width 10ft   6017023.70578 2097046.84349 37.739046226814 -122.383653592346 (37.739046226814, -122.383653592346) 10 3 8 58 1
39747 196021 1 59 212 Terry A Francois Blvd 25 Sidewalk: Property side : Yard Tree 2     20     6015567.39764 2110686.7089 37.7764177856004 -122.389641269543 (37.7764177856004, -122.389641269543) 14 3 9 310 20
41514 195974 1 59 200 Tulare St 20 Back Yard : Yard Tree 2     12 Width 4ft   6015315.44713 2100317.81293 37.7479330619596 -122.389788429193 (37.7479330619596, -122.389788429193)   3 8 58 1
42007 195956 1 59 200 Tulare St 2 Back Yard : Yard Tree 2     9     6015682.42479 2100340.57249 37.7480158985316 -122.388521013727 (37.7480158985316, -122.388521013727) 10 3 8 58 1
47866 195983 1 59 401 Amador St 10 Sidewalk: Curb side : Yard Tree 2     4     6018491.3513 2099573.26629 37.7460642923356 -122.378754477939 (37.7460642923356, -122.378754477939) 10 3 8 58 1
49343 196013 1 59 212 Terry A Francois Blvd 17 Sidewalk: Property side : Yard Tree 2     17     6015743.28218 2110693.67028 37.7764466511333 -122.389033316139 (37.7764466511333, -122.389033316139) 14 3 9 310 20
52665 254470 4 59 1601 Evans Ave 11 Sidewalk: Property side : Yard Tree 2       3x3   6015397 2098706 37.7435118805521 -122.389393878977 (37.7435118805521, -122.389393878977) 10 3 8 58 1
52670 196039 1 59 1 Lane St 9 Sidewalk: Property side : Yard Tree 2     17 Width 10ft   6017058.78761 2096996.23306 37.7389091998064 -122.38352877184 (37.7389091998064, -122.38352877184) 10 3 8 58 1