1,013 rows where qSpecies_id = 42 sorted by rowid descending

View and edit SQL

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)
194166 224321 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 4078 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003404.59391 2100412.31265 37.7475248345221 -122.430982364755 (37.7475248345221, -122.430982364755) 2 4 5 63 22
194068 199334 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1240 Ingalls St 7 Sidewalk: Curb side : Cutout Tree Private 2     33 Width 3ft   6017407.70897 2093993.36114 37.7306831882733 -122.382113515049 (37.7306831882733, -122.382113515049) 10 3 8 58 1
193913 12078 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1241X La Salle Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017245.0743814 2094442.9323579 37.7319086387255 -122.382707045529 (37.7319086387255, -122.382707045529) 10 3 8 58 1
193779 4461 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1451 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6004572.77209 2100404.42204 37.7475692915908 -122.426942314243 (37.7475692915908, -122.426942314243) 2 7 5 63 22
193724 191886 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1189 La Salle Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6017618.3449 2094055.2465 37.7308647442976 -122.38138960844 (37.7308647442976, -122.38138960844) 10 3 8 58 1
193439 209060 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 183 San Benito Way 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 6ft   5992891.23985 2095499.44379 37.7334340138624 -122.466979463536 (37.7334340138624, -122.466979463536) 9 8 4 59 40
193296 113324 Permitted Site 7 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1234 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   5993019.12807809 2107069.22790191 37.76520905664 -122.467378332531 (37.76520905664, -122.467378332531) 11 8 11 56 12
192791 191975 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1322 Hudson Ave 39 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   6017399.67227 2095082.1979 37.7336724754063 -122.382217018908 (37.7336724754063, -122.382217018908) 10 3 8 58 1
192349 224318 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1664 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6009276.46755 2099693.85922 37.7458830870421 -122.410626984552 (37.7458830870421, -122.410626984552) 2 7 7 28859 2
192002 192006 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1241 Ingalls St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6017773.06159 2093908.81444 37.7304712108758 -122.380844546432 (37.7304712108758, -122.380844546432) 10 3 8 58 1
191774 224323 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 315 27th St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6004466.1603 2100134.08188 37.7468209711249 -122.42729171706 (37.7468209711249, -122.42729171706) 2 7 5 63 22
191713 97890 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 10 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     24 5x7   5994268.27564 2115530.11005 37.7885124127348 -122.463671991785 (37.7885124127348, -122.463671991785) 11 6 1 54 11
191677 191904 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1195 La Salle Ave 16 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6017421.0392 2094371.64171 37.7317226085061 -122.382093734444 (37.7317226085061, -122.382093734444) 10 3 8 58 1
191200 183101 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2247 44th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     19 Width 0ft   5982633.8386 2099812.9726 37.7446804014496 -122.502760792038 (37.7446804014496, -122.502760792038) 1 8 3 29491 35
191177 10786 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1200X Hudson Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x4   6017715.9911991 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913) 10 3 8 58 1
190985 21101 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2201X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     42 60   5985004.6737667 2100227.1692458 37.7459567185928 -122.494593556276 (37.7459567185928, -122.494593556276) 1 8 3 29491 35
190948 209081 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 95 San Benito Way 1 Sidewalk: Curb side : Yard Tree Private 2     24 Width 8ft   5992864.70303 2096101.09713 37.7350844721621 -122.467114936514 (37.7350844721621, -122.467114936514) 1 8 4 59 40
190668 10747 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1120X Hudson Ave 7 Sidewalk: Property side : Cutout Tree DPW 1     12 3X4   6017909.652863 2094654.0666341 37.7325250651963 -122.380424102302 (37.7325250651963, -122.380424102302) 10 3 8 58 1
190584 42121 Permitted Site 7 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 110 Melrose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42418 5999349.45513333 2095526.80253467 37.7338797805201 -122.44465363726 (37.7338797805201, -122.44465363726) 9 7 4 59 40
190091 224303 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 3750 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6005452.8742 2101399.0795 37.7503501176724 -122.423969691544 (37.7503501176724, -122.423969691544) 2 4 5 28859 19
189988 45055 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2311 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/23/2011 12:00:00 AM 1   Permit Number 767715 5988234.443 2099548.661 37.7442822204704 -122.483375858058 (37.7442822204704, -122.483375858058) 1 8 3 29491 35
189966 209089 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 35 San Benito Way 1 Sidewalk: Curb side : Yard Tree Private 2     23 Width 8ft   5992853.3988 2096539.51024 37.7362875923931 -122.467185884919 (37.7362875923931, -122.467185884919) 1 8 4 59 40
189825 224324 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 315 27th St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004482.86307 2100136.13243 37.7468275460626 -122.427234106495 (37.7468275460626, -122.427234106495) 2 7 5 63 22
189801 209135 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 900x Bosworth St 21 Median : Yard Tree DPW 1     21     6001010.14297 2095737.8079 37.7345537777227 -122.438927266197 (37.7345537777227, -122.438927266197) 9 7 5 63 40
189531 24280 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 300X Winding Way 18 Median : Cutout Tree DPW 1     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117) 9 7 6 28861 5
189465 10772 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1120X Hudson Ave 35 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X4   6017909.652863 2094654.0666341 37.7325250651963 -122.380424102302 (37.7325250651963, -122.380424102302) 10 3 8 58 1
189000 26907 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 10 Caine Ave 3 Median : Cutout Tree DPW 1     18 10   5997653.71656 2089718.57825 37.7178348520782 -122.450097794787 (37.7178348520782, -122.450097794787) 9 8 6 28861 24
188848 209189 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 156 Kensington Way 3 Back Yard : Yard Tree Private 2     9 Width 3ft   5994812.38667 2098544.02713 37.7419043873887 -122.460558108972 (37.7419043873887, -122.460558108972) 1 8 4 59 40
188488 224316 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 3450 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6005324.68635 2103732.49106 37.756749885806 -122.424578939078 (37.756749885806, -122.424578939078) 2 4 5 28859 19
188092 176366 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 0 Font Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     16     5989001.16217 2090698.46083 37.7200264360421 -122.480077167338 (37.7200264360421, -122.480077167338) 1 8 4 64 14
187694 29370 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 500X Bosworth St 10 Median : Cutout Tree DPW 1   07/06/2005 12:00:00 AM 3 3X3   6002650.15248 2095274.05972 37.733373604614 -122.433224085933 (37.733373604614, -122.433224085933) 2 7 5 63 40
187583 87251 Permitted Site 7 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2 Argonaut Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 50275 6008259 2086838.7 37.7105284764145 -122.413236372693 (37.7105284764145, -122.413236372693) 9 7 8 309 39
187373 142350 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 101 Anza St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5998407.064 2112615.6345 37.7807476407903 -122.449142440817 (37.7807476407903, -122.449142440817) 15 6 2 54 16
187337 105079 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 3770 24TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6004633.1 2101955.7 37.7518321521274 -122.426844164794 (37.7518321521274, -122.426844164794) 2 4 5 28862 22
187052 209151 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1205 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   5992961.66218 2107238.84664 37.765671467181 -122.467589427822 (37.765671467181, -122.467589427822) 11 8 11 56 12
186915 140906 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2309 Geary Blvd 6 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6000494.1112 2113338.3342 37.782851136695 -122.441974243422 (37.782851136695, -122.441974243422) 15 5 1 29490 41
186579 114967 Permitted Site 7 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 469 Hill St 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6003301.68334873 2103280.29729908 37.7553938131292 -122.431542939454 (37.7553938131292, -122.431542939454) 2 4 5 28862 22
186516 11985 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1200X La Salle Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1   11/05/1992 12:00:00 AM 12 3X3   6017464.4799176 2094331.6246005 37.7316151284675 -122.381940767084 (37.7316151284675, -122.381940767084) 10 3 8 58 1
186483 209134 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 900x Bosworth St 20 Median : Yard Tree DPW 1     16     6001014.70511 2095735.41705 37.7345474725699 -122.438911322111 (37.7345474725699, -122.438911322111) 9 7 5 63 40
186324 224311 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1300 San Jose Ave 41 Sidewalk: Property side : Yard Tree Private 2     16     6003371.63665 2095581.99741 37.7342600339703 -122.430751682345 (37.7342600339703, -122.430751682345) 2 7 5 63 7
186302 191965 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1322 Hudson Ave 28 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 3ft   6017513.97895 2094931.0641 37.733263804581 -122.38181131495 (37.733263804581, -122.38181131495) 10 3 8 58 1
186157 191820 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2150 24th St 1 : Tree Private 2     24 Width 3ft   6012030.38694 2102364.15145 37.753369146286 -122.401291873339 (37.753369146286, -122.401291873339) 10 3 8 28856 29
186132 223946 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 4308 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     36 Width 3ft   6001874.6261 2101202.64201 37.7496080807523 -122.436329442272 (37.7496080807523, -122.436329442272) 2 4 5 28862 22
185907 209129 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1301 Monterey Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     14 Width 2ft   5993935.33671 2094440.81242 37.7305874815164 -122.463292961705 (37.7305874815164, -122.463292961705) 9 8 4 59 40
185691 191964 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1322 Hudson Ave 23 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6017587.14065 2094853.02283 37.7330535583775 -122.381552946926 (37.7330535583775, -122.381552946926) 10 3 8 58 1
185223 10754 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1120X Hudson Ave 17 Sidewalk: Property side : Cutout Tree DPW 1     8 3X4   6017909.652863 2094654.0666341 37.7325250651963 -122.380424102302 (37.7325250651963, -122.380424102302) 10 3 8 58 1
185177 176358 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 300x Mansell St 1 Median : Cutout Tree DPW 1     24 Width 0ft   6010959.21222 2090503.85024 37.720743461909 -122.404161585696 (37.720743461909, -122.404161585696) 10 3 7 309 28
184690 4479 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1542 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6004543.28364 2099929.08192 37.7462624498637 -122.427010433384 (37.7462624498637, -122.427010433384) 2 7 5 63 22
184552 11250 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1145X Ingalls St 5 Sidewalk: Curb side : Cutout Tree DPW 1     40 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439) 10 3 8 58 1
184485 209152 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1205 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   5992964.45058 2107210.32038 37.7655933026036 -122.467577708746 (37.7655933026036, -122.467577708746) 11 8 11 56 12
184355 200228 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1079 Ingerson Ave 2 unknown : Yard Tree Private 2     7 Width 0ft   6013685.1573 2090181.4131 37.7200100518893 -122.394716195485 (37.7200100518893, -122.394716195485) 10 3 8 58 1
184335 10755 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1120X Hudson Ave 44 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X4   6017909.652863 2094654.0666341 37.7325250651963 -122.380424102302 (37.7325250651963, -122.380424102302) 10 3 8 58 1
184179 4470 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1500 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6004528.8343 2100105.60966 37.7467463372682 -122.42707296864 (37.7467463372682, -122.42707296864) 2 7 5 63 22
184010 223928 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 610 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6001275.75039 2100902.7174 37.7487505133321 -122.438378885672 (37.7487505133321, -122.438378885672) 2 4 5 28862 22
183920 22064 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2955 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2000 12:00:00 AM 3 3X3   6016002.11901 2101736.21307 37.7518657478303 -122.387512864733 (37.7518657478303, -122.387512864733) 10 3 8 28856 1
183748 82939 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 741 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM 7 3x3 Permit Number 52449 6009171.80953 2110382.94472 37.775227013061 -122.411744028881 (37.775227013061, -122.411744028881) 8 2 9 28853 34
183651 209130 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1301 Monterey Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     14 Width 2ft   5993944.42117 2094433.54647 37.7305680543596 -122.463261028572 (37.7305680543596, -122.463261028572) 9 8 4 59 40
183636 191927 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1197 La Salle Ave 20 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   6016640.54337 2094861.38898 37.7330242206729 -122.384826197671 (37.7330242206729, -122.384826197671) 10 3 8 58 1
183366 251343 Property Tree 8 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 934 Brannan St 1 Back Yard : Yard Tree Private 2       3x3   6010724 2108745 37.7708165471861 -122.406259194073 (37.7708165471861, -122.406259194073) 14 2 9 28853 34
182906 103611 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 1 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
182770 32599 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1488 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1996 12:00:00 AM 10   Permit Number 770751 5985602.7329 2105115.8853 37.7594147799348 -122.492885607985 (37.7594147799348, -122.492885607985) 1 8 3 56 35
182739 8587 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2355X Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6000490.27762 2113338.60243 37.7828516547291 -122.441987525227 (37.7828516547291, -122.441987525227) 15 5 1 29490 41
182591 11259 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1145X Ingalls St 14 Sidewalk: Curb side : Cutout Tree DPW 1     70 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439) 10 3 8 58 1
182572 209162 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 170 San Benito Way 1 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 3ft   5992852.82391 2095595.83511 37.7336964630127 -122.467119282923 (37.7336964630127, -122.467119282923) 9 8 4 59 40
182534 126593 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1903 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6004413.74304 2117671.69069 37.7949720215818 -122.428722965614 (37.7949720215818, -122.428722965614) 13 9 1 28858 27
182020 32698 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 665 Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM 11   Permit Number 37104 6008567.49434 2114513.32482 37.7865341297888 -122.414126776328 (37.7865341297888, -122.414126776328) 5 1 9 28852 36
181816 209126 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 262 Juanita Way 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   5995608.98823 2097868.7896 37.7400961484222 -122.457754887986 (37.7400961484222, -122.457754887986) 9 7 4 59 40
181753 36701 Permitted Site 7 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 3698x 19th St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1998 12:00:00 AM     Permit Number 39496 6005001.97582164 2104885.80884876 37.7598983948026 -122.425777079422 (37.7598983948026, -122.425777079422) 2 4 5 28859 19
181380 10758 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1120X Hudson Ave 43 Sidewalk: Property side : Cutout Tree DPW 1     12 3X4   6017909.652863 2094654.0666341 37.7325250651963 -122.380424102302 (37.7325250651963, -122.380424102302) 10 3 8 58 1
181098 11221 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1050X Ingalls St 7 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X4   6018130.45859 2094749.06198 37.7327980852604 -122.379667313208 (37.7327980852604, -122.379667313208) 10 3 8 58 1
180906 142421 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 10 MAYFAIR DR 36 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5997633.2625 2114522.3029 37.7859385621108 -122.451956978624 (37.7859385621108, -122.451956978624) 11 6 1 54 31
180892 126599 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 900 Larkin St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6007428.72172 2114479.43347 37.7863770443201 -122.418064254687 (37.7863770443201, -122.418064254687) 13 9 9 28858 36
180886 101392 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 305X Hickory St 1 Front Yard : Yard Tree DPW 1           6005503.9 2110451.5 37.775208804322 -122.42443704976 (37.775208804322, -122.42443704976) 7 9 11 28852 10
180385 101839 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 3815-3817 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2           6003483 2105926 37.762668556024 -122.431104719068 (37.762668556024, -122.431104719068) 15 4 5 28862 3
180371 123311 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 401 05th Ave 15 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   5994329.74669 2112644.7334 37.7805934921061 -122.463249859078 (37.7805934921061, -122.463249859078) 11 6 2 54 11
180200 11249 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1145X Ingalls St 4 Sidewalk: Curb side : Cutout Tree DPW 1   01/09/2003 12:00:00 AM 8 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439) 10 3 8 58 1
180155 122595 Permitted Site 7 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 524 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6010413.68618597 2119615.98935706 37.8006483359763 -122.408099375454 (37.8006483359763, -122.408099375454) 3 1 10 308 23
180139 11294 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1199X Ingalls St 6 Sidewalk: Curb side : Cutout Tree DPW 1   11/02/1992 12:00:00 AM 20 3X3   6017612.0195749 2093925.7037957 37.7305086962257 -122.381402471608 (37.7305086962257, -122.381402471608) 10 3 8 58 1
180081 126597 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1030 Post St 3 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6007171.31266 2114720.24088 37.7870237512868 -122.418971912538 (37.7870237512868, -122.418971912538) 13 9 10 28858 21
180037 8595 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2355X Geary Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000490.27762 2113338.60243 37.7828516547291 -122.441987525227 (37.7828516547291, -122.441987525227) 15 5 1 29490 41
179711 246870 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 3090x Market St 3 Median : Yard Tree DPW 1     11     5999943.44665 2105326.58667 37.7608215070397 -122.443303673043 (37.7608215070397, -122.443303673043) 15 5 5 28862 3
179481 142639 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 22 VANDEWATER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6009078.1452 2121326.0074 37.8052687504629 -122.412841878433 (37.8052687504629, -122.412841878433) 3 1 10 308 23
179170 22819 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 61 Turquoise Way 1 Sidewalk: Curb side : Cutout Tree Private 2     35 2X2 10/31/08 5999145.76648 2099274.26515 37.7441577943622 -122.445627242426 (37.7441577943622, -122.445627242426) 2 7 5 63 22
179111 191865 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1196 La Salle Ave 13 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6017144.98761 2094497.59744 37.7320532082933 -122.383056873302 (37.7320532082933, -122.383056873302) 10 3 8 58 1
178939 47202 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801X Clement St 4 Sidewalk: Curb side : Cutout Tree SFUSD 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
178928 191854 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 573 10th St 1 Sidewalk: Property side : Yard Tree DPW 1     24 Width 6ft tree is in ROW therefore DPW maintained 6009977.72395 2108375.30106 37.7697596664942 -122.408814503513 (37.7697596664942, -122.408814503513) 8 2 9 28853 34
178131 191825 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 295 San Bruno Ave 3 Front Yard : Yard Tree Private 2     23     6010908.23936 2107157.21106 37.7664671450633 -122.405510058844 (37.7664671450633, -122.405510058844) 8 4 8 28853 19
177842 10764 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1120X Hudson Ave 22 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X4   6017909.652863 2094654.0666341 37.7325250651963 -122.380424102302 (37.7325250651963, -122.380424102302) 10 3 8 58 1
177467 209076 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 72 San Benito Way 1 Sidewalk: Curb side : Yard Tree Private 2     29 Width 8ft   5992829.94539 2096272.00713 37.7355517419246 -122.467247528056 (37.7355517419246, -122.467247528056) 1 8 4 59 40
177405 209177 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2023 09th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5993463.1113 2101693.12534 37.7504732951261 -122.465452138611 (37.7504732951261, -122.465452138611) 1 8 4 29491 40
177293 253645 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1200x La Salle Ave 17 Sidewalk: Curb side : Cutout Tree DPW 1 Private 03/11/2006 12:00:00 AM   3x3   6017461 2094327 37.7316022380495 -122.381952476407 (37.7316022380495, -122.381952476407) 10 3 8 58 1
177240 11285 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1176X Ingalls St 24 Sidewalk: Curb side : Cutout Tree DPW 1     45 3X3   6017716.362196 2093961.1645628 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671) 10 3 8 58 1
176756 38350 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1666 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/31/1998 12:00:00 AM 0   Permit Number 40417 5981619.44120207 2103744.31851256 37.7554151050669 -122.506559824318 (37.7554151050669, -122.506559824318) 1 8 3 56 35
176646 72854 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 24 Lunado Way 4 Sidewalk: Curb side : Cutout Tree Private 2   09/26/1998 12:00:00 AM       5991516.52955398 2091408.89207172 37.7221229357531 -122.471434223035 (37.7221229357531, -122.471434223035) 9 8 4 59 40
176639 42670 Permitted Site 7 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1575 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42698 6006081.0251203 2117910.0746574 37.7957207841663 -122.422970868865 (37.7957207841663, -122.422970868865) 13 9 10 28858 32
176278 11245 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1100X Ingalls St 14 Sidewalk: Curb side : Cutout Tree DPW 1   04/02/1998 12:00:00 AM 12 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.379993586815 (37.7307473625426, -122.379993586815) 10 3 8 58 1
176276 209067 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 150 Aptos Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5992874.24807 2093944.47004 37.7291634608249 -122.466925202962 (37.7291634608249, -122.466925202962) 9 8 4 59 40
176222 10808 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1139X Hudson Ave 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X4   6017594.95201 2094772.39901 37.7328326125475 -122.381520335899 (37.7328326125475, -122.381520335899) 10 3 8 58 1
176063 191819 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 929 Rhode Island St 3 : Tree Private 2     13 Width 6ft   6011909.67827 2104067.75313 37.7580401269696 -122.401829053673 (37.7580401269696, -122.401829053673) 10 3 8 28856 29
176022 223935 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 111 Surrey St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6002262.24862 2096228.55087 37.7359724051861 -122.434633403615 (37.7359724051861, -122.434633403615) 2 7 5 63 7

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