trees
808 rows where qSpecies_id = 171 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
85278 | 101315 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 60 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011155 | 2096548 | 37.7373503742221 | -122.403909910739 | (37.7373503742221, -122.403909910739) | 10 | 3 | 8 | 58 | 1 | ||||
90585 | 102789 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 3410X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006332.5 | 2102094.7 | 37.7523097538431 | -122.420977263424 | (37.7523097538431, -122.420977263424) | 2 | 4 | 5 | 28859 | 19 | ||||
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 | |||
121423 | 111677 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1138 SUTTER ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6007105 | 2115125 | 37.7881313861469 | -122.419230062804 | (37.7881313861469, -122.419230062804) | 13 | 9 | 10 | 28858 | 21 | ||||
137865 | 111678 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1150 SUTTER ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6007057 | 2115063 | 37.7879584460395 | -122.419391734764 | (37.7879584460395, -122.419391734764) | 13 | 9 | 10 | 28858 | 21 | ||||
75948 | 111679 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1150 SUTTER ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6007057 | 2115063 | 37.7879584460395 | -122.419391734764 | (37.7879584460395, -122.419391734764) | 13 | 9 | 10 | 28858 | 21 | ||||
168962 | 115531 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007312.73746 | 2111269.98589 | 37.7775581502144 | -122.41823790028 | (37.7775581502144, -122.41823790028) | 7 | 9 | 9 | 28852 | 36 | ||
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 | ||
115681 | 115533 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007275.38703 | 2111262.82601 | 37.7775363884346 | -122.418366600452 | (37.7775363884346, -122.418366600452) | 7 | 9 | 9 | 28852 | 36 | ||
93518 | 115534 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007259.83389 | 2111260.26588 | 37.7775284833993 | -122.418420222514 | (37.7775284833993, -122.418420222514) | 7 | 9 | 9 | 28852 | 36 | ||
184734 | 115535 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007237.56945 | 2111260.60051 | 37.7775281488378 | -122.418497266559 | (37.7775281488378, -122.418497266559) | 7 | 9 | 9 | 28852 | 36 | ||
133593 | 116482 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 191 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 5999138.49956791 | 2107652.6022322 | 37.7671622291215 | -122.446254942292 | (37.7671622291215, -122.446254942292) | 15 | 5 | 5 | 29492 | 9 | ||||
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 | ||||
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 | ||||
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 | ||||
154571 | 116870 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2000x JONES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008236 | 2119365 | 37.7998370108632 | -122.415617306198 | (37.7998370108632, -122.415617306198) | 5 | 1 | 10 | 308 | 32 | ||||
143614 | 116962 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1144 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6007321.53099 | 2115265.33752 | 37.7885289106147 | -122.418490856182 | (37.7885289106147, -122.418490856182) | 13 | 9 | 10 | 28858 | 21 | |||
128788 | 117679 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 7800 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 19 | Width 3ft | 5982700.57004 | 2112440.07286 | 37.7793547453385 | -122.503464893902 | (37.7793547453385, -122.503464893902) | 11 | 6 | 2 | 55 | 26 | |||
167026 | 121611 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 10 Fountain St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6000298 | 2101623 | 37.7506725731621 | -122.441811619208 | (37.7506725731621, -122.441811619208) | 2 | 4 | 5 | 28862 | 22 | ||||
105408 | 121659 | Undocumented 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 698 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996831 | 2094462 | 37.7308120537964 | -122.453283804485 | (37.7308120537964, -122.453283804485) | 9 | 7 | 4 | 59 | 40 | ||||
100587 | 122776 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 698X Hearst Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996831 | 2094462 | 37.7308120537964 | -122.453283804485 | (37.7308120537964, -122.453283804485) | 9 | 7 | 4 | 59 | 40 | ||||
170796 | 122777 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 698X Hearst Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996831 | 2094462 | 37.7308120537964 | -122.453283804485 | (37.7308120537964, -122.453283804485) | 9 | 7 | 4 | 59 | 40 | ||||
138963 | 123349 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 516 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994708.14146 | 2111967.00888 | 37.778754433673 | -122.461891662951 | (37.778754433673, -122.461891662951) | 11 | 6 | 2 | 54 | 11 | |||
82380 | 12648 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 947 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2017 03:46:00 PM | 8 | 4X4PL | 5992480.81927 | 2114786.4909 | 37.7863674822329 | -122.469802097985 | (37.7863674822329, -122.469802097985) | 11 | 6 | 2 | 54 | 11 | ||
176492 | 13361 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 681 Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009922.88098 | 2090119.11514 | 37.7196290984845 | -122.407716765821 | (37.7196290984845, -122.407716765821) | 9 | 7 | 8 | 309 | 18 | |||
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 | |||
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 | |||
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 | |||
93140 | 136334 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1170 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009052.72645 | 2117042.36337 | 37.7935054980422 | -122.412626835765 | (37.7935054980422, -122.412626835765) | 3 | 1 | 10 | 28857 | 21 | |||
125290 | 136335 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 92 Bernard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008402.94124 | 2118099.23171 | 37.7963709080467 | -122.414949987878 | (37.7963709080467, -122.414949987878) | 5 | 1 | 10 | 308 | 21 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
131719 | 136344 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 405 Sansome St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6012313.48823 | 2117009.95024 | 37.7935989654818 | -122.401341997949 | (37.7935989654818, -122.401341997949) | 4 | 1 | 10 | 28854 | 6 | |||
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 | |||
118545 | 179384 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 227 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001349.74859 | 2089514.68507 | 37.7174858152825 | -122.437307684305 | (37.7174858152825, -122.437307684305) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
128530 | 179386 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 227 Italy Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001320.56571 | 2089533.69709 | 37.7175363589882 | -122.437409916557 | (37.7175363589882, -122.437409916557) | 9 | 7 | 6 | 28861 | 5 | |||
193862 | 179387 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 227 Italy Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001304.74857 | 2089543.53539 | 37.7175624735167 | -122.437465293195 | (37.7175624735167, -122.437465293195) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
145143 | 179389 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 130 Moneta Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 5997444.76319 | 2087767.57678 | 37.7124658931485 | -122.450679464611 | (37.7124658931485, -122.450679464611) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
153902 | 179391 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 411 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012708.59796 | 2087058.68535 | 37.7113813197638 | -122.397872915301 | (37.7113813197638, -122.397872915301) | 10 | 3 | 8 | 309 | 1 | |||
82609 | 179392 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 747 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009473.2278 | 2090538.86376 | 37.7207564589159 | -122.409300667085 | (37.7207564589159, -122.409300667085) | 9 | 3 | 7 | 309 | 28 | |||
186454 | 179393 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 137 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011128.89263 | 2092490.03157 | 37.7262065861404 | -122.403714730559 | (37.7262065861404, -122.403714730559) | 10 | 3 | 7 | 309 | 28 | |||
118639 | 179394 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 802 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998790.1622 | 2089940.29632 | 37.7185086052637 | -122.446185561331 | (37.7185086052637, -122.446185561331) | 9 | 7 | 6 | 28861 | 25 | |||
177889 | 179395 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 802 Delano Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5998781.55693 | 2089916.70875 | 37.7184433477691 | -122.446213610282 | (37.7184433477691, -122.446213610282) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
179252 | 179397 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 327 Craut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 7ft | 6004072.1632 | 2093632.5606 | 37.7289469823068 | -122.428190852935 | (37.7289469823068, -122.428190852935) | 9 | 7 | 6 | 28861 | 5 | |||
190968 | 179398 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 114 Congdon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004666.37209 | 2094131.13756 | 37.7303495667676 | -122.426172108778 | (37.7303495667676, -122.426172108778) | 9 | 7 | 6 | 28861 | 5 | |||
159966 | 179400 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 230 Congdon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004681.8691 | 2093837.71735 | 37.7295447760473 | -122.426097652978 | (37.7295447760473, -122.426097652978) | 9 | 7 | 6 | 28861 | 5 | |||
138377 | 179401 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 413 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006494.32804 | 2091952.03759 | 37.7244693819427 | -122.41969804493 | (37.7244693819427, -122.41969804493) | 9 | 7 | 7 | 309 | 28 | |||
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 | |||
153850 | 179403 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1048 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007979.45809 | 2093014.38196 | 37.7274699006897 | -122.414639278375 | (37.7274699006897, -122.414639278375) | 9 | 3 | 7 | 309 | 5 | |||
150578 | 179404 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1048 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007961.10452 | 2093009.68378 | 37.727455969313 | -122.414702394601 | (37.727455969313, -122.414702394601) | 9 | 3 | 7 | 309 | 5 | |||
159541 | 179405 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1048 Felton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007930.33459 | 2092999.95469 | 37.7274275264563 | -122.41480807843 | (37.7274275264563, -122.41480807843) | 9 | 3 | 7 | 309 | 5 | |||
91481 | 179406 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1048 Felton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007913.23251 | 2092994.17366 | 37.7274106920366 | -122.414866791566 | (37.7274106920366, -122.414866791566) | 9 | 3 | 7 | 309 | 5 | |||
122079 | 179407 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1048 Felton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007895.73174 | 2092989.66965 | 37.7273973416074 | -122.414926973296 | (37.7273973416074, -122.414926973296) | 9 | 3 | 7 | 309 | 5 | |||
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 | |||
137656 | 179409 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 201 Boylston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009135.56729 | 2094499.84472 | 37.7316135513065 | -122.410747450544 | (37.7316135513065, -122.410747450544) | 10 | 3 | 7 | 309 | 28 | |||
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 | |||
106931 | 179411 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 201 Boylston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009126.74584 | 2094532.82811 | 37.7317036220221 | -122.410780276706 | (37.7317036220221, -122.410780276706) | 9 | 3 | 7 | 309 | 28 | |||
192995 | 179412 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 101X Boylston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009128 | 2094630 | 37.7319705055503 | -122.410782800932 | (37.7319705055503, -122.410782800932) | 10 | 3 | 7 | 309 | 28 | |||
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 | |||
163655 | 179414 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 74 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008389.29005 | 2093808.76897 | 37.7296741345546 | -122.413278634727 | (37.7296741345546, -122.413278634727) | 9 | 3 | 7 | 309 | 28 | |||
114138 | 179415 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 180 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010572.19231 | 2093849.8826 | 37.7299093378406 | -122.405734964918 | (37.7299093378406, -122.405734964918) | 10 | 3 | 7 | 309 | 28 | |||
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 | |||
152852 | 179417 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 634 Goettingen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010588.26905 | 2091751.17345 | 37.7241476198129 | -122.405531631786 | (37.7241476198129, -122.405531631786) | 10 | 3 | 7 | 309 | 28 | |||
90768 | 1874 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 15 Beatrice Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/01/2006 12:00:00 AM | 3 | 3X3 | 6017610.71077 | 2094324.60114 | 37.7316039177833 | -122.381434724757 | (37.7316039177833, -122.381434724757) | 10 | 3 | 8 | 58 | 1 | ||
141292 | 187517 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 248 Lauren Ct | 1 | : | Tree | Private 2 | 3 | Width 1ft | 6012485.73667 | 2088132.58582 | 37.7143176233377 | -122.398718501961 | (37.7143176233377, -122.398718501961) | 10 | 3 | 8 | 309 | 1 | |||
72878 | 187532 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 5 Megan Dr | 1 | : | Tree | Private 2 | 3 | Width 1ft | 6012528.30512 | 2088068.01559 | 37.7141426980008 | -122.398566839383 | (37.7141426980008, -122.398566839383) | 10 | 3 | 8 | 309 | 1 | |||
138498 | 187533 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 29 Megan Dr | 1 | : | Tree | Private 2 | 3 | Width 1ft | 6012554.21482 | 2088005.04865 | 37.7139712467489 | -122.398472869247 | (37.7139712467489, -122.398472869247) | 10 | 3 | 8 | 309 | 1 | |||
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 | |||
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 | |||
190433 | 197358 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1919 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010659.81809 | 2106911.15144 | 37.7657776276592 | -122.40635196817 | (37.7657776276592, -122.40635196817) | 8 | 4 | 8 | 28853 | 19 | |||
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 | |||
93649 | 197360 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 854 Rhode Island St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6011832.54279 | 2104397.74705 | 37.7589419122575 | -122.402119022102 | (37.7589419122575, -122.402119022102) | 10 | 3 | 8 | 28856 | 29 | |||
138751 | 197361 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 854 Rhode Island St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6011833.16628 | 2104382.68737 | 37.7589005965113 | -122.402115807021 | (37.7589005965113, -122.402115807021) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
150212 | 197363 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2250 Revere Ave | 9 | : | Tree | Private 2 | 4 | Width 3ft | 6011532.16861 | 2097082.05033 | 37.7388378277964 | -122.402643401474 | (37.7388378277964, -122.402643401474) | 10 | 3 | 8 | 58 | 1 | |||
145378 | 197364 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 19 Decatur St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6010722.19817 | 2109437.33684 | 37.772717444075 | -122.40631421555 | (37.772717444075, -122.40631421555) | 14 | 2 | 9 | 28853 | 34 | |||
78190 | 197365 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 352 Tehama St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011403.86643 | 2112552.85537 | 37.781310045354 | -122.404175546789 | (37.781310045354, -122.404175546789) | 6 | 2 | 9 | 28853 | 34 | |||
109144 | 197366 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 34 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009876.04885 | 2111029.66508 | 37.7770422370334 | -122.40935354454 | (37.7770422370334, -122.40935354454) | 8 | 2 | 9 | 28853 | 34 | |||
125725 | 214046 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1370 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990539.74795 | 2106066.50264 | 37.7623123950137 | -122.475880589844 | (37.7623123950137, -122.475880589844) | 1 | 8 | 3 | 56 | 12 | |||
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 | |||
135839 | 214048 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 834 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993109.23075 | 2106663.62725 | 37.7641005853884 | -122.467037200902 | (37.7641005853884, -122.467037200902) | 11 | 8 | 11 | 56 | 12 | |||
106255 | 214049 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1027 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992526.76202 | 2107262.97913 | 37.7657126093769 | -122.469095395662 | (37.7657126093769, -122.469095395662) | 11 | 8 | 11 | 56 | 12 | |||
69665 | 214050 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1025 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992561.5369 | 2107264.03733 | 37.7657175241692 | -122.468975194959 | (37.7657175241692, -122.468975194959) | 11 | 8 | 11 | 56 | 12 | |||
139021 | 214051 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1025 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992571.13216 | 2107264.43219 | 37.7657191627324 | -122.46894203606 | (37.7657191627324, -122.46894203606) | 11 | 8 | 11 | 56 | 12 | |||
115059 | 214052 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1453 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5992708.61466 | 2105570.39299 | 37.7610757201979 | -122.468343263835 | (37.7610757201979, -122.468343263835) | 1 | 8 | 4 | 56 | 12 | |||
160619 | 214053 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 2276 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991058.30826 | 2099931.05819 | 37.7454961285492 | -122.473639521573 | (37.7454961285492, -122.473639521573) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
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 | |||
75502 | 214056 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 241 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992137.11925 | 2095143.36951 | 37.732412767139 | -122.469560735453 | (37.732412767139, -122.469560735453) | 9 | 8 | 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 |
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) );