trees
527 rows where SiteOrder = 1 and 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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |
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 | |||
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 | ||||
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 | |
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | ||
102954 | 2747 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 26 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5995511.83348 | 2110826.68765 | 37.7756696485776 | -122.459028807619 | (37.7756696485776, -122.459028807619) | 11 | 6 | 2 | 54 | 11 | |||
108178 | 12645 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 944 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5992509.49668 | 2114843.34604 | 37.7865252483142 | -122.469707022996 | (37.7865252483142, -122.469707022996) | 11 | 6 | 1 | 54 | 11 | |||
113228 | 123753 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 4ft | 5995463.5723 | 2110766.04178 | 37.7755003566036 | -122.459191361341 | (37.7755003566036, -122.459191361341) | 11 | 6 | 2 | 54 | 11 | |||
114687 | 123174 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 735 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5992855.85161 | 2110444.11138 | 37.7744661593712 | -122.468188588983 | (37.7744661593712, -122.468188588983) | 11 | 6 | 2 | 54 | 11 | |||
118409 | 124347 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 850 Balboa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 8ft | 5992970.95796 | 2111419.69143 | 37.7771514865391 | -122.467861389315 | (37.7771514865391, -122.467861389315) | 11 | 6 | 2 | 54 | 11 | |||
123586 | 68931 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 655 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 12 | Permit Number 32915 | 5992836.31623 | 2110994.2871 | 37.7759756654158 | -122.468296198193 | (37.7759756654158, -122.468296198193) | 11 | 6 | 2 | 54 | 11 | |
130875 | 19296 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 40X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5995496.87098 | 2110852.98465 | 37.7757409930634 | -122.459082470822 | (37.7757409930634, -122.459082470822) | 11 | 6 | 2 | 54 | 11 | |||
134266 | 43675 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 611 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 10 | Permit Number 43318 | 5995303.58271 | 2111376.81482 | 37.7771681785952 | -122.459789050934 | (37.7771681785952, -122.459789050934) | 11 | 6 | 2 | 54 | 11 | |
144377 | 2754 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 123 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3X3 | 5995213.94147 | 2110758.8179 | 37.7754661672939 | -122.460054364765 | (37.7754661672939, -122.460054364765) | 11 | 6 | 2 | 54 | 11 | |||
147944 | 2778 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 330 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3X3 | 5994563.22046 | 2110788.63831 | 37.7755105982792 | -122.462307510178 | (37.7755105982792, -122.462307510178) | 11 | 6 | 2 | 54 | 11 | |||
151423 | 123466 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 672 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995362.13932 | 2110969.47971 | 37.7760531114849 | -122.459556977451 | (37.7760531114849, -122.459556977451) | 11 | 6 | 2 | 54 | 11 | |||
152008 | 2749 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 59 Cabrillo St | 1 | 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 | |||
153954 | 52473 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 454@ ANZA Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | Permit Number 48584 | 5991906.61756296 | 2112344.10243716 | 37.7796281496591 | -122.471610624408 | (37.7796281496591, -122.471610624408) | 11 | 6 | 2 | 54 | 11 | ||
170135 | 43696 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1539 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 8 | Permit Number 43340 | 5993847.57781 | 2112069.22957 | 37.7789855246228 | -122.464876090912 | (37.7789855246228, -122.464876090912) | 11 | 6 | 2 | 54 | 11 | |
178644 | 2769 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 300 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5994681.18753 | 2110791.87373 | 37.7755262738923 | -122.461899671419 | (37.7755262738923, -122.461899671419) | 11 | 6 | 2 | 54 | 11 | |||
189564 | 43657 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 553 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 10 | Permit Number 43301 | 5992810.17 | 2111710.04136 | 37.7779394229571 | -122.468438730278 | (37.7779394229571, -122.468438730278) | 11 | 6 | 2 | 54 | 11 | |
39490 | 215006 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1315 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5995155.47354 | 2106606.49729 | 37.764061618685 | -122.459955752961 | (37.764061618685, -122.459955752961) | 15 | 5 | 11 | 56 | 12 | |||
62829 | 240524 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1023 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5997228.03932 | 2107019.29645 | 37.7653140406215 | -122.452817189965 | (37.7653140406215, -122.452817189965) | 15 | 5 | 11 | 29492 | 12 | |||
150991 | 239702 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 74 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5998481.13439 | 2105398.60241 | 37.7609357487984 | -122.448366326458 | (37.7609357487984, -122.448366326458) | 15 | 5 | 11 | 29492 | 12 | |||
155923 | 214172 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1370 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5992428.9422 | 2106122.35536 | 37.76257510589 | -122.469350698796 | (37.76257510589, -122.469350698796) | 1 | 8 | 11 | 56 | 12 | |||
168629 | 214171 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1337 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5994229.27069 | 2106420.50927 | 37.7634976322383 | -122.46314569683 | (37.7634976322383, -122.46314569683) | 1 | 5 | 11 | 56 | 12 | |||
102044 | 179480 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5989599 | 2090767 | 37.7202493457345 | -122.478015677124 | (37.7202493457345, -122.478015677124) | 1 | 8 | 4 | 64 | 14 | ||||
112112 | 66607 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 12 | Permit Number 29802 | 5989869.39246895 | 2090726.40504468 | 37.7201535727537 | -122.477078065149 | (37.7201535727537, -122.477078065149) | 1 | 8 | 4 | 64 | 14 | ||
140571 | 114382 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 402X SERRANO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
162222 | 179478 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989807.06872 | 2090726.39006 | 37.720149915678 | -122.477293493993 | (37.720149915678, -122.477293493993) | 1 | 8 | 4 | 64 | 14 | ||||
1337 | 27411 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2198 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5996975.1116 | 2109480.4382 | 37.7720572057802 | -122.453869751853 | (37.7720572057802, -122.453869751853) | 15 | 5 | 11 | 29492 | 16 | ||
4554 | 74167 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1801 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6000438.3175 | 2111300.5273 | 37.7772526604879 | -122.442020948646 | (37.7772526604879, -122.442020948646) | 15 | 5 | 11 | 29492 | 16 | |||
9615 | 70386 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1536 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6000423.3259 | 2110656.0694 | 37.7754822883832 | -122.442026539723 | (37.7754822883832, -122.442026539723) | 15 | 5 | 11 | 29492 | 16 | |||
14424 | 46330 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 548 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2002 12:00:00 AM | 11 | Permit Number 44580 | 5996909.4172 | 2109622.8664 | 37.7724445099575 | -122.454107281383 | (37.7724445099575, -122.454107281383) | 15 | 5 | 11 | 29492 | 16 | ||
41227 | 27410 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2184 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1999 12:00:00 AM | 8 | 3X3 | 5997011.7697 | 2109487.1799 | 37.7720778184275 | -122.453743436192 | (37.7720778184275, -122.453743436192) | 15 | 5 | 11 | 29492 | 16 | ||
46670 | 40143 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560X Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 2 | 3x3 | Permit Number 41343 | 5996910.70022428 | 2109465.35547876 | 37.7720120993682 | -122.454091465131 | (37.7720120993682, -122.454091465131) | 15 | 5 | 11 | 29492 | 16 | |
89839 | 40607 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2756 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/1999 12:00:00 AM | 9 | Permit Number 41618 | 5996431.87496 | 2111290.71055 | 37.7769965796048 | -122.45587972743 | (37.7769965796048, -122.45587972743) | 11 | 6 | 2 | 54 | 16 | ||
100799 | 14523 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 625 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 4x4 | 5999129.3058 | 2110654.1301 | 37.7754031370148 | -122.446502707181 | (37.7754031370148, -122.446502707181) | 15 | 5 | 11 | 29492 | 16 | |||
121336 | 80832 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3100 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.456929197984 | (37.7774658426, -122.456929197984) | 11 | 6 | 2 | 54 | 16 | |
146717 | 140664 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 536 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5996926.8557 | 2109499.2642 | 37.7721061302796 | -122.4540380318 | (37.7721061302796, -122.4540380318) | 15 | 5 | 11 | 29492 | 16 | |||
148297 | 27407 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2172 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5997059.3832 | 2109492.2362 | 37.7720944312961 | -122.453579103335 | (37.7720944312961, -122.453579103335) | 15 | 5 | 11 | 29492 | 16 | ||
164135 | 124456 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 41 Willard St North | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996112.49349 | 2111554.958 | 37.7777037980862 | -122.457003677962 | (37.7777037980862, -122.457003677962) | 11 | 6 | 2 | 54 | 16 | |||
173200 | 40640 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2740 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | 12 | Permit Number 41638 | 5996456.82543 | 2111294.67201 | 37.7770088886807 | -122.455793702985 | (37.7770088886807, -122.455793702985) | 11 | 6 | 2 | 54 | 16 | ||
179145 | 27408 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2178 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5997039.15745 | 2109490.68407 | 37.7720890100789 | -122.453648953362 | (37.7720890100789, -122.453648953362) | 15 | 5 | 11 | 29492 | 16 | ||
188347 | 140193 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2177 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997047.1638 | 2109490.1294 | 37.7720879460791 | -122.453621218845 | (37.7720879460791, -122.453621218845) | 15 | 5 | 11 | 29492 | 16 | |||
189982 | 46329 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 548 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2002 12:00:00 AM | 6 | Permit Number 44580 | 5996911.3335 | 2109610.2187 | 37.7724098925353 | -122.454099739112 | (37.7724098925353, -122.454099739112) | 15 | 5 | 11 | 29492 | 16 | ||
22630 | 59288 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2067 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1980 12:00:00 AM | 17 | Permit Number 18625 | 6003010.51633 | 2119230.45541 | 37.7991724689015 | -122.433689789967 | (37.7991724689015, -122.433689789967) | 13 | 9 | 1 | 57 | 17 | ||
61164 | 57496 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2090 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1988 12:00:00 AM | 15 | Permit Number 25529 | 6003581.68174 | 2117969.32312 | 37.7957421173574 | -122.431623277394 | (37.7957421173574, -122.431623277394) | 13 | 9 | 1 | 57 | 17 | ||
67130 | 23587 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3251X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.425855144407 | (37.8066799978444, -122.425855144407) | 13 | 1 | 1 | 28858 | 17 | |||
82261 | 68986 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1990 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 18 | Permit Number 32976 | 5999758.99431 | 2121250.9256 | 37.8045351046614 | -122.44508646209 | (37.8045351046614, -122.44508646209) | 13 | 9 | 1 | 57 | 17 | |
128300 | 40086 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1667 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/1999 12:00:00 AM | 9 | Permit Number 41307 | 6005062.9841 | 2118469.14548 | 37.7971983526666 | -122.426533306168 | (37.7971983526666, -122.426533306168) | 13 | 9 | 1 | 57 | 17 | ||
144095 | 68014 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3400 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1993 12:00:00 AM | 1 | Permit Number 31744 | 5999283.32146 | 2120515.04352 | 37.8024874104189 | -122.446679585917 | (37.8024874104189, -122.446679585917) | 13 | 9 | 1 | 57 | 17 | ||
194298 | 262528 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3400 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | 6003691 | 2120547 | 37.8028259466608 | -122.431429119577 | (37.8028259466608, -122.431429119577) | 13 | 9 | 1 | 57 | 17 | ||
14741 | 33010 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3622 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42195 | 6005636.60974519 | 2102002.04320044 | 37.7520160884207 | -122.423377179853 | (37.7520160884207, -122.423377179853) | 2 | 4 | 5 | 28859 | 19 | ||
25673 | 4159 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3736-3738 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1989 12:00:00 AM | 23 | 3X3 | 6005622.07663 | 2100534.07243 | 37.7479845580381 | -122.4233230934 | (37.7479845580381, -122.4233230934) | 2 | 4 | 5 | 28859 | 19 | ||
27845 | 5359 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 233 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6004883.71893 | 2107010.19311 | 37.7657247654982 | -122.426337327709 | (37.7657247654982, -122.426337327709) | 8 | 4 | 5 | 28853 | 19 | |||
34589 | 5333 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 135 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6004851.68413 | 2107592.33342 | 37.7673213724137 | -122.426489583844 | (37.7673213724137, -122.426489583844) | 8 | 4 | 5 | 28862 | 19 | |||
50254 | 239671 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 761 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6005055.20153 | 2103892.32562 | 37.7571735312626 | -122.425522291914 | (37.7571735312626, -122.425522291914) | 2 | 4 | 5 | 28859 | 19 | |||
65095 | 101807 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 733 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 19463 | 6008567.7 | 2104253 | 37.7583616995478 | -122.413400180344 | (37.7583616995478, -122.413400180344) | 2 | 4 | 7 | 28859 | 19 | ||||
70797 | 239676 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1356 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010842.92295 | 2102014.50671 | 37.7523427770036 | -122.405373771977 | (37.7523427770036, -122.405373771977) | 10 | 4 | 8 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );