trees
182 rows where SiteOrder = 2 and 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12227 | 33648 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 530 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37739 | 6004854.0578934 | 2110753.28886702 | 37.7760007246145 | -122.426706497307 | (37.7760007246145, -122.426706497307) | 7 | 9 | 11 | 28852 | 10 | |||
60311 | 136398 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 536 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6004816.14787 | 2110734.28179 | 37.7759463924382 | -122.426836284165 | (37.7759463924382, -122.426836284165) | 7 | 9 | 11 | 28852 | 10 | |||
80575 | 142222 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 536 LINDEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6004811.0996 | 2110732.6679 | 37.7759416756566 | -122.426853632489 | (37.7759416756566, -122.426853632489) | 7 | 9 | 11 | 28852 | 10 | |||
83546 | 246591 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 22 Waller St | 2 | : | Tree | Private 2 | 20 | Width 3ft | 6005592.78222 | 2109289.94448 | 37.7720244723693 | -122.424046964897 | (37.7720244723693, -122.424046964897) | 7 | 9 | 11 | 28852 | 10 | |||
116236 | 108004 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 520 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | Permit Number 773433 | 6005298.14108 | 2111058.38089 | 37.776863530054 | -122.425192009758 | (37.776863530054, -122.425192009758) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
174064 | 138844 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005153.7619 | 2110972.2976 | 37.7766190089592 | -122.425685333039 | (37.7766190089592, -122.425685333039) | 7 | 9 | 11 | 28852 | 10 | |||
13044 | 197544 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6011744.68904 | 2107088.20402 | 37.766324401967 | -122.402612061007 | (37.766324401967, -122.402612061007) | 8 | 2 | 8 | 28853 | 20 | |||
36630 | 197555 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Kansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 4ft | 6011386.38473 | 2107363.2099 | 37.7670594952368 | -122.403870728771 | (37.7670594952368, -122.403870728771) | 8 | 2 | 8 | 28853 | 20 | |||
50109 | 197570 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011756.09586 | 2113120.18338 | 37.7828874706141 | -122.402996914199 | (37.7828874706141, -122.402996914199) | 6 | 2 | 9 | 28853 | 34 | |||
75678 | 197519 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1055 Natoma St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6007591.22918 | 2109427.92338 | 37.7725159572842 | -122.417143942455 | (37.7725159572842, -122.417143942455) | 8 | 2 | 9 | 28853 | 19 | |||
88167 | 197527 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6010651.56665 | 2106560.03091 | 37.7648130687996 | -122.406355766009 | (37.7648130687996, -122.406355766009) | 8 | 4 | 8 | 28853 | 19 | |||
89864 | 200830 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1550 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6011811.2987 | 2107032.5363 | 37.7661752695362 | -122.402377754798 | (37.7661752695362, -122.402377754798) | 8 | 3 | 8 | 28853 | 20 | |||
94667 | 197523 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1919 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010718.52588 | 2106914.57132 | 37.7657903018022 | -122.406149150388 | (37.7657903018022, -122.406149150388) | 8 | 4 | 8 | 28853 | 19 | |||
96965 | 239687 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 201 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006096.7615 | 2108447.15285 | 37.7697388094304 | -122.422243770256 | (37.7697388094304, -122.422243770256) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |
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 | ||||
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 | |||
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 | ||||
117461 | 200842 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1919 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010705.6887 | 2106916.0312 | 37.7657935922594 | -122.40619365455 | (37.7657935922594, -122.40619365455) | 8 | 4 | 8 | 28853 | 19 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
65438 | 239712 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 88 Santa Marina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006164.57012 | 2097549.79113 | 37.7398209981319 | -122.421235287575 | (37.7398209981319, -122.421235287575) | 2 | 7 | 7 | 28859 | 2 | |||
66667 | 31499 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3244 21st St | 2 | 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 | ||||
78515 | 239684 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1664 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6009268.13 | 2099680.20873 | 37.7458451383533 | -122.41065485094 | (37.7458451383533, -122.41065485094) | 2 | 7 | 7 | 28859 | 2 | |||
99055 | 40859 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1670 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42380 | 6009721.65724328 | 2100087.27684169 | 37.7469882750849 | -122.409115329349 | (37.7469882750849, -122.409115329349) | 2 | 7 | 7 | 28859 | 2 | ||
121929 | 239680 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 14 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6005352.16587 | 2103533.57017 | 37.7562052473857 | -122.424469755997 | (37.7562052473857, -122.424469755997) | 2 | 4 | 5 | 28859 | 19 | |||
164647 | 240536 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3256 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006586.82298 | 2103803.98419 | 37.7570173873698 | -122.420219073467 | (37.7570173873698, -122.420219073467) | 2 | 4 | 7 | 28859 | 19 | |||
170620 | 101979 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | ||
74312 | 113590 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 2 | 3x3 | 6013615.62221 | 2118103.5659 | 37.7966743392965 | -122.396913185795 | (37.7966743392965, -122.396913185795) | 3 | 1 | 10 | 28860 | 6 | ||
121653 | 136417 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013524.76569 | 2118243.85815 | 37.797054490825 | -122.397237414787 | (37.797054490825, -122.397237414787) | 3 | 1 | 10 | 28860 | 6 | |||
166105 | 136412 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 550 Davis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013223.70662 | 2118326.48177 | 37.7972645904406 | -122.398284959481 | (37.7972645904406, -122.398284959481) | 3 | 1 | 10 | 28860 | 6 | |||
22787 | 215004 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 240 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5996022.14356 | 2090574.20231 | 37.7200906944015 | -122.455799201591 | (37.7200906944015, -122.455799201591) | 9 | 8 | 6 | 28861 | 24 | |||
23898 | 35110 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1998 12:00:00 AM | Permit Number 40572 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
38007 | 217714 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1199 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5996346.1405 | 2091806.7339 | 37.7234935241877 | -122.454768263296 | (37.7234935241877, -122.454768263296) | 9 | 8 | 4 | 28861 | 24 | |||
80210 | 114872 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 735 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6002556.26502 | 2089229.80958 | 37.7167721250182 | -122.433116973091 | (37.7167721250182, -122.433116973091) | 9 | 7 | 6 | 28861 | 5 | ||||
93273 | 179485 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6001441.34691 | 2093639.06415 | 37.7288156345119 | -122.437286225591 | (37.7288156345119, -122.437286225591) | 9 | 7 | 6 | 28861 | 25 | |||
102339 | 179465 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 291 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6001702.1853 | 2090068.84403 | 37.7190274412447 | -122.436129108381 | (37.7190274412447, -122.436129108381) | 9 | 7 | 6 | 28861 | 5 | |||
103624 | 214999 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 325 Holloway Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995798.02713 | 2091198.56158 | 37.7217921721658 | -122.456619019966 | (37.7217921721658, -122.456619019966) | 9 | 8 | 6 | 28861 | 24 | |||
156434 | 179492 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 781 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6002448.84708 | 2087107.83027 | 37.7109395422009 | -122.433336718839 | (37.7109395422009, -122.433336718839) | 9 | 7 | 6 | 28861 | 5 | |||
157153 | 179460 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6000997.30077 | 2089688.71555 | 37.7179436214658 | -122.438538393947 | (37.7179436214658, -122.438538393947) | 9 | 7 | 6 | 28861 | 5 | |||
162504 | 179476 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 245 Wilson St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5994306.08107 | 2086649.96822 | 37.7092170428021 | -122.461446662549 | (37.7092170428021, -122.461446662549) | 9 | 8 | 6 | 28861 | 25 | ||||
167640 | 179462 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 90 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000856.84082 | 2089774.26479 | 37.7181705294179 | -122.43903002902 | (37.7181705294179, -122.43903002902) | 9 | 7 | 6 | 28861 | 5 | |||
172022 | 35126 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 766 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 7 | Permit Number 38660 | 6001721.91154 | 2089504.55342 | 37.7174791459225 | -122.43602056561 | (37.7174791459225, -122.43602056561) | 9 | 7 | 6 | 28861 | 5 | |
186974 | 179491 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 117 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002422.82198 | 2087024.8993 | 37.7107103553801 | -122.433420745181 | (37.7107103553801, -122.433420745181) | 9 | 7 | 6 | 28861 | 5 | |||
35678 | 240563 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Hancock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004179.51855 | 2105131.83325 | 37.7605274080343 | -122.42863909662 | (37.7605274080343, -122.42863909662) | 2 | 4 | 5 | 28862 | 3 | |||
56982 | 240571 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 387 Eureka St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001511.27704 | 2103588.18103 | 37.7561375464167 | -122.437756745491 | (37.7561375464167, -122.437756745491) | 2 | 4 | 5 | 28862 | 3 | |||
57063 | 240572 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 210 Collingwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6002036.98136 | 2104624.07975 | 37.7590117527075 | -122.436012807155 | (37.7590117527075, -122.436012807155) | 2 | 4 | 5 | 28862 | 3 | |||
60334 | 240558 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 983 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003807.25002 | 2102556.49662 | 37.7534350692835 | -122.429742914602 | (37.7534350692835, -122.429742914602) | 2 | 4 | 5 | 28862 | 22 | |||
67312 | 239692 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3591 21st St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 19 | Width 4ft | 6004466.42319 | 2103643.72661 | 37.7564576520127 | -122.427540804958 | (37.7564576520127, -122.427540804958) | 2 | 4 | 5 | 28862 | 22 | |||
85310 | 50056 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 646 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46785 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341 | (37.7605408596837, -122.42837316341) | 2 | 4 | 5 | 28862 | 3 | |||
95638 | 239695 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 49 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6004807.13542 | 2101616.24717 | 37.7509099321629 | -122.426218161243 | (37.7509099321629, -122.426218161243) | 2 | 4 | 5 | 28862 | 22 | |||
106826 | 239719 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4818 25th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 10ft | 5999936.15376 | 2101092.93289 | 37.7491965123129 | -122.443024847242 | (37.7491965123129, -122.443024847242) | 2 | 4 | 5 | 28862 | 22 | |||
115664 | 5372 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 266 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6004807.33386 | 2106790.92069 | 37.7651183778313 | -122.426585912012 | (37.7651183778313, -122.426585912012) | 8 | 4 | 5 | 28862 | 3 | |||
126222 | 239725 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 921 Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6000349.32495 | 2102545.17891 | 37.7532075776886 | -122.441700307737 | (37.7532075776886, -122.441700307737) | 2 | 4 | 5 | 28862 | 22 | |||
128364 | 5349 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/22/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53640 | 6004790.70557 | 2107143.57223 | 37.7660857344886 | -122.426668539926 | (37.7660857344886, -122.426668539926) | 8 | 4 | 5 | 28862 | 3 | |
148873 | 240547 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4250 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001501.76962 | 2102352.07867 | 37.752742966328 | -122.437701100834 | (37.752742966328, -122.437701100834) | 2 | 4 | 5 | 28862 | 22 | |||
3780 | 14742 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004772.182 | 2111961.3352 | 37.7793130940377 | -122.427075791541 | (37.7793130940377, -122.427075791541) | 7 | 9 | 11 | 29490 | 41 | |||
27097 | 12333 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1105X Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3X3 | 6004706.62549 | 2112590.71039 | 37.7810374956819 | -122.427347425327 | (37.7810374956819, -122.427347425327) | 7 | 9 | 11 | 29490 | 41 | |||
49551 | 5262 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1234 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6001365.3782 | 2112681.2883 | 37.7810966664945 | -122.438912929299 | (37.7810966664945, -122.438912929299) | 15 | 5 | 11 | 29490 | 41 | |||
58515 | 22676 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1340 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003587.61727 | 2112577.28894 | 37.7809372939052 | -122.431217671135 | (37.7809372939052, -122.431217671135) | 15 | 9 | 11 | 29490 | 41 | |||
71403 | 14754 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 950X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
74166 | 138389 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1955 STEINER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002444.1157 | 2115010.1115 | 37.7875523399426 | -122.435347676 | (37.7875523399426, -122.435347676) | 13 | 9 | 11 | 29490 | 27 | |||
79932 | 138325 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2492 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001603.2252 | 2114641.6748 | 37.7864929170324 | -122.438230579455 | (37.7864929170324, -122.438230579455) | 13 | 6 | 11 | 29490 | 27 | |||
97829 | 30957 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 2 | 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 | ||
131378 | 138488 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002039.4918 | 2114807.7995 | 37.7869738559463 | -122.43673310409 | (37.7869738559463, -122.43673310409) | 13 | 6 | 11 | 29490 | 27 | |||
154530 | 138491 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1800 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002045.7921 | 2114746.8959 | 37.7868069882912 | -122.43670694528 | (37.7868069882912, -122.43670694528) | 13 | 6 | 11 | 29490 | 27 | |||
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 | ||
186525 | 18089 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3000 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 5999515.0867 | 2114695.0726 | 37.786520549412 | -122.445458834419 | (37.786520549412, -122.445458834419) | 15 | 6 | 1 | 29490 | 31 | |||
186586 | 141838 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1103 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004708.7161 | 2112593.1646 | 37.7810443525714 | -122.427340367744 | (37.7810443525714, -122.427340367744) | 7 | 9 | 11 | 29490 | 41 | |||
108229 | 214175 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2574 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991436.71189 | 2097914.45578 | 37.7399809632369 | -122.472184104624 | (37.7399809632369, -122.472184104624) | 1 | 8 | 4 | 29491 | 40 | |||
157428 | 183899 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5989428.0919 | 2100803.1123 | 37.7477960125827 | -122.479340275734 | (37.7477960125827, -122.479340275734) | 1 | 8 | 3 | 29491 | 35 | |||
23706 | 239699 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 157 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997863.73891 | 2105916.05553 | 37.7623212272736 | -122.450538922143 | (37.7623212272736, -122.450538922143) | 15 | 5 | 11 | 29492 | 9 | |||
48218 | 27409 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2178 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5997014.41754 | 2109490.27003 | 37.7720864549253 | -122.453734500333 | (37.7720864549253, -122.453734500333) | 15 | 5 | 11 | 29492 | 16 | ||
64596 | 52688 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1401@ RIVOLI Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2006 12:00:00 AM | Permit Number 48758 | 5997782.1418349 | 2105912.5855129 | 37.76230702883 | -122.450820884323 | (37.76230702883, -122.450820884323) | 15 | 5 | 11 | 29492 | 9 | |||
65498 | 140194 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2177 FELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997033.6803 | 2109487.6013 | 37.772080231598 | -122.45366767652 | (37.772080231598, -122.45366767652) | 15 | 5 | 11 | 29492 | 16 | |||
79965 | 239706 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4922 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 5997784.7842 | 2105653.47991 | 37.7615957414698 | -122.450793062454 | (37.7615957414698, -122.450793062454) | 15 | 5 | 11 | 29492 | 9 | |||
85114 | 247185 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 2 | : | Tree | Private 2 | 13 | Width 4ft | 6000997.16935 | 2108899.56704 | 37.7706920584128 | -122.439915513203 | (37.7706920584128, -122.439915513203) | 15 | 5 | 11 | 29492 | 9 | |||
105323 | 251187 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000800 | 2109063 | 37.7711295786607 | -122.440609247553 | (37.7711295786607, -122.440609247553) | 15 | 5 | 11 | 29492 | 9 | ||||
116428 | 246228 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 5999452.5303 | 2107741.8948 | 37.7674253335335 | -122.445175180965 | (37.7674253335335, -122.445175180965) | 15 | 5 | 11 | 29492 | 9 | |||
120689 | 10523 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1855 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 5997295.7816 | 2108435.9791 | 37.7692077702137 | -122.452685140494 | (37.7692077702137, -122.452685140494) | 15 | 5 | 11 | 29492 | 9 | |||
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 |
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) );