trees
1,069 rows where qSpecies_id = 93 sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
88665 | 5559 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 984 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005041.33516 | 2102650.51852 | 37.7537630358578 | -122.425481873703 | (37.7537630358578, -122.425481873703) | 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 | |||
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 | |||
141318 | 10425 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1419 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 5999323.0709 | 2108716.5502 | 37.7700941010229 | -122.445693060933 | (37.7700941010229, -122.445693060933) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
178006 | 5514 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 827 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X5 | 6005075.88619 | 2103522.47666 | 37.7561591814037 | -122.425424436705 | (37.7561591814037, -122.425424436705) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
17515 | 179429 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Brookdale Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6006237.48001 | 2087456.42565 | 37.7121109208587 | -122.420267010915 | (37.7121109208587, -122.420267010915) | 9 | 7 | 8 | 309 | 39 | |||
22649 | 239673 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 51 Tiffany Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 6006373.75126 | 2099735.68708 | 37.7458347673547 | -122.420667160657 | (37.7458347673547, -122.420667160657) | 2 | 7 | 7 | 28859 | 2 | |||
31790 | 93029 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 45 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5x6 | undocumented | 6004830 | 2101620 | 37.7509215289079 | -122.426139360449 | (37.7509215289079, -122.426139360449) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |||
44599 | 138401 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002032.4913 | 2114859.6026 | 37.7871156961534 | -122.436761033856 | (37.7871156961534, -122.436761033856) | 13 | 6 | 11 | 29490 | 27 | |||
47324 | 214178 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 229 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5994148.82976 | 2098782.7623 | 37.7425216973119 | -122.462869772235 | (37.7425216973119, -122.462869772235) | 1 | 8 | 4 | 59 | 40 | |||
47509 | 43759 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 249 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2000 12:00:00 AM | 9 | Permit Number 43395 | 5990535.98179 | 2113705.55195 | 37.7832869196807 | -122.476451677439 | (37.7832869196807, -122.476451677439) | 11 | 6 | 2 | 55 | 26 | ||
53227 | 214194 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 335 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992857.93725 | 2094480.72645 | 37.7306349468323 | -122.467020561646 | (37.7306349468323, -122.467020561646) | 9 | 8 | 4 | 59 | 40 | |||
54243 | 215017 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 832 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999463.89862 | 2095685.88724 | 37.7343231196096 | -122.444269401028 | (37.7343231196096, -122.444269401028) | 9 | 7 | 4 | 63 | 40 | |||
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 | |||
60818 | 214199 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 159 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994376.25623 | 2095510.50299 | 37.7335499814343 | -122.46184618277 | (37.7335499814343, -122.46184618277) | 9 | 8 | 4 | 59 | 40 | |||
65498 | 140194 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2177 FELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997033.6803 | 2109487.6013 | 37.772080231598 | -122.45366767652 | (37.772080231598, -122.45366767652) | 15 | 5 | 11 | 29492 | 16 | |||
71020 | 197528 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010653.38226 | 2106522.32736 | 37.7647096449648 | -122.406346829457 | (37.7647096449648, -122.406346829457) | 8 | 4 | 8 | 28853 | 19 | |||
74166 | 138389 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1955 STEINER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002444.1157 | 2115010.1115 | 37.7875523399426 | -122.435347676 | (37.7875523399426, -122.435347676) | 13 | 9 | 11 | 29490 | 27 | |||
76658 | 215016 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Rosewood Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994826.24251 | 2095308.69182 | 37.7330217520514 | -122.460275845063 | (37.7330217520514, -122.460275845063) | 9 | 8 | 4 | 59 | 40 | |||
81254 | 214179 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 247 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5994052.93286 | 2098838.27918 | 37.742668608777 | -122.46320538032 | (37.742668608777, -122.46320538032) | 1 | 8 | 4 | 59 | 40 | |||
81823 | 62229 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 107 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 9 | Permit Number 22354 | 6001481.45016 | 2093645.47099 | 37.7288355059294 | -122.437148044757 | (37.7288355059294, -122.437148044757) | 9 | 7 | 6 | 28861 | 25 | |
89839 | 40607 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2756 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/1999 12:00:00 AM | 9 | Permit Number 41618 | 5996431.87496 | 2111290.71055 | 37.7769965796048 | -122.45587972743 | (37.7769965796048, -122.45587972743) | 11 | 6 | 2 | 54 | 16 | ||
91371 | 54495 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 582 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/1972 12:00:00 AM | 9 | Permit Number 10288 | 5983824.99898 | 2111865.78484 | 37.7778439571052 | -122.499532631055 | (37.7778439571052, -122.499532631055) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
95430 | 215007 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 226 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5994166.81469 | 2098811.63729 | 37.7426020166841 | -122.462809680445 | (37.7426020166841, -122.462809680445) | 1 | 8 | 4 | 59 | 40 | |||
97410 | 179475 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 245 Wilson St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5994292.07601 | 2086663.34927 | 37.7092529779255 | -122.461496035314 | (37.7092529779255, -122.461496035314) | 9 | 8 | 6 | 28861 | 25 | ||||
98144 | 138403 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002027.5911 | 2114900.905 | 37.7872288234819 | -122.436780945176 | (37.7872288234819, -122.436780945176) | 13 | 6 | 11 | 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 | |||
106107 | 197517 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 407 09th St | 10 | : | Tree | Private 2 | 9 | Width 3ft | 6009758.68055 | 2109312.44793 | 37.7723205831618 | -122.40963832656 | (37.7723205831618, -122.40963832656) | 14 | 2 | 9 | 28853 | 34 | |||
112939 | 138405 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002023.3908 | 2114940.8074 | 37.7873381465407 | -122.436798334797 | (37.7873381465407, -122.436798334797) | 13 | 6 | 11 | 29490 | 27 | |||
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 | |||
121653 | 136417 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013524.76569 | 2118243.85815 | 37.797054490825 | -122.397237414787 | (37.797054490825, -122.397237414787) | 3 | 1 | 10 | 28860 | 6 | |||
126705 | 197568 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6011770.36838 | 2107496.45307 | 37.7674467954558 | -122.402551951223 | (37.7674467954558, -122.402551951223) | 8 | 2 | 8 | 28853 | 20 | |||
128300 | 40086 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1667 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/1999 12:00:00 AM | 9 | Permit Number 41307 | 6005062.9841 | 2118469.14548 | 37.7971983526666 | -122.426533306168 | (37.7971983526666, -122.426533306168) | 13 | 9 | 1 | 57 | 17 | ||
129821 | 35123 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 752 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 9 | Permit Number 38658 | 6001767.50485 | 2089578.0778 | 37.7176836175692 | -122.435868228557 | (37.7176836175692, -122.435868228557) | 9 | 7 | 6 | 28861 | 5 | |
130986 | 214184 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 333 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992621.78111 | 2094609.78104 | 37.7309756648889 | -122.467846365021 | (37.7309756648889, -122.467846365021) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
134111 | 245060 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000828.8922 | 2109039.4379 | 37.7710665282542 | -122.440507618445 | (37.7710665282542, -122.440507618445) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
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 | |||
139502 | 138402 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002032.4913 | 2114879.2037 | 37.7871695157566 | -122.43676243751 | (37.7871695157566, -122.43676243751) | 13 | 6 | 11 | 29490 | 27 | |||
146428 | 102835 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
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 | |||
155471 | 113597 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6013588.4505 | 2118285.15352 | 37.7971714233818 | -122.397019945211 | (37.7971714233818, -122.397019945211) | 3 | 1 | 10 | 28860 | 6 | |||
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 | |||
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 | |||
162222 | 179478 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989807.06872 | 2090726.39006 | 37.720149915678 | -122.477293493993 | (37.720149915678, -122.477293493993) | 1 | 8 | 4 | 64 | 14 | ||||
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 | |||
168385 | 54720 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 510 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1972 12:00:00 AM | 9 | Permit Number 10556 | 5983806.7051 | 2112297.13716 | 37.7790272518998 | -122.499627803034 | (37.7790272518998, -122.499627803034) | 11 | 6 | 2 | 55 | 26 | ||
171268 | 246423 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 406 Duncan St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6003794.9997 | 2099851.12644 | 37.7460060612246 | -122.429592349221 | (37.7460060612246, -122.429592349221) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
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 | ||||
186462 | 30968 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1902 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 9 | Permit Number 34759 | 6002518.1694 | 2114816.0277 | 37.7870236405814 | -122.435077578769 | (37.7870236405814, -122.435077578769) | 13 | 9 | 11 | 29490 | 27 | |
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 | |
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 | |||
131098 | 12646 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 944 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 5992487.23998 | 2114843.45413 | 37.7865242586719 | -122.469784032853 | (37.7865242586719, -122.469784032853) | 11 | 6 | 1 | 54 | 11 | |||
5678 | 214198 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 165 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5994046.02682 | 2093769.86979 | 37.7287516135932 | -122.462861635163 | (37.7287516135932, -122.462861635163) | 9 | 8 | 4 | 59 | 40 | |||
10054 | 63509 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1805 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/1987 12:00:00 AM | 8 | 3x3 | Permit Number 24115 | 6000922.9965 | 2111712.7723 | 37.7784121888349 | -122.440373864948 | (37.7784121888349, -122.440373864948) | 15 | 5 | 11 | 29490 | 41 |
11203 | 239713 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 293 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x6 | 5999986 | 2099353 | 37.7444219165503 | -122.442727560507 | (37.7444219165503, -122.442727560507) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
14944 | 75719 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3701 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5984076.35537 | 2111035.6681 | 37.7755794412237 | -122.498601779667 | (37.7755794412237, -122.498601779667) | 11 | 6 | 2 | 55 | 26 | |||
21269 | 197529 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1399 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013534.71133 | 2105671.72801 | 37.7625348459264 | -122.396321376134 | (37.7625348459264, -122.396321376134) | 14 | 3 | 8 | 28856 | 29 | |||
28758 | 140668 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 544 Stanyan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5996917.2741 | 2109577.8331 | 37.7723213107109 | -122.454076850691 | (37.7723213107109, -122.454076850691) | 15 | 5 | 11 | 29492 | 16 | |||
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 | |||
41227 | 27410 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2184 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1999 12:00:00 AM | 8 | 3X3 | 5997011.7697 | 2109487.1799 | 37.7720778184275 | -122.453743436192 | (37.7720778184275, -122.453743436192) | 15 | 5 | 11 | 29492 | 16 | ||
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 | |
67223 | 250321 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 247 27th Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5987414.73446 | 2114306.16368 | 37.7847545126541 | -122.487293940769 | (37.7847545126541, -122.487293940769) | 11 | 6 | 1 | 55 | 33 | |||
74066 | 179461 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6000982.14926 | 2089697.75779 | 37.7179675875255 | -122.43859141349 | (37.7179675875255, -122.43859141349) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
81245 | 140666 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 540 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5996922.2565 | 2109538.357 | 37.7722132052629 | -122.454056764617 | (37.7722132052629, -122.454056764617) | 15 | 5 | 11 | 29492 | 16 | |||
83445 | 179427 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Brookdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006362.44693 | 2087442.7546 | 37.7120804239565 | -122.419834118658 | (37.7120804239565, -122.419834118658) | 9 | 7 | 8 | 309 | 39 | |||
83828 | 43760 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 249 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 8 | Permit Number 43395 | 5990536.37641 | 2113724.23454 | 37.7833382397577 | -122.476451677446 | (37.7833382397577, -122.476451677446) | 11 | 6 | 2 | 55 | 26 | |
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 | |||
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 | |||
97645 | 179431 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 121 Blythdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006605.70519 | 2086910.12298 | 37.7106316305231 | -122.418955592547 | (37.7106316305231, -122.418955592547) | 9 | 7 | 8 | 309 | 39 | |||
101282 | 215002 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995954.15999 | 2091115.97449 | 37.7215743707347 | -122.456073344621 | (37.7215743707347, -122.456073344621) | 9 | 8 | 6 | 28861 | 24 | |||
102585 | 214200 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 145 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5994280.88933 | 2095617.06263 | 37.7338370774039 | -122.462183616499 | (37.7338370774039, -122.462183616499) | 9 | 8 | 4 | 59 | 40 | |||
105842 | 47786 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 445 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | 8 | Permit Number 45558 | 6009129.7041 | 2121124.5774 | 37.8047185679867 | -122.41264920319 | (37.8047185679867, -122.41264920319) | 3 | 1 | 10 | 308 | 23 | ||
106890 | 142161 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 490X Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000657 | 2110488 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | 15 | 5 | 11 | 29492 | 16 | |||
108226 | 239714 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 872 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000978.62192 | 2099691.67862 | 37.745408384388 | -122.43931955855 | (37.745408384388, -122.43931955855) | 2 | 4 | 5 | 63 | 22 | |||
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 | |||
108695 | 67438 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2910 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/1992 12:00:00 AM | 8 | 4x4 | Permit Number 30940 | 5989610.64145 | 2111971.49615 | 37.7784719767097 | -122.479526038454 | (37.7784719767097, -122.479526038454) | 11 | 6 | 2 | 55 | 26 |
112158 | 179483 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5988918.91652 | 2090347.02209 | 37.7190566943955 | -122.480335749404 | (37.7190566943955, -122.480335749404) | 1 | 8 | 4 | 64 | 14 | ||||
112551 | 179428 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Brookdale Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006287.8718 | 2087448.27209 | 37.7120913722811 | -122.420092263655 | (37.7120913722811, -122.420092263655) | 9 | 7 | 8 | 309 | 39 | |||
112981 | 200844 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1919 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010817.914 | 2106923.6397 | 37.7658207601783 | -122.405806025102 | (37.7658207601783, -122.405806025102) | 8 | 4 | 8 | 28853 | 19 | |||
125228 | 245993 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1419 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999291.5767 | 2108712.9163 | 37.7700823250716 | -122.445801737198 | (37.7700823250716, -122.445801737198) | 15 | 5 | 11 | 29492 | 9 | |||
132882 | 239672 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 176 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6006037.13635 | 2099215.12032 | 37.7443864317028 | -122.421794159571 | (37.7443864317028, -122.421794159571) | 2 | 7 | 5 | 28859 | 2 | |||
139891 | 50200 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 582 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 8 | 3x4 | Permit Number 46908 | 5988471.49095 | 2112024.91124 | 37.7785524043317 | -122.483470659433 | (37.7785524043317, -122.483470659433) | 11 | 6 | 2 | 55 | 26 |
141730 | 197572 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011789.60702 | 2113153.20247 | 37.7829800045728 | -122.40288330192 | (37.7829800045728, -122.40288330192) | 6 | 2 | 9 | 28853 | 34 | |||
146067 | 240581 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 34 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003132.18994 | 2108077.2132 | 37.768555379853 | -122.432471703217 | (37.768555379853, -122.432471703217) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
153019 | 64355 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 230 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1988 12:00:00 AM | 8 | Permit Number 770960 | 6011932.302 | 2113111.47227 | 37.7828733899288 | -122.402386698084 | (37.7828733899288, -122.402386698084) | 6 | 2 | 9 | 28853 | 34 | ||
153125 | 136405 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 897 Green St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6008967.16736 | 2119019.94772 | 37.7989306555735 | -122.413062774033 | (37.7989306555735, -122.413062774033) | 3 | 1 | 10 | 308 | 21 | |||
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 | |||
156586 | 197542 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 346 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6014414.15376 | 2114458.74368 | 37.7867109212046 | -122.393894799306 | (37.7867109212046, -122.393894799306) | 6 | 2 | 9 | 28855 | 6 | |||
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 |
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) );