trees
1,069 rows where qSpecies_id = 93 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
78205 | 109306 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 RHODE ISLAND ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011759.4 | 2107238.5 | 37.7667379021668 | -122.402571748171 | (37.7667379021668, -122.402571748171) | 8 | 2 | 8 | 28853 | 20 | ||||
78732 | 28532 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 241 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | Permit Number 769387 | 6010727.06736 | 2111841.54231 | 37.7793191064344 | -122.406466814313 | (37.7793191064344, -122.406466814313) | 14 | 2 | 9 | 28853 | 34 | ||
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 | ||||
80553 | 107848 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 407 09th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6009766.34192 | 2109306.87193 | 37.7723057020722 | -122.409611431441 | (37.7723057020722, -122.409611431441) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
90242 | 40591 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 22 | 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 | ||
91134 | 40594 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 20 | 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 | ||
93637 | 197515 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | 6009794.12284 | 2109513.93692 | 37.7728758110884 | -122.409529951052 | (37.7728758110884, -122.409529951052) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | |||
94986 | 197510 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | 6009757.95432 | 2109468.49949 | 37.7727490237764 | -122.409651855072 | (37.7727490237764, -122.409651855072) | 14 | 2 | 9 | 28853 | 34 | ||||
96924 | 197573 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011805.47785 | 2113169.35516 | 37.7830252422689 | -122.402829531459 | (37.7830252422689, -122.402829531459) | 6 | 2 | 9 | 28853 | 34 | |||
96943 | 197563 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011871.68658 | 2107504.14213 | 37.767473563785 | -122.402202043898 | (37.767473563785, -122.402202043898) | 8 | 2 | 8 | 28853 | 20 | |||
97689 | 44030 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 96 Lafayette St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52444 | 6007681.41962 | 2109502.84398 | 37.7727267448872 | -122.416837272729 | (37.7727267448872, -122.416837272729) | 8 | 2 | 9 | 28853 | 19 | |
98154 | 111034 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 9 | 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 | ||||
98557 | 111030 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 5 | 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 | ||||
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 | |||
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 | ||||
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 | |
102509 | 197554 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Kansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 4ft | 6011382.26351 | 2107407.34025 | 37.7671804369461 | -122.403888089262 | (37.7671804369461, -122.403888089262) | 8 | 2 | 8 | 28853 | 20 | |||
105208 | 197514 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | 6009780.84318 | 2109499.43172 | 37.7728352390743 | -122.409574863193 | (37.7728352390743, -122.409574863193) | 14 | 2 | 9 | 28853 | 34 | ||||
106107 | 197517 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 407 09th St | 10 | : | Tree | Private 2 | 9 | Width 3ft | 6009758.68055 | 2109312.44793 | 37.7723205831618 | -122.40963832656 | (37.7723205831618, -122.40963832656) | 14 | 2 | 9 | 28853 | 34 | |||
106282 | 197571 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011772.19211 | 2113135.08358 | 37.7829292819051 | -122.402942275888 | (37.7829292819051, -122.402942275888) | 6 | 2 | 9 | 28853 | 34 | |||
108154 | 28531 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 241 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2012 12:00:00 AM | 18 | 3X3 | Permit Number 769387 | 6010735.41269 | 2111831.43795 | 37.7792918290844 | -122.406437232011 | (37.7792918290844, -122.406437232011) | 14 | 2 | 9 | 28853 | 34 | |
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 | |||
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 | |||
110464 | 197550 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6011736.46068 | 2107238.9435 | 37.7667378392138 | -122.402651123063 | (37.7667378392138, -122.402651123063) | 8 | 2 | 8 | 28853 | 20 | |||
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 | |||
112473 | 109297 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 RHODE ISLAND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011759.4 | 2107238.5 | 37.7667379021668 | -122.402571748171 | (37.7667379021668, -122.402571748171) | 8 | 2 | 8 | 28853 | 20 | ||||
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 | ||
114432 | 109303 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 RHODE ISLAND ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011759.4 | 2107238.5 | 37.7667379021668 | -122.402571748171 | (37.7667379021668, -122.402571748171) | 8 | 2 | 8 | 28853 | 20 | ||||
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 | |
118151 | 197516 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 11 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 6009818.3758 | 2109520.83011 | 37.7728960971219 | -122.409446543433 | (37.7728960971219, -122.409446543433) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | ||||
124607 | 197559 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Kansas St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 4ft | 6011390.59783 | 2107261.91001 | 37.7667815840329 | -122.403849027227 | (37.7667815840329, -122.403849027227) | 8 | 2 | 8 | 28853 | 20 | |||
126705 | 197568 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6011770.36838 | 2107496.45307 | 37.7674467954558 | -122.402551951223 | (37.7674467954558, -122.402551951223) | 8 | 2 | 8 | 28853 | 20 | |||
127345 | 197565 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011813.28863 | 2107500.86119 | 37.7674612952308 | -122.402403805019 | (37.7674612952308, -122.402403805019) | 8 | 2 | 8 | 28853 | 20 | |||
128128 | 197557 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Kansas St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 4ft | 6011388.35138 | 2107305.69041 | 37.7669016696051 | -122.403859878426 | (37.7669016696051, -122.403859878426) | 8 | 2 | 8 | 28853 | 20 | |||
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 | ||
130739 | 197574 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011821.05226 | 2113183.26768 | 37.7830643124058 | -122.402776628832 | (37.7830643124058, -122.402776628832) | 6 | 2 | 9 | 28853 | 34 | |||
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 | ||||
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 | |||
133546 | 51034 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2004 12:00:00 AM | 13 | Permit Number 47509 | 6009703.0212 | 2109410.10707 | 37.7725856133573 | -122.409837753032 | (37.7725856133573, -122.409837753032) | 14 | 2 | 9 | 28853 | 34 | |
135187 | 197566 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6011795.68975 | 2107497.96925 | 37.7674523721611 | -122.402464474151 | (37.7674523721611, -122.402464474151) | 8 | 2 | 8 | 28853 | 20 | |||
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 | ||
139942 | 197547 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6011743.05813 | 2107162.2739 | 37.7665276901155 | -122.402622911324 | (37.7665276901155, -122.402622911324) | 8 | 2 | 8 | 28853 | 20 | |||
141730 | 197572 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011789.60702 | 2113153.20247 | 37.7829800045728 | -122.40288330192 | (37.7829800045728, -122.40288330192) | 6 | 2 | 9 | 28853 | 34 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||||
1613 | 112905 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500 Bancroft Ave | 1 | Front Yard : Yard | Tree | DPW 1 | 25 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | ||||
3162 | 202093 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2403 Keith St | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | 25 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | ||||
3578 | 261993 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
6032 | 50628 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 1 | 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 | |||
6230 | 262036 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
7784 | 197575 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1121 Jamestown Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 6013269.3073 | 2090137.6242 | 37.7198666867704 | -122.396150589498 | (37.7198666867704, -122.396150589498) | 10 | 3 | 8 | 58 | 1 | ||||
11444 | 261994 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
12244 | 261985 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500x Bancroft Ave | Front Yard : Yard | Tree | Private 2 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | ||||||
13099 | 197577 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 299x Cashmere St | 5 | Median : Yard | Tree | DPW 1 | 33 | 6016820.77887 | 2095888.49241 | 37.735854408739 | -122.38427457691 | (37.735854408739, -122.38427457691) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
17557 | 261982 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2403 Keith St | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | |||||
17656 | 261984 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557 Bancroft Ave | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014517 | 2091967 | 37.7249591332222 | -122.391965574806 | (37.7249591332222, -122.391965574806) | 10 | 3 | 8 | 58 | 1 | |||||
18238 | 200676 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015656.8366 | 2095323.7293 | 37.7342392575487 | -122.388259416585 | (37.7342392575487, -122.388259416585) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
32927 | 179473 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 890 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011506.9921 | 2090808.93918 | 37.7216117663527 | -122.402289508352 | (37.7216117663527, -122.402289508352) | 10 | 3 | 7 | 309 | 28 | |||
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 | ||||
39904 | 200682 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6015703.0041 | 2095289.1037 | 37.7341467406335 | -122.388097383825 | (37.7341467406335, -122.388097383825) | 10 | 3 | 8 | 58 | 1 | |||
40892 | 200680 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6015687.0653 | 2095298.4471 | 37.734171512631 | -122.388153141599 | (37.734171512631, -122.388153141599) | 10 | 3 | 8 | 58 | 1 | |||
43725 | 200673 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6015618.3638 | 2095361.6525 | 37.7343412551751 | -122.38839507653 | (37.7343412551751, -122.38839507653) | 10 | 3 | 8 | 58 | 1 | |||
44049 | 26131 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x3 | 6015558.456 | 2095125.3192 | 37.7336890117673 | -122.388585707606 | (37.7336890117673, -122.388585707606) | 10 | 3 | 8 | 58 | 1 |
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) );