Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 142399 | 142399 | 36233 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5698 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | 3x3 | Permit Number 39264 | 5997821.10019036 | 2086869.6666529 | 37.710021971633296 | -122.449314082525 | (37.7100219716333, -122.449314082525) | ||
| 144595 | 144595 | 36235 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5698 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39264 | 5997821.10019036 | 2086869.6666529 | 37.710021971633296 | -122.449314082525 | (37.7100219716333, -122.449314082525) | |||
| 110518 | 110518 | 36243 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5694 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39266 | 5997860.0334642 | 2086885.30228194 | 37.710067130450504 | -122.449180647912 | (37.7100671304505, -122.449180647912) | |||
| 110658 | 110658 | 36242 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5694 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39266 | 5997860.0334642 | 2086885.30228194 | 37.710067130450504 | -122.449180647912 | (37.7100671304505, -122.449180647912) | |||
| 112323 | 112323 | 36244 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5694 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39266 | 5997860.0334642 | 2086885.30228194 | 37.710067130450504 | -122.449180647912 | (37.7100671304505, -122.449180647912) | |||
| 116618 | 116618 | 36241 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5694 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39266 | 5997860.0334642 | 2086885.30228194 | 37.710067130450504 | -122.449180647912 | (37.7100671304505, -122.449180647912) | |||
| 28342 | 28342 | 178569 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 248 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6007731.20347 | 2086684.5364299999 | 37.7100755293265 | -122.415049652546 | (37.7100755293265, -122.415049652546) | |||
| 185448 | 185448 | 178522 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997828.42227 | 2086900.0351099998 | 37.7101057753261 | -122.449290962629 | (37.7101057753261, -122.449290962629) | |||
| 155345 | 155345 | 178584 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 26 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008214.79968 | 2086685.80623 | 37.710106180029705 | -122.41337833353799 | (37.7101061800297, -122.413378333538) | |||
| 45297 | 45297 | 108827 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 545 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6012961.52713 | 2086598.5921 | 37.710132076897004 | -122.39696648323601 | (37.710132076897, -122.396966483236) | ||||
| 164066 | 164066 | 108828 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 545 Lathrop Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6012942.964319999 | 2086604.7843099998 | 37.7101480461743 | -122.39703107431801 | (37.7101480461743, -122.397031074318) | ||||
| 186453 | 186453 | 178523 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997858.27775 | 2086928.7713 | 37.7101863860532 | -122.449189845558 | (37.7101863860532, -122.449189845558) | |||
| 70301 | 70301 | 178570 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6007788.073340001 | 2086736.82111 | 37.71022228790721 | -122.41485679652901 | (37.7102222879072, -122.414856796529) | |||
| 175446 | 175446 | 178524 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 5997869.35085 | 2086941.7630200002 | 37.7102226917018 | -122.44915251020599 | (37.7102226917018, -122.449152510206) | |||
| 41443 | 41443 | 178583 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 14 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008232.92194 | 2086734.3557799999 | 37.7102405045764 | -122.41331913027099 | (37.7102405045764, -122.413319130271) | |||
| 143202 | 143202 | 36240 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5680 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39265 | 5997984.77377446 | 2086951.33234778 | 37.7102555679665 | -122.44875427577298 | (37.7102555679665, -122.448754275773) | |||
| 152518 | 152518 | 178525 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997892.95524 | 2086962.1133599998 | 37.710279919152704 | -122.44907239407401 | (37.7102799191527, -122.449072394074) | |||
| 13182 | 13182 | 1306 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 4001 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X6 | 5991941.83628 | 2087094.05513 | 37.7103000369794 | -122.469650093897 | (37.7103000369794, -122.469650093897) | |||
| 40425 | 40425 | 178571 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 239 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6007804.92948 | 2086781.45745 | 37.7103457971888 | -122.414801695063 | (37.7103457971888, -122.414801695063) | |||
| 42182 | 42182 | 178526 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997920.74376 | 2086988.8754200002 | 37.710354990967105 | -122.448978278229 | (37.7103549909671, -122.448978278229) | |||
| 55872 | 55872 | 178527 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997931.98579 | 2086999.1742900002 | 37.7103839122559 | -122.448940164984 | (37.7103839122559, -122.448940164984) | |||
| 172306 | 172306 | 178528 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997956.06337 | 2087020.6353099998 | 37.7104442162958 | -122.448858493027 | (37.7104442162958, -122.448858493027) | |||
| 182420 | 182420 | 178572 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 227 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6007823.3785 | 2086829.7924 | 37.710479551557995 | -122.41474134964199 | (37.710479551558, -122.414741349642) | |||
| 25895 | 25895 | 178582 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 14 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008211.00722 | 2086844.86906 | 37.710542720837395 | -122.413402682694 | (37.7105427208374, -122.413402682694) | |||
| 186452 | 186452 | 178581 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 26 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008164.03378 | 2086861.9069599998 | 37.7105868658553 | -122.41356623790199 | (37.7105868658553, -122.413566237902) | |||
| 182975 | 182975 | 178573 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 215 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6007841.980330001 | 2086878.07052 | 37.710613158435706 | -122.414680471838 | (37.7106131584357, -122.414680471838) | |||
| 175460 | 175460 | 178580 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 32 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008120.9442300005 | 2086878.3110099998 | 37.7106294883307 | -122.413716324871 | (37.7106294883307, -122.413716324871) | |||
| 154996 | 154996 | 178579 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 50 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008070.38485 | 2086898.7992200002 | 37.710682905359604 | -122.413892518218 | (37.7106829053596, -122.413892518218) | |||
| 65766 | 65766 | 178574 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6007852.78765 | 2086912.7762400003 | 37.7107090603577 | -122.414645573646 | (37.7107090603577, -122.414645573646) | |||
| 148000 | 148000 | 178578 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 62 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008022.86886 | 2086914.0591900002 | 37.710722137395 | -122.41405782350799 | (37.710722137395, -122.414057823508) | |||
| 72901 | 72901 | 178577 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 72 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6007977.02252 | 2086932.98941 | 37.7107715407319 | -122.414217617769 | (37.7107715407319, -122.414217617769) | |||
| 147670 | 147670 | 178576 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 78 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6007932.69383 | 2086948.1843400002 | 37.7108107727734 | -122.41437190275299 | (37.7108107727734, -122.414371902753) | |||
| 159559 | 159559 | 178575 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 90 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007893.14623 | 2086963.28184 | 37.71085000569129 | -122.414509656404 | (37.7108500056913, -122.414509656404) | |||
| 11599 | 11599 | 1188 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3023 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5996633.13731 | 2087220.7977599998 | 37.7109180726785 | -122.453445224323 | (37.7109180726785, -122.453445224323) | |||
| 12008 | 12008 | 1186 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3021 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5996654.59932 | 2087233.67855 | 37.7109546705803 | -122.453371976343 | (37.7109546705803, -122.453371976343) | |||
| 22046 | 22046 | 19095 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 261 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5994400.34264 | 2087392.3938799999 | 37.7112609940588 | -122.461174661688 | (37.7112609940588, -122.461174661688) | |||
| 21816 | 21816 | 19067 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 181 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X6 | 5995183.65728 | 2087383.7822 | 37.711282396136106 | -122.458466724769 | (37.7112823961361, -122.458466724769) | |||
| 19954 | 19954 | 19056 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 155 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995399.90932 | 2087379.93977 | 37.7112842712213 | -122.45771903023001 | (37.7112842712213, -122.45771903023) | |||
| 65682 | 65682 | 211990 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 121 Sagamore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5995657.3346 | 2087377.6276599998 | 37.7112927077714 | -122.45682914206101 | (37.7112927077714, -122.456829142061) | |||
| 99853 | 99853 | 19066 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 181 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5995202.5823827 | 2087398.1206165 | 37.711322853670104 | -122.45840235248001 | (37.7113228536701, -122.45840235248) | |||
| 145938 | 145938 | 19047 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 121 Sagamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 5995696.4497884 | 2087392.1121528998 | 37.711334724785296 | -122.456694997796 | (37.7113347247853, -122.456694997796) | |||
| 12890 | 12890 | 1261 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3833 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X6 | 5992776.62471 | 2087495.32693 | 37.7114500468546 | -122.466794068292 | (37.7114500468546, -122.466794068292) | |||
| 56820 | 56820 | 212740 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 230 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994691.78366 | 2087470.5554900002 | 37.7114923752566 | -122.460173034569 | (37.7114923752566, -122.460173034569) | |||
| 127301 | 127301 | 19081 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 224 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 5994792.47561 | 2087468.61728 | 37.7114928446183 | -122.459824878953 | (37.7114928446183, -122.459824878953) | ||||
| 20969 | 20969 | 19080 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 222 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5994789.79995 | 2087468.8436599998 | 37.711493312329104 | -122.45983414305701 | (37.7114933123291, -122.459834143057) | |||
| 18827 | 18827 | 19077 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 214 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5994888.1662 | 2087467.46648 | 37.7114951874196 | -122.459494066213 | (37.7114951874196, -122.459494066213) | |||
| 17155 | 17155 | 19075 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 210 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5994852.87647 | 2087468.5468 | 37.7114961245189 | -122.459616114113 | (37.7114961245189, -122.459616114113) | |||
| 18849 | 18849 | 19061 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 170 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5995253.52383 | 2087462.2076 | 37.7115017488875 | -122.45823092253599 | (37.7115017488875, -122.458230922536) | |||
| 21765 | 21765 | 19060 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 168 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5995281.6457400005 | 2087462.6432700001 | 37.71150456104971 | -122.458133757993 | (37.7115045610497, -122.458133757993) | |||
| 109769 | 109769 | 19084 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 228 SAGAMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5994709.0 | 2087484.0 | 37.711530280980504 | -122.4601145042 | (37.7115302809805, -122.4601145042) | |||
| 10881 | 10881 | 1170 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2900 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5996939.82993 | 2087557.20875 | 37.711859355284204 | -122.45240948860099 | (37.7118593552842, -122.452409488601) | |||
| 93200 | 93200 | 101825 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 50 Raymond Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6010875.0 | 2087406.8 | 37.7122348861177 | -122.40423481912902 | (37.7122348861177, -122.404234819129) | |||
| 108822 | 108822 | 101824 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 50 Raymond Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6010875.0 | 2087406.8 | 37.7122348861177 | -122.40423481912902 | (37.7122348861177, -122.404234819129) | |||
| 114260 | 114260 | 101826 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 50 Raymond Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6010875.0 | 2087406.8 | 37.7122348861177 | -122.40423481912902 | (37.7122348861177, -122.404234819129) | |||
| 157653 | 157653 | 115396 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800x Rutland St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Private 3 | 5 | 3x3 | 6009890.08055 | 2087427.6888 | 37.7122371577831 | -122.407640479942 | (37.7122371577831, -122.407640479942) | ||
| 129043 | 129043 | 79686 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 50 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2002 12:00:00 AM | 17 | 3x3 | 6010880.07744846 | 2087416.54149132 | 37.7122619180075 | -122.404217955056 | (37.7122619180075, -122.404217955056) | ||
| 168353 | 168353 | 178542 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 66 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010862.49885 | 2087419.3068400002 | 37.7122685288301 | -122.404278906756 | (37.7122685288301, -122.404278906756) | |||
| 39914 | 39914 | 115395 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800x Rutland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Private 3 | 4 | 3x3 | 6009893.891419999 | 2087442.30364 | 37.7122775004839 | -122.40762833818998 | (37.7122775004839, -122.40762833819) | ||
| 23520 | 23520 | 178543 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 66 Raymond Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6010836.28225 | 2087433.88375 | 37.712307089080795 | -122.404370544988 | (37.7123070890808, -122.404370544988) | |||
| 53226 | 53226 | 115394 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800x Rutland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Private 3 | 4 | 3x3 | 6009899.82351 | 2087457.5745 | 37.7123197632209 | -122.407608911042 | (37.7123197632209, -122.407608911042) | ||
| 25743 | 25743 | 178544 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 66 Raymond Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6010796.6015800005 | 2087452.10529 | 37.7123549042316 | -122.404508975835 | (37.7123549042316, -122.404508975835) | |||
| 25916 | 25916 | 115393 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800x Rutland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Private 3 | 4 | 3x3 | 6009906.5006099995 | 2087474.9292900001 | 37.712367789705 | -122.407587055718 | (37.712367789705, -122.407587055718) | ||
| 166673 | 166673 | 178545 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 66 Raymond Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6010779.304409999 | 2087461.44534 | 37.7123795834354 | -122.40456941746 | (37.7123795834354, -122.40456941746) | |||
| 154144 | 154144 | 115392 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800x Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Private 3 | 6 | 3x3 | 6009912.446690001 | 2087490.89947 | 37.7124119734081 | -122.407567629444 | (37.7124119734081, -122.407567629444) | ||
| 12680 | 12680 | 1833 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2174 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6011634.522580001 | 2087511.81203 | 37.712565639665705 | -122.40161704481301 | (37.7125656396657, -122.401617044813) | |||
| 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) | ||||
| 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) | ||||
| 11773 | 11773 | 109059 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1126 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772776 | 6001371.73977 | 2087888.1678900002 | 37.7130210113759 | -122.437115282467 | (37.7130210113759, -122.437115282467) |
| 12326 | 12326 | 113363 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 126 Chester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 3x6 | Permit Number 776810 | 5991720.20644 | 2088367.09772 | 37.7137826921811 | -122.470508741378 | (37.7137826921811, -122.470508741378) | ||
| 12258 | 12258 | 1155 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2700 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 5997899.99425 | 2088293.2375900003 | 37.7139352846675 | -122.44914389918199 | (37.7139352846675, -122.449143899182) | |||
| 165337 | 165337 | 178601 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 654 Brotherhood Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5990455.55423 | 2088469.00468 | 37.7139892970456 | -122.474887233782 | (37.7139892970456, -122.474887233782) | |||
| 187274 | 187274 | 178602 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 654 Brotherhood Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5990447.2893 | 2088474.31285 | 37.7140033930131 | -122.47491618743601 | (37.7140033930131, -122.474916187436) | |||
| 159789 | 159789 | 178603 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 654 Brotherhood Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5990440.31227 | 2088479.59352 | 37.714017488102606 | -122.474940687671 | (37.7140174881026, -122.474940687671) | |||
| 163552 | 163552 | 178531 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 434 Huron Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5998755.7197199995 | 2088580.22705 | 37.714772199163704 | -122.44620683389 | (37.7147721991637, -122.44620683389) | |||
| 25413 | 25413 | 178530 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 434 Huron Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5998803.133719999 | 2088625.5176 | 37.7148992643772 | -122.446046207778 | (37.7148992643772, -122.446046207778) | |||
| 70947 | 70947 | 178529 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 434 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5998825.673140001 | 2088647.89797 | 37.714962002860204 | -122.44596991111 | (37.7149620028602, -122.44596991111) | |||
| 65428 | 65428 | 212741 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 142 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5992469.93504 | 2088840.59445 | 37.7151261228375 | -122.467951845594 | (37.7151261228375, -122.467951845594) | |||
| 96604 | 96604 | 115832 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 FONT BLVD | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 30x30 | Permit Number 777501 | 5990916.0 | 2088996.0 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | ||
| 99929 | 99929 | 105362 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2649 SAN JOSE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5997450.2 | 2088871.8 | 37.7154981469817 | -122.45074023855601 | (37.7154981469817, -122.450740238556) | |||
| 63730 | 63730 | 178606 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5989765.07873 | 2089203.5232 | 37.715966065363205 | -122.47732740025499 | (37.7159660653632, -122.477327400255) | ||||
| 10684 | 10684 | 1109 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2362 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 5999292.86989 | 2089155.09159 | 37.716381308429206 | -122.44439151548201 | (37.7163813084292, -122.444391515482) | |||
| 132166 | 132166 | 195881 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014862.619080001 | 2088902.1636299998 | 37.716562878860294 | -122.390556737105 | (37.7165628788603, -122.390556737105) | |||
| 130910 | 130910 | 195880 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 881 Jamestown Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014854.38836 | 2088918.94793 | 37.716608508652705 | -122.39058635897699 | (37.7166085086527, -122.390586358977) | |||
| 74400 | 74400 | 105470 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 77899 | 77899 | 105477 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 85521 | 85521 | 105467 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 89404 | 89404 | 105468 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 90134 | 90134 | 105485 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 92437 | 92437 | 105486 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 92986 | 92986 | 105482 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 98979 | 98979 | 105480 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 106191 | 106191 | 105479 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 107323 | 107323 | 105474 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 107452 | 107452 | 105466 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 111563 | 111563 | 105472 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 117705 | 117705 | 105487 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 118857 | 118857 | 105469 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 122946 | 122946 | 105471 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 124065 | 124065 | 105476 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 125780 | 125780 | 105481 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) |
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");