trees
808 rows where qSpecies_id = 171 sorted by qLegalStatus_id
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 | |||
1373 | 32746 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 254 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 4 | Permit Number 37128 | 5994350.01319 | 2089345.90391 | 37.716621973312 | -122.461490145655 | (37.716621973312, -122.461490145655) | 9 | 8 | 6 | 28861 | 24 | |
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 | |||
5023 | 35483 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 16 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1998 12:00:00 AM | 5 | Permit Number 38894 | 6007493.52073 | 2093929.30657 | 37.7299547724713 | -122.416383947876 | (37.7299547724713, -122.416383947876) | 9 | 3 | 7 | 309 | 28 | |
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 | |||
6367 | 33275 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1200 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 5 | Permit Number 37444 | 6008934.75066 | 2117024.05475 | 37.7934486051144 | -122.413033747502 | (37.7934486051144, -122.413033747502) | 5 | 1 | 10 | 28857 | 21 | |
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 | |||
8022 | 33277 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1200 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 5 | Permit Number 37444 | 6008905.29439 | 2117021.0394 | 37.7934386721123 | -122.413135455459 | (37.7934386721123, -122.413135455459) | 5 | 1 | 10 | 28857 | 21 | |
9170 | 41208 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 112 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 5 | Permit Number 41915 | 6001387.72145 | 2121116.10553 | 37.804257751046 | -122.439440444547 | (37.804257751046, -122.439440444547) | 13 | 9 | 1 | 57 | 17 | |
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 | |||
11119 | 37137 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 161 Escolta Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 3 | Permit Number 42807 | 5986482.4499372 | 2097271.49394256 | 37.7379276046571 | -122.489266400384 | (37.7379276046571, -122.489266400384) | 1 | 8 | 3 | 29491 | 35 | |
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 | |||
13135 | 70951 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 333 12th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | Permit Number 779764 | 6008387.46855 | 2108743.89071 | 37.7706825255975 | -122.41434125384 | (37.7706825255975, -122.41434125384) | 8 | 2 | 9 | 28853 | 19 | ||
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 | |||
15321 | 30827 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 198 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 5 | Permit Number 34680 | 6001761.61704 | 2095036.28299 | 37.7326702790141 | -122.436278984899 | (37.7326702790141, -122.436278984899) | 9 | 7 | 5 | 63 | 40 | |
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 | |||
16741 | 37198 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1661 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 3 | Permit Number 39765 | 5986527.74614195 | 2103950.96431222 | 37.7562702766901 | -122.489600837066 | (37.7562702766901, -122.489600837066) | 1 | 8 | 3 | 56 | 35 | |
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 | |||
19977 | 38352 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1723 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/1998 12:00:00 AM | 2 | Permit Number 40419 | 5981271.60203473 | 2103339.27473669 | 37.7542824830847 | -122.507732681289 | (37.7542824830847, -122.507732681289) | 1 | 8 | 3 | 56 | 35 | |
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 | |||
20743 | 39558 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 851 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 4 | Permit Number 40980 | 6012172.05667 | 2104437.32461 | 37.7590695278586 | -122.400947597548 | (37.7590695278586, -122.400947597548) | 10 | 3 | 8 | 28856 | 29 | |
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 | |||
21472 | 38351 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1525 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/1998 12:00:00 AM | 2 | Permit Number 40418 | 5981225.53274519 | 2104685.47699717 | 37.7579760566052 | -122.50799190128 | (37.7579760566052, -122.50799190128) | 1 | 8 | 3 | 56 | 35 | |
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 | |||
23148 | 43612 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2245 33rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | 3 | Permit Number 43265 | 5986043.06830282 | 2099955.88767086 | 37.7452725739887 | -122.4909830193 | (37.7452725739887, -122.4909830193) | 1 | 8 | 3 | 29491 | 35 | |
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 | |||
27344 | 42699 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 839 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2007 12:00:00 AM | 4 | Permit No. 49315 | 6006686.40585 | 2121480.76195 | 37.805559128512 | -122.421129804292 | (37.805559128512, -122.421129804292) | 5 | 1 | 1 | 28858 | 32 | |
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 | |||
30638 | 42980 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 326 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | 5 | Permit Number 42864 | 6006615.65934 | 2092432.63366 | 37.7257958289143 | -122.419312695324 | (37.7257958289143, -122.419312695324) | 9 | 7 | 7 | 309 | 5 | |
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 | ||
31235 | 33114 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2664 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 6 | Permit Number 37351 | 6000216.07669 | 2118539.73956 | 37.7971169892123 | -122.443309838783 | (37.7971169892123, -122.443309838783) | 13 | 9 | 1 | 57 | 17 | |
32138 | 40651 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 220 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 5 | Permit Number 41646 | 6004675.95059 | 2093935.66524 | 37.7298133846627 | -122.426125084098 | (37.7298133846627, -122.426125084098) | 9 | 7 | 6 | 28861 | 5 | |
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 | |||
32584 | 43044 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2378 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 4 | Permit Number 42898 | 5984575.17835777 | 2099003.211622 | 37.7425709165312 | -122.495988392138 | (37.7425709165312, -122.495988392138) | 1 | 8 | 3 | 29491 | 35 | |
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 | |||
34114 | 42203 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 17 Decatur St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 5 | Permit Number 42475 | 6010751.10561 | 2109407.62364 | 37.7726374754766 | -122.406212127213 | (37.7726374754766, -122.406212127213) | 14 | 2 | 9 | 28853 | 34 | |
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 | |||
35254 | 40689 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 156 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 4 | Permit Number 41672 | 6004442.73992 | 2094023.43219 | 37.7300411892414 | -122.426937568535 | (37.7300411892414, -122.426937568535) | 9 | 7 | 6 | 28861 | 5 | |
35340 | 37392 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 174 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 5 | Permit Number 39874 | 6000312.39243 | 2087872.87189 | 37.7129187386835 | -122.440775632915 | (37.7129187386835, -122.440775632915) | 9 | 7 | 6 | 28861 | 5 | |
35435 | 33120 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2333 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | 4 | Permit Number 38631 | 6001730.82308 | 2119050.70449 | 37.7986062251452 | -122.438105074499 | (37.7986062251452, -122.438105074499) | 13 | 9 | 1 | 57 | 17 | |
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 | |||
37273 | 49785 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 234 Wilde Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | 2 | Permit Number 46569 | 6011634.9968 | 2088843.14893 | 37.7162212498006 | -122.401708924923 | (37.7162212498006, -122.401708924923) | 10 | 7 | 8 | 309 | 39 | |
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 | |||
39258 | 43609 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2171 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | 3 | Permit Number 43263 | 5986025.72538259 | 2100465.41766357 | 37.746670592713 | -122.491080477377 | (37.746670592713, -122.491080477377) | 1 | 8 | 3 | 29491 | 35 | |
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 | |||
41070 | 37354 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 15 Florentine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 5 | Permit Number 39860 | 5999445.56286 | 2087945.6113 | 37.7130690603709 | -122.4437768927 | (37.7130690603709, -122.4437768927) | 9 | 7 | 6 | 28861 | 5 | |
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 | ||||
44903 | 43606 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2267 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | 0 | Permit Number 43260 | 5986358.2658798 | 2099823.43099403 | 37.7449272932947 | -122.489883393766 | (37.7449272932947, -122.489883393766) | 1 | 8 | 3 | 29491 | 35 | |
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 | |||
46618 | 37138 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 161 Escolta Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 3 | Permit Number 42807 | 5986482.4499372 | 2097271.49394256 | 37.7379276046571 | -122.489266400384 | (37.7379276046571, -122.489266400384) | 1 | 8 | 3 | 29491 | 35 | |
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 | |||
50043 | 43611 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2245 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | 3 | Permit Number 43265 | 5986043.06830282 | 2099955.88767086 | 37.7452725739887 | -122.4909830193 | (37.7452725739887, -122.4909830193) | 1 | 8 | 3 | 29491 | 35 | |
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 |
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) );