trees
182 rows where SiteOrder = 2 and qSpecies_id = 93 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193333 | 47788 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 445 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | Permit Number 45558 | 6009171.86340947 | 2121127.78288236 | 37.8047297355065 | -122.412503532854 | (37.8047297355065, -122.412503532854) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
191710 | 2777 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 331 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4X6 | 5994569.06869 | 2110730.26091 | 37.7753506462039 | -122.462283045018 | (37.7753506462039, -122.462283045018) | 11 | 6 | 2 | 54 | 11 | |||
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 | |||
187655 | 136409 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 842 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006660.27823 | 2121526.69808 | 37.8056837844424 | -122.421223486682 | (37.8056837844424, -122.421223486682) | 5 | 1 | 1 | 28858 | 32 | |||
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 | |||
186586 | 141838 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1103 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004708.7161 | 2112593.1646 | 37.7810443525714 | -122.427340367744 | (37.7810443525714, -122.427340367744) | 7 | 9 | 11 | 29490 | 41 | |||
186525 | 18089 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3000 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 5999515.0867 | 2114695.0726 | 37.786520549412 | -122.445458834419 | (37.786520549412, -122.445458834419) | 15 | 6 | 1 | 29490 | 31 | |||
183911 | 30960 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2401 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34753 | 6002022.0507417 | 2114644.40993289 | 37.7865242387809 | -122.436781745524 | (37.7865242387809, -122.436781745524) | 13 | 6 | 1 | 29490 | 27 | ||
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 | |||
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 | ||
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 | |||
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 | ||
177794 | 123731 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 401 Cabrillo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 4ft | 5994369 | 2110706 | 37.7752725100687 | -122.462973363335 | (37.7752725100687, -122.462973363335) | 11 | 6 | 2 | 54 | 11 | |||
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 | ||||
174064 | 138844 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005153.7619 | 2110972.2976 | 37.7766190089592 | -122.425685333039 | (37.7766190089592, -122.425685333039) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
172287 | 24345 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 95 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6006134.19272 | 2108466.72229 | 37.7697946537198 | -122.422115687012 | (37.7697946537198, -122.422115687012) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |
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 | |||||
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 | |||
169348 | 48771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 562 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2002 12:00:00 AM | Permit Number 773432 | 6005160.4427442 | 2110970.099276 | 37.77661335041 | -122.425662065534 | (37.77661335041, -122.425662065534) | 7 | 9 | 11 | 28852 | 10 | |||
168976 | 2775 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 325 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 5994586.46007 | 2110712.87272 | 37.7753039042477 | -122.462221623284 | (37.7753039042477, -122.462221623284) | 11 | 6 | 2 | 54 | 11 | |||
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 | |||
167389 | 102832 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 2 | 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 | |||
166105 | 136412 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 550 Davis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013223.70662 | 2118326.48177 | 37.7972645904406 | -122.398284959481 | (37.7972645904406, -122.398284959481) | 3 | 1 | 10 | 28860 | 6 | |||
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 | |||
165324 | 120320 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 640 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5988820.50243 | 2110953.12943 | 37.7756298975626 | -122.482184767826 | (37.7756298975626, -122.482184767826) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
163960 | 40639 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2740 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | 12 | Permit Number 41638 | 5996441.36597 | 2111293.50073 | 37.7770047854178 | -122.455847097036 | (37.7770047854178, -122.455847097036) | 11 | 6 | 2 | 54 | 16 | ||
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 | |||
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 | ||||
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 | |||
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 | ||||
161596 | 114998 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 460 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6009108.5473 | 2121165.2365 | 37.8048290202645 | -122.412725294876 | (37.8048290202645, -122.412725294876) | 3 | 1 | 10 | 308 | 23 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
154674 | 21843 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 148 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5995171.12407 | 2111491.00238 | 37.7774740890587 | -122.460255539349 | (37.7774740890587, -122.460255539349) | 11 | 6 | 2 | 54 | 11 | |||
154530 | 138491 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1800 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002045.7921 | 2114746.8959 | 37.7868069882912 | -122.43670694528 | (37.7868069882912, -122.43670694528) | 13 | 6 | 11 | 29490 | 27 | |||
152570 | 47784 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 411 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | Permit Number 45557 | 6009328.94293981 | 2121149.73408628 | 37.8047988220658 | -122.4119614934 | (37.8047988220658, -122.4119614934) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
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 | |||
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 | |||
149304 | 136383 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 345 Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5997619.24971 | 2115159.44048 | 37.7876871703592 | -122.452051444224 | (37.7876871703592, -122.452051444224) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||
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 | |||
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 | |||
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 | |||
143552 | 197507 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6009714.36956 | 2109423.21347 | 37.7726222364622 | -122.409799423029 | (37.7726222364622, -122.409799423029) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
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 | |||
135661 | 245059 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000823.1995 | 2109073.1196 | 37.7711586856136 | -122.44052972578 | (37.7711586856136, -122.44052972578) | 15 | 5 | 11 | 29492 | 9 | |||
135371 | 122960 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 140 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5993063.2627 | 2114539.09095 | 37.7857218385904 | -122.467769009292 | (37.7857218385904, -122.467769009292) | 11 | 6 | 2 | 54 | 11 | |||
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 | |||
131378 | 138488 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002039.4918 | 2114807.7995 | 37.7869738559463 | -122.43673310409 | (37.7869738559463, -122.43673310409) | 13 | 6 | 11 | 29490 | 27 | |||
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 | |||
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 | |
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 | ||||
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 | ||
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 | |||
125715 | 40150 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560X Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | Permit Number 41343 | 5996910.70022428 | 2109465.35547876 | 37.7720120993682 | -122.454091465131 | (37.7720120993682, -122.454091465131) | 15 | 5 | 11 | 29492 | 16 | |||
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 | |||
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 | |||
122283 | 124457 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 41 Willard St North | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996114.41784 | 2111533.68226 | 37.7776454910208 | -122.456995481723 | (37.7776454910208, -122.456995481723) | 11 | 6 | 2 | 54 | 16 | |||
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 | |||
121835 | 46759 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1180X Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44858 | 6007776.04474552 | 2115482.02501481 | 37.7891494581332 | -122.416933662921 | (37.7891494581332, -122.416933662921) | 13 | 1 | 10 | 28858 | 21 | |||
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 | |||
121328 | 136399 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1667 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005091.5128 | 2118475.84475 | 37.7972183598879 | -122.42643506692 | (37.7972183598879, -122.42643506692) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
118609 | 136401 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1128 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007893.03777 | 2115514.03443 | 37.7892439283227 | -122.416531148891 | (37.7892439283227, -122.416531148891) | 13 | 1 | 10 | 28858 | 21 | |||
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 | |||
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 | |||
116236 | 108004 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 520 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | Permit Number 773433 | 6005298.14108 | 2111058.38089 | 37.776863530054 | -122.425192009758 | (37.776863530054, -122.425192009758) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
114350 | 117921 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 701 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5983188.84619 | 2110935.7089 | 37.7752528931729 | -122.501664442808 | (37.7752528931729, -122.501664442808) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||||
112260 | 101869 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6012583.9023 | 2113041.0524 | 37.7827163862355 | -122.400127471434 | (37.7827163862355, -122.400127471434) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |||
108379 | 41627 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1095 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42109 | 6007646.45182189 | 2109473.56842462 | 37.7726443942379 | -122.416956155908 | (37.7726443942379, -122.416956155908) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
108154 | 28531 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 241 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2012 12:00:00 AM | 18 | 3X3 | Permit Number 769387 | 6010735.41269 | 2111831.43795 | 37.7792918290844 | -122.406437232011 | (37.7792918290844, -122.406437232011) | 14 | 2 | 9 | 28853 | 34 | |
108074 | 2750 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 59 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5995436.711 | 2110737.12628 | 37.7754194179801 | -122.459282185974 | (37.7754194179801, -122.459282185974) | 11 | 6 | 2 | 54 | 11 | |||
107916 | 123827 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1501 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5993999.90025 | 2112075.97538 | 37.7790128280473 | -122.46434964043 | (37.7790128280473, -122.46434964043) | 11 | 6 | 2 | 54 | 11 | |||
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 | |||
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 | ||
105323 | 251187 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000800 | 2109063 | 37.7711295786607 | -122.440609247553 | (37.7711295786607, -122.440609247553) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | ||
97829 | 30957 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
97689 | 44030 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 96 Lafayette St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52444 | 6007681.41962 | 2109502.84398 | 37.7727267448872 | -122.416837272729 | (37.7727267448872, -122.416837272729) | 8 | 2 | 9 | 28853 | 19 | |
96965 | 239687 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 201 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006096.7615 | 2108447.15285 | 37.7697388094304 | -122.422243770256 | (37.7697388094304, -122.422243770256) | 8 | 4 | 7 | 28853 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );