395 rows where qSpecies_id = 35

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)
101060 185902 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2000 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985031.1855 2101301.2352 37.7489073626901 -122.494581050501 (37.7489073626901, -122.494581050501) 1 8 3 29491 35
101189 111558 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 900x BOSWORTH ST 36 Front Yard : Yard Tree DPW 1     15     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
101800 8581 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 8 Median : Cutout Tree DPW 1     24 6   6000715.1007 2113420.9091 37.7830904567466 -122.441215640748 (37.7830904567466, -122.441215640748) 15 5 1 29490 41
102914 187129 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2600 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     24 Width 0ft   5985149.8207 2097410.2322 37.7382306634066 -122.493884107972 (37.7382306634066, -122.493884107972) 1 8 3 29491 35
103504 254796 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 19 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
103704 255364 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700X Brotherhood Way 2 Median : Cutout Tree DPW 1       6x10   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
104823 181540 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984863.0454 2105869.1102 37.7614396414651 -122.495499326148 (37.7614396414651, -122.495499326148) 1 8 3 56 35
104913 185906 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2000 Sunset Blvd 49 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985026.2976 2101345.2263 37.7490278641469 -122.49460119526 (37.7490278641469, -122.49460119526) 1 8 3 29491 35
105094 96843 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 417 Dewey Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2           5995136 2100316.9 37.7467908665237 -122.459567540316 (37.7467908665237, -122.459567540316) 1 8 4 59 40
106659 111575 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1x SUNSET BLVD OFF RAMP 7 Median : Cutout Tree DPW 1     5 3x3   5984955 2095624 37.7333147463652 -122.494426056577 (37.7333147463652, -122.494426056577) 1 8 4 64 35
106955 211009 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500 Junipero Serra Blvd 25 : Tree Private 2     4 Width 0ft   5991341.55983 2093667.80622 37.728315229259 -122.472203623507 (37.728315229259, -122.472203623507) 9 8 4 64 40
107231 8560 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/1994 12:00:00 AM 6 3X3   6001214.79121 2113518.75863 37.7833875775095 -122.439493935571 (37.7833875775095, -122.439493935571) 15 5 11 29490 13
107565 252925 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Sanchez St 2 Front Yard : Yard Tree DPW 1           6003672 2104202 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181) 2 4 5 28862 3
108114 114123 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 1200X JUNIPERO SERRA BLVD 16 Sidewalk: Property side : Yard Tree Private 2     18     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
109718 87015 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 35 Whitfield Ct 2 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.381653502791 (37.7310090102049, -122.381653502791) 10 3 8 58 1
110569 8474 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1900 Geary Blvd 11 Median : Cutout Tree DPW 1     6 8   6001879.2717 2113651.882 37.7837908949329 -122.437204633286 (37.7837908949329, -122.437204633286) 13 5 11 29490 41
110654 139356 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350x GEARY BLVD 5 Median : Cutout Tree DPW 1     24 Width 0ft   6005063.0942 2114090.4032 37.7851754347521 -122.426221023287 (37.7851754347521, -122.426221023287) 13 9 11 28858 41
111520 178143 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 14 : Tree Private 2     5 Width 0ft   5991964.10718 2087949.4813 37.7126501183836 -122.4696353549 (37.7126501183836, -122.4696353549) 9 8 4 64 24
112575 8469 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1900 Geary Blvd 6 Median : Cutout Tree DPW 1     48 8   6002244.0904 2113695.2 37.7839305664786 -122.435945599699 (37.7839305664786, -122.435945599699) 13 5 11 29490 41
112823 211025 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 95 : Tree Private 2     6 Width 0ft   5991234.71561 2092082.53367 37.7239562818437 -122.472457461651 (37.7239562818437, -122.472457461651) 9 8 4 64 40
113218 114925 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 4400x OCEAN AVE 3 Front Yard : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
113256 8561 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/1994 12:00:00 AM 6 3X3   6001214.79121 2113518.75863 37.7833875775095 -122.439493935571 (37.7833875775095, -122.439493935571) 15 5 11 29490 13
113773 111508 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 800x BOSWORTH ST 3 Front Yard : Yard Tree DPW 1     18     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
113834 243114 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 17 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001830.21459 2098656.61242 37.7426147609522 -122.436300830338 (37.7426147609522, -122.436300830338) 2 7 5 63 7
114736 185930 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2000 Sunset Blvd 73 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985039.332 2101497.8374 37.7494476553955 -122.494567371863 (37.7494476553955, -122.494567371863) 1 8 3 29491 35
115061 243111 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 13 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001795.3662 2098698.75734 37.7427285009166 -122.436424341429 (37.7427285009166, -122.436424341429) 2 7 5 63 7
116060 8575 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 2 Median : Cutout Tree DPW 1     48 6   6001093.7947 2113474.2106 37.7832583731226 -122.439909339764 (37.7832583731226, -122.439909339764) 15 5 11 29490 41
116100 185960 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2001 Sunset Blvd 19 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984855.8243 2101346.8117 37.7490222380818 -122.495190801303 (37.7490222380818, -122.495190801303) 1 8 3 29491 35
116936 100068 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 303 Serrano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2012 12:00:00 AM     Permit Number 769006 5990392 2090762 37.720281613079 -122.47527420247 (37.720281613079, -122.47527420247) 1 8 4 64 40
117654 178148 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 19 : Tree Private 2     5 Width 0ft   5991783.61367 2087988.33952 37.7127463800143 -122.470262019583 (37.7127463800143, -122.470262019583) 9 8 4 64 24
118418 200613 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 54 Median : Cutout Tree DPW 1     15 Width 0ft   6016431.4971 2095119.9571 37.7337226328106 -122.385566946165 (37.7337226328106, -122.385566946165) 10 3 8 58 1
119256 181538 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Sunset Blvd 16 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984897.5768 2105857.4141 37.761409549185 -122.495379035532 (37.761409549185, -122.495379035532) 1 8 3 56 35
119669 185964 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2001 Sunset Blvd 23 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984823.122 2101326.4259 37.7489643495953 -122.495302381208 (37.7489643495953, -122.495302381208) 1 8 3 29491 35
120441 234471 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350 Noe St 5 Sidewalk: Property side : Yard Tree Private 2     16     6003196.85258 2100348.13678 37.7473368492221 -122.431696139568 (37.7473368492221, -122.431696139568) 2 4 5 63 22
120683 255712 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 618x Mendell St 6 Front Yard : Yard Tree Private 2       3x3 Permit Number 781846 6016234 2097322 37.7397580688138 -122.386403238688 (37.7397580688138, -122.386403238688) 10 3 8 58 1
121416 185539 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2201 Sunset Blvd 23 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984878.3804 2100042.8891 37.7454433428019 -122.495016669314 (37.7454433428019, -122.495016669314) 1 8 3 29491 35
121908 178144 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 15 : Tree Private 2     4 Width 0ft   5991934.88004 2087954.77106 37.7126629535013 -122.469736757058 (37.7126629535013, -122.469736757058) 9 8 4 64 24
122237 178153 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 8 : Tree Private 2     7 Width 0ft   5993495.89449 2087748.40295 37.7121864189299 -122.464326467118 (37.7121864189299, -122.464326467118) 9 8 4 64 24
122378 101036 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1010X Portola Dr 10 Front Yard : Yard Tree DPW 1   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
122774 200572 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 42 Median : Cutout Tree DPW 1     18 Width 0ft   6016330.8681 2095450.735 37.7346253143087 -122.385937902813 (37.7346253143087, -122.385937902813) 10 3 8 58 1
122803 8535 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2100 Geary Blvd 6 Median : Cutout Tree DPW 1     18 6   6001300.5704 2113502.1304 37.7833468021346 -122.439195981768 (37.7833468021346, -122.439195981768) 15 5 11 29490 41
122904 96844 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 417 Dewey Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2           5995136 2100316.9 37.7467908665237 -122.459567540316 (37.7467908665237, -122.459567540316) 1 8 4 59 40
123187 211017 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 49 : Tree Private 2     5 Width 0ft   5991258.9422 2092457.39845 37.7249869696545 -122.472401030094 (37.7249869696545, -122.472401030094) 9 8 4 64 40
123530 186167 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1700 Sunset Blvd 52 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984926.5892 2103481.0156 37.7548863180592 -122.495103454208 (37.7548863180592, -122.495103454208) 1 8 3 56 35
123901 211026 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 138 : Tree Private 2     4 Width 0ft   5991196.61305 2091604.80622 37.7226423552448 -122.472554361808 (37.7226423552448, -122.472554361808) 9 8 4 64 40
124888 2268 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 750X Brotherhood Way 2 Median : Cutout Tree DPW 1     6 14M   5991074.0426161 2088106.2478104 37.7130290777882 -122.47272309172 (37.7130290777882, -122.47272309172) 1 8 4 64 14
125264 8348 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 14 Median : Cutout Tree DPW 1   06/08/1994 12:00:00 AM 6 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
125671 91502 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 12 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
126371 8532 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2100 Geary Blvd 3 Median : Cutout Tree DPW 1   06/10/1994 12:00:00 AM 6 6   6001535.4351 2113580.6442 37.7835757427727 -122.438389071264 (37.7835757427727, -122.438389071264) 15 5 11 29490 41
126819 257966 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 98X Clearfield Dr 1 Side Yard : Yard Tree Private 2       3x3 Permit Number 782748 5986022 2095487 37.7330009680725 -122.490727117227 (37.7330009680725, -122.490727117227) 1 8 4 64 35
126959 211020 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 74 : Tree Private 2     4 Width 0ft   5991248.48231 2092260.69315 37.7244462603628 -122.472422854829 (37.7244462603628, -122.472422854829) 9 8 4 64 40
127126 8475 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1900 Geary Blvd 12 Median : Cutout Tree DPW 1   06/03/1994 12:00:00 AM 6 8   6001831.8926 2113645.1136 37.7837696172579 -122.437368062109 (37.7837696172579, -122.437368062109) 13 5 11 29490 41
127400 187193 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2301 Sunset Blvd 55 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984945.2043 2099085.395 37.7428182353231 -122.494715027467 (37.7428182353231, -122.494715027467) 1 8 3 29491 35
127523 243106 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 9 Median : Yard Tree DPW 1   01/09/2018 12:00:00 AM 3     6001667.33897 2098826.57882 37.7430721930381 -122.436876170699 (37.7430721930381, -122.436876170699) 2 7 5 63 7
127704 4530 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 45 Cleary Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781999 6004963.1338 2113665.364 37.7840027322121 -122.426536579485 (37.7840027322121, -122.426536579485) 7 9 11 28858 41
128412 105268 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 842X GONZALEZ DR 1 Sidewalk: Curb side : Yard Tree Private 2     2     5988421 2089827 37.7175998975755 -122.482018759302 (37.7175998975755, -122.482018759302) 1 8 4 64 14
128912 184982 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2701 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984985.373 2096691.786 37.7362483795762 -122.494399733702 (37.7362483795762, -122.494399733702) 1 8 3 29491 35
129267 98161 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 600 Front St   Front Yard : Yard Tree Private 2   12/21/2011 12:00:00 AM     Permit Number 768589 6012888.4 2118392.6 37.7974274520849 -122.399449857041 (37.7974274520849, -122.399449857041) 3 1 10 28860 6
129439 4367 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 973 Chenery St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6001101.12966 2096102.69208 37.7355608412513 -122.438638832041 (37.7355608412513, -122.438638832041) 2 7 5 63 7
129810 132163 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 150 Lombard St 12 Sidewalk: Curb side : Yard Tree Private 2     16 Width 5ft   6011528.08163 2120803.57488 37.8039714887622 -122.404326723704 (37.8039714887622, -122.404326723704) 3 1 10 28860 6
129835 194424 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 132 Kissling St 3 Sidewalk: Curb side : Yard Tree Private 2     23 Width 5ft   6007931.05098 2109095.29996 37.7716217631679 -122.415944902456 (37.7716217631679, -122.415944902456) 8 2 9 28853 19
130337 186855 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 4 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985186.2801 2096278.9071 37.7351264799029 -122.49367471051 (37.7351264799029, -122.49367471051) 1 8 3 29491 35
130934 185700 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2101 Sunset Blvd 32 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984899.9898 2100515.832 37.7467431803198 -122.494976814737 (37.7467431803198, -122.494976814737) 1 8 3 29491 35
131403 200571 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 41 Median : Cutout Tree DPW 1     17 Width 0ft   6016326.461 2095462.4873 37.7346573398722 -122.385953958726 (37.7346573398722, -122.385953958726) 10 3 8 58 1
132634 94230 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Everglade Sloat Blvd 9 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 12   Permit Number 53611 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621) 1 8 4 64 35
133124 178162 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 17 : Tree Private 2     5 Width 0ft   5993072.48922 2087856.39417 37.7124585223038 -122.465797709423 (37.7124585223038, -122.465797709423) 9 8 4 64 24
133229 194425 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 132 Kissling St 4 Sidewalk: Curb side : Yard Tree Private 2     16 Width 5ft   6007938.01013 2109107.31213 37.771655137004 -122.415921681048 (37.771655137004, -122.415921681048) 8 2 9 28853 19
133423 186893 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 42 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985181.9251 2096557.8565 37.7358921458374 -122.493710315825 (37.7358921458374, -122.493710315825) 1 8 3 29491 35
133693 211016 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 46 : Tree Private 2     3 Width 0ft   5991242.43895 2092472.66575 37.7250279346749 -122.472459191965 (37.7250279346749, -122.472459191965) 9 8 4 64 40
134318 178164 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 19 : Tree Private 2     5 Width 0ft   5993000.50065 2087852.84302 37.71244461881 -122.46604626403 (37.71244461881, -122.46604626403) 9 8 4 64 24
134727 186880 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 29 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5985201.1788 2096460.2128 37.7356251686507 -122.49363655642 (37.7356251686507, -122.49363655642) 1 8 3 29491 35
134883 87835 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 11 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2008 12:00:00 AM   3x3 Permit Number 50721 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
135146 243113 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 16 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001816.52967 2098672.65474 37.7426580318326 -122.436349296602 (37.7426580318326, -122.436349296602) 2 7 5 63 7
136381 200558 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 34 Median : Cutout Tree DPW 1     8 Width 0ft   6016305.3951 2095506.8264 37.7347779203 -122.386029881179 (37.7347779203, -122.386029881179) 10 3 8 58 1
136516 27297 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 7800X Geary Blvd 4 Median : Cutout Tree Fire Dept 16   06/10/1999 12:00:00 AM 6 5X5   5982680.86392 2112396.64212 37.7792343387449 -122.503529847504 (37.7792343387449, -122.503529847504) 11 6 2 55 26
136696 98279 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 900 Brotherhood Way 501 Sidewalk: Curb side : Yard Tree Private 2   02/07/2012 12:00:00 AM     Permit Number 768594 5988860.9 2088745.5 37.7146559434524 -122.480419123791 (37.7146559434524, -122.480419123791) 1 8 4 64 14
137065 4531 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 45 Cleary Ct 2 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781999 6004996.2689 2113667.7308 37.7840111039908 -122.426422112629 (37.7840111039908, -122.426422112629) 7 9 11 28858 41
137297 211019 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 71 : Tree Private 2     3 Width 0ft   5991242.8983 2092280.74938 37.7245010065929 -122.472443619273 (37.7245010065929, -122.472443619273) 9 8 4 64 40
137465 234473 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 99 Elsie St 2 Sidewalk: Curb side : Pot Tree Private 2     16     6007295.70063 2098744.01488 37.7431637754778 -122.417408915989 (37.7431637754778, -122.417408915989) 2 7 7 28859 2
137776 178172 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 7 Sidewalk: Curb side : Yard Tree Private 2     2     5988133.68649 2089845.13121 37.7176329668754 -122.483013187625 (37.7176329668754, -122.483013187625) 1 8 4 64 14
138142 115834 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 900X LAKE MERCED BLVD 2 Median : Cutout Tree Private 2   08/30/2016 12:00:00 AM 3 10x100 Permit Number 777492 5987646 2090104 37.7183153647657 -122.484717856844 (37.7183153647657, -122.484717856844) 1 8 4 64 14
138421 243116 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 19 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001856.44522 2098624.22352 37.7425273189785 -122.436207815256 (37.7425273189785, -122.436207815256) 2 7 5 63 7
139760 94232 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 12 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 14   Permit Number 53611 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
141285 120542 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2450 California St 1 Front Yard : Yard Tree MTA 3 DPW for City Agency         6002644.10897 2115479.97736 37.7888538273233 -122.434689351726 (37.7888538273233, -122.434689351726) 13 9 1 29490 27
141624 8586 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 13 Median : Cutout Tree DPW 1     24 6   6000400.7068 2113377.2527 37.7829526738098 -122.442300177437 (37.7829526738098, -122.442300177437) 15 5 1 29490 41
141879 211032 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 297 Dorantes Ave 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5993259.54182 2099680.27875 37.7449347888095 -122.466009845078 (37.7449347888095, -122.466009845078) 1 8 4 29491 40
141899 254786 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 9 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
142106 178147 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 18 : Tree Private 2     4 Width 0ft   5991814.6494 2087985.34878 37.712739962461 -122.47015453352 (37.712739962461, -122.47015453352) 9 8 4 64 24
142428 114137 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 1200X JUNIPERO SERRA BLVD 33 Sidewalk: Property side : Yard Tree Private 2     26     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
143757 185290 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2601 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984983.8028 2097379.2257 37.738135813056 -122.494455822202 (37.738135813056, -122.494455822202) 1 8 3 29491 35
144446 178170 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Serrano Dr 4 Sidewalk: Curb side : Yard Tree Private 2     4     5989035.58475 2090454.34239 37.7193581480518 -122.479940326497 (37.7193581480518, -122.479940326497) 1 8 4 64 14
144504 254787 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 10 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
144700 118538 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 7900x Geary Blvd 1 Median : Cutout Tree DPW 1     11 Width 4ft   5982472.23583 2112389.87128 37.7792034803758 -122.504251064408 (37.7792034803758, -122.504251064408) 11 6 2 55 26
145411 254797 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 21 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
145424 211006 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 600x Portola Dr 1 Median : Cutout Tree DPW 1     6 Width 4ft   5997174.86391 2099677.95775 37.7451535147355 -122.452471281937 (37.7451535147355, -122.452471281937) 1 7 4 59 40
145727 178137 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 8 : Tree Private 2     5 Width 0ft   5992316.61451 2087859.09194 37.7124222985339 -122.468410417129 (37.7124222985339, -122.468410417129) 9 8 4 64 24
146907 243109 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 10 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001750.32805 2098751.0187 37.7428694390712 -122.436583810118 (37.7428694390712, -122.436583810118) 2 7 5 63 7
146921 186247 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1701 Sunset Blvd 58 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984819.3113 2103171.6078 37.7540304886989 -122.495451627268 (37.7540304886989, -122.495451627268) 1 8 3 56 35
147440 111557 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 900x BOSWORTH ST 35 Front Yard : Yard Tree DPW 1     12     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
147596 234475 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 378 Highland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6007368.44216 2096501.62636 37.7370107660349 -122.416998547241 (37.7370107660349, -122.416998547241) 2 7 7 28859 2

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