trees
1,069 rows where qSpecies_id = 93 sorted by qLegalStatus_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
100923 | 111027 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 2 | 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 | ||||
101186 | 32425 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 275 Maywood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 36952 | 5994490.2461397 | 2094811.13335462 | 37.7316362454296 | -122.461401406739 | (37.7316362454296, -122.461401406739) | 9 | 8 | 4 | 59 | 40 | ||||
105212 | 32424 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 275 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 36952 | 5994490.2461397 | 2094811.13335462 | 37.7316362454296 | -122.461401406739 | (37.7316362454296, -122.461401406739) | 9 | 8 | 4 | 59 | 40 | ||||
106799 | 62237 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 61 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | Permit Number 22363 | 6001374.44401127 | 2093790.00837779 | 37.7292262892939 | -122.437528318003 | (37.7292262892939, -122.437528318003) | 9 | 7 | 6 | 28861 | 25 | ||
107752 | 94890 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 491 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997284 | 2107398 | 37.7663570704681 | -122.452650969879 | (37.7663570704681, -122.452650969879) | 15 | 5 | 11 | 29492 | 9 | |||||
108379 | 41627 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1095 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42109 | 6007646.45182189 | 2109473.56842462 | 37.7726443942379 | -122.416956155908 | (37.7726443942379, -122.416956155908) | 8 | 2 | 9 | 28853 | 19 | |||
108442 | 67011 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 319 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30366 | 5995876.19861024 | 2091190.26348134 | 37.7217738754672 | -122.456348203392 | (37.7217738754672, -122.456348203392) | 9 | 8 | 6 | 28861 | 24 | ||
109902 | 62343 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 14 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22485 | 6005822.8575705 | 2099672.01958419 | 37.7456288871148 | -122.422567552448 | (37.7456288871148, -122.422567552448) | 2 | 7 | 5 | 28859 | 22 | ||
110059 | 34514 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1x GUY PL | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462 | 2114376 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | 6 | 2 | 9 | 28855 | 6 | |||
110275 | 51012 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 85 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2016 12:00:00 AM | 3 | Permit Number 778086 | 6001486.35916374 | 2107715.14620283 | 37.7674677672856 | -122.438138542404 | (37.7674677672856, -122.438138542404) | 15 | 5 | 5 | 29492 | 3 | ||
110587 | 62804 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1999 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23161 | 5999778.16418017 | 2092287.72080324 | 37.7250104697039 | -122.442938938279 | (37.7250104697039, -122.442938938279) | 9 | 7 | 6 | 28861 | 25 | ||
111364 | 62348 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 57 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22491 | 6005543.85080152 | 2099604.02987317 | 37.745426458533 | -122.423527484038 | (37.745426458533, -122.423527484038) | 2 | 7 | 5 | 28859 | 22 | ||
111820 | 10490 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1687 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 5997959.93364 | 2108479.83355 | 37.7693662163265 | -122.450391046811 | (37.7693662163265, -122.450391046811) | 15 | 5 | 11 | 29492 | 9 | |||
112112 | 66607 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 12 | Permit Number 29802 | 5989869.39246895 | 2090726.40504468 | 37.7201535727537 | -122.477078065149 | (37.7201535727537, -122.477078065149) | 1 | 8 | 4 | 64 | 14 | ||
113382 | 40574 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | 8 | 2 | 8 | 28853 | 20 | ||
115157 | 34444 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 74 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38188 | 6004269.61043081 | 2097757.70943651 | 37.7402848805672 | -122.427802072604 | (37.7402848805672, -122.427802072604) | 2 | 7 | 5 | 63 | 7 | ||
115880 | 14775 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 10 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | |||
117538 | 30959 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2401 Bush St | 1 | 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 | ||
119001 | 67758 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4394 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1995 12:00:00 AM | Permit Number 31437 | 6001339.65304045 | 2101178.10506013 | 37.7495102967122 | -122.43817763612 | (37.7495102967122, -122.43817763612) | 2 | 4 | 5 | 28862 | 22 | ||
119182 | 114771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
119613 | 30945 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 16 | 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 | ||
121175 | 67802 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4022 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31449 | 6003744.51176452 | 2100434.22126683 | 37.7476042452744 | -122.429808512801 | (37.7476042452744, -122.429808512801) | 2 | 4 | 5 | 63 | 22 | ||
121336 | 80832 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3100 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.456929197984 | (37.7774658426, -122.456929197984) | 11 | 6 | 2 | 54 | 16 | |
121835 | 46759 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1180X Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44858 | 6007776.04474552 | 2115482.02501481 | 37.7891494581332 | -122.416933662921 | (37.7891494581332, -122.416933662921) | 13 | 1 | 10 | 28858 | 21 | |||
122831 | 67990 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 324 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31715 | 5995860.10496142 | 2091242.55276948 | 37.7219165255419 | -122.45640761374 | (37.7219165255419, -122.45640761374) | 9 | 8 | 4 | 28861 | 24 | ||
123423 | 111033 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 8 | 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 | ||||
125715 | 40150 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560X Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | Permit Number 41343 | 5996910.70022428 | 2109465.35547876 | 37.7720120993682 | -122.454091465131 | (37.7720120993682, -122.454091465131) | 15 | 5 | 11 | 29492 | 16 | |||
126597 | 33954 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1999 12:00:00 AM | Permit Number 48991 | 6002287.3237241 | 2097040.91143479 | 37.7382043832783 | -122.434604778209 | (37.7382043832783, -122.434604778209) | 2 | 7 | 5 | 63 | 7 | |||
127594 | 98700 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2490X Divisadero St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000865 | 2116767.3 | 37.7922873178989 | -122.440937193321 | (37.7922873178989, -122.440937193321) | 13 | 6 | 1 | 29490 | 27 | ||||
128884 | 40584 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | 8 | 2 | 8 | 28853 | 20 | ||
129693 | 32286 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1800 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | Permit Number 36869 | 6001579.61916409 | 2114619.58179026 | 37.7864309126762 | -122.438310666952 | (37.7864309126762, -122.438310666952) | 13 | 6 | 11 | 29490 | 27 | |||
129814 | 47778 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 872 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | Permit Number 45554 | 5999190.57637215 | 2107256.51251673 | 37.7660776404196 | -122.446046324392 | (37.7660776404196, -122.446046324392) | 15 | 5 | 5 | 29492 | 9 | |||
131936 | 34513 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 18 Lansing St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | 6 | 2 | 9 | 28855 | 6 | |||
132055 | 111031 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 6 | 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 | ||||
132607 | 66239 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1023 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29337 | 5995901.80991046 | 2090714.82365274 | 37.720469900548 | -122.456225313763 | (37.720469900548, -122.456225313763) | 9 | 8 | 6 | 28861 | 24 | ||
134533 | 68795 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2574 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32734 | 5991441.9162308 | 2097904.96501407 | 37.7399552051973 | -122.472165418715 | (37.7399552051973, -122.472165418715) | 1 | 8 | 4 | 29491 | 40 | ||
135234 | 30946 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 14 | 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 | ||
135321 | 34446 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 84 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38190 | 6004274.31729793 | 2097673.91474862 | 37.7400550657314 | -122.427779829106 | (37.7400550657314, -122.427779829106) | 2 | 7 | 5 | 63 | 7 | ||
135640 | 66524 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 625 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30334 | 6002498.75858532 | 2099723.40130775 | 37.7455818770993 | -122.434065444251 | (37.7455818770993, -122.434065444251) | 2 | 7 | 5 | 63 | 22 | ||
135718 | 50043 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3920@ SANCHEZ 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46774 | 6003513.59033802 | 2104807.4010588 | 37.759598884966 | -122.430919082048 | (37.759598884966, -122.430919082048) | 2 | 4 | 5 | 28862 | 3 | |||
136691 | 34507 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 18 Lansing St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | 6 | 2 | 9 | 28855 | 6 | |||
137200 | 40593 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | 8 | 2 | 8 | 28853 | 20 | ||
139566 | 87081 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 172 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50022 | 6001920 | 2108624 | 37.7699879080732 | -122.436703704361 | (37.7699879080732, -122.436703704361) | 15 | 5 | 5 | 29492 | 9 | ||
143677 | 41343 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 340 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/25/2000 12:00:00 AM | Permit Number 41997 | 6003273.15240269 | 2109435.92669423 | 37.7722940667741 | -122.43208116562 | (37.7722940667741, -122.43208116562) | 15 | 9 | 11 | 29492 | 10 | ||
144248 | 30958 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 8 | 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 | ||
144596 | 62792 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23149 | 6001049.88033752 | 2093967.86468253 | 37.7296961834546 | -122.438663099148 | (37.7296961834546, -122.438663099148) | 9 | 7 | 6 | 28861 | 25 | ||
145627 | 40587 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | 8 | 2 | 8 | 28853 | 20 | ||
146432 | 62345 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 21 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/1989 12:00:00 AM | Permit Number 27053 | 6005775.86880093 | 2099617.25647877 | 37.7454758690666 | -122.422726141692 | (37.7454758690666, -122.422726141692) | 2 | 7 | 5 | 28859 | 22 | ||
147321 | 34510 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 18 Lansing St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | 6 | 2 | 9 | 28855 | 6 | |||
147347 | 46758 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1180X Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44858 | 6007776.04474552 | 2115482.02501481 | 37.7891494581332 | -122.416933662921 | (37.7891494581332, -122.416933662921) | 13 | 1 | 10 | 28858 | 21 | |||
147494 | 25233 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1637 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 5994903.85182 | 2092233.64445 | 37.7245828817054 | -122.459784868939 | (37.7245828817054, -122.459784868939) | 9 | 8 | 4 | 28861 | 24 | |||
147627 | 40595 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | 8 | 2 | 8 | 28853 | 20 | ||
149756 | 40571 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1750 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1999 12:00:00 AM | Permit Number 41613 | 6008764.95036499 | 2118846.2736549 | 37.7984424358323 | -122.41375022293 | (37.7984424358323, -122.41375022293) | 3 | 1 | 10 | 308 | 21 | |||
150529 | 49695 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4227 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/2006 12:00:00 AM | Permit Number 46516 | 6002391.92264985 | 2101184.34624044 | 37.7495872238662 | -122.434539307309 | (37.7495872238662, -122.434539307309) | 2 | 4 | 5 | 28862 | 22 | ||
150643 | 30948 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 11 | 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 | ||
151617 | 30952 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 5 | 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 | ||
151691 | 30955 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 3 | 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 | ||
152092 | 50629 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.7203756614272 | -122.39176255443 | (37.7203756614272, -122.39176255443) | 10 | 3 | 8 | 58 | 1 | |||
152346 | 49884 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 438@ SANCHEZ Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | Permit Number 46657 | 6003687.07481325 | 2099844.22133211 | 37.7459809898986 | -122.429965046522 | (37.7459809898986, -122.429965046522) | 2 | 7 | 5 | 63 | 22 | ||
152570 | 47784 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 411 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | Permit Number 45557 | 6009328.94293981 | 2121149.73408628 | 37.8047988220658 | -122.4119614934 | (37.8047988220658, -122.4119614934) | 3 | 1 | 10 | 308 | 23 | |||
153237 | 30950 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 7 | 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 | ||
153538 | 64837 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 220 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/1992 12:00:00 AM | Permit Number 30263 | 6004446.78862161 | 2099595.17558793 | 37.7453401631208 | -122.427320319833 | (37.7453401631208, -122.427320319833) | 2 | 7 | 5 | 63 | 22 | ||
153856 | 86882 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49807 | 6011833 | 2113224.2 | 37.7831773700909 | -122.402738173851 | (37.7831773700909, -122.402738173851) | 6 | 2 | 9 | 28853 | 34 | |||
153863 | 30953 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 4 | 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 | ||
153954 | 52473 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 454@ ANZA Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | Permit Number 48584 | 5991906.61756296 | 2112344.10243716 | 37.7796281496591 | -122.471610624408 | (37.7796281496591, -122.471610624408) | 11 | 6 | 2 | 54 | 11 | ||
154229 | 114773 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
155805 | 66517 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4172 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1991 12:00:00 AM | Permit Number 29684 | 6002746.62066356 | 2101256.12020049 | 37.7498044269933 | -122.43331787905 | (37.7498044269933, -122.43331787905) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |
157549 | 40142 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560X Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | Permit Number 41343 | 5996910.70022428 | 2109465.35547876 | 37.7720120993682 | -122.454091465131 | (37.7720120993682, -122.454091465131) | 15 | 5 | 11 | 29492 | 16 | |||
157944 | 34509 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 18 Lansing St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | 6 | 2 | 9 | 28855 | 6 | |||
159824 | 30944 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 9 | 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 | ||
160504 | 114772 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
161956 | 111032 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 7 | 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 | ||||
162241 | 62350 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 74 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22493 | 6005428.10472053 | 2099649.51598417 | 37.7455448191665 | -122.423930949775 | (37.7455448191665, -122.423930949775) | 2 | 7 | 5 | 28859 | 22 | ||
163383 | 50263 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 519 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46969 | 6006390.76852581 | 2096193.21285802 | 37.7361088859688 | -122.420356925459 | (37.7361088859688, -122.420356925459) | 2 | 7 | 7 | 28859 | 2 | ||
163502 | 41628 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1095 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42109 | 6007646.45182189 | 2109473.56842462 | 37.7726443942379 | -122.416956155908 | (37.7726443942379, -122.416956155908) | 8 | 2 | 9 | 28853 | 19 | |||
165237 | 35113 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
165709 | 14777 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 12 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | |||
166144 | 35111 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
166748 | 31500 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3244 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 35060 | 6006677.13820069 | 2103812.71234735 | 37.7570464414299 | -122.419907347924 | (37.7570464414299, -122.419907347924) | 2 | 4 | 7 | 28859 | 19 | ||||
167756 | 68408 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 170 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32243 | 5994001.22714578 | 2093857.38366654 | 37.7289893248225 | -122.463022856253 | (37.7289893248225, -122.463022856253) | 9 | 8 | 4 | 59 | 40 | ||
168976 | 2775 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 325 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 5994586.46007 | 2110712.87272 | 37.7753039042477 | -122.462221623284 | (37.7753039042477, -122.462221623284) | 11 | 6 | 2 | 54 | 11 | |||
169348 | 48771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 562 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2002 12:00:00 AM | Permit Number 773432 | 6005160.4427442 | 2110970.099276 | 37.77661335041 | -122.425662065534 | (37.77661335041, -122.425662065534) | 7 | 9 | 11 | 28852 | 10 | |||
172994 | 30951 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 6 | 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 | ||
173907 | 48950 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2911 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46135 | 6009399.56446616 | 2102741.17443943 | 37.7542572383471 | -122.410416464523 | (37.7542572383471, -122.410416464523) | 2 | 4 | 7 | 28859 | 19 | ||
174395 | 65162 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 957 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 14 | 4x12 | Permit Number 27142 | 6000403.82793053 | 2102538.64719816 | 37.7531927484611 | -122.441511357285 | (37.7531927484611, -122.441511357285) | 2 | 4 | 5 | 28862 | 22 |
175086 | 9540 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004321.7721316 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | 7 | 9 | 11 | 29490 | 41 | ||
175707 | 41649 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 450X Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2000 12:00:00 AM | Permit Number 42121 | 6000751.83853912 | 2110650.06591878 | 37.7754845196238 | -122.440889708326 | (37.7754845196238, -122.440889708326) | 15 | 5 | 11 | 29492 | 10 | |||
175799 | 30947 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 12 | 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 | ||
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 | ||
177695 | 12322 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1008X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6004729.34594 | 2112297.27395 | 37.7802330766406 | -122.427247915616 | (37.7802330766406, -122.427247915616) | 7 | 9 | 11 | 29490 | 41 | |||
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 | ||
179145 | 27408 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2178 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5997039.15745 | 2109490.68407 | 37.7720890100789 | -122.453648953362 | (37.7720890100789, -122.453648953362) | 15 | 5 | 11 | 29492 | 16 | ||
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 |
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) );