Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
71402 | 71402 | 211176 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 792 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 2ft | 5994165.53492 | 2089952.8107099999 | 37.71827777448029 | -122.462171779599 | (37.7182777744803, -122.462171779599) | |||
72585 | 72585 | 20673 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1501X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.49558761620101 | (37.7589182591611, -122.495587616201) | |||
74227 | 74227 | 96113 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 229 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767768 | 5982054.02521 | 2112599.84865 | 37.779755411650704 | -122.505713372558 | (37.7797554116507, -122.505713372558) |
76137 | 76137 | 21458 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2701X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | |||
77320 | 77320 | 122488 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 69x Bonview St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007716.0 | 2099172.0 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | ||||
77701 | 77701 | 20565 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1392X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984737.8310875995 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | |||
77759 | 77759 | 21450 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2701X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | |||
78201 | 78201 | 20481 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
78379 | 78379 | 21066 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2192X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
78763 | 78763 | 12819 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2160 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 14x5.5 | 5988722.6241 | 2114706.8097900003 | 37.78593075537871 | -122.48279849952401 | (37.7859307553787, -122.482798499524) | |||
79030 | 79030 | 20630 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1492X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984803.7392562 | 2105036.6950477003 | 37.759150589029495 | -122.495643037613 | (37.7591505890295, -122.495643037613) | |||
79064 | 79064 | 20862 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1892X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
79185 | 79185 | 21253 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2401X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985051.1945321 | 2098862.1753589 | 37.7422115377949 | -122.49433209823401 | (37.7422115377949, -122.494332098234) | |||
79229 | 79229 | 21225 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2392X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
79249 | 79249 | 111091 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 423 GONZALEZ DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775595 | 5989758.0 | 2089186.0 | 37.715917540265 | -122.477350587483 | (37.715917540265, -122.477350587483) | |
79257 | 79257 | 21215 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2392X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
79303 | 79303 | 20666 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1501X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.49558761620101 | (37.7589182591611, -122.495587616201) | |||
79350 | 79350 | 20756 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1692X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984807.486919099 | 2103677.7923597 | 37.755419639160706 | -122.495529849669 | (37.7554196391607, -122.495529849669) | |||
79409 | 79409 | 20942 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1992X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984875.945426799 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | |||
79503 | 79503 | 20719 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1601X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984865.3499442 | 2104298.7792233997 | 37.7571280850658 | -122.49537554020701 | (37.7571280850658, -122.495375540207) | |||
79786 | 79786 | 21406 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2692X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
79885 | 79885 | 21420 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2692X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
80012 | 80012 | 21274 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2492X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) | |||
80024 | 80024 | 21417 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2692X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
80160 | 80160 | 20737 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1601X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984865.3499442 | 2104298.7792233997 | 37.7571280850658 | -122.49537554020701 | (37.7571280850658, -122.495375540207) | |||
80410 | 80410 | 20503 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
80524 | 80524 | 21340 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2592X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
80533 | 80533 | 87918 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 160 Gardenside Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50940 | 5999367.0 | 2102115.0 | 37.751970392561496 | -122.445066449965 | (37.7519703925615, -122.445066449965) | ||
80577 | 80577 | 85020 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 299 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994525.0 | 2094707.0 | 37.7313523209144 | -122.46127371080699 | (37.7313523209144, -122.461273710807) | |||||
80704 | 80704 | 20832 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1801X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | |||
80876 | 80876 | 20691 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1592X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984826.8631 | 2104357.0018991 | 37.7572856948155 | -122.49551293462 | (37.7572856948155, -122.49551293462) | |||
81031 | 81031 | 20903 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1901X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984934.4009631 | 2102260.4913733 | 37.75153555211671 | -122.494986448304 | (37.7515355521167, -122.494986448304) | |||
81113 | 81113 | 21272 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2492X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) | |||
81880 | 81880 | 110591 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1160X PORTOLA DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994964.0 | 2098019.0 | 37.7404715144277 | -122.459995857341 | (37.7404715144277, -122.459995857341) | ||||
81918 | 81918 | 102229 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 254 WINDING WAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 6x9 | 6001720.0 | 2086577.5 | 37.709441995804795 | -122.435817862229 | (37.7094419958048, -122.435817862229) | |||
81927 | 81927 | 20798 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1792X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.49540321629601 | (37.7535582155387, -122.495403216296) | |||
82043 | 82043 | 21219 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2392X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
82085 | 82085 | 21354 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2592X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
82215 | 82215 | 95686 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 373 Castenada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2011 12:00:00 AM | Permit Number 56980 | 5993476.3 | 2100002.1 | 37.7458309308973 | -122.465283713064 | (37.7458309308973, -122.465283713064) | |||
82329 | 82329 | 57589 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 93 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50021 | 6001851.03848289 | 2096750.6660448 | 37.7373826596428 | -122.436092469726 | (37.7373826596428, -122.436092469726) | ||
82693 | 82693 | 20498 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
82760 | 82760 | 120597 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
82785 | 82785 | 20670 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1501X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.49558761620101 | (37.7589182591611, -122.495587616201) | |||
82811 | 82811 | 114380 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 437X SERRANO DR | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 48 | 5988907.0 | 2090368.0 | 37.7191136019865 | -122.48037847439699 | (37.7191136019865, -122.480378474397) | |||||
82867 | 82867 | 20608 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1401X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984800.4502922995 | 2105635.4093669 | 37.760794298851295 | -122.495698574627 | (37.7607942988513, -122.495698574627) | |||
83087 | 83087 | 20884 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1892X Sunset Blvd | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
83538 | 83538 | 92871 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 3600 Jackson St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53088 | 5997031.0 | 2116025.0 | 37.790030052590105 | -122.454149203806 | (37.7900300525901, -122.454149203806) | ||||
83548 | 83548 | 20660 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1501X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.49558761620101 | (37.7589182591611, -122.495587616201) | |||
83856 | 83856 | 21271 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2492X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) | |||
83887 | 83887 | 21488 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2792X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) | |||
84141 | 84141 | 120594 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
84187 | 84187 | 21423 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2692X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
84327 | 84327 | 20758 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1692X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984807.486919099 | 2103677.7923597 | 37.755419639160706 | -122.495529849669 | (37.7554196391607, -122.495529849669) | |||
84573 | 84573 | 21087 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2192X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
84948 | 84948 | 20597 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1401X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984800.4502922995 | 2105635.4093669 | 37.760794298851295 | -122.495698574627 | (37.7607942988513, -122.495698574627) | |||
84964 | 84964 | 20564 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1392X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984737.8310875995 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | |||
85037 | 85037 | 21216 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2392X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
85334 | 85334 | 21001 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2003X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984964.2584556 | 2101570.8346889 | 37.7496436917689 | -122.49483235574101 | (37.7496436917689, -122.494832355741) | |||
85410 | 85410 | 20985 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2002X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
85621 | 85621 | 21283 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2492X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) | |||
85701 | 85701 | 103993 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2425 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5x5 | 6002155.3 | 2105752.9 | 37.7621179405028 | -122.435684366446 | (37.7621179405028, -122.435684366446) | ||||
86486 | 86486 | 21510 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2800X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5985062.8642150005 | 2096221.8871717 | 37.7349626975104 | -122.494097196305 | (37.7349626975104, -122.494097196305) | |||
86561 | 86561 | 20934 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1992X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984875.945426799 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | |||
86985 | 86985 | 21105 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2201X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985004.6737667 | 2100227.1692458 | 37.745956718592794 | -122.494593556276 | (37.7459567185928, -122.494593556276) | |||
87086 | 87086 | 20486 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 36 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
87148 | 87148 | 20814 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1792X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.49540321629601 | (37.7535582155387, -122.495403216296) | |||
87179 | 87179 | 20652 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1501X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.49558761620101 | (37.7589182591611, -122.495587616201) | |||
87784 | 87784 | 21139 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2292X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
88028 | 88028 | 21137 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2292X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
88154 | 88154 | 20705 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1592X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984826.8631 | 2104357.0018991 | 37.7572856948155 | -122.49551293462 | (37.7572856948155, -122.49551293462) | |||
88307 | 88307 | 20692 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1592X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | 5984826.8631 | 2104357.0018991 | 37.7572856948155 | -122.49551293462 | (37.7572856948155, -122.49551293462) | |||
88493 | 88493 | 20768 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1692X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984807.486919099 | 2103677.7923597 | 37.755419639160706 | -122.495529849669 | (37.7554196391607, -122.495529849669) | |||
88643 | 88643 | 21322 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2501X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5985074.890734901 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | |||
88663 | 88663 | 20605 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1401X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984800.4502922995 | 2105635.4093669 | 37.760794298851295 | -122.495698574627 | (37.7607942988513, -122.495698574627) | |||
88762 | 88762 | 109961 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 115x GARCES DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 3x3 | 5989202.0 | 2088902.0 | 37.7151054701837 | -122.47925159789301 | (37.7151054701837, -122.479251597893) | |||
89112 | 89112 | 20569 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1392X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984737.8310875995 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | |||
89116 | 89116 | 21207 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2392X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
89258 | 89258 | 98822 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 373 Castenada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 56980 | 5993476.3 | 2100002.1 | 37.7458309308973 | -122.465283713064 | (37.7458309308973, -122.465283713064) | ||||
89330 | 89330 | 21140 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2292X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
89346 | 89346 | 21129 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2292X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
89604 | 89604 | 20815 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1792X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.49540321629601 | (37.7535582155387, -122.495403216296) | |||
89997 | 89997 | 106914 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1192 PAGE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | Permit Number 774208 | 6000862.8 | 2109319.8 | 37.771838263069895 | -122.440410441009 | (37.7718382630699, -122.440410441009) | ||
90124 | 90124 | 21370 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2592X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
90425 | 90425 | 20506 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1211X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
90568 | 90568 | 20629 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1492X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984803.7392562 | 2105036.6950477003 | 37.759150589029495 | -122.495643037613 | (37.7591505890295, -122.495643037613) | |||
90577 | 90577 | 20800 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1792X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.49540321629601 | (37.7535582155387, -122.495403216296) | |||
90585 | 90585 | 20901 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1901X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | 5984934.4009631 | 2102260.4913733 | 37.75153555211671 | -122.494986448304 | (37.7515355521167, -122.494986448304) | |||
90768 | 90768 | 38768 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2086 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 40635 | 5993219.31121709 | 2101288.86117635 | 37.7493492253318 | -122.46626583425699 | (37.7493492253318, -122.466265834257) | ||||
90789 | 90789 | 21107 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2201X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5985004.6737667 | 2100227.1692458 | 37.745956718592794 | -122.494593556276 | (37.7459567185928, -122.494593556276) | |||
90942 | 90942 | 114461 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 360 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993491.0 | 2100066.0 | 37.7460072318163 | -122.46523752358401 | (37.7460072318163, -122.465237523584) | ||||
91408 | 91408 | 20622 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1492X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984803.7392562 | 2105036.6950477003 | 37.759150589029495 | -122.495643037613 | (37.7591505890295, -122.495643037613) | |||
91871 | 91871 | 20813 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1792X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.49540321629601 | (37.7535582155387, -122.495403216296) | |||
91956 | 91956 | 85282 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1283 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49571 | 6006751.0 | 2119761.0 | 37.8008407409326 | -122.42078409851001 | (37.8008407409326, -122.42078409851) | ||||
91994 | 91994 | 21323 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2501X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5985074.890734901 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | |||
92102 | 92102 | 21365 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2592X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
92290 | 92290 | 20993 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2003X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984964.2584556 | 2101570.8346889 | 37.7496436917689 | -122.49483235574101 | (37.7496436917689, -122.494832355741) | |||
92503 | 92503 | 21151 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2292X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
92606 | 92606 | 20623 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1492X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 60 | 5984803.7392562 | 2105036.6950477003 | 37.759150589029495 | -122.495643037613 | (37.7591505890295, -122.495643037613) | |||
92754 | 92754 | 20904 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1901X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984934.4009631 | 2102260.4913733 | 37.75153555211671 | -122.494986448304 | (37.7515355521167, -122.494986448304) | |||
92790 | 92790 | 21497 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2792X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");