Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 975 | 975 | 251421 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 09/30/2014 01:37:00 PM | 3x3 | 6014268.0 | 2110701.0 | 37.776384889187796 | -122.394137287636 | (37.7763848891878, -122.394137287636) | ||
| 1665 | 1665 | 251650 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | |||||||||
| 2087 | 2087 | 252878 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6014268.0 | 2110701.0 | 37.776384889187796 | -122.394137287636 | (37.7763848891878, -122.394137287636) | |||
| 4620 | 4620 | 253639 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 4405 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 5993893.0 | 2114132.0 | 37.784651953064206 | -122.46486880251801 | (37.7846519530642, -122.464868802518) | |||
| 30541 | 30541 | 103924 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/1995 12:00:00 AM | 4x4 | 6013544.1 | 2119061.0 | 37.7992992444467 | -122.397227842585 | (37.7992992444467, -122.397227842585) | |||
| 42744 | 42744 | 113684 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 51510 | 51510 | 113673 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 76349 | 76349 | 113681 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 77378 | 77378 | 113565 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 77936 | 77936 | 73302 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900x Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/24/1999 12:00:00 AM | 5x5 | 6001563.0 | 2111524.0 | 37.7779302874148 | -122.438146331007 | (37.7779302874148, -122.438146331007) | |||
| 79130 | 79130 | 122733 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3203 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008384.0 | 2100540.0 | 37.7481563241105 | -122.41377286403 | (37.7481563241105, -122.41377286403) | ||||
| 80237 | 80237 | 113567 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 80473 | 80473 | 96517 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1975 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002736.0 | 2114050.0 | 37.7849326895546 | -122.434269149206 | (37.7849326895546, -122.434269149206) | ||||
| 80509 | 80509 | 110645 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 81474 | 81474 | 111053 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2059X MARKET ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6004434.0 | 2107851.0 | 37.76800798766929 | -122.427952728751 | (37.7680079876693, -122.427952728751) | ||||
| 82803 | 82803 | 102580 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2013 12:00:00 AM | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | |||
| 82862 | 82862 | 113568 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 83181 | 83181 | 113686 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 85232 | 85232 | 113670 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 86565 | 86565 | 91191 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 818 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52040 | 6006711.43287 | 2113326.5718900003 | 37.7831711713524 | -122.42046403454901 | (37.7831711713524, -122.420464034549) | |
| 86765 | 86765 | 122732 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3203 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008384.0 | 2100540.0 | 37.7481563241105 | -122.41377286403 | (37.7481563241105, -122.41377286403) | ||||
| 86914 | 86914 | 113682 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 87601 | 87601 | 96518 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1975 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002736.0 | 2114050.0 | 37.7849326895546 | -122.434269149206 | (37.7849326895546, -122.434269149206) | ||||
| 88679 | 88679 | 98554 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1630 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6006532.62844 | 2116048.76559 | 37.7906355665082 | -122.421275996977 | (37.7906355665082, -122.421275996977) | ||||
| 90513 | 90513 | 102577 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2013 12:00:00 AM | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | |||
| 90544 | 90544 | 113685 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 90883 | 90883 | 110015 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5996616.0 | 2116061.2 | 37.7901056424074 | -122.455587678197 | (37.7901056424074, -122.455587678197) | |||||
| 91095 | 91095 | 91190 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 818 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52040 | 6006711.43287 | 2113326.5718900003 | 37.7831711713524 | -122.42046403454901 | (37.7831711713524, -122.420464034549) | |
| 92120 | 92120 | 113674 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 92124 | 92124 | 109583 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400x 06TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011386.0 | 2111037.0 | 37.7771468605476 | -122.404130641378 | (37.7771468605476, -122.404130641378) | ||||
| 92544 | 92544 | 112383 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3250 CESAR CHAVEZ ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007972.0 | 2100641.0 | 37.7484105018638 | -122.415204699043 | (37.7484105018638, -122.415204699043) | ||||
| 92788 | 92788 | 28195 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 92877 | 92877 | 110644 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 93887 | 93887 | 113683 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 96584 | 96584 | 112382 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3250 CESAR CHAVEZ ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007972.0 | 2100641.0 | 37.7484105018638 | -122.415204699043 | (37.7484105018638, -122.415204699043) | ||||
| 96778 | 96778 | 110017 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5996616.0 | 2116061.2 | 37.7901056424074 | -122.455587678197 | (37.7901056424074, -122.455587678197) | |||||
| 97744 | 97744 | 113672 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 98042 | 98042 | 110643 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 98480 | 98480 | 113689 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 98816 | 98816 | 102575 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | ||||
| 98879 | 98879 | 73079 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/24/1999 12:00:00 AM | 5x5 | 6001526.55605734 | 2111478.46223961 | 37.77780317948721 | -122.438269140063 | (37.7778031794872, -122.438269140063) | |||
| 99911 | 99911 | 113677 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 101036 | 101036 | 96521 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1975 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002736.0 | 2114050.0 | 37.7849326895546 | -122.434269149206 | (37.7849326895546, -122.434269149206) | ||||
| 102665 | 102665 | 102582 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | ||||
| 103293 | 103293 | 102578 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2013 12:00:00 AM | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | |||
| 103638 | 103638 | 113680 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 103678 | 103678 | 108035 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 945 Market St | unknown : Cutout 12 | Tree 1 | DPW 2 | 3x3 | Permit Number 774370 | 6010085.9126699995 | 2113154.0076 | 37.782886937251796 | -122.408777465126 | (37.7828869372518, -122.408777465126) | ||||
| 105305 | 105305 | 104205 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 710X Brotherhood Way | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 770788 | 5991124.9259 | 2088065.41222 | 37.7129198985758 | -122.472544248538 | (37.7129198985758, -122.472544248538) | ||||
| 105736 | 105736 | 110016 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5996616.0 | 2116061.2 | 37.7901056424074 | -122.455587678197 | (37.7901056424074, -122.455587678197) | |||||
| 106234 | 106234 | 104536 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | ||||
| 107941 | 107941 | 113678 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 108853 | 108853 | 113675 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 109248 | 109248 | 113668 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 109302 | 109302 | 113562 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 111588 | 111588 | 113679 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 112734 | 112734 | 104535 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | ||||
| 113961 | 113961 | 104204 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 710X Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 770788 | 5991124.9259 | 2088065.41222 | 37.7129198985758 | -122.472544248538 | (37.7129198985758, -122.472544248538) | ||||
| 114785 | 114785 | 110640 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 116119 | 116119 | 110641 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 118377 | 118377 | 110639 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 118590 | 118590 | 113676 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 119126 | 119126 | 114048 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1676 MARKET ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4X4 | 6006227.0 | 2109799.0 | 37.7734580035574 | -122.421889319638 | (37.7734580035574, -122.421889319638) | ||||
| 120593 | 120593 | 102581 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | ||||
| 121576 | 121576 | 102579 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2013 12:00:00 AM | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | |||
| 122305 | 122305 | 74968 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 493 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2013 12:00:00 AM | 6x6 | Permit Number 769961 | 6011188.26118785 | 2118621.30079081 | 37.79796050165611 | -122.405348925503 | (37.7979605016561, -122.405348925503) | ||
| 123340 | 123340 | 113566 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 123624 | 123624 | 74830 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 493 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2013 12:00:00 AM | 6x6 | Permit Number 769961 | 6011188.26118785 | 2118621.30079081 | 37.79796050165611 | -122.405348925503 | (37.7979605016561, -122.405348925503) | ||
| 124147 | 124147 | 96519 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1975 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002736.0 | 2114050.0 | 37.7849326895546 | -122.434269149206 | (37.7849326895546, -122.434269149206) | ||||
| 125752 | 125752 | 113563 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 125964 | 125964 | 110638 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | |||||
| 126015 | 126015 | 113564 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 126816 | 126816 | 113688 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 127842 | 127842 | 110014 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5996616.0 | 2116061.2 | 37.7901056424074 | -122.455587678197 | (37.7901056424074, -122.455587678197) | |||||
| 139956 | 139956 | 96520 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1975 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002736.0 | 2114050.0 | 37.7849326895546 | -122.434269149206 | (37.7849326895546, -122.434269149206) | ||||
| 139962 | 139962 | 113687 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 140505 | 140505 | 113667 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 140512 | 140512 | 113669 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 140678 | 140678 | 111052 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2059X MARKET ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6004434.0 | 2107851.0 | 37.76800798766929 | -122.427952728751 | (37.7680079876693, -122.427952728751) | ||||
| 142499 | 142499 | 119625 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1797X Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4X4 | 6005740.867306 | 2109154.5344128003 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | ||||
| 142778 | 142778 | 104537 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | ||||
| 142793 | 142793 | 113671 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
| 142818 | 142818 | 103925 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/1995 12:00:00 AM | 4X4 | 6013544.1 | 2119061.0 | 37.7992992444467 | -122.397227842585 | (37.7992992444467, -122.397227842585) | |||
| 142960 | 142960 | 113569 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6014268.596778099 | 2110706.0699128 | 37.776398843196894 | -122.394135578218 | (37.7763988431969, -122.394135578218) | |||||
| 143044 | 143044 | 112381 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3250 CESAR CHAVEZ ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007972.0 | 2100641.0 | 37.7484105018638 | -122.415204699043 | (37.7484105018638, -122.415204699043) | ||||
| 145206 | 145206 | 102576 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | ||||
| 93292 | 93292 | 14172 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1797X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/1993 12:00:00 AM | 0 | 4X4 | 6005740.867306 | 2109154.5344128003 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | ||
| 23142 | 23142 | 14047 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1355 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/16/2011 12:00:00 AM | 1 | 4X4 | 6007641.877 | 2110957.1689 | 37.7767177508292 | -122.41707712263901 | (37.7767177508292, -122.417077122639) | ||
| 23278 | 23278 | 20252 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1880 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 6002754.504 | 2113860.9916 | 37.78441477059 | -122.43419161466801 | (37.78441477059, -122.434191614668) | |||
| 58727 | 58727 | 110212 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2978 CESAR CHAVEZ ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x4 | 6009700.7 | 2100638.5 | 37.7485006383082 | -122.409226689451 | (37.7485006383082, -122.409226689451) | ||||
| 128153 | 128153 | 110637 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200x DRUMM ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 6013666.0 | 2117675.0 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | ||||
| 418 | 418 | 23307 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/2014 12:00:00 AM | 2 | 3x3 | 6006542.6232900005 | 2114014.0044299997 | 37.785049178209206 | -122.421096875635 | (37.7850491782092, -122.421096875635) | ||
| 4574 | 4574 | 133622 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 45 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2014 02:11:00 PM | 2 | Width 3ft | 5999573.26075 | 2119295.26208 | 37.799154775636296 | -122.44558848973499 | (37.7991547756363, -122.445588489735) | ||
| 4977 | 4977 | 9927 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2010 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/2013 12:00:00 AM | 2 | 3x3 | 6005187.26248 | 2116638.45302 | 37.792178759685896 | -122.42597288644899 | (37.7921787596859, -122.425972886449) | ||
| 7084 | 7084 | 13768 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 870 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 4X4 | 6010591.78264 | 2113879.97345 | 37.7849085890159 | -122.40707854485201 | (37.7849085890159, -122.407078544852) | |||
| 8385 | 8385 | 13456 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 4X4 | 6013856.99519 | 2117057.08374 | 37.7938143782887 | -122.396004602544 | (37.7938143782887, -122.396004602544) | |||
| 13574 | 13574 | 14051 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1355 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/16/2011 12:00:00 AM | 2 | 4x4 | 6007746.8123 | 2111061.1756 | 37.7770092309043 | -122.41672148930799 | (37.7770092309043, -122.416721489308) | ||
| 13589 | 13589 | 14052 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1355 Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 4X4 | 6007772.813999999 | 2111082.5341 | 37.7770693386485 | -122.416633054532 | (37.7770693386485, -122.416633054532) | |||
| 14445 | 14445 | 14057 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1355 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2004 12:00:00 AM | 2 | 4x4 | 6007614.9467 | 2110932.0959 | 37.776647391378496 | -122.417168505674 | (37.7766473913785, -122.417168505674) | ||
| 14522 | 14522 | 14049 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1355 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2004 12:00:00 AM | 2 | 4x4 | 6007698.5235 | 2111010.1009 | 37.776866275909796 | -122.416884916186 | (37.7768662759098, -122.416884916186) | ||
| 15494 | 15494 | 14056 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1355 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 4x4 | 6007584.534 | 2110905.1656 | 37.7765717362345 | -122.417271803551 | (37.7765717362345, -122.417271803551) |
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");