Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantDate, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 111141 | 111141 | 2204 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1120 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5x9 | 6000904.16856 | 2112542.81493 | 37.7806902026292 | -122.440498545519 | (37.7806902026292, -122.440498545519) | |||
| 7947 | 7947 | 2629 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1872 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004578.2934 | 2115053.5876 | 37.787792683911 | -122.427966943787 | (37.787792683911, -122.427966943787) | |||
| 13710 | 13710 | 3708 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016594.5506 | 2099214.51013 | 37.744974467789504 | -122.385288434823 | (37.7449744677895, -122.385288434823) | |||
| 17950 | 17950 | 4408 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1091 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6004454.91155 | 2102571.21825 | 37.7535121447905 | -122.42750421154301 | (37.7535121447905, -122.427504211543) | |||
| 19493 | 19493 | 4411 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1101 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6004460.022890001 | 2102441.95426 | 37.7531575052231 | -122.42747732723801 | (37.7531575052231, -122.427477327238) | |||
| 22192 | 22192 | 4813 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 29 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6005915.07365 | 2097910.62237 | 37.740797690665396 | -122.422123570454 | (37.7407976906654, -122.422123570454) | |||
| 9401 | 9401 | 4822 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 60 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6006061.0289274 | 2097780.9763268996 | 37.7404499429552 | -122.421609705422 | (37.7404499429552, -122.421609705422) | |||
| 18729 | 18729 | 4825 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 72 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 6006134.02134 | 2097745.6697400003 | 37.7403571145946 | -122.421354819194 | (37.7403571145946, -122.421354819194) | |||
| 9063 | 9063 | 4830 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 44 | 5x5 | 6006270.256805 | 2097668.3997492 | 37.740152628556 | -122.42087828555401 | (37.740152628556, -122.420878285554) | |||
| 21392 | 21392 | 4831 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006324.12928 | 2097690.18327 | 37.74021547767221 | -122.420693562078 | (37.7402154776722, -122.420693562078) | |||
| 9234 | 9234 | 4832 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 104X CORTLAND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 48 | 3X3 | 6006272.0 | 2097672.0 | 37.7401626122958 | -122.420872513823 | (37.7401626122958, -122.420872513823) | |||
| 87130 | 87130 | 10269 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 215X Haight St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 6X12 | 6005099.693995 | 2109521.3764509996 | 37.7726320769714 | -122.42576907222299 | (37.7726320769714, -122.425769072223) | |||
| 96814 | 96814 | 10650 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 923 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003416.95187 | 2110680.8277 | 37.7757204098004 | -122.431672647172 | (37.7757204098004, -122.431672647172) | |||
| 7110 | 7110 | 10652 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 931 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003404.4622 | 2110674.9336 | 37.775703518104 | -122.431715431116 | (37.775703518104, -122.431715431116) | |||
| 7855 | 7855 | 10655 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 937 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003345.7495 | 2110667.1791 | 37.775678897926 | -122.43191797899799 | (37.775678897926, -122.431917978998) | |||
| 18780 | 18780 | 16006 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 95 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001386.18936 | 2094608.8979 | 37.7314754397255 | -122.43754633291799 | (37.7314754397255, -122.437546332918) | |||
| 20016 | 20016 | 16033 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 159 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X4 | 6001012.52549 | 2094617.56697 | 37.7314779911003 | -122.438838778307 | (37.7314779911003, -122.438838778307) | |||
| 139546 | 139546 | 17753 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006028.796019999 | 2115599.444 | 37.7893734236606 | -122.422987282423 | (37.7893734236606, -122.422987282423) | |||
| 9298 | 9298 | 17755 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005983.055346799 | 2115593.0882202997 | 37.789353391125104 | -122.42314508816901 | (37.7893533911251, -122.423145088169) | |||
| 9377 | 9377 | 17756 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005973.81147 | 2115593.81965 | 37.7893548777914 | -122.423177122971 | (37.7893548777914, -122.423177122971) | |||
| 9504 | 9504 | 17758 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005894.5926 | 2115584.1297299997 | 37.7893238007876 | -122.423450522313 | (37.7893238007876, -122.423450522313) | |||
| 9564 | 9564 | 17759 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005845.8328233 | 2115574.0220236 | 37.7892932953595 | -122.42361850671999 | (37.7892932953595, -122.42361850672) | |||
| 22379 | 22379 | 17784 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1798X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005418.97388 | 2115516.65721 | 37.7891116821071 | -122.42509130621599 | (37.7891116821071, -122.425091306216) | |||
| 119460 | 119460 | 20127 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 999X Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6003226.6736 | 2110648.3783 | 37.7756205244718 | -122.432328548686 | (37.7756205244718, -122.432328548686) | |||
| 99312 | 99312 | 20132 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 990X Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003116.52257 | 2110682.58178 | 37.7757081923636 | -122.43271203162901 | (37.7757081923636, -122.432712031629) | |||
| 13479 | 13479 | 22442 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 6025 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6013654.8805 | 2091521.7057 | 37.7236885437418 | -122.394914674123 | (37.7236885437418, -122.394914674123) | |||
| 11298 | 11298 | 25444 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2155 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6011824.01572 | 2087503.73336 | 37.7125540294141 | -122.40096152627399 | (37.7125540294141, -122.400961526274) | |||
| 16319 | 16319 | 26014 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 3 | 3X3 | 6014769.7753099995 | 2095716.92157 | 37.735269692036205 | -122.39135377296002 | (37.7352696920362, -122.39135377296) | ||
| 13891 | 13891 | 26809 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1471 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016061.043 | 2095379.9811 | 37.7344161021924 | -122.38686585494 | (37.7344161021924, -122.38686585494) | |||
| 116654 | 116654 | 28140 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 525X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4X4 | 6007061.2074168 | 2097884.914897 | 37.7407916822017 | -122.418158839049 | (37.7407916822017, -122.418158839049) | |||
| 120244 | 120244 | 34458 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1960 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | 3x3 | Permit Number 42077 | 6008233.26269903 | 2119182.7725058 | 37.7993365057546 | -122.415613869084 | (37.7993365057546, -122.415613869084) | |
| 116970 | 116970 | 34459 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1960 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | Permit Number 42077 | 6008233.26269903 | 2119182.7725058 | 37.7993365057546 | -122.415613869084 | (37.7993365057546, -122.415613869084) | ||
| 125997 | 125997 | 34460 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1960 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | 3x3 | Permit Number 38200 | 6008233.26269903 | 2119182.7725058 | 37.7993365057546 | -122.415613869084 | (37.7993365057546, -122.415613869084) | |
| 89868 | 89868 | 36789 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1314 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39526 | 6015468.42166203 | 2090653.62366449 | 37.7214056358126 | -122.388584951991 | (37.7214056358126, -122.388584951991) | ||
| 117616 | 117616 | 36790 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1314 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39526 | 6015468.42166203 | 2090653.62366449 | 37.7214056358126 | -122.388584951991 | (37.7214056358126, -122.388584951991) | ||
| 78284 | 78284 | 36808 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1290 Egbert Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39532 | 6014916.278192299 | 2090716.3266444001 | 37.721547191141205 | -122.39049795372 | (37.7215471911412, -122.39049795372) | ||
| 95666 | 95666 | 36809 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1290 Egbert Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39532 | 6014916.278192299 | 2090716.3266444001 | 37.721547191141205 | -122.39049795372 | (37.7215471911412, -122.39049795372) | ||
| 83231 | 83231 | 36833 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2715 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39537 | 6015005.69395491 | 2090908.83002417 | 37.7220807273762 | -122.390202307194 | (37.7220807273762, -122.390202307194) | ||
| 146328 | 146328 | 36834 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2715 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39537 | 6015005.69395491 | 2090908.83002417 | 37.7220807273762 | -122.390202307194 | (37.7220807273762, -122.390202307194) | ||
| 57547 | 57547 | 38224 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1099 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 14 | Permit Number 40351 | 6014264.59569 | 2102044.43409 | 37.7526156672934 | -122.39354307806101 | (37.7526156672934, -122.393543078061) | |
| 170634 | 170634 | 38226 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1099 Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | 11 | Permit Number 40351 | 6014262.677019999 | 2102083.6302 | 37.752723184838295 | -122.393552456191 | (37.7527231848383, -122.393552456191) | ||
| 96253 | 96253 | 41569 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 63 Ruth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2000 12:00:00 AM | Permit Number 42084 | 6001453.1346338 | 2091658.26221962 | 37.723377473003104 | -122.437103713844 | (37.7233774730031, -122.437103713844) | |||
| 123002 | 123002 | 48545 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 501X Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 3x3 | Permit Number 45866 | 6013823.0 | 2112518.0 | 37.7813492145506 | -122.39580402612101 | (37.7813492145506, -122.395804026121) | ||
| 128144 | 128144 | 50377 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1620 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | |||
| 97104 | 97104 | 50378 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1620 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | |||
| 81696 | 81696 | 51527 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2900 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | Permit Number 47830 | 6014679.41969777 | 2089453.24857655 | 37.7180658851091 | -122.39122846992599 | (37.7180658851091, -122.391228469926) | |||
| 78413 | 78413 | 51528 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2900 Hawes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | Permit Number 47830 | 6014679.41969777 | 2089453.24857655 | 37.7180658851091 | -122.39122846992599 | (37.7180658851091, -122.391228469926) | |||
| 28860 | 28860 | 51570 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 227 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2005 12:00:00 AM | 17 | Permit Number 47867 | 5988337.51894 | 2114460.53389 | 37.7852321378524 | -122.48411277430401 | (37.7852321378524, -122.484112774304) | |
| 10033 | 10033 | 54506 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1215 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1972 12:00:00 AM | 5x5 | Permit Number 10300 | 5995769.71808299 | 2107217.0895637 | 37.7657734551651 | -122.457875462722 | (37.7657734551651, -122.457875462722) | ||
| 86521 | 86521 | 54509 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1291 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1972 12:00:00 AM | 6x5 | Permit Number 10303 | 5995784.13645716 | 2106797.98257299 | 37.7646235238936 | -122.457795263133 | (37.7646235238936, -122.457795263133) | ||
| 10973 | 10973 | 55642 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 422 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775006 | 6002423.93112 | 2090348.58782 | 37.719836534298 | -122.433654298202 | (37.719836534298, -122.433654298202) | |
| 50076 | 50076 | 58511 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1430 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1979 12:00:00 AM | Permit Number 17687 | 5998871.25967783 | 2108358.36156462 | 37.7690847998305 | -122.447230081169 | (37.7690847998305, -122.447230081169) | |||
| 141205 | 141205 | 58522 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1979 12:00:00 AM | 4x4 | Permit Number 17699 | 5998383.76026587 | 2108237.92603054 | 37.768726247134204 | -122.448907628846 | (37.7687262471342, -122.448907628846) | ||
| 11921 | 11921 | 61836 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 209 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1985 12:00:00 AM | 14 | 3x3 | Permit Number 21875 | 6001956.61236 | 2093885.6272599997 | 37.7295219188836 | -122.435522552544 | (37.7295219188836, -122.435522552544) | |
| 169973 | 169973 | 61914 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1985 12:00:00 AM | 12 | Permit Number 21965 | 6016347.85341 | 2101137.90293 | 37.75024205603879 | -122.386275546874 | (37.7502420560388, -122.386275546874) | ||
| 148918 | 148918 | 62209 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 227 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1985 12:00:00 AM | 16 | Permit Number 22331 | 5988338.57879 | 2114482.10714 | 37.7852914335725 | -122.48411069019699 | (37.7852914335725, -122.484110690197) | |
| 40659 | 40659 | 62578 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 739 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1986 12:00:00 AM | 9 | Permit Number 22783 | 6011302.7424099995 | 2104925.74778 | 37.7603620991639 | -122.403988486898 | (37.7603620991639, -122.403988486898) | |
| 62464 | 62464 | 62579 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 741 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1986 12:00:00 AM | 10 | Permit Number 22784 | 6011303.77085 | 2104898.93824 | 37.7602885436105 | -122.40398304329399 | (37.7602885436105, -122.403983043294) | |
| 111273 | 111273 | 62887 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 149 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1986 12:00:00 AM | 18 | 3x3 | Permit Number 23260 | 6008863.78099283 | 2097860.37589342 | 37.7408255991868 | -122.411924460546 | (37.7408255991868, -122.411924460546) | |
| 183147 | 183147 | 66382 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 661 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 12 | Permit Number 29508 | 6003420.5252 | 2110677.1492 | 37.7757105120941 | -122.431660023451 | (37.7757105120941, -122.431660023451) | |
| 28308 | 28308 | 67884 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 5X Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1993 12:00:00 AM | 15 | Permit Number 31577 | 6003921.69231 | 2093425.09481 | 37.72836881267121 | -122.428696258429 | (37.7283688126712, -122.428696258429) | ||
| 5622 | 5622 | 87285 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1820 Webster St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 50302 | 6003460.507999999 | 2115059.4384 | 37.7877454479518 | -122.43183468665801 | (37.7877454479518, -122.431834686658) | ||
| 83393 | 83393 | 92053 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1001 Potrero Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | |||||
| 123251 | 123251 | 92054 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1001 Potrero Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | |||||
| 93165 | 93165 | 95079 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1110 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6013929.4 | 2106263.3 | 37.7641811276583 | -122.394997717565 | (37.7641811276583, -122.394997717565) | ||||
| 96285 | 96285 | 96780 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1502X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x50 | 5993551.4 | 2095180.8 | 37.732597178480894 | -122.4646739916 | (37.7325971784809, -122.4646739916) | |||
| 123678 | 123678 | 97297 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 450 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994062.8 | 2112448.2 | 37.7800384821655 | -122.46415907596202 | (37.7800384821655, -122.464159075962) | |||||
| 106969 | 106969 | 99110 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 94 Bernal Heights Blvd | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6009548.4 | 2098143.7 | 37.741641931317396 | -122.409577286243 | (37.7416419313174, -122.409577286243) | |||||
| 104633 | 104633 | 99112 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80X Bradford St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6009564.7 | 2098208.3 | 37.741820222197596 | -122.40952548431801 | (37.7418202221976, -122.409525484318) | |||||
| 124001 | 124001 | 99698 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1750 Divisadero St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6001124.0 | 2114376.0 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | |||||
| 140716 | 140716 | 99699 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1750 Divisadero St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6001124.0 | 2114376.0 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | |||||
| 142623 | 142623 | 101243 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1299X 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993606.4 | 2106666.6 | 37.7641374320151 | -122.465317867129 | (37.7641374320151, -122.465317867129) | ||||
| 133143 | 133143 | 102290 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016394.11438 | 2101141.39793 | 37.7502542130621 | -122.386115815616 | (37.7502542130621, -122.386115815616) | |||
| 181384 | 181384 | 102291 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6016420.3361599995 | 2101143.32913 | 37.7502609669785 | -122.38602527277399 | (37.7502609669785, -122.386025272774) | |||
| 184177 | 184177 | 102292 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6016451.98974 | 2101145.15055 | 37.750267719991605 | -122.38591593857099 | (37.7502677199916, -122.385915938571) | |||
| 132884 | 132884 | 102293 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016486.61621 | 2101147.40436 | 37.7502758246674 | -122.385796353939 | (37.7502758246674, -122.385796353939) | |||
| 95227 | 95227 | 104805 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X3 Surrey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002238.26788 | 2096221.16673 | 37.7359507686256 | -122.43471578665 | (37.7359507686256, -122.43471578665) | |||
| 95397 | 95397 | 105511 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 772834 | 6003196.1616 | 2109801.36502 | 37.7732931051579 | -122.432373588443 | (37.7732931051579, -122.432373588443) | ||||
| 78803 | 78803 | 105667 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301X DORADO TER | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 5994306.4 | 2092922.0 | 37.726438562961896 | -122.461900058607 | (37.7264385629619, -122.461900058607) | |||||
| 85276 | 85276 | 105668 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301X DORADO TER | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | 5994306.4 | 2092922.0 | 37.726438562961896 | -122.461900058607 | (37.7264385629619, -122.461900058607) | ||||
| 128360 | 128360 | 106364 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 155 BORICA ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992696.0 | 2092292.5 | 37.724617268406604 | -122.467421338179 | (37.7246172684066, -122.467421338179) | |||||
| 98034 | 98034 | 106401 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 22 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5x6 | 5988976.53234 | 2115004.21174 | 37.786762106623705 | -122.481941850779 | (37.7867621066237, -122.481941850779) | |||
| 84347 | 84347 | 106497 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1890 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 772114 | 5997541.6 | 2108881.8 | 37.770445962098705 | -122.451867038975 | (37.7704459620987, -122.451867038975) | ||||
| 146060 | 146060 | 106499 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 420X Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997462.73555 | 2109001.92463 | 37.770771276139705 | -122.452148498658 | (37.7707712761397, -122.452148498658) | |||||
| 124008 | 124008 | 106918 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 274 PUTNAM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009044.8 | 2096077.1 | 37.7359392652864 | -122.41117262558201 | (37.7359392652864, -122.411172625582) | |||||
| 16316 | 16316 | 107069 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400X Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | 8x8 | Permit Number 773144 | 6015928.73625 | 2106322.43558 | 37.764454474908 | -122.388086653778 | (37.764454474908, -122.388086653778) | |
| 16272 | 16272 | 107070 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400X Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | 20x6 | Permit Number 773144 | 6015880.83246 | 2106317.74548 | 37.7644389427302 | -122.388252013943 | (37.7644389427302, -122.388252013943) | |
| 15843 | 15843 | 107072 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400X Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | 50x5 | Permit Number 773144 | 6015855.633230001 | 2106318.50292 | 37.7644396262057 | -122.388339224777 | (37.7644396262057, -122.388339224777) | |
| 55714 | 55714 | 107425 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1600X Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997832.17799 | 2108247.26578 | 37.7687203321672 | -122.450816174345 | (37.7687203321672, -122.450816174345) | |||||
| 98225 | 98225 | 107945 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2200 JERROLD AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6012443.5 | 2099218.7 | 37.7447554536478 | -122.399642400815 | (37.7447554536478, -122.399642400815) | ||||
| 117255 | 117255 | 107946 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2200 JERROLD AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6012443.5 | 2099218.7 | 37.7447554536478 | -122.399642400815 | (37.7447554536478, -122.399642400815) | ||||
| 82988 | 82988 | 107948 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2200 JERROLD AVE | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6012443.5 | 2099218.7 | 37.7447554536478 | -122.399642400815 | (37.7447554536478, -122.399642400815) | ||||
| 108308 | 108308 | 107950 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2200 JERROLD AVE | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6012443.5 | 2099218.7 | 37.7447554536478 | -122.399642400815 | (37.7447554536478, -122.399642400815) | ||||
| 118094 | 118094 | 107951 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2200 JERROLD AVE | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6012443.5 | 2099218.7 | 37.7447554536478 | -122.399642400815 | (37.7447554536478, -122.399642400815) | ||||
| 53672 | 53672 | 108737 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 22 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5x6 | 5988982.16462 | 2115033.23873 | 37.786842134064706 | -122.481924491754 | (37.7868421340647, -122.481924491754) | |||
| 31839 | 31839 | 108738 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 22 22nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 5x6 | 5988982.34798 | 2115051.76356 | 37.786893008658296 | -122.481925214884 | (37.7868930086583, -122.481925214884) | |||
| 139042 | 139042 | 108739 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 22 22ND AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x6 | 5989006.7 | 2115022.6 | 37.786814349999105 | -122.48183882646299 | (37.7868143499991, -122.481838826463) | ||||
| 121637 | 121637 | 110196 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 60x ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998800.0 | 2110445.0 | 37.7748101047276 | -122.44762679098999 | (37.7748101047276, -122.44762679099) | ||||
| 6470 | 6470 | 110846 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2776 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000368.55091 | 2117170.43785 | 37.793365941237894 | -122.44268387196999 | (37.7933659412379, -122.44268387197) | |||
| 94372 | 94372 | 111101 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X1 SURREY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 6002238.0 | 2096221.0 | 37.7359502956153 | -122.434716700898 | (37.7359502956153, -122.434716700898) |
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");