2,694 rows where qSpecies_id = 84 sorted by DBH

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);