244 rows where qCaretaker_id = 2 and qSpecies_id = 35

View and edit SQL

qCaretaker_id

  • Private · 144
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)
84561 178158 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 13 : Tree Private 2     5 Width 0ft   5993255.20411 2087840.25906 37.7124247572585 -122.465165024673 (37.7124247572585, -122.465165024673) 9 8 4 64 24
85596 87013 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1184 Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49946 6017813.5 2093492.6 37.7293305991048 -122.380675823117 (37.7293305991048, -122.380675823117) 10 3 8 58 1
87580 178149 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 20 : Tree Private 2     4 Width 0ft   5991654.66793 2087995.14516 37.712757610756 -122.470708188538 (37.712757610756, -122.470708188538) 9 8 4 64 24
87610 185118 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2850 35th Ave 1 Sidewalk: Property side : Yard Tree Private 2     21 Width 0ft   5985615.0479 2096000.8357 37.7343880441022 -122.492171858431 (37.7343880441022, -122.492171858431) 1 8 3 29491 35
88271 178133 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 4 : Tree Private 2     6 Width 0ft   5992553.46677 2087849.43624 37.7124094643071 -122.467591088862 (37.7124094643071, -122.467591088862) 9 8 4 64 24
88362 178135 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 6 : Tree Private 2     5 Width 0ft   5992385.69997 2087851.79588 37.7124062555186 -122.468171108404 (37.7124062555186, -122.468171108404) 9 8 4 64 24
88636 186468 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1601 Sunset Blvd 56 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984781.1405 2103769.7876 37.7556706898247 -122.495627747424 (37.7556706898247, -122.495627747424) 1 8 3 56 35
88779 186421 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1601 Sunset Blvd 9 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984727.9626 2104153.7573 37.756721849906 -122.495839973726 (37.756721849906, -122.495839973726) 1 8 3 56 35
89742 186435 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1601 Sunset Blvd 23 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984740.5243 2104016.8346 37.7563466338471 -122.495786431621 (37.7563466338471, -122.495786431621) 1 8 3 56 35
90257 178131 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 2 : Tree Private 2     5 Width 0ft   5992618.59421 2087849.23546 37.7124126730667 -122.467365975965 (37.7124126730667, -122.467365975965) 9 8 4 64 24
90902 194427 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 905 Minna St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008110 2110227 37.7747392032863 -122.415406037323 (37.7747392032863, -122.415406037323) 8 2 9 28853 34
90962 178141 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 12 Median : Yard Tree Private 2 DPW   5 Width 0ft   5992021.87667 2087934.24208 37.7126116138994 -122.469434578544 (37.7126116138994, -122.469434578544) 9 8 4 64 24
92103 186040 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1900 Sunset Blvd 35 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985014.7934 2102133.6877 37.7511920899125 -122.49469909774 (37.7511920899125, -122.49469909774) 1 8 3 29491 35
92672 254785 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 8 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
93290 181384 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Sunset Blvd 17 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984945.4334 2104486.2478 37.75764751046 -122.49511240858 (37.75764751046, -122.49511240858) 1 8 3 56 35
93553 178171 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 8 Sidewalk: Curb side : Yard Tree Private 2     2     5988123.04078 2089845.83927 37.7176342915553 -122.483050036443 (37.7176342915553, -122.483050036443) 1 8 4 64 14
94007 132160 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1141 Chestnut St 5 Front Yard : Yard Tree Private 2     20     6006382.37262 2120397.93248 37.8025688116636 -122.422104980572 (37.8025688116636, -122.422104980572) 5 9 1 28858 32
95623 178173 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard Tree Private 2     2     5988347.73388 2089792.82325 37.717501795356 -122.482269501364 (37.717501795356, -122.482269501364) 1 8 4 64 14
95893 184801 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1301 Sunset Blvd 62 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984720.8276 2105758.3732 37.7611272600096 -122.49598302149 (37.7611272600096, -122.49598302149) 1 8 3 56 35
96104 234476 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 784 Duncan St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   6001432.63511 2099723.41327 37.7455213464352 -122.437751929628 (37.7455213464352, -122.437751929628) 2 7 5 63 22
96966 254788 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 11 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
97315 186080 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1901 Sunset Blvd 26 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984851.2986 2101988.3321 37.7507834123081 -122.495253753816 (37.7507834123081, -122.495253753816) 1 8 3 29491 35
97343 187133 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2600 Sunset Blvd 69 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985163.4571 2097445.4987 37.7383282936023 -122.493839558913 (37.7383282936023, -122.493839558913) 1 8 3 29491 35
99863 114934 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 4400x OCEAN AVE 10 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
99999 181379 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Sunset Blvd 12 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984933.4588 2104463.134 37.7575833453331 -122.495152116603 (37.7575833453331, -122.495152116603) 1 8 3 56 35
100596 194423 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 132 Kissling St 2 Sidewalk: Curb side : Yard Tree Private 2     17 Width 5ft   6007917.867 2109077.33792 37.771571702413 -122.41598923453 (37.771571702413, -122.41598923453) 8 2 9 28853 19
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
148334 254794 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 20 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
152315 254800 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 23 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
153020 186456 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1601 Sunset Blvd 44 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984777.372 2103875.7247 37.7559613430639 -122.495648593467 (37.7559613430639, -122.495648593467) 1 8 3 56 35
153599 185439 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2300 Sunset Blvd 57 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985094.1378 2099479.3093 37.74390853381 -122.494229093058 (37.74390853381, -122.494229093058) 1 8 3 29491 35
153819 186620 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1501 Sunset Blvd 91 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984755.0749 2104355.2681 37.7572767304033 -122.495761074715 (37.7572767304033, -122.495761074715) 1 8 3 56 35
155300 178177 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 167 Vienna St 1 Sidewalk: Property side : Yard Tree Private 2     10     6004561.94872 2092421.12411 37.7256483463685 -122.426411406667 (37.7256483463685, -122.426411406667) 9 7 6 28861 5
156752 186238 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1701 Sunset Blvd 49 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984762.5292 2103340.0793 37.7544897398871 -122.495660416165 (37.7544897398871, -122.495660416165) 1 8 3 56 35
157706 178159 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 14 : Tree Private 2     5 Width 0ft   5993218.97583 2087844.63687 37.7124346884772 -122.465290557432 (37.7124346884772, -122.465290557432) 9 8 4 64 24
158532 185308 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2601 Sunset Blvd 33 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985001.1798 2097292.5499 37.7378988415191 -122.494389354717 (37.7378988415191, -122.494389354717) 1 8 3 29491 35

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