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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10259 | 10259 | 141190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1771 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9999 | Width 0ft | 6002407.0405 | 2112959.471 | 37.781919696317296 | -122.43532920805599 | (37.7819196963173, -122.435329208056) | |||
134826 | 134826 | 133419 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3535 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1920 | Width 3ft | 5997881.22616 | 2115448.76842 | 37.788496590783794 | -122.451165933971 | (37.7884965907838, -122.451165933971) | |||
152523 | 152523 | 223698 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 151 | 6004903.42732 | 2096771.39372 | 37.7376125150086 | -122.42554040785801 | (37.7376125150086, -122.425540407858) | ||||
140148 | 140148 | 110856 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 199x HAWTHORNE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 123 | 3x3 | 6013721.0 | 2113357.0 | 37.7836472413673 | -122.39621571824699 | (37.7836472413673, -122.396215718247) | |||
156890 | 156890 | 249999 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 121 | Width 0ft | 6011509.9435 | 2120224.2158 | 37.8023796968334 | -122.404348688764 | (37.8023796968334, -122.404348688764) | |||
50438 | 50438 | 205639 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 212 Hearst Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 105 | 5999981.368430001 | 2094392.7205 | 37.7308018951744 | -122.442387538165 | (37.7308018951744, -122.442387538165) | ||||
186127 | 186127 | 131690 | Undocumented 2 | Musa spp :: Banana 371 | 407 Vallejo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 105 | 6011485.14109 | 2119034.37122 | 37.7991112871264 | -122.40435072033199 | (37.7991112871264, -122.404350720332) | ||||
23770 | 23770 | 186402 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984820.6527 | 2102319.266 | 37.7516902715465 | -122.495384132242 | (37.7516902715465, -122.495384132242) | |||
24028 | 24028 | 186361 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984795.4735 | 2102590.7965 | 37.752434345234 | -122.495491228463 | (37.752434345234, -122.495491228463) | |||
25740 | 25740 | 187008 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984967.4388 | 2098043.05 | 37.739957538540295 | -122.49456132318899 | (37.7399575385403, -122.494561323189) | |||
77244 | 77244 | 185929 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2000 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5985012.7201 | 2101493.4926 | 37.7494341681805 | -122.494659074897 | (37.7494341681805, -122.494659074897) | |||
152584 | 152584 | 184346 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1251 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984686.7384 | 2106407.7493 | 37.7629082680796 | -122.49614883097901 | (37.7629082680796, -122.496148830979) | |||
153184 | 153184 | 185035 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5985023.8956 | 2096287.7176 | 37.7351411700064 | -122.49423677323401 | (37.7351411700064, -122.494236773234) | |||
155847 | 155847 | 186256 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 67 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984812.6153 | 2103003.1364 | 37.7535675206606 | -122.49546235883498 | (37.7535675206606, -122.495462358835) | |||
163766 | 163766 | 185074 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984997.7254 | 2096135.7209 | 37.7347222961152 | -122.49431605154301 | (37.7347222961152, -122.494316051543) | |||
167561 | 167561 | 186155 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1700 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984957.7478 | 2103324.5301 | 37.7544584761874 | -122.494984162752 | (37.7544584761874, -122.494984162752) | |||
171399 | 171399 | 184735 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984680.1977 | 2106291.6891 | 37.7625892162308 | -122.496162889393 | (37.7625892162308, -122.496162889393) | |||
149618 | 149618 | 185710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 95 | Width 0ft | 5984848.6658 | 2100421.3565 | 37.7464807716884 | -122.495147319794 | (37.7464807716884, -122.495147319794) | |||
174141 | 174141 | 217519 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 125 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 94 | Width 10ft | 5998618.10798 | 2093180.61105 | 37.72739593057529 | -122.447013334218 | (37.7273959305753, -122.447013334218) | |||
103301 | 103301 | 113895 | Undocumented 2 | Populus spp :: Poplar Spp 276 | 1x STORRIE ST | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | |||
144910 | 144910 | 113889 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1x STORRIE ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 90 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | ||||
156364 | 156364 | 185965 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 90 | Width 0ft | 5984859.6467 | 2101291.1753 | 37.748869699536904 | -122.49517348139999 | (37.7488696995369, -122.4951734814) | |||
179874 | 179874 | 186060 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 90 | Width 0ft | 5984837.0831 | 2102159.5408 | 37.7512526720721 | -122.49531553640101 | (37.7512526720721, -122.495315536401) | |||
35692 | 35692 | 209045 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 300 Melrose Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 88 | 5998032.3562900005 | 2095523.6559099997 | 37.733795893852296 | -122.44920699922599 | (37.7337958938523, -122.449206999226) | ||||
149016 | 149016 | 185997 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 87 | Width 0ft | 5984874.4912 | 2100963.0377 | 37.7479695924465 | -122.495097956423 | (37.7479695924465, -122.495097956423) | |||
183441 | 183441 | 185627 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 87 | Width 0ft | 5985046.4186 | 2100324.9202 | 37.7462275593372 | -122.494456414967 | (37.7462275593372, -122.494456414967) | |||
34443 | 34443 | 186561 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 85 | Width 0ft | 5984740.943 | 2104715.6846 | 37.758265506246296 | -122.495836533834 | (37.7582655062463, -122.495836533834) | |||
69733 | 69733 | 186694 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 85 | Width 0ft | 5984719.2741 | 2105229.7727 | 37.75967577978221 | -122.495949397724 | (37.7596757797822, -122.495949397724) | |||
76772 | 76772 | 185977 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 85 | Width 0ft | 5984864.6841 | 2101097.7224 | 37.7483388256863 | -122.495141798808 | (37.7483388256863, -122.495141798808) | |||
148127 | 148127 | 185306 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 85 | Width 0ft | 5984983.5934 | 2097312.6487 | 37.7379529982098 | -122.49445163979401 | (37.7379529982098, -122.494451639794) | |||
176677 | 176677 | 244012 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1327 Diamond St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 85 | Width 10ft | 6002018.1444 | 2100161.75754 | 37.7467582119217 | -122.43575868930799 | (37.7467582119217, -122.435758689308) | |||
55181 | 55181 | 187225 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2401 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 81 | Width 0ft | 5984926.1909 | 2098694.4361 | 37.741743654922296 | -122.494751951574 | (37.7417436549223, -122.494751951574) | |||
70399 | 70399 | 185574 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 81 | Width 0ft | 5984904.9127 | 2099653.9265 | 37.744376910333 | -122.494896252369 | (37.744376910333, -122.494896252369) | |||
26684 | 26684 | 185578 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 80 | Width 0ft | 5984888.727999999 | 2099615.9854 | 37.744271786934796 | -122.49494941784201 | (37.7442717869348, -122.494949417842) | |||
29091 | 29091 | 186379 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 80 | Width 0ft | 5984812.5721 | 2102477.6444 | 37.7521246619181 | -122.495423755128 | (37.7521246619181, -122.495423755128) | |||
55565 | 55565 | 185944 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 80 | Width 0ft | 5984848.1796 | 2101522.6398 | 37.7495045663334 | -122.49523020096001 | (37.7495045663334, -122.49523020096) | |||
147892 | 147892 | 243999 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 240 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | Width 5ft | 6004722.773990001 | 2100192.7659 | 37.746996613213796 | -122.42640854862302 | (37.7469966132138, -122.426408548623) | |||
173276 | 173276 | 247543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1101 Waller St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 80 | 6000225.31856 | 2108498.53576 | 37.7695469597628 | -122.442556551344 | (37.7695469597628, -122.442556551344) | ||||
30066 | 30066 | 178334 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 11 Pilgrim Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 79 | 6000689.70014 | 2093938.9080400001 | 37.729596178617705 | -122.439906202537 | (37.7295961786177, -122.439906202537) | ||||
70101 | 70101 | 247851 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 152 Chapman St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 79 | 6009070.86749 | 2098234.59559 | 37.7418647407582 | -122.411234858803 | (37.7418647407582, -122.411234858803) | ||||
162604 | 162604 | 186094 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 79 | Width 0ft | 5984804.2595 | 2101775.159 | 37.7501953433109 | -122.49540069682199 | (37.7501953433109, -122.495400696822) | |||
71097 | 71097 | 184768 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 78 | Width 0ft | 5984699.3735 | 2106071.8316 | 37.761986672397 | -122.496080347248 | (37.761986672397, -122.496080347248) | |||
75065 | 75065 | 186159 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1700 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 77 | Width 0ft | 5984932.8209 | 2103361.228 | 37.7545577792255 | -122.495073071066 | (37.7545577792255, -122.495073071066) | |||
162400 | 162400 | 187357 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 77 | Width 0ft | 5985072.2445 | 2099793.5247 | 37.7447700029853 | -122.494327950417 | (37.7447700029853, -122.494327950417) | |||
55184 | 55184 | 187026 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 76 | Width 0ft | 5984957.5185 | 2097874.0689 | 37.7394929812704 | -122.49458316876199 | (37.7394929812704, -122.494583168762) | |||
93026 | 93026 | 104163 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 2127 12TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 76 | 4x3 | Permit Number 770670 | 5992542.0 | 2100965.0 | 37.748420883115294 | -122.468584409749 | (37.7484208831153, -122.468584409749) | ||
158274 | 158274 | 176343 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 450 Raymond Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 76 | 6008484.74111 | 2088383.4213400001 | 37.714782633086294 | -122.412565284366 | (37.7147826330863, -122.412565284366) | ||||
138404 | 138404 | 114251 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 129 FONT BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 75 | 5990853.0 | 2088876.0 | 37.715129831054796 | -122.473543194374 | (37.7151298310548, -122.473543194374) | ||||
154149 | 154149 | 201514 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1001 Innes Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 75 | 6018663.55815 | 2094844.4948099998 | 37.733089515074795 | -122.377830854436 | (37.7330895150748, -122.377830854436) | ||||
163901 | 163901 | 186063 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 75 | Width 0ft | 5984824.1542 | 2102129.3734 | 37.7511690836835 | -122.49535802071101 | (37.7511690836835, -122.495358020711) | |||
171706 | 171706 | 185276 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2601 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 75 | Width 0ft | 5984954.4921 | 2097458.3645 | 37.7383513915158 | -122.494562994936 | (37.7383513915158, -122.494562994936) | |||
50830 | 50830 | 187240 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2401 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 74 | Width 0ft | 5984922.9229999995 | 2098555.1433 | 37.741361003208795 | -122.494752983477 | (37.7413610032088, -122.494752983477) | |||
28097 | 28097 | 184746 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 73 | Width 0ft | 5984670.325 | 2106153.0915 | 37.7622080878104 | -122.49618680876499 | (37.7622080878104, -122.496186808765) | |||
28570 | 28570 | 187221 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2401 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 73 | Width 0ft | 5984920.4721 | 2098768.3716 | 37.7419463270938 | -122.494777174832 | (37.7419463270938, -122.494777174832) | |||
41947 | 41947 | 243965 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 60 Ramona Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 73 | Width 5ft | 6005189.67155 | 2107490.26222 | 37.7670602101766 | -122.42531326790501 | (37.7670602101766, -122.425313267905) | |||
133818 | 133818 | 186243 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 73 | Width 0ft | 5984798.9554 | 2103218.7477 | 37.7541587299008 | -122.495525498398 | (37.7541587299008, -122.495525498398) | |||
25090 | 25090 | 223699 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 72 | 6004901.063490001 | 2096745.81285 | 37.737542142145706 | -122.425546760699 | (37.7375421421457, -122.425546760699) | ||||
151754 | 151754 | 185361 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601 Sunset Blvd | 86 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 72 | Width 0ft | 5985015.9398 | 2096870.9998 | 37.7367422415889 | -122.49430725909599 | (37.7367422415889, -122.494307259096) | |||
180772 | 180772 | 186089 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 72 | Width 0ft | 5984838.8917 | 2101823.6441 | 37.750330497842995 | -122.49528451351001 | (37.750330497843, -122.49528451351) | |||
77263 | 77263 | 185735 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101 Sunset Blvd | 67 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 71 | Width 0ft | 5984891.8172 | 2100271.961 | 37.7460730985326 | -122.49498709535801 | (37.7460730985326, -122.494987095358) | |||
146474 | 146474 | 186043 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 71 | Width 0ft | 5984987.6927 | 2102184.5017 | 37.751330024914395 | -122.49479655955 | (37.7513300249144, -122.49479655955) | |||
176904 | 176904 | 185257 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2570 33rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 71 | Width 0ft | 5986168.5104 | 2097746.1262 | 37.739212488149796 | -122.490386735185 | (37.7392124881498, -122.490386735185) | |||
178256 | 178256 | 186462 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1601 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 71 | Width 0ft | 5984739.2681 | 2103826.734 | 37.755824596750706 | -122.495776753709 | (37.7558245967507, -122.495776753709) | |||
26145 | 26145 | 185549 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 70 | Width 0ft | 5984904.1167 | 2099896.1658 | 37.745041987094396 | -122.49491686223999 | (37.7450419870944, -122.49491686224) | |||
44055 | 44055 | 111970 | Undocumented 2 | Populus spp :: Poplar Spp 276 | 1x STORRIE ST | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | |||
69703 | 69703 | 244011 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1327 Diamond St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 70 | Width 10ft | 6002019.91281 | 2100146.50257 | 37.746716425824 | -122.435751483069 | (37.746716425824, -122.435751483069) | |||
74975 | 74975 | 185009 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 70 | Width 0ft | 5984987.4666 | 2096476.9807 | 37.7356587041277 | -122.494376666271 | (37.7356587041277, -122.494376666271) | |||
112663 | 112663 | 114044 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 549X ARLINGTON ST | Median : Cutout 11 | Tree 1 | Private 1 | 70 | 6003400.0 | 2095634.0 | 37.734404428182295 | -122.430657330781 | (37.7344044281823, -122.430657330781) | |||||
127993 | 127993 | 122585 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500X Lyon St | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 70 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
184555 | 184555 | 186200 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 70 | Width 0ft | 5984778.3318 | 2103452.7061 | 37.754799907325605 | -122.49561407416701 | (37.7547999073256, -122.495614074167) | |||
164893 | 164893 | 184780 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 69 | Width 0ft | 5984672.982999999 | 2105911.7799 | 37.7615456694917 | -122.496159811415 | (37.7615456694917, -122.496159811415) | |||
185648 | 185648 | 185953 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 69 | Width 0ft | 5984818.0255 | 2101428.1429 | 37.7492433382305 | -122.49532750509199 | (37.7492433382305, -122.495327505092) | |||
58024 | 58024 | 185970 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2001 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 68 | Width 0ft | 5984877.0596 | 2101205.8095 | 37.748636327835 | -122.495106974471 | (37.748636327835, -122.495106974471) | |||
98923 | 98923 | 185985 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 68 | Width 0ft | 5984835.0992 | 2101040.6776 | 37.7481804641628 | -122.495239894977 | (37.7481804641628, -122.495239894977) | |||
152630 | 152630 | 185951 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 68 | Width 0ft | 5984852.8514 | 2101465.7293 | 37.749348579206796 | -122.495209849718 | (37.7493485792068, -122.495209849718) | |||
46888 | 46888 | 223710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 67 | 6004258.36813 | 2095937.1689 | 37.735285453551604 | -122.427711264267 | (37.7352854535516, -122.427711264267) | ||||
60814 | 60814 | 186596 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 67 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 67 | Width 0ft | 5984749.6315 | 2104462.0427 | 37.757569584992396 | -122.495787775902 | (37.7575695849924, -122.495787775902) | |||
73768 | 73768 | 185673 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 67 | Width 0ft | 5984881.5197 | 2100790.5954 | 37.747496524434396 | -122.495060938811 | (37.7474965244344, -122.495060938811) | |||
135127 | 135127 | 122185 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 14th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 67 | 5991491.733030001 | 2115080.7655 | 37.787118258390606 | -122.473245521028 | (37.7871182583906, -122.473245521028) | ||||
29069 | 29069 | 186197 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 66 | Width 0ft | 5984786.367000001 | 2103519.1304 | 37.7549827606067 | -122.49559118568399 | (37.7549827606067, -122.495591185684) | |||
71307 | 71307 | 223724 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 Belgrave Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 66 | Width 2ft | 5997664.737000001 | 2104901.53877 | 37.7595242277824 | -122.451154026041 | (37.7595242277824, -122.451154026041) | |||
55074 | 55074 | 185341 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 65 | Width 0ft | 5984987.4666 | 2096984.4739 | 37.7370521447921 | -122.49441406407699 | (37.7370521447921, -122.494414064077) | |||
132735 | 132735 | 223694 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 65 | 6005104.45792 | 2096735.8383799999 | 37.7375262448502 | -122.424842819945 | (37.7375262448502, -122.424842819945) | ||||
136614 | 136614 | 199597 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1400 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 65 | 6012249.4280199995 | 2101848.61895 | 37.7519658243772 | -122.40049816857099 | (37.7519658243772, -122.400498168571) | ||||
179881 | 179881 | 199598 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1400 De Haro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 65 | 6012249.21193 | 2101837.97965 | 37.7519365991191 | -122.400498168573 | (37.7519365991191, -122.400498168573) | ||||
126430 | 126430 | 114212 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302 SERRANO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 64 | 5988825.0 | 2090618.0 | 37.7197952736455 | -122.480680205506 | (37.7197952736455, -122.480680205506) | ||||
131940 | 131940 | 187018 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 64 | Width 0ft | 5984958.1911 | 2097916.1040000003 | 37.739608437718395 | -122.494583941282 | (37.7396084377184, -122.494583941282) | |||
152560 | 152560 | 186239 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 64 | Width 0ft | 5984787.4383 | 2103338.7401 | 37.754487521465 | -122.49557417650298 | (37.754487521465, -122.495574176503) | |||
168435 | 168435 | 176111 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 64 | 6005239.18473 | 2086329.3019599998 | 37.7089597755375 | -122.423637326411 | (37.7089597755375, -122.423637326411) | ||||
186276 | 186276 | 186413 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 64 | Width 0ft | 5984739.2681 | 2104238.7582 | 37.75695590087879 | -122.495807145737 | (37.7569559008788, -122.495807145737) | |||
186424 | 186424 | 184800 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 64 | Width 0ft | 5984686.2732 | 2105775.8403 | 37.76117319587821 | -122.496103817218 | (37.7611731958782, -122.496103817218) | |||
62963 | 62963 | 186357 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 63 | Width 0ft | 5984799.4911 | 2102657.2208 | 37.7526169633154 | -122.49548223376001 | (37.7526169633154, -122.49548223376) | |||
66998 | 66998 | 226943 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 301 Fairmount St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 63 | 6004022.8098 | 2097135.0105400002 | 37.7385611270814 | -122.42861103418001 | (37.7385611270814, -122.42861103418) | ||||
147554 | 147554 | 181434 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 67 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 63 | Width 0ft | 5984896.7414 | 2104905.8493 | 37.758796768768704 | -122.495311746922 | (37.7587967687687, -122.495311746922) | |||
166336 | 166336 | 185565 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 63 | Width 0ft | 5984901.9941 | 2099754.2184 | 37.7446521138241 | -122.494913737481 | (37.7446521138241, -122.494913737481) | |||
170917 | 170917 | 211605 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Santa Monica Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 63 | Width 6ft | 5994170.00368 | 2097298.61305 | 37.7384478134265 | -122.46268892035299 | (37.7384478134265, -122.462688920353) | |||
176872 | 176872 | 248241 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 296 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 63 | 6006778.03314 | 2099006.59157 | 37.743855612256 | -122.419217498503 | (37.743855612256, -122.419217498503) | ||||
40549 | 40549 | 185571 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 62 | Width 0ft | 5984908.6272 | 2099694.7862 | 37.744489317421205 | -122.494886420663 | (37.7444893174212, -122.494886420663) | |||
42147 | 42147 | 186117 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1700 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 62 | Width 0ft | 5984960.6905 | 2103014.1557 | 37.753606445966 | -122.494951102458 | (37.753606445966, -122.494951102458) | |||
49437 | 49437 | 227622 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 521 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 62 | Width 3ft | 6001670.93131 | 2100857.28025 | 37.748648223551 | -122.43700910221001 | (37.748648223551, -122.43700910221) |
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");