trees
1,069 rows where qSpecies_id = 93 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
175962 | 119669 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
176752 | 64740 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1225 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1988 12:00:00 AM | Permit Number 25701 | 6000702.83668032 | 2109256.16819914 | 37.7716544366578 | -122.440959198032 | (37.7716544366578, -122.440959198032) | 15 | 5 | 11 | 29492 | 9 | ||
178550 | 30956 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
179056 | 41712 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 395 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42160 | 6000832.46516562 | 2096676.37340252 | 37.7371207489149 | -122.439608818975 | (37.7371207489149, -122.439608818975) | 2 | 7 | 5 | 63 | 7 | ||
179233 | 62796 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1872 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23153 | 6000282.71540486 | 2093136.39817936 | 37.7273694960454 | -122.441255629685 | (37.7273694960454, -122.441255629685) | 9 | 7 | 6 | 28861 | 25 | ||
181204 | 50265 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 35 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46971 | 6005046.20150954 | 2096458.3536408 | 37.7367610435591 | -122.425024502668 | (37.7367610435591, -122.425024502668) | 2 | 7 | 5 | 28859 | 2 | ||
182028 | 111028 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | 8 | 2 | 8 | 28853 | 20 | ||||
183911 | 30960 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2401 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34753 | 6002022.0507417 | 2114644.40993289 | 37.7865242387809 | -122.436781745524 | (37.7865242387809, -122.436781745524) | 13 | 6 | 1 | 29490 | 27 | ||
184922 | 39497 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 430 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40954 | 6003565.0004553 | 2102762.00333018 | 37.7539856215362 | -122.430595327752 | (37.7539856215362, -122.430595327752) | 2 | 4 | 5 | 28862 | 22 | ||
186613 | 50160 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50543 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | 8 | 2 | 8 | 28853 | 20 | ||
186788 | 62232 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 31 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | Permit Number 22358 | 6001252.08087827 | 2093926.39351405 | 37.7295938138913 | -122.437961102136 | (37.7295938138913, -122.437961102136) | 9 | 7 | 6 | 28861 | 25 | ||
189632 | 32954 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 673X Missouri St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
190567 | 53817 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50398 | 5992946.10042753 | 2094372.20791552 | 37.730342070192 | -122.466707885488 | (37.730342070192, -122.466707885488) | 9 | 8 | 4 | 59 | 40 | ||
192693 | 67989 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 315 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31713 | 5995887.5336506 | 2091190.06532653 | 37.7217739820868 | -122.456309007028 | (37.7217739820868, -122.456309007028) | 9 | 8 | 6 | 28861 | 24 | ||
193333 | 47788 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 445 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | Permit Number 45558 | 6009171.86340947 | 2121127.78288236 | 37.8047297355065 | -122.412503532854 | (37.8047297355065, -122.412503532854) | 3 | 1 | 10 | 308 | 23 | |||
50109 | 197570 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011756.09586 | 2113120.18338 | 37.7828874706141 | -122.402996914199 | (37.7828874706141, -122.402996914199) | 6 | 2 | 9 | 28853 | 34 | |||
144095 | 68014 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3400 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1993 12:00:00 AM | 1 | Permit Number 31744 | 5999283.32146 | 2120515.04352 | 37.8024874104189 | -122.446679585917 | (37.8024874104189, -122.446679585917) | 13 | 9 | 1 | 57 | 17 | ||
10659 | 136418 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6013527.00347 | 2118227.13229 | 37.797008690162 | -122.397228498003 | (37.797008690162, -122.397228498003) | 3 | 1 | 10 | 28860 | 6 | |||
13703 | 40148 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
14953 | 239697 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 155 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5997911.0613 | 2106175.96002 | 37.763037567858 | -122.450393989214 | (37.763037567858, -122.450393989214) | 15 | 5 | 11 | 29492 | 9 | |||
18292 | 214176 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2570 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991436.65565 | 2097934.35886 | 37.7400356087611 | -122.4721857495 | (37.7400356087611, -122.4721857495) | 1 | 8 | 4 | 29491 | 40 | |||
19789 | 247187 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 4 | : | Tree | Private 2 | 10 | Width 4ft | 6000970.93564 | 2108908.88323 | 37.770716144966 | -122.440006923906 | (37.770716144966, -122.440006923906) | 15 | 5 | 11 | 29492 | 9 | |||
20754 | 197513 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | 6009803.31754 | 2109510.05508 | 37.7728656676608 | -122.409497871353 | (37.7728656676608, -122.409497871353) | 14 | 2 | 9 | 28853 | 34 | ||||
34991 | 197524 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Utah St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6010641.49765 | 2106679.01368 | 37.7651392052289 | -122.406398976647 | (37.7651392052289, -122.406398976647) | 8 | 4 | 8 | 28853 | 19 | |||
37312 | 142672 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 444 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6009151.8318 | 2121171.42 | 37.8048484279172 | -122.412575941125 | (37.8048484279172, -122.412575941125) | 3 | 1 | 10 | 308 | 23 | |||
42392 | 245011 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1209 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6000668.5479 | 2109254.8115 | 37.7716487585204 | -122.441077707327 | (37.7716487585204, -122.441077707327) | 15 | 5 | 11 | 29492 | 9 | |||
44097 | 96379 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 531 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 10 | 3x3 | Permit Number 768930 | 6005269 | 2111284 | 37.7774813787572 | -122.425308876718 | (37.7774813787572, -122.425308876718) | 7 | 9 | 11 | 28852 | 10 | |
48920 | 142551 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 425 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6009181 | 2121098 | 37.8046484719029 | -122.41246980811 | (37.8046484719029, -122.41246980811) | 3 | 1 | 10 | 308 | 23 | |||
52712 | 197535 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Missouri St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6013599.31223 | 2104067.77122 | 37.7581343255511 | -122.395985537795 | (37.7581343255511, -122.395985537795) | 10 | 3 | 8 | 28856 | 29 | |||
55798 | 179451 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1848 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6006175.92265 | 2087836.63994 | 37.7131514400558 | -122.420506743187 | (37.7131514400558, -122.420506743187) | 9 | 7 | 8 | 309 | 39 | |||
57986 | 40147 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
59824 | 40145 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
63033 | 179440 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Blythdale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6007040.38457 | 2086896.48953 | 37.7106186631909 | -122.417452275027 | (37.7106186631909, -122.417452275027) | 9 | 7 | 8 | 309 | 39 | |||
65438 | 239712 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 88 Santa Marina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006164.57012 | 2097549.79113 | 37.7398209981319 | -122.421235287575 | (37.7398209981319, -122.421235287575) | 2 | 7 | 7 | 28859 | 2 | |||
66788 | 179470 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 755 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6002483.16702 | 2089112.03412 | 37.7164445928267 | -122.43336122534 | (37.7164445928267, -122.43336122534) | 9 | 7 | 6 | 28861 | 5 | |||
68847 | 179445 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 50 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006641.641 | 2087043.64286 | 37.7110002716098 | -122.418840853438 | (37.7110002716098, -122.418840853438) | 9 | 7 | 8 | 309 | 39 | |||
74616 | 136410 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1700 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008350.5752 | 2118320.27531 | 37.7969748963406 | -122.415146840471 | (37.7969748963406, -122.415146840471) | 5 | 1 | 10 | 308 | 21 | |||
80568 | 30967 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1904 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34758 | 6002512.7183 | 2114848.7346 | 37.7871131358628 | -122.435098778488 | (37.7871131358628, -122.435098778488) | 13 | 9 | 11 | 29490 | 27 | |
83824 | 240593 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 73 Digby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002622.32078 | 2097674.93204 | 37.7399642691366 | -122.433491822189 | (37.7399642691366, -122.433491822189) | 2 | 7 | 5 | 63 | 7 | |||
84700 | 197537 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 266 Bridgeview Dr | 1 | : | Tree | Private 2 | 10 | Width 2ft | 6012934.68235 | 2095259.36475 | 37.7339113173389 | -122.397666323936 | (37.7339113173389, -122.397666323936) | 10 | 3 | 8 | 58 | 1 | |||
89864 | 200830 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1550 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6011811.2987 | 2107032.5363 | 37.7661752695362 | -122.402377754798 | (37.7661752695362, -122.402377754798) | 8 | 3 | 8 | 28853 | 20 | |||
94609 | 240585 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 334 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999374.09078 | 2105029.48188 | 37.7599732475924 | -122.445251453514 | (37.7599732475924, -122.445251453514) | 15 | 5 | 5 | 28862 | 3 | |||
94767 | 179482 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5988878.80429 | 2090370.98469 | 37.7191201586413 | -122.48047615337 | (37.7191201586413, -122.48047615337) | 1 | 8 | 4 | 64 | 14 | ||||
98297 | 30941 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1101 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34750 | 5995913.71268 | 2091275.1809 | 37.7220091920614 | -122.456224664532 | (37.7220091920614, -122.456224664532) | 9 | 8 | 4 | 28861 | 24 | |
100452 | 240545 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4390 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001366.11149 | 2101175.74148 | 37.749505311641 | -122.438085972914 | (37.749505311641, -122.438085972914) | 2 | 4 | 5 | 28862 | 22 | |||
101559 | 179477 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 245 Wilson St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5994326.32135 | 2086634.18047 | 37.7091748582933 | -122.461375565754 | (37.7091748582933, -122.461375565754) | 9 | 8 | 6 | 28861 | 25 | ||||
102339 | 179465 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 291 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6001702.1853 | 2090068.84403 | 37.7190274412447 | -122.436129108381 | (37.7190274412447, -122.436129108381) | 9 | 7 | 6 | 28861 | 5 | |||
113094 | 247472 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 838 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002550.7646 | 2109563.4235 | 37.772603159446 | -122.434589085205 | (37.772603159446, -122.434589085205) | 15 | 5 | 11 | 29492 | 9 | |||
113228 | 123753 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 4ft | 5995463.5723 | 2110766.04178 | 37.7755003566036 | -122.459191361341 | (37.7755003566036, -122.459191361341) | 11 | 6 | 2 | 54 | 11 | |||
115486 | 31153 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 45 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 10 | Permit Number 34856 | 5999668.77928 | 2093756.13869 | 37.7290361680777 | -122.443422496853 | (37.7290361680777, -122.443422496853) | 9 | 7 | 4 | 63 | 40 | |
117041 | 183904 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5989435.9716 | 2100535.9908 | 37.7470630248592 | -122.479293489941 | (37.7470630248592, -122.479293489941) | 1 | 8 | 3 | 29491 | 35 | |||
118609 | 136401 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1128 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007893.03777 | 2115514.03443 | 37.7892439283227 | -122.416531148891 | (37.7892439283227, -122.416531148891) | 13 | 1 | 10 | 28858 | 21 | |||
121328 | 136399 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1667 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005091.5128 | 2118475.84475 | 37.7972183598879 | -122.42643506692 | (37.7972183598879, -122.42643506692) | 13 | 9 | 1 | 57 | 17 | |||
125881 | 21850 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 199X Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5995087 | 2110729 | 37.7753769933328 | -122.46049132133 | (37.7753769933328, -122.46049132133) | 11 | 6 | 2 | 54 | 11 | |||
126536 | 179439 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006794.78813 | 2086912.99237 | 37.7106501547416 | -122.418302281839 | (37.7106501547416, -122.418302281839) | 9 | 7 | 8 | 309 | 39 | |||
133836 | 136387 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3395 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998704.14947 | 2115236.64778 | 37.7879612450483 | -122.448303478237 | (37.7879612450483, -122.448303478237) | 13 | 6 | 1 | 54 | 31 | |||
134266 | 43675 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 611 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 10 | Permit Number 43318 | 5995303.58271 | 2111376.81482 | 37.7771681785952 | -122.459789050934 | (37.7771681785952, -122.459789050934) | 11 | 6 | 2 | 54 | 11 | |
141055 | 138390 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1955 STEINER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002448.3159 | 2114992.6104 | 37.7875045249199 | -122.435331891812 | (37.7875045249199, -122.435331891812) | 13 | 9 | 11 | 29490 | 27 | |||
141567 | 214173 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2252 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991053.76562 | 2100086.62004 | 37.7459229980593 | -122.473666574964 | (37.7459229980593, -122.473666574964) | 1 | 8 | 4 | 29491 | 40 | |||
142266 | 240529 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 185 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x6 | 6008658.35145 | 2097704.96683 | 37.7403873524888 | -122.412623778059 | (37.7403873524888, -122.412623778059) | 10 | 7 | 7 | 28859 | 2 | |||
147191 | 239721 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 400 Clipper St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6002485.20231 | 2100944.35113 | 37.7489335487424 | -122.434199588643 | (37.7489335487424, -122.434199588643) | 2 | 4 | 5 | 28862 | 22 | |||
150907 | 239700 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 157 Rivoli St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997877.76471 | 2105918.81674 | 37.7623296116347 | -122.450490611447 | (37.7623296116347, -122.450490611447) | 15 | 5 | 11 | 29492 | 9 | |||
153889 | 179441 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6007125.21698 | 2086870.4635 | 37.7105519739575 | -122.417157231746 | (37.7105519739575, -122.417157231746) | 9 | 7 | 8 | 309 | 39 | |||
156764 | 40149 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
160176 | 217708 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1125 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5996389.2535 | 2091794.3451 | 37.7234619803781 | -122.454618335706 | (37.7234619803781, -122.454618335706) | 9 | 8 | 4 | 28861 | 24 | |||
166836 | 117906 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 578 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5983823.18804 | 2111887.66222 | 37.7779039197886 | -122.499540512861 | (37.7779039197886, -122.499540512861) | 11 | 6 | 2 | 55 | 26 | |||
174056 | 179446 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 127 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006032.90525 | 2087456.20206 | 37.712098777304 | -122.420974066009 | (37.712098777304, -122.420974066009) | 9 | 7 | 8 | 309 | 39 | |||
175362 | 214174 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2574 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991436.00676 | 2097903.57199 | 37.7399510383196 | -122.4721857495 | (37.7399510383196, -122.4721857495) | 1 | 8 | 4 | 29491 | 40 | |||
177543 | 247186 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 3 | : | Tree | Private 2 | 10 | Width 4ft | Permit Number 780753 | 6000985.28448 | 2108903.00262 | 37.7707008151093 | -122.439956869431 | (37.7707008151093, -122.439956869431) | 15 | 5 | 11 | 29492 | 9 | ||
181030 | 214189 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 364 San Benito Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992760.98003 | 2094267.65253 | 37.7300443017829 | -122.46734026706 | (37.7300443017829, -122.46734026706) | 9 | 8 | 4 | 59 | 40 | |||
181624 | 103006 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 41X Beulah St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5997709.4 | 2107777.7 | 37.7674239953752 | -122.451206983541 | (37.7674239953752, -122.451206983541) | 15 | 5 | 11 | 29492 | 9 | |||
186586 | 141838 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1103 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004708.7161 | 2112593.1646 | 37.7810443525714 | -122.427340367744 | (37.7810443525714, -122.427340367744) | 7 | 9 | 11 | 29490 | 41 | |||
188347 | 140193 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2177 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997047.1638 | 2109490.1294 | 37.7720879460791 | -122.453621218845 | (37.7720879460791, -122.453621218845) | 15 | 5 | 11 | 29492 | 16 | |||
189564 | 43657 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 553 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 10 | Permit Number 43301 | 5992810.17 | 2111710.04136 | 37.7779394229571 | -122.468438730278 | (37.7779394229571, -122.468438730278) | 11 | 6 | 2 | 54 | 11 | |
146996 | 5639 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1273 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 106 | 6X6 | 6005219.14783 | 2100952.73682 | 37.7491113654052 | -122.424746185103 | (37.7491113654052, -122.424746185103) | 2 | 4 | 5 | 28859 | 19 | |||
4246 | 67958 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 719 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 11 | Permit Number 31678 | 5987220.95005 | 2111007.3016 | 37.7756854718616 | -122.48772192034 | (37.7756854718616, -122.48772192034) | 11 | 6 | 2 | 55 | 26 | |
10705 | 72398 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 791 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5990047.51543 | 2110000.36847 | 37.7730851702984 | -122.477870609559 | (37.7730851702984, -122.477870609559) | 11 | 6 | 2 | 55 | 26 | |||
14424 | 46330 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 548 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2002 12:00:00 AM | 11 | Permit Number 44580 | 5996909.4172 | 2109622.8664 | 37.7724445099575 | -122.454107281383 | (37.7724445099575, -122.454107281383) | 15 | 5 | 11 | 29492 | 16 | ||
15213 | 78534 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 240 Wayland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6010805.45879 | 2092437.25464 | 37.7260435984308 | -122.404829115572 | (37.7260435984308, -122.404829115572) | 10 | 3 | 7 | 309 | 28 | |||
17372 | 2773 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 324 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 5994596.42955 | 2110789.71407 | 37.7755154642019 | -122.462192710849 | (37.7755154642019, -122.462192710849) | 11 | 6 | 2 | 54 | 11 | |||
17552 | 46597 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 170St. 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/09/2002 12:00:00 AM | 11 | Permit Number 44725 | 5993070.73118 | 2114361.72785 | 37.7852352793736 | -122.467730266741 | (37.7852352793736, -122.467730266741) | 11 | 6 | 2 | 54 | 11 | |
17629 | 71250 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1240 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6x3 | 6007647.94637 | 2118195.049 | 37.7965915450137 | -122.417569230932 | (37.7965915450137, -122.417569230932) | 5 | 1 | 10 | 28858 | 32 | ||
20941 | 179443 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 20 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6006639.5983 | 2087274.41681 | 37.7116338134302 | -122.418864269997 | (37.7116338134302, -122.418864269997) | 9 | 7 | 8 | 309 | 39 | |||
37454 | 239698 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 157 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5997845.27898 | 2105913.04775 | 37.7623119120732 | -122.450602550973 | (37.7623119120732, -122.450602550973) | 15 | 5 | 11 | 29492 | 9 | |||
38007 | 217714 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1199 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5996346.1405 | 2091806.7339 | 37.7234935241877 | -122.454768263296 | (37.7234935241877, -122.454768263296) | 9 | 8 | 4 | 28861 | 24 | |||
45910 | 250462 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 290 Seacliff Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5986816.96544 | 2115727.4811 | 37.7886221640356 | -122.489466544563 | (37.7886221640356, -122.489466544563) | 11 | 6 | 1 | 55 | 33 | |||
50090 | 239732 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 553 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002955.84762 | 2099760.28761 | 37.7457090889122 | -122.432487535773 | (37.7457090889122, -122.432487535773) | 2 | 7 | 5 | 63 | 22 | |||
55264 | 136396 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3651 Baker St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 5999117.86509 | 2121345.13243 | 37.8047571571746 | -122.447311924407 | (37.8047571571746, -122.447311924407) | 13 | 9 | 1 | 57 | 17 | |||
63504 | 138391 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1955 STEINER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002452.5162 | 2114975.8094 | 37.7874586321962 | -122.435316157397 | (37.7874586321962, -122.435316157397) | 13 | 9 | 11 | 29490 | 27 | |||
66240 | 102833 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
67473 | 179442 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 20 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6006642.58468 | 2087353.9641 | 37.7118524017357 | -122.418859586325 | (37.7118524017357, -122.418859586325) | 9 | 7 | 8 | 309 | 39 | |||
68428 | 113589 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6013618.31729 | 2118086.59987 | 37.7966279046102 | -122.396902670038 | (37.7966279046102, -122.396902670038) | 3 | 1 | 10 | 28860 | 6 | |||
69697 | 69405 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 781 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 11 | Permit Number 33509 | 6002439.0824 | 2087100.62464 | 37.7109192031396 | -122.43336995327 | (37.7109192031396, -122.43336995327) | 9 | 7 | 6 | 28861 | 5 | |
71412 | 214177 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 225 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 5994177.64343 | 2098765.47338 | 37.7424758858443 | -122.462768889883 | (37.7424758858443, -122.462768889883) | 1 | 8 | 4 | 59 | 40 | |||
79165 | 197509 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | 6009753.46902 | 2109444.94334 | 37.7726840927246 | -122.40966570733 | (37.7726840927246, -122.40966570733) | 14 | 2 | 9 | 28853 | 34 | ||||
88114 | 179444 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 50 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6006641.4754 | 2087068.60877 | 37.7110688134384 | -122.418843195273 | (37.7110688134384, -122.418843195273) | 9 | 7 | 8 | 309 | 39 | |||
88167 | 197527 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6010651.56665 | 2106560.03091 | 37.7648130687996 | -122.406355766009 | (37.7648130687996, -122.406355766009) | 8 | 4 | 8 | 28853 | 19 | |||
92494 | 215014 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 158 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994270.18976 | 2095584.01107 | 37.7337457098893 | -122.462218211614 | (37.7337457098893, -122.462218211614) | 9 | 8 | 4 | 59 | 40 | |||
93273 | 179485 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6001441.34691 | 2093639.06415 | 37.7288156345119 | -122.437286225591 | (37.7288156345119, -122.437286225591) | 9 | 7 | 6 | 28861 | 25 | |||
102044 | 179480 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5989599 | 2090767 | 37.7202493457345 | -122.478015677124 | (37.7202493457345, -122.478015677124) | 1 | 8 | 4 | 64 | 14 |
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) );