trees
861 rows where qSpecies_id = 18 sorted by qSiteInfo descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 115276 | 122590 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 MacOndray Ln | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6008161 | 2119143 | 37.7992232381339 | -122.415861106147 | (37.7992232381339, -122.415861106147) | 5 | 1 | 10 | 308 | 32 | |||||
| 16962 | 187077 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2600 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985155.4633 | 2096938.6014 | 37.736936021545 | -122.493829852855 | (37.736936021545, -122.493829852855) | 1 | 8 | 3 | 29491 | 35 | |||
| 36673 | 129452 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007720.96455 | 2120575.51523 | 37.8031318169312 | -122.417485363758 | (37.8031318169312, -122.417485363758) | 5 | 1 | 1 | 308 | 32 | |||
| 50767 | 227610 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 400 Prospect Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6006250.04952 | 2097648.94567 | 37.7400980729811 | -122.420946773391 | (37.7400980729811, -122.420946773391) | 2 | 7 | 7 | 28859 | 2 | ||||
| 55769 | 176926 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 200 Morse St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 6000586.22066 | 2087873.89241 | 37.7129371316064 | -122.439829268227 | (37.7129371316064, -122.439829268227) | 9 | 7 | 6 | 28861 | 5 | |||
| 56414 | 129456 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6007719.74229 | 2120576.43903 | 37.803134284681 | -122.417489658942 | (37.803134284681, -122.417489658942) | 5 | 1 | 1 | 308 | 32 | |||
| 74339 | 227660 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 195 Beacon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6003113.10037 | 2097586.0775 | 37.7397481278718 | -122.431788568281 | (37.7397481278718, -122.431788568281) | 2 | 7 | 5 | 63 | 7 | |||
| 80866 | 129453 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6007720.64474 | 2120576.42054 | 37.8031342846895 | -122.417486534671 | (37.8031342846895, -122.417486534671) | 5 | 1 | 1 | 308 | 32 | |||
| 82542 | 186908 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2700 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985188.8014 | 2096694.9245 | 37.736268900285 | -122.493696639188 | (37.736268900285, -122.493696639188) | 1 | 8 | 3 | 29491 | 35 | |||
| 84073 | 191265 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2100 Thomas Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6012134.75084 | 2095927.24781 | 37.7357006075903 | -122.400478845738 | (37.7357006075903, -122.400478845738) | 10 | 3 | 8 | 58 | 1 | ||||
| 87345 | 191264 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 801 Arkansas St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 6013055.03201 | 2103799.19748 | 37.7573665842245 | -122.397849067074 | (37.7573665842245, -122.397849067074) | 10 | 3 | 8 | 28856 | 29 | ||||
| 88043 | 191269 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 538 Delancey St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6015147.69888 | 2113724.07494 | 37.7847344271845 | -122.391305511737 | (37.7847344271845, -122.391305511737) | 6 | 2 | 9 | 28856 | 6 | ||||
| 92397 | 248214 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 67 Fair Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 6ft | 6006956.2223 | 2099478.83098 | 37.7451623091856 | -122.41863484214 | (37.7451623091856, -122.41863484214) | 2 | 7 | 7 | 28859 | 2 | |||
| 96416 | 186909 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2700 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985192.0104 | 2096702.7177 | 37.7362904860675 | -122.493686118595 | (37.7362904860675, -122.493686118595) | 1 | 8 | 3 | 29491 | 35 | |||
| 98350 | 227609 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 400 Prospect Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6006260.17283 | 2097644.39448 | 37.740086147061 | -122.420911448013 | (37.740086147061, -122.420911448013) | 2 | 7 | 7 | 28859 | 2 | ||||
| 101952 | 191250 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6015147.38841 | 2105382.23529 | 37.7618295678896 | -122.390723435432 | (37.7618295678896, -122.390723435432) | 10 | 3 | 8 | 28856 | 29 | |||
| 102470 | 185052 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2715 41st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5983668.1125 | 2096649.8142 | 37.7360559577629 | -122.498950875232 | (37.7360559577629, -122.498950875232) | 1 | 8 | 3 | 29491 | 35 | |||
| 102631 | 207098 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6000468.8354 | 2095254.59465 | 37.7331961737441 | -122.440764091915 | (37.7331961737441, -122.440764091915) | 9 | 7 | 5 | 63 | 40 | ||||
| 111065 | 186817 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1200 Sunset Blvd | 110 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984826.8059 | 2106810.865 | 37.7640233139964 | -122.495694129376 | (37.7640233139964, -122.495694129376) | 1 | 8 | 3 | 56 | 35 | |||
| 115877 | 191267 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 538 Delancey St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6015157.46118 | 2113744.49366 | 37.7847910341296 | -122.391273164948 | (37.7847910341296, -122.391273164948) | 6 | 2 | 9 | 28856 | 6 | ||||
| 117025 | 187130 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2600 Sunset Blvd | 66 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985156.874 | 2097417.7557 | 37.7382517335963 | -122.493860275789 | (37.7382517335963, -122.493860275789) | 1 | 8 | 3 | 29491 | 35 | |||
| 117570 | 96626 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 145 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.7759857009664 | -122.50890252539 | (37.7759857009664, -122.50890252539) | 11 | 6 | 2 | 55 | 26 | |||
| 122965 | 191252 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6015147.22099 | 2105373.94992 | 37.7618068087648 | -122.390723435452 | (37.7618068087648, -122.390723435452) | 10 | 3 | 8 | 28856 | 29 | |||
| 123209 | 185051 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2715 41st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5983667.0512 | 2096660.9577 | 37.736086492552 | -122.498955367569 | (37.736086492552, -122.498955367569) | 1 | 8 | 3 | 29491 | 35 | |||
| 133324 | 227621 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1335 Douglass St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6001398.3282 | 2099807.15248 | 37.7457493236871 | -122.437876554075 | (37.7457493236871, -122.437876554075) | 2 | 4 | 5 | 63 | 22 | |||
| 136872 | 129455 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007721.09596 | 2120576.41129 | 37.8031342846798 | -122.417484972552 | (37.8031342846798, -122.417484972552) | 5 | 1 | 1 | 308 | 32 | |||
| 140684 | 176927 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 200 Morse St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 10ft | 6000575.21017 | 2087869.90013 | 37.7129255429455 | -122.439867037942 | (37.7129255429455, -122.439867037942) | 9 | 7 | 6 | 28861 | 5 | |||
| 143309 | 176963 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 83 Badger St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 2ft | 6002428.97482 | 2094295.2581 | 37.7306734890866 | -122.433918818513 | (37.7306734890866, -122.433918818513) | 9 | 7 | 5 | 28861 | 25 | |||
| 156724 | 129454 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007720.06236 | 2120575.53372 | 37.8031318169374 | -122.41748848713 | (37.8031318169374, -122.41748848713) | 5 | 1 | 1 | 308 | 32 | |||
| 161594 | 191268 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 538 Delancey St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6015150.51675 | 2113731.33336 | 37.7847545135408 | -122.391296270324 | (37.7847545135408, -122.391296270324) | 6 | 2 | 9 | 28856 | 6 | ||||
| 172712 | 191251 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6015148.84129 | 2105378.48456 | 37.7618193498029 | -122.390718148336 | (37.7618193498029, -122.390718148336) | 10 | 3 | 8 | 28856 | 29 | |||
| 175436 | 227601 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1100 San Jose Ave | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6004769.19859 | 2096667.0685 | 37.7373184762576 | -122.425997076417 | (37.7373184762576, -122.425997076417) | 2 | 7 | 5 | 63 | 7 | ||||
| 178232 | 191253 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6015148.44265 | 2105367.15882 | 37.7617882296504 | -122.390718735586 | (37.7617882296504, -122.390718735586) | 10 | 3 | 8 | 28856 | 29 | |||
| 188798 | 227662 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 32 Harry St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6003182.99622 | 2097643.55659 | 37.7399099141156 | -122.431551000691 | (37.7399099141156, -122.431551000691) | 2 | 7 | 5 | 63 | 7 | |||
| 194062 | 96627 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 145 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.7759857009664 | -122.50890252539 | (37.7759857009664, -122.50890252539) | 11 | 6 | 2 | 55 | 26 | |||
| 7739 | 262320 | Section 806 (d) 5 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2567 31st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/07/2020 12:00:00 AM | 3 | 6x10 | Permit Number 785009 | 5986744.29234 | 2097795.22153 | 37.7393809030196 | -122.48839957369 | (37.7393809030196, -122.48839957369) | 1 | 8 | 3 | 29491 | 35 | |
| 78623 | 97442 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1900@Gough Pacific Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004943.9 | 2117474.7 | 37.7944611255838 | -122.426874507837 | (37.7944611255838, -122.426874507837) | 13 | 9 | 1 | 28858 | 27 | |||||
| 5529 | 250619 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 114 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5987113.72203 | 2115192.60557 | 37.7871708695801 | -122.48840049988 | (37.7871708695801, -122.48840049988) | 11 | 6 | 1 | 55 | 33 | |||
| 8211 | 118727 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 744 44th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5982311.94927 | 2110684.47096 | 37.7745115225468 | -122.504679158367 | (37.7745115225468, -122.504679158367) | 11 | 6 | 2 | 55 | 26 | ||
| 50918 | 227611 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Balmy St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 6008811.16325 | 2101739.45031 | 37.751473726132 | -122.412380510571 | (37.751473726132, -122.412380510571) | 2 | 4 | 7 | 28859 | 19 | |||
| 61133 | 183581 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2614 26th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5988348.717 | 2097504.9177 | 37.738677287922 | -122.482830978923 | (37.738677287922, -122.482830978923) | 1 | 8 | 3 | 29491 | 35 | |||
| 61523 | 176925 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 17 Curtis St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000534.5551 | 2088493.30994 | 37.7146349724878 | -122.440052229032 | (37.7146349724878, -122.440052229032) | 9 | 7 | 6 | 28861 | 5 | |||
| 61944 | 207077 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994500.88494 | 2100452.87217 | 37.74712767141 | -122.461773548104 | (37.74712767141, -122.461773548104) | 1 | 8 | 4 | 29491 | 40 | |||
| 71092 | 250533 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 69 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5987683.92995 | 2115503.12844 | 37.7880567296852 | -122.486450536786 | (37.7880567296852, -122.486450536786) | 11 | 6 | 1 | 55 | 33 | |||
| 76983 | 207075 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5994498.16233 | 2100407.05536 | 37.7470017132656 | -122.461779641027 | (37.7470017132656, -122.461779641027) | 1 | 8 | 4 | 29491 | 40 | |||
| 79840 | 207070 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1927 08th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5993749.21516 | 2102356.41341 | 37.7523110111603 | -122.464510933358 | (37.7523110111603, -122.464510933358) | 1 | 8 | 4 | 29491 | 12 | |||
| 80586 | 207072 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 245 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994440.69834 | 2100406.16627 | 37.7469959638947 | -122.461978280579 | (37.7469959638947, -122.461978280579) | 1 | 8 | 4 | 29491 | 40 | |||
| 81946 | 207074 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994502.24516 | 2100385.66213 | 37.7469432078786 | -122.461763972133 | (37.7469432078786, -122.461763972133) | 1 | 8 | 4 | 29491 | 40 | |||
| 86778 | 176920 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 671 London St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6001061.12784 | 2089906.70665 | 37.7185458066272 | -122.438333380903 | (37.7185458066272, -122.438333380903) | 9 | 7 | 6 | 28861 | 5 | ||||
| 111319 | 182968 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2501 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5990431.4773 | 2098333.0499 | 37.7410720891089 | -122.475690312642 | (37.7410720891089, -122.475690312642) | 1 | 8 | 3 | 29491 | 35 | |||
| 111323 | 207069 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1927 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 5993748.4844 | 2102370.47272 | 37.7523495722986 | -122.46451448117 | (37.7523495722986, -122.46451448117) | 1 | 8 | 4 | 29491 | 12 | |||
| 114585 | 207071 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1927 08th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 5993749.48127 | 2102344.6615 | 37.7522787587656 | -122.464509159894 | (37.7522787587656, -122.464509159894) | 1 | 8 | 4 | 29491 | 12 | |||
| 126224 | 250620 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 114 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5987116.07946 | 2115204.5954 | 37.7872039277514 | -122.488393225281 | (37.7872039277514, -122.488393225281) | 11 | 6 | 1 | 55 | 33 | |||
| 138941 | 207095 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1565 Plymouth Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5995634.15192 | 2094407.35941 | 37.7305933513933 | -122.457417521726 | (37.7305933513933, -122.457417521726) | 9 | 7 | 4 | 28861 | 40 | |||
| 140567 | 250532 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 79 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 5987685.24066 | 2115481.63254 | 37.7879977845133 | -122.486444423174 | (37.7879977845133, -122.486444423174) | 11 | 6 | 1 | 55 | 33 | |||
| 157479 | 207076 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994497.66006 | 2100431.13069 | 37.7470677891411 | -122.461783123205 | (37.7470677891411, -122.461783123205) | 1 | 8 | 4 | 29491 | 40 | |||
| 175651 | 129401 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 5 Dicha Aly | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5998309.94171 | 2113772.92465 | 37.7839197016653 | -122.449561847418 | (37.7839197016653, -122.449561847418) | 15 | 6 | 1 | 54 | 31 | |||
| 176982 | 191363 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 955 Key Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6013550.52728 | 2089583.75311 | 37.7183615103672 | -122.395139727222 | (37.7183615103672, -122.395139727222) | 10 | 3 | 8 | 58 | 1 | ||||
| 181058 | 183580 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2614 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5988349.2799 | 2097484.0905 | 37.7386201346216 | -122.482827506776 | (37.7386201346216, -122.482827506776) | 1 | 8 | 3 | 29491 | 35 | |||
| 188836 | 207073 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994505.45248 | 2100370.55426 | 37.746901910105 | -122.461751786336 | (37.746901910105, -122.461751786336) | 1 | 8 | 4 | 29491 | 40 | |||
| 12709 | 129426 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Broadway | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6003248.10705 | 2117506.03033 | 37.7944511216749 | -122.432744393832 | (37.7944511216749, -122.432744393832) | 13 | 9 | 1 | 29490 | 27 | |||
| 45106 | 246316 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006848.8767 | 2108962.1326 | 37.7711952166815 | -122.41967876451 | (37.7711952166815, -122.41967876451) | 8 | 2 | 9 | 28853 | 19 | |||
| 46340 | 129439 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010043.54378 | 2115756.33064 | 37.7900299214 | -122.409107728349 | (37.7900299214, -122.409107728349) | 5 | 1 | 10 | 28857 | 21 | |||
| 67835 | 129427 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Broadway | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6003257.40294 | 2117505.83832 | 37.7944511216666 | -122.43271221522 | (37.7944511216666, -122.43271221522) | 13 | 9 | 1 | 29490 | 27 | |||
| 81001 | 246317 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006842.0158 | 2108939.8347 | 37.7711336054687 | -122.419700914309 | (37.7711336054687, -122.419700914309) | 8 | 2 | 9 | 28853 | 19 | |||
| 129419 | 129425 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Broadway | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6003239.07369 | 2117504.42466 | 37.794446200597 | -122.432775535577 | (37.794446200597, -122.432775535577) | 13 | 9 | 1 | 29490 | 27 | |||
| 144399 | 129436 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010030.57511 | 2115756.25526 | 37.7900289879055 | -122.409152593735 | (37.7900289879055, -122.409152593735) | 5 | 1 | 10 | 28857 | 21 | |||
| 144752 | 246315 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006857.4528 | 2108984.4305 | 37.7712569245067 | -122.419650681714 | (37.7712569245067, -122.419650681714) | 8 | 2 | 9 | 28853 | 19 | |||
| 155967 | 246318 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 6006836.8702 | 2108926.9706 | 37.7710979938489 | -122.419717800254 | (37.7710979938489, -122.419717800254) | 8 | 2 | 9 | 28853 | 19 | |||
| 155983 | 129437 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010035.0094 | 2115756.16478 | 37.7900289878849 | -122.409137245009 | (37.7900289878849, -122.409137245009) | 5 | 1 | 10 | 28857 | 21 | |||
| 188316 | 246314 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 6006868.6018 | 2109014.4469 | 37.7713399704187 | -122.419614246796 | (37.7713399704187, -122.419614246796) | 8 | 2 | 9 | 28853 | 19 | |||
| 189800 | 191249 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2300 18th St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 10ft | 6010915.57021 | 2105542.63703 | 37.7620342994705 | -122.405370986778 | (37.7620342994705, -122.405370986778) | 8 | 3 | 8 | 28856 | 29 | |||
| 190708 | 129438 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010041.47641 | 2115755.35321 | 37.7900271217973 | -122.409114812309 | (37.7900271217973, -122.409114812309) | 5 | 1 | 10 | 28857 | 21 | |||
| 30 | 254372 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 62 Tioga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778036 | 6010859.22958 | 2088882.34048 | 37.7162855403434 | -122.404393121162 | (37.7162855403434, -122.404393121162) | 9 | 7 | 8 | 309 | 39 |
| 629 | 259747 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1674 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6014811.75538 | 2097073.30447 | 37.7389963714409 | -122.391303417459 | (37.7389963714409, -122.391303417459) | 10 | 3 | 8 | 58 | 1 | ||
| 697 | 19206 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 630 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012230.08543 | 2117977.14861 | 37.7962500076802 | -122.401698594427 | (37.7962500076802, -122.401698594427) | 3 | 1 | 10 | 28860 | 4 | |||
| 943 | 103518 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 5234 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770228 | 5999957.27012 | 2088737.63684 | 37.7152729578673 | -122.442065082634 | (37.7152729578673, -122.442065082634) | 9 | 7 | 6 | 28861 | 25 | |
| 1319 | 227653 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3750 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003384.06107 | 2103624.93542 | 37.7563447763019 | -122.431282651989 | (37.7563447763019, -122.431282651989) | 2 | 4 | 5 | 28862 | 3 | |||
| 1422 | 259801 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 2229 | 227630 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 10 Arbor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002176.82031 | 2096986.40745 | 37.7380484541639 | -122.43498294672 | (37.7380484541639, -122.43498294672) | 2 | 7 | 5 | 63 | 7 | |||
| 2588 | 101345 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 600 Chestnut St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 22 | Permit Number 32655 | 6008773.8267 | 2120774.1665 | 37.8037364477628 | -122.413855954453 | (37.8037364477628, -122.413855954453) | 3 | 1 | 10 | 308 | 23 | ||
| 2631 | 176979 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Winding Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6002427.23589 | 2086817.03836 | 37.7101398650242 | -122.433390645786 | (37.7101398650242, -122.433390645786) | 9 | 7 | 6 | 28861 | 5 | |||
| 2814 | 191330 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014815.79386 | 2110104.24777 | 37.7747767728644 | -122.392200554832 | (37.7747767728644, -122.392200554832) | 14 | 3 | 9 | 310 | ||||
| 2930 | 31151 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 666 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/2019 02:39:00 PM | 3 | Permit Number 34854 | 5997015.55395 | 2094425.74026 | 37.7307230695921 | -122.452643159453 | (37.7307230695921, -122.452643159453) | 9 | 7 | 4 | 59 | 40 | |
| 3046 | 258383 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007919.90114 | 2093441.26607 | 37.7286386864609 | -122.414875367562 | (37.7286386864609, -122.414875367562) | 9 | 3 | 7 | 309 | 28 | |||
| 3259 | 207067 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 319 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992889.43355 | 2094705.13069 | 37.7312529231878 | -122.466927982745 | (37.7312529231878, -122.466927982745) | 9 | 8 | 4 | 59 | 40 | |||
| 3342 | 258384 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007919.90114 | 2093441.26607 | 37.7286386864609 | -122.414875367562 | (37.7286386864609, -122.414875367562) | 9 | 3 | 7 | 309 | 28 | |||
| 3361 | 261454 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 3379 | 258367 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 901 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | ||||||||||||||
| 3785 | 258385 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007919.90114 | 2093441.26607 | 37.7286386864609 | -122.414875367562 | (37.7286386864609, -122.414875367562) | 9 | 3 | 7 | 309 | 28 | ||||
| 4194 | 143382 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1600 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005275.1713 | 2118900.2974 | 37.7983941790308 | -122.425829789965 | (37.7983941790308, -122.425829789965) | 13 | 9 | 1 | 57 | 17 | |||
| 4446 | 94086 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1727 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53469 | 5987161.9603 | 2103493.9012 | 37.7550523122054 | -122.487373962851 | (37.7550523122054, -122.487373962851) | 1 | 8 | 3 | 56 | 35 | |
| 4492 | 260884 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 195 26th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5987712.04911 | 2114688.49303 | 37.7858216131413 | -122.486293421393 | (37.7858216131413, -122.486293421393) | 11 | 6 | 1 | 55 | 33 | |||
| 4504 | 48452 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 740 Euclid Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5996026.36682 | 2113840.43033 | 37.7839741521628 | -122.457467011011 | (37.7839741521628, -122.457467011011) | 11 | 6 | 1 | 54 | 31 | ||
| 4681 | 6924 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 446 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X4 | 6005254.8423 | 2110638.1989 | 37.775707366557 | -122.425311885836 | (37.775707366557, -122.425311885836) | 7 | 9 | 11 | 28852 | 10 | |||
| 4785 | 16923 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 503 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 6004556.4237 | 2110140.1804 | 37.7743004469023 | -122.427692399322 | (37.7743004469023, -122.427692399322) | 7 | 9 | 11 | 28852 | 10 | ||||
| 4788 | 71255 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1392 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6007494.44606 | 2117816.87319 | 37.7955445300156 | -122.418073553678 | (37.7955445300156, -122.418073553678) | 5 | 1 | 10 | 28858 | 32 | |||
| 5176 | 260916 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1726 Page St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998303.71415 | 2108967.89528 | 37.7707259785013 | -122.449237098474 | (37.7707259785013, -122.449237098474) | 15 | 5 | 11 | 29492 | 9 | |||
| 5696 | 227632 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 71 Clarendon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997917 | 2104594 | 37.7586942433209 | -122.450259411288 | (37.7586942433209, -122.450259411288) | 15 | 5 | 4 | 28862 | 38 | |||
| 6189 | 260917 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1740 Page St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998239.87383 | 2108958.8784 | 37.7706975687071 | -122.44945727244 | (37.7706975687071, -122.44945727244) | 15 | 5 | 11 | 29492 | 9 |
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) );