trees
145 rows where Fire Prevention Districts = 1 and qSpecies_id = 35 sorted by qSiteInfo
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | |
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 | |
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 | |||
165137 | 101040 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1010X Portola Dr | 14 | 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 | |||
183595 | 101034 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1010X Portola Dr | 8 | Front Yard : Yard | Tree | DPW 1 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||||
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 | ||||
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 | |||
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 | |
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 | |||
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 | ||||
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 | |
166211 | 211005 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 4ft | 5996562.64616 | 2099171.26049 | 37.7437271539842 | -122.454551615288 | (37.7437271539842, -122.454551615288) | 1 | 7 | 4 | 59 | 40 | |||
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 | ||||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||||
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 | ||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||||
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 | |||
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 | |||||
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 | ||
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 | ||
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 | ||||
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 | ||||
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 | ||||
162497 | 211001 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Portola Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996755.51144 | 2099350.67627 | 37.7442308453761 | -122.45389769125 | (37.7442308453761, -122.45389769125) | 1 | 7 | 4 | 59 | 40 | |||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | ||||
163611 | 114372 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 821 GONZALEZ DR | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988453 | 2089765 | 37.7174315222235 | -122.481903612061 | (37.7174315222235, -122.481903612061) | 1 | 8 | 4 | 64 | 14 | ||||
168170 | 211033 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 417 Dewey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5995123.84893 | 2100332.44688 | 37.7468328556504 | -122.459610683101 | (37.7468328556504, -122.459610683101) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );