trees
86 rows where qSpecies_id = 183
This data as json, CSV (advanced)
| rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1370 | 49770 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 333 Schwerin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | Permit Number 46559 | 6008566.26332194 | 2086145.27295548 | 37.7086417136506 | -122.412125425298 | (37.7086417136506, -122.412125425298) | 9 | 7 | 8 | 309 | 39 | ||
| 3283 | 48026 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 927 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45744 | 5991172.8529559 | 2102455.75823322 | 37.7524349314894 | -122.473427563174 | (37.7524349314894, -122.473427563174) | 1 | 8 | 4 | 29491 | 12 | ||
| 4686 | 109392 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1619X York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774922 | 6010432.1 | 2100253.4 | 37.7474841871266 | -122.406670373739 | (37.7474841871266, -122.406670373739) | 2 | 7 | 7 | 28859 | 2 |
| 4912 | 261377 | Planning Code 138.1 required 2 | Olea Majestic Beauty :: 183 | 3015 25th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 4x10 | Permit Number 784883 | 5988814.87181 | 2095155.07295 | 37.7322523337557 | -122.481047245899 | (37.7322523337557, -122.481047245899) | 1 | 8 | 4 | 64 | 35 | |
| 5515 | 84808 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 604 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49309 | 6011773 | 2105570 | 37.7621573346125 | -122.402407376212 | (37.7621573346125, -122.402407376212) | 10 | 3 | 8 | 28856 | 29 | |||
| 9262 | 233724 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 4636 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787678 | 6000480.53281 | 2104663.5524 | 37.7590315899554 | -122.441398558215 | (37.7590315899554, -122.441398558215) | 2 | 4 | 5 | 28862 | 3 | |
| 9668 | 264919 | Property Tree 8 | Olea Majestic Beauty :: 183 | 1833 Page St | 1 | Sidewalk: Property side : Yard | Tree | Public Library 12 | 3x3 | 5997789 | 2108763 | 37.7701339345343 | -122.451002717521 | (37.7701339345343, -122.451002717521) | 15 | 5 | 11 | 29492 | 9 | ||||
| 10078 | 51848 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 813 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48072 | 5998616.0895613 | 2107512.49914502 | 37.7667476925096 | -122.44805178449 | (37.7667476925096, -122.44805178449) | 15 | 5 | 11 | 29492 | 9 | |||
| 12349 | 233723 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 4636 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787678 | 6000465.02654 | 2104660.92765 | 37.7590234996596 | -122.441451997735 | (37.7590234996596, -122.441451997735) | 2 | 4 | 5 | 28862 | 3 | |
| 17839 | 135721 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 2498X Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 779691 | 6001734 | 2116823 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | 13 | 6 | 1 | 29490 | 27 | |
| 17863 | 261376 | Planning Code 138.1 required 2 | Olea Majestic Beauty :: 183 | 3015 25th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 4x10 | Permit Number 784883 | 5988814.87181 | 2095155.07295 | 37.7322523337557 | -122.481047245899 | (37.7322523337557, -122.481047245899) | 1 | 8 | 4 | 64 | 35 | |
| 20272 | 51901 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 10 Carmel St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48109 | 5998966.66978018 | 2105434.62940771 | 37.7610624172986 | -122.446689671322 | (37.7610624172986, -122.446689671322) | 15 | 5 | 11 | 29492 | 12 | |||
| 20439 | 43940 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 1431 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2004 12:00:00 AM | 3 | Permit Number 47356 | 5988334.46944807 | 2105569.4402423 | 37.7608194885962 | -122.483471288135 | (37.7608194885962, -122.483471288135) | 1 | 8 | 3 | 56 | 35 | |
| 24145 | 50418 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1092 Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47075 | 5995075.75606262 | 2091172.41961397 | 37.7216788968678 | -122.459113814718 | (37.7216788968678, -122.459113814718) | 9 | 8 | 6 | 28861 | 24 | ||
| 26087 | 9121 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 5809 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/2014 12:00:00 AM | 3 | 3X3 | 5988977.4434 | 2112551.26078 | 37.7800270475547 | -122.481758960972 | (37.7800270475547, -122.481758960972) | 11 | 6 | 2 | 55 | 26 | ||
| 32964 | 49766 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 333 Schwerin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | Permit Number 46559 | 6008566.26332194 | 2086145.27295548 | 37.7086417136506 | -122.412125425298 | (37.7086417136506, -122.412125425298) | 9 | 7 | 8 | 309 | 39 | ||
| 33004 | 50420 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1092 Capitol Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47075 | 5995075.75606262 | 2091172.41961397 | 37.7216788968678 | -122.459113814718 | (37.7216788968678, -122.459113814718) | 9 | 8 | 6 | 28861 | 24 | ||
| 33100 | 50419 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1092 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47075 | 5995075.75606262 | 2091172.41961397 | 37.7216788968678 | -122.459113814718 | (37.7216788968678, -122.459113814718) | 9 | 8 | 6 | 28861 | 24 | ||
| 34669 | 244041 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 400 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998430.346 | 2109186.6154 | 37.7713337703654 | -122.44881483539 | (37.7713337703654, -122.44881483539) | 15 | 5 | 11 | 29492 | 9 | |||
| 35575 | 48027 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1311 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45745 | 5992008.68570265 | 2098400.45709107 | 37.7413484836963 | -122.470241856121 | (37.7413484836963, -122.470241856121) | 1 | 8 | 4 | 59 | 40 | ||
| 38645 | 39800 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1920 41st Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 39952 | 51900 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 10 Carmel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48109 | 5998966.66978018 | 2105434.62940771 | 37.7610624172986 | -122.446689671322 | (37.7610624172986, -122.446689671322) | 15 | 5 | 11 | 29492 | 12 | |||
| 41053 | 48998 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 172 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/2002 12:00:00 AM | Permit Number 46185 | 6004821.78713079 | 2098737.69614262 | 37.743006921807 | -122.425962607538 | (37.743006921807, -122.425962607538) | 2 | 7 | 5 | 63 | 22 | ||
| 48935 | 51898 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 10 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48109 | 5998966.66978018 | 2105434.62940771 | 37.7610624172986 | -122.446689671322 | (37.7610624172986, -122.446689671322) | 15 | 5 | 11 | 29492 | 12 | |||
| 50686 | 47704 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 125 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45500 | 6002654.19286093 | 2096771.9016546 | 37.7374865643804 | -122.433317110941 | (37.7374865643804, -122.433317110941) | 2 | 7 | 5 | 63 | 7 | ||
| 51541 | 50888 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 2171 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47397 | 5991295.6388277 | 2100646.5391186 | 37.7474743961381 | -122.472871039952 | (37.7474743961381, -122.472871039952) | 1 | 8 | 4 | 29491 | 40 | ||
| 52759 | 44800 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 1535 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | 0 | Permit Number 43894 | 5988358.78199344 | 2104862.73529885 | 37.7588804836103 | -122.483335396593 | (37.7588804836103, -122.483335396593) | 1 | 8 | 3 | 56 | 35 | |
| 57773 | 39804 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1920 41st Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 57899 | 39803 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1920 41st Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 58243 | 109770 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 9 Pomona St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/29/2015 12:00:00 AM | 6x7 | Permit Number 774437 | 6014227.8 | 2094671.9 | 37.7323701819213 | -122.393154495945 | (37.7323701819213, -122.393154495945) | 10 | 3 | 8 | 58 | 1 | ||
| 59773 | 114786 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 2578 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2015 12:00:00 AM | Permit Number 773268 | 6000282.5 | 2114132.7 | 37.7850201993277 | -122.442763385723 | (37.7850201993277, -122.442763385723) | 15 | 6 | 1 | 29490 | 27 | |||
| 59774 | 50799 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 2118 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47858 | 6003464.5437447 | 2107159.58616463 | 37.766054639862 | -122.431256610846 | (37.766054639862, -122.431256610846) | 15 | 5 | 5 | 28862 | 3 | |||
| 64211 | 50625 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 2201(REVISED) Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2003 12:00:00 AM | Permit Number 47221 | 6004201.40424147 | 2116358.26582712 | 37.7913536714136 | -122.429363982602 | (37.7913536714136, -122.429363982602) | 13 | 9 | 1 | 29490 | 27 | |||
| 66773 | 244057 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 408 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998433.3367 | 2109162.2622 | 37.7712670737259 | -122.448802736045 | (37.7712670737259, -122.448802736045) | 15 | 5 | 11 | 29492 | 9 | |||
| 69303 | 39794 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1920 41st Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 69742 | 51899 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 10 Carmel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48109 | 5998966.66978018 | 2105434.62940771 | 37.7610624172986 | -122.446689671322 | (37.7610624172986, -122.446689671322) | 15 | 5 | 11 | 29492 | 12 | |||
| 74122 | 49031 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 461 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2003 12:00:00 AM | Permit Number 46207 | 5993806.4454161 | 2101759.79287074 | 37.7506761426139 | -122.464269712533 | (37.7506761426139, -122.464269712533) | 1 | 8 | 4 | 29491 | 40 | |||
| 76836 | 45489 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 2974 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | Permit Number 44267 | 5990023.24329649 | 2095462.47812983 | 37.7331665606888 | -122.476892129437 | (37.7331665606888, -122.476892129437) | 1 | 8 | 4 | 64 | 35 | ||
| 78375 | 109036 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 2422 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773529 | 5987396.7 | 2098769.6 | 37.7420943335288 | -122.486215376652 | (37.7420943335288, -122.486215376652) | 1 | 8 | 3 | 29491 | 35 |
| 79775 | 251140 | Planning Code 138.1 required 2 | Olea Majestic Beauty :: 183 | 138 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996904.98449 | 2113495.29925 | 37.783076941712 | -122.454402393245 | (37.783076941712, -122.454402393245) | 11 | 6 | 1 | 54 | 31 | ||||
| 81366 | 45202 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 222 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2001 12:00:00 AM | Permit Number 44046 | 5987941.71158977 | 2115357.18116388 | 37.7876710228878 | -122.485547954085 | (37.7876710228878, -122.485547954085) | 11 | 6 | 1 | 55 | 33 | |||
| 83718 | 125086 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 2498X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2018 12:00:00 AM | 3 | Width 4ft | 6001776 | 2116945 | 37.7928270792484 | -122.437797852893 | (37.7928270792484, -122.437797852893) | 13 | 6 | 1 | 29490 | 27 | ||
| 84736 | 244042 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 400 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998428.637 | 2109205.8416 | 37.7713864628664 | -122.448822131958 | (37.7713864628664, -122.448822131958) | 15 | 5 | 11 | 29492 | 9 | |||
| 86245 | 63366 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1999 12:00:00 AM | Permit Number 41545 | 6006308.21143459 | 2096885.36921844 | 37.7380047408881 | -122.420691480393 | (37.7380047408881, -122.420691480393) | 2 | 7 | 7 | 28859 | 2 | ||
| 86488 | 108914 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 14 Joy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772971 | 6010371.9 | 2098925.3 | 37.7438341457577 | -122.406784957727 | (37.7438341457577, -122.406784957727) | 2 | 7 | 7 | 28859 | 2 |
| 89818 | 39802 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1920 41st Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 92893 | 47989 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 2546 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45721 | 5991761.63478074 | 2098099.13967132 | 37.7405068566293 | -122.471074117371 | (37.7405068566293, -122.471074117371) | 1 | 8 | 4 | 59 | 40 | ||
| 96273 | 45266 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 573 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45996 | 6008563.2074273 | 2096175.03546928 | 37.7361811545865 | -122.412844610652 | (37.7361811545865, -122.412844610652) | 10 | 7 | 7 | 28859 | 2 | ||
| 98819 | 50624 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 2201(REVISED) Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2003 12:00:00 AM | Permit Number 47221 | 6004201.40424147 | 2116358.26582712 | 37.7913536714136 | -122.429363982602 | (37.7913536714136, -122.429363982602) | 13 | 9 | 1 | 29490 | 27 | |||
| 98999 | 48921 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 2612 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46111 | 6011124.42622162 | 2101850.32474835 | 37.7519077045726 | -122.40438872766 | (37.7519077045726, -122.40438872766) | 10 | 4 | 8 | 28859 | 19 | ||
| 100170 | 50916 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 2354 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47418 | 5990770.82550859 | 2099372.08880505 | 37.7439446897673 | -122.474592794399 | (37.7439446897673, -122.474592794399) | 1 | 8 | 4 | 29491 | 40 | ||
| 100316 | 49520 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 3850@ CHURCH 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/2003 12:00:00 AM | Permit Number 46427 | 6004849.52312029 | 2100786.51985424 | 37.7486340888052 | -122.42601252142 | (37.7486340888052, -122.42601252142) | 2 | 4 | 5 | 28862 | 22 | ||
| 103084 | 51902 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 10 Carmel St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48109 | 5998966.66978018 | 2105434.62940771 | 37.7610624172986 | -122.446689671322 | (37.7610624172986, -122.446689671322) | 15 | 5 | 11 | 29492 | 12 | |||
| 104760 | 51241 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1527 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47611 | 6000120.99232637 | 2114156.28818959 | 37.7850757578449 | -122.443323844133 | (37.7850757578449, -122.443323844133) | 15 | 6 | 1 | 29490 | 31 | ||
| 112547 | 49634 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 118@ HOLLAWAY Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2003 12:00:00 AM | Permit Number 47124 | 5995362.36867696 | 2090698.75234074 | 37.7203947919527 | -122.458088814243 | (37.7203947919527, -122.458088814243) | 9 | 8 | 6 | 28861 | 24 | ||
| 117174 | 48920 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 2612 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46111 | 6011124.42622162 | 2101850.32474835 | 37.7519077045726 | -122.40438872766 | (37.7519077045726, -122.40438872766) | 10 | 4 | 8 | 28859 | 19 | ||
| 118881 | 50421 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1092 Capitol Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47075 | 5995075.75606262 | 2091172.41961397 | 37.7216788968678 | -122.459113814718 | (37.7216788968678, -122.459113814718) | 9 | 8 | 6 | 28861 | 24 | ||
| 122317 | 46129 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 886 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2001 12:00:00 AM | Permit Number 44479 | 5999201.43690268 | 2107178.82505375 | 37.7658649503447 | -122.44600317189 | (37.7658649503447, -122.44600317189) | 15 | 5 | 5 | 29492 | 9 | ||
| 124616 | 244045 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 400 Clayton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998420.092 | 2109262.2384 | 37.7715408254049 | -122.448855752375 | (37.7715408254049, -122.448855752375) | 15 | 5 | 11 | 29492 | 9 | |||
| 128447 | 252851 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 100X Langton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | Permit Number 780604 | 6010166 | 2110701 | 37.776156040571 | -122.408327321329 | (37.776156040571, -122.408327321329) | 8 | 2 | 9 | 28853 | 34 | |||
| 128806 | 39801 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1920 41st Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 130494 | 40460 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/1999 12:00:00 AM | Permit Number 41545 | 6006308.21143459 | 2096885.36921844 | 37.7380047408881 | -122.420691480393 | (37.7380047408881, -122.420691480393) | 2 | 7 | 7 | 28859 | 2 | |||
| 133654 | 50417 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1092 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47075 | 5995075.75606262 | 2091172.41961397 | 37.7216788968678 | -122.459113814718 | (37.7216788968678, -122.459113814718) | 9 | 8 | 6 | 28861 | 24 | ||
| 134064 | 48025 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 927 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45744 | 5991172.8529559 | 2102455.75823322 | 37.7524349314894 | -122.473427563174 | (37.7524349314894, -122.473427563174) | 1 | 8 | 4 | 29491 | 12 | ||
| 140787 | 48982 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 3971 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2002 12:00:00 AM | Permit Number 46169 | 6004077.4019356 | 2100692.01440883 | 37.7483309307307 | -122.428675772155 | (37.7483309307307, -122.428675772155) | 2 | 4 | 5 | 63 | 22 | ||
| 142248 | 45490 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 2974 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | Permit Number 44267 | 5990023.24329649 | 2095462.47812983 | 37.7331665606888 | -122.476892129437 | (37.7331665606888, -122.476892129437) | 1 | 8 | 4 | 64 | 35 | ||
| 142696 | 49032 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 461 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2003 12:00:00 AM | Permit Number 46207 | 5993806.4454161 | 2101759.79287074 | 37.7506761426139 | -122.464269712533 | (37.7506761426139, -122.464269712533) | 1 | 8 | 4 | 29491 | 40 | |||
| 142771 | 109395 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1619X York St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774922 | 6010432.1 | 2100253.4 | 37.7474841871266 | -122.406670373739 | (37.7474841871266, -122.406670373739) | 2 | 7 | 7 | 28859 | 2 |
| 145107 | 50886 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 2151 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47395 | 5991291.12356149 | 2100776.95734171 | 37.7478322293855 | -122.472896161814 | (37.7478322293855, -122.472896161814) | 1 | 8 | 4 | 29491 | 40 | ||
| 146804 | 47854 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 1318 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 2 | Permit Number 45613 | 5982778.81660668 | 2106137.43065428 | 37.7620541098462 | -122.502727551098 | (37.7620541098462, -122.502727551098) | 1 | 8 | 3 | 56 | 35 | |
| 149851 | 50915 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 2354 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47418 | 5990770.82550859 | 2099372.08880505 | 37.7439446897673 | -122.474592794399 | (37.7439446897673, -122.474592794399) | 1 | 8 | 4 | 29491 | 40 | ||
| 153959 | 244044 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 400 Clayton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998422.6555 | 2109243.8667 | 37.7714905280118 | -122.448845561582 | (37.7714905280118, -122.448845561582) | 15 | 5 | 11 | 29492 | 9 | |||
| 155951 | 251723 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 22 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996653 | 2088721 | 37.7150384191871 | -122.453484821913 | (37.7150384191871, -122.453484821913) | 9 | 8 | 6 | 28861 | 24 | ||||
| 158742 | 244043 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 400 Clayton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998423.9372 | 2109224.2133 | 37.7714366380954 | -122.448839712257 | (37.7714366380954, -122.448839712257) | 15 | 5 | 11 | 29492 | 9 | |||
| 159704 | 109394 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1619X York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774922 | 6010432.1 | 2100253.4 | 37.7474841871266 | -122.406670373739 | (37.7474841871266, -122.406670373739) | 2 | 7 | 7 | 28859 | 2 |
| 163148 | 50889 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 2183 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47399 | 5991298.34798675 | 2100568.28820424 | 37.7472596962302 | -122.472855966955 | (37.7472596962302, -122.472855966955) | 1 | 8 | 4 | 29491 | 40 | ||
| 165125 | 42971 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 1150 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780074 | 6008001.65221 | 2092059.65812 | 37.724849680043 | -122.414495024431 | (37.724849680043, -122.414495024431) | 9 | 3 | 7 | 309 | 28 | |
| 166828 | 45293 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 117 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44132 | 6007166.24761126 | 2096811.6959344 | 37.7378507726133 | -122.417719597387 | (37.7378507726133, -122.417719597387) | 2 | 7 | 7 | 28859 | 2 | ||
| 171648 | 17883 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 2209 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2012 12:00:00 AM | 4 | 3x3 | 6003372.2037857 | 2115179.8461354 | 37.7880710509428 | -122.432148804285 | (37.7880710509428, -122.432148804285) | 13 | 9 | 11 | 29490 | 27 | ||
| 173159 | 106214 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 585X BUSH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774310 | 6010854.4 | 2115853.2 | 37.790341292651 | -122.406309047916 | (37.790341292651, -122.406309047916) | 5 | 1 | 10 | 28857 | 6 | |
| 176141 | 143043 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 443 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:20:00 AM | 15 | Width 0ft | 6010277.7096 | 2120592.1376 | 37.8033209840901 | -122.408638812993 | (37.8033209840901, -122.408638812993) | 3 | 1 | 10 | 308 | 23 | ||
| 176152 | 48018 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 2638 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45740 | 5991147.28700714 | 2097448.7639677 | 37.738685538766 | -122.473150852694 | (37.738685538766, -122.473150852694) | 1 | 8 | 4 | 29491 | 40 | ||
| 180774 | 52962 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 701 Head St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48948 | 5993488.64835927 | 2090503.61064911 | 37.7197511413359 | -122.464551443607 | (37.7197511413359, -122.464551443607) | 9 | 8 | 6 | 64 | 24 | ||
| 194120 | 109393 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 1619X York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774922 | 6010432.1 | 2100253.4 | 37.7474841871266 | -122.406670373739 | (37.7474841871266, -122.406670373739) | 2 | 7 | 7 | 28859 | 2 |
| 194324 | 163428 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 416 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 0 | 4x6 | 5995056.18363 | 2088509.02002 | 37.7143647082391 | -122.458988723675 | (37.7143647082391, -122.458988723675) | 9 | 8 | 6 | 28861 | 24 | ||
| 194379 | 68392 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 240 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779249 | 6001623.41455 | 2093933.04413 | 37.7296331848184 | -122.436677841421 | (37.7296331848184, -122.436677841421) | 9 | 7 | 6 | 28861 | 25 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );