Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8 | 8 | 122650 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 11 | 11 | 122658 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 12 | 12 | 122660 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 13 | 13 | 122648 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 16 | 16 | 122649 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 3264 | 3264 | 253390 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2529x Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2017 12:00:00 AM | 3 | 3x3 | |||||||
| 11396 | 11396 | 122654 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 11418 | 11418 | 122651 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 11649 | 11649 | 122647 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 12297 | 12297 | 122656 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 12338 | 12338 | 122652 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18303 | 18303 | 122659 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18304 | 18304 | 122653 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18306 | 18306 | 122645 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18307 | 18307 | 122655 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18312 | 18312 | 122646 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18314 | 18314 | 122661 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18321 | 18321 | 122657 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 59216 | 59216 | 185222 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2507 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985796.7937 | 2098135.752 | 37.740260579141 | -122.491700620712 | (37.740260579141, -122.491700620712) | |||
| 55050 | 55050 | 66327 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1231 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1991 12:00:00 AM | 4 | Permit Number 29446 | 5987052.1054 | 2106857.6987 | 37.7642819711606 | -122.48800101763901 | (37.7642819711606, -122.488001017639) | |
| 153828 | 153828 | 88582 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 572 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51525 | 5988469.856980001 | 2112085.5473 | 37.7787187988439 | -122.483480758311 | (37.7787187988439, -122.483480758311) | ||
| 149270 | 149270 | 185773 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1615 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989001.3995 | 2102380.5121 | 37.7521023420375 | -122.48093121324699 | (37.7521023420375, -122.480931213247) | |||
| 177732 | 177732 | 123077 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 723 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992233.23043 | 2110491.18489 | 37.774559431962 | -122.47034576378599 | (37.774559431962, -122.470345763786) | |||
| 102281 | 102281 | 1264 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3995X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/15/1992 12:00:00 AM | 3 | 3x3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||
| 17188 | 17188 | 28843 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 338 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2008 12:00:00 AM | 3 | 3X3 | 5993062.32103 | 2089859.0124700002 | 37.7179566445716 | -122.465978279778 | (37.7179566445716, -122.465978279778) | ||
| 94213 | 94213 | 87436 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3726X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5993141.944866001 | 2087637.371973 | 37.7118611458885 | -122.46554174995501 | (37.7118611458885, -122.465541749955) | ||
| 43633 | 43633 | 203422 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 9 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993354.866669999 | 2097295.22775 | 37.738391538344004 | -122.465506999949 | (37.738391538344, -122.465506999949) | |||
| 32646 | 32646 | 203423 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 10 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993355.35449 | 2097236.83517 | 37.7382312350687 | -122.465501072513 | (37.7382312350687, -122.465501072513) | |||
| 132785 | 132785 | 203421 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993401.40723 | 2097258.40143 | 37.738293106632 | -122.46534341236799 | (37.738293106632, -122.465343412368) | |||
| 130360 | 130360 | 203420 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 15 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993455.07316 | 2097218.01136 | 37.7381853004145 | -122.465154930655 | (37.7381853004145, -122.465154930655) | |||
| 31410 | 31410 | 203402 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 20 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993459.6533 | 2097164.40162 | 37.738038365583 | -122.465135202222 | (37.738038365583, -122.465135202222) | |||
| 103313 | 103313 | 115731 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 15 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776556 | 5993468.8 | 2097225.0 | 37.7382052810266 | -122.465107977902 | (37.7382052810266, -122.465107977902) | ||
| 135019 | 135019 | 203401 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 24 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993518.80789 | 2097119.92672 | 37.737919659575404 | -122.46492744804199 | (37.7379196595754, -122.464927448042) | |||
| 130777 | 130777 | 203419 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 35 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993568.7451 | 2097128.9038799999 | 37.7379471878035 | -122.464755443717 | (37.7379471878035, -122.464755443717) | |||
| 115585 | 115585 | 112290 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 34 YERBA BUENA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776546 | 5993584.0 | 2097045.0 | 37.7377176881769 | -122.464696609393 | (37.7377176881769, -122.464696609393) | |
| 149696 | 149696 | 203400 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 34 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993596.06359 | 2097068.4927400001 | 37.737782888861396 | -122.46465660552201 | (37.7377828888614, -122.464656605522) | |||
| 85039 | 85039 | 115729 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 776540 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | |||
| 86745 | 86745 | 115730 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776540 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 92394 | 92394 | 115737 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 9x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776557 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 117245 | 117245 | 116958 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777762 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 144044 | 144044 | 115738 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 95x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776553 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 63718 | 63718 | 203407 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5993759.21038 | 2102270.66076 | 37.7520761325235 | -122.46447014280899 | (37.7520761325235, -122.464470142809) | |||
| 100125 | 100125 | 94790 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1985 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | Permit Number 53888 | 5993755.4 | 2101986.9 | 37.751296778417 | -122.464462718314 | (37.751296778417, -122.464462718314) | |||
| 160113 | 160113 | 203408 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5993769.17892 | 2102256.91781 | 37.7520389725334 | -122.464434672649 | (37.7520389725334, -122.464434672649) | |||
| 173706 | 173706 | 203398 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1898 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993787.6735 | 2102657.11631 | 37.753138881175 | -122.464399769949 | (37.753138881175, -122.464399769949) | |||
| 34402 | 34402 | 203409 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993779.2225 | 2102246.7483099997 | 37.7520116286371 | -122.46439920245399 | (37.7520116286371, -122.464399202454) | |||
| 64431 | 64431 | 203399 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1898 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993788.70878 | 2102627.32377 | 37.7530571381766 | -122.464394026856 | (37.7530571381766, -122.464394026856) | |||
| 83228 | 83228 | 116467 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 85504 | 85504 | 116466 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 88800 | 88800 | 116464 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 99224 | 99224 | 116470 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 101818 | 101818 | 116469 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 105171 | 105171 | 116465 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 129159 | 129159 | 116468 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 46595 | 46595 | 203410 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993793.04129 | 2102233.18002 | 37.7519751701323 | -122.464350430425 | (37.7519751701323, -122.464350430425) | |||
| 161699 | 161699 | 203411 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5993801.541669999 | 2102222.78745 | 37.751947124766104 | -122.46432028066201 | (37.7519471247661, -122.464320280662) | |||
| 112912 | 112912 | 115733 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 50 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776548 | 5993693.2 | 2096969.0 | 37.7375153061033 | -122.46431353926701 | (37.7375153061033, -122.464313539267) | ||
| 175947 | 175947 | 203418 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993705.93526 | 2097033.15738 | 37.7376922003421 | -122.464274164331 | (37.7376922003421, -122.464274164331) | |||
| 32405 | 32405 | 203412 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993816.05949 | 2102205.88495 | 37.7519015516321 | -122.464268849347 | (37.7519015516321, -122.464268849347) | |||
| 171730 | 171730 | 203413 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993820.42059 | 2102181.53499 | 37.7518349442394 | -122.464252000534 | (37.7518349442394, -122.464252000534) | |||
| 94366 | 94366 | 1221 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3600X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3X5 | 5993524.054670201 | 2087589.4711722 | 37.7117516532039 | -122.46421760708901 | (37.7117516532039, -122.464217607089) | ||
| 139076 | 139076 | 115734 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 776555 | 5993732.7 | 2097034.0 | 37.7376960566374 | -122.464181687663 | (37.7376960566374, -122.464181687663) | ||||
| 35502 | 35502 | 203417 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993769.4905900005 | 2096990.17002 | 37.7375778308529 | -122.46405130512 | (37.7375778308529, -122.46405130512) | |||
| 146206 | 146206 | 115735 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776554 | 5993777.6 | 2097002.8 | 37.737612976998896 | -122.464024183823 | (37.7376129769989, -122.464024183823) | ||
| 83319 | 83319 | 115736 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 66 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776551 | 5993801.4 | 2096894.7 | 37.7373175329251 | -122.463934052027 | (37.7373175329251, -122.463934052027) | ||
| 68972 | 68972 | 203416 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 75 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993822.50089 | 2096951.1599400002 | 37.7374737738828 | -122.463865194036 | (37.7374737738828, -122.463865194036) | |||
| 166765 | 166765 | 123540 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 27 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994225.0963 | 2115400.2579200002 | 37.788153386103204 | -122.463811955609 | (37.7881533861032, -122.463811955609) | |||
| 162583 | 162583 | 203415 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 95 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993910.70196 | 2096889.9014700002 | 37.7373106557719 | -122.463555799377 | (37.7373106557719, -122.463555799377) | |||
| 38969 | 38969 | 203414 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 95 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993945.5640199995 | 2096868.34313 | 37.7372534705646 | -122.463433702031 | (37.7372534705646, -122.463433702031) | |||
| 74171 | 74171 | 203427 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 101 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994083.74487 | 2096763.2179299998 | 37.7369727831569 | -122.462948326201 | (37.7369727831569, -122.462948326201) | |||
| 105346 | 105346 | 115752 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | ||
| 143813 | 143813 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | ||
| 138380 | 138380 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | ||
| 155871 | 155871 | 203426 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 135 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994229.44749 | 2096660.50029 | 37.7366991374492 | -122.462437122787 | (37.7366991374492, -122.462437122787) | |||
| 184899 | 184899 | 203425 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 135 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994247.20035 | 2096642.9024 | 37.7366518402943 | -122.46237446791099 | (37.7366518402943, -122.462374467911) | |||
| 147976 | 147976 | 203424 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 135 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994267.45762 | 2096626.89262 | 37.7366090478713 | -122.462303269505 | (37.7366090478713, -122.462303269505) | |||
| 167748 | 167748 | 203403 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994381.0014 | 2096518.06805 | 37.736316779896995 | -122.461902813967 | (37.736316779897, -122.461902813967) | |||
| 159278 | 159278 | 203404 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994396.0657 | 2096501.5652400001 | 37.7362723344984 | -122.461849534529 | (37.7362723344984, -122.461849534529) | |||
| 71761 | 71761 | 203405 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994431.87617 | 2096469.95405 | 37.736187599465204 | -122.46172343251101 | (37.7361875994652, -122.461723432511) | |||
| 40227 | 40227 | 203406 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994466.0383 | 2096440.3744299999 | 37.736108347605295 | -122.461603176966 | (37.7361083476053, -122.461603176966) | |||
| 18687 | 18687 | 49144 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 206 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2003 12:00:00 AM | Permit Number 46269 | 5994953.84956095 | 2088734.37736924 | 37.714977603179705 | -122.45935873857901 | (37.7149776031797, -122.459358738579) | |||
| 90255 | 90255 | 1204 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3101X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.45557429143899 | (37.7101888713812, -122.455574291439) | ||
| 93119 | 93119 | 1205 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3101X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.45557429143899 | (37.7101888713812, -122.455574291439) | ||
| 95494 | 95494 | 1203 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3111X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.45557429143899 | (37.7101888713812, -122.455574291439) | ||
| 150548 | 150548 | 140191 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 282 Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997398.2687 | 2109611.1769 | 37.772440432665604 | -122.452415461613 | (37.7724404326656, -122.452415461613) | |||
| 64160 | 64160 | 220475 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1177 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5997354.16789 | 2106085.5022299998 | 37.7627573058278 | -122.452313556128 | (37.7627573058278, -122.452313556128) | |||
| 54946 | 54946 | 220476 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 849 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998017.46753 | 2107292.9322 | 37.7661105800595 | -122.45010648043501 | (37.7661105800595, -122.450106480435) | |||
| 187239 | 187239 | 220477 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 851 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998019.7394900005 | 2107271.17336 | 37.766050965816895 | -122.45009705375601 | (37.7660509658169, -122.450097053756) | |||
| 160541 | 160541 | 84875 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1936 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2007 12:00:00 AM | 3 | Permit No. 49244 | 5998519.2047 | 2110389.3497 | 37.7746412516506 | -122.44859410709101 | (37.7746412516506, -122.448594107091) | ||
| 82990 | 82990 | 122582 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2500X Lyon St | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 6 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
| 120312 | 120312 | 1128 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2525 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3X6 | 5998741.2887 | 2088615.01895 | 37.7148669056281 | -122.446259214537 | (37.7148669056281, -122.446259214537) | ||
| 70138 | 70138 | 38959 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3186 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | 6 | Permit Number 40754 | 5999542.34025 | 2115724.95595 | 37.7893498954312 | -122.445438624911 | (37.7893498954312, -122.445438624911) | ||
| 13022 | 13022 | 1124 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2463 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5999036.51586 | 2088791.0726700001 | 37.715367165446 | -122.44525144000099 | (37.715367165446, -122.445251440001) | ||
| 11051 | 11051 | 16382 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2413X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5999194.33201 | 2088944.0721099998 | 37.7157962742582 | -122.444716950429 | (37.7157962742582, -122.444716950429) | ||
| 139129 | 139129 | 87445 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2413X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3x3 | 5999221.04782 | 2088973.5231299999 | 37.7158786645875 | -122.44462672412901 | (37.7158786645875, -122.444626724129) | |||
| 121954 | 121954 | 114457 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1985 GOLDEN GATE AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6000094.0 | 2111584.0 | 37.7780113768023 | -122.44323241454501 | (37.7780113768023, -122.443232414545) | |||
| 73165 | 73165 | 175136 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 313 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5999930.3709 | 2092032.12822 | 37.7243173479397 | -122.442394436857 | (37.7243173479397, -122.442394436857) | |||
| 173013 | 173013 | 109047 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2146 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6000527.7493 | 2120317.86339 | 37.802017012842995 | -122.44235909620701 | (37.802017012843, -122.442359096207) | ||||
| 60498 | 60498 | 175129 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 211 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000010.16428 | 2086668.02018 | 37.7095932687863 | -122.441733813766 | (37.7095932687863, -122.441733813766) | |||
| 132408 | 132408 | 175130 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 10 Watt Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000121.603519999 | 2086651.0077400003 | 37.7095529054216 | -122.441347441633 | (37.7095529054216, -122.441347441633) |
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");