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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16424 | 16424 | 19949 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 25ST | ||||||||
16454 | 16454 | 20294 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
16608 | 16608 | 19951 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
16721 | 16721 | 19947 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 25ST | ||||||||
16878 | 16878 | 19909 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 120ST | ||||||||
17092 | 17092 | 19978 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY45 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 30ST | ||||||||
18087 | 18087 | 21247 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2401X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985051.1945321 | 2098862.1753589 | 37.7422115377949 | -122.49433209823401 | (37.7422115377949, -122.494332098234) | |||
18718 | 18718 | 21167 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5985027.9083074005 | 2099542.6271361 | 37.744078511576 | -122.49446276258301 | (37.744078511576, -122.494462762583) | |||
19244 | 19244 | 20545 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
19606 | 19606 | 21428 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2692X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
19643 | 19643 | 21239 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2401X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985051.1945321 | 2098862.1753589 | 37.7422115377949 | -122.49433209823401 | (37.7422115377949, -122.494332098234) | |||
19685 | 19685 | 92559 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52905 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | |||
20621 | 20621 | 21114 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985004.6737667 | 2100227.1692458 | 37.745956718592794 | -122.494593556276 | (37.7459567185928, -122.494593556276) | |||
22920 | 22920 | 251148 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22923 | 22923 | 251152 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22924 | 22924 | 251154 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22925 | 22925 | 251150 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22927 | 22927 | 251157 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22928 | 22928 | 251155 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22929 | 22929 | 251156 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22930 | 22930 | 251151 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22931 | 22931 | 251158 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22932 | 22932 | 251153 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22933 | 22933 | 251149 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
22934 | 22934 | 251159 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
23006 | 23006 | 5050 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 6001979.62541 | 2098516.88417 | 37.7422395880754 | -122.43577421703002 | (37.7422395880754, -122.43577421703) | ||||
23021 | 23021 | 5047 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 6002007.86459 | 2098449.21717 | 37.7420553943514 | -122.43567173476002 | (37.7420553943514, -122.43567173476) | ||||
23106 | 23106 | 5048 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 6002000.04243 | 2098472.35983 | 37.7421184943815 | -122.435700436623 | (37.7421184943815, -122.435700436623) | ||||
23130 | 23130 | 5046 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 6002013.964380001 | 2098440.0292 | 37.7420305128012 | -122.43564998647 | (37.7420305128012, -122.43564998647) | ||||
23272 | 23272 | 5052 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 6001966.9976699995 | 2098545.79058 | 37.742318241009606 | -122.43581994754999 | (37.7423182410096, -122.43581994755) | ||||
23275 | 23275 | 5049 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 39 | 6001985.29603 | 2098499.31047 | 37.7421916569134 | -122.43575335275101 | (37.7421916569134, -122.435753352751) | ||||
23290 | 23290 | 5051 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 6001971.36584 | 2098533.18854 | 37.7422838868872 | -122.43580394232 | (37.7422838868872, -122.43580394232) | ||||
24119 | 24119 | 184645 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3430 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 0ft | 5983573.582 | 2103608.0944 | 37.7551559377943 | -122.49979184963699 | (37.7551559377943, -122.499791849637) | |||
24419 | 24419 | 20488 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1204 Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
28418 | 28418 | 20917 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984934.4009631 | 2102260.4913733 | 37.75153555211671 | -122.494986448304 | (37.7515355521167, -122.494986448304) | |||
30531 | 30531 | 21160 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985027.9083074005 | 2099542.6271361 | 37.744078511576 | -122.49446276258301 | (37.744078511576, -122.494462762583) | |||
35574 | 35574 | 206878 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 15 Belmont Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5996722.9126 | 2106147.11856 | 37.762890304760205 | -122.454501283825 | (37.7628903047602, -122.454501283825) | |||
40530 | 40530 | 205896 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 88 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995555.85476 | 2096185.3340599998 | 37.73547073996521 | -122.457816813517 | (37.7354707399652, -122.457816813517) | |||
40580 | 40580 | 223723 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2900 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010018.43827 | 2101654.33057 | 37.751307680712294 | -122.40819958573499 | (37.7513076807123, -122.408199585735) | |||
41645 | 41645 | 206879 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 15 Belmont Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5996709.23846 | 2106155.1061299997 | 37.7629114523342 | -122.45454915471599 | (37.7629114523342, -122.454549154716) | |||
42268 | 42268 | 53726 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1972 12:00:00 AM | 8 | Permit Number 9405 | 6012451.87174 | 2095251.14558 | 37.733861851932296 | -122.399334980939 | (37.7338618519323, -122.399334980939) | ||
43485 | 43485 | 20515 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1211X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
44566 | 44566 | 21326 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985074.890734901 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | |||
45340 | 45340 | 20906 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984934.4009631 | 2102260.4913733 | 37.75153555211671 | -122.494986448304 | (37.7515355521167, -122.494986448304) | |||
49800 | 49800 | 206806 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 175 Garcia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 44 | Width 4ft | 5994639.44486 | 2099406.32417 | 37.7442620887181 | -122.461218572898 | (37.7442620887181, -122.461218572898) | |||
50101 | 50101 | 121189 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000x Duncan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
52925 | 52925 | 21108 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5985004.6737667 | 2100227.1692458 | 37.745956718592794 | -122.494593556276 | (37.7459567185928, -122.494593556276) | |||
53596 | 53596 | 21025 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.49472533299699 | (37.7478054765444, -122.494725332997) | |||
58969 | 58969 | 20977 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2002X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
66637 | 66637 | 20618 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1492X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984803.7392562 | 2105036.6950477003 | 37.759150589029495 | -122.495643037613 | (37.7591505890295, -122.495643037613) | |||
67562 | 67562 | 20729 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984865.3499442 | 2104298.7792233997 | 37.7571280850658 | -122.49537554020701 | (37.7571280850658, -122.495375540207) | |||
72114 | 72114 | 223768 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 340 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007779.74156 | 2105912.97739 | 37.762875341838004 | -122.41624286402 | (37.762875341838, -122.41624286402) | |||
72965 | 72965 | 99863 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 681 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 5981324.99313 | 2111098.19167 | 37.7755893711796 | -122.508123883044 | (37.7755893711796, -122.508123883044) | ||||
74389 | 74389 | 21381 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | |||
76219 | 76219 | 248488 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 772 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5999103.5198 | 2107851.3675 | 37.7677059906434 | -122.44639023232 | (37.7677059906434, -122.44639023232) | |||
77330 | 77330 | 20837 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | |||
77359 | 77359 | 12466 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
77466 | 77466 | 110865 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 838 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 6x9 | 5985433.60853 | 2110167.44818 | 37.7732750611072 | -122.49384278286699 | (37.7732750611072, -122.493842782867) | |||
77616 | 77616 | 21117 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985004.6737667 | 2100227.1692458 | 37.745956718592794 | -122.494593556276 | (37.7459567185928, -122.494593556276) | |||
77754 | 77754 | 21175 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985027.9083074005 | 2099542.6271361 | 37.744078511576 | -122.49446276258301 | (37.744078511576, -122.494462762583) | |||
77826 | 77826 | 20716 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984865.3499442 | 2104298.7792233997 | 37.7571280850658 | -122.49537554020701 | (37.7571280850658, -122.495375540207) | |||
77957 | 77957 | 20834 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | |||
78034 | 78034 | 20777 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984888.092725 | 2103630.7874996 | 37.7552952964732 | -122.49524762816002 | (37.7552952964732, -122.49524762816) | |||
78072 | 78072 | 120919 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 198X Miraloma Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x10 | 5994595.0 | 2096392.0 | 37.7359829456919 | -122.461153801837 | (37.7359829456919, -122.461153801837) | |||
78243 | 78243 | 21452 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | |||
78443 | 78443 | 12480 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
78476 | 78476 | 12483 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
78564 | 78564 | 21038 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.49472533299699 | (37.7478054765444, -122.494725332997) | |||
78625 | 78625 | 20733 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984865.3499442 | 2104298.7792233997 | 37.7571280850658 | -122.49537554020701 | (37.7571280850658, -122.495375540207) | |||
78630 | 78630 | 85239 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 200 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2007 12:00:00 AM | Permit Number 49542 | 5994792.0 | 2096029.0 | 37.7349975719357 | -122.460446404237 | (37.7349975719357, -122.460446404237) | |||
79291 | 79291 | 20762 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1692X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984807.486919099 | 2103677.7923597 | 37.755419639160706 | -122.495529849669 | (37.7554196391607, -122.495529849669) | |||
79366 | 79366 | 20549 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
79640 | 79640 | 20909 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984934.4009631 | 2102260.4913733 | 37.75153555211671 | -122.494986448304 | (37.7515355521167, -122.494986448304) | |||
79781 | 79781 | 122494 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 69x Bonview St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007716.0 | 2099172.0 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | ||||
79934 | 79934 | 12458 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
80047 | 80047 | 20786 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984888.092725 | 2103630.7874996 | 37.7552952964732 | -122.49524762816002 | (37.7552952964732, -122.49524762816) | |||
80125 | 80125 | 20902 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984934.4009631 | 2102260.4913733 | 37.75153555211671 | -122.494986448304 | (37.7515355521167, -122.494986448304) | |||
80493 | 80493 | 20915 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 60 | 5984934.4009631 | 2102260.4913733 | 37.75153555211671 | -122.494986448304 | (37.7515355521167, -122.494986448304) | |||
80495 | 80495 | 92565 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Stanyan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52905 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | |||
80647 | 80647 | 20806 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1792X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.49540321629601 | (37.7535582155387, -122.495403216296) | |||
80727 | 80727 | 21384 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | |||
80754 | 80754 | 20751 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1692X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984807.486919099 | 2103677.7923597 | 37.755419639160706 | -122.495529849669 | (37.7554196391607, -122.495529849669) | |||
80775 | 80775 | 21364 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2592X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
80825 | 80825 | 20808 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1792X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.49540321629601 | (37.7535582155387, -122.495403216296) | |||
81048 | 81048 | 20479 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1203X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
81070 | 81070 | 21037 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.49472533299699 | (37.7478054765444, -122.494725332997) | |||
81188 | 81188 | 21005 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2003X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984964.2584556 | 2101570.8346889 | 37.7496436917689 | -122.49483235574101 | (37.7496436917689, -122.494832355741) | |||
81281 | 81281 | 12469 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
81317 | 81317 | 20811 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1792X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.49540321629601 | (37.7535582155387, -122.495403216296) | |||
81424 | 81424 | 21179 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985027.9083074005 | 2099542.6271361 | 37.744078511576 | -122.49446276258301 | (37.744078511576, -122.494462762583) | |||
81466 | 81466 | 21517 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | 5985158.491992299 | 2096224.0649069 | 37.7349742721437 | -122.49376674256901 | (37.7349742721437, -122.493766742569) | |||
81772 | 81772 | 21027 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.49472533299699 | (37.7478054765444, -122.494725332997) | |||
81882 | 81882 | 21106 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985004.6737667 | 2100227.1692458 | 37.745956718592794 | -122.494593556276 | (37.7459567185928, -122.494593556276) | |||
82138 | 82138 | 21224 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2392X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
82157 | 82157 | 20474 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1203X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
82208 | 82208 | 21162 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985027.9083074005 | 2099542.6271361 | 37.744078511576 | -122.49446276258301 | (37.744078511576, -122.494462762583) | |||
82291 | 82291 | 20905 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984934.4009631 | 2102260.4913733 | 37.75153555211671 | -122.494986448304 | (37.7515355521167, -122.494986448304) | |||
82607 | 82607 | 21184 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5985027.9083074005 | 2099542.6271361 | 37.744078511576 | -122.49446276258301 | (37.744078511576, -122.494462762583) | |||
82736 | 82736 | 20776 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984888.092725 | 2103630.7874996 | 37.7552952964732 | -122.49524762816002 | (37.7552952964732, -122.49524762816) | |||
82820 | 82820 | 21286 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2492X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) |
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");