trees
1,069 rows where qSpecies_id = 93 sorted by Neighborhoods (old)
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 | |||||||||||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
13703 | 40148 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
14684 | 246599 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 52 Waller St | 5 | : | Tree | Private 2 | 18 | Width 3ft | 6005448.39533 | 2109271.63735 | 37.7719660524162 | -122.42454510839 | (37.7719660524162, -122.42454510839) | 7 | 9 | 11 | 28852 | 10 | |||
28456 | 239669 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 89 Webster St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 6004261.58964 | 2108988.28216 | 37.7711209334157 | -122.428630156483 | (37.7711209334157, -122.428630156483) | 7 | 9 | 11 | 29492 | 10 | |||
36218 | 116694 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 536 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x4 | 6004835.97758 | 2110737.29191 | 37.7759557786585 | -122.426767902416 | (37.7759557786585, -122.426767902416) | 7 | 9 | 11 | 28852 | 10 | |||
44097 | 96379 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 531 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 10 | 3x3 | Permit Number 768930 | 6005269 | 2111284 | 37.7774813787572 | -122.425308876718 | (37.7774813787572, -122.425308876718) | 7 | 9 | 11 | 28852 | 10 | |
54587 | 246597 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 52 Waller St | 3 | : | Tree | Private 2 | 16 | Width 3ft | 6005485.46938 | 2109277.24468 | 37.7719835424264 | -122.42441726525 | (37.7719835424264, -122.42441726525) | 7 | 9 | 11 | 28852 | 10 | |||
54725 | 246598 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 52 Waller St | 4 | : | Tree | Private 2 | 20 | Width 3ft | 6005467.40356 | 2109274.31341 | 37.7719744736758 | -122.424479547814 | (37.7719744736758, -122.424479547814) | 7 | 9 | 11 | 28852 | 10 | |||
56958 | 10262 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 212 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005067.14002 | 2109566.55049 | 37.7727542742761 | -122.425884896112 | (37.7727542742761, -122.425884896112) | 7 | 9 | 11 | 28852 | 10 | |||
57986 | 40147 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
59824 | 40145 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
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 | |||
65135 | 246583 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98 Waller St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6005277.33485 | 2109248.26095 | 37.7718922045878 | -122.425135156289 | (37.7718922045878, -122.425135156289) | 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 | |||
86102 | 219588 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98x Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005256 | 2109297 | 37.7720248250001 | -122.42521242385 | (37.7720248250001, -122.42521242385) | 7 | 9 | 11 | 28852 | 10 | ||||
98734 | 246592 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 22 Waller St | 3 | : | Tree | Private 2 | 20 | Width 3ft | 6005574.15853 | 2109287.40717 | 37.7720164540359 | -122.42411120528 | (37.7720164540359, -122.42411120528) | 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 | ||
143267 | 116981 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 89 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004230 | 2108988 | 37.7711183708566 | -122.428739406059 | (37.7711183708566, -122.428739406059) | 7 | 9 | 11 | 29492 | 10 | |||||
143677 | 41343 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 340 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/25/2000 12:00:00 AM | Permit Number 41997 | 6003273.15240269 | 2109435.92669423 | 37.7722940667741 | -122.43208116562 | (37.7722940667741, -122.43208116562) | 15 | 9 | 11 | 29492 | 10 | ||
147782 | 240586 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 117 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 2 | Width 3ft | Permit Number 37769 | 6003553.87833 | 2108799.61563 | 37.770562824039 | -122.431064686005 | (37.770562824039, -122.431064686005) | 15 | 9 | 11 | 29492 | 10 | |
156764 | 40149 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
163269 | 239688 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 214 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005063.05276 | 2109561.17817 | 37.7727392922036 | -122.425898651924 | (37.7727392922036, -122.425898651924) | 7 | 9 | 11 | 28852 | 10 | |||
167002 | 48770 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2002 12:00:00 AM | 15 | 3x3 | Permit Number 46028 | 6005170.9549 | 2110973.7304 | 37.7766239145875 | -122.425625959395 | (37.7766239145875, -122.425625959395) | 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 | |||
175707 | 41649 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 450X Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2000 12:00:00 AM | Permit Number 42121 | 6000751.83853912 | 2110650.06591878 | 37.7754845196238 | -122.440889708326 | (37.7754845196238, -122.440889708326) | 15 | 5 | 11 | 29492 | 10 | |||
177367 | 6886 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 289X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5x6 | 6006058.26796 | 2110694.64672 | 37.7759077162141 | -122.422536644348 | (37.7759077162141, -122.422536644348) | 7 | 9 | 11 | 28852 | 10 | |||
7491 | 70152 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 231 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5993349.44748 | 2113931.04039 | 37.7840688184898 | -122.466734683653 | (37.7840688184898, -122.466734683653) | 11 | 6 | 2 | 54 | 11 | |||
11016 | 53933 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 144 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 17 | Permit Number 9647 | 5993062.86441 | 2114500.7791 | 37.7856166217584 | -122.467767599839 | (37.7856166217584, -122.467767599839) | 11 | 6 | 2 | 54 | 11 | ||
17372 | 2773 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 324 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 5994596.42955 | 2110789.71407 | 37.7755154642019 | -122.462192710849 | (37.7755154642019, -122.462192710849) | 11 | 6 | 2 | 54 | 11 | |||
17552 | 46597 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 170St. 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/09/2002 12:00:00 AM | 11 | Permit Number 44725 | 5993070.73118 | 2114361.72785 | 37.7852352793736 | -122.467730266741 | (37.7852352793736, -122.467730266741) | 11 | 6 | 2 | 54 | 11 | |
20507 | 2755 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 124 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5995208.65957 | 2110814.76075 | 37.7756194677712 | -122.460076689691 | (37.7756194677712, -122.460076689691) | 11 | 6 | 2 | 54 | 11 | |||
20607 | 123755 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 4ft | 5995425.06371 | 2110766.64717 | 37.7754998049095 | -122.459324614731 | (37.7754998049095, -122.459324614731) | 11 | 6 | 2 | 54 | 11 | |||
23373 | 53934 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 148 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1992 12:00:00 AM | 16 | Permit Number 30776 | 5993063.90435 | 2114472.77746 | 37.7855397969799 | -122.467761964704 | (37.7855397969799, -122.467761964704) | 11 | 6 | 2 | 54 | 11 | ||
23990 | 7135 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 336X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5994611.62343 | 2110790.08992 | 37.775517371009 | -122.462140179219 | (37.775517371009, -122.462140179219) | 11 | 6 | 2 | 54 | 11 | |||
26398 | 1631 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 20X Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5995606.71843 | 2110827.0926 | 37.7756762144924 | -122.458700608592 | (37.7756762144924, -122.458700608592) | 11 | 6 | 2 | 54 | 11 | |||
26919 | 2770 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 300 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5994656.76542 | 2110790.98006 | 37.7755224141133 | -122.461984087937 | (37.7755224141133, -122.461984087937) | 11 | 6 | 2 | 54 | 11 | |||
27239 | 56308 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 171 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1973 12:00:00 AM | 14 | 3x3 | Permit Number 12442 | 5993024.02697 | 2114355.61708 | 37.785215804041 | -122.467891402947 | (37.785215804041, -122.467891402947) | 11 | 6 | 2 | 54 | 11 | |
27973 | 2748 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 27 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5995513.49163 | 2110771.02145 | 37.7755168992008 | -122.459019040214 | (37.7755168992008, -122.459019040214) | 11 | 6 | 2 | 54 | 11 | |||
41322 | 21853 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 199X Cabrillo St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5995153.19322 | 2110756.08274 | 37.7754551631243 | -122.460264307742 | (37.7754551631243, -122.460264307742) | 11 | 6 | 2 | 54 | 11 | |||
41485 | 123746 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 5995436.31203 | 2110822.24381 | 37.7756531053071 | -122.459289731361 | (37.7756531053071, -122.459289731361) | 11 | 6 | 2 | 54 | 11 | |||
46553 | 123742 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5994695.24651 | 2110740.9683 | 37.7753873104579 | -122.461847346358 | (37.7753873104579, -122.461847346358) | 11 | 6 | 2 | 54 | 11 | |||
53692 | 2752 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 59 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5995436.711 | 2110737.12628 | 37.7754194179801 | -122.459282185974 | (37.7754194179801, -122.459282185974) | 11 | 6 | 2 | 54 | 11 | |||
54292 | 2774 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 325 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X6 | 5994591.7075 | 2110737.91873 | 37.7753729760761 | -122.462205288187 | (37.7753729760761, -122.462205288187) | 11 | 6 | 2 | 54 | 11 | |||
54813 | 43677 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 656 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 8 | Permit Number 43320 | 5995359.11762 | 2111077.33678 | 37.7763490847186 | -122.459575243791 | (37.7763490847186, -122.459575243791) | 11 | 6 | 2 | 54 | 11 | |
66304 | 123757 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 103 Cabrillo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5995251.69378 | 2110760.63793 | 37.7754733358801 | -122.459923903312 | (37.7754733358801, -122.459923903312) | 11 | 6 | 2 | 54 | 11 | |||
66614 | 123759 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 201 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2016 12:00:00 AM | 18 | Width 5ft | 5994972.58843 | 2110752.02511 | 37.7754336316323 | -122.460888764015 | (37.7754336316323, -122.460888764015) | 11 | 6 | 2 | 54 | 11 | ||
69290 | 2751 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 59 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5995436.711 | 2110737.12628 | 37.7754194179801 | -122.459282185974 | (37.7754194179801, -122.459282185974) | 11 | 6 | 2 | 54 | 11 | |||
72064 | 2791 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 451 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5994200.86487 | 2110721.92095 | 37.7753065385693 | -122.463556132466 | (37.7753065385693, -122.463556132466) | 11 | 6 | 2 | 54 | 11 | |||
75705 | 123754 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 4ft | 5995442.56449 | 2110764.47311 | 37.7754948416879 | -122.459263918278 | (37.7754948416879, -122.459263918278) | 11 | 6 | 2 | 54 | 11 | |||
80031 | 21857 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 215X Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4.5X4.5 | 5994989.01038 | 2110754.0886 | 37.7754402423317 | -122.460832106591 | (37.7754402423317, -122.460832106591) | 11 | 6 | 2 | 54 | 11 | |||
81264 | 123747 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 4ft | 5995457.51702 | 2110823.60741 | 37.7756580685065 | -122.459216477329 | (37.7756580685065, -122.459216477329) | 11 | 6 | 2 | 54 | 11 | |||
81850 | 1676 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/1991 12:00:00 AM | 12 | 3X3 | 5994751.99718 | 2111422.13569 | 37.7772608818646 | -122.461700433178 | (37.7772608818646, -122.461700433178) | 11 | 6 | 2 | 54 | 11 | ||
82674 | 123736 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 398 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5994542.01129 | 2110789.2592 | 37.7755110818004 | -122.462380922286 | (37.7755110818004, -122.462380922286) | 11 | 6 | 2 | 54 | 11 | |||
84871 | 123733 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 398 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5994463.58559 | 2110785.44478 | 37.7754960920711 | -122.462651936813 | (37.7754960920711, -122.462651936813) | 11 | 6 | 2 | 54 | 11 | |||
85062 | 87200 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 123 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 2 | 3x3 | 5995204.25641 | 2110758.61891 | 37.7754650638757 | -122.460087853041 | (37.7754650638757, -122.460087853041) | 11 | 6 | 2 | 54 | 11 | ||
93306 | 19297 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 40X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5995496.87098 | 2110852.98465 | 37.7757409930634 | -122.459082470822 | (37.7757409930634, -122.459082470822) | 11 | 6 | 2 | 54 | 11 | |||
93911 | 123698 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 198 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995066.49877 | 2111490.37862 | 37.7774663576481 | -122.460617425181 | (37.7774663576481, -122.460617425181) | 11 | 6 | 2 | 54 | 11 | |||
94455 | 46476 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 454 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2002 12:00:00 AM | 6 | Permit Number 44671 | 5991902.97979 | 2112323.35635 | 37.7795709761183 | -122.471621696685 | (37.7795709761183, -122.471621696685) | 11 | 6 | 2 | 54 | 11 |
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) );