trees

334 rows where qSpecies_id = 59 sorted by qAddress

✎ 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)
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
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
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
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
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
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
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
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
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
23378 234893 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 7 Front Yard : Yard Tree Private 2     17     6010664.01336 2100659.8191 37.7486130978165 -122.405897053323 (37.7486130978165, -122.405897053323) 2 7 7 28859 2
47166 234889 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 3 Front Yard : Yard Tree Private 2     25     6010620.28496 2100677.87035 37.7486602169168 -122.406049537871 (37.7486602169168, -122.406049537871) 2 7 7 28859 2
52513 234888 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 2 Front Yard : Yard Tree Private 2     33     6010611.763 2100694.95228 37.7487066435094 -122.406080210127 (37.7487066435094, -122.406080210127) 2 7 7 28859 2
76548 234891 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 5 Front Yard : Yard Tree Private 2     12     6010619.31212 2100642.55964 37.7485632070257 -122.406050414705 (37.7485632070257, -122.406050414705) 2 7 7 28859 2
97525 234890 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 4 Front Yard : Yard Tree Private 2     14     6010623.85334 2100666.44158 37.7486290355994 -122.406036393361 (37.7486290355994, -122.406036393361) 2 7 7 28859 2
110194 234887 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 1 Front Yard : Yard Tree Private 2     15     6010600.22161 2100713.10517 37.7487558418292 -122.406121399085 (37.7487558418292, -122.406121399085) 2 7 7 28859 2
111007 234892 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 6 Front Yard : Yard Tree Private 2     18     6010653.55518 2100656.49907 37.7486033968442 -122.40593298392 (37.7486033968442, -122.40593298392) 2 7 7 28859 2
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
19788 246559 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 3 Median : Yard Tree DPW 1     6 Width 7ft   6005723.21879 2109372.62983 37.7722588698898 -122.423601653893 (37.7722588698898, -122.423601653893) 7 9 11 28852 10
24737 246562 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 6 Median : Yard Tree DPW 1     16 Width 7ft   6005708.50416 2109443.88838 37.7724536981194 -122.423657620518 (37.7724536981194, -122.423657620518) 7 9 11 28852 10
26372 246564 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 8 Median : Yard Tree DPW 1     9 Width 7ft   6005706.72335 2109459.01828 37.7724951406584 -122.423664856449 (37.7724951406584, -122.423664856449) 7 9 11 28852 10
32481 246567 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 11 Median : Yard Tree DPW 1     10 Width 7ft   6005696.09569 2109523.68249 37.7726720930872 -122.423706217176 (37.7726720930872, -122.423706217176) 7 9 11 28852 10
37967 246565 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 9 Median : Yard Tree DPW 1     11 Width 7ft   6005706.10974 2109468.40026 37.7725208666788 -122.423667646169 (37.7725208666788, -122.423667646169) 7 9 11 28852 10
67742 246560 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 4 Median : Yard Tree DPW 1     5 Width 7ft   6005720.56075 2109380.70244 37.772280885298 -122.423611422347 (37.772280885298, -122.423611422347) 7 9 11 28852 10
80487 246571 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 15 Median : Yard Tree DPW 1     10 Width 7ft   6005693.03742 2109551.27371 37.7727476792916 -122.423718758221 (37.7727476792916, -122.423718758221) 7 9 11 28852 10
81955 246558 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 2 Median : Yard Tree DPW 1     7 Width 7ft   6005725.55596 2109365.49138 37.7722394013476 -122.423593061791 (37.7722394013476, -122.423593061791) 7 9 11 28852 10
84264 246561 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 5 Median : Yard Tree DPW 1     8 Width 7ft   6005718.25772 2109387.68034 37.7722999149342 -122.423619884948 (37.7722999149342, -122.423619884948) 7 9 11 28852 10
100151 246569 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 13 Median : Yard Tree DPW 1     9 Width 7ft   6005694.60842 2109539.50826 37.772715462883 -122.423712487254 (37.772715462883, -122.423712487254) 7 9 11 28852 10
115890 246568 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 12 Median : Yard Tree DPW 1     7 Width 7ft   6005695.27816 2109533.51475 37.7726990439551 -122.423709744321 (37.7726990439551, -122.423709744321) 7 9 11 28852 10
142683 246566 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 10 Median : Yard Tree DPW 1     9 Width 7ft   6005705.41603 2109475.54193 37.772540436826 -122.423670553651 (37.772540436826, -122.423670553651) 7 9 11 28852 10
148891 246563 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 7 Median : Yard Tree DPW 1     14 Width 7ft   6005707.64026 2109451.46523 37.7724744535597 -122.423661147645 (37.7724744535597, -122.423661147645) 7 9 11 28852 10
165695 246570 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 14 Median : Yard Tree DPW 1     9 Width 7ft   6005693.82305 2109545.39115 37.7727315715478 -122.423715622299 (37.7727315715478, -122.423715622299) 7 9 11 28852 10
178785 246557 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 1 Median : Yard Tree DPW 1     11 Width 7ft   6005728.07536 2109359.17359 37.7722221964256 -122.4235838977 (37.7722221964256, -122.4235838977) 7 9 11 28852 10
78015 135666 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 3001 Divisadero St 4 Sidewalk: Curb side : Yard Tree Private 2     42 Width 9ft   6000472.49775 2118651.89467 37.7974395562567 -122.442430617479 (37.7974395562567, -122.442430617479) 13 9 1 57 17
15701 254211 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 300X Esmeralda Ave 3 Unaccepted Street : Yard Tree DPW 1                              
153116 24282 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 300X Winding Way 20 Median : Cutout Tree DPW 1     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117) 9 7 6 28861 5
73440 116094 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
80147 116095 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
118842 116091 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
145439 116093 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
154885 116096 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
170444 116097 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
177168 116092 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
148446 53540 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 308 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/1969 12:00:00 AM 24   Permit Number 6452 5994656.44022 2113376.70713 37.7826221103339 -122.462172779062 (37.7826221103339, -122.462172779062) 11 6 2 54 11
151245 255455 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 31x Garlington Ct 1 Side Yard : Yard Tree Private 2       3x3   6016454 2094669 37.7324856396877 -122.385457730704 (37.7324856396877, -122.385457730704) 10 3 8 58 1
109416 212850 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 32 Malta Dr 32 Sidewalk: Curb side : Yard Tree Private 2     32 Width 3ft   5999489.82188 2096117.1264 37.7355086796695 -122.444210754429 (37.7355086796695, -122.444210754429) 9 7 4 63 40
99978 234895 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 3255x 24th St 6 Side Yard : Cutout Tree Private 2     40 Width 10ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
1248 260958 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 3790 California St 2 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   5996359 2114633 37.786169437555 -122.456373557771 (37.786169437555, -122.456373557771) 11 6 1 54 31
17671 260957 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 3790 California St 1 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   5996359 2114633 37.786169437555 -122.456373557771 (37.786169437555, -122.456373557771) 11 6 1 54 31
63685 135663 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 3790 California St 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   5996346.46825 2114626.15487 37.7861499232377 -122.456416418905 (37.7861499232377, -122.456416418905) 11 6 1 54 31
138606 135664 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 3790 California St 3 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   5996336.60886 2114624.27331 37.7861441909595 -122.456450393471 (37.7861441909595, -122.456450393471) 11 6 1 54 31
154598 135665 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 3790 California St 4 Sidewalk: Property side : Yard Tree Private 2     16 Width 3ft   5996326.40952 2114621.95963 37.7861372526689 -122.456485512902 (37.7861372526689, -122.456485512902) 11 6 1 54 31
193664 121867 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 382 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5990303.78145 2112825.75308 37.7808577673116 -122.477190674715 (37.7808577673116, -122.477190674715) 11 6 2 55 26
28533 195986 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 7 Sidewalk: Curb side : Yard Tree Private 2     3     6018468.61509 2099561.76349 37.7460314544851 -122.378832298987 (37.7460314544851, -122.378832298987) 10 3 8 58 1
47866 195983 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 10 Sidewalk: Curb side : Yard Tree Private 2     4     6018491.3513 2099573.26629 37.7460642923356 -122.378754477939 (37.7460642923356, -122.378754477939) 10 3 8 58 1
55799 195988 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 5 Sidewalk: Curb side : Yard Tree Private 2     3     6018362.60368 2099564.59582 37.7460333862374 -122.379199073078 (37.7460333862374, -122.379199073078) 10 3 8 58 1
62379 195992 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 1 Sidewalk: Curb side : Yard Tree Private 2     5     6018320.61791 2099573.80473 37.7460563567193 -122.379344895446 (37.7460563567193, -122.379344895446) 10 3 8 58 1
64096 195982 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 11 Sidewalk: Curb side : Yard Tree Private 2     10     6018502.10258 2099556.87815 37.7460198865213 -122.378716163238 (37.7460198865213, -122.378716163238) 10 3 8 58 1
82059 195984 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 9 Sidewalk: Curb side : Yard Tree Private 2     5     6018485.16554 2099556.70792 37.7460184853642 -122.378774718093 (37.7460184853642, -122.378774718093) 10 3 8 58 1
99139 195989 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 4 Sidewalk: Curb side : Yard Tree Private 2     3     6018358.23149 2099573.02507 37.7460562901585 -122.379214777067 (37.7460562901585, -122.379214777067) 10 3 8 58 1
120240 195985 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 8 Sidewalk: Curb side : Yard Tree Private 2     5     6018474.35913 2099556.32192 37.7460168297129 -122.378812058831 (37.7460168297129, -122.378812058831) 10 3 8 58 1
127782 195991 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 2 Sidewalk: Curb side : Yard Tree Private 2     5     6018339.20952 2099575.6179 37.7460623605839 -122.379280733321 (37.7460623605839, -122.379280733321) 10 3 8 58 1
135590 195990 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 3 Sidewalk: Curb side : Yard Tree Private 2     4     6018348.89198 2099575.3229 37.7460620845153 -122.379247231793 (37.7460620845153, -122.379247231793) 10 3 8 58 1
176786 195987 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 6 Sidewalk: Curb side : Yard Tree Private 2     6     6018466.53487 2099573.76457 37.7460642923433 -122.378840325441 (37.7460642923433, -122.378840325441) 10 3 8 58 1
185083 195981 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 12 Sidewalk: Curb side : Yard Tree Private 2     7     6018524.13374 2099557.33259 37.7460223488573 -122.378640013128 (37.7460223488573, -122.378640013128) 10 3 8 58 1
4419 260950 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 460x Davis Ct 2 Side Yard : Yard Tree Private 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 6
13002 260949 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 460x Davis Ct 1 Side Yard : Yard Tree Private 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 6
215 119692 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 10 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
413 119686 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 4 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
12376 119696 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 14 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
12956 119689 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 7 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
31585 119691 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 9 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
58975 119683 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 1 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
60290 119690 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 8 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
64025 119685 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 3 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
74269 119684 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 2 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
84324 119697 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 15 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          

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