trees
808 rows where qSpecies_id = 171 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
7418 | 31898 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1525 Houston St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | Permit Number 35325 | |||||||||||||
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 | |||
8251 | 40540 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 388 San Benito Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/1999 12:00:00 AM | Permit Number 41588 | 5992603.60686863 | 2094011.26053389 | 37.7293312265638 | -122.467865679912 | (37.7293312265638, -122.467865679912) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
10715 | 38142 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52631 | 6010564.87001 | 2093809.44352 | 37.7297978911456 | -122.405757431764 | (37.7297978911456, -122.405757431764) | 10 | 3 | 7 | 309 | 28 | |
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 | |||
12263 | 31899 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1525 Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | Permit Number 35325 | |||||||||||||
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 | |||
14674 | 36425 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 300 Montecito Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39337 | 5996091.95170793 | 2094186.31684288 | 37.7300127063789 | -122.455818876187 | (37.7300127063789, -122.455818876187) | 9 | 7 | 4 | 28861 | 40 | |||
15352 | 31896 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1525 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | Permit Number 35325 | |||||||||||||
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 | |||
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 | |||
23358 | 43530 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1860 Hayes St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2000 12:00:00 AM | Permit Number 43204 | 5998953.15578019 | 2110104.23073393 | 37.7738831913239 | -122.447072466868 | (37.7738831913239, -122.447072466868) | 15 | 5 | 11 | 29492 | 16 | |||
23460 | 92774 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1144 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2009 12:00:00 AM | 3x3 | Permit Number 52995 | 5995988 | 2091529 | 37.7227103831657 | -122.455986213896 | (37.7227103831657, -122.455986213896) | 9 | 8 | 4 | 28861 | 24 | ||
23574 | 41964 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 650 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42319 | 5993529.11184875 | 2094722.09176746 | 37.7313363939727 | -122.464717748368 | (37.7313363939727, -122.464717748368) | 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 | |||
25655 | 45840 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1346 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2001 12:00:00 AM | Permit Number 44450 | 6009251.30909241 | 2101314.54392094 | 37.7503317176584 | -122.410828420764 | (37.7503317176584, -122.410828420764) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
28373 | 37471 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 38 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1998 12:00:00 AM | Permit Number 39942 | 6009520.07754888 | 2094206.74439622 | 37.7308303118978 | -122.409397439907 | (37.7308303118978, -122.409397439907) | 9 | 3 | 7 | 309 | 28 | |||
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 | |||
30514 | 39359 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 396 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40914 | 6007191.01710862 | 2105014.18893606 | 37.7603743559888 | -122.418215335605 | (37.7603743559888, -122.418215335605) | 2 | 4 | 7 | 28859 | 19 | |||
30773 | 46085 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1418 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2001 12:00:00 AM | 5 | Permit Number 44462 | 6007321.53362 | 2117792.12789 | 37.7954668519637 | -122.418670106339 | (37.7954668519637, -122.418670106339) | 5 | 1 | 10 | 28858 | 32 | ||
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 | |||
33178 | 36122 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1349 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1998 12:00:00 AM | Permit Number 39218 | 5990794.30800848 | 2106216.44397592 | 37.7627388498783 | -122.475011116785 | (37.7627388498783, -122.475011116785) | 1 | 8 | 3 | 56 | 12 | |||
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 | |||
34272 | 115532 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007293.46404 | 2111265.83422 | 37.7775456658356 | -122.418304279225 | (37.7775456658356, -122.418304279225) | 7 | 9 | 9 | 28852 | 36 | ||
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 | |||
35667 | 33341 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 201 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/1996 12:00:00 AM | Permit Number 37479 | 5992123.76889257 | 2094974.5728779 | 37.7319485222009 | -122.469594606822 | (37.7319485222009, -122.469594606822) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
36171 | 42259 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1695 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42501 | 6013703.77956799 | 2101941.41266903 | 37.7523016153345 | -122.395475275192 | (37.7523016153345, -122.395475275192) | 10 | 3 | 8 | 28856 | 1 | |||
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 | |||
36604 | 35871 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 50 Dorman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1998 12:00:00 AM | 9 | 3x3 | Permit Number 39081 | 6011337.7 | 2097400.6 | 37.7397016379903 | -122.403338190355 | (37.7397016379903, -122.403338190355) | 10 | 3 | 8 | 58 | 1 | |
36641 | 37470 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 21 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1998 12:00:00 AM | Permit Number 39941 | 6009550.88685783 | 2094283.89488091 | 37.7310438768949 | -122.409296369078 | (37.7310438768949, -122.409296369078) | 10 | 3 | 7 | 309 | 28 | |||
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 | |||
36814 | 42258 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1695 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42501 | 6013703.77956799 | 2101941.41266903 | 37.7523016153345 | -122.395475275192 | (37.7523016153345, -122.395475275192) | 10 | 3 | 8 | 28856 | 1 | |||
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 | |||
41656 | 91494 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1980 Union St | 3 | Sidewalk: Property side : Pot | Tree | Private 2 | 12/12/2006 12:00:00 AM | Permit Number 49113 | 6003507 | 2118649 | 37.797604101528 | -122.431930246212 | (37.797604101528, -122.431930246212) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
44176 | 33165 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1900 Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37385 | 5987002.17141519 | 2099642.65378786 | 37.7444685044849 | -122.487643637748 | (37.7444685044849, -122.487643637748) | 1 | 8 | 3 | 29491 | 35 | |||
44333 | 39914 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 334 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41191 | 6003664.62387668 | 2108679.5470683 | 37.7702394198325 | -122.430673046953 | (37.7702394198325, -122.430673046953) | 15 | 9 | 11 | 29492 | 10 | |||
44563 | 33397 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100 San Rafael Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1996 12:00:00 AM | Permit Number 37515 | 5991863.33861193 | 2095425.01594073 | 37.7331702707174 | -122.470527755913 | (37.7331702707174, -122.470527755913) | 9 | 8 | 4 | 59 | 40 | |||
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 | ||||
44957 | 30832 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 110 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1995 12:00:00 AM | Permit Number 34683 | 6000693.09492752 | 2095244.46595359 | 37.7331811316798 | -122.439988041925 | (37.7331811316798, -122.439988041925) | 9 | 7 | 5 | 63 | 40 | |||
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 | |||
48063 | 35872 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 50 Dorman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1998 12:00:00 AM | 9 | 3x3 | Permit Number 39081 | 6011337.7 | 2097400.6 | 37.7397016379903 | -122.403338190355 | (37.7397016379903, -122.403338190355) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
49405 | 35875 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 575X Barneveld Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1998 12:00:00 AM | 6 | 3x3 | Permit Number 39082 | 6011047.1 | 2097307 | 37.7394283976201 | -122.404336380175 | (37.7394283976201, -122.404336380175) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
50288 | 37435 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 834 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1998 12:00:00 AM | Permit Number 39909 | 5993207.31488974 | 2106658.25624757 | 37.7640914989899 | -122.466697568833 | (37.7640914989899, -122.466697568833) | 11 | 8 | 11 | 56 | 12 | |||
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 | |||
55038 | 43531 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1860 Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2000 12:00:00 AM | Permit Number 43204 | 5998953.15578019 | 2110104.23073393 | 37.7738831913239 | -122.447072466868 | (37.7738831913239, -122.447072466868) | 15 | 5 | 11 | 29492 | 16 | |||
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 |
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) );