trees
2,694 rows where qSpecies_id = 84 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
282 | 119806 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005545 | 2110174 | 37.7744491774234 | -122.424275134654 | (37.7744491774234, -122.424275134654) | 7 | 9 | 11 | 28852 | 10 | ||||
340 | 42995 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 436 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42871 | 6004515.16540478 | 2110012.02065503 | 37.7739462176361 | -122.42782598565 | (37.7739462176361, -122.42782598565) | 7 | 9 | 11 | 28852 | 10 | ||
647 | 259570 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Public Park | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994238 | 2098707 | 37.7423188086517 | -122.462555955845 | (37.7423188086517, -122.462555955845) | 1 | 8 | 4 | 59 | 40 | ||||
884 | 261406 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
1149 | 259572 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 298 Public Park | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994238 | 2098707 | 37.7423188086517 | -122.462555955845 | (37.7423188086517, -122.462555955845) | 1 | 8 | 4 | 59 | 40 | ||||
1961 | 259574 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 298 Public Park | 4 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994238 | 2098707 | 37.7423188086517 | -122.462555955845 | (37.7423188086517, -122.462555955845) | 1 | 8 | 4 | 59 | 40 | ||||
2074 | 64926 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2340 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 25954 | 5991486.3095246 | 2099579.02126823 | 37.7445543038697 | -122.472133919026 | (37.7445543038697, -122.472133919026) | 1 | 8 | 4 | 29491 | 40 | ||
2220 | 117168 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 299x ALMA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
2238 | 88648 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 74 Carmelita St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51628 | 6002619 | 2108775 | 37.7704422164895 | -122.434296675208 | (37.7704422164895, -122.434296675208) | 15 | 5 | 5 | 29492 | 9 | |||
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 | |
3071 | 31851 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
3161 | 68640 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1843 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32545 | 5990599.2738678 | 2102847.22998444 | 37.7534765784204 | -122.475439654249 | (37.7534765784204, -122.475439654249) | 1 | 8 | 4 | 56 | 12 | ||
3201 | 52387 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 136 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | Permit Number 48512 | 6005694.4540201 | 2096630.70014958 | 37.7372708656751 | -122.422795452389 | (37.7372708656751, -122.422795452389) | 2 | 7 | 7 | 28859 | 2 | ||
3526 | 65715 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 735 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1996 12:00:00 AM | Permit Number 28647 | 6009189.05467178 | 2115445.35577198 | 37.7891281538301 | -122.412042214215 | (37.7891281538301, -122.412042214215) | 5 | 1 | 10 | 28858 | 21 | ||
3665 | 261403 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 746 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010031.95335 | 2118510.77151 | 37.797592298166 | -122.409342294069 | (37.797592298166, -122.409342294069) | 3 | 1 | 10 | 308 | 4 | |||||
3995 | 59121 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 572 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2013 12:00:00 AM | Permit Number 770918 | 5992864.66737091 | 2111571.53492594 | 37.7775622694604 | -122.46824012776 | (37.7775622694604, -122.46824012776) | 11 | 6 | 2 | 54 | 11 | |||
4023 | 31850 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
4329 | 34818 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 443 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1997 12:00:00 AM | Permit Number 38451 | 5983428.96299375 | 2112819.28622042 | 37.7804387490097 | -122.500973171264 | (37.7804387490097, -122.500973171264) | 11 | 6 | 2 | 55 | 26 | ||
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 | ||
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 | ||
4527 | 35301 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3459 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/1998 12:00:00 AM | Permit Number 38773 | 6005812.46547868 | 2106053.59345559 | 37.763150623964 | -122.423056990755 | (37.763150623964, -122.423056990755) | 8 | 4 | 5 | 28859 | 19 | |||
4562 | 261421 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 780 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009867.40288 | 2118488.04976 | 37.7975206891225 | -122.409910080478 | (37.7975206891225, -122.409910080478) | 3 | 1 | 10 | 308 | 4 | |||||
4627 | 36424 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 300 Montecito Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39337 | 5996091.95170793 | 2094186.31684288 | 37.7300127063789 | -122.455818876187 | (37.7300127063789, -122.455818876187) | 9 | 7 | 4 | 28861 | 40 | |||
4740 | 119761 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
4762 | 84963 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 227 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51615 | 5999235.1 | 2094032 | 37.7297688774613 | -122.444941576876 | (37.7297688774613, -122.444941576876) | 9 | 7 | 4 | 28861 | 40 | ||
4940 | 39332 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
5000 | 42437 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 550 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42584 | 5996829.49530885 | 2093648.57745681 | 37.7285785035344 | -122.453230305718 | (37.7285785035344, -122.453230305718) | 9 | 7 | 4 | 28861 | 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 | ||
5244 | 261407 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
5252 | 253357 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1705 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | 13 | 9 | 11 | 29490 | 13 | ||
5446 | 36410 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 591 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39333 | 5995339.97501455 | 2093247.68753987 | 37.7273922712597 | -122.458350621736 | (37.7273922712597, -122.458350621736) | 9 | 7 | 4 | 28861 | 40 | ||
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 | ||
5710 | 261400 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 730 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010100.55131 | 2118520.19892 | 37.7976220266446 | -122.409105591228 | (37.7976220266446, -122.409105591228) | 3 | 1 | 10 | 308 | 4 | |||||
5974 | 62490 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 52 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1986 12:00:00 AM | Permit Number 22661 | 6000842.2540014 | 2092843.5185791 | 37.7265971735996 | -122.439300325407 | (37.7265971735996, -122.439300325407) | 9 | 7 | 6 | 28861 | 25 | ||
6160 | 42787 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 413 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42754 | 6004586.33786017 | 2109969.42501453 | 37.7738332863504 | -122.427576752843 | (37.7738332863504, -122.427576752843) | 7 | 9 | 11 | 28852 | 10 | |
6169 | 39333 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
6847 | 260435 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 917 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992908 | 2106572 | 37.7638373839544 | -122.467726529112 | (37.7638373839544, -122.467726529112) | 1 | 8 | 11 | 56 | 12 | ||||
7234 | 43732 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 769 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43369 | 5994354.80201989 | 2089904.78759744 | 37.718156810292 | -122.461514088361 | (37.718156810292, -122.461514088361) | 9 | 8 | 6 | 28861 | 24 | ||
7392 | 261325 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 644 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010473 | 2118597 | 37.79785376133 | -122.407822230627 | (37.79785376133, -122.407822230627) | 3 | 1 | 10 | 308 | 4 | ||||
7447 | 40722 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1436 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41701 | 6009381.89128779 | 2097433.59188792 | 37.7396827973609 | -122.410102898748 | (37.7396827973609, -122.410102898748) | 10 | 7 | 7 | 28859 | 2 | ||
7633 | 65608 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 235 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | Permit Number 28512 | 6004926.15006729 | 2093819.12850558 | 37.7295075388181 | -122.425251826139 | (37.7295075388181, -122.425251826139) | 9 | 7 | 6 | 28861 | 5 | ||
7700 | 261404 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 754 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009997.65437 | 2118506.05781 | 37.7975774337622 | -122.409460645418 | (37.7975774337622, -122.409460645418) | 3 | 1 | 10 | 308 | 4 | |||||
7788 | 39331 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
8270 | 261411 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
8298 | 66169 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 141 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29241 | 6009332.38059352 | 2096679.3641893 | 37.7376090764499 | -122.410220849347 | (37.7376090764499, -122.410220849347) | 10 | 7 | 7 | 28859 | 2 | ||
8521 | 43574 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 165 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43235 | 6004098.34924441 | 2100984.69662112 | 37.7491357535113 | -122.428624197191 | (37.7491357535113, -122.428624197191) | 2 | 4 | 5 | 28862 | 22 | ||
8717 | 119762 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
8869 | 45450 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 191 Corona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44761 | 5993006.32104665 | 2092505.10355506 | 37.7252189362985 | -122.466364051503 | (37.7252189362985, -122.466364051503) | 9 | 8 | 4 | 59 | 40 | ||
8968 | 261399 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 715 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010168.78657 | 2118489.20051 | 37.7975407349103 | -122.408867289597 | (37.7975407349103, -122.408867289597) | 3 | 1 | 10 | 308 | 4 | |||||
8992 | 261405 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
9212 | 259382 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 225 Whipple Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5997701 | 2087724 | 37.7123609051901 | -122.449790697309 | (37.7123609051901, -122.449790697309) | 9 | 7 | 6 | 28861 | 25 | ||||
9291 | 34653 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2000 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38332 | 5988676.14476792 | 2105141.94720244 | 37.75966558895 | -122.482258277854 | (37.75966558895, -122.482258277854) | 1 | 8 | 3 | 56 | 35 | ||
9471 | 119842 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 350 Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
9928 | 261390 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 638 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010519.78547 | 2118576.37921 | 37.7977997607314 | -122.407658884309 | (37.7977997607314, -122.407658884309) | 3 | 1 | 10 | 308 | 4 | |||||
10081 | 119760 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
10215 | 45064 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2101 27th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43947 | 5987870.53797958 | 2100985.88306806 | 37.7482072643075 | -122.484739557427 | (37.7482072643075, -122.484739557427) | 1 | 8 | 3 | 29491 | 35 | ||
10250 | 261397 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 720 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010143.42503 | 2118526.09105 | 37.7976406066987 | -122.408957651874 | (37.7976406066987, -122.408957651874) | 3 | 1 | 10 | 308 | 4 | |||||
10622 | 58722 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 73 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1986 12:00:00 AM | Permit Number 22987 | 6002575.33914396 | 2108761.52820117 | 37.7704027479761 | -122.434446734741 | (37.7704027479761, -122.434446734741) | 15 | 5 | 5 | 29492 | 9 | ||
10688 | 31923 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2296 15th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.471361438247 | (37.7451690123809, -122.471361438247) | 1 | 8 | 4 | 29491 | 40 | ||
10978 | 261419 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 781 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009855.16282 | 2118445.96033 | 37.7974044358704 | -122.409949461749 | (37.7974044358704, -122.409949461749) | 3 | 1 | 10 | 308 | 4 | |||||
11366 | 53918 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
11419 | 51055 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 640 Rivera St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2004 12:00:00 AM | Permit Number 47524 | 5991199.18695168 | 2100466.01651136 | 37.746973143605 | -122.47319139748 | (37.746973143605, -122.47319139748) | 1 | 8 | 4 | 29491 | 40 | |||
11452 | 110549 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
11462 | 38558 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1534 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40523 | 6015743.77247492 | 2095689.90327715 | 37.7352495140639 | -122.387984392406 | (37.7352495140639, -122.387984392406) | 10 | 3 | 8 | 58 | 1 | ||
11519 | 261392 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 670 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010377.23792 | 2118557.51621 | 37.7977399869991 | -122.408150809713 | (37.7977399869991, -122.408150809713) | 3 | 1 | 10 | 308 | 4 | |||||
11590 | 37254 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4200 20th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
11798 | 66507 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 64 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | Permit Number 29671 | 6009973.94739461 | 2110908.31483893 | 37.7767145222423 | -122.409006317188 | (37.7767145222423, -122.409006317188) | 8 | 2 | 9 | 28853 | 34 | ||
11895 | 36362 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 136 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39316 | 5995674.40918334 | 2093601.67196771 | 37.7283834402433 | -122.457220086151 | (37.7283834402433, -122.457220086151) | 9 | 7 | 4 | 28861 | 40 | ||
11993 | 261391 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 660 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010421.78403 | 2118563.41089 | 37.7977586664904 | -122.407997083107 | (37.7977586664904, -122.407997083107) | 3 | 1 | 10 | 308 | 4 | |||||
12147 | 63155 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1466 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1986 12:00:00 AM | Permit Number 23691 | 5992764.22387578 | 2105486.82086268 | 37.7608494648287 | -122.468144857754 | (37.7608494648287, -122.468144857754) | 1 | 8 | 4 | 56 | 12 | ||
12262 | 261408 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
12502 | 261420 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 780 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009867.40288 | 2118488.04976 | 37.7975206891225 | -122.409910080478 | (37.7975206891225, -122.409910080478) | 3 | 1 | 10 | 308 | 4 | |||||
12686 | 84527 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 32 Mars St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50968 | 5999562.49866969 | 2105598.34791337 | 37.7615459654268 | -122.444640731753 | (37.7615459654268, -122.444640731753) | 15 | 5 | 5 | 28862 | 3 | ||
12874 | 34981 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 336 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41309 | 6003431.10233151 | 2104509.78972726 | 37.7587770412129 | -122.43118312363 | (37.7587770412129, -122.43118312363) | 2 | 4 | 5 | 28862 | 3 | ||
13159 | 63787 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4043 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24473 | 6003575.02317091 | 2101250.14462278 | 37.749834980882 | -122.430452801929 | (37.749834980882, -122.430452801929) | 2 | 4 | 5 | 28862 | 22 | ||
13514 | 65246 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1123 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28040 | 6009230.45296658 | 2102616.7905535 | 37.753906226408 | -122.410992511898 | (37.753906226408, -122.410992511898) | 2 | 4 | 7 | 28859 | 19 | ||
13647 | 43721 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 655 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43361 | 5995440.43888004 | 2089883.51967293 | 37.7181608417184 | -122.457759993154 | (37.7181608417184, -122.457759993154) | 9 | 8 | 6 | 28861 | 24 | ||
13767 | 38951 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 300 Urbano Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/1998 12:00:00 AM | Permit Number 40747 | 5992264.30447735 | 2092728.68952836 | 37.7257900052514 | -122.468945369117 | (37.7257900052514, -122.468945369117) | 9 | 8 | 4 | 59 | 40 | ||
13781 | 40472 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 43 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | 9 | 8 | 6 | 28861 | 24 | |||
13830 | 62681 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 59 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1986 12:00:00 AM | Permit Number 23015 | 6002832.11131033 | 2108737.08241022 | 37.7703501979341 | -122.433556812869 | (37.7703501979341, -122.433556812869) | 15 | 5 | 5 | 29492 | 9 | ||
14089 | 261410 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
14300 | 261393 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 661 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010427.0314 | 2118523.75657 | 37.7976500791874 | -122.407976127788 | (37.7976500791874, -122.407976127788) | 3 | 1 | 10 | 308 | 4 | |||||
14566 | 31845 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
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 | ||
14620 | 65548 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 335 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28447 | 5995087.51239517 | 2097484.61184976 | 37.7390113196181 | -122.459530109112 | (37.7390113196181, -122.459530109112) | 9 | 7 | 4 | 59 | 40 | ||
15267 | 119759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
15474 | 67662 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31263 | 6016003.68231462 | 2097240.31166612 | 37.739521017402 | -122.387193890351 | (37.739521017402, -122.387193890351) | 10 | 3 | 8 | 58 | 1 | ||
15516 | 39334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
15708 | 36338 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 47 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39302 | 5995626.1352497 | 2092908.66266202 | 37.7264778306363 | -122.457336855787 | (37.7264778306363, -122.457336855787) | 9 | 7 | 4 | 28861 | 40 | ||
16091 | 261396 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 700 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010229.17248 | 2118537.87531 | 37.7976777662505 | -122.408661772909 | (37.7976777662505, -122.408661772909) | 3 | 1 | 10 | 308 | 4 | |||||
16092 | 63589 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 718 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1987 12:00:00 AM | Permit Number 24217 | 6007364.81298333 | 2095596.86962092 | 37.734526298545 | -122.416947010477 | (37.734526298545, -122.416947010477) | 2 | 7 | 7 | 28859 | 2 | ||
16400 | 60155 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1668 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 19686 | 5990610.46669896 | 2104039.03153173 | 37.7567495994005 | -122.475487960344 | (37.7567495994005, -122.475487960344) | 1 | 8 | 4 | 56 | 12 | ||
16965 | 31849 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
17072 | 259381 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 225 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5997701 | 2087724 | 37.7123609051901 | -122.449790697309 | (37.7123609051901, -122.449790697309) | 9 | 7 | 6 | 28861 | 25 | ||||
17102 | 64930 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2306 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1989 12:00:00 AM | Permit Number 25958 | 5991495.59202308 | 2099725.9184431 | 37.7449581828883 | -122.47211252761 | (37.7449581828883, -122.47211252761) | 1 | 8 | 4 | 29491 | 40 | ||
17187 | 261409 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
17467 | 50541 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180 | 2099188 | 37.7443200209268 | -122.421298240567 | (37.7443200209268, -122.421298240567) | 2 | 7 | 7 | 28859 | 2 | |||
17485 | 64739 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 139 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51671 | 6002793.57505281 | 2109015.34015791 | 37.7711120386945 | -122.433710000051 | (37.7711120386945, -122.433710000051) | 15 | 5 | 11 | 29492 | 9 | ||
17492 | 43352 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4184 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | Permit Number 43104 | 6002499.60919335 | 2104164.95121467 | 37.7577773673085 | -122.43437999795 | (37.7577773673085, -122.43437999795) | 2 | 4 | 5 | 28862 | 3 | ||
17531 | 64923 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2326 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 25951 | 5991484.88147917 | 2099641.61135178 | 37.744726077495 | -122.472143418263 | (37.744726077495, -122.472143418263) | 1 | 8 | 4 | 29491 | 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) );