Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 136118 | 136118 | 250773 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 259 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5985865.92055 | 2114194.89594 | 37.7843585636424 | -122.492644052605 | (37.7843585636424, -122.492644052605) | |||
| 154559 | 154559 | 250620 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987116.07946 | 2115204.5954 | 37.7872039277514 | -122.48839322528099 | (37.7872039277514, -122.488393225281) | |||
| 62217 | 62217 | 250619 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987113.722030001 | 2115192.60557 | 37.7871708695801 | -122.48840049988002 | (37.7871708695801, -122.48840049988) | |||
| 133413 | 133413 | 250533 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 69 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5987683.92995 | 2115503.12844 | 37.7880567296852 | -122.48645053678601 | (37.7880567296852, -122.486450536786) | |||
| 136250 | 136250 | 250532 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 79 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5987685.24066 | 2115481.63254 | 37.787997784513294 | -122.486444423174 | (37.7879977845133, -122.486444423174) | |||
| 154095 | 154095 | 248214 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 67 Fair Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 6006956.2223 | 2099478.83098 | 37.7451623091856 | -122.41863484214 | (37.7451623091856, -122.41863484214) | |||
| 148811 | 148811 | 247957 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6010434.9927199995 | 2098878.7541 | 37.743709870826 | -122.40656351750602 | (37.743709870826, -122.406563517506) | ||||
| 43673 | 43673 | 247493 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 806 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002649.6994 | 2109575.8819 | 37.7726429829887 | -122.434247750607 | (37.7726429829887, -122.434247750607) | |||
| 76536 | 76536 | 247481 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 309 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002713.0909 | 2109626.0822 | 37.7727844183865 | -122.43403206203101 | (37.7727844183865, -122.434032062031) | |||
| 155567 | 155567 | 247480 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 309 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002710.1595 | 2109648.0677 | 37.772844618769895 | -122.434043773953 | (37.7728446187699, -122.434043773953) | |||
| 163079 | 163079 | 247479 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 309 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002709.4266 | 2109671.5189 | 37.7729089683714 | -122.434047985824 | (37.7729089683714, -122.434047985824) | |||
| 67225 | 67225 | 247478 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 309 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002704.2967 | 2109689.8401 | 37.772958982719494 | -122.43406704066099 | (37.7729589827195, -122.434067040661) | |||
| 26163 | 26163 | 247176 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001288.35672 | 2108578.65763 | 37.7698274924813 | -122.438885293015 | (37.7698274924813, -122.438885293015) | |||
| 58867 | 58867 | 247173 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 141 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6001348.76723 | 2108505.96887 | 37.7696313440465 | -122.438671125768 | (37.7696313440465, -122.438671125768) | |||
| 162970 | 162970 | 246778 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 392 Franconia St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 6009934.469769999 | 2098852.71045 | 37.7436103455484 | -122.408292376913 | (37.7436103455484, -122.408292376913) | ||||
| 146728 | 146728 | 246318 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6006836.8702 | 2108926.9706 | 37.7710979938489 | -122.419717800254 | (37.7710979938489, -122.419717800254) | |||
| 162927 | 162927 | 246317 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006842.0158 | 2108939.8347 | 37.771133605468705 | -122.419700914309 | (37.7711336054687, -122.419700914309) | |||
| 132516 | 132516 | 246316 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006848.8767 | 2108962.1326 | 37.7711952166815 | -122.41967876451 | (37.7711952166815, -122.41967876451) | |||
| 55147 | 55147 | 246315 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006857.4528 | 2108984.4305 | 37.7712569245067 | -122.419650681714 | (37.7712569245067, -122.419650681714) | |||
| 187192 | 187192 | 246314 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6006868.6018 | 2109014.4469 | 37.7713399704187 | -122.419614246796 | (37.7713399704187, -122.419614246796) | |||
| 53050 | 53050 | 245954 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 189 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998286.3355 | 2107663.1593 | 37.7671425117336 | -122.44920319850401 | (37.7671425117336, -122.449203198504) | |||
| 136463 | 136463 | 244199 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 677 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003772.3734 | 2110028.492 | 37.7739493963127 | -122.430396601984 | (37.7739493963127, -122.430396601984) | |||
| 172614 | 172614 | 244059 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1652 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998660.6331 | 2109020.8428 | 37.7708917674934 | -122.44800632768299 | (37.7708917674934, -122.448006327683) | |||
| 3035 | 3035 | 240686 | Planning Code 138.1 required 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2810 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010325.27315 | 2101087.17666 | 37.749767577309605 | -122.40709853768499 | (37.7497675773096, -122.407098537685) | |
| 158100 | 158100 | 227666 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 46 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006306.62249 | 2109592.20963 | 37.772894696857705 | -122.421599203664 | (37.7728946968577, -122.421599203664) | |||
| 69926 | 69926 | 227665 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 46 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006330.78292 | 2109566.87483 | 37.7728264958779 | -122.421513830121 | (37.7728264958779, -122.421513830121) | |||
| 170793 | 170793 | 227664 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 46 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6006352.613580001 | 2109543.15644 | 37.7727626017523 | -122.42143663049801 | (37.7727626017523, -122.421436630498) | |||
| 47731 | 47731 | 227663 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6 Unnamed 011 | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | Width 10ft | 6002739.4908 | 2096074.90228 | 37.735577602816896 | -122.432972414242 | (37.7355776028169, -122.432972414242) | |||
| 162520 | 162520 | 227662 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 32 Harry St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6003182.99622 | 2097643.55659 | 37.7399099141156 | -122.43155100069099 | (37.7399099141156, -122.431551000691) | |||
| 55800 | 55800 | 227661 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Addison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003680.16981 | 2096890.8857099998 | 37.7378714190205 | -122.42977831104099 | (37.7378714190205, -122.429778311041) | |||
| 61708 | 61708 | 227660 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 195 Beacon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6003113.10037 | 2097586.0775 | 37.73974812787179 | -122.43178856828101 | (37.7397481278718, -122.431788568281) | |||
| 57506 | 57506 | 227659 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 248 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003786.3248 | 2109251.28052 | 37.771816154325 | -122.430292880621 | (37.771816154325, -122.430292880621) | |||
| 186507 | 186507 | 227658 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001589.01566 | 2106181.9491 | 37.763263822894295 | -122.437673651738 | (37.7632638228943, -122.437673651738) | |||
| 162971 | 162971 | 227657 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 117 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001570.048769999 | 2106180.8326 | 37.7632596788053 | -122.437739171852 | (37.7632596788053, -122.437739171852) | |||
| 37486 | 37486 | 227656 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 148 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001371.492269999 | 2107387.94373 | 37.7665628167523 | -122.43851240444799 | (37.7665628167523, -122.438512404448) | |||
| 72449 | 72449 | 227655 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003762.03013 | 2108315.13286 | 37.769244345078704 | -122.430310116133 | (37.7692443450787, -122.430310116133) | |||
| 45275 | 45275 | 227654 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 210 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004930.05045 | 2104005.07306 | 37.7574760371124 | -122.42596313868201 | (37.7574760371124, -122.425963138682) | |||
| 23366 | 23366 | 227653 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3750 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003384.06107 | 2103624.93542 | 37.7563447763019 | -122.43128265198901 | (37.7563447763019, -122.431282651989) | |||
| 157583 | 157583 | 227652 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3875 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003788.823369999 | 2104769.57077 | 37.759510603063795 | -122.42996449048799 | (37.7595106030638, -122.429964490488) | |||
| 152338 | 152338 | 227651 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4118 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001694.86954 | 2103534.27623 | 37.75599997444 | -122.43711796243 | (37.75599997444, -122.43711796243) | |||
| 74636 | 74636 | 227650 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 154 Danvers St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000006.33119 | 2104908.8667200003 | 37.759678136855996 | -122.443056184107 | (37.759678136856, -122.443056184107) | |||
| 76313 | 76313 | 227649 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 154 Danvers St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999999.59495 | 2104920.93401 | 37.7597108865789 | -122.44308034798901 | (37.7597108865789, -122.443080347989) | |||
| 70505 | 70505 | 227648 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 154 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999992.54639 | 2104934.00184 | 37.7597463657249 | -122.443105663906 | (37.7597463657249, -122.443105663906) | |||
| 186402 | 186402 | 227647 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999980.75729 | 2104959.09552 | 37.7598145945821 | -122.44314823869499 | (37.7598145945821, -122.443148238695) | |||
| 157251 | 157251 | 227646 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4082 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002634.29607 | 2102415.94957 | 37.7529826707309 | -122.43378918933 | (37.7529826707309, -122.43378918933) | |||
| 56261 | 56261 | 227645 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3801 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003027.84051 | 2103561.52563 | 37.7561504741859 | -122.432510056589 | (37.7561504741859, -122.432510056589) | |||
| 179940 | 179940 | 227644 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3801 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003004.720380001 | 2103560.48994 | 37.756146319318496 | -122.43258993978901 | (37.7561463193185, -122.432589939789) | |||
| 163312 | 163312 | 227643 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3801 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002989.53011 | 2103560.80368 | 37.7561463193257 | -122.432642495251 | (37.7561463193257, -122.432642495251) | |||
| 129683 | 129683 | 227642 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3801 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002972.163319999 | 2103558.74094 | 37.756139670625295 | -122.432702408096 | (37.7561396706253, -122.432702408096) | |||
| 165161 | 165161 | 227641 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 582 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001827.41036 | 2102469.65818 | 37.753084321989 | -122.436583393722 | (37.753084321989, -122.436583393722) | |||
| 162454 | 162454 | 227640 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1098 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006270.9018 | 2103197.69782 | 37.7553348592182 | -122.421268598461 | (37.7553348592182, -122.421268598461) | |||
| 53363 | 53363 | 227639 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 326 San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6006173.90943 | 2101141.69074 | 37.7496840680694 | -122.42145802088001 | (37.7496840680694, -122.42145802088) | |||
| 69501 | 69501 | 227638 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 326 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6006175.20644 | 2101155.72627 | 37.7497226795546 | -122.421454532416 | (37.7497226795546, -122.421454532416) | |||
| 41678 | 41678 | 227637 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 326 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6006174.20556 | 2101172.48753 | 37.7497686457084 | -122.421459183712 | (37.7497686457084, -122.421459183712) | |||
| 152929 | 152929 | 227636 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3232 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008200.59079 | 2100972.6589 | 37.749334006979396 | -122.414437698959 | (37.7493340069794, -122.414437698959) | |||
| 158779 | 158779 | 227635 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3234 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008177.73099 | 2100971.3435400003 | 37.7493291110692 | -122.41451665582198 | (37.7493291110692, -122.414516655822) | |||
| 43921 | 43921 | 227634 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3238 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008149.92124 | 2100968.79152 | 37.7493205414166 | -122.414612642259 | (37.7493205414166, -122.414612642259) | |||
| 167315 | 167315 | 227633 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3240 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008124.7966 | 2100966.18492 | 37.749311972684396 | -122.414699339617 | (37.7493119726844, -122.414699339617) | |||
| 56432 | 56432 | 227632 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 71 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997905.871119999 | 2104612.50701 | 37.758744422044295 | -122.450299233916 | (37.7587444220443, -122.450299233916) | |||
| 76698 | 76698 | 227631 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 75 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997896.0946 | 2104612.71078 | 37.758744422037395 | -122.450333060142 | (37.7587444220374, -122.450333060142) | |||
| 184634 | 184634 | 227630 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 10 Arbor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002176.820309999 | 2096986.40745 | 37.7380484541639 | -122.43498294671998 | (37.7380484541639, -122.43498294672) | |||
| 71664 | 71664 | 227629 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 62 Natick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003056.07384 | 2095532.6693400003 | 37.7341067067448 | -122.431839162348 | (37.7341067067448, -122.431839162348) | |||
| 69047 | 69047 | 227628 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4222 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6001065.76771 | 2102912.44614 | 37.754256799634796 | -122.43924903191002 | (37.7542567996348, -122.43924903191) | |||
| 163137 | 163137 | 227627 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1455 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6003318.42561 | 2099759.38462 | 37.7457271634958 | -122.43123373066003 | (37.7457271634958, -122.43123373066) | |||
| 133441 | 133441 | 227626 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1455 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6003318.57968 | 2099748.35087 | 37.7456968761174 | -122.43123241046601 | (37.7456968761174, -122.431232410466) | |||
| 151159 | 151159 | 227625 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4283 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002039.82763 | 2101169.8407900003 | 37.749527401673 | -122.435755824069 | (37.749527401673, -122.435755824069) | |||
| 53384 | 53384 | 227624 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4283 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002006.21213 | 2101168.55205 | 37.749521953590396 | -122.43587197511499 | (37.7495219535904, -122.435871975115) | |||
| 29861 | 29861 | 227623 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1001 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001957.40527 | 2101134.69618 | 37.7494262207603 | -122.43603832812599 | (37.7494262207603, -122.436038328126) | |||
| 49437 | 49437 | 227622 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 521 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 62 | Width 3ft | 6001670.93131 | 2100857.28025 | 37.748648223551 | -122.43700910221001 | (37.748648223551, -122.43700910221) | |||
| 155958 | 155958 | 227621 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1335 Douglass St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001398.3282 | 2099807.1524799997 | 37.7457493236871 | -122.43787655407499 | (37.7457493236871, -122.437876554075) | |||
| 47927 | 47927 | 227620 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005907.97007 | 2102264.4901400004 | 37.752752018913796 | -122.422457421298 | (37.7527520189138, -122.422457421298) | |||
| 189130 | 189130 | 227619 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1193 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008092.35309 | 2100991.6752 | 37.7493801403813 | -122.414813334067 | (37.7493801403813, -122.414813334067) | |||
| 184290 | 184290 | 227618 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 119 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009077.3937800005 | 2097965.31988 | 37.7411257345706 | -122.411193275964 | (37.7411257345706, -122.411193275964) | |||
| 69654 | 69654 | 227617 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6009080.60999 | 2097991.13845 | 37.7411968070922 | -122.411183978775 | (37.7411968070922, -122.411183978775) | |||
| 31281 | 31281 | 227616 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 246 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999006.659659999 | 2106731.5709599997 | 37.764625778676 | -122.44664468051 | (37.764625778676, -122.44664468051) | |||
| 170771 | 170771 | 227615 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6005000.954919999 | 2099622.04361 | 37.7454452619845 | -122.42540601408001 | (37.7454452619845, -122.42540601408) | |||
| 64332 | 64332 | 227614 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 210 Holladay Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010810.25772 | 2099834.79777 | 37.746355946971605 | -122.405333247626 | (37.7463559469716, -122.405333247626) | |||
| 58227 | 58227 | 227613 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 210 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010812.412330001 | 2099853.77151 | 37.746408165199796 | -122.405327133143 | (37.7464081651998, -122.405327133143) | |||
| 170818 | 170818 | 227612 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1299 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010076.057159999 | 2101688.5205599996 | 37.7514047850101 | -122.40800274303601 | (37.7514047850101, -122.408002743036) | |||
| 56287 | 56287 | 227611 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Balmy St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6008811.16325 | 2101739.4503099998 | 37.751473726132005 | -122.412380510571 | (37.751473726132, -122.412380510571) | |||
| 62886 | 62886 | 227610 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 400 Prospect Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6006250.04952 | 2097648.9456700003 | 37.7400980729811 | -122.420946773391 | (37.7400980729811, -122.420946773391) | ||||
| 168581 | 168581 | 227609 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 400 Prospect Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6006260.1728300005 | 2097644.39448 | 37.740086147061 | -122.420911448013 | (37.740086147061, -122.420911448013) | ||||
| 44798 | 44798 | 227608 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004572.06439 | 2096162.43718 | 37.7359217292935 | -122.426642736581 | (37.7359217292935, -122.426642736581) | ||||
| 184382 | 184382 | 227607 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 61 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004513.177130001 | 2096122.0643 | 37.735807545078295 | -122.426843458979 | (37.7358075450783, -122.426843458979) | ||||
| 54300 | 54300 | 227606 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 60 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004509.90475 | 2096122.13365 | 37.7358075504724 | -122.426854777822 | (37.7358075504724, -122.426854777822) | ||||
| 165842 | 165842 | 227605 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004504.61589 | 2096121.06345 | 37.735804312902204 | -122.426872987299 | (37.7358043129022, -122.426872987299) | ||||
| 166757 | 166757 | 227604 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 57 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004502.9106 | 2096117.99556 | 37.7357957927473 | -122.426878664735 | (37.7357957927473, -122.426878664735) | ||||
| 26504 | 26504 | 227603 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 55 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004504.07862 | 2096101.1879099999 | 37.735749708773795 | -122.42687342978998 | (37.7357497087738, -122.42687342979) | ||||
| 184269 | 184269 | 227602 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 54 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004494.61967 | 2096104.27773 | 37.735757657887994 | -122.426906353066 | (37.735757657888, -122.426906353066) | ||||
| 161451 | 161451 | 227601 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1100 San Jose Ave | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6004769.19859 | 2096667.0685 | 37.7373184762576 | -122.425997076417 | (37.7373184762576, -122.425997076417) | ||||
| 37340 | 37340 | 227600 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 308 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6006510.89149 | 2104242.1298 | 37.7582161548565 | -122.420512774045 | (37.7582161548565, -122.420512774045) | |||
| 182098 | 182098 | 227599 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3542 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005268.27661 | 2106072.0060799997 | 37.7631704570704 | -122.424940469222 | (37.7631704570704, -122.424940469222) | |||
| 28179 | 28179 | 227598 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501 14th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6005393.4683 | 2107800.6400599997 | 37.7679239451627 | -122.424630446843 | (37.7679239451627, -122.424630446843) | |||
| 169966 | 169966 | 227597 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501 14th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005381.2036 | 2107800.12984 | 37.767921851550604 | -122.424672832791 | (37.7679218515506, -122.424672832791) | |||
| 173789 | 173789 | 227596 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501 14th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005369.47041 | 2107799.69843 | 37.7679200043356 | -122.424713385909 | (37.7679200043356, -122.424713385909) | |||
| 187960 | 187960 | 227595 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501 14th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005359.22331 | 2107799.65504 | 37.7679193064505 | -122.424748826411 | (37.7679193064505, -122.424748826411) | |||
| 161241 | 161241 | 227594 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005345.94103 | 2107798.56704 | 37.7679155688764 | -122.42479469094101 | (37.7679155688764, -122.424794690941) | |||
| 59498 | 59498 | 227593 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005330.86399 | 2107797.8602 | 37.7679127764864 | -122.42484679046301 | (37.7679127764864, -122.424846790463) | |||
| 153075 | 153075 | 227592 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6005300.21046 | 2107796.96547 | 37.767908588337896 | -122.424952753964 | (37.7679085883379, -122.424952753964) | |||
| 174716 | 174716 | 227591 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 27 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6005552.79952 | 2098729.9467700003 | 37.743026930158294 | -122.423434412384 | (37.7430269301583, -122.423434412384) |
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");