trees
808 rows where qSpecies_id = 171 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1106 | 70679 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1111 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008560.05738 | 2116476.80387 | 37.7919249476168 | -122.414291480882 | (37.7919249476168, -122.414291480882) | 5 | 1 | 10 | 28858 | 21 | |||
1300 | 214130 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 459 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998397.60644 | 2095236.47729 | 37.7330282541307 | -122.447923556932 | (37.7330282541307, -122.447923556932) | 9 | 7 | 4 | 59 | 40 | |||
1520 | 240441 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 201x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007898.27023 | 2096569.27157 | 37.7372262948636 | -122.415171475584 | (37.7372262948636, -122.415171475584) | 2 | 7 | 7 | 28859 | 2 | |||
2929 | 179388 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 26 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999809.28838 | 2088896.52322 | 37.715700789641 | -122.442587971868 | (37.715700789641, -122.442587971868) | 9 | 7 | 6 | 28861 | 25 | |||
4274 | 179410 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 199x Boylston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009166 | 2094503 | 37.7316239213188 | -122.410642460987 | (37.7316239213188, -122.410642460987) | 10 | 3 | 7 | 309 | 28 | |||
4443 | 179408 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 656 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005718.65931 | 2093534.83532 | 37.7287716729707 | -122.422491846438 | (37.7287716729707, -122.422491846438) | 9 | 7 | 7 | 309 | 5 | |||
5332 | 70334 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 241 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010007.80208 | 2094072.89599 | 37.7304901074191 | -122.407701855976 | (37.7304901074191, -122.407701855976) | 10 | 3 | 7 | 309 | 28 | |||
6406 | 240442 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 201x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007915.32233 | 2096568.13158 | 37.7372241229949 | -122.415112437814 | (37.7372241229949, -122.415112437814) | 2 | 7 | 7 | 28859 | 2 | |||
6727 | 240443 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 201X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6007930.79471 | 2096567.41959 | 37.7372230375177 | -122.415058892166 | (37.7372230375177, -122.415058892166) | 2 | 7 | 7 | 28859 | 2 | |||
6930 | 78226 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 735 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6009356.04256 | 2090803.21552 | 37.7214757474837 | -122.409724391665 | (37.7214757474837, -122.409724391665) | 9 | 3 | 7 | 309 | 28 | |||
7427 | 214054 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 75 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992589.0993 | 2098653.10719 | 37.7420757360966 | -122.468253382008 | (37.7420757360966, -122.468253382008) | 1 | 8 | 4 | 59 | 40 | |||
7818 | 72522 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 25 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5999833.66964 | 2088872.28034 | 37.7156356139591 | -122.442501959816 | (37.7156356139591, -122.442501959816) | 9 | 7 | 6 | 28861 | 25 | |||
9931 | 106730 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 675 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 2x2 | 6007270.08958 | 2091466.77872 | 37.7231806345686 | -122.416981969156 | (37.7231806345686, -122.416981969156) | 9 | 3 | 7 | 309 | 28 | |||
10124 | 214104 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 376 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995053.96865 | 2088294.46143 | 37.7137754535406 | -122.45898085369 | (37.7137754535406, -122.45898085369) | 9 | 8 | 6 | 28861 | 24 | |||
10908 | 214113 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 232 Garfield St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5993322.79937 | 2090505.62474 | 37.7197471093131 | -122.46512486634 | (37.7197471093131, -122.46512486634) | 9 | 8 | 6 | 64 | 24 | |||
11740 | 246800 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 125 Brewster St | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6010336.37348 | 2099216.9029 | 37.7446328360494 | -122.406928349065 | (37.7446328360494, -122.406928349065) | 2 | 7 | 7 | 28859 | 2 | |||
12612 | 72441 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 3755 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5996301.68553 | 2115882.69147 | 37.7895974644048 | -122.456662259358 | (37.7895974644048, -122.456662259358) | 11 | 6 | 1 | 54 | 31 | |||
13177 | 240455 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 395 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007235.30663 | 2105078.40224 | 37.7605531637099 | -122.418066710723 | (37.7605531637099, -122.418066710723) | 2 | 4 | 7 | 28859 | 19 | |||
15399 | 214071 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 110 Westgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993372.15361 | 2093767.9107 | 37.7287073975199 | -122.465191096889 | (37.7287073975199, -122.465191096889) | 9 | 8 | 4 | 59 | 40 | |||
17086 | 214094 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 651 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5997782.04572 | 2094966.29787 | 37.7322512012232 | -122.450032235997 | (37.7322512012232, -122.450032235997) | 9 | 7 | 4 | 59 | 40 | ||||
18012 | 214055 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 241 San Fernando Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992140.43755 | 2095156.89356 | 37.7324500925775 | -122.469550247555 | (37.7324500925775, -122.469550247555) | 9 | 8 | 4 | 59 | 40 | |||
18445 | 70411 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1809 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6005512.8628 | 2092696.08683 | 37.7264570419356 | -122.423143704729 | (37.7264570419356, -122.423143704729) | 9 | 7 | 7 | 309 | 5 | |||
19010 | 214047 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1650 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990913.92189 | 2104155.04693 | 37.7570857331305 | -122.474446977845 | (37.7570857331305, -122.474446977845) | 1 | 8 | 4 | 56 | 12 | |||
20206 | 240428 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 530 Hickory St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 2ft | 6004264.45793 | 2110312.03862 | 37.7747558078645 | -122.428714616282 | (37.7747558078645, -122.428714616282) | 7 | 9 | 11 | 28852 | 10 | |||
21088 | 136339 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2020 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008202.0476 | 2119382.96503 | 37.7998844297821 | -122.415736067261 | (37.7998844297821, -122.415736067261) | 5 | 1 | 10 | 308 | 32 | |||
21255 | 240437 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 241 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009006.99303 | 2097210.14785 | 37.7390482484851 | -122.411383360277 | (37.7390482484851, -122.411383360277) | 10 | 7 | 7 | 28859 | 2 | |||
21904 | 214108 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 109 Caine Ave | 5 | : | Tree | Private 2 | 3 | Width 3ft | 5997325.44659 | 2089211.35865 | 37.7164233544255 | -122.451195913766 | (37.7164233544255, -122.451195913766) | 9 | 8 | 6 | 28861 | 24 | |||
22309 | 214134 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 208 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6000001.95124 | 2095241.87496 | 37.7331346484373 | -122.442377319163 | (37.7331346484373, -122.442377319163) | 9 | 7 | 4 | 63 | 40 | |||
23253 | 214080 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 20 Santa Rita Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993850.57041 | 2100913.50249 | 37.7483549879002 | -122.464055698337 | (37.7483549879002, -122.464055698337) | 1 | 8 | 4 | 29491 | 40 | |||
23357 | 214062 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 306 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992867.89158 | 2094835.36028 | 37.7316092579634 | -122.467011920972 | (37.7316092579634, -122.467011920972) | 9 | 8 | 4 | 59 | 40 | |||
23711 | 187536 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 88 Megan Dr | 2 | : | Tree | Private 2 | 3 | Width 1ft | 6012637.77766 | 2087904.04579 | 37.7136985678121 | -122.3981769608 | (37.7136985678121, -122.3981769608) | 10 | 3 | 8 | 309 | 1 | |||
25802 | 136332 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2201 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004130.99948 | 2116365.41859 | 37.7913693248864 | -122.429608091843 | (37.7913693248864, -122.429608091843) | 13 | 9 | 1 | 29490 | 27 | |||
26804 | 197359 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 301 Utah St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010633.78259 | 2106874.74406 | 37.7656762048112 | -122.406439454241 | (37.7656762048112, -122.406439454241) | 8 | 4 | 8 | 28853 | 19 | |||
26873 | 136338 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2020 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008205.97782 | 2119361.84946 | 37.7998266726343 | -122.415720971247 | (37.7998266726343, -122.415720971247) | 5 | 1 | 10 | 308 | 32 | |||
27145 | 179402 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 413 Harvard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006484.02196 | 2091986.9071 | 37.7245645455137 | -122.419736144732 | (37.7245645455137, -122.419736144732) | 9 | 7 | 7 | 309 | 28 | |||
27238 | 214136 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 280 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6000181.60915 | 2094987.27855 | 37.7324458244188 | -122.441737929968 | (37.7324458244188, -122.441737929968) | 9 | 7 | 5 | 63 | 40 | |||
28847 | 116869 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2000x JONES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008236 | 2119365 | 37.7998370108632 | -122.415617306198 | (37.7998370108632, -122.415617306198) | 5 | 1 | 10 | 308 | 32 | ||||
29271 | 255114 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 762 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x12 | 5992622 | 2110262 | 37.7739526219287 | -122.468984263397 | (37.7739526219287, -122.468984263397) | 11 | 6 | 2 | 54 | 11 | ||||
29435 | 240458 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 9 Sunview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998745.41414 | 2100365.7906 | 37.7471319935551 | -122.447090103938 | (37.7471319935551, -122.447090103938) | 2 | 5 | 5 | 63 | 38 | |||
32326 | 179416 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 634 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010579.81864 | 2091777.61519 | 37.7242197508253 | -122.405562705175 | (37.7242197508253, -122.405562705175) | 10 | 3 | 7 | 309 | 28 | |||
33312 | 240488 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 3004 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008913.96519 | 2105461.43201 | 37.7616992138765 | -122.412288048567 | (37.7616992138765, -122.412288048567) | 8 | 4 | 7 | 28859 | 19 | |||
33887 | 214137 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 473 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997076.62001 | 2095526.13958 | 37.7337480013603 | -122.452511426764 | (37.7337480013603, -122.452511426764) | 9 | 7 | 4 | 59 | 40 | |||
34162 | 246736 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 110 Ripley St | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6008636.33373 | 2099057.51181 | 37.744099907697 | -122.412795505415 | (37.744099907697, -122.412795505415) | 2 | 7 | 7 | 28859 | 2 | |||
34199 | 214120 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 245 Kenwood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993845.8598 | 2093540.45581 | 37.7281101676319 | -122.463536977458 | (37.7281101676319, -122.463536977458) | 9 | 8 | 4 | 59 | 40 | |||
34270 | 214122 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1238 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995887.38066 | 2092288.61202 | 37.7247903212011 | -122.456388931102 | (37.7247903212011, -122.456388931102) | 9 | 7 | 4 | 28861 | 40 | |||
34362 | 136337 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1441 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006625.88661 | 2118341.51338 | 37.7969361364579 | -122.421116195753 | (37.7969361364579, -122.421116195753) | 13 | 9 | 10 | 28858 | 32 | |||
34458 | 240459 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 10 Sunview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998774.93682 | 2100357.47963 | 37.7471108603927 | -122.446987419335 | (37.7471108603927, -122.446987419335) | 2 | 5 | 5 | 63 | 38 | |||
36001 | 240483 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 3408 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006311.55692 | 2102032.46826 | 37.7521376992102 | -122.421045269824 | (37.7521376992102, -122.421045269824) | 2 | 4 | 5 | 28859 | 19 | |||
36219 | 240476 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 95 Arbor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001825.73863 | 2096747.87014 | 37.7373735453515 | -122.436179742928 | (37.7373735453515, -122.436179742928) | 2 | 7 | 5 | 63 | 7 | |||
36810 | 214123 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1422 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995888.96446 | 2093464.6167 | 37.7280194395365 | -122.45646845638 | (37.7280194395365, -122.45646845638) | 9 | 7 | 4 | 28861 | 40 | |||
37501 | 214075 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994524.80508 | 2093748.46822 | 37.7287204152156 | -122.461204929282 | (37.7287204152156, -122.461204929282) | 9 | 8 | 4 | 59 | 40 | |||
38304 | 240481 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 378 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007186.61383 | 2105147.29677 | 37.7607395913868 | -122.418240001972 | (37.7607395913868, -122.418240001972) | 2 | 4 | 7 | 28859 | 19 | |||
38636 | 240447 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 307 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007214.00859 | 2105476.56765 | 37.7616452347736 | -122.418168600314 | (37.7616452347736, -122.418168600314) | 2 | 4 | 7 | 28859 | 19 | |||
38718 | 136343 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 405 Sansome St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6012310.89347 | 2117046.31271 | 37.7936986634044 | -122.401353532662 | (37.7936986634044, -122.401353532662) | 4 | 1 | 10 | 28860 | 6 | |||
40274 | 240497 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 296 Collingwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002061.83117 | 2104156.34768 | 37.7577288850888 | -122.43589339786 | (37.7577288850888, -122.43589339786) | 2 | 4 | 5 | 28862 | 3 | |||
40314 | 179385 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 227 Italy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001334.52213 | 2089523.28387 | 37.7175085600499 | -122.437360930457 | (37.7175085600499, -122.437360930457) | 9 | 7 | 6 | 28861 | 5 | |||
40569 | 197362 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2250 Revere Ave | 8 | : | Tree | Private 2 | 4 | Width 2ft | 6011553.01117 | 2097063.53685 | 37.7387881573563 | -122.402570035698 | (37.7387881573563, -122.402570035698) | 10 | 3 | 8 | 58 | 1 | |||
41107 | 240449 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 315 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007214.23155 | 2105454.10891 | 37.7615835808407 | -122.418166236878 | (37.7615835808407, -122.418166236878) | 2 | 4 | 7 | 28859 | 19 | |||
41275 | 179413 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 248 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009284.39498 | 2094756.53156 | 37.7323267019989 | -122.410251038266 | (37.7323267019989, -122.410251038266) | 10 | 3 | 7 | 309 | 28 | |||
41306 | 240467 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 500 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000657.73533 | 2101059.8853 | 37.7491468868218 | -122.440527243747 | (37.7491468868218, -122.440527243747) | 2 | 4 | 5 | 28862 | 22 | |||
41430 | 136341 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 405 Sansome St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6012301.53594 | 2117108.74815 | 37.7938695741742 | -122.401390300532 | (37.7938695741742, -122.401390300532) | 4 | 1 | 10 | 28860 | 6 | |||
41924 | 214141 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 27 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997794.49721 | 2091449.45768 | 37.7225954996675 | -122.449735844629 | (37.7225954996675, -122.449735844629) | 9 | 7 | 4 | 28861 | 24 | |||
42004 | 214082 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 92 Fairfield Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993797.56798 | 2093505.14629 | 37.7280104337283 | -122.463701360955 | (37.7280104337283, -122.463701360955) | 9 | 8 | 4 | 59 | 40 | |||
43541 | 179396 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 522 Avalon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004016.97033 | 2092466.75791 | 37.7257428246461 | -122.428298604305 | (37.7257428246461, -122.428298604305) | 9 | 7 | 6 | 28861 | 5 | |||
44793 | 253714 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 199x Boylston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009166 | 2094503 | 37.7316239213188 | -122.410642460987 | (37.7316239213188, -122.410642460987) | 10 | 3 | 7 | 309 | 28 | ||||
45574 | 179383 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 227 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001367.16278 | 2089507.57514 | 37.7174672829606 | -122.437246982771 | (37.7174672829606, -122.437246982771) | 9 | 7 | 6 | 28861 | 5 | |||
47057 | 240444 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 21 Samoset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009964.6851 | 2099164.07899 | 37.7444669875706 | -122.408209855099 | (37.7444669875706, -122.408209855099) | 2 | 7 | 7 | 28859 | 2 | |||
47355 | 240473 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 106 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003773.04832 | 2096485.69416 | 37.7367641143612 | -122.429428297586 | (37.7367641143612, -122.429428297586) | 2 | 7 | 5 | 63 | 7 | |||
47959 | 214064 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 306 San Benito Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992868.39865 | 2094830.01805 | 37.7315946187936 | -122.4670097797 | (37.7315946187936, -122.4670097797) | 9 | 8 | 4 | 59 | 40 | |||
48079 | 136336 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 847 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006667.96284 | 2121478.38508 | 37.8055515625299 | -122.421193460133 | (37.8055515625299, -122.421193460133) | 5 | 1 | 1 | 28858 | 32 | |||
48783 | 240491 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 168 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003204.56497 | 2105076.07134 | 37.7603190746763 | -122.432007030709 | (37.7603190746763, -122.432007030709) | 2 | 4 | 5 | 28862 | 3 | |||
50247 | 240450 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 319 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007216.26639 | 2105420.04532 | 37.7614901646684 | -122.418156784115 | (37.7614901646684, -122.418156784115) | 2 | 4 | 7 | 28859 | 19 | |||
50558 | 214129 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 201 Acadia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001398.48596 | 2094992.79016 | 37.7325302185866 | -122.437531302532 | (37.7325302185866, -122.437531302532) | 9 | 7 | 5 | 63 | 40 | |||
53074 | 240445 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 3321 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007580.78652 | 2100889.10858 | 37.7490697582683 | -122.416575083477 | (37.7490697582683, -122.416575083477) | 2 | 4 | 7 | 28859 | 19 | |||
53490 | 136331 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2201 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004147.29374 | 2116366.13985 | 37.791372227882 | -122.429551765519 | (37.791372227882, -122.429551765519) | 13 | 9 | 1 | 29490 | 27 | |||
54029 | 214078 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 95 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993653.33784 | 2093560.03423 | 37.7281528305709 | -122.464203947977 | (37.7281528305709, -122.464203947977) | 9 | 8 | 4 | 59 | 40 | |||
55079 | 214139 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 678 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997592.24153 | 2095008.03804 | 37.7323549470266 | -122.450691437268 | (37.7323549470266, -122.450691437268) | 9 | 7 | 4 | 59 | 40 | |||
56377 | 214057 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 263 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992130.61667 | 2094998.35123 | 37.7320142073829 | -122.469572663162 | (37.7320142073829, -122.469572663162) | 9 | 8 | 4 | 59 | 40 | |||
57061 | 136333 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1170 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009094.3848 | 2117047.80804 | 37.7935227857058 | -122.41248307914 | (37.7935227857058, -122.41248307914) | 3 | 1 | 10 | 28857 | 21 | |||
58023 | 116583 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 298x Congdon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004696.00416 | 2093918.10113 | 37.7297662909357 | -122.426054506725 | (37.7297662909357, -122.426054506725) | 9 | 7 | 6 | 28861 | 5 | ||||
58274 | 214103 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 252 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994385.24996 | 2089344.94583 | 37.7166213707489 | -122.461368281228 | (37.7166213707489, -122.461368281228) | 9 | 8 | 6 | 28861 | 24 | |||
59759 | 214060 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 201 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992193.63451 | 2094957.42717 | 37.7319054820527 | -122.469351821151 | (37.7319054820527, -122.469351821151) | 9 | 8 | 4 | 59 | 40 | |||
60576 | 116868 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2000x JONES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008236 | 2119365 | 37.7998370108632 | -122.415617306198 | (37.7998370108632, -122.415617306198) | 5 | 1 | 10 | 308 | 32 | ||||
60711 | 240453 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 331 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007218.07842 | 2105375.09919 | 37.7613668550248 | -122.418147330431 | (37.7613668550248, -122.418147330431) | 2 | 4 | 7 | 28859 | 19 | |||
62678 | 27859 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 501 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6005590.08151 | 2106010.51077 | 37.7630197774623 | -122.423823079568 | (37.7630197774623, -122.423823079568) | 8 | 4 | 5 | 28859 | 19 | |||
62683 | 240446 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 225 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007185.08806 | 2105978.8862 | 37.763022856728 | -122.418304241463 | (37.763022856728, -122.418304241463) | 8 | 4 | 7 | 28859 | 19 | |||
63423 | 248268 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 175 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 6006645.67565 | 2098561.99454 | 37.7426273937378 | -122.419643622452 | (37.7426273937378, -122.419643622452) | 2 | 7 | 7 | 28859 | 2 | |||
64151 | 240485 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 3010 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009422.53663 | 2101621.07014 | 37.7511829699376 | -122.410257941465 | (37.7511829699376, -122.410257941465) | 2 | 4 | 7 | 28859 | 19 | |||
64181 | 187538 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 28 Megan Dr | 1 | : | Tree | Private 2 | 2 | Width 1ft | 6012586.06032 | 2088035.04723 | 37.7140553909211 | -122.398364902042 | (37.7140553909211, -122.398364902042) | 10 | 3 | 8 | 309 | 1 | |||
64419 | 240487 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 3006 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008900.8953 | 2105460.00546 | 37.7616945634837 | -122.412333151379 | (37.7616945634837, -122.412333151379) | 8 | 4 | 7 | 28859 | 19 | |||
65024 | 179390 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 92 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000659.06031 | 2087971.66607 | 37.713209742208 | -122.439584515931 | (37.713209742208, -122.439584515931) | 9 | 7 | 6 | 28861 | 5 | |||
65490 | 223647 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 3270 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007640.90679 | 2105619.03236 | 37.7620604292697 | -122.416702221525 | (37.7620604292697, -122.416702221525) | 8 | 4 | 7 | 28859 | 19 | |||
65547 | 136342 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 405 Sansome St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6012305.28576 | 2117077.96429 | 37.7937852582386 | -122.401375161334 | (37.7937852582386, -122.401375161334) | 4 | 1 | 10 | 28860 | 6 | |||
65656 | 240434 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 378 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6003500.73252 | 2098661.47259 | 37.7427228810479 | -122.430525014544 | (37.7427228810479, -122.430525014544) | 2 | 7 | 5 | 63 | 22 | |||
66490 | 214085 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 331 Hearst Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5999222.32015 | 2094357.21935 | 37.7306611242991 | -122.445009128462 | (37.7306611242991, -122.445009128462) | 9 | 7 | 4 | 28861 | 40 | |||
66573 | 136340 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2020 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008200.70314 | 2119395.79645 | 37.7999195860788 | -122.415741628666 | (37.7999195860788, -122.415741628666) | 5 | 1 | 10 | 308 | 32 | |||
66979 | 214079 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 750 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993766.75997 | 2094272.48059 | 37.73011557038 | -122.463863538374 | (37.73011557038, -122.463863538374) | 9 | 8 | 4 | 59 | 40 | |||
67572 | 240492 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 104 Eagle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999802.79387 | 2104488.88116 | 37.7585133529317 | -122.443729943602 | (37.7585133529317, -122.443729943602) | 2 | 4 | 5 | 28862 | 3 | |||
68460 | 214092 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5996810.21499 | 2094453.14745 | 37.7307865554542 | -122.45335502231 | (37.7307865554542, -122.45335502231) | 9 | 7 | 4 | 59 | 40 | |||
69592 | 214126 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 198 Lippard Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001754.28692 | 2095002.36729 | 37.7325767378097 | -122.436301900507 | (37.7325767378097, -122.436301900507) | 9 | 7 | 5 | 63 | 40 |
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) );