trees
1,069 rows where qSpecies_id = 93 sorted by qAddress descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
191088 | 179469 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 750 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6002474.00901 | 2089177.35967 | 37.7166234427928 | -122.433397545354 | (37.7166234427928, -122.433397545354) | 9 | 7 | 6 | 28861 | 5 | |||
119678 | 215005 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 75 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995603.15885 | 2090386.73113 | 37.7195518880809 | -122.457233926015 | (37.7195518880809, -122.457233926015) | 9 | 8 | 6 | 28861 | 24 | |||
43720 | 240588 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 74 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004274.45467 | 2097751.30027 | 37.7402675564928 | -122.427784866605 | (37.7402675564928, -122.427784866605) | 2 | 7 | 5 | 63 | 7 | |||
115157 | 34444 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 74 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38188 | 6004269.61043081 | 2097757.70943651 | 37.7402848805672 | -122.427802072604 | (37.7402848805672, -122.427802072604) | 2 | 7 | 5 | 63 | 7 | ||
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 | |||
162241 | 62350 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 74 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22493 | 6005428.10472053 | 2099649.51598417 | 37.7455448191665 | -122.423930949775 | (37.7455448191665, -122.423930949775) | 2 | 7 | 5 | 28859 | 22 | ||
23977 | 101872 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6012644.6557 | 2113099.5202 | 37.782880312512 | -122.39992139618 | (37.782880312512, -122.39992139618) | 6 | 2 | 9 | 28856 | 34 | |||
27413 | 101870 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779151 | 6012595.5925 | 2113052.7427 | 37.7827491368943 | -122.400087849303 | (37.7827491368943, -122.400087849303) | 6 | 2 | 9 | 28856 | 34 | |
101372 | 101867 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769242 | 6012649.1 | 2113074.7 | 37.7828124097662 | -122.399904277178 | (37.7828124097662, -122.399904277178) | 6 | 2 | 9 | 28856 | 34 | |
112260 | 101869 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6012583.9023 | 2113041.0524 | 37.7827163862355 | -122.400127471434 | (37.7827163862355, -122.400127471434) | 6 | 2 | 9 | 28856 | 34 | |||
117285 | 101868 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2014 12:00:00 AM | 6 | 3x3 | Permit Number 771222 | 6012702 | 2113175 | 37.7830907593936 | -122.399728309071 | (37.7830907593936, -122.399728309071) | 6 | 2 | 9 | 28856 | 34 | |
155354 | 101871 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6012623.9262 | 2113078.7907 | 37.7828222383966 | -122.399991655868 | (37.7828222383966, -122.399991655868) | 6 | 2 | 9 | 28856 | 34 | |||
8923 | 81053 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 735 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6002545.69492 | 2089214.07107 | 37.7167283109449 | -122.433152384794 | (37.7167283109449, -122.433152384794) | 9 | 7 | 6 | 28861 | 5 | |||
80210 | 114872 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 735 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6002556.26502 | 2089229.80958 | 37.7167721250182 | -122.433116973091 | (37.7167721250182, -122.433116973091) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | |||
96467 | 117877 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 734 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5983242.29307 | 2110782.48705 | 37.7748353295228 | -122.501468223794 | (37.7748353295228, -122.501468223794) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||||
177335 | 239677 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 733 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008549.23323 | 2104225.32004 | 37.7582846598211 | -122.413462089219 | (37.7582846598211, -122.413462089219) | 2 | 4 | 7 | 28859 | 19 | |||
83824 | 240593 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 73 Digby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002622.32078 | 2097674.93204 | 37.7399642691366 | -122.433491822189 | (37.7399642691366, -122.433491822189) | 2 | 7 | 5 | 63 | 7 | |||
193921 | 62259 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 73 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | 9 | Permit Number 22385 | 6001393.61197 | 2093758.63795 | 37.7291412430561 | -122.437459807321 | (37.7291412430561, -122.437459807321) | 9 | 7 | 6 | 28861 | 25 | |
7605 | 240540 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 72 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6005500 | 2099675 | 37.7456188511036 | -122.423684158346 | (37.7456188511036, -122.423684158346) | 2 | 7 | 5 | 28859 | 22 | |||
19784 | 240541 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 72 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6005497.38826 | 2099648.86664 | 37.7455469474293 | -122.423691331589 | (37.7455469474293, -122.423691331589) | 2 | 7 | 5 | 28859 | 22 | |||
4246 | 67958 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 719 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 11 | Permit Number 31678 | 5987220.95005 | 2111007.3016 | 37.7756854718616 | -122.48772192034 | (37.7756854718616, -122.48772192034) | 11 | 6 | 2 | 55 | 26 | |
49058 | 105202 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 708 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x6 | 5984164.05462 | 2110996.44068 | 37.7754768768809 | -122.49829551345 | (37.7754768768809, -122.49829551345) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
114350 | 117921 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 701 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5983188.84619 | 2110935.7089 | 37.7752528931729 | -122.501664442808 | (37.7752528931729, -122.501664442808) | 11 | 6 | 2 | 55 | 26 | |||
6553 | 75600 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 701 38th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5984118.61972 | 2110981.94357 | 37.7754344077107 | -122.498451610106 | (37.7754344077107, -122.498451610106) | 11 | 6 | 2 | 55 | 26 | |||
14668 | 75472 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 701 38th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5984118.82642 | 2110932.36992 | 37.7752983048778 | -122.498447232603 | (37.7752983048778, -122.498447232603) | 11 | 6 | 2 | 55 | 26 | |||
15630 | 75661 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 701 38th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5984119.5345 | 2111005.02849 | 37.7754978458904 | -122.498450151227 | (37.7754978458904, -122.498450151227) | 11 | 6 | 2 | 55 | 26 | |||
16140 | 75536 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 701 38th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5984118.85326 | 2110953.37322 | 37.7753559754601 | -122.498448691476 | (37.7753559754601, -122.498448691476) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
59617 | 5486 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 700X Dolores St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/28/2008 12:00:00 AM | 12 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | 2 | 4 | 5 | 28862 | 3 | ||
81183 | 5484 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 700X Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 35 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||||
28780 | 118224 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5984451.82255 | 2111562.02768 | 37.7770466856492 | -122.497341833187 | (37.7770466856492, -122.497341833187) | 11 | 6 | 2 | 55 | 26 | |||
40555 | 118221 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5984455.23409 | 2111482.21189 | 37.7768277344481 | -122.497324138201 | (37.7768277344481, -122.497324138201) | 11 | 6 | 2 | 55 | 26 | |||
68701 | 118228 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5984449.814 | 2111641.46186 | 37.7772646712772 | -122.49735464678 | (37.7772646712772, -122.49735464678) | 11 | 6 | 2 | 55 | 26 | |||
75592 | 118225 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5984452.24227 | 2111581.69085 | 37.7771006996432 | -122.497341833206 | (37.7771006996432, -122.497341833206) | 11 | 6 | 2 | 55 | 26 | |||
90912 | 118222 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5984454.40833 | 2111501.37469 | 37.7768803015762 | -122.497328409687 | (37.7768803015762, -122.497328409687) | 11 | 6 | 2 | 55 | 26 | |||
97376 | 118223 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5984452.77979 | 2111524.24348 | 37.7769429972336 | -122.49733573185 | (37.7769429972336, -122.49733573185) | 11 | 6 | 2 | 55 | 26 | |||
111694 | 118227 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5984452.03524 | 2111621.56677 | 37.7772101752848 | -122.497345493843 | (37.7772101752848, -122.497345493843) | 11 | 6 | 2 | 55 | 26 | |||
123732 | 118217 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5984459.3393 | 2111410.10949 | 37.776630002637 | -122.497304613296 | (37.776630002637, -122.497304613296) | 11 | 6 | 2 | 55 | 26 | |||
148787 | 118226 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5984451.57804 | 2111600.14779 | 37.7771513381474 | -122.497345493825 | (37.7771513381474, -122.497345493825) | 11 | 6 | 2 | 55 | 26 | |||
172567 | 118220 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5984456.55861 | 2111461.63296 | 37.7767713082661 | -122.497318036821 | (37.7767713082661, -122.497318036821) | 11 | 6 | 2 | 55 | 26 | |||
54468 | 5480 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 695 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 8 | 6005032.86911 | 2104338.69015 | 37.7583978815122 | -122.425631294213 | (37.7583978815122, -122.425631294213) | 2 | 4 | 5 | 28859 | 19 | |||
151126 | 239675 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 689 Dolores St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 9ft | 6005030.3991 | 2104342.90235 | 37.7584093076526 | -122.425640136401 | (37.7584093076526, -122.425640136401) | 2 | 4 | 5 | 28859 | 19 | |||
158163 | 803 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 680X 39th Ave | 1 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983825.76498 | 2111129.60729 | 37.7758226717015 | -122.499475562851 | (37.7758226717015, -122.499475562851) | 11 | 6 | 2 | 55 | 26 | |||
192936 | 805 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 680X 39th Ave | 3 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983823.96426 | 2111160.91126 | 37.7759085177004 | -122.499484105844 | (37.7759085177004, -122.499484105844) | 11 | 6 | 2 | 55 | 26 | |||
90659 | 118237 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 680 38th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 5984156.56832 | 2111248.83134 | 37.7761694298689 | -122.498340055521 | (37.7761694298689, -122.498340055521) | 11 | 6 | 2 | 55 | 26 | |||
116743 | 118236 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 680 38th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 5984154.15255 | 2111259.59719 | 37.7761988481286 | -122.498349207541 | (37.7761988481286, -122.498349207541) | 11 | 6 | 2 | 55 | 26 | |||
157646 | 35120 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 679 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 11 | Permit Number 38655 | 6001477.30735 | 2089545.09865 | 37.7175765748797 | -122.436868949145 | (37.7175765748797, -122.436868949145) | 9 | 7 | 6 | 28861 | 5 | |
171544 | 240574 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 676 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003010.11937 | 2104332.09959 | 37.7582652812248 | -122.432626383021 | (37.7582652812248, -122.432626383021) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
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 | |||
20356 | 39764 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 670 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41130 | 6003007.22096458 | 2104433.1722566 | 37.7585426381862 | -122.432643626683 | (37.7585426381862, -122.432643626683) | 2 | 4 | 5 | 28862 | 3 | ||
182071 | 240573 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 670 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003005.75377 | 2104417.09042 | 37.7584983981093 | -122.432647552151 | (37.7584983981093, -122.432647552151) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |
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 | |
190567 | 53817 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50398 | 5992946.10042753 | 2094372.20791552 | 37.730342070192 | -122.466707885488 | (37.730342070192, -122.466707885488) | 9 | 8 | 4 | 59 | 40 | ||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
167833 | 44448 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 6 | Permit Number 43777 | 6002641.71413 | 2086935.0699 | 37.7104761197367 | -122.432657792736 | (37.7104761197367, -122.432657792736) | 9 | 7 | 6 | 28861 | 5 | |
149651 | 239704 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998299.05202 | 2105978.64919 | 37.7625179998246 | -122.449037852934 | (37.7625179998246, -122.449037852934) | 15 | 5 | 11 | 29492 | 9 | |||
63033 | 179440 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Blythdale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6007040.38457 | 2086896.48953 | 37.7106186631909 | -122.417452275027 | (37.7106186631909, -122.417452275027) | 9 | 7 | 8 | 309 | 39 | |||
126536 | 179439 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006794.78813 | 2086912.99237 | 37.7106501547416 | -122.418302281839 | (37.7106501547416, -122.418302281839) | 9 | 7 | 8 | 309 | 39 | |||
153889 | 179441 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6007125.21698 | 2086870.4635 | 37.7105519739575 | -122.417157231746 | (37.7105519739575, -122.417157231746) | 9 | 7 | 8 | 309 | 39 | |||
38500 | 50055 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 646 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46785 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341 | (37.7605408596837, -122.42837316341) | 2 | 4 | 5 | 28862 | 3 | |||
85310 | 50056 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 646 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46785 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341 | (37.7605408596837, -122.42837316341) | 2 | 4 | 5 | 28862 | 3 | |||
85248 | 69541 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 643 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38636 | 6002429.0315791 | 2090033.16165602 | 37.7189707335787 | -122.43361413687 | (37.7189707335787, -122.43361413687) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||||||||||||
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 | |||
133626 | 136415 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 640 Davis St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013156.852 | 2118810.40691 | 37.7985896092893 | -122.398550270302 | (37.7985896092893, -122.398550270302) | 3 | 1 | 10 | 28860 | 6 | |||
165324 | 120320 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 640 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5988820.50243 | 2110953.12943 | 37.7756298975626 | -122.482184767826 | (37.7756298975626, -122.482184767826) | 11 | 6 | 2 | 55 | 26 | |||
118681 | 239723 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 639 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6002256.27904 | 2102059.77272 | 37.7519832361373 | -122.435070970552 | (37.7519832361373, -122.435070970552) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
123357 | 239728 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 625 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002499.54698 | 2099729.30316 | 37.745598126946 | -122.434063139918 | (37.745598126946, -122.434063139918) | 2 | 7 | 5 | 63 | 22 | |||
134601 | 239727 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 625 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002467.60091 | 2099728.10934 | 37.7455930359069 | -122.434173519104 | (37.7455930359069, -122.434173519104) | 2 | 7 | 5 | 63 | 22 | |||
135640 | 66524 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 625 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30334 | 6002498.75858532 | 2099723.40130775 | 37.7455818770993 | -122.434065444251 | (37.7455818770993, -122.434065444251) | 2 | 7 | 5 | 63 | 22 | ||
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 | |
106799 | 62237 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 61 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | Permit Number 22363 | 6001374.44401127 | 2093790.00837779 | 37.7292262892939 | -122.437528318003 | (37.7292262892939, -122.437528318003) | 9 | 7 | 6 | 28861 | 25 | ||
92069 | 239729 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 601 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002586.38248 | 2099734.9254 | 37.745618492099 | -122.433763278079 | (37.745618492099, -122.433763278079) | 2 | 7 | 5 | 63 | 22 | |||
140384 | 96985 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 601 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6x7 | 5991261.14283 | 2111266.80131 | 37.7766328115191 | -122.473764965551 | (37.7766328115191, -122.473764965551) | 11 | 6 | 2 | 54 | 26 | |||
164587 | 117839 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 600x 39th Ave | 3 | Median : Cutout | Tree | DPW 1 | 15 | Width 6ft | 5983810.52385 | 2111649.02031 | 37.7772479352498 | -122.499566680778 | (37.7772479352498, -122.499566680778) | 11 | 6 | 2 | 55 | 26 | |||
58886 | 807 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 600X 39th Ave | 5 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983808.20604 | 2111664.13118 | 37.7772892893219 | -122.499575815745 | (37.7772892893219, -122.499575815745) | 11 | 6 | 2 | 55 | 26 | |||
131494 | 24342 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 600X 39th Ave | 14 | Median : Cutout | Tree | DPW 1 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | 11 | 6 | 2 | 55 | 26 | |||
178216 | 814 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 600X 39th Ave | 12 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | 11 | 6 | 2 | 55 | 26 | |||
94787 | 240583 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 60 Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000828.16342 | 2106033.71202 | 37.7628135098535 | -122.440294550454 | (37.7628135098535, -122.440294550454) | 15 | 5 | 5 | 28862 | 3 | |||
23898 | 35110 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1998 12:00:00 AM | Permit Number 40572 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
31895 | 35112 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
94617 | 38649 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1998 12:00:00 AM | Permit Number 40572 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
165237 | 35113 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
166144 | 35111 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
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 |
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) );