trees
1,069 rows where qSpecies_id = 93 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2386 | 19745 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 STAIRWAY15 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
18752 | 51349 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 6401 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2004 12:00:00 AM | Permit Number 47697 | |||||||||||||
160392 | 122800 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1223 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6017230.3941 | 2093111.7012 | 37.7282525286375 | -122.382665199331 | (37.7282525286375, -122.382665199331) | 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 | ||||
156854 | 197578 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 299x Cashmere St | 6 | Median : Yard | Tree | DPW 1 | 7 | 6016803.94707 | 2095896.67464 | 37.7358759448203 | -122.384333341329 | (37.7358759448203, -122.384333341329) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
143778 | 200679 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6015689.2638 | 2095313.8362 | 37.7342138898064 | -122.388146614226 | (37.7342138898064, -122.388146614226) | 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 | |||
163642 | 200677 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015676.0731 | 2095323.7293 | 37.7342403234109 | -122.388192909274 | (37.7342403234109, -122.388192909274) | 10 | 3 | 8 | 58 | 1 | |||
126956 | 94034 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1300X Lane St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x3 | 6015674.4242 | 2095246.7836 | 37.7340289546749 | -122.388193241926 | (37.7340289546749, -122.388193241926) | 10 | 3 | 8 | 58 | 1 | ||
106354 | 200678 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015671.6762 | 2095312.1874 | 37.7342083880601 | -122.388207305661 | (37.7342083880601, -122.388207305661) | 10 | 3 | 8 | 58 | 1 | |||
108079 | 200675 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015661.7831 | 2095333.6223 | 37.7342666958117 | -122.388243005014 | (37.7342666958117, -122.388243005014) | 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 | |||
172859 | 200674 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6015639.7987 | 2095348.4618 | 37.7343062239298 | -122.388320048161 | (37.7343062239298, -122.388320048161) | 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 | |||
149532 | 16559 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 702X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015638.3263 | 2097400.20162 | 37.7399398030878 | -122.388468300865 | (37.7399398030878, -122.388468300865) | 10 | 3 | 8 | 58 | 1 | |||
169480 | 200672 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015595.8297 | 2095380.8889 | 37.7343928257308 | -122.388474327143 | (37.7343928257308, -122.388474327143) | 10 | 3 | 8 | 58 | 1 | |||
149818 | 22178 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3950X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015635.4577 | 2097953.7776 | 37.7414596503706 | -122.38851684959 | (37.7414596503706, -122.38851684959) | 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 | |||
189391 | 22196 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4049 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015606.879 | 2097560.5249 | 37.7403782752921 | -122.38858822178 | (37.7403782752921, -122.38858822178) | 10 | 3 | 8 | 58 | 1 | |||
141666 | 26133 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1504 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 5x5 | 6015522.1816 | 2095153.8991 | 37.7337654760523 | -122.388713114387 | (37.7337654760523, -122.388713114387) | 10 | 3 | 8 | 58 | 1 | |||
84712 | 16562 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 700X Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015552.29216 | 2097280.01448 | 37.7396050257983 | -122.388757385673 | (37.7396050257983, -122.388757385673) | 10 | 3 | 8 | 58 | 1 | |||
145312 | 98611 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1537 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6015388.0762 | 2094133.544 | 37.730956353088 | -122.389105540873 | (37.730956353088, -122.389105540873) | 10 | 3 | 8 | 58 | 1 | |||
60920 | 98610 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1537 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 6015377.6336 | 2094141.2385 | 37.7309769017577 | -122.389142180051 | (37.7309769017577, -122.389142180051) | 10 | 3 | 8 | 58 | 1 | |||
133863 | 200066 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1563 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6015094.0337 | 2094004.9347 | 37.7305869134552 | -122.390113122096 | (37.7305869134552, -122.390113122096) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||||
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 | ||||||
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 | |||
152092 | 50629 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.7203756614272 | -122.39176255443 | (37.7203756614272, -122.39176255443) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||||
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 | ||||
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 | |||||
162517 | 104734 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 5490x 03RD ST | 1 | Median : Cutout | Tree | DPW 1 | 40 | 9x9 | 6014203 | 2093127 | 37.7281268221954 | -122.393132175736 | (37.7281268221954, -122.393132175736) | 10 | 3 | 8 | 58 | 1 | |||
177148 | 22364 | Landmark tree 11 | Schinus terebinthifolius :: Brazilian Pepper 93 | 5490X 03rd St | 1 | Median : Cutout | Tree | DPW 1 | 48 | 40TR | 6014151.6099 | 2093070.9929 | 37.7279701830365 | -122.393305916851 | (37.7279701830365, -122.393305916851) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
152373 | 197576 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1121 Jamestown Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6013293.0543 | 2090118.55817 | 37.7198156565414 | -122.396067168381 | (37.7198156565414, -122.396067168381) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
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 | ||||
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 | |||
68428 | 113589 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6013618.31729 | 2118086.59987 | 37.7966279046102 | -122.396902670038 | (37.7966279046102, -122.396902670038) | 3 | 1 | 10 | 28860 | 6 | |||
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 | ||
90697 | 117571 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 DRUMM ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013616 | 2118213 | 37.7969748404412 | -122.396919555024 | (37.7969748404412, -122.396919555024) | 3 | 1 | 10 | 28860 | 6 | ||||
36115 | 113591 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6013610.58042 | 2118128.2339 | 37.796741791142 | -122.396932362048 | (37.796741791142, -122.396932362048) | 3 | 1 | 10 | 28860 | 6 | |||
18254 | 113592 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6013608.47765 | 2118139.13549 | 37.7967716072789 | -122.396940402888 | (37.7967716072789, -122.396940402888) | 3 | 1 | 10 | 28860 | 6 | |||
26984 | 113593 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6013606.07873 | 2118153.06914 | 37.7968097322489 | -122.396949681183 | (37.7968097322489, -122.396949681183) | 3 | 1 | 10 | 28860 | 6 | |||
74582 | 113594 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6013595.86878 | 2118231.42432 | 37.7970243086769 | -122.396990506826 | (37.7970243086769, -122.396990506826) | 3 | 1 | 10 | 28860 | 6 | |||
128505 | 113595 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 2 | 3x3 | 6013594.82153 | 2118250.31526 | 37.7970761204252 | -122.396995455792 | (37.7970761204252, -122.396995455792) | 3 | 1 | 10 | 28860 | 6 | ||
16930 | 113596 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6013590.96742 | 2118268.55465 | 37.7971259869262 | -122.397010071555 | (37.7971259869262, -122.397010071555) | 3 | 1 | 10 | 28860 | 6 | |||
155471 | 113597 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6013588.4505 | 2118285.15352 | 37.7971714233818 | -122.397019945211 | (37.7971714233818, -122.397019945211) | 3 | 1 | 10 | 28860 | 6 | |||
161176 | 136427 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6013551.14952 | 2118058.04 | 37.796545747032 | -122.397133083548 | (37.796545747032, -122.397133083548) | 3 | 1 | 10 | 28860 | 6 | |||
184744 | 136426 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6013550.70975 | 2118074.47295 | 37.7965908435385 | -122.397135758112 | (37.7965908435385, -122.397135758112) | 3 | 1 | 10 | 28860 | 6 | |||
159144 | 136425 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6013547.46214 | 2118092.2461 | 37.7966394636056 | -122.397148242524 | (37.7966394636056, -122.397148242524) | 3 | 1 | 10 | 28860 | 6 | |||
50434 | 136424 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6013541.7115 | 2118113.66267 | 37.7966979482953 | -122.397169643672 | (37.7966979482953, -122.397169643672) | 3 | 1 | 10 | 28860 | 6 | |||
51848 | 136423 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6013540.78751 | 2118131.64516 | 37.7967472725126 | -122.397174102497 | (37.7967472725126, -122.397174102497) | 3 | 1 | 10 | 28860 | 6 | |||
38948 | 136422 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6013539.98314 | 2118153.18221 | 37.7968063633679 | -122.397178396789 | (37.7968063633679, -122.397178396789) | 3 | 1 | 10 | 28860 | 6 | |||
127434 | 136421 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6013535.0626 | 2118179.75007 | 37.7968790384839 | -122.39719728705 | (37.7968790384839, -122.39719728705) | 3 | 1 | 10 | 28860 | 6 | |||
190938 | 136420 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6013531.80462 | 2118197.00986 | 37.7969262483997 | -122.397209771417 | (37.7969262483997, -122.397209771417) | 3 | 1 | 10 | 28860 | 6 | |||
118392 | 136419 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6013531.07074 | 2118211.65227 | 37.7969664121295 | -122.397213338118 | (37.7969664121295, -122.397213338118) | 3 | 1 | 10 | 28860 | 6 | |||
10659 | 136418 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6013527.00347 | 2118227.13229 | 37.797008690162 | -122.397228498003 | (37.797008690162, -122.397228498003) | 3 | 1 | 10 | 28860 | 6 | |||
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 | |||
23104 | 136416 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6013522.99602 | 2118258.2651 | 37.797093950371 | -122.397244549101 | (37.797093950371, -122.397244549101) | 3 | 1 | 10 | 28860 | 6 | |||
84700 | 197537 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 266 Bridgeview Dr | 1 | : | Tree | Private 2 | 10 | Width 2ft | 6012934.68235 | 2095259.36475 | 37.7339113173389 | -122.397666323936 | (37.7339113173389, -122.397666323936) | 10 | 3 | 8 | 58 | 1 | |||
31221 | 136411 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
84021 | 49096 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 550 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2003 12:00:00 AM | 3 | Permit Number 46244 | 6013227.23366 | 2118310.02974 | 37.7972196135456 | -122.398271600054 | (37.7972196135456, -122.398271600054) | 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 | |||
46666 | 136413 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 550 Davis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013222.1695 | 2118341.72349 | 37.7973063549552 | -122.398291348284 | (37.7973063549552, -122.398291348284) | 3 | 1 | 10 | 28860 | 6 | |||
48487 | 136414 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 640 Davis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013178.6157 | 2118647.51257 | 37.7981435527405 | -122.398463524392 | (37.7981435527405, -122.398463524392) | 3 | 1 | 10 | 28860 | 6 |
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) );