200 rows where Police Districts = 8 and qSpecies_id = 35 sorted by SiteOrder

View and edit SQL

These facets timed out: Police Districts

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)
19643 105261 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 619 GONZALEZ DR   Sidewalk: Curb side : Yard Tree Private 2     3     5988914.8 2089258.8 37.7160684695332 -122.48027037241 (37.7160684695332, -122.48027037241) 1 8 4 64 14
6387 114260 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 800x BROTHERHOOD WAY 1 Front Yard : Cutout Tree Private 2     7     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
22467 211031 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2375 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   5992617.61467 2099318.2887 37.7439038024205 -122.468203163863 (37.7439038024205, -122.468203163863) 1 8 4 29491 40
66301 178130 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 1 : Tree Private 2     7 Width 0ft   5992655.54446 2087848.4586 37.7124126730818 -122.4672382093 (37.7124126730818, -122.4672382093) 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
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
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
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
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
154769 255363 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700X Brotherhood Way 1 Median : Cutout Tree DPW 1       6x10   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
161266 114370 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 821 GONZALEZ DR 1 Sidewalk: Curb side : Yard Tree Private 2     2     5988453 2089765 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061) 1 8 4 64 14
194461 265095 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 1100 Junipero Serra Blvd 1 Side Yard : Cutout Tree Private 2       10x10   5991104 2090006 37.7182470667789 -122.472757983106 (37.7182470667789, -122.472757983106) 9 8 4 64 40
9866 178155 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 10 : Tree Private 2     6 Width 0ft   5993366.44396 2087810.43567 37.7123492834548 -122.464778384525 (37.7123492834548, -122.464778384525) 9 8 4 64 24
42301 87834 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 10 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
51083 178139 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 10 : Tree Private 2     6 Width 0ft   5992188.74587 2087889.24466 37.7124977039766 -122.468854559004 (37.7124977039766, -122.468854559004) 9 8 4 64 24
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
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
43976 178156 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 11 : Tree Private 2     5 Width 0ft   5993327.47852 2087822.82752 37.712381061909 -122.464913959129 (37.712381061909, -122.464913959129) 9 8 4 64 24
82846 178140 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 11 : Tree Private 2     6 Width 0ft   5992153.76433 2087899.91411 37.712524978625 -122.468976240883 (37.712524978625, -122.468976240883) 9 8 4 64 24
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
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
75099 178157 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 12 : Tree Private 2     7 Width 0ft   5993292.82373 2087832.959 37.712406882332 -122.465034470985 (37.712406882332, -122.465034470985) 9 8 4 64 24
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
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
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
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
164072 2266 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700X Brotherhood Way 12 Median : Cutout Tree DPW 1   04/04/2014 12:00:00 AM 22 14M Permit Number 772491 5991180.7931196 2088069.9959997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932) 1 8 4 64 14
187095 21459 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2701X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 40   5985119.0068215 2096832.7848434 37.7366433445438 -122.493948101207 (37.7366433445438, -122.493948101207) 1 8 3 29491 35
5669 185954 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2001 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984829.7049 2101412.004 37.7491997090577 -122.495285928093 (37.7491997090577, -122.495285928093) 1 8 3 29491 35
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
160793 178142 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 13 : Tree Private 2     5 Width 0ft   5991993.89623 2087943.01111 37.7126340744777 -122.469531924782 (37.7126340744777, -122.469531924782) 9 8 4 64 24
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
23395 185955 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2001 Sunset Blvd 14 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984875.9978 2101408.1817 37.7491919243755 -122.495125567093 (37.7491919243755, -122.495125567093) 1 8 3 29491 35
40897 21491 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2792X Sunset Blvd 14 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5985060.3629888 2096294.4798015 37.7351618711636 -122.49411119238 (37.7351618711636, -122.49411119238) 1 8 3 29491 35
72264 184348 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1251 Sunset Blvd 14 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984683.9949 2106431.9954 37.7629746803622 -122.496160108596 (37.7629746803622, -122.496160108596) 1 8 3 56 35
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
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
62197 94233 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 15 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
72849 91503 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 15 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
75630 184347 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1251 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984658.9334 2106421.3632 37.7629440193232 -122.496246001897 (37.7629440193232, -122.496246001897) 1 8 3 56 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
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
174956 178160 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 15 : Tree Private 2     6 Width 0ft   5993144.35627 2087854.16093 37.7124565357104 -122.465549154771 (37.7124565357104, -122.465549154771) 9 8 4 64 24
51793 211027 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 157 : Tree Private 2     4 Width 0ft   5991179.7136 2091396.79999 37.7220702434165 -122.47259762098 (37.7220702434165, -122.47259762098) 9 8 4 64 40
52379 178161 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 16 : Tree Private 2     6 Width 0ft   5993106.56964 2087853.50799 37.7124525633948 -122.465679708459 (37.7124525633948, -122.465679708459) 9 8 4 64 24
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
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
184903 178145 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 16 : Tree Private 2     4 Width 0ft   5991905.80045 2087967.06921 37.7126950404068 -122.469838159212 (37.7126950404068, -122.469838159212) 9 8 4 64 24
182077 211028 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 160 : Tree Private 2     4 Width 0ft   5991184.3391 2091378.75733 37.7220209704755 -122.472580317131 (37.7220209704755, -122.472580317131) 9 8 4 64 40
167758 211029 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 162 : Tree Private 2     5 Width 0ft   5991185.525 2091363.77787 37.7219799092267 -122.472575126241 (37.7219799092267, -122.472575126241) 9 8 4 64 40
14478 211030 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 165 : Tree Private 2     4 Width 0ft   5991183.72988 2091349.85826 37.7219415855123 -122.472580317121 (37.7219415855123, -122.472580317121) 9 8 4 64 40
61085 114124 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 1200X JUNIPERO SERRA BLVD 17 Sidewalk: Property side : Yard Tree Private 2     12     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 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
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
170410 178146 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 17 : Tree Private 2     4 Width 0ft   5991839.8077 2087981.8975 37.7127319405071 -122.47006732805 (37.7127319405071, -122.47006732805) 9 8 4 64 24
17565 181385 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984917.5854 2104501.8427 37.7576886993488 -122.495209866912 (37.7576886993488, -122.495209866912) 1 8 3 56 35
53868 91504 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 18 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
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
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
179255 254795 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 18 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
182755 178163 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 18 : Tree Private 2     5 Width 0ft   5993033.97644 2087855.75659 37.7124545499972 -122.465930773993 (37.7124545499972, -122.465930773993) 9 8 4 64 24
68405 185535 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2201 Sunset Blvd 19 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984921.0973 2100070.748 37.7455223363848 -122.494871016971 (37.7455223363848, -122.494871016971) 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
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
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
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
52814 211034 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 417 Dewey Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 3ft   5995115.07777 2100328.51022 37.7468215422 -122.45964072765 (37.7468215422, -122.45964072765) 1 8 4 59 40
53879 114377 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 842X GONZALEZ DR 2 Sidewalk: Curb side : Yard Tree Private 2     2     5988421 2089827 37.7175998975755 -122.482018759302 (37.7175998975755, -122.482018759302) 1 8 4 64 14
67047 186733 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1250 Sunset Blvd 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984855.8629 2106397.0571 37.7628888152225 -122.495563108047 (37.7628888152225, -122.495563108047) 1 8 3 56 35
82197 114371 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 821 GONZALEZ DR 2 Sidewalk: Curb side : Yard Tree Private 2     2     5988453 2089765 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061) 1 8 4 64 14
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
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
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
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
170489 178175 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2     6     5989026.35056 2089515.50206 37.7167797908382 -122.47990357931 (37.7167797908382, -122.47990357931) 1 8 4 64 14
450 178165 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 20 Median : Cutout Tree Private 2     5 Width 0ft   5992928.58802 2087852.90738 37.7124406464989 -122.466294818667 (37.7124406464989, -122.466294818667) 9 8 4 64 24
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
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
18682 91505 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 21 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621) 1 8 4 64 35
25077 178166 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 21 : Tree Private 2     5 Width 0ft   5992891.51235 2087851.51661 37.7124346884767 -122.466422861421 (37.7124346884767, -122.466422861421) 9 8 4 64 24
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
184676 178150 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 21 : Tree Private 2     4 Width 0ft   5991622.99627 2087995.81221 37.7127576107372 -122.470817703474 (37.7127576107372, -122.470817703474) 9 8 4 64 24
11838 94234 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 22 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
49587 178167 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 22 : Tree Private 2     5 Width 0ft   5992858.09731 2087851.49534 37.7124327018762 -122.466538351485 (37.7124327018762, -122.466538351485) 9 8 4 64 24
65012 254798 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 22 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
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
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
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
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
167203 178168 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 23 : Tree Private 2     5 Width 0ft   5992821.74753 2087850.08942 37.712426743882 -122.466663884229 (37.712426743882, -122.466663884229) 9 8 4 64 24
11755 186875 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 24 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985206.2214 2096387.7822 37.7354265885186 -122.493613787113 (37.7354265885186, -122.493613787113) 1 8 3 29491 35
30677 178169 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 24 : Tree Private 2     6 Width 0ft   5992786.91057 2087851.54482 37.7124287295635 -122.466784396099 (37.7124287295635, -122.466784396099) 9 8 4 64 24
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
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
168039 21429 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2692X Sunset Blvd 26 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054) 1 8 3 29491 35
15433 186081 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1901 Sunset Blvd 27 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984821.8866 2101948.8735 37.7506733477582 -122.495352551899 (37.7506733477582, -122.495352551899) 1 8 3 29491 35
67535 211010 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500 Junipero Serra Blvd 27 : Tree Private 2     3 Width 0ft   5991339.10103 2093646.61822 37.7282569100089 -122.472210579766 (37.7282569100089, -122.472210579766) 9 8 4 64 40
173124 186878 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 27 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985170.4646 2096439.5838 37.7355667300556 -122.493741225987 (37.7355667300556, -122.493741225987) 1 8 3 29491 35
49351 21431 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2692X Sunset Blvd 28 Sidewalk: Curb side : Cutout Tree DPW 1     36 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054) 1 8 3 29491 35
186740 186440 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1601 Sunset Blvd 28 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984767.7413 2103960.7256 37.7561941679911 -122.495688168642 (37.7561941679911, -122.495688168642) 1 8 3 56 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)
);