trees
527 rows where SiteOrder = 1 and qSpecies_id = 93 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
59029 | 101259 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1830 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990081.34478 | 2106545.17551 | 37.763600113076 | -122.477501005027 | (37.763600113076, -122.477501005027) | 1 | 8 | 3 | 56 | 35 | ||||
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 | ||||
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 | |
39481 | 101978 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6006502 | 2099737 | 37.7458455996049 | -122.420223786963 | (37.7458455996049, -122.420223786963) | 2 | 7 | 7 | 28859 | 2 | ||||
85542 | 10223 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1377X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6005871.04446 | 2100967.56548 | 37.7491888788632 | -122.42249296967 | (37.7491888788632, -122.42249296967) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
335 | 102831 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
101349 | 103464 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 543 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6x9 | 6003223.19269 | 2090290.89193 | 37.7197234328838 | -122.430887417037 | (37.7197234328838, -122.430887417037) | 9 | 7 | 6 | 28861 | 5 | |||
28691 | 10384 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1330 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5999747.97928 | 2108852.64514 | 37.7704920339747 | -122.44423309424 | (37.7704920339747, -122.44423309424) | 15 | 5 | 11 | 29492 | 9 | |||
175855 | 10385 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1330 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/17/2017 12:00:00 AM | 24 | 3X3 | 5999759.298 | 2108827.6222 | 37.7704239730353 | -122.444192144461 | (37.7704239730353, -122.444192144461) | 15 | 5 | 11 | 29492 | 9 | ||
28287 | 10404 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1372 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 5999585.1964 | 2108804.377 | 37.7703502135529 | -122.444792689196 | (37.7703502135529, -122.444792689196) | 15 | 5 | 11 | 29492 | 9 | |||
79980 | 10424 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1417 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 5999343.5805 | 2108720.18711 | 37.7701052580123 | -122.445622380313 | (37.7701052580123, -122.445622380313) | 15 | 5 | 11 | 29492 | 9 | |||
35143 | 10438 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1474 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5999064.8261 | 2108729.1491 | 37.770113946782 | -122.446587229644 | (37.770113946782, -122.446587229644) | 15 | 5 | 11 | 29492 | 9 | |||
35777 | 10458 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1568 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998619.39853 | 2108748.68603 | 37.7701421372022 | -122.448129358985 | (37.7701421372022, -122.448129358985) | 15 | 5 | 11 | 29492 | 9 | |||
119092 | 10460 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1568 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/2008 12:00:00 AM | 12 | 3x3 | 5998627.6282 | 2108670.1782 | 37.7699270451307 | -122.448095239137 | (37.7699270451307, -122.448095239137) | 15 | 5 | 11 | 29492 | 9 | ||
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 | |||
146534 | 104774 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 781 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | Permit Number 778365 | 6002484.5 | 2103704 | 37.7565108482623 | -122.434399295862 | (37.7565108482623, -122.434399295862) | 2 | 4 | 5 | 28862 | 3 | ||
111820 | 10490 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1687 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 5997959.93364 | 2108479.83355 | 37.7693662163265 | -122.450391046811 | (37.7693662163265, -122.450391046811) | 15 | 5 | 11 | 29492 | 9 | |||
146370 | 105020 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101X ORD ST | 1 | Median : Yard | Tree | DPW 1 | 12 | 6000863 | 2105739 | 37.7620062865301 | -122.440152928616 | (37.7620062865301, -122.440152928616) | 15 | 5 | 5 | 28862 | 3 | ||||
127043 | 10517 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1827 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1996 12:00:00 AM | 20 | 3X3 | 5997386.3275 | 2108448.0922 | 37.7692462174685 | -122.452372822905 | (37.7692462174685, -122.452372822905) | 15 | 5 | 11 | 29492 | 9 | ||
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 | |||
91572 | 10522 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1855 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2017 12:00:00 AM | 14 | 3X3 | 5997273.9779 | 2108433.2536 | 37.7691990373323 | -122.452760361188 | (37.7691990373323, -122.452760361188) | 15 | 5 | 11 | 29492 | 9 | ||
15470 | 105248 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1301 COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x5 | 5998246 | 2105821 | 37.7620821004846 | -122.44920998149 | (37.7620821004846, -122.44920998149) | 15 | 5 | 11 | 29492 | 9 | |||
67112 | 105255 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 162 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004396.67956 | 2090207.02373 | 37.7195595692124 | -122.426825119088 | (37.7195595692124, -122.426825119088) | 9 | 7 | 6 | 28861 | 5 | |||
44524 | 106689 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3756 22ND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x5 | 6003424 | 2103059.4 | 37.7547942135386 | -122.431104165828 | (37.7547942135386, -122.431104165828) | 2 | 4 | 5 | 28862 | 22 | |||
188526 | 106721 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1445 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5999673.9299 | 2113871.5922 | 37.7842685529811 | -122.444850062171 | (37.7842685529811, -122.444850062171) | 15 | 6 | 11 | 29490 | 31 | |||
46066 | 107120 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 249 HOLLOWAY AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5996083 | 2091212 | 37.7218454285066 | -122.455634919471 | (37.7218454285066, -122.455634919471) | 9 | 8 | 6 | 28861 | 24 | |||
48484 | 108585 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 36 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6009820.40384 | 2094253.93436 | 37.7309767080873 | -122.408362486264 | (37.7309767080873, -122.408362486264) | 10 | 3 | 7 | 309 | 28 | |||
36565 | 109296 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 RHODE ISLAND ST | 1 | 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 | ||||
125622 | 112609 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 333 SANTA ANA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992649 | 2094625 | 37.7310190240744 | -122.467753372021 | (37.7310190240744, -122.467753372021) | 9 | 8 | 4 | 59 | 40 | ||||
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 | ||||
68428 | 113589 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6013618.31729 | 2118086.59987 | 37.7966279046102 | -122.396902670038 | (37.7966279046102, -122.396902670038) | 3 | 1 | 10 | 28860 | 6 | |||
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 | ||||
134565 | 114875 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1362 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 3x3 | 5999587.7 | 2108019.3 | 37.7681947328922 | -122.444727590707 | (37.7681947328922, -122.444727590707) | 15 | 5 | 11 | 29492 | 9 | |||
117371 | 114997 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 460 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009124.5214 | 2121167.813 | 37.8048369912448 | -122.412670196869 | (37.8048369912448, -122.412670196869) | 3 | 1 | 10 | 308 | 23 | |||
20942 | 116380 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4299X 17TH ST | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 15 | 3x3 | 6000957 | 2105810 | 37.7622065862093 | -122.439832910658 | (37.7622065862093, -122.439832910658) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
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 | |||||
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 | |||
166836 | 117906 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 578 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5983823.18804 | 2111887.66222 | 37.7779039197886 | -122.499540512861 | (37.7779039197886, -122.499540512861) | 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 | |||
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 | |||||
146431 | 120182 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 152 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5987745.04636 | 2114955.0234 | 37.7865553525285 | -122.486198834875 | (37.7865553525285, -122.486198834875) | 11 | 6 | 1 | 55 | 33 | |||
159024 | 121236 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3512 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004884 | 2103735 | 37.7567318772846 | -122.42610317358 | (37.7567318772846, -122.42610317358) | 2 | 4 | 5 | 28862 | 3 | ||||
156771 | 121868 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 382 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 6ft | 5990304.70067 | 2112806.52029 | 37.7808050127417 | -122.477186088815 | (37.7808050127417, -122.477186088815) | 11 | 6 | 2 | 55 | 26 | |||
176026 | 121873 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 346 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5990295.07305 | 2113054.8824 | 37.7814863875121 | -122.47723755062 | (37.7814863875121, -122.47723755062) | 11 | 6 | 2 | 55 | 26 | |||
128267 | 122452 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 203 Addison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002642 | 2097220 | 37.7387162474086 | -122.433391278876 | (37.7387162474086, -122.433391278876) | 2 | 7 | 5 | 63 | 7 | ||||
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 | |||
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 | |||
177695 | 12322 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1008X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6004729.34594 | 2112297.27395 | 37.7802330766406 | -122.427247915616 | (37.7802330766406, -122.427247915616) | 7 | 9 | 11 | 29490 | 41 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
156940 | 1355 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 293 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999960.7830229 | 2099345.3310648 | 37.7443994219045 | -122.442814204744 | (37.7443994219045, -122.442814204744) | 2 | 7 | 5 | 63 | 22 | |||
152947 | 136384 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3604 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5997592.70923 | 2115124.52811 | 37.7875897899782 | -122.452140748718 | (37.7875897899782, -122.452140748718) | 11 | 6 | 1 | 54 | 31 | |||
156884 | 136385 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3395 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998661.8986 | 2115230.45117 | 37.787941815198 | -122.448449211579 | (37.787941815198, -122.448449211579) | 13 | 6 | 1 | 54 | 31 | |||
56923 | 136400 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1128 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007907.63985 | 2115517.19966 | 37.7892534404542 | -122.416480851612 | (37.7892534404542, -122.416480851612) | 13 | 1 | 10 | 28858 | 21 | |||
131492 | 136403 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 897 Green St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6008921.12724 | 2119013.91425 | 37.7989115045253 | -122.413221661757 | (37.7989115045253, -122.413221661757) | 3 | 1 | 10 | 308 | 21 | |||
37780 | 136408 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1120 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008149.75151 | 2118608.08883 | 37.7977538729053 | -122.415862131533 | (37.7977538729053, -122.415862131533) | 5 | 1 | 10 | 28858 | 21 | |||
74616 | 136410 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1700 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008350.5752 | 2118320.27531 | 37.7969748963406 | -122.415146840471 | (37.7969748963406, -122.415146840471) | 5 | 1 | 10 | 308 | 21 | |||
31221 | 136411 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
23104 | 136416 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6013522.99602 | 2118258.2651 | 37.797093950371 | -122.397244549101 | (37.797093950371, -122.397244549101) | 3 | 1 | 10 | 28860 | 6 | |||
173032 | 138285 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2603 CALIFORNIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001869.0685 | 2115321.3526 | 37.7883742541874 | -122.437359516387 | (37.7883742541874, -122.437359516387) | 13 | 6 | 1 | 29490 | 27 | |||
151848 | 138288 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2605 CALIFORNIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001853.9989 | 2115318.2614 | 37.7883649098379 | -122.43741143324 | (37.7883649098379, -122.43741143324) | 13 | 6 | 1 | 29490 | 27 | |||
105423 | 138335 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1799 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002013.7611 | 2114612.8977 | 37.7864372431223 | -122.436808168929 | (37.7864372431223, -122.436808168929) | 13 | 6 | 1 | 29490 | 27 | |||
190896 | 138387 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1905 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001950.5989 | 2115065.5557 | 37.7876765361513 | -122.43705911384 | (37.7876765361513, -122.43705911384) | 13 | 6 | 1 | 29490 | 27 | |||
16227 | 138388 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1955 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002442.7156 | 2115026.9125 | 37.7875983916864 | -122.435353722329 | (37.7875983916864, -122.435353722329) | 13 | 9 | 11 | 29490 | 27 | |||
92768 | 138487 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002041.5919 | 2114791.6986 | 37.786929766345 | -122.436724685254 | (37.786929766345, -122.436724685254) | 13 | 6 | 11 | 29490 | 27 | |||
42292 | 138490 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1800 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002048.5923 | 2114731.495 | 37.7867648604943 | -122.436696154429 | (37.7867648604943, -122.436696154429) | 13 | 6 | 11 | 29490 | 27 | |||
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 | |||
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 | |||
147812 | 141823 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004743.395 | 2112299.7812 | 37.7802407554337 | -122.427199492081 | (37.7802407554337, -122.427199492081) | 7 | 9 | 11 | 29490 | 41 | |||
188949 | 141831 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1181 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6004346.382 | 2112542.3961 | 37.7808844562183 | -122.42859024189 | (37.7808844562183, -122.42859024189) | 7 | 9 | 11 | 29490 | 41 | |||
186845 | 141832 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1171 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 6004383.2413 | 2112546.5688 | 37.7808979992964 | -122.428463024993 | (37.7808979992964, -122.428463024993) | 7 | 9 | 11 | 29490 | 41 | |||
84963 | 141901 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004790.1275 | 2111962.5056 | 37.7793173224289 | -122.427013793928 | (37.7793173224289, -122.427013793928) | 7 | 9 | 11 | 29490 | 41 | |||
28172 | 142669 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 444 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6009205.7299 | 2121176.5543 | 37.8048655501446 | -122.412389783451 | (37.8048655501446, -122.412389783451) | 3 | 1 | 10 | 308 | 23 | |||
173622 | 142733 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 425 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009181 | 2121098 | 37.8046484719029 | -122.41246980811 | (37.8046484719029, -122.41246980811) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
18859 | 14566 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1030 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5999382.6721 | 2109282.399 | 37.7716511811815 | -122.445527596882 | (37.7716511811815, -122.445527596882) | 15 | 5 | 11 | 29492 | 9 | |||
97960 | 14745 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 910 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
56897 | 14749 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 940 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
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 | |||
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 | ||
167487 | 17371 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050X Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5999379.15193 | 2109268.47217 | 37.7716127406754 | -122.445538771694 | (37.7716127406754, -122.445538771694) | 15 | 5 | 11 | 29492 | 9 | |||
2071 | 179437 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 121 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6006551.53826 | 2086713.55756 | 37.7100888527847 | -122.419128872099 | (37.7100888527847, -122.419128872099) | 9 | 7 | 8 | 309 | 39 | |||
67473 | 179442 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 20 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6006642.58468 | 2087353.9641 | 37.7118524017357 | -122.418859586325 | (37.7118524017357, -122.418859586325) | 9 | 7 | 8 | 309 | 39 | |||
88114 | 179444 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 50 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6006641.4754 | 2087068.60877 | 37.7110688134384 | -122.418843195273 | (37.7110688134384, -122.418843195273) | 9 | 7 | 8 | 309 | 39 | |||
174056 | 179446 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 127 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006032.90525 | 2087456.20206 | 37.712098777304 | -122.420974066009 | (37.712098777304, -122.420974066009) | 9 | 7 | 8 | 309 | 39 | |||
7806 | 179447 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 154 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 6ft | 6006213.66342 | 2087416.73528 | 37.7120005974198 | -122.420346512779 | (37.7120005974198, -122.420346512779) | 9 | 7 | 8 | 309 | 39 | |||
55798 | 179451 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1848 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6006175.92265 | 2087836.63994 | 37.7131514400558 | -122.420506743187 | (37.7131514400558, -122.420506743187) | 9 | 7 | 8 | 309 | 39 | |||
31474 | 179452 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1851 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6006040.88882 | 2087844.33942 | 37.7131649703554 | -122.420974012957 | (37.7131649703554, -122.420974012957) | 9 | 7 | 8 | 309 | 39 | |||
152072 | 179455 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1651 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6006947.07452 | 2087492.65331 | 37.7122503535477 | -122.417817006765 | (37.7122503535477, -122.417817006765) | 9 | 7 | 8 | 309 | 39 | |||
79502 | 179456 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 39 Melra Ct | 1 | : | Tree | Private 2 | 18 | Width 4ft | 6008986.48136 | 2086460.78308 | 37.7095316094729 | -122.410695358215 | (37.7095316094729, -122.410695358215) | 9 | 7 | 8 | 309 | 39 | |||
67016 | 179457 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 949 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 1ft | 6002045.64816 | 2088406.8974 | 37.714483612097 | -122.434823106621 | (37.714483612097, -122.434823106621) | 9 | 7 | 6 | 28861 | 5 |
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) );