trees
2,694 rows where qSpecies_id = 84 sorted by Zip Codes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1475 | 80073 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2788 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5985889.2586 | 2096432.3825 | 37.735588983385 | -122.491255586179 | (37.735588983385, -122.491255586179) | 1 | 8 | 3 | 64 | 35 | |||
2591 | 92319 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2788 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985889.2586 | 2096423.8922 | 37.7355656712712 | -122.491254961509 | (37.7355656712712, -122.491254961509) | 1 | 8 | 3 | 64 | 35 | ||
4346 | 32173 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 117 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.494326297163 | (37.7296644874619, -122.494326297163) | 1 | 8 | 4 | 64 | 35 | ||
11410 | 25472 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 205X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 6 | 3X3 | 5993432.494 | 2088486.2672 | 37.7142087634879 | -122.464599140586 | (37.7142087634879, -122.464599140586) | 9 | 8 | 6 | 64 | 24 | ||
12911 | 25471 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 237 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993297.6081 | 2088487.2193 | 37.7142036007288 | -122.465065423908 | (37.7142036007288, -122.465065423908) | 9 | 8 | 6 | 64 | 24 | ||
25943 | 32174 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 119 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.494335637657 | (37.7296472241819, -122.494335637657) | 1 | 8 | 4 | 64 | 35 | ||
36059 | 38916 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 151 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40727 | 5991915.78904323 | 2089537.41535132 | 37.7170074074891 | -122.469917900123 | (37.7170074074891, -122.469917900123) | 9 | 8 | 6 | 64 | 24 | ||
36657 | 214421 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 447 Head St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5993467.53824 | 2088847.90842 | 37.7152037640188 | -122.464504257681 | (37.7152037640188, -122.464504257681) | 9 | 8 | 6 | 64 | 24 | |||
36820 | 32170 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 117 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.494326297163 | (37.7296644874619, -122.494326297163) | 1 | 8 | 4 | 64 | 35 | ||
36933 | 18597 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 415 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1999 12:00:00 AM | 6 | 3X3 | 5992871.5273 | 2088492.4561 | 37.7141934014371 | -122.466538492306 | (37.7141934014371, -122.466538492306) | 9 | 8 | 6 | 64 | 24 | ||
44234 | 50018 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 375 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46752 | 5992447.36096557 | 2090326.79664317 | 37.7192055701762 | -122.468137918171 | (37.7192055701762, -122.468137918171) | 9 | 8 | 6 | 64 | 24 | ||
60086 | 45551 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 345 Sloat Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | Permit Number 44299 | 5990416.87578702 | 2095931.52068495 | 37.7344772588746 | -122.475565486654 | (37.7344772588746, -122.475565486654) | 1 | 8 | 4 | 64 | 35 | |||
60398 | 214424 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 732 Shields St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5992045.19947 | 2089870.88734 | 37.7179305201634 | -122.469494855606 | (37.7179305201634, -122.469494855606) | 9 | 8 | 6 | 64 | 24 | |||
63949 | 32171 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 117 Lakeshore Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.494326297163 | (37.7296644874619, -122.494326297163) | 1 | 8 | 4 | 64 | 35 | ||
65104 | 45349 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 442 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44764 | 5992505.35292147 | 2090807.04622062 | 37.7205275676125 | -122.467972377091 | (37.7205275676125, -122.467972377091) | 9 | 8 | 6 | 64 | 24 | ||
83550 | 47347 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 752 Head St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45273 | 5993544.85331051 | 2090864.0101395 | 37.7207439512448 | -122.464383317404 | (37.7207439512448, -122.464383317404) | 9 | 8 | 6 | 64 | 24 | ||
89877 | 47355 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 375 Ralston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45280 | 5992186.9428459 | 2090329.99196799 | 37.7191993003756 | -122.469038309031 | (37.7191993003756, -122.469038309031) | 9 | 8 | 6 | 64 | 24 | ||
97892 | 214419 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 479 Ramsell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5992969.97647 | 2090349.42697 | 37.7192978763685 | -122.466333093823 | (37.7192978763685, -122.466333093823) | 9 | 8 | 6 | 64 | 24 | |||
104136 | 45312 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 333 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44759 | 5991931.79579935 | 2090744.40687829 | 37.7203224367541 | -122.469950404817 | (37.7203224367541, -122.469950404817) | 9 | 8 | 6 | 64 | 24 | ||
113748 | 214427 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 55 Cranleigh Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5991235.53196 | 2095666.85517 | 37.7337979784868 | -122.472715858468 | (37.7337979784868, -122.472715858468) | 1 | 8 | 4 | 64 | 40 | |||
121074 | 45309 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 238 Beverly St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44147 | 5991464.05254061 | 2090792.05998046 | 37.7204262308827 | -122.471570695131 | (37.7204262308827, -122.471570695131) | 9 | 8 | 6 | 64 | 24 | ||
123220 | 45351 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 455 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | Permit Number 44765 | 5992454.32883637 | 2090891.06433755 | 37.7207553141827 | -122.46815485821 | (37.7207553141827, -122.46815485821) | 9 | 8 | 6 | 64 | 24 | ||
126419 | 45358 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 434 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | Permit Number 44766 | 5993275.26942875 | 2090069.89309509 | 37.7185479545501 | -122.465257525662 | (37.7185479545501, -122.465257525662) | 9 | 8 | 6 | 64 | 24 | ||
127416 | 45546 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 345 Sloat Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | Permit Number 44299 | 5990416.87578702 | 2095931.52068495 | 37.7344772588746 | -122.475565486654 | (37.7344772588746, -122.475565486654) | 1 | 8 | 4 | 64 | 35 | ||
129196 | 214423 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 447 Bright St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5993753.59221 | 2090152.37899 | 37.7188020135797 | -122.463610156194 | (37.7188020135797, -122.463610156194) | 9 | 8 | 6 | 64 | 24 | |||
131222 | 32172 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 117 Lakeshore Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.494326297163 | (37.7296644874619, -122.494326297163) | 1 | 8 | 4 | 64 | 35 | ||
132375 | 38910 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 542 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40722 | 5992764.33916068 | 2090804.00808724 | 37.7205341782239 | -122.46707693099 | (37.7205341782239, -122.46707693099) | 9 | 8 | 6 | 64 | 24 | ||
143097 | 214420 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 466 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993273.26213 | 2090266.31835 | 37.7190871751261 | -122.465278724129 | (37.7190871751261, -122.465278724129) | 9 | 8 | 6 | 64 | 24 | |||
144156 | 32169 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 117 Lakeshore Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.494326297163 | (37.7296644874619, -122.494326297163) | 1 | 8 | 4 | 64 | 35 | ||
147295 | 38915 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 147 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40726 | 5991915.47880902 | 2089512.34448242 | 37.7169385510534 | -122.469917148086 | (37.7169385510534, -122.469917148086) | 9 | 8 | 6 | 64 | 24 | ||
149749 | 36259 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 25 Elmhurst Dr | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39270 | 5991200.33310514 | 2094436.30103714 | 37.7304171492597 | -122.472747856373 | (37.7304171492597, -122.472747856373) | 9 | 8 | 4 | 64 | 40 | ||
158048 | 36258 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 25 Elmhurst Dr | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39270 | 5991200.33310514 | 2094436.30103714 | 37.7304171492597 | -122.472747856373 | (37.7304171492597, -122.472747856373) | 9 | 8 | 4 | 64 | 40 | ||
158805 | 214426 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 41 Lagunitas Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991077.3957 | 2095586.31529 | 37.7335676810093 | -122.473256705357 | (37.7335676810093, -122.473256705357) | 1 | 8 | 4 | 64 | 40 | |||
162367 | 47354 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 375 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45280 | 5992186.9428459 | 2090329.99196799 | 37.7191993003756 | -122.469038309031 | (37.7191993003756, -122.469038309031) | 9 | 8 | 6 | 64 | 24 | ||
168017 | 45484 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3036 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | Permit Number 44264 | 5990299.6759109 | 2095068.01075494 | 37.7320994854452 | -122.475907639335 | (37.7320994854452, -122.475907639335) | 1 | 8 | 4 | 64 | 35 | ||
170403 | 36282 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 62 Rossmoor Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1998 12:00:00 AM | Permit Number 39280 | 5990920.84116695 | 2094554.1128949 | 37.7307244477014 | -122.47372268091 | (37.7307244477014, -122.47372268091) | 9 | 8 | 4 | 64 | 40 | ||
170729 | 214422 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 529 Bright St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5993759.81051 | 2090686.52668 | 37.7202690128731 | -122.463627407878 | (37.7202690128731, -122.463627407878) | 9 | 8 | 6 | 64 | 24 | |||
172802 | 47334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 142 Garfield St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45265 | 5993656.96278859 | 2090531.97182441 | 37.7198387158131 | -122.463971702484 | (37.7198387158131, -122.463971702484) | 9 | 8 | 6 | 64 | 24 | ||
173484 | 52967 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 430 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48951 | 5992913.39477217 | 2090514.51004168 | 37.7197478895212 | -122.466540666402 | (37.7197478895212, -122.466540666402) | 9 | 8 | 6 | 64 | 24 | ||
176071 | 214425 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 41 Lagunitas Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991075.83745 | 2095563.72513 | 37.7335055639152 | -122.473260445626 | (37.7335055639152, -122.473260445626) | 1 | 8 | 4 | 64 | 40 | |||
176822 | 47346 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 752 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45273 | 5993544.85331051 | 2090864.0101395 | 37.7207439512448 | -122.464383317404 | (37.7207439512448, -122.464383317404) | 9 | 8 | 6 | 64 | 24 | ||
189902 | 45359 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 438 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | Permit Number 44767 | 5993275.62106747 | 2090094.58069454 | 37.71861576102 | -122.465258102457 | (37.71861576102, -122.465258102457) | 9 | 8 | 6 | 64 | 24 | ||
193399 | 32175 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 119 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.494335637657 | (37.7296472241819, -122.494335637657) | 1 | 8 | 4 | 64 | 35 | ||
2384 | 61000 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 569 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1983 12:00:00 AM | 3x3 | Permit Number 20813 | 6003055.65980298 | 2095965.62236934 | 37.7352954735478 | -122.43187149765 | (37.7352954735478, -122.43187149765) | 2 | 7 | 5 | 63 | 7 | |
4426 | 42126 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 54 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42422 | 5999645.50083885 | 2093804.90397788 | 37.7291687386678 | -122.44350647351 | (37.7291687386678, -122.44350647351) | 9 | 7 | 4 | 63 | 40 | ||
5165 | 39388 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 414 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40926 | 6003200.97263054 | 2099519.74958744 | 37.7450625247242 | -122.431622760195 | (37.7450625247242, -122.431622760195) | 2 | 7 | 5 | 63 | 22 | ||
5687 | 66315 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 94 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29430 | 6001458.61740114 | 2094962.10093841 | 37.7324493716412 | -122.43732121741 | (37.7324493716412, -122.43732121741) | 9 | 7 | 5 | 63 | 40 | ||
7568 | 247783 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 278 30th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004785 | 2098454 | 37.7422258778278 | -122.426069615856 | (37.7422258778278, -122.426069615856) | 2 | 7 | 5 | 63 | 22 | |||
12189 | 9378 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 320 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6001091.8143019 | 2097867.0769739 | 37.7404048998329 | -122.438797433034 | (37.7404048998329, -122.438797433034) | 2 | 7 | 5 | 63 | 7 | |||
14580 | 33345 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 90 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37482 | 6001488.85408541 | 2094961.63013744 | 37.7324497978026 | -122.437216648553 | (37.7324497978026, -122.437216648553) | 9 | 7 | 5 | 63 | 40 | ||
17765 | 47693 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 469 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45492 | 6003825.81919033 | 2095934.94010265 | 37.7352548563783 | -122.429206586085 | (37.7352548563783, -122.429206586085) | 2 | 7 | 5 | 63 | 7 | ||
22237 | 214456 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 87 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001455.73616 | 2094912.80793 | 37.7323138605989 | -122.437327650168 | (37.7323138605989, -122.437327650168) | 9 | 7 | 4 | 63 | 40 | |||
23717 | 34392 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 224 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 3x3 | Permit Number 38139 | 6004139.10762167 | 2096768.34817433 | 37.7375609365762 | -122.428182808375 | (37.7375609365762, -122.428182808375) | 2 | 7 | 5 | 63 | 7 | |
28066 | 60426 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 419 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31497 | 6003853.1521524 | 2098925.15717718 | 37.7434668562001 | -122.42932524739 | (37.7434668562001, -122.42932524739) | 2 | 7 | 5 | 63 | 22 | ||
28149 | 66486 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1249 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/11/1995 12:00:00 AM | Permit Number 29644 | 6001993.92137577 | 2100462.92046027 | 37.7475837581962 | -122.435863994873 | (37.7475837581962, -122.435863994873) | 2 | 4 | 5 | 63 | 22 | ||
29311 | 64131 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 619 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 24902 | 6002577.32467051 | 2098854.14366792 | 37.743199557291 | -122.433731658795 | (37.743199557291, -122.433731658795) | 2 | 7 | 5 | 63 | 7 | ||
32041 | 45666 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 248 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/2001 12:00:00 AM | Permit Number 44362 | 6004322.96019847 | 2098710.22232116 | 37.7429032809545 | -122.427685458336 | (37.7429032809545, -122.427685458336) | 2 | 7 | 5 | 63 | 22 | ||
32514 | 246499 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 311 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779776 | 6004393.83338 | 2099835.13521 | 37.7459960419019 | -122.427520522551 | (37.7459960419019, -122.427520522551) | 2 | 7 | 5 | 63 | 22 | |
38376 | 35406 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 332 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/16/2004 12:00:00 AM | Permit Number 38861 | 6003780.41618424 | 2098680.34067413 | 37.7427905283735 | -122.429559293939 | (37.7427905283735, -122.429559293939) | 2 | 7 | 5 | 63 | 22 | ||
39770 | 122604 | - 12 | Prunus serrulata :: Ornamental Cherry 84 | 132 Surrey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779127 | 6002205.30607 | 2096205.31937 | 37.7359053840536 | -122.434828615692 | (37.7359053840536, -122.434828615692) | 2 | 7 | 5 | 63 | 7 | |
40414 | 214471 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 273 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000292.89042 | 2094938.17921 | 37.7323173490585 | -122.441349683656 | (37.7323173490585, -122.441349683656) | 9 | 7 | 4 | 63 | 40 | |||
42362 | 43582 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1623 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43243 | 6003373.31451853 | 2098789.66014494 | 37.7430676354641 | -122.430974736071 | (37.7430676354641, -122.430974736071) | 2 | 7 | 5 | 63 | 22 | ||
43443 | 187656 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1548 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003789 | 2099328 | 37.744569337434 | -122.42957579342 | (37.744569337434, -122.42957579342) | 2 | 7 | 5 | 63 | 22 | ||||
47035 | 47713 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 100 Bemis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | 2 | 7 | 5 | 63 | 7 | ||
48161 | 42417 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 273 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42567 | 6000281.10617536 | 2094927.9398225 | 37.7322885627641 | -122.441389689923 | (37.7322885627641, -122.441389689923) | 9 | 7 | 4 | 63 | 40 | ||
53173 | 36247 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 134 Surrey St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1998 12:00:00 AM | Permit Number 39267 | 6002197.13789926 | 2096205.20394281 | 37.7359046033608 | -122.434856848009 | (37.7359046033608, -122.434856848009) | 2 | 7 | 5 | 63 | 7 | |||
56957 | 64805 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1425 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25804 | 6003950.13397491 | 2099979.34039052 | 37.7463668898084 | -122.429065055592 | (37.7463668898084, -122.429065055592) | 2 | 7 | 5 | 63 | 22 | ||
57432 | 30797 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 142 Acadia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | Permit Number 34664 | 6001440.7282053 | 2094773.69226545 | 37.7319310278176 | -122.437369578033 | (37.7319310278176, -122.437369578033) | 9 | 7 | 4 | 63 | 40 | ||
57626 | 34619 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 205 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38302 | 6004548.03715501 | 2099548.66698547 | 37.7452181868086 | -122.426966907077 | (37.7452181868086, -122.426966907077) | 2 | 7 | 5 | 63 | 22 | ||
57746 | 34382 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 520 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | 3x3 | Permit Number 38132 | 6003249.18885376 | 2096183.56473871 | 37.735904862626 | -122.431217948328 | (37.735904862626, -122.431217948328) | 2 | 7 | 5 | 63 | 7 | ||
58337 | 43577 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1604 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43238 | 6002000.92857203 | 2099413.61265297 | 37.744703004335 | -122.435764701149 | (37.744703004335, -122.435764701149) | 2 | 7 | 5 | 63 | 22 | ||
58343 | 47712 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 100 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | 2 | 7 | 5 | 63 | 7 | ||
64859 | 214472 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 249 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 6000443.47619 | 2094924.07855 | 37.7322872091904 | -122.440828064285 | (37.7322872091904, -122.440828064285) | 9 | 7 | 4 | 63 | 40 | |||
66850 | 238006 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 120 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6002226.03876 | 2096243.00701 | 37.7360100427193 | -122.434759628851 | (37.7360100427193, -122.434759628851) | 2 | 7 | 5 | 63 | 7 | |||
66967 | 34394 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 124 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 3 | Permit Number 38141 | 6002617.96680614 | 2096893.03282917 | 37.7378171074636 | -122.433451015032 | (37.7378171074636, -122.433451015032) | 2 | 7 | 5 | 63 | 7 | |
69759 | 214458 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 87 Joost Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001469.66795 | 2094911.12879 | 37.7323100420653 | -122.437279364672 | (37.7323100420653, -122.437279364672) | 9 | 7 | 4 | 63 | 40 | |||
74282 | 47714 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 100 Bemis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | 2 | 7 | 5 | 63 | 7 | ||
76634 | 36246 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 134 Surrey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1998 12:00:00 AM | Permit Number 39267 | 6002197.13789926 | 2096205.20394281 | 37.7359046033608 | -122.434856848009 | (37.7359046033608, -122.434856848009) | 2 | 7 | 5 | 63 | 7 | |||
78119 | 214457 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 87 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001468.0488 | 2094911.62577 | 37.7323113146131 | -122.437284998007 | (37.7323113146131, -122.437284998007) | 9 | 7 | 4 | 63 | 40 | |||
79284 | 34439 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 166 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38183 | 6001888.55878785 | 2096500.99101298 | 37.7366992413933 | -122.435944884805 | (37.7366992413933, -122.435944884805) | 2 | 7 | 5 | 63 | 7 | ||
79867 | 42128 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 62 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42424 | 5999607.24235334 | 2093805.46920105 | 37.7291681086723 | -122.443638776439 | (37.7291681086723, -122.443638776439) | 9 | 7 | 4 | 63 | 40 | ||
80224 | 67853 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 312 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31523 | 6004481.54507681 | 2099889.33165024 | 37.7461498135161 | -122.427221086938 | (37.7461498135161, -122.427221086938) | 2 | 7 | 5 | 63 | 22 | ||
85027 | 238001 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 591 27th St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | 6002762.01889 | 2100032.14119 | 37.7464445418877 | -122.433177187196 | (37.7464445418877, -122.433177187196) | 2 | 7 | 5 | 63 | 22 | ||||
85708 | 101473 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 1X Melrose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000100 | 2095441 | 37.7336869872758 | -122.442052627426 | (37.7336869872758, -122.442052627426) | 9 | 7 | 4 | 63 | 40 | |||||
88027 | 214470 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 273 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6000290.09007 | 2094924.97364 | 37.7322809301091 | -122.441358417874 | (37.7322809301091, -122.441358417874) | 9 | 7 | 4 | 63 | 40 | |||
88113 | 214455 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 449 Baden St | 1 | Side Yard : Yard | Tree | Private 2 | 10 | Width 8ft | 6000738.08484 | 2095503.40232 | 37.733894671806 | -122.439851058803 | (37.733894671806, -122.439851058803) | 9 | 7 | 5 | 63 | 40 | |||
89319 | 64797 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 481 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25796 | 6003405.20909868 | 2100070.2281285 | 37.7465855850582 | -122.430955826913 | (37.7465855850582, -122.430955826913) | 2 | 7 | 5 | 63 | 22 | ||
91922 | 238034 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 49 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002532.9786 | 2096444.99653 | 37.7365820807996 | -122.433712847664 | (37.7365820807996, -122.433712847664) | 2 | 7 | 5 | 63 | 7 | |||
95380 | 238035 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 47 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002547.90945 | 2096426.13275 | 37.7365311324066 | -122.433659877604 | (37.7365311324066, -122.433659877604) | 2 | 7 | 5 | 63 | 7 | |||
96380 | 214462 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 139 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6000481.84259 | 2095189.99694 | 37.7330195442146 | -122.440714490676 | (37.7330195442146, -122.440714490676) | 9 | 7 | 5 | 63 | 40 | |||
98240 | 238005 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 118 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002126.98293 | 2096665.47856 | 37.7371644277915 | -122.435132311514 | (37.7371644277915, -122.435132311514) | 2 | 7 | 5 | 63 | 7 | |||
106223 | 36248 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 134 Surrey St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1998 12:00:00 AM | Permit Number 39267 | 6002197.13789926 | 2096205.20394281 | 37.7359046033608 | -122.434856848009 | (37.7359046033608, -122.434856848009) | 2 | 7 | 5 | 63 | 7 | |||
106366 | 119906 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 501x Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003371 | 2096193 | 37.7359376719491 | -122.430797472178 | (37.7359376719491, -122.430797472178) | 2 | 7 | 5 | 63 | 7 | ||||
108233 | 34369 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 71 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | 12 | 12x4. 5 | Permit Number 38124 | 6003708.03789498 | 2097975.15575924 | 37.7408501544429 | -122.429759271139 | (37.7408501544429, -122.429759271139) | 2 | 7 | 5 | 63 | 7 |
110170 | 42038 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1700 Church St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42358 | 6004596.89230657 | 2098983.86286022 | 37.7436701266667 | -122.426757759605 | (37.7436701266667, -122.426757759605) | 2 | 7 | 5 | 63 | 22 | |||
115476 | 42035 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1700 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42358 | 6004596.89230657 | 2098983.86286022 | 37.7436701266667 | -122.426757759605 | (37.7436701266667, -122.426757759605) | 2 | 7 | 5 | 63 | 22 | ||
115656 | 121604 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 132 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779127 | 6002211 | 2096230 | 37.7359734746513 | -122.434810693949 | (37.7359734746513, -122.434810693949) | 2 | 7 | 5 | 63 | 7 | |
115964 | 238004 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 569 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6003031.46134 | 2095960.14105 | 37.7352790512837 | -122.431954769317 | (37.7352790512837, -122.431954769317) | 2 | 7 | 5 | 63 | 7 | |||
117177 | 214459 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 87 Joost Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6001485.72244 | 2094910.79641 | 37.7323100420719 | -122.437223836928 | (37.7323100420719, -122.437223836928) | 9 | 7 | 4 | 63 | 40 | |||
117213 | 34377 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 192 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/13/1997 12:00:00 AM | Permit Number 38132 | 6004119.49989193 | 2097245.26729923 | 37.7388693385577 | -122.428284582088 | (37.7388693385577, -122.428284582088) | 2 | 7 | 5 | 63 | 7 |
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) );