395 rows where qSpecies_id = 35 sorted by Fire Prevention Districts

View and edit SQL

Suggested facets: qLegalStatus_id, PermitNotes

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)
2100 253677 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 199X Kissling St 1 Side Yard : Cutout Tree Private 2       5x10                      
3808 20305 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 50X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
3943 87019 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 10 Osceola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49949                    
4106 19663 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 100 STAIRWAY5 62 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
5212 19664 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 100 STAIRWAY5 63 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
5625 19976 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 100 STAIRWAY45 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 30ST                      
6586 258122 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Clarendon Ave 4 Median : Cutout Tree DPW 1   05/26/2019 09:11:00 PM 3 5x5                      
6613 19666 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 100 STAIRWAY5 65 Sidewalk: Curb side : Cutout Tree DPW 1     18 60ST                      
6935 258120 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Clarendon Ave 2 Median : Cutout Tree DPW 1   05/26/2019 09:06:00 PM 3 5x5                      
7691 19980 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 100 STAIRWAY45 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 30ST                      
7975 19667 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 100 STAIRWAY5 66 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
13326 258119 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Clarendon Ave 1 Median : Cutout Tree DPW 1   05/26/2019 09:14:00 PM 3 5x5                      
13843 20301 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 50X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
14131 258121 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Clarendon Ave 3 Median : Cutout Tree DPW 1   05/26/2019 09:09:00 PM 3 5x5                      
15936 19986 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 100 STAIRWAY46 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
267 178174 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard Tree Private 2     2     5988358.3694 2089791.63303 37.717499145949 -122.482232652541 (37.717499145949, -122.482232652541) 1 8 4 64 14
1053 211003 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Portola Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996800.72253 2099394.55039 37.7443539050009 -122.453744529511 (37.7443539050009, -122.453744529511) 1 7 4 59 40
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
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
6708 256455 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2901 Sunset Blvd 4 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
7563 187388 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Sunset Blvd 74 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985049.5619 2100144.9354 37.7457335539505 -122.49443228067 (37.7457335539505, -122.49443228067) 1 8 3 29491 35
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
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
12887 185307 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2601 Sunset Blvd 32 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984973.1253 2097316.8359 37.7379638824881 -122.494488141215 (37.7379638824881, -122.494488141215) 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
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
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
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
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
23338 114378 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 842X GONZALEZ DR 3 Sidewalk: Curb side : Yard Tree Private 2     2     5988421 2089827 37.7175998975755 -122.482018759302 (37.7175998975755, -122.482018759302) 1 8 4 64 14
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
30409 185563 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2201 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984887.6667 2099768.5458 37.7446906142612 -122.494964334306 (37.7446906142612, -122.494964334306) 1 8 3 29491 35
33869 186381 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1801 Sunset Blvd 48 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984844.8943 2102435.3563 37.7520104429492 -122.495308863381 (37.7520104429492, -122.495308863381) 1 8 3 56 35
38569 181557 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Sunset Blvd 35 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984875.8554 2106073.5142 37.7620016277453 -122.495470098326 (37.7620016277453, -122.495470098326) 1 8 3 56 35
38732 186685 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1401 Sunset Blvd 42 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984734.6622 2105357.4834 37.7600273389586 -122.495905599978 (37.7600273389586, -122.495905599978) 1 8 3 56 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
41763 114139 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 1200X JUNIPERO SERRA BLVD 34 Sidewalk: Property side : Yard Tree Private 2     36     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
41826 187121 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2600 Sunset Blvd 57 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985174.7424 2097328.4139 37.7380074703554 -122.493791914706 (37.7380074703554, -122.493791914706) 1 8 3 29491 35
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
44422 94231 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 9 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 24   Permit Number 53611 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
47104 187385 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Sunset Blvd 71 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985037.3743 2100116.159 37.7456538284953 -122.494472302074 (37.7456538284953, -122.494472302074) 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
49925 211004 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5996822.63607 2099410.87592 37.7443999871842 -122.453669936126 (37.7443999871842, -122.453669936126) 1 7 4 59 40
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
53240 185023 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2701 Sunset Blvd 49 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985046.088 2096329.59 37.7352574390957 -122.494163132435 (37.7352574390957, -122.494163132435) 1 8 3 29491 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
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
55245 186890 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 39 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985200.262 2096503.3044 37.7357434330648 -122.493642900348 (37.7357434330648, -122.493642900348) 1 8 3 29491 35
56939 185562 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2201 Sunset Blvd 46 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984881.299 2099768.8111 37.7446909699364 -122.494986371806 (37.7446909699364, -122.494986371806) 1 8 3 29491 35
60102 185310 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2601 Sunset Blvd 35 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984962.2385 2097256.121 37.7377965384833 -122.494521307154 (37.7377965384833, -122.494521307154) 1 8 3 29491 35
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
61408 186038 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1900 Sunset Blvd 33 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984981.8854 2102120.1374 37.7511529582795 -122.494811896529 (37.7511529582795, -122.494811896529) 1 8 3 29491 35
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
63516 178176 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2     3     5989163.89955 2089384.56057 37.7164282485354 -122.479418571325 (37.7164282485354, -122.479418571325) 1 8 4 64 14
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
65461 185709 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2101 Sunset Blvd 41 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984908.4893 2100423.9717 37.7464914545154 -122.494940652646 (37.7464914545154, -122.494940652646) 1 8 3 29491 35
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
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
69193 186380 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1801 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984843.2782 2102467.9478 37.7520998356184 -122.495316855331 (37.7520998356184, -122.495316855331) 1 8 3 56 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
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
75002 185676 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2101 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984839.349 2100771.308 37.7474410976212 -122.495205338122 (37.7474410976212, -122.495205338122) 1 8 3 29491 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
75828 114138 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 1200X JUNIPERO SERRA BLVD 32 Sidewalk: Property side : Yard Tree Private 2   02/16/2016 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
76251 181473 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400 Sunset Blvd 33 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984918.4628 2105275.6702 37.7598134657238 -122.49526389807 (37.7598134657238, -122.49526389807) 1 8 3 56 35
77378 211002 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Portola Dr 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5996779.38475 2099373.51377 37.744294920285 -122.453816791818 (37.744294920285, -122.453816791818) 1 7 4 59 40
78181 98278 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 900 Brotherhood Way 500 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
81883 106311 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 5 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 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
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
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
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
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
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
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
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
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
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
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
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

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