Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2786 | 2786 | 252851 | Undocumented 2 | Olea Majestic Beauty :: 192 | 100X Langton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | Permit Number 780604 | 6010166.0 | 2110701.0 | 37.776156040570996 | -122.408327321329 | (37.776156040571, -122.408327321329) | |||
| 3440 | 3440 | 251723 | Undocumented 2 | Olea Majestic Beauty :: 192 | 22 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996653.0 | 2088721.0 | 37.7150384191871 | -122.453484821913 | (37.7150384191871, -122.453484821913) | ||||
| 3919 | 3919 | 42971 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1150 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780074 | 6008001.65221 | 2092059.65812 | 37.724849680043 | -122.414495024431 | (37.724849680043, -122.414495024431) | |
| 4775 | 4775 | 244044 | Undocumented 2 | Olea Majestic Beauty :: 192 | 400 Clayton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998422.6555 | 2109243.8667 | 37.771490528011796 | -122.44884556158199 | (37.7714905280118, -122.448845561582) | |||
| 4782 | 4782 | 244045 | Undocumented 2 | Olea Majestic Beauty :: 192 | 400 Clayton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998420.092 | 2109262.2384 | 37.7715408254049 | -122.448855752375 | (37.7715408254049, -122.448855752375) | |||
| 4804 | 4804 | 244042 | Undocumented 2 | Olea Majestic Beauty :: 192 | 400 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998428.637 | 2109205.8416 | 37.771386462866396 | -122.44882213195801 | (37.7713864628664, -122.448822131958) | |||
| 4820 | 4820 | 244057 | Undocumented 2 | Olea Majestic Beauty :: 192 | 408 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998433.3367 | 2109162.2622 | 37.7712670737259 | -122.448802736045 | (37.7712670737259, -122.448802736045) | |||
| 4822 | 4822 | 244043 | Undocumented 2 | Olea Majestic Beauty :: 192 | 400 Clayton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998423.9372 | 2109224.2133 | 37.771436638095395 | -122.448839712257 | (37.7714366380954, -122.448839712257) | |||
| 4830 | 4830 | 244041 | Undocumented 2 | Olea Majestic Beauty :: 192 | 400 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998430.346 | 2109186.6154 | 37.7713337703654 | -122.44881483539 | (37.7713337703654, -122.44881483539) | |||
| 18079 | 18079 | 109392 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1619X York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774922 | 6010432.1 | 2100253.4 | 37.7474841871266 | -122.40667037373899 | (37.7474841871266, -122.406670373739) |
| 19245 | 19245 | 84808 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 604 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | Permit No. 49309 | 6011773.0 | 2105570.0 | 37.762157334612496 | -122.40240737621201 | (37.7621573346125, -122.402407376212) | |||
| 19749 | 19749 | 48026 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 927 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45744 | 5991172.8529559 | 2102455.75823322 | 37.7524349314894 | -122.473427563174 | (37.7524349314894, -122.473427563174) | ||
| 22895 | 22895 | 251140 | Planning Code 138.1 required 4 | Olea Majestic Beauty :: 192 | 138 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996904.98449 | 2113495.29925 | 37.783076941712 | -122.45440239324499 | (37.783076941712, -122.454402393245) | ||||
| 38721 | 38721 | 47854 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1318 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 2 | Permit Number 45613 | 5982778.81660668 | 2106137.43065428 | 37.762054109846204 | -122.502727551098 | (37.7620541098462, -122.502727551098) | |
| 58676 | 58676 | 49770 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 333 Schwerin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46559 | 6008566.26332194 | 2086145.27295548 | 37.7086417136506 | -122.412125425298 | (37.7086417136506, -122.412125425298) | ||
| 76173 | 76173 | 48027 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1311 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45745 | 5992008.68570265 | 2098400.45709107 | 37.7413484836963 | -122.470241856121 | (37.7413484836963, -122.470241856121) | ||
| 77656 | 77656 | 49766 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 333 Schwerin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46559 | 6008566.26332194 | 2086145.27295548 | 37.7086417136506 | -122.412125425298 | (37.7086417136506, -122.412125425298) | ||
| 79319 | 79319 | 47704 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 125 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45500 | 6002654.19286093 | 2096771.9016546002 | 37.7374865643804 | -122.433317110941 | (37.7374865643804, -122.433317110941) | ||
| 79570 | 79570 | 51898 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 10 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48109 | 5998966.66978018 | 2105434.62940771 | 37.761062417298604 | -122.446689671322 | (37.7610624172986, -122.446689671322) | |||
| 80766 | 80766 | 39800 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1920 41st Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 81196 | 81196 | 48998 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 172 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/2002 12:00:00 AM | Permit Number 46185 | 6004821.78713079 | 2098737.69614262 | 37.743006921807 | -122.425962607538 | (37.743006921807, -122.425962607538) | ||
| 81235 | 81235 | 51900 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 10 Carmel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48109 | 5998966.66978018 | 2105434.62940771 | 37.761062417298604 | -122.446689671322 | (37.7610624172986, -122.446689671322) | |||
| 84298 | 84298 | 50888 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2171 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47397 | 5991295.6388277 | 2100646.5391186 | 37.7474743961381 | -122.472871039952 | (37.7474743961381, -122.472871039952) | ||
| 85588 | 85588 | 50799 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2118 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | Permit Number 47858 | 6003464.5437447 | 2107159.58616463 | 37.766054639862 | -122.431256610846 | (37.766054639862, -122.431256610846) | |||
| 85825 | 85825 | 50625 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2201(REVISED) Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2003 12:00:00 AM | Permit Number 47221 | 6004201.40424147 | 2116358.26582712 | 37.7913536714136 | -122.429363982602 | (37.7913536714136, -122.429363982602) | |||
| 87187 | 87187 | 39804 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1920 41st Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 88194 | 88194 | 39803 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1920 41st Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 88243 | 88243 | 39794 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1920 41st Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 88916 | 88916 | 49031 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 461 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2003 12:00:00 AM | Permit Number 46207 | 5993806.445416099 | 2101759.79287074 | 37.7506761426139 | -122.464269712533 | (37.7506761426139, -122.464269712533) | |||
| 90440 | 90440 | 51899 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 10 Carmel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48109 | 5998966.66978018 | 2105434.62940771 | 37.761062417298604 | -122.446689671322 | (37.7610624172986, -122.446689671322) | |||
| 91424 | 91424 | 47989 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2546 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45721 | 5991761.63478074 | 2098099.13967132 | 37.740506856629295 | -122.471074117371 | (37.7405068566293, -122.471074117371) | ||
| 92700 | 92700 | 63366 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41545 | 6006308.21143459 | 2096885.36921844 | 37.7380047408881 | -122.420691480393 | (37.7380047408881, -122.420691480393) | ||
| 93884 | 93884 | 39802 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1920 41st Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 94035 | 94035 | 45489 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2974 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | Permit Number 44267 | 5990023.24329649 | 2095462.47812983 | 37.733166560688794 | -122.476892129437 | (37.7331665606888, -122.476892129437) | ||
| 94054 | 94054 | 108914 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 14 Joy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772971 | 6010371.9 | 2098925.3 | 37.7438341457577 | -122.406784957727 | (37.7438341457577, -122.406784957727) |
| 97398 | 97398 | 45202 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 222 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2001 12:00:00 AM | Permit Number 44046 | 5987941.71158977 | 2115357.18116388 | 37.7876710228878 | -122.485547954085 | (37.7876710228878, -122.485547954085) | |||
| 97511 | 97511 | 48921 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2612 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46111 | 6011124.42622162 | 2101850.32474835 | 37.7519077045726 | -122.40438872766 | (37.7519077045726, -122.40438872766) | ||
| 97626 | 97626 | 51241 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1527 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47611 | 6000120.99232637 | 2114156.28818959 | 37.78507575784489 | -122.44332384413299 | (37.7850757578449, -122.443323844133) | ||
| 98583 | 98583 | 49634 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 118@ HOLLAWAY Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47124 | 5995362.36867696 | 2090698.75234074 | 37.72039479195271 | -122.458088814243 | (37.7203947919527, -122.458088814243) | ||
| 98794 | 98794 | 50624 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2201(REVISED) Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2003 12:00:00 AM | Permit Number 47221 | 6004201.40424147 | 2116358.26582712 | 37.7913536714136 | -122.429363982602 | (37.7913536714136, -122.429363982602) | |||
| 99603 | 99603 | 50916 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2354 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47418 | 5990770.82550859 | 2099372.08880505 | 37.7439446897673 | -122.474592794399 | (37.7439446897673, -122.474592794399) | ||
| 99714 | 99714 | 45266 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 573 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 45996 | 6008563.2074273 | 2096175.03546928 | 37.736181154586504 | -122.412844610652 | (37.7361811545865, -122.412844610652) | ||
| 101274 | 101274 | 49520 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 3850@ CHURCH 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2003 12:00:00 AM | Permit Number 46427 | 6004849.52312029 | 2100786.51985424 | 37.748634088805204 | -122.42601252142 | (37.7486340888052, -122.42601252142) | ||
| 101718 | 101718 | 109770 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 9 Pomona St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/29/2015 12:00:00 AM | 6x7 | Permit Number 774437 | 6014227.8 | 2094671.9 | 37.7323701819213 | -122.393154495945 | (37.7323701819213, -122.393154495945) | ||
| 102372 | 102372 | 51902 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 10 Carmel St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48109 | 5998966.66978018 | 2105434.62940771 | 37.761062417298604 | -122.446689671322 | (37.7610624172986, -122.446689671322) | |||
| 103076 | 103076 | 109036 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2422 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773529 | 5987396.7 | 2098769.6 | 37.7420943335288 | -122.486215376652 | (37.7420943335288, -122.486215376652) |
| 107058 | 107058 | 46129 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 886 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2001 12:00:00 AM | Permit Number 44479 | 5999201.43690268 | 2107178.82505375 | 37.7658649503447 | -122.44600317189 | (37.7658649503447, -122.44600317189) | ||
| 107379 | 107379 | 40460 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1999 12:00:00 AM | Permit Number 41545 | 6006308.21143459 | 2096885.36921844 | 37.7380047408881 | -122.420691480393 | (37.7380047408881, -122.420691480393) | |||
| 108196 | 108196 | 48920 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2612 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46111 | 6011124.42622162 | 2101850.32474835 | 37.7519077045726 | -122.40438872766 | (37.7519077045726, -122.40438872766) | ||
| 108257 | 108257 | 39801 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1920 41st Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 108669 | 108669 | 50421 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1092 Capitol Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47075 | 5995075.75606262 | 2091172.41961397 | 37.72167889686779 | -122.459113814718 | (37.7216788968678, -122.459113814718) | ||
| 110509 | 110509 | 49032 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 461 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2003 12:00:00 AM | Permit Number 46207 | 5993806.445416099 | 2101759.79287074 | 37.7506761426139 | -122.464269712533 | (37.7506761426139, -122.464269712533) | |||
| 110536 | 110536 | 50915 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2354 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47418 | 5990770.82550859 | 2099372.08880505 | 37.7439446897673 | -122.474592794399 | (37.7439446897673, -122.474592794399) | ||
| 112368 | 112368 | 50886 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2151 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47395 | 5991291.12356149 | 2100776.95734171 | 37.7478322293855 | -122.472896161814 | (37.7478322293855, -122.472896161814) | ||
| 113598 | 113598 | 48025 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 927 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45744 | 5991172.8529559 | 2102455.75823322 | 37.7524349314894 | -122.473427563174 | (37.7524349314894, -122.473427563174) | ||
| 113853 | 113853 | 45490 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2974 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | Permit Number 44267 | 5990023.24329649 | 2095462.47812983 | 37.733166560688794 | -122.476892129437 | (37.7331665606888, -122.476892129437) | ||
| 114229 | 114229 | 50417 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1092 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47075 | 5995075.75606262 | 2091172.41961397 | 37.72167889686779 | -122.459113814718 | (37.7216788968678, -122.459113814718) | ||
| 114364 | 114364 | 48982 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 3971 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2002 12:00:00 AM | Permit Number 46169 | 6004077.4019356 | 2100692.01440883 | 37.7483309307307 | -122.428675772155 | (37.7483309307307, -122.428675772155) | ||
| 116045 | 116045 | 109395 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1619X York St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774922 | 6010432.1 | 2100253.4 | 37.7474841871266 | -122.40667037373899 | (37.7474841871266, -122.406670373739) |
| 118941 | 118941 | 50889 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2183 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47399 | 5991298.34798675 | 2100568.28820424 | 37.7472596962302 | -122.472855966955 | (37.7472596962302, -122.472855966955) | ||
| 122282 | 122282 | 109394 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1619X York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774922 | 6010432.1 | 2100253.4 | 37.7474841871266 | -122.40667037373899 | (37.7474841871266, -122.406670373739) |
| 122345 | 122345 | 114786 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2578 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | Permit Number 773268 | 6000282.5 | 2114132.7 | 37.785020199327704 | -122.442763385723 | (37.7850201993277, -122.442763385723) | |||
| 123107 | 123107 | 45293 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 117 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44132 | 6007166.24761126 | 2096811.6959343997 | 37.7378507726133 | -122.417719597387 | (37.7378507726133, -122.417719597387) | ||
| 123507 | 123507 | 51848 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 813 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | Permit Number 48072 | 5998616.0895613 | 2107512.49914502 | 37.766747692509604 | -122.44805178448999 | (37.7667476925096, -122.44805178449) | |||
| 124027 | 124027 | 51901 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 10 Carmel St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48109 | 5998966.66978018 | 2105434.62940771 | 37.761062417298604 | -122.446689671322 | (37.7610624172986, -122.446689671322) | |||
| 124323 | 124323 | 50419 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1092 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47075 | 5995075.75606262 | 2091172.41961397 | 37.72167889686779 | -122.459113814718 | (37.7216788968678, -122.459113814718) | ||
| 125211 | 125211 | 9121 | DPW Maintained 3 | Olea Majestic Beauty :: 192 | 5809 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/2014 12:00:00 AM | 3 | 3X3 | 5988977.4434 | 2112551.26078 | 37.780027047554704 | -122.481758960972 | (37.7800270475547, -122.481758960972) | ||
| 127745 | 127745 | 50418 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1092 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47075 | 5995075.75606262 | 2091172.41961397 | 37.72167889686779 | -122.459113814718 | (37.7216788968678, -122.459113814718) | ||
| 128648 | 128648 | 50420 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1092 Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47075 | 5995075.75606262 | 2091172.41961397 | 37.72167889686779 | -122.459113814718 | (37.7216788968678, -122.459113814718) | ||
| 134661 | 134661 | 43940 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1431 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/29/2004 12:00:00 AM | 3 | Permit Number 47356 | 5988334.46944807 | 2105569.4402423 | 37.7608194885962 | -122.483471288135 | (37.7608194885962, -122.483471288135) | |
| 136077 | 136077 | 44800 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1535 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 0 | Permit Number 43894 | 5988358.78199344 | 2104862.73529885 | 37.7588804836103 | -122.48333539659299 | (37.7588804836103, -122.483335396593) | |
| 140518 | 140518 | 48018 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 2638 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45740 | 5991147.28700714 | 2097448.7639677 | 37.738685538766 | -122.47315085269399 | (37.738685538766, -122.473150852694) | ||
| 141414 | 141414 | 17883 | DPW Maintained 3 | Olea Majestic Beauty :: 192 | 2209 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/08/2012 12:00:00 AM | 4 | 3x3 | 6003372.2037857 | 2115179.8461354002 | 37.7880710509428 | -122.43214880428499 | (37.7880710509428, -122.432148804285) | ||
| 141793 | 141793 | 52962 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 701 Head St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48948 | 5993488.64835927 | 2090503.61064911 | 37.7197511413359 | -122.46455144360701 | (37.7197511413359, -122.464551443607) | ||
| 143791 | 143791 | 106214 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 585X BUSH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774310 | 6010854.4 | 2115853.2 | 37.790341292651 | -122.406309047916 | (37.790341292651, -122.406309047916) | |
| 144986 | 144986 | 109393 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1619X York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774922 | 6010432.1 | 2100253.4 | 37.7474841871266 | -122.40667037373899 | (37.7474841871266, -122.406670373739) |
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");