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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42737 | 42737 | 239675 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 689 Dolores St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 9ft | 6005030.3991 | 2104342.90235 | 37.7584093076526 | -122.425640136401 | (37.7584093076526, -122.425640136401) | |||
| 184658 | 184658 | 124347 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 850 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 8ft | 5992970.95796 | 2111419.69143 | 37.777151486539104 | -122.46786138931499 | (37.7771514865391, -122.467861389315) | |||
| 52385 | 52385 | 239682 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3685 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 7ft | 6005238.007069999 | 2101931.5191900004 | 37.751799940838204 | -122.424750590868 | (37.7517999408382, -122.424750590868) | |||
| 175889 | 175889 | 239683 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3681 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 7ft | 6005263.58065 | 2101933.28194 | 37.7518062252985 | -122.42466227924601 | (37.7518062252985, -122.424662279246) | |||
| 27661 | 27661 | 179429 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Brookdale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6006237.48001 | 2087456.42565 | 37.712110920858706 | -122.420267010915 | (37.7121109208587, -122.420267010915) | |||
| 33568 | 33568 | 179425 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006737.87137 | 2087492.2529799999 | 37.712237478839796 | -122.418540048182 | (37.7122374788398, -122.418540048182) | |||
| 34284 | 34284 | 179448 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006504.268209999 | 2087381.76307 | 37.7119209426602 | -122.419339618327 | (37.7119209426602, -122.419339618327) | |||
| 37203 | 37203 | 179446 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 127 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006032.90525 | 2087456.2020599998 | 37.712098777304 | -122.42097406600901 | (37.712098777304, -122.420974066009) | |||
| 40375 | 40375 | 179440 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Blythdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007040.38457 | 2086896.48953 | 37.7106186631909 | -122.417452275027 | (37.7106186631909, -122.417452275027) | |||
| 44932 | 44932 | 179450 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006580.779159999 | 2087379.51909 | 37.7119190900695 | -122.41907501532499 | (37.7119190900695, -122.419075015325) | |||
| 46358 | 46358 | 179434 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6006514.55403 | 2086760.1932299999 | 37.710214821715496 | -122.419260003144 | (37.7102148217155, -122.419260003144) | |||
| 48306 | 48306 | 179432 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6006549.425009999 | 2086808.7283400001 | 37.7103500527955 | -122.419142922204 | (37.7103500527955, -122.419142922204) | |||
| 48668 | 48668 | 179445 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 50 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006641.641 | 2087043.6428599998 | 37.7110002716098 | -122.418840853438 | (37.7110002716098, -122.418840853438) | |||
| 51527 | 51527 | 179437 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 121 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6006551.53826 | 2086713.5575599999 | 37.71008885278471 | -122.419128872099 | (37.7100888527847, -122.419128872099) | |||
| 51699 | 51699 | 179433 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006535.42412 | 2086786.7518099998 | 37.7102889213719 | -122.419189754426 | (37.7102889213719, -122.419189754426) | |||
| 51882 | 51882 | 179443 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 20 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6006639.5983 | 2087274.4168099998 | 37.711633813430204 | -122.418864269997 | (37.7116338134302, -122.418864269997) | |||
| 54669 | 54669 | 179439 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006794.78813 | 2086912.99237 | 37.7106501547416 | -122.418302281839 | (37.7106501547416, -122.418302281839) | |||
| 55960 | 55960 | 197531 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2006 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6012046.11634 | 2103763.76948 | 37.7572130681337 | -122.40133582769501 | (37.7572130681337, -122.401335827695) | |||
| 62271 | 62271 | 179447 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 154 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6006213.66342 | 2087416.73528 | 37.712000597419795 | -122.420346512779 | (37.7120005974198, -122.420346512779) | |||
| 64857 | 64857 | 239685 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1601x Alabama St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6009289.0171 | 2100045.3572 | 37.7468489265392 | -122.41060840725201 | (37.7468489265392, -122.410608407252) | |||
| 76738 | 76738 | 239680 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 14 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6005352.16587 | 2103533.57017 | 37.7562052473857 | -122.42446975599701 | (37.7562052473857, -122.424469755997) | |||
| 130153 | 130153 | 179493 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 781 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6002457.74986 | 2087117.22162 | 37.710965833866 | -122.43330661939899 | (37.710965833866, -122.433306619399) | |||
| 132286 | 132286 | 179436 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006488.6944 | 2086721.59328 | 37.7101073779209 | -122.419346642943 | (37.7101073779209, -122.419346642943) | |||
| 147390 | 147390 | 239674 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3735 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 6005599.10993 | 2100487.66713 | 37.747855843492495 | -122.42339921293001 | (37.7478558434925, -122.42339921293) | |||
| 154490 | 154490 | 179428 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006287.8718 | 2087448.27209 | 37.7120913722811 | -122.420092263655 | (37.7120913722811, -122.420092263655) | |||
| 157586 | 157586 | 179441 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007125.21698 | 2086870.4635 | 37.7105519739575 | -122.417157231746 | (37.7105519739575, -122.417157231746) | |||
| 158631 | 158631 | 179435 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006500.6084199995 | 2086740.91409 | 37.710161099825 | -122.41930683535 | (37.710161099825, -122.41930683535) | |||
| 161232 | 161232 | 179438 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 163 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6006665.75653 | 2086898.09687 | 37.7106019906608 | -122.41874718904499 | (37.7106019906608, -122.418747189045) | |||
| 163435 | 163435 | 179431 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 121 Blythdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006605.70519 | 2086910.12298 | 37.7106316305231 | -122.418955592547 | (37.7106316305231, -122.418955592547) | |||
| 165244 | 165244 | 197530 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1400 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6013404.893999999 | 2105708.82045 | 37.7626294689928 | -122.39677297068899 | (37.7626294689928, -122.396772970689) | |||
| 167377 | 167377 | 179427 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006362.446930001 | 2087442.7546 | 37.7120804239565 | -122.419834118658 | (37.7120804239565, -122.419834118658) | |||
| 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) | |||
| 170161 | 170161 | 179449 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006550.96819 | 2087379.45579 | 37.711917237452 | -122.419178046153 | (37.711917237452, -122.419178046153) | |||
| 173561 | 173561 | 179492 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 781 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6002448.847080001 | 2087107.83027 | 37.7109395422009 | -122.433336718839 | (37.7109395422009, -122.433336718839) | |||
| 179328 | 179328 | 179430 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 241 Blythdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006173.52059 | 2087002.57891 | 37.7108611491941 | -122.42045587934099 | (37.7108611491941, -122.420455879341) | |||
| 184920 | 184920 | 239672 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 176 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6006037.13635 | 2099215.12032 | 37.74438643170279 | -122.421794159571 | (37.7443864317028, -122.421794159571) | |||
| 185597 | 185597 | 179442 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 20 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6006642.58468 | 2087353.9641 | 37.711852401735705 | -122.418859586325 | (37.7118524017357, -122.418859586325) | |||
| 187434 | 187434 | 179444 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 50 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6006641.4754 | 2087068.60877 | 37.711068813438395 | -122.418843195273 | (37.7110688134384, -122.418843195273) | |||
| 187470 | 187470 | 179426 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 6ft | 6006719.22339 | 2087474.4297099998 | 37.7121874900245 | -122.41860323816401 | (37.7121874900245, -122.418603238164) | |||
| 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) | |||
| 1987 | 1987 | 123759 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 201 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2016 12:00:00 AM | 18 | Width 5ft | 5994972.5884300005 | 2110752.02511 | 37.775433631632296 | -122.46088876401501 | (37.7754336316323, -122.460888764015) | ||
| 3590 | 3590 | 246905 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 491 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 5997325.00222 | 2107400.6153700002 | 37.76636660087539 | -122.45250934033501 | (37.7663666008754, -122.452509340335) | |||
| 24001 | 24001 | 239679 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3426 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 6005478.10496 | 2103741.19129 | 37.7567824376811 | -122.42404897940399 | (37.7567824376811, -122.424048979404) | |||
| 24460 | 24460 | 239706 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4922 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5997784.7842 | 2105653.4799099998 | 37.7615957414698 | -122.450793062454 | (37.7615957414698, -122.450793062454) | |||
| 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) | |||
| 34902 | 34902 | 215020 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 501 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5998758.39397 | 2094948.38752 | 37.732257843614704 | -122.44665550384701 | (37.7322578436147, -122.446655503847) | |||
| 42864 | 42864 | 197567 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6011782.82118 | 2107497.01248 | 37.767449026680495 | -122.402508917767 | (37.7674490266805, -122.402508917767) | |||
| 44607 | 44607 | 197563 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011871.68658 | 2107504.14213 | 37.767473563784996 | -122.40220204389799 | (37.767473563785, -122.402202043898) | |||
| 45807 | 45807 | 240555 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 133 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6004136.97088 | 2102299.45232 | 37.752747951271 | -122.428584348611 | (37.752747951271, -122.428584348611) | |||
| 52817 | 52817 | 197564 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011853.28866 | 2107502.0789900003 | 37.7674668719146 | -122.402265535131 | (37.7674668719146, -122.402265535131) | |||
| 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) | |||
| 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) | |||
| 58063 | 58063 | 197566 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6011795.68975 | 2107497.96925 | 37.7674523721611 | -122.402464474151 | (37.7674523721611, -122.402464474151) | |||
| 59654 | 59654 | 239671 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 761 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6005055.20153 | 2103892.3256200003 | 37.7571735312626 | -122.425522291914 | (37.7571735312626, -122.425522291914) | |||
| 61254 | 61254 | 240527 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1401 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 5997701.75426 | 2105891.8144400003 | 37.7622453946303 | -122.45109741551 | (37.7622453946303, -122.45109741551) | |||
| 61327 | 61327 | 197568 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6011770.36838 | 2107496.4530700003 | 37.7674467954558 | -122.40255195122299 | (37.7674467954558, -122.402551951223) | |||
| 68118 | 68118 | 239670 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 443 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6004953.91663 | 2105786.25833 | 37.762368099926206 | -122.426007393424 | (37.7623680999262, -122.426007393424) | |||
| 73460 | 73460 | 214179 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 247 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 5994052.93286 | 2098838.27918 | 37.742668608776995 | -122.46320538031999 | (37.742668608777, -122.46320538032) | |||
| 146870 | 146870 | 239737 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1375 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6003294.62667 | 2100231.18022 | 37.7470212555198 | -122.431349696436 | (37.7470212555198, -122.431349696436) | |||
| 147722 | 147722 | 197561 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011901.49708 | 2107505.7702099998 | 37.7674796980447 | -122.402099047246 | (37.7674796980447, -122.402099047246) | |||
| 148167 | 148167 | 123746 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5995436.312030001 | 2110822.24381 | 37.7756531053071 | -122.45928973136101 | (37.7756531053071, -122.459289731361) | |||
| 154363 | 154363 | 197560 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011918.46378 | 2107507.65941 | 37.7674858323444 | -122.40204049418502 | (37.7674858323444, -122.402040494185) | |||
| 155020 | 155020 | 240521 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 149 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 6003423.1831 | 2096576.8964099998 | 37.7369947203295 | -122.430644439989 | (37.7369947203295, -122.430644439989) | |||
| 166446 | 166446 | 123745 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 5995418.55494 | 2110821.8121700003 | 37.775650899214895 | -122.459351125835 | (37.7756508992149, -122.459351125835) | |||
| 169400 | 169400 | 197562 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011885.98223 | 2107505.07026 | 37.7674769101657 | -122.402152662133 | (37.7674769101657, -122.402152662133) | |||
| 170597 | 170597 | 215011 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 240 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 5992624.77756 | 2095177.6880700001 | 37.7325351693537 | -122.467877296305 | (37.7325351693537, -122.467877296305) | |||
| 176319 | 176319 | 136396 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3651 Baker St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 5999117.86509 | 2121345.1324299998 | 37.8047571571746 | -122.447311924407 | (37.8047571571746, -122.447311924407) | |||
| 178891 | 178891 | 197565 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011813.28863 | 2107500.86119 | 37.767461295230795 | -122.40240380501899 | (37.7674612952308, -122.402403805019) | |||
| 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) | |||
| 183305 | 183305 | 214178 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 229 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 5994148.82976 | 2098782.7623 | 37.7425216973119 | -122.462869772235 | (37.7425216973119, -122.462869772235) | |||
| 183439 | 183439 | 240520 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 161 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 5ft | 6003392.36274 | 2096552.7059 | 37.7369265526056 | -122.43074927395399 | (37.7369265526056, -122.430749273954) | |||
| 186727 | 186727 | 214177 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 225 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 5994177.64343 | 2098765.47338 | 37.7424758858443 | -122.46276888988301 | (37.7424758858443, -122.462768889883) | |||
| 187778 | 187778 | 239705 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4922 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 5997802.28625 | 2105653.55065 | 37.761596937571795 | -122.450732535394 | (37.7615969375718, -122.450732535394) | |||
| 1701 | 1701 | 239730 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1709 Castro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779965 | 6002631.28239 | 2100576.89579 | 37.747932892899705 | -122.43366818554199 | (37.7479328928997, -122.433668185542) | |
| 5171 | 5171 | 247184 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | |
| 5187 | 5187 | 247186 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | Permit Number 780753 | 6000985.28448 | 2108903.00262 | 37.770700815109294 | -122.439956869431 | (37.7707008151093, -122.439956869431) | ||
| 23825 | 23825 | 247187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6000970.93564 | 2108908.88323 | 37.770716144966 | -122.440006923906 | (37.770716144966, -122.440006923906) | |||
| 23959 | 23959 | 123754 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5995442.56449 | 2110764.4731099997 | 37.7754948416879 | -122.45926391827801 | (37.7754948416879, -122.459263918278) | |||
| 25184 | 25184 | 239681 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3616 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6005642.96525 | 2101995.98753 | 37.751999819647295 | -122.423354771113 | (37.7519998196473, -122.423354771113) | |||
| 26119 | 26119 | 247188 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6000957.547669999 | 2108914.20808 | 37.7707300035244 | -122.440053614886 | (37.7707300035244, -122.440053614886) | |||
| 26211 | 26211 | 123755 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5995425.063709999 | 2110766.6471700002 | 37.7754998049095 | -122.459324614731 | (37.7754998049095, -122.459324614731) | |||
| 29182 | 29182 | 136399 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1667 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005091.5128 | 2118475.84475 | 37.7972183598879 | -122.42643506691999 | (37.7972183598879, -122.42643506692) | |||
| 30646 | 30646 | 123738 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 301 Cabrillo St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5994608.02307 | 2110726.73042 | 37.775343195361295 | -122.46214803765801 | (37.7753431953613, -122.462148037658) | |||
| 32674 | 32674 | 123736 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 398 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5994542.01129 | 2110789.2592 | 37.775511081800396 | -122.462380922286 | (37.7755110818004, -122.462380922286) | |||
| 34052 | 34052 | 136411 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 160 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6013483.17698 | 2118325.06374 | 37.797275146684 | -122.397387020609 | (37.797275146684, -122.397387020609) | |||
| 34171 | 34171 | 239736 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1449 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003316.36973 | 2099822.47009 | 37.745900265003705 | -122.431245341824 | (37.7459002650037, -122.431245341824) | |||
| 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) | |||
| 37444 | 37444 | 136389 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3395 Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5998748.07929 | 2115242.8098299997 | 37.787980675804796 | -122.448151933487 | (37.7879806758048, -122.448151933487) | |||
| 38859 | 38859 | 239735 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1449 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003316.0935 | 2099809.08635 | 37.7458635007156 | -122.431245341826 | (37.7458635007156, -122.431245341826) | |||
| 45132 | 45132 | 179472 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 416 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003621.62429 | 2091003.33187 | 37.7217022030671 | -122.42956096376999 | (37.7217022030671, -122.42956096377) | |||
| 45178 | 45178 | 239695 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6004807.135419999 | 2101616.24717 | 37.7509099321629 | -122.426218161243 | (37.7509099321629, -122.426218161243) | |||
| 48654 | 48654 | 124458 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 41 Willard St North | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5996118.46825 | 2111510.19918 | 37.7775812452699 | -122.45697977108601 | (37.7775812452699, -122.456979771086) | |||
| 48874 | 48874 | 215006 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1315 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5995155.473540001 | 2106606.4972900003 | 37.764061618685005 | -122.45995575296101 | (37.764061618685, -122.459955752961) | |||
| 48880 | 48880 | 197526 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 301 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010646.79925 | 2106595.9922 | 37.764911543656794 | -122.40637478936002 | (37.7649115436568, -122.40637478936) | |||
| 49766 | 49766 | 214997 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 324 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5995789.64183 | 2091235.7059799999 | 37.721893680423 | -122.45665069048799 | (37.721893680423, -122.456650690488) | |||
| 51181 | 51181 | 136415 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 640 Davis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013156.852000001 | 2118810.40691 | 37.7985896092893 | -122.398550270302 | (37.7985896092893, -122.398550270302) | |||
| 53232 | 53232 | 123753 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5995463.5723 | 2110766.04178 | 37.7755003566036 | -122.459191361341 | (37.7755003566036, -122.459191361341) | |||
| 53284 | 53284 | 197543 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6011744.4821 | 2107062.59215 | 37.7662540659871 | -122.40261097552799 | (37.7662540659871, -122.402610975528) | |||
| 55322 | 55322 | 239696 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 112 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 5997951.3916 | 2106835.98646 | 37.7648521416436 | -122.450302081196 | (37.7648521416436, -122.450302081196) | |||
| 55379 | 55379 | 179487 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Capistrano Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6001448.45649 | 2093575.59463 | 37.728641765884106 | -122.437257104634 | (37.7286417658841, -122.437257104634) |
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");