trees
39,840 rows where qLegalStatus_id = 7 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193828 | 50603 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1700 Buchanan St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2003 12:00:00 AM | Permit Number 47204 | 6004061.24207522 | 2114267.02341516 | 37.7856037113433 | -122.429699722138 | (37.7856037113433, -122.429699722138) | 13 | 9 | 11 | 29490 | 13 | |||
193822 | 57502 | Permitted Site 7 | Tree(s) :: 17 | 645 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/1976 12:00:00 AM | Permit Number 16354 | 6002231.27065409 | 2102052.31128719 | 37.7519613287465 | -122.435156919426 | (37.7519613287465, -122.435156919426) | 2 | 4 | 5 | 28862 | 22 | |||
193820 | 61374 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 599 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/1984 12:00:00 AM | 8 | 3x6 | Permit Number 21284 | 6003080.89795336 | 2095695.95776174 | 37.7345564667425 | -122.431764992429 | (37.7345564667425, -122.431764992429) | 2 | 7 | 5 | 63 | 7 | |
193819 | 62622 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 183 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1986 12:00:00 AM | Permit Number 22936 | 5997384.53937268 | 2107058.88452992 | 37.7654317060994 | -122.452278752633 | (37.7654317060994, -122.452278752633) | 15 | 5 | 11 | 29492 | 9 | ||
193818 | 54366 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 1430 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 4x6 | Permit Number 10131 | 5994303.85243307 | 2105774.2854119 | 37.7617275656201 | -122.462840859506 | (37.7617275656201, -122.462840859506) | 1 | 5 | 11 | 56 | 12 | ||
193815 | 36311 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Colon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.7288745967493 | -122.455513542245 | (37.7288745967493, -122.455513542245) | 9 | 7 | 4 | 28861 | 40 | ||
193812 | 28764 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1595X Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6005946.1425241 | 2099684.9167719 | 37.745671254309 | -122.422142167151 | (37.745671254309, -122.422142167151) | 2 | 7 | 5 | 28859 | 22 | |||
193811 | 53999 | Permitted Site 7 | Tree(s) :: 17 | 14 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/1972 12:00:00 AM | Permit Number 9717 | 6010652.24723851 | 2089463.80706867 | 37.7178705599695 | -122.405149476877 | (37.7178705599695, -122.405149476877) | 10 | 7 | 8 | 309 | 39 | |||
193810 | 59427 | Permitted Site 7 | Tree(s) :: 17 | 3030 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | Permit Number 18789 | 6002847.01894889 | 2096073.28659013 | 37.7355792650376 | -122.432600533347 | (37.7355792650376, -122.432600533347) | 2 | 7 | 5 | 63 | 7 | |||
193808 | 67150 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 427 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1992 12:00:00 AM | Permit Number 30582 | 6010005.12050673 | 2098589.41341875 | 37.7428913451797 | -122.40802951845 | (37.7428913451797, -122.40802951845) | 10 | 7 | 7 | 28859 | 2 | ||
193803 | 96153 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 482 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767788 | 6008200 | 2096596 | 37.7373166375453 | -122.414130144574 | (37.7373166375453, -122.414130144574) | 2 | 7 | 7 | 28859 | 2 | |
193792 | 61487 | Permitted Site 7 | Tree(s) :: 17 | 450 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/1984 12:00:00 AM | Permit Number 21432 | 6009986.55325494 | 2115111.49204318 | 37.7882561568332 | -122.409259387993 | (37.7882561568332, -122.409259387993) | 5 | 1 | 10 | 28852 | 21 | |||
193778 | 45139 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1267 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 43996 | 6000511.08946601 | 2109229.61979704 | 37.7715706185616 | -122.44162055585 | (37.7715706185616, -122.44162055585) | 15 | 5 | 11 | 29492 | 9 | ||
193776 | 50901 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1758 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47409 | 5990941.75175781 | 2103435.18794997 | 37.7551108027567 | -122.47429820501 | (37.7551108027567, -122.47429820501) | 1 | 8 | 4 | 56 | 12 | ||
193768 | 101346 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
193764 | 68365 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 945 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32186 | 6010298.82314684 | 2116844.8632649 | 37.7930330672197 | -122.408301287665 | (37.7930330672197, -122.408301287665) | 3 | 1 | 10 | 28857 | 4 | ||
193761 | 59554 | Permitted Site 7 | Tree(s) :: 17 | 114 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1981 12:00:00 AM | Permit Number 18940 | 5989933.62004717 | 2114608.14551697 | 37.7857302354003 | -122.478601614646 | (37.7857302354003, -122.478601614646) | 11 | 6 | 2 | 55 | 26 | |||
193760 | 98461 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 210 UPPER TER | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/2012 12:00:00 AM | 3x3 | Permit Number 768632 | 5999573.7 | 2106360.6 | 37.7636395591816 | -122.444656780294 | (37.7636395591816, -122.444656780294) | 15 | 5 | 5 | 29492 | 9 | ||
193758 | 37308 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 400 Hill St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | 2 | 4 | 5 | 28862 | 22 | ||
193757 | 105847 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 790 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008900 | 2110136 | 37.7745337092857 | -122.412666821872 | (37.7745337092857, -122.412666821872) | 8 | 2 | 9 | 28853 | 34 | |||
193756 | 61982 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3150 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1989 12:00:00 AM | Permit Number 22049 | 6004241.15992791 | 2119938.65131172 | 37.8011867438319 | -122.429481874601 | (37.8011867438319, -122.429481874601) | 13 | 9 | 1 | 57 | 17 | ||
193749 | 35853 | Permitted Site 7 | Tree(s) :: 17 | 500 Paris St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778923 | 6001729.76297614 | 2090780.38588209 | 37.7209827425077 | -122.436084672938 | (37.7209827425077, -122.436084672938) | 9 | 7 | 6 | 28861 | 5 | |
193745 | 38085 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 2501 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000626.16659083 | 2114103.31583795 | 37.7849591037257 | -122.441572302214 | (37.7849591037257, -122.441572302214) | 15 | 6 | 11 | 29490 | 13 | ||
193736 | 63753 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 714 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/06/1993 12:00:00 AM | Permit Number 24426 | 6003137.88940085 | 2109646.80433687 | 37.7728654152301 | -122.432564117591 | (37.7728654152301, -122.432564117591) | 15 | 5 | 11 | 29492 | 9 | ||
193734 | 70136 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 400 Gates St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | Permit Number 768270 | 6008220.64737322 | 2096959.77893551 | 37.7383166546264 | -122.414084485151 | (37.7383166546264, -122.414084485151) | 2 | 7 | 7 | 28859 | 2 | ||
193732 | 61830 | Permitted Site 7 | Tree(s) :: 17 | 21 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/1985 12:00:00 AM | Permit Number 21867 | 6000368.03189985 | 2101553.31084355 | 37.7504852137468 | -122.441564443283 | (37.7504852137468, -122.441564443283) | 2 | 4 | 5 | 28862 | 22 | |||
193730 | 94506 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 188 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998957 | 2107088 | 37.7656016064454 | -122.446842088627 | (37.7656016064454, -122.446842088627) | 15 | 5 | 11 | 29492 | 9 | ||||
193726 | 55505 | Permitted Site 7 | Tree(s) :: 17 | 877 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2012 12:00:00 AM | Permit Number 769029 | 6001316.38571339 | 2101284.99848129 | 37.7498024771894 | -122.438265751867 | (37.7498024771894, -122.438265751867) | 2 | 4 | 5 | 28862 | 22 | |||
193723 | 64802 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 164 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25801 | 6004840.80279914 | 2099324.03629974 | 37.744617952474 | -122.425938585487 | (37.744617952474, -122.425938585487) | 2 | 7 | 5 | 63 | 22 | ||
193718 | 51972 | Permitted Site 7 | Tree(s) :: 17 | 31REVISED Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2006 12:00:00 AM | Permit Number 48193 | 6000867.64488524 | 2106169.34308213 | 37.7631881671737 | -122.440167724833 | (37.7631881671737, -122.440167724833) | 15 | 5 | 5 | 28862 | 3 | |||
193707 | 45249 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1000-1098X Woolsey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44095 | 6008704.15221598 | 2091317.858977 | 37.7228522971335 | -122.412014157155 | (37.7228522971335, -122.412014157155) | 9 | 3 | 7 | 309 | 28 | ||
193705 | 31190 | Permitted Site 7 | :: 45 | 744 Shields St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | 9 | 8 | 6 | 64 | 24 | ||
193700 | 65587 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 280 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50506 | 6001698.32383124 | 2096225.19678186 | 37.7359311655571 | -122.436582873755 | (37.7359311655571, -122.436582873755) | 2 | 7 | 5 | 63 | 7 | ||
193699 | 95794 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1330 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767537 | 6010317 | 2101466 | 37.7508072797373 | -122.407153846535 | (37.7508072797373, -122.407153846535) | 2 | 4 | 7 | 28859 | 19 | |
193697 | 43905 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1050 York St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.7552328939148 | -122.408509176777 | (37.7552328939148, -122.408509176777) | 2 | 4 | 7 | 28859 | 19 |
193686 | 16402 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
193683 | 54798 | Permitted Site 7 | Tree(s) :: 17 | 448 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1972 12:00:00 AM | Permit Number 10649 | 6012425.51934153 | 2086571.65769638 | 37.710028268909 | -122.398817155488 | (37.710028268909, -122.398817155488) | 10 | 3 | 8 | 309 | 1 | |||
193676 | 50458 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 1798 08th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.464504569218 | (37.7548110540457, -122.464504569218) | 1 | 8 | 4 | 56 | 12 | |||
193675 | 60821 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 53 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20499 | 6004777.4385748 | 2101608.3520195 | 37.7508865753177 | -122.42632029375 | (37.7508865753177, -122.42632029375) | 2 | 4 | 5 | 28862 | 22 | ||
193672 | 50972 | Permitted Site 7 | Tree(s) :: 17 | 683 REVISED Brannan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2004 12:00:00 AM | Permit Number 47463 | 6012417.01604771 | 2110263.6615562 | 37.775081003703 | -122.40050967291 | (37.775081003703, -122.40050967291) | 14 | 2 | 9 | 28856 | 20 | |||
193669 | 101324 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 690X 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5992887.4 | 2110774.9 | 37.7753762378891 | -122.468103525281 | (37.7753762378891, -122.468103525281) | 11 | 6 | 2 | 54 | 11 | ||||
193667 | 50546 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 4 | 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 | |||
193662 | 79557 | Permitted Site 7 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 298 | 153 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772536 | 6004741.65189255 | 2108986.02751221 | 37.7711418993687 | -122.426969442731 | (37.7711418993687, -122.426969442731) | 7 | 9 | 11 | 28852 | 10 |
193660 | 59455 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 443 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31623 | 6003271.74004842 | 2095168.91222267 | 37.733120135626 | -122.431067583223 | (37.733120135626, -122.431067583223) | 9 | 7 | 5 | 28861 | 25 | ||
193656 | 16998 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 903 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6002629.22495 | 2109872.04506 | 37.7734550115897 | -122.434339751705 | (37.7734550115897, -122.434339751705) | 15 | 5 | 11 | 29492 | 9 | |||
193652 | 64496 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1548 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | Permit Number 25375 | 6000395.90025246 | 2110653.11374306 | 37.7754726099708 | -122.442121199098 | (37.7754726099708, -122.442121199098) | 15 | 5 | 11 | 29492 | 16 | ||
193640 | 55969 | Permitted Site 7 | Gleditsia triacanthos :: Honey Locust 182 | 35 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2000 12:00:00 AM | Permit Number 770524 | 6007464.012592 | 2099914.14210495 | 37.7463861516938 | -122.416909822502 | (37.7463861516938, -122.416909822502) | 2 | 7 | 7 | 28859 | 2 | ||
193639 | 42115 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 155 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42413 | 5999054.57340658 | 2093467.82755964 | 37.7282094871154 | -122.445525122705 | (37.7282094871154, -122.445525122705) | 9 | 7 | 4 | 28861 | 40 | ||
193634 | 108648 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 196 Lippard Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774607 | 6001751.75522 | 2094959.06379 | 37.7324576925005 | -122.436307555189 | (37.7324576925005, -122.436307555189) | 9 | 7 | 5 | 63 | 40 | |
193631 | 43074 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 378 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 46009 | 6007759.3011441 | 2112719.71067496 | 37.7815638725917 | -122.416795815478 | (37.7815638725917, -122.416795815478) | 7 | 10 | 9 | 28852 | 36 | ||
193629 | 101407 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 395X Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2012 12:00:00 AM | 3x3 | Permit Number 768634 | 6007839 | 2105646.7 | 37.7621475376843 | -122.416019051105 | (37.7621475376843, -122.416019051105) | 8 | 4 | 7 | 28859 | 19 | |
193624 | 34563 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 70 Nebraska St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38271 | 6009256.0147148 | 2097648.30844195 | 37.7402653060856 | -122.410553286198 | (37.7402653060856, -122.410553286198) | 10 | 7 | 7 | 28859 | 2 | ||
193614 | 93010 | Permitted Site 7 | Tree(s) :: 17 | 1520 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2010 12:00:00 AM | 3x3 | Permit Number 53136 | 6015407.2 | 2095381.5 | 37.7343840488548 | -122.389126529878 | (37.7343840488548, -122.389126529878) | 10 | 3 | 8 | 58 | 1 | ||
193611 | 60120 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 231 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19647 | 6004727.57850512 | 2096979.14667455 | 37.7381730200844 | -122.426163187426 | (37.7381730200844, -122.426163187426) | 2 | 7 | 5 | 63 | 7 | ||
193603 | 68315 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3820 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32128 | 5981623.22584135 | 2100818.01716678 | 37.7473805290726 | -122.506329747472 | (37.7473805290726, -122.506329747472) | 1 | 8 | 3 | 29491 | 35 | ||
193602 | 40739 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 20 Alviso St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2002 12:00:00 AM | Permit Number 45856 | 5992072.81756498 | 2091384.27409538 | 37.7220875062624 | -122.469509497536 | (37.7220875062624, -122.469509497536) | 9 | 8 | 4 | 59 | 40 | ||
193599 | 36395 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 799 FAXON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39328 | 5994869.9 | 2093286.2 | 37.7274709926994 | -122.459978448904 | (37.7274709926994, -122.459978448904) | 9 | 8 | 4 | 28861 | 40 | ||
193593 | 41004 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
193592 | 68615 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1926 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32520 | 5990980.83795372 | 2102284.63061067 | 37.7519539388073 | -122.474079091331 | (37.7519539388073, -122.474079091331) | 1 | 8 | 4 | 29491 | 12 | ||
193591 | 47391 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 789 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45306 | 5995339.87116689 | 2110345.66733656 | 37.7743390069649 | -122.459588816877 | (37.7743390069649, -122.459588816877) | 11 | 6 | 2 | 54 | 11 | |||
193581 | 43004 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 205X Rose St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | 7 | 9 | 11 | 28852 | 10 | |||
193575 | 50422 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 549 HOLLOWAY AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778616 | 5995097 | 2091149 | 37.721615813455 | -122.459038685652 | (37.721615813455, -122.459038685652) | 9 | 8 | 6 | 28861 | 24 | |
193558 | 66280 | Permitted Site 7 | Tree(s) :: 17 | 828 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1990 12:00:00 AM | Permit Number 29391 | 5998695.58119662 | 2107319.16022296 | 37.7662213763467 | -122.447762917426 | (37.7662213763467, -122.447762917426) | 15 | 5 | 11 | 29492 | 9 | |||
193557 | 69512 | Permitted Site 7 | Arbutus unedo :: Strawberry Tree 106 | 472 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | Permit Number 33639 | 6008869.38717848 | 2096146.49207246 | 37.7361199619039 | -122.411784001618 | (37.7361199619039, -122.411784001618) | 10 | 7 | 7 | 28859 | 2 | ||
193556 | 54459 | Permitted Site 7 | Tree(s) :: 17 | 4231 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1972 12:00:00 AM | Permit Number 10250 | 6002400.47694314 | 2100599.86959771 | 37.7479828746195 | -122.434467942065 | (37.7479828746195, -122.434467942065) | 2 | 4 | 5 | 63 | 22 | |||
193550 | 36501 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 202 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39381 | 6007894.41646621 | 2097691.91332434 | 37.7403086056831 | -122.415264247706 | (37.7403086056831, -122.415264247706) | 2 | 7 | 7 | 28859 | 2 | ||
193547 | 37696 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 590 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40081 | 6007854.26822666 | 2104498.62498081 | 37.7589960467021 | -122.41588494267 | (37.7589960467021, -122.41588494267) | 2 | 4 | 7 | 28859 | 19 | ||
193529 | 28809 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Point Lobos Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2005 12:00:00 AM | 3 | 3X3 | 5981914.41464 | 2112627.90945 | 37.7798242405661 | -122.50619841953 | (37.7798242405661, -122.50619841953) | 11 | 6 | 2 | 55 | 26 | ||
193519 | 87130 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 539 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2008 12:00:00 AM | 3x3 | Permit Number 50079 | 5987777.8 | 2112308.8 | 37.7792914839248 | -122.485891213403 | (37.7792914839248, -122.485891213403) | 11 | 6 | 2 | 55 | 26 | ||
193516 | 47708 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 283 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45503 | 6001687.89351139 | 2096174.25192012 | 37.7357906900295 | -122.436615290037 | (37.7357906900295, -122.436615290037) | 2 | 7 | 5 | 63 | 7 | ||
193514 | 66728 | Permitted Site 7 | Tree(s) :: 17 | 615 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/1991 12:00:00 AM | Permit Number 29971 | 5992676.53220067 | 2105893.65059977 | 37.7619614475114 | -122.468477741786 | (37.7619614475114, -122.468477741786) | 1 | 8 | 4 | 56 | 12 | |||
193504 | 18708 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 18 Roosevelt Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6001702.8694074 | 2107531.8635154 | 37.7669768293108 | -122.437376538243 | (37.7669768293108, -122.437376538243) | 15 | 5 | 5 | 28862 | 3 | |||
193503 | 53508 | Permitted Site 7 | Tree(s) :: 17 | 238 Ralston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/1969 12:00:00 AM | Permit Number 6418 | 5992226.59125592 | 2089458.03207637 | 37.7168074014067 | -122.468837842897 | (37.7168074014067, -122.468837842897) | 9 | 8 | 6 | 64 | 24 | |||
193500 | 68043 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1823 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1993 12:00:00 AM | Permit Number 31780 | 5993105.45691397 | 2103063.19350901 | 37.7542145156657 | -122.466788507311 | (37.7542145156657, -122.466788507311) | 1 | 8 | 4 | 56 | 12 | ||
193498 | 47037 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 714 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2015 12:00:00 AM | Permit Number 776491 | 6002280.60768666 | 2108833.96933031 | 37.7705849188534 | -122.435471392977 | (37.7705849188534, -122.435471392977) | 15 | 5 | 11 | 29492 | 9 | ||
193496 | 53294 | Permitted Site 7 | Tree(s) :: 17 | 4107 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1969 12:00:00 AM | Permit Number 6184 | 6002448.65163308 | 2102356.36648783 | 37.7528085336342 | -122.434426922819 | (37.7528085336342, -122.434426922819) | 2 | 4 | 5 | 28862 | 22 | |||
193481 | 25827 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.9996834 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | 3 | 1 | 10 | 28860 | 6 | ||
193479 | 83743 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 1119 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51253 | 5997288.04131904 | 2106575.48673103 | 37.7640988902825 | -122.452577626495 | (37.7640988902825, -122.452577626495) | 15 | 5 | 11 | 29492 | 12 | ||
193476 | 67801 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 881 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31447 | 6000722.4252572 | 2102556.2611987 | 37.7532592580737 | -122.440410849633 | (37.7532592580737, -122.440410849633) | 2 | 4 | 5 | 28862 | 22 | ||
193467 | 92409 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2194 36th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52806 | 5985172.2 | 2100288.5 | 37.7461349199107 | -122.494018801011 | (37.7461349199107, -122.494018801011) | 1 | 8 | 3 | 29491 | 35 | |
193466 | 247432 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 448 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | 9 | Width 0ft | Permit Number 30736 | 6002214.9987 | 2110062.5424 | 37.7739545493289 | -122.435786250227 | (37.7739545493289, -122.435786250227) | 15 | 5 | 11 | 29492 | 10 | |
193457 | 47591 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/2003 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
193453 | 45252 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 568 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44099 | 6009813.67282905 | 2098883.83763279 | 37.7436890489958 | -122.408712260487 | (37.7436890489958, -122.408712260487) | 2 | 7 | 7 | 28859 | 2 | ||
193448 | 63318 | Permitted Site 7 | Tree(s) :: 17 | 416 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/1987 12:00:00 AM | Permit Number 23885 | 6009423.56378257 | 2100207.92948709 | 37.7473028565921 | -122.410154631402 | (37.7473028565921, -122.410154631402) | 2 | 7 | 7 | 28859 | 2 | |||
193442 | 101629 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
193435 | 45082 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2143 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43964 | 5987260.68011287 | 2100690.67520581 | 37.7473611656774 | -122.486826724588 | (37.7473611656774, -122.486826724588) | 1 | 8 | 3 | 29491 | 35 | ||
193431 | 86972 | Permitted Site 7 | Grevillea robusta :: Silk Oak Tree 76 | 3274 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2007 12:00:00 AM | 3x3 | Permit Number 49936 | 6007899 | 2100950 | 37.7492548435872 | -122.415479005477 | (37.7492548435872, -122.415479005477) | 2 | 4 | 7 | 28859 | 19 | ||
193429 | 96036 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1498 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767675 | 6006383 | 2118353 | 37.7969539806541 | -122.421957458925 | (37.7969539806541, -122.421957458925) | 13 | 9 | 10 | 28858 | 32 | |
193427 | 106524 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2510 Jackson St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | 13 | 6 | 1 | 29490 | 27 | ||||
193425 | 34738 | Permitted Site 7 | :: 45 | 577 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38388 | 6007301.38154642 | 2103961.93369164 | 37.7574913175401 | -122.417759048452 | (37.7574913175401, -122.417759048452) | 2 | 4 | 7 | 28859 | 19 | ||
193418 | 37877 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 591 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/2002 12:00:00 AM | Permit Number 40158 | 5996748.50508252 | 2094082.2355122 | 37.7297645826714 | -122.453541590937 | (37.7297645826714, -122.453541590937) | 9 | 7 | 4 | 28861 | 40 | ||
193406 | 53495 | Permitted Site 7 | Tree(s) :: 17 | 2623 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1969 12:00:00 AM | Permit Number 6405 | 5997607.19251822 | 2089135.57838222 | 37.7162314069443 | -122.450216607006 | (37.7162314069443, -122.450216607006) | 9 | 8 | 6 | 28861 | 24 | |||
193404 | 107416 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 300 Seacliff Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.7884965174911 | -122.489505906992 | (37.7884965174911, -122.489505906992) | 11 | 6 | 1 | 55 | 33 | ||
193401 | 16304 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 750 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3X3 | 5997121.6948006 | 2094756.564309 | 37.7316375145123 | -122.452300078462 | (37.7316375145123, -122.452300078462) | 9 | 7 | 4 | 59 | 40 | |||
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 | ||
193398 | 35749 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 190 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1998 12:00:00 AM | Permit Number 39020 | 6007991.91657507 | 2093047.96738245 | 37.7275628190095 | -122.414598584861 | (37.7275628190095, -122.414598584861) | 9 | 3 | 7 | 309 | 5 | ||
193389 | 39001 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2180 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1999 12:00:00 AM | Permit Number 40764 | 6008727.07607359 | 2105746.22742921 | 37.7624707078907 | -122.412954561883 | (37.7624707078907, -122.412954561883) | 8 | 4 | 7 | 28859 | 19 | ||
193386 | 59620 | Permitted Site 7 | Tree(s) :: 17 | 1250 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1981 12:00:00 AM | Permit Number 19027 | 6009405.43377303 | 2110084.0575777 | 37.7744194420762 | -122.410914751831 | (37.7744194420762, -122.410914751831) | 8 | 2 | 9 | 28853 | 34 | |||
193385 | 112978 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101 Fairmount St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6004821.44439287 | 2097233.75118826 | 37.7388774114731 | -122.425856763586 | (37.7388774114731, -122.425856763586) | 2 | 7 | 5 | 63 | 7 | |||
193374 | 88133 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 782 Foerster St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51160 | 5998155 | 2096174 | 37.7355885978434 | -122.448829813464 | (37.7355885978434, -122.448829813464) | 9 | 7 | 4 | 59 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );