trees

334 rows where qSpecies_id = 59 sorted by qAddress descending

✎ 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)
187174 234894 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 12 Front Yard : Yard Tree Private 2     27     6010729.67514 2100698.35511 37.7487225812957 -122.405672708429 (37.7487225812957, -122.405672708429) 2 7 7 28859 2
59791 96983 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800X Buchanan St 6 Sidewalk: Curb side : Cutout Tree Private 2     38   Permit Number 25529 6003522.34271 2118089.29041 37.796068153086 -122.431837171257 (37.796068153086, -122.431837171257) 13 9 1 57 17
91372 96982 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     41   Permit Number 25529 6003530.13563 2118059.26209 37.7959861448054 -122.431808061115 (37.7959861448054, -122.431808061115) 13 9 1 57 17
156312 104131 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800X Buchanan St 7 Sidewalk: Curb side : Cutout Tree Private 2     27     6003522.94878 2118100.93382 37.7961001572485 -122.431835905912 (37.7961001572485, -122.431835905912) 13 9 1 57 17
21087 234873 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 3 Sidewalk: Property side : Yard Tree Private 2     11     6010726.23893 2100862.83367 37.7491740112676 -122.405696174457 (37.7491740112676, -122.405696174457) 10 4 7 28859 19
24893 234872 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 2 Sidewalk: Property side : Yard Tree Private 2     31     6010732.42318 2100864.09022 37.7491778073048 -122.405674877619 (37.7491778073048, -122.405674877619) 10 4 7 28859 19
34861 234884 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 15 Sidewalk: Property side : Yard Tree Private 2     20     6010535.25533 2100821.90556 37.7490509498578 -122.406353718268 (37.7490509498578, -122.406353718268) 10 4 7 28859 19
66581 234875 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 5 Sidewalk: Property side : Yard Tree Private 2     12     6010693.4536 2100854.39807 37.7491490155229 -122.405808953037 (37.7491490155229, -122.405808953037) 10 4 7 28859 19
78172 234882 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 13 Sidewalk: Property side : Yard Tree Private 2     14     6010551.46993 2100825.34606 37.7490613037485 -122.406297890147 (37.7490613037485, -122.406297890147) 10 4 7 28859 19
111134 234874 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 4 Sidewalk: Property side : Yard Tree Private 2     33     6010703.27515 2100855.87105 37.7491536092595 -122.40577509356 (37.7491536092595, -122.40577509356) 10 4 7 28859 19
114900 234880 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 11 Sidewalk: Property side : Yard Tree Private 2     24     6010577.49101 2100830.77043 37.7490776534227 -122.406208290698 (37.7490776534227, -122.406208290698) 10 4 7 28859 19
115793 234881 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 12 Sidewalk: Property side : Yard Tree Private 2     29     6010567.07854 2100828.40228 37.749070568567 -122.406244130469 (37.749070568567, -122.406244130469) 10 4 7 28859 19
117375 234878 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 9 Sidewalk: Property side : Yard Tree Private 2     23     6010615.53478 2100839.32379 37.7491032670092 -122.406077336824 (37.7491032670092, -122.406077336824) 10 4 7 28859 19
121047 234886 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 17 Sidewalk: Property side : Yard Tree Private 2     28     6010522.64734 2100819.38367 37.7490433200014 -122.406397139344 (37.7490433200014, -122.406397139344) 10 4 7 28859 19
121304 234879 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 10 Sidewalk: Property side : Yard Tree Private 2     30     6010587.10266 2100832.95642 37.7490841933025 -122.406175207346 (37.7490841933025, -122.406175207346) 10 4 7 28859 19
131745 234883 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 14 Sidewalk: Property side : Yard Tree Private 2     22     6010542.26084 2100823.35069 37.7490553097539 -122.406329594845 (37.7490553097539, -122.406329594845) 10 4 7 28859 19
142091 234885 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 16 Sidewalk: Property side : Yard Tree Private 2     7     6010529.65259 2100820.82881 37.7490476799194 -122.406373016826 (37.7490476799194, -122.406373016826) 10 4 7 28859 19
146008 234876 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 7 Sidewalk: Property side : Yard Tree Private 2     27     6010649.76891 2100846.09542 37.7491237751432 -122.405959431208 (37.7491237751432, -122.405959431208) 10 4 7 28859 19
165442 234871 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 1 Sidewalk: Property side : Yard Tree Private 2     17     6010740.98958 2100867.24575 37.7491869507297 -122.405645476962 (37.7491869507297, -122.405645476962) 10 4 7 28859 19
182229 234877 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 8 Sidewalk: Property side : Yard Tree Private 2     38     6010643.54009 2100844.31084 37.7491185267072 -122.405980844948 (37.7491185267072, -122.405980844948) 10 4 7 28859 19
37565 125723 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     38 Width 4ft   6003539.04242 2117994.60754 37.7958091249389 -122.431772623315 (37.7958091249389, -122.431772623315) 13 9 1 57 17
47415 125722 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     43 Width 4ft   6003540.89789 2117978.17849 37.7957641201722 -122.431765029446 (37.7957641201722, -122.431765029446) 13 9 1 57 17
49152 125724 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     35 Width 4ft   6003536.06003 2118009.60299 37.7958501295278 -122.431784014136 (37.7958501295278, -122.431784014136) 13 9 1 57 17
166467 125725 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     36 Width 4ft   6003533.81623 2118024.94741 37.7958921341649 -122.431792874238 (37.7958921341649, -122.431792874238) 13 9 1 57 17
142556 256880 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 2701 Alemany Blvd 1 Side Yard : Yard Tree Private 2       10x10   5997600 2087902 37.7128438731446 -122.450152604107 (37.7128438731446, -122.450152604107) 9 7 6 28861 25
86942 103067 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 255 Broadway 6 Sidewalk: Curb side : Cutout Tree Private 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
66019 249894 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 230 Greenwich St 30 Back Yard : Yard Tree Private 2     24 Width 0ft   6011403.76038 2120447.63681 37.8029872221404 -122.404731874586 (37.8029872221404, -122.404731874586) 3 1 10 28860 6
77598 249893 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 230 Greenwich St 29 Back Yard : Yard Tree Private 2     13 Width 0ft   6011394.80053 2120441.53452 37.8029699659579 -122.404762450627 (37.8029699659579, -122.404762450627) 3 1 10 28860 6
98514 249895 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 230 Greenwich St 31 Back Yard : Yard Tree Private 2     18 Width 0ft   6011395.76102 2120447.38073 37.8029860719045 -122.404759538639 (37.8029860719045, -122.404759538639) 3 1 10 28860 6
142161 249896 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 230 Greenwich St 32 Back Yard : Yard Tree Private 2     24 Width 0ft   6011386.30387 2120437.51769 37.8029584618196 -122.404791570676 (37.8029584618196, -122.404791570676) 3 1 10 28860 6
88473 85294 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2255 Mariposa St   Sidewalk: Property side : Cutout Landscaping Private 2   07/27/2007 12:00:00 AM   2x50 Permit Number 49675 6010752 2105977 37.7632178155038 -122.405967315915 (37.7632178155038, -122.405967315915) 8 4 8 28859 19
20810 248173 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 218 Esmeralda Ave 2 Side Yard : Yard Tree Private 2     6     6007303.95131 2098726.55555 37.743116300271 -122.417379150221 (37.743116300271, -122.417379150221) 2 7 7 28859 2
80814 248172 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 218 Esmeralda Ave 1 Side Yard : Yard Tree Private 2     12     6007302.01446 2098729.32454 37.7431237943252 -122.417386043537 (37.7431237943252, -122.417386043537) 2 7 7 28859 2
6092 196018 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 22 Sidewalk: Property side : Yard Tree Private 2     15     6015632.04702 2110689.93838 37.7764302375944 -122.389417852744 (37.7764302375944, -122.389417852744) 14 3 9 310 20
10408 195999 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 3 Sidewalk: Property side : Yard Tree Private 2     16     6016051.5903 2110711.60548 37.7765129824099 -122.387968033214 (37.7765129824099, -122.387968033214) 14 3 9 310 20
23490 196012 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 16 Sidewalk: Property side : Yard Tree Private 2     16     6015764.41678 2110694.68671 37.7764506135265 -122.388960275907 (37.7764506135265, -122.388960275907) 14 3 9 310 20
30255 196014 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 18 Sidewalk: Property side : Yard Tree Private 2     17     6015720.48392 2110692.27541 37.7764415573597 -122.389112085054 (37.7764415573597, -122.389112085054) 14 3 9 310 20
32582 196000 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 4 Sidewalk: Property side : Yard Tree Private 2     17     6016029.90141 2110710.35403 37.7765083446095 -122.38804297462 (37.7765083446095, -122.38804297462) 14 3 9 310 20
37957 196010 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 14 Sidewalk: Property side : Yard Tree Private 2     17     6015807.5178 2110696.90854 37.7764591031505 -122.38881133109 (37.7764591031505, -122.38881133109) 14 3 9 310 20
39747 196021 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 25 Sidewalk: Property side : Yard Tree Private 2     20     6015567.39764 2110686.7089 37.7764177856004 -122.389641269543 (37.7764177856004, -122.389641269543) 14 3 9 310 20
49343 196013 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 17 Sidewalk: Property side : Yard Tree Private 2     17     6015743.28218 2110693.67028 37.7764466511333 -122.389033316139 (37.7764466511333, -122.389033316139) 14 3 9 310 20
68586 196022 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 26 Sidewalk: Property side : Yard Tree Private 2     21     6015549.75144 2110684.1794 37.7764098616684 -122.389702136539 (37.7764098616684, -122.389702136539) 14 3 9 310 20
80958 196006 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 10 Sidewalk: Property side : Yard Tree Private 2     14     6015895.59891 2110702.13918 37.7764783468376 -122.388506996001 (37.7764783468376, -122.388506996001) 14 3 9 310 20
81978 196007 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 11 Sidewalk: Property side : Yard Tree Private 2     15     6015874.48096 2110701.94702 37.7764766489106 -122.388580036236 (37.7764766489106, -122.388580036236) 14 3 9 310 20
84576 196011 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 15 Sidewalk: Property side : Yard Tree Private 2     16     6015786.39152 2110696.30426 37.7764562729832 -122.388884371337 (37.7764562729832, -122.388884371337) 14 3 9 310 20
87935 196005 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 9 Sidewalk: Property side : Yard Tree Private 2     15     6015919.22066 2110703.31156 37.7764828749315 -122.38842536276 (37.7764828749315, -122.38842536276) 14 3 9 310 20
100061 195998 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 2 Sidewalk: Property side : Yard Tree Private 2     18     6016075.49067 2110714.30849 37.7765217283366 -122.387885542896 (37.7765217283366, -122.387885542896) 14 3 9 310 20
121735 196003 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 7 Sidewalk: Property side : Yard Tree Private 2     16     6015962.95079 2110705.93329 37.7764924967751 -122.388274269443 (37.7764924967751, -122.388274269443) 14 3 9 310 20
126204 196009 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 13 Sidewalk: Property side : Yard Tree Private 2     16     6015830.73834 2110698.70731 37.776465329147 -122.388731129538 (37.776465329147, -122.388731129538) 14 3 9 310 20
137112 196001 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 5 Sidewalk: Property side : Yard Tree Private 2     4     6016008.12939 2110708.52586 37.7765021186104 -122.388118163334 (37.7765021186104, -122.388118163334) 14 3 9 310 20
138177 196019 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 23 Sidewalk: Property side : Yard Tree Private 2     17     6015611.09455 2110687.68162 37.7764228793455 -122.389490176245 (37.7764228793455, -122.389490176245) 14 3 9 310 20
145197 196008 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 12 Sidewalk: Property side : Yard Tree Private 2     15     6015854.16157 2110700.296 37.7764709894889 -122.388650212137 (37.7764709894889, -122.388650212137) 14 3 9 310 20
155750 196017 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 21 Sidewalk: Property side : Yard Tree Private 2     16     6015653.37625 2110690.3321 37.776432501193 -122.389344095768 (37.776432501193, -122.389344095768) 14 3 9 310 20
158107 196020 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 24 Sidewalk: Property side : Yard Tree Private 2     18     6015589.15281 2110687.71234 37.7764217471115 -122.38956608172 (37.7764217471115, -122.38956608172) 14 3 9 310 20
169789 196016 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 20 Sidewalk: Property side : Yard Tree Private 2     15     6015678.42156 2110690.23877 37.7764336334278 -122.389257449686 (37.7764336334278, -122.389257449686) 14 3 9 310 20
175828 195997 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 1 Sidewalk: Property side : Yard Tree Private 2     23     6016094.12732 2110713.51522 37.776520582607 -122.387821017432 (37.776520582607, -122.387821017432) 14 3 9 310 20
184380 196015 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 19 Sidewalk: Property side : Yard Tree Private 2     17     6015698.09519 2110690.66596 37.7764358970472 -122.389189422279 (37.7764358970472, -122.389189422279) 14 3 9 310 20
185058 196002 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 6 Sidewalk: Property side : Yard Tree Private 2     18     6015985.51722 2110706.09628 37.7764941946745 -122.388196216398 (37.7764941946745, -122.388196216398) 14 3 9 310 20
191532 196004 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 8 Sidewalk: Property side : Yard Tree Private 2     16     6015940.35109 2110704.12187 37.7764862707572 -122.388352322497 (37.7764862707572, -122.388352322497) 14 3 9 310 20
32210 195994 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2101 Newcomb Ave 3 Side Yard : Yard Tree Private 2     20 Width 3ft   6012438.11131 2097750.05558 37.7407225675882 -122.39955794175 (37.7407225675882, -122.39955794175) 10 3 8 58 1
93753 195995 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2101 Newcomb Ave 4 Side Yard : Yard Tree Private 2     23 Width 3ft   6012483.54441 2097715.89022 37.7406312890986 -122.399398452383 (37.7406312890986, -122.399398452383) 10 3 8 58 1
115902 195996 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2101 Newcomb Ave 5 Side Yard : Yard Tree Private 2     14 Width 3ft   6012499.27572 2097703.95349 37.7405993901482 -122.399343221431 (37.7405993901482, -122.399343221431) 10 3 8 58 1
189964 195993 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2101 Newcomb Ave 2 Side Yard : Yard Tree Private 2     23 Width 3ft   6012429.27896 2097757.0265 37.7407412159349 -122.399588970171 (37.7407412159349, -122.399588970171) 10 3 8 58 1
15414 96980 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 2090@Buchanan Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25529 6003561 2117963 37.7957235834131 -122.431694388271 (37.7957235834131, -122.431694388271) 13 9 1 57 17
74255 96979 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 2090@Buchanan Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25529 6003561 2117963 37.7957235834131 -122.431694388271 (37.7957235834131, -122.431694388271) 13 9 1 57 17
123430 96984 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 2090@Buchanan Vallejo St 7 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25529 6003561 2117963 37.7957235834131 -122.431694388271 (37.7957235834131, -122.431694388271) 13 9 1 57 17
171267 96981 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 2090@Buchanan Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25529 6003561 2117963 37.7957235834131 -122.431694388271 (37.7957235834131, -122.431694388271) 13 9 1 57 17
187717 96978 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 2090@Buchanan Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25529 6003561 2117963 37.7957235834131 -122.431694388271 (37.7957235834131, -122.431694388271) 13 9 1 57 17
127 119777 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 12 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
248 119766 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 1 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
431 119778 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 13 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
14005 119780 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 15 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
56641 119767 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 2 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
62466 119770 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 5 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
104758 119774 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 9 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
106853 119772 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 7 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
113742 119769 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 4 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
119609 119771 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 6 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
153309 119768 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 3 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
158897 119775 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 10 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
178614 119779 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 14 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
179144 119773 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 8 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
187388 119776 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 11 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
44966 244263 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 4 Median : Cutout Tree DPW 1     5 Width 0ft   6005610.4338 2110073.0988 37.7741758216851 -122.424041609468 (37.7741758216851, -122.424041609468) 7 9 11 28852 10
61977 244407 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 13 Median : Cutout Tree DPW 1     8 Width 0ft   6005584.4651 2110232.73 37.774612664125 -122.424142794808 (37.774612664125, -122.424142794808) 7 9 11 28852 10
77096 244403 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 9 Median : Cutout Tree DPW 1     7 Width 0ft   6005596.6857 2110150.2412 37.7743868598384 -122.424094653801 (37.7743868598384, -122.424094653801) 7 9 11 28852 10
85065 244266 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 7 Median : Cutout Tree DPW 1     4 Width 0ft   6005600.5046 2110125.0362 37.7743178686238 -122.424079650665 (37.7743178686238, -122.424079650665) 7 9 11 28852 10
98854 244404 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 10 Median : Cutout Tree DPW 1     8 Width 0ft   6005594.3943 2110164.7531 37.7744265766299 -122.424103612435 (37.7744265766299, -122.424103612435) 7 9 11 28852 10
100001 244261 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 2 Median : Cutout Tree DPW 1     5 Width 0ft   6005613.489 2110034.9096 37.7740711358709 -122.424028324662 (37.7740711358709, -122.424028324662) 7 9 11 28852 10
101044 244406 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 12 Median : Cutout Tree DPW 1     12 Width 0ft   6005586.7565 2110217.4543 37.7745708501281 -122.424133781799 (37.7745708501281, -122.424133781799) 7 9 11 28852 10
112727 244265 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 6 Median : Cutout Tree DPW 1     9 Width 0ft   6005602.0322 2110112.8157 37.7742844003359 -122.42407349717 (37.7742844003359, -122.42407349717) 7 9 11 28852 10
116865 244408 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 14 Median : Cutout Tree DPW 1     10 Width 0ft   6005581.41 2110245.7143 37.7746481433715 -122.424154286626 (37.7746481433715, -122.424154286626) 7 9 11 28852 10
124424 244402 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 8 Median : Cutout Tree DPW 1     5 Width 0ft   6005599.7408 2110138.7844 37.7743555747298 -122.424083270702 (37.7743555747298, -122.424083270702) 7 9 11 28852 10
127892 244264 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 5 Median : Cutout Tree DPW 1     6 Width 0ft   6005607.3787 2110087.6108 37.7742154956389 -122.424053209833 (37.7742154956389, -122.424053209833) 7 9 11 28852 10
136053 244405 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 11 Median : Cutout Tree DPW 1     10 Width 0ft   6005589.0478 2110200.651 37.7745248417047 -122.424124660487 (37.7745248417047, -122.424124660487) 7 9 11 28852 10
147228 244262 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 3 Median : Cutout Tree DPW 1     5 Width 0ft   6005612.7252 2110055.5318 37.7741277163216 -122.424032433594 (37.7741277163216, -122.424032433594) 7 9 11 28852 10
148940 244260 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 1 Median : Cutout Tree DPW 1     7 Width 0ft   6005614.2528 2110021.9252 37.7740355269714 -122.424024758994 (37.7740355269714, -122.424024758994) 7 9 11 28852 10
187951 244409 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 15 Median : Cutout Tree DPW 1     15 Width 0ft   6005580.6462 2110260.99 37.7746900436181 -122.424158015373 (37.7746900436181, -122.424158015373) 7 9 11 28852 10
29793 195970 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 16 Back Yard : Yard Tree Private 2     8     6015399.1088 2100325.42161 37.7479585928282 -122.389499659601 (37.7479585928282, -122.389499659601)   3 8 58 1
41514 195974 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 20 Back Yard : Yard Tree Private 2     12 Width 4ft   6015315.44713 2100317.81293 37.7479330619596 -122.389788429193 (37.7479330619596, -122.389788429193)   3 8 58 1

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