trees
182 rows where SiteOrder = 2 and qSpecies_id = 93 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
162504 | 179476 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 245 Wilson St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5994306.08107 | 2086649.96822 | 37.7092170428021 | -122.461446662549 | (37.7092170428021, -122.461446662549) | 9 | 8 | 6 | 28861 | 25 | ||||
1203 | 179432 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6006549.42501 | 2086808.72834 | 37.7103500527955 | -122.419142922204 | (37.7103500527955, -122.419142922204) | 9 | 7 | 8 | 309 | 39 | |||
152421 | 179430 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 241 Blythdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006173.52059 | 2087002.57891 | 37.7108611491941 | -122.420455879341 | (37.7108611491941, -122.420455879341) | 9 | 7 | 8 | 309 | 39 | |||
186974 | 179491 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 117 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002422.82198 | 2087024.8993 | 37.7107103553801 | -122.433420745181 | (37.7107103553801, -122.433420745181) | 9 | 7 | 6 | 28861 | 5 | |||
68847 | 179445 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 50 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006641.641 | 2087043.64286 | 37.7110002716098 | -122.418840853438 | (37.7110002716098, -122.418840853438) | 9 | 7 | 8 | 309 | 39 | |||
156434 | 179492 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 781 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6002448.84708 | 2087107.83027 | 37.7109395422009 | -122.433336718839 | (37.7109395422009, -122.433336718839) | 9 | 7 | 6 | 28861 | 5 | |||
20941 | 179443 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 20 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6006639.5983 | 2087274.41681 | 37.7116338134302 | -122.418864269997 | (37.7116338134302, -122.418864269997) | 9 | 7 | 8 | 309 | 39 | |||
23628 | 179425 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006737.87137 | 2087492.25298 | 37.7122374788398 | -122.418540048182 | (37.7122374788398, -122.418540048182) | 9 | 7 | 8 | 309 | 39 | |||
162846 | 179453 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1657 Sunnydale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6006878.87058 | 2087495.95749 | 37.7122555876031 | -122.418052974468 | (37.7122555876031, -122.418052974468) | 9 | 7 | 8 | 309 | 39 | |||
7566 | 264756 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 176 Hahn St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
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 | ||||
172022 | 35126 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 766 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 7 | Permit Number 38660 | 6001721.91154 | 2089504.55342 | 37.7174791459225 | -122.43602056561 | (37.7174791459225, -122.43602056561) | 9 | 7 | 6 | 28861 | 5 | |
157153 | 179460 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6000997.30077 | 2089688.71555 | 37.7179436214658 | -122.438538393947 | (37.7179436214658, -122.438538393947) | 9 | 7 | 6 | 28861 | 5 | |||
167640 | 179462 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 90 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000856.84082 | 2089774.26479 | 37.7181705294179 | -122.43903002902 | (37.7181705294179, -122.43903002902) | 9 | 7 | 6 | 28861 | 5 | |||
102339 | 179465 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 291 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6001702.1853 | 2090068.84403 | 37.7190274412447 | -122.436129108381 | (37.7190274412447, -122.436129108381) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||
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 | |||
176933 | 179484 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5988536.49014 | 2090373.27915 | 37.7191065591004 | -122.481659555971 | (37.7191065591004, -122.481659555971) | 1 | 8 | 4 | 64 | 14 | ||||
127628 | 179481 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988902.49405 | 2090393.59661 | 37.7191836220039 | -122.480395922129 | (37.7191836220039, -122.480395922129) | 1 | 8 | 4 | 64 | 14 | ||||
22787 | 215004 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 240 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5996022.14356 | 2090574.20231 | 37.7200906944015 | -122.455799201591 | (37.7200906944015, -122.455799201591) | 9 | 8 | 6 | 28861 | 24 | |||
163290 | 114214 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 230 SERRANO DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5988981 | 2090766 | 37.7202107101289 | -122.480151800691 | (37.7202107101289, -122.480151800691) | 1 | 8 | 4 | 64 | 14 | ||||
32927 | 179473 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 890 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011506.9921 | 2090808.93918 | 37.7216117663527 | -122.402289508352 | (37.7216117663527, -122.402289508352) | 10 | 3 | 7 | 309 | 28 | |||
103624 | 214999 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 325 Holloway Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995798.02713 | 2091198.56158 | 37.7217921721658 | -122.456619019966 | (37.7217921721658, -122.456619019966) | 9 | 8 | 6 | 28861 | 24 | |||
38007 | 217714 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1199 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5996346.1405 | 2091806.7339 | 37.7234935241877 | -122.454768263296 | (37.7234935241877, -122.454768263296) | 9 | 8 | 4 | 28861 | 24 | |||
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 | ||||
15213 | 78534 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 240 Wayland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6010805.45879 | 2092437.25464 | 37.7260435984308 | -122.404829115572 | (37.7260435984308, -122.404829115572) | 10 | 3 | 7 | 309 | 28 | |||
93273 | 179485 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6001441.34691 | 2093639.06415 | 37.7288156345119 | -122.437286225591 | (37.7288156345119, -122.437286225591) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
181030 | 214189 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 364 San Benito Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992760.98003 | 2094267.65253 | 37.7300443017829 | -122.46734026706 | (37.7300443017829, -122.46734026706) | 9 | 8 | 4 | 59 | 40 | |||
158494 | 108586 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 38 Goettingen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009809 | 2094307 | 37.7311217764568 | -122.408405653048 | (37.7311217764568, -122.408405653048) | 10 | 3 | 7 | 309 | 28 | ||||
49445 | 214195 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 333 San Benito Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5992867.77854 | 2094524.25297 | 37.7307550279091 | -122.466989702314 | (37.7307550279091, -122.466989702314) | 9 | 8 | 4 | 59 | 40 | |||
6864 | 214183 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 347 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5992610.48002 | 2094547.79644 | 37.7308048179917 | -122.467880927762 | (37.7308048179917, -122.467880927762) | 9 | 8 | 4 | 59 | 40 | |||
104601 | 112610 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 333 SANTA ANA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992649 | 2094625 | 37.7310190240744 | -122.467753372021 | (37.7310190240744, -122.467753372021) | 9 | 8 | 4 | 59 | 40 | ||||
27009 | 214185 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 333 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5992626.04523 | 2094642.7577 | 37.7310664568338 | -122.467834020931 | (37.7310664568338, -122.467834020931) | 9 | 8 | 4 | 59 | 40 | |||
109203 | 214186 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 329 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992628.86117 | 2094691.7651 | 37.7312011815816 | -122.46782784889 | (37.7312011815816, -122.46782784889) | 9 | 8 | 4 | 59 | 40 | |||
101186 | 32425 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 275 Maywood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 36952 | 5994490.2461397 | 2094811.13335462 | 37.7316362454296 | -122.461401406739 | (37.7316362454296, -122.461401406739) | 9 | 8 | 4 | 59 | 40 | ||||
147694 | 215020 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 501 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5998758.39397 | 2094948.38752 | 37.7322578436147 | -122.446655503847 | (37.7322578436147, -122.446655503847) | 9 | 7 | 4 | 59 | 40 | |||
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 | ||
44983 | 215010 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 220 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 5992623.69978 | 2095247.7676 | 37.7327275280451 | -122.467886117771 | (37.7327275280451, -122.467886117771) | 9 | 8 | 4 | 59 | 40 | |||
39658 | 215015 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Fernwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994765.23071 | 2095304.12361 | 37.7330056991393 | -122.460486446495 | (37.7330056991393, -122.460486446495) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
124231 | 214201 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 145 Maywood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5994272.70142 | 2095629.8656 | 37.7338717597584 | -122.462212852568 | (37.7338717597584, -122.462212852568) | 9 | 8 | 4 | 59 | 40 | |||
102524 | 258404 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 15 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x10 | 5991685.90264393 | 2095891.27109779 | 37.7344402285305 | -122.471175151585 | (37.7344402285305, -122.471175151585) | 9 | 8 | 4 | 59 | 40 | ||||
181204 | 50265 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 35 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46971 | 6005046.20150954 | 2096458.3536408 | 37.7367610435591 | -122.425024502668 | (37.7367610435591, -122.425024502668) | 2 | 7 | 5 | 28859 | 2 | ||
136950 | 240518 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 410 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003671.25303 | 2096506.18775 | 37.736814621205 | -122.429781709568 | (37.736814621205, -122.429781709568) | 2 | 7 | 5 | 63 | 7 | |||
37849 | 240519 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 167 Bemis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003354.83441 | 2096529.99607 | 37.7368620703274 | -122.430877405766 | (37.7368620703274, -122.430877405766) | 2 | 7 | 5 | 63 | 7 | |||
179056 | 41712 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 395 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42160 | 6000832.46516562 | 2096676.37340252 | 37.7371207489149 | -122.439608818975 | (37.7371207489149, -122.439608818975) | 2 | 7 | 5 | 63 | 7 | ||
65438 | 239712 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 88 Santa Marina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006164.57012 | 2097549.79113 | 37.7398209981319 | -122.421235287575 | (37.7398209981319, -122.421235287575) | 2 | 7 | 7 | 28859 | 2 | |||
36627 | 47707 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2002 12:00:00 AM | Permit Number 45502 | 6004240.85369341 | 2097554.18637259 | 37.7397244258614 | -122.42788700337 | (37.7397244258614, -122.42788700337) | 2 | 7 | 5 | 63 | 7 | |||
163557 | 240591 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004224.31251 | 2097557.73547 | 37.7397332350934 | -122.42794444859 | (37.7397332350934, -122.42794444859) | 2 | 7 | 5 | 63 | 7 | |||
108229 | 214175 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2574 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991436.71189 | 2097914.45578 | 37.7399809632369 | -122.472184104624 | (37.7399809632369, -122.472184104624) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
134763 | 215008 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 230 Granville Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5994122.16655 | 2098836.84765 | 37.7426686663343 | -122.462965888181 | (37.7426686663343, -122.462965888181) | 1 | 8 | 4 | 59 | 40 | |||
173802 | 239715 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 875 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000941.552 | 2099644.41912 | 37.745276511409 | -122.439444352976 | (37.745276511409, -122.439444352976) | 2 | 4 | 5 | 63 | 22 | |||
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 | |||
78515 | 239684 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1664 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6009268.13 | 2099680.20873 | 37.7458451383533 | -122.41065485094 | (37.7458451383533, -122.41065485094) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
170620 | 101979 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
99055 | 40859 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1670 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42380 | 6009721.65724328 | 2100087.27684169 | 37.7469882750849 | -122.409115329349 | (37.7469882750849, -122.409115329349) | 2 | 7 | 7 | 28859 | 2 | ||
145601 | 239737 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1375 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6003294.62667 | 2100231.18022 | 37.7470212555198 | -122.431349696436 | (37.7470212555198, -122.431349696436) | 2 | 7 | 5 | 63 | 22 | |||
43916 | 98255 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1375 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 5x5 | Permit Number 25808 | 6003289 | 2100236 | 37.7470341706262 | -122.431369496968 | (37.7470341706262, -122.431369496968) | 2 | 7 | 5 | 63 | 22 | ||
182065 | 239739 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4195 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6002669.07226 | 2100621.06715 | 37.7480563212454 | -122.433540666185 | (37.7480563212454, -122.433540666185) | 2 | 4 | 5 | 63 | 22 | |||
157428 | 183899 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5989428.0919 | 2100803.1123 | 37.7477960125827 | -122.479340275734 | (37.7477960125827, -122.479340275734) | 1 | 8 | 3 | 29491 | 35 | |||
106826 | 239719 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4818 25th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 10ft | 5999936.15376 | 2101092.93289 | 37.7491965123129 | -122.443024847242 | (37.7491965123129, -122.443024847242) | 2 | 4 | 5 | 28862 | 22 | |||
95638 | 239695 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 49 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6004807.13542 | 2101616.24717 | 37.7509099321629 | -122.426218161243 | (37.7509099321629, -122.426218161243) | 2 | 4 | 5 | 28862 | 22 | |||
148873 | 240547 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4250 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001501.76962 | 2102352.07867 | 37.752742966328 | -122.437701100834 | (37.752742966328, -122.437701100834) | 2 | 4 | 5 | 28862 | 22 | |||
126222 | 239725 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 921 Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6000349.32495 | 2102545.17891 | 37.7532075776886 | -122.441700307737 | (37.7532075776886, -122.441700307737) | 2 | 4 | 5 | 28862 | 22 | |||
60334 | 240558 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 983 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003807.25002 | 2102556.49662 | 37.7534350692835 | -122.429742914602 | (37.7534350692835, -122.429742914602) | 2 | 4 | 5 | 28862 | 22 | |||
121929 | 239680 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 14 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6005352.16587 | 2103533.57017 | 37.7562052473857 | -122.424469755997 | (37.7562052473857, -122.424469755997) | 2 | 4 | 5 | 28859 | 19 | |||
56982 | 240571 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 387 Eureka St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001511.27704 | 2103588.18103 | 37.7561375464167 | -122.437756745491 | (37.7561375464167, -122.437756745491) | 2 | 4 | 5 | 28862 | 3 | |||
67312 | 239692 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3591 21st St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 19 | Width 4ft | 6004466.42319 | 2103643.72661 | 37.7564576520127 | -122.427540804958 | (37.7564576520127, -122.427540804958) | 2 | 4 | 5 | 28862 | 22 | |||
62536 | 112022 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
6965 | 240534 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3250 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2020 12:00:00 AM | 3 | Width 3ft | 6006614.52941 | 2103803.76084 | 37.7570183352315 | -122.420123238094 | (37.7570183352315, -122.420123238094) | 2 | 4 | 7 | 28859 | 19 | ||
164647 | 240536 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3256 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006586.82298 | 2103803.98419 | 37.7570173873698 | -122.420219073467 | (37.7570173873698, -122.420219073467) | 2 | 4 | 7 | 28859 | 19 | |||
66667 | 31499 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3244 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 35060 | 6006677.13820069 | 2103812.71234735 | 37.7570464414299 | -122.419907347924 | (37.7570464414299, -122.419907347924) | 2 | 4 | 7 | 28859 | 19 | ||||
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 | |||
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 | |||||
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 | |||
57063 | 240572 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 210 Collingwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6002036.98136 | 2104624.07975 | 37.7590117527075 | -122.436012807155 | (37.7590117527075, -122.436012807155) | 2 | 4 | 5 | 28862 | 3 | |||
165340 | 215013 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 9 Locksley Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994094.36202 | 2104778.03714 | 37.7589800579143 | -122.463493095026 | (37.7589800579143, -122.463493095026) | 1 | 5 | 4 | 56 | 12 | |||
35678 | 240563 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Hancock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004179.51855 | 2105131.83325 | 37.7605274080343 | -122.42863909662 | (37.7605274080343, -122.42863909662) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
79965 | 239706 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4922 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 5997784.7842 | 2105653.47991 | 37.7615957414698 | -122.450793062454 | (37.7615957414698, -122.450793062454) | 15 | 5 | 11 | 29492 | 9 | |||
21972 | 197530 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1400 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6013404.894 | 2105708.82045 | 37.7626294689928 | -122.396772970689 | (37.7626294689928, -122.396772970689) | 14 | 3 | 8 | 28856 | 29 | |||
64596 | 52688 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1401@ RIVOLI Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2006 12:00:00 AM | Permit Number 48758 | 5997782.1418349 | 2105912.5855129 | 37.76230702883 | -122.450820884323 | (37.76230702883, -122.450820884323) | 15 | 5 | 11 | 29492 | 9 | |||
23706 | 239699 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 157 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997863.73891 | 2105916.05553 | 37.7623212272736 | -122.450538922143 | (37.7623212272736, -122.450538922143) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
88167 | 197527 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6010651.56665 | 2106560.03091 | 37.7648130687996 | -122.406355766009 | (37.7648130687996, -122.406355766009) | 8 | 4 | 8 | 28853 | 19 | |||
115664 | 5372 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 266 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6004807.33386 | 2106790.92069 | 37.7651183778313 | -122.426585912012 | (37.7651183778313, -122.426585912012) | 8 | 4 | 5 | 28862 | 3 | |||
94667 | 197523 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1919 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010718.52588 | 2106914.57132 | 37.7657903018022 | -122.406149150388 | (37.7657903018022, -122.406149150388) | 8 | 4 | 8 | 28853 | 19 | |||
117461 | 200842 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1919 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010705.6887 | 2106916.0312 | 37.7657935922594 | -122.40619365455 | (37.7657935922594, -122.40619365455) | 8 | 4 | 8 | 28853 | 19 | |||
89864 | 200830 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1550 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6011811.2987 | 2107032.5363 | 37.7661752695362 | -122.402377754798 | (37.7661752695362, -122.402377754798) | 8 | 3 | 8 | 28853 | 20 | |||
13044 | 197544 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6011744.68904 | 2107088.20402 | 37.766324401967 | -122.402612061007 | (37.766324401967, -122.402612061007) | 8 | 2 | 8 | 28853 | 20 | |||
128364 | 5349 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/22/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53640 | 6004790.70557 | 2107143.57223 | 37.7660857344886 | -122.426668539926 | (37.7660857344886, -122.426668539926) | 8 | 4 | 5 | 28862 | 3 | |
112473 | 109297 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 RHODE ISLAND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011759.4 | 2107238.5 | 37.7667379021668 | -122.402571748171 | (37.7667379021668, -122.402571748171) | 8 | 2 | 8 | 28853 | 20 | ||||
36630 | 197555 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Kansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 4ft | 6011386.38473 | 2107363.2099 | 37.7670594952368 | -122.403870728771 | (37.7670594952368, -122.403870728771) | 8 | 2 | 8 | 28853 | 20 | |||
100923 | 111027 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | 8 | 2 | 8 | 28853 | 20 | ||||
192856 | 197561 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6011901.49708 | 2107505.77021 | 37.7674796980447 | -122.402099047246 | (37.7674796980447, -122.402099047246) | 8 | 2 | 8 | 28853 | 20 | |||
116428 | 246228 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 5999452.5303 | 2107741.8948 | 37.7674253335335 | -122.445175180965 | (37.7674253335335, -122.445175180965) | 15 | 5 | 11 | 29492 | 9 | |||
120689 | 10523 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1855 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 5997295.7816 | 2108435.9791 | 37.7692077702137 | -122.452685140494 | (37.7692077702137, -122.452685140494) | 15 | 5 | 11 | 29492 | 9 |
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) );