trees
1,069 rows where qSpecies_id = 93 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
143552 | 197507 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6009714.36956 | 2109423.21347 | 37.7726222364622 | -122.409799423029 | (37.7726222364622, -122.409799423029) | 14 | 2 | 9 | 28853 | 34 | |||
145491 | 197562 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6011885.98223 | 2107505.07026 | 37.7674769101657 | -122.402152662133 | (37.7674769101657, -122.402152662133) | 8 | 2 | 8 | 28853 | 20 | |||
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 | ||
147268 | 197552 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011729.09071 | 2107385.60351 | 37.7671401230397 | -122.402686929574 | (37.7671401230397, -122.402686929574) | 8 | 2 | 8 | 28853 | 20 | |||
147544 | 197548 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6011737.58275 | 2107186.12686 | 37.7665928792734 | -122.402643527378 | (37.7665928792734, -122.402643527378) | 8 | 2 | 8 | 28853 | 20 | |||
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 | ||
150237 | 200831 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1550 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6011784.6689 | 2107029.6831 | 37.7661659486938 | -122.402469661979 | (37.7661659486938, -122.402469661979) | 8 | 3 | 8 | 28853 | 20 | |||
150837 | 197526 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6010646.79925 | 2106595.9922 | 37.7649115436568 | -122.40637478936 | (37.7649115436568, -122.40637478936) | 8 | 4 | 8 | 28853 | 19 | |||
153019 | 64355 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 230 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1988 12:00:00 AM | 8 | Permit Number 770960 | 6011932.302 | 2113111.47227 | 37.7828733899288 | -122.402386698084 | (37.7828733899288, -122.402386698084) | 6 | 2 | 9 | 28853 | 34 | ||
153490 | 197549 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011738.81307 | 2107215.77896 | 37.766674365946 | -122.402641357327 | (37.766674365946, -122.402641357327) | 8 | 2 | 8 | 28853 | 20 | |||
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 | |||
155041 | 197553 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6011728.60069 | 2107407.79279 | 37.7672010224355 | -122.402690185116 | (37.7672010224355, -122.402690185116) | 8 | 2 | 8 | 28853 | 20 | |||
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 | ||||
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 | |||
170927 | 197512 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | 6009788.18393 | 2109495.5877 | 37.7728250956205 | -122.409549199229 | (37.7728250956205, -122.409549199229) | 14 | 2 | 9 | 28853 | 34 | ||||
172287 | 24345 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 95 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6006134.19272 | 2108466.72229 | 37.7697946537198 | -122.422115687012 | (37.7697946537198, -122.422115687012) | 8 | 4 | 7 | 28853 | 19 | |||
176271 | 197569 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011744.63707 | 2113111.42965 | 37.7828627950365 | -122.403035941152 | (37.7828627950365, -122.403035941152) | 6 | 2 | 9 | 28853 | 34 | |||
177569 | 200829 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1550 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6011839.8305 | 2107032.5363 | 37.7661768622321 | -122.402279068281 | (37.7661768622321, -122.402279068281) | 8 | 3 | 8 | 28853 | 20 | |||
178619 | 197564 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011853.28866 | 2107502.07899 | 37.7674668719146 | -122.402265535131 | (37.7674668719146, -122.402265535131) | 8 | 2 | 8 | 28853 | 20 | |||
181312 | 24344 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 95 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6006121.89128 | 2108467.81183 | 37.7697969514995 | -122.422158314852 | (37.7697969514995, -122.422158314852) | 8 | 4 | 7 | 28853 | 19 | |||
181408 | 197520 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98 Lafayette St | 5 | : | Tree | Private 2 | 22 | Width 3ft | 6007717.24028 | 2109472.44967 | 37.7726453040621 | -122.416711211162 | (37.7726453040621, -122.416711211162) | 8 | 2 | 9 | 28853 | 19 | |||
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 | ||||
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 | ||
187175 | 197551 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011729.23528 | 2107361.85894 | 37.7670749338806 | -122.402684759517 | (37.7670749338806, -122.402684759517) | 8 | 2 | 8 | 28853 | 20 | |||
188249 | 197508 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | 6009725.72224 | 2109430.36659 | 37.7726425134742 | -122.409760657749 | (37.7726425134742, -122.409760657749) | 14 | 2 | 9 | 28853 | 34 | ||||
192856 | 197561 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6011901.49708 | 2107505.77021 | 37.7674796980447 | -122.402099047246 | (37.7674796980447, -122.402099047246) | 8 | 2 | 8 | 28853 | 20 | |||
335 | 102831 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
8180 | 197538 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 33 Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6014309.72341 | 2114400.37585 | 37.7865448523989 | -122.39425201814 | (37.7865448523989, -122.39425201814) | 6 | 2 | 9 | 28855 | 6 | |||
16917 | 197539 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 33 Guy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014318.065 | 2114410.62146 | 37.7865734481466 | -122.394223875652 | (37.7865734481466, -122.394223875652) | 6 | 2 | 9 | 28855 | 6 | |||
30024 | 197541 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 33 Guy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014357.779 | 2114449.44998 | 37.7866822697032 | -122.394089193158 | (37.7866822697032, -122.394089193158) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
80921 | 34505 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1x GUY PL | 1 | 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 | |||
90230 | 34506 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1x GUY PL | 3 | 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 | |||
93708 | 34503 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1x GUY PL | 2 | 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 | |||
100760 | 34504 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 18 Lansing St | 6 | 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 | |||
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 | |||
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 | |||
132515 | 102836 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X LANSING ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014464 | 2114267 | 37.7861872071537 | -122.393708916182 | (37.7861872071537, -122.393708916182) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
146428 | 102835 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
155597 | 102834 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
156586 | 197542 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 346 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6014414.15376 | 2114458.74368 | 37.7867109212046 | -122.393894799306 | (37.7867109212046, -122.393894799306) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
167389 | 102832 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
187276 | 197540 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 33 Guy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6014343.28071 | 2114436.43625 | 37.7866457311723 | -122.394138442734 | (37.7866457311723, -122.394138442734) | 6 | 2 | 9 | 28855 | 6 | |||
350 | 119661 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
21269 | 197529 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1399 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013534.71133 | 2105671.72801 | 37.7625348459264 | -122.396321376134 | (37.7625348459264, -122.396321376134) | 14 | 3 | 8 | 28856 | 29 | |||
21972 | 197530 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1400 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6013404.894 | 2105708.82045 | 37.7626294689928 | -122.396772970689 | (37.7626294689928, -122.396772970689) | 14 | 3 | 8 | 28856 | 29 | |||
23977 | 101872 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6012644.6557 | 2113099.5202 | 37.782880312512 | -122.39992139618 | (37.782880312512, -122.39992139618) | 6 | 2 | 9 | 28856 | 34 | |||
27413 | 101870 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779151 | 6012595.5925 | 2113052.7427 | 37.7827491368943 | -122.400087849303 | (37.7827491368943, -122.400087849303) | 6 | 2 | 9 | 28856 | 34 | |
39890 | 197532 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Missouri St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6013605.01625 | 2103874.96409 | 37.757605236407 | -122.395952299753 | (37.757605236407, -122.395952299753) | 10 | 3 | 8 | 28856 | 29 | ||||
48571 | 197536 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Missouri St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6013614.8063 | 2103893.08079 | 37.7576555255942 | -122.395919711032 | (37.7576555255942, -122.395919711032) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||
59121 | 119660 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
60432 | 112026 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
62536 | 112022 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
73651 | 112027 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
91855 | 197531 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2006 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6012046.11634 | 2103763.76948 | 37.7572130681337 | -122.401335827695 | (37.7572130681337, -122.401335827695) | 10 | 3 | 8 | 28856 | 29 | |||
101372 | 101867 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769242 | 6012649.1 | 2113074.7 | 37.7828124097662 | -122.399904277178 | (37.7828124097662, -122.399904277178) | 6 | 2 | 9 | 28856 | 34 | |
112260 | 101869 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6012583.9023 | 2113041.0524 | 37.7827163862355 | -122.400127471434 | (37.7827163862355, -122.400127471434) | 6 | 2 | 9 | 28856 | 34 | |||
117285 | 101868 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2014 12:00:00 AM | 6 | 3x3 | Permit Number 771222 | 6012702 | 2113175 | 37.7830907593936 | -122.399728309071 | (37.7830907593936, -122.399728309071) | 6 | 2 | 9 | 28856 | 34 | |
129735 | 197534 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Missouri St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6013594.2637 | 2104046.7535 | 37.7580763345811 | -122.396001525061 | (37.7580763345811, -122.396001525061) | 10 | 3 | 8 | 28856 | 29 | ||||
129965 | 112024 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
155354 | 101871 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6012623.9262 | 2113078.7907 | 37.7828222383966 | -122.399991655868 | (37.7828222383966, -122.399991655868) | 6 | 2 | 9 | 28856 | 34 | |||
159854 | 119671 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
169381 | 197533 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Missouri St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6013601.75095 | 2103896.53741 | 37.7576642903943 | -122.395965104316 | (37.7576642903943, -122.395965104316) | 10 | 3 | 8 | 28856 | 29 | ||||
171923 | 49833 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 418@ 19th ST Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 12 | Permit Number 46616 | 6014316.07851 | 2105148.78787 | 37.7611424148166 | -122.393582289386 | (37.7611424148166, -122.393582289386) | 10 | 3 | 8 | 28856 | 29 | |
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 | |||||
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 | |||
141721 | 98795 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 950@Washington Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | |||
17584 | 66355 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 842 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1992 12:00:00 AM | 15 | Permit Number 30970 | 6006677.47104 | 2121530.77464 | 37.8056959468756 | -122.421164278004 | (37.8056959468756, -122.421164278004) | 5 | 1 | 1 | 28858 | 32 | ||
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 | ||
37780 | 136408 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1120 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008149.75151 | 2118608.08883 | 37.7977538729053 | -122.415862131533 | (37.7977538729053, -122.415862131533) | 5 | 1 | 10 | 28858 | 21 | |||
56923 | 136400 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1128 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007907.63985 | 2115517.19966 | 37.7892534404542 | -122.416480851612 | (37.7892534404542, -122.416480851612) | 13 | 1 | 10 | 28858 | 21 | |||
59403 | 46760 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1180X Bush St | 1 | 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 | |||
67130 | 23587 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3251X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.425855144407 | (37.8066799978444, -122.425855144407) | 13 | 1 | 1 | 28858 | 17 | |||
67554 | 23458 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2252 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 4X4 | 6005965.50421 | 2118183.1057 | 37.7964639393172 | -122.423390011952 | (37.7964639393172, -122.423390011952) | 13 | 9 | 10 | 28858 | 32 | |||
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 | |||
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 | |||
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 | |||
162251 | 136397 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3101 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005394.36926 | 2121578.01878 | 37.8057532498833 | -122.425608007222 | (37.8057532498833, -122.425608007222) | 13 | 1 | 1 | 28858 | 17 | |||
170405 | 136402 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1128 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007876.49139 | 2115513.01244 | 37.7892401916349 | -122.416588325105 | (37.7892401916349, -122.416588325105) | 13 | 1 | 10 | 28858 | 21 | |||
187655 | 136409 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 842 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006660.27823 | 2121526.69808 | 37.8056837844424 | -122.421223486682 | (37.8056837844424, -122.421223486682) | 5 | 1 | 1 | 28858 | 32 | |||
6965 | 240534 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3250 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2020 12:00:00 AM | 3 | Width 3ft | 6006614.52941 | 2103803.76084 | 37.7570183352315 | -122.420123238094 | (37.7570183352315, -122.420123238094) | 2 | 4 | 7 | 28859 | 19 | ||
7605 | 240540 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 72 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6005500 | 2099675 | 37.7456188511036 | -122.423684158346 | (37.7456188511036, -122.423684158346) | 2 | 7 | 5 | 28859 | 22 | |||
14741 | 33010 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3622 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42195 | 6005636.60974519 | 2102002.04320044 | 37.7520160884207 | -122.423377179853 | (37.7520160884207, -122.423377179853) | 2 | 4 | 5 | 28859 | 19 | ||
16168 | 4153 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3721-3721 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/31/1989 12:00:00 AM | 6 | 3X3 | 6005701.8016 | 2100493.99134 | 37.7478790037267 | -122.423044558975 | (37.7478790037267, -122.423044558975) | 2 | 4 | 5 | 28859 | 22 | ||
19784 | 240541 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 72 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6005497.38826 | 2099648.86664 | 37.7455469474293 | -122.423691331589 | (37.7455469474293, -122.423691331589) | 2 | 7 | 5 | 28859 | 22 | |||
22628 | 101981 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
22649 | 239673 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 51 Tiffany Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 6006373.75126 | 2099735.68708 | 37.7458347673547 | -122.420667160657 | (37.7458347673547, -122.420667160657) | 2 | 7 | 7 | 28859 | 2 | |||
25673 | 4159 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3736-3738 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1989 12:00:00 AM | 23 | 3X3 | 6005622.07663 | 2100534.07243 | 37.7479845580381 | -122.4233230934 | (37.7479845580381, -122.4233230934) | 2 | 4 | 5 | 28859 | 19 | ||
29321 | 701 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1401X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005272.9475237 | 2100137.7446563 | 37.7468766226068 | -122.424502181659 | (37.7468766226068, -122.424502181659) | 2 | 7 | 5 | 28859 | 22 | |||
39481 | 101978 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6006502 | 2099737 | 37.7458455996049 | -122.420223786963 | (37.7458455996049, -122.420223786963) | 2 | 7 | 7 | 28859 | 2 | ||||
50254 | 239671 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 761 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6005055.20153 | 2103892.32562 | 37.7571735312626 | -122.425522291914 | (37.7571735312626, -122.425522291914) | 2 | 4 | 5 | 28859 | 19 | |||
54229 | 240538 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 57 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005573.72478 | 2099614.71997 | 37.7454574972629 | -122.423424944317 | (37.7454574972629, -122.423424944317) | 2 | 7 | 5 | 28859 | 22 | |||
54468 | 5480 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 695 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 8 | 6005032.86911 | 2104338.69015 | 37.7583978815122 | -122.425631294213 | (37.7583978815122, -122.425631294213) | 2 | 4 | 5 | 28859 | 19 | |||
57183 | 24291 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 300 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006664.25165 | 2098042.76581 | 37.7412027542911 | -122.41954256204 | (37.7412027542911, -122.41954256204) | 2 | 7 | 7 | 28859 | 2 | |||
58081 | 33457 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 300 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37712 | 6006656.20982267 | 2098052.1703387 | 37.7412281240479 | -122.419571034944 | (37.7412281240479, -122.419571034944) | 2 | 7 | 7 | 28859 | 2 | |||
65095 | 101807 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 733 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 19463 | 6008567.7 | 2104253 | 37.7583616995478 | -122.413400180344 | (37.7583616995478, -122.413400180344) | 2 | 4 | 7 | 28859 | 19 |
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) );