Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23085 | 23085 | 11553 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 29 | 3X3 | 6018940.8378099995 | 2097294.9489700003 | 37.7398332568108 | -122.377042159778 | (37.7398332568108, -122.377042159778) | ||
| 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) | ||
| 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) | |
| 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) | |
| 70753 | 70753 | 206290 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 519 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1989 12:00:00 AM | 13 | Width 3ft | Permit Number 28366 | 5994747.213769999 | 2092021.25084 | 37.7239906908132 | -122.460310960879 | (37.7239906908132, -122.460310960879) | |
| 7223 | 7223 | 10658 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 957 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3x3 | 6003278.1745 | 2110658.3168 | 37.7756507331964 | -122.43215110447599 | (37.7756507331964, -122.432151104476) | ||
| 792 | 792 | 199372 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2 Newhall St | 2 | : 4 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 15 | Width 3ft | Permit Number 774049 | 6018530.30847 | 2097200.55685 | 37.7395514542225 | -122.37845506126499 | (37.7395514542225, -122.378455061265) | |
| 85383 | 85383 | 11265 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1176X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1992 12:00:00 AM | 20 | 3X3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | ||
| 23295 | 23295 | 9894 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/1997 12:00:00 AM | 23 | 3X3 | 6005329.1496 | 2115601.42673 | 37.7893393634754 | -122.425408122112 | (37.7893393634754, -122.425408122112) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||
| 90620 | 90620 | 116853 | Planning Code 138.1 required 4 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | 3X3 | Permit Number 773331 | 6005973.81147 | 2115593.81965 | 37.7893548777914 | -122.423177122971 | (37.7893548777914, -122.423177122971) | |
| 95123 | 95123 | 17757 | Planning Code 138.1 required 4 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773331 | 6005917.49192 | 2115584.99362 | 37.7893274652545 | -122.42337135467699 | (37.7893274652545, -122.423371354677) | |
| 109130 | 109130 | 119808 | Planning Code 138.1 required 4 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773331 | 6006048.0 | 2115627.0 | 37.789450169199796 | -122.422922798032 | (37.7894501691998, -122.422922798032) | |
| 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) | ||
| 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) | |
| 6636 | 6636 | 2588 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1710 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1999 12:00:00 AM | 18 | 3 | 6005206.687000001 | 2115142.0135 | 37.788071009916 | -122.42579911500499 | (37.788071009916, -122.425799115005) | ||
| 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) | ||
| 15190 | 15190 | 3701 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/12/2000 12:00:00 AM | 3 | 3X3 | 6016463.92851 | 2099311.9747200003 | 37.745234858406 | -122.385746898422 | (37.745234858406, -122.385746898422) | ||
| 15631 | 15631 | 3715 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/1996 12:00:00 AM | 3 | 3X3 | 6016713.472019999 | 2099127.09165 | 37.744741012786896 | -122.38487113321699 | (37.7447410127869, -122.384871133217) | ||
| 122202 | 122202 | 11556 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 830X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/1996 12:00:00 AM | 18 | 3X3 | 6015938.87476 | 2096683.24967 | 37.737987849284394 | -122.387379118862 | (37.7379878492844, -122.387379118862) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 95268 | 95268 | 11318 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1216X Ingalls St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/1990 12:00:00 AM | 60 | 3X3 | 6017561.7867095005 | 2093983.7658262001 | 37.7306653497809 | -122.38158017208 | (37.7306653497809, -122.38158017208) | ||
| 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) | |||
| 85513 | 85513 | 11303 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1201X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/1993 12:00:00 AM | 40 | 3X3 | 6017591.0151778 | 2093928.8426978001 | 37.7305161553992 | -122.38147530581499 | (37.7305161553992, -122.381475305815) | ||
| 96922 | 96922 | 11305 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1201X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/1993 12:00:00 AM | 40 | 3X3 | 6017591.0151778 | 2093928.8426978001 | 37.7305161553992 | -122.38147530581499 | (37.7305161553992, -122.381475305815) | ||
| 101060 | 101060 | 11326 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1223 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/1993 12:00:00 AM | 50 | 3X3 | 6017540.6929483 | 2093936.3628531997 | 37.730534025837706 | -122.38164980170299 | (37.7305340258377, -122.381649801703) | ||
| 124644 | 124644 | 11327 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1223 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/1993 12:00:00 AM | 40 | 3X3 | 6017540.6929483 | 2093936.3628531997 | 37.730534025837706 | -122.38164980170299 | (37.7305340258377, -122.381649801703) | ||
| 1068 | 1068 | 11520 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2017 12:00:00 AM | 6 | 3X3 | 6018495.90717 | 2096693.85175 | 37.738158246093 | -122.378538834904 | (37.738158246093, -122.378538834904) | ||
| 7523 | 7523 | 87408 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2400X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 6005843.02152 | 2118712.53051 | 37.7979106921903 | -122.42385149366501 | (37.7979106921903, -122.423851493665) | ||
| 103086 | 103086 | 11230 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1050X Ingalls St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/13/1990 12:00:00 AM | 45 | 3X4 | 6018085.661882901 | 2094069.8743192002 | 37.7309306978843 | -122.379775016493 | (37.7309306978843, -122.379775016493) | ||
| 111415 | 111415 | 11292 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1199X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/13/1990 12:00:00 AM | 30 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | ||
| 16927 | 16927 | 24534 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 128 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/1996 12:00:00 AM | 8 | 3X3 | 6006387.02802 | 2097608.2195099997 | 37.7399939683457 | -122.420470266705 | (37.7399939683457, -122.420470266705) | ||
| 37403 | 37403 | 11269 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1176X Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/1990 12:00:00 AM | 3 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | ||
| 94 | 94 | 201404 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1051 Ingalls St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1990 12:00:00 AM | 14 | Width 3ft | 6018112.6185 | 2094686.77545 | 37.732626074632705 | -122.379724665662 | (37.7326260746327, -122.379724665662) | ||
| 128599 | 128599 | 11231 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1050X Ingalls St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/1990 12:00:00 AM | 50 | 3X4 | 6018085.661882901 | 2094069.8743192002 | 37.7309306978843 | -122.379775016493 | (37.7309306978843, -122.379775016493) | ||
| 4294 | 4294 | 248325 | 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 | 19 | Width 0ft | Permit Number 17699 | 5998266.3488 | 2108214.611 | 37.7686555147255 | -122.44931206435 | (37.7686555147255, -122.44931206435) | |
| 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) | ||
| 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) | |
| 14867 | 14867 | 3710 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1990 12:00:00 AM | 12 | 3X3 | 6016627.8913900005 | 2099188.4950200003 | 37.7449048800496 | -122.385171335 | (37.7449048800496, -122.385171335) | ||
| 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) | |||
| 124037 | 124037 | 10826 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1139X Hudson Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1990 12:00:00 AM | 12 | 3X4 | 6017834.53501 | 2094620.0550099998 | 37.732427530713004 | -122.380681442077 | (37.732427530713, -122.380681442077) | ||
| 2951 | 2951 | 246120 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1285 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 17 | Width 0ft | Permit Number 17675 | 5999562.003 | 2108407.0589 | 37.769257954715705 | -122.44484435027799 | (37.7692579547157, -122.444844350278) | |
| 3022 | 3022 | 246073 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1209 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 18 | Width 0ft | Permit Number 17669 | 5999896.6292 | 2108453.3917 | 37.7694042640863 | -122.44369022814199 | (37.7694042640863, -122.443690228142) | |
| 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) | ||
| 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) | ||
| 2574 | 2574 | 139639 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/1997 12:00:00 AM | 22 | Width 0ft | 6001669.0 | 2112367.0 | 37.7802509803634 | -122.437840034507 | (37.7802509803634, -122.437840034507) | ||
| 16643 | 16643 | 3702 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/1990 12:00:00 AM | 12 | 3X3 | 6016478.46508 | 2099300.03196 | 37.7452028704157 | -122.385695800734 | (37.7452028704157, -122.385695800734) | ||
| 20112 | 20112 | 29963 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 500X Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3x3 | 5991394.8537099995 | 2093447.95886 | 37.7277146673841 | -122.47200336878099 | (37.7277146673841, -122.472003368781) | ||
| 14752 | 14752 | 3664 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 100 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017168.62408 | 2098888.98032 | 37.744112371380204 | -122.383280718132 | (37.7441123713802, -122.383280718132) | ||
| 15773 | 15773 | 3675 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 111 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016978.81066 | 2099030.1280400003 | 37.74448944274229 | -122.383946883753 | (37.7444894427423, -122.383946883753) | ||
| 16743 | 16743 | 3677 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 113 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3x3 | 6016945.8178 | 2099054.7063700003 | 37.7445551058345 | -122.38406267865801 | (37.7445551058345, -122.384062678658) | ||
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |||
| 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) | |||
| 16854 | 16854 | 11488 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/1993 12:00:00 AM | 6 | 4X4 | 6018872.157000001 | 2097296.32677 | 37.7398332567899 | -122.377279727371 | (37.7398332567899, -122.377279727371) | ||
| 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) | |
| 106 | 106 | 10645 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 906 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6003455.1435 | 2110726.9996 | 37.775849351151706 | -122.431543829861 | (37.7758493511517, -122.431543829861) | |||
| 433 | 433 | 251301 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 2 | Back Yard : Yard 13 | Tree 1 | Mayor Office of Housing 7 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 474 | 474 | 251300 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 1150 | 1150 | 246081 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1390 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 5999109.7278 | 2108387.5264 | 37.769178502070204 | -122.44640733565201 | (37.7691785020702, -122.446407335652) | |||
| 1153 | 1153 | 17806 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1881 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6004903.5356 | 2115394.9801 | 37.7887484569995 | -122.42686598915199 | (37.7887484569995, -122.426865989152) | |||
| 1197 | 1197 | 224424 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2500X Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002246.98159 | 2097281.36199 | 37.738862314555 | -122.43476145089501 | (37.738862314555, -122.434761450895) | |||
| 1520 | 1520 | 199389 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 16 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 4ft | 6017439.78771 | 2096071.60272 | 37.7363914002406 | -122.38214713169901 | (37.7363914002406, -122.382147131699) | |||
| 1843 | 1843 | 9890 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005344.337040001 | 2115550.48459 | 37.7892003471598 | -122.42535194865299 | (37.7892003471598, -122.425351948653) | |||
| 2071 | 2071 | 252870 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 716 McAllister St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | ||||
| 2557 | 2557 | 139640 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 0ft | 6001669.0 | 2112367.0 | 37.7802509803634 | -122.437840034507 | (37.7802509803634, -122.437840034507) | |||
| 2560 | 2560 | 138642 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3059 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 0ft | 5999277.8969 | 2114611.151 | 37.7862765793233 | -122.446273410182 | (37.7862765793233, -122.446273410182) | |||
| 2566 | 2566 | 139641 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | Width 0ft | 6001669.0 | 2112367.0 | 37.7802509803634 | -122.437840034507 | (37.7802509803634, -122.437840034507) | |||
| 2569 | 2569 | 139637 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6001520.6292 | 2112190.4921 | 37.7797578963919 | -122.438340667374 | (37.7797578963919, -122.438340667374) | |||
| 3087 | 3087 | 19650 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 3849 | 3849 | 10659 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 957 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6003302.5458 | 2110662.7479 | 37.775664281642 | -122.43206711469601 | (37.775664281642, -122.432067114696) | |||
| 3956 | 3956 | 15038 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1017 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6015648.0 | 2096190.0 | 37.7366173719863 | -122.388350408836 | (37.7366173719863, -122.388350408836) | |||
| 4178 | 4178 | 246147 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1504 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998476.2094 | 2108299.706 | 37.768901165807705 | -122.448592305739 | (37.7689011658077, -122.448592305739) | |||
| 4228 | 4228 | 248327 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5998303.294 | 2108219.7591 | 37.768671763303104 | -122.449184645334 | (37.7686717633031, -122.449184645334) | |||
| 4288 | 4288 | 248328 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5998322.9779 | 2108222.7874 | 37.768681204074895 | -122.44911677876101 | (37.7686812040749, -122.449116778761) | |||
| 4299 | 4299 | 248326 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998285.1242 | 2108217.0336 | 37.768663240508 | -122.44924729658001 | (37.768663240508, -122.44924729658) | |||
| 4566 | 4566 | 176382 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2112 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 3ft | 6011978.0 | 2087840.0 | 37.7134859388755 | -122.40045291074101 | (37.7134859388755, -122.400452910741) | |||
| 4693 | 4693 | 253655 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1048 Ingalls St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6018024.0 | 2094000.0 | 37.7307354351655 | -122.379983340658 | (37.7307354351655, -122.379983340658) | ||||
| 4862 | 4862 | 19656 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 55 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 5348 | 5348 | 26872 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 969 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003227.2163 | 2110650.5623 | 37.7756265519671 | -122.432326827371 | (37.7756265519671, -122.432326827371) | |||
| 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) | ||
| 5896 | 5896 | 19680 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 5976 | 5976 | 19649 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST |
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");