Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9887 | 9887 | 51349 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 6401 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2004 12:00:00 AM | Permit Number 47697 | ||||||||
| 11322 | 11322 | 19745 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 STAIRWAY15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
| 75642 | 75642 | 117921 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 701 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5983188.84619 | 2110935.7089 | 37.7752528931729 | -122.50166444280799 | (37.7752528931729, -122.501664442808) | |||
| 56961 | 56961 | 117877 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 734 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5983242.29307 | 2110782.48705 | 37.774835329522794 | -122.501468223794 | (37.7748353295228, -122.501468223794) | |||
| 164370 | 164370 | 54720 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 510 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1972 12:00:00 AM | 9 | Permit Number 10556 | 5983806.7051 | 2112297.13716 | 37.7790272518998 | -122.499627803034 | (37.7790272518998, -122.499627803034) | ||
| 87349 | 87349 | 807 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600X 39th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983808.206040001 | 2111664.13118 | 37.7772892893219 | -122.49957581574499 | (37.7772892893219, -122.499575815745) | |||
| 170156 | 170156 | 117839 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600x 39th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 5983810.52385 | 2111649.02031 | 37.7772479352498 | -122.499566680778 | (37.7772479352498, -122.499566680778) | |||
| 71113 | 71113 | 117906 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 578 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5983823.18804 | 2111887.6622200003 | 37.777903919788606 | -122.499540512861 | (37.7779039197886, -122.499540512861) | |||
| 151739 | 151739 | 54495 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 582 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/1972 12:00:00 AM | 9 | Permit Number 10288 | 5983824.998980001 | 2111865.7848400003 | 37.777843957105205 | -122.49953263105499 | (37.7778439571052, -122.499532631055) | ||
| 104485 | 104485 | 24342 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600X 39th Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 143285 | 143285 | 814 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600X 39th Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 145945 | 145945 | 805 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 680X 39th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983823.96426 | 2111160.91126 | 37.7759085177004 | -122.499484105844 | (37.7759085177004, -122.499484105844) | |||
| 121730 | 121730 | 803 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 680X 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983825.76498 | 2111129.60729 | 37.7758226717015 | -122.499475562851 | (37.7758226717015, -122.499475562851) | |||
| 62431 | 62431 | 75772 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3701 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 13 | 5984063.002640001 | 2111035.7891 | 37.7755789903575 | -122.49864797822599 | (37.7755789903575, -122.498647978226) | ||
| 153253 | 153253 | 75719 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3701 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 8 | 5984076.35537 | 2111035.6681 | 37.775579441223705 | -122.498601779667 | (37.7755794412237, -122.498601779667) | ||
| 39538 | 39538 | 75600 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 701 38th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 9 | 5984118.61972 | 2110981.94357 | 37.775434407710705 | -122.49845161010599 | (37.7754344077107, -122.498451610106) | ||
| 34723 | 34723 | 75661 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 701 38th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 2 | 5984119.5345 | 2111005.02849 | 37.7754978458904 | -122.498450151227 | (37.7754978458904, -122.498450151227) | ||
| 159303 | 159303 | 75536 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 701 38th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 12 | 5984118.85326 | 2110953.37322 | 37.7753559754601 | -122.498448691476 | (37.7753559754601, -122.498448691476) | ||
| 68301 | 68301 | 75472 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 701 38th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 8 | 5984118.82642 | 2110932.36992 | 37.77529830487779 | -122.498447232603 | (37.7752983048778, -122.498447232603) | ||
| 54299 | 54299 | 118236 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 680 38th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5984154.15255 | 2111259.59719 | 37.7761988481286 | -122.49834920754101 | (37.7761988481286, -122.498349207541) | |||
| 26497 | 26497 | 118237 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 680 38th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 5984156.56832 | 2111248.83134 | 37.7761694298689 | -122.498340055521 | (37.7761694298689, -122.498340055521) | |||
| 19745 | 19745 | 105202 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 708 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x6 | 5984164.05462 | 2110996.44068 | 37.7754768768809 | -122.49829551344999 | (37.7754768768809, -122.49829551345) | |||
| 89070 | 89070 | 184134 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3240 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5984156.0453 | 2104307.1890000002 | 37.757109619352 | -122.497829171247 | (37.757109619352, -122.497829171247) | |||
| 53981 | 53981 | 118228 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5984449.813999999 | 2111641.4618599997 | 37.7772646712772 | -122.49735464678001 | (37.7772646712772, -122.49735464678) | |||
| 49154 | 49154 | 118227 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5984452.03524 | 2111621.56677 | 37.77721017528479 | -122.497345493843 | (37.7772101752848, -122.497345493843) | |||
| 186668 | 186668 | 118226 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5984451.57804 | 2111600.1477900003 | 37.7771513381474 | -122.497345493825 | (37.7771513381474, -122.497345493825) | |||
| 36086 | 36086 | 118225 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5984452.242269999 | 2111581.69085 | 37.7771006996432 | -122.49734183320601 | (37.7771006996432, -122.497341833206) | |||
| 52120 | 52120 | 118224 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5984451.82255 | 2111562.02768 | 37.7770466856492 | -122.49734183318701 | (37.7770466856492, -122.497341833187) | |||
| 28186 | 28186 | 118223 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5984452.77979 | 2111524.2434799997 | 37.776942997233604 | -122.49733573185 | (37.7769429972336, -122.49733573185) | |||
| 181631 | 181631 | 118222 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5984454.40833 | 2111501.37469 | 37.776880301576206 | -122.497328409687 | (37.7768803015762, -122.497328409687) | |||
| 49033 | 49033 | 118221 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5984455.23409 | 2111482.2118900004 | 37.776827734448105 | -122.49732413820101 | (37.7768277344481, -122.497324138201) | |||
| 167234 | 167234 | 118220 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5984456.55861 | 2111461.63296 | 37.7767713082661 | -122.497318036821 | (37.7767713082661, -122.497318036821) | |||
| 50694 | 50694 | 118217 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5984459.3393 | 2111410.10949 | 37.776630002637 | -122.497304613296 | (37.776630002637, -122.497304613296) | |||
| 162463 | 162463 | 35173 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4545 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 12 | Permit Number 38711 | 5984612.32858 | 2111732.91994 | 37.7775253123971 | -122.496799216616 | (37.7775253123971, -122.496799216616) | |
| 51448 | 51448 | 92261 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4545 Anza St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52708 | 5984639.1399 | 2111735.34775 | 37.7775335493935 | -122.49670664793301 | (37.7775335493935, -122.496706647933) | |
| 2683 | 2683 | 71631 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 678 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2017 12:00:00 AM | 3 | Permit Number 780356 | 5984775.35157 | 2111233.16415 | 37.776162677429205 | -122.496198392825 | (37.7761626774292, -122.496198392825) | |
| 82650 | 82650 | 21149 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2292X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
| 105178 | 105178 | 21150 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2292X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
| 108652 | 108652 | 21148 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2292X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
| 134909 | 134909 | 187383 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2200 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985095.2656 | 2100101.9401 | 37.745618175200704 | -122.49427107768601 | (37.7456181752007, -122.494271077686) | |||
| 116776 | 116776 | 104817 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3170 BALBOA ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5985841.0 | 2111127.0 | 37.7759335444794 | -122.49250425909901 | (37.7759335444794, -122.492504259099) | ||||
| 151396 | 151396 | 84343 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2925 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50100 | 5986511.98637 | 2110444.25082 | 37.774098116355795 | -122.49013294289101 | (37.7740981163558, -122.490132942891) | |
| 150999 | 150999 | 250462 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 290 Seacliff Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5986816.96544 | 2115727.4811 | 37.7886221640356 | -122.489466544563 | (37.7886221640356, -122.489466544563) | |||
| 69621 | 69621 | 67958 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 719 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 11 | Permit Number 31678 | 5987220.95005 | 2111007.3016 | 37.7756854718616 | -122.48772192033998 | (37.7756854718616, -122.48772192034) | |
| 29127 | 29127 | 250321 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 247 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987414.73446 | 2114306.1636799998 | 37.7847545126541 | -122.487293940769 | (37.7847545126541, -122.487293940769) | |||
| 137903 | 137903 | 250320 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 255 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 5987417.56987 | 2114243.0271099997 | 37.78458132302389 | -122.487279492276 | (37.7845813230239, -122.487279492276) | |||
| 68359 | 68359 | 120182 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 152 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5987745.04636 | 2114955.0234 | 37.7865553525285 | -122.486198834875 | (37.7865553525285, -122.486198834875) | |||
| 176855 | 176855 | 50200 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 582 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 8 | 3x4 | Permit Number 46908 | 5988471.49095 | 2112024.9112400003 | 37.778552404331705 | -122.483470659433 | (37.7785524043317, -122.483470659433) |
| 133689 | 133689 | 84536 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 124 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | 5988694.18379 | 2114506.16667 | 37.7853781914991 | -122.482882183887 | (37.7853781914991, -122.482882183887) | |||
| 82375 | 82375 | 88393 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 124 23rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51371 | 5988714.5 | 2114502.9 | 37.785370404226796 | -122.48281165726401 | (37.7853704042268, -122.482811657264) | |||
| 112904 | 112904 | 114382 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 402X SERRANO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 188682 | 188682 | 120320 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 640 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5988820.50243 | 2110953.1294299997 | 37.7756298975626 | -122.482184767826 | (37.7756298975626, -122.482184767826) | |||
| 180579 | 180579 | 179484 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5988536.49014 | 2090373.27915 | 37.719106559100396 | -122.48165955597099 | (37.7191065591004, -122.481659555971) | ||||
| 156566 | 156566 | 182027 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2151 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5989030.3614 | 2106462.597 | 37.7633123331055 | -122.481129936538 | (37.7633123331055, -122.481129936538) | |||
| 103632 | 103632 | 95070 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2165 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989059.0 | 2106465.0 | 37.763320595920504 | -122.48103106212099 | (37.7633205959205, -122.481031062121) | ||||
| 46825 | 46825 | 179482 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5988878.80429 | 2090370.98469 | 37.719120158641296 | -122.48047615337 | (37.7191201586413, -122.48047615337) | ||||
| 153866 | 153866 | 179481 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5988902.49405 | 2090393.59661 | 37.7191836220039 | -122.480395922129 | (37.7191836220039, -122.480395922129) | ||||
| 54855 | 54855 | 179483 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5988918.9165199995 | 2090347.02209 | 37.7190566943955 | -122.48033574940399 | (37.7190566943955, -122.480335749404) | ||||
| 119916 | 119916 | 114214 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 230 SERRANO DR | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5988981.0 | 2090766.0 | 37.720210710128896 | -122.48015180069099 | (37.7202107101289, -122.480151800691) | ||||
| 79870 | 79870 | 67438 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2910 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1992 12:00:00 AM | 8 | 4x4 | Permit Number 30940 | 5989610.64145 | 2111971.49615 | 37.7784719767097 | -122.479526038454 | (37.7784719767097, -122.479526038454) |
| 129472 | 129472 | 93166 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2900@ Anza Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x9 | 5989637.9003800005 | 2111973.07871 | 37.7784779053207 | -122.47943185638701 | (37.7784779053207, -122.479431856387) | |||
| 157905 | 157905 | 183898 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5989422.5761 | 2101010.3481 | 37.748364707147495 | -122.47937450767701 | (37.7483647071475, -122.479374507677) | |||
| 51874 | 51874 | 183899 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5989428.0919 | 2100803.1123 | 37.747796012582704 | -122.479340275734 | (37.7477960125827, -122.479340275734) | |||
| 48810 | 48810 | 183900 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101 22nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5989432.8197 | 2100761.3499 | 37.7476816186189 | -122.479320872687 | (37.7476816186189, -122.479320872687) | |||
| 135551 | 135551 | 183901 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101 22nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5989435.1836 | 2100729.0432 | 37.7475930502179 | -122.47931033546699 | (37.7475930502179, -122.479310335467) | |||
| 167194 | 167194 | 183903 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101 22nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5989437.5475 | 2100612.4238 | 37.7472729813132 | -122.479293631278 | (37.7472729813132, -122.479293631278) | |||
| 179352 | 179352 | 183904 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101 22nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5989435.9716 | 2100535.9908 | 37.7470630248592 | -122.479293489941 | (37.7470630248592, -122.479293489941) | |||
| 25682 | 25682 | 183905 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101 22nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5989441.4873 | 2100495.8044 | 37.746953003916296 | -122.479271477973 | (37.7469530039163, -122.479271477973) | |||
| 96521 | 96521 | 62611 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2262 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/1986 12:00:00 AM | Permit Number 22921 | 5989510.16412079 | 2099957.30856958 | 37.745478424066704 | -122.478994620655 | (37.7454784240667, -122.478994620655) | ||
| 171956 | 171956 | 179479 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989502.72531 | 2090743.3416900001 | 37.7201787974032 | -122.478346734135 | (37.7201787974032, -122.478346734135) | ||||
| 168 | 168 | 179480 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5989599.0 | 2090767.0 | 37.7202493457345 | -122.478015677124 | (37.7202493457345, -122.478015677124) | ||||
| 186144 | 186144 | 72398 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 791 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 11 | 5990047.515430001 | 2110000.36847 | 37.7730851702984 | -122.477870609559 | (37.7730851702984, -122.477870609559) | ||
| 11226 | 11226 | 110358 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1830 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5990014.2377 | 2106553.7919 | 37.7636198770855 | -122.477733734661 | (37.7636198770855, -122.477733734661) | |||
| 89422 | 89422 | 101259 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1830 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990081.34478 | 2106545.17551 | 37.763600113076 | -122.47750100502701 | (37.763600113076, -122.477501005027) | ||||
| 187686 | 187686 | 179478 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989807.06872 | 2090726.39006 | 37.720149915678 | -122.477293493993 | (37.720149915678, -122.477293493993) | ||||
| 72936 | 72936 | 121873 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 346 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5990295.07305 | 2113054.8824 | 37.7814863875121 | -122.47723755062 | (37.7814863875121, -122.47723755062) | |||
| 188963 | 188963 | 121868 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 382 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 6ft | 5990304.700669999 | 2112806.5202900004 | 37.7808050127417 | -122.477186088815 | (37.7808050127417, -122.477186088815) | |||
| 100932 | 100932 | 66607 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1991 12:00:00 AM | 12 | Permit Number 29802 | 5989869.39246895 | 2090726.40504468 | 37.7201535727537 | -122.477078065149 | (37.7201535727537, -122.477078065149) | ||
| 37601 | 37601 | 43760 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 249 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 8 | Permit Number 43395 | 5990536.37641 | 2113724.23454 | 37.783338239757704 | -122.47645167744601 | (37.7833382397577, -122.476451677446) | |
| 52358 | 52358 | 43759 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 249 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2000 12:00:00 AM | 9 | Permit Number 43395 | 5990535.981790001 | 2113705.55195 | 37.783286919680705 | -122.476451677439 | (37.7832869196807, -122.476451677439) | ||
| 136280 | 136280 | 96985 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 601 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6x7 | 5991261.14283 | 2111266.80131 | 37.7766328115191 | -122.473764965551 | (37.7766328115191, -122.473764965551) | |||
| 56526 | 56526 | 214173 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2252 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991053.76562 | 2100086.62004 | 37.7459229980593 | -122.47366657496401 | (37.7459229980593, -122.473666574964) | |||
| 174621 | 174621 | 214174 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2574 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991436.00676 | 2097903.57199 | 37.7399510383196 | -122.47218574950001 | (37.7399510383196, -122.4721857495) | |||
| 176426 | 176426 | 214176 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2570 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991436.65565 | 2097934.35886 | 37.7400356087611 | -122.47218574950001 | (37.7400356087611, -122.4721857495) | |||
| 136010 | 136010 | 214175 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2574 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991436.71189 | 2097914.45578 | 37.7399809632369 | -122.472184104624 | (37.7399809632369, -122.472184104624) | |||
| 112946 | 112946 | 68795 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2574 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32734 | 5991441.9162308 | 2097904.96501407 | 37.7399552051973 | -122.472165418715 | (37.7399552051973, -122.472165418715) | ||
| 72553 | 72553 | 46476 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 454 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2002 12:00:00 AM | 6 | Permit Number 44671 | 5991902.97979 | 2112323.35635 | 37.7795709761183 | -122.471621696685 | (37.7795709761183, -122.471621696685) | ||
| 118505 | 118505 | 52473 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 454@ ANZA Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | Permit Number 48584 | 5991906.61756296 | 2112344.10243716 | 37.779628149659096 | -122.471610624408 | (37.7796281496591, -122.471610624408) | ||
| 109971 | 109971 | 12646 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 944 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5992487.23998 | 2114843.45413 | 37.786524258671896 | -122.469784032853 | (37.7865242586719, -122.469784032853) | |||
| 103612 | 103612 | 12645 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 944 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5992509.49668 | 2114843.34604 | 37.786525248314206 | -122.469707022996 | (37.7865252483142, -122.469707022996) | |||
| 163208 | 163208 | 214172 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1370 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5992428.9422 | 2106122.35536 | 37.76257510589 | -122.469350698796 | (37.76257510589, -122.469350698796) | |||
| 130729 | 130729 | 43657 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 553 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 10 | Permit Number 43301 | 5992810.17 | 2111710.0413599997 | 37.777939422957104 | -122.468438730278 | (37.7779394229571, -122.468438730278) | |
| 74596 | 74596 | 68931 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 655 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 12 | Permit Number 32915 | 5992836.31623 | 2110994.2871 | 37.7759756654158 | -122.468296198193 | (37.7759756654158, -122.468296198193) | |
| 36655 | 36655 | 123174 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 735 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5992855.85161 | 2110444.11138 | 37.7744661593712 | -122.468188588983 | (37.7744661593712, -122.468188588983) | |||
| 169541 | 169541 | 214180 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 350 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 3ft | 5992555.06379 | 2094476.42863 | 37.7306056595249 | -122.46806731945499 | (37.7306056595249, -122.468067319455) | |||
| 77105 | 77105 | 214181 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 355 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5992570.4626400005 | 2094410.6821599999 | 37.7304260253276 | -122.468009303302 | (37.7304260253276, -122.468009303302) | |||
| 151737 | 151737 | 214182 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 347 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992605.035 | 2094526.5774700001 | 37.7307462415431 | -122.467898209135 | (37.7307462415431, -122.467898209135) | |||
| 57971 | 57971 | 215009 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 220 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5992622.02484 | 2095272.1230799998 | 37.73279430540261 | -122.467893679258 | (37.7327943054026, -122.467893679258) | |||
| 121875 | 121875 | 56308 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 171 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/1973 12:00:00 AM | 14 | 3x3 | Permit Number 12442 | 5993024.02697 | 2114355.6170799998 | 37.785215804041 | -122.467891402947 | (37.785215804041, -122.467891402947) | |
| 182269 | 182269 | 215010 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 220 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 5992623.69978 | 2095247.7676 | 37.7327275280451 | -122.467886117771 | (37.7327275280451, -122.467886117771) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");