Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 183393 | 183393 | 50456 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 993 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 6 | Permit Number 47101 | 6015538.43851 | 2104592.1377 | 37.7596818177679 | -122.38931576171001 | (37.7596818177679, -122.38931576171) | ||
| 148773 | 148773 | 176956 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 99 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012750.523080001 | 2087747.4076 | 37.713274749713605 | -122.39777628854799 | (37.7132747497136, -122.397776288548) | |||
| 34497 | 34497 | 191363 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 955 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013550.52728 | 2089583.75311 | 37.7183615103672 | -122.395139727222 | (37.7183615103672, -122.395139727222) | ||||
| 169089 | 169089 | 176954 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 95 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012699.50978 | 2087739.26695 | 37.713249556105104 | -122.397952038554 | (37.7132495561051, -122.397952038554) | |||
| 179315 | 179315 | 176955 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 95 Lois Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012720.393999999 | 2087742.5814099999 | 37.7132598200564 | -122.397880087391 | (37.7132598200564, -122.397880087391) | |||
| 99776 | 99776 | 65445 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 922 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1989 12:00:00 AM | Permit Number 28319 | 6007730.56095344 | 2114797.09154755 | 37.7872662397984 | -122.417042480837 | (37.7872662397984, -122.417042480837) | ||
| 16799 | 16799 | 57069 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 920 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 27 | 7x13 | Permit Number 14335 | 6015211.40645 | 2104319.9485 | 37.7589163085501 | -122.390427794128 | (37.7589163085501, -122.390427794128) | |
| 60646 | 60646 | 191259 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 900x Carolina St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6012470.08805 | 2103421.28043 | 37.7562963136528 | -122.39984551077299 | (37.7562963136528, -122.399845510773) | ||||
| 66909 | 66909 | 129449 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 884 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008727.37725 | 2119383.41122 | 37.799915172210206 | -122.41391825502899 | (37.7999151722102, -122.413918255029) | |||
| 35185 | 35185 | 129454 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007720.06236 | 2120575.53372 | 37.8031318169374 | -122.41748848713002 | (37.8031318169374, -122.41748848713) | |||
| 46474 | 46474 | 129453 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6007720.64474 | 2120576.4205400003 | 37.8031342846895 | -122.417486534671 | (37.8031342846895, -122.417486534671) | |||
| 49285 | 49285 | 129456 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6007719.74229 | 2120576.43903 | 37.803134284681 | -122.41748965894199 | (37.803134284681, -122.417489658942) | |||
| 65391 | 65391 | 129455 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007721.09596 | 2120576.41129 | 37.8031342846798 | -122.41748497255199 | (37.8031342846798, -122.417484972552) | |||
| 76720 | 76720 | 129452 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007720.96455 | 2120575.51523 | 37.803131816931206 | -122.41748536375799 | (37.8031318169312, -122.417485363758) | |||
| 145313 | 145313 | 64085 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2010 12:00:00 AM | Permit Number 54033 | 5990603.92265969 | 2099084.38866457 | 37.7431450674581 | -122.475148901667 | (37.7431450674581, -122.475148901667) | |||
| 9193 | 9193 | 4549 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004652.295 | 2113623.5507 | 37.7838703460943 | -122.427608988739 | (37.7838703460943, -122.427608988739) | |||
| 9249 | 9249 | 4552 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004747.7557 | 2113637.7514 | 37.7839147367985 | -122.42727974188101 | (37.7839147367985, -122.427279741881) | |||
| 9465 | 9465 | 4553 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004771.4236 | 2113636.9625 | 37.7839139091534 | -122.427197803426 | (37.7839139091534, -122.427197803426) | |||
| 122987 | 122987 | 4550 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004735.0847094 | 2113637.0202701 | 37.783912012698394 | -122.427323526754 | (37.7839120126984, -122.427323526754) | |||
| 144085 | 144085 | 4551 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1991 12:00:00 AM | 24 | 3X3 | 6004735.0847094 | 2113637.0202701 | 37.783912012698394 | -122.427323526754 | (37.7839120126984, -122.427323526754) | ||
| 159237 | 159237 | 139750 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 CLEARY CT | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6004722.5099 | 2113632.2289 | 37.78389814561189 | -122.427366689538 | (37.7838981456119, -122.427366689538) | |||
| 168441 | 168441 | 139749 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 CLEARY CT | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004687.007999999 | 2113628.2842 | 37.783885306529605 | -122.427489231919 | (37.7838853065296, -122.427489231919) | |||
| 187273 | 187273 | 176963 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 83 Badger St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 6002428.97482 | 2094295.2581 | 37.7306734890866 | -122.43391881851299 | (37.7306734890866, -122.433918818513) | |||
| 178480 | 178480 | 119541 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 823 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5986627.47166 | 2110288.5169900004 | 37.773677258601 | -122.48972200943399 | (37.773677258601, -122.489722009434) | |||
| 46359 | 46359 | 129457 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 822 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010137.05679 | 2118184.23209 | 37.7967015887668 | -122.408955554965 | (37.7967015887668, -122.408955554965) | |||
| 174066 | 174066 | 176973 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 82 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008143.29471 | 2093583.4510299999 | 37.729041645841896 | -122.414113135409 | (37.7290416458419, -122.414113135409) | |||
| 43673 | 43673 | 247493 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 806 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002649.6994 | 2109575.8819 | 37.7726429829887 | -122.434247750607 | (37.7726429829887, -122.434247750607) | |||
| 43531 | 43531 | 191264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 801 Arkansas St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013055.03201 | 2103799.19748 | 37.7573665842245 | -122.39784906707399 | (37.7573665842245, -122.397849067074) | ||||
| 44149 | 44149 | 30586 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 8 | Permit Number 34556 | 6002690.739 | 2109580.279 | 37.7726573855875 | -122.43410610481001 | (37.7726573855875, -122.43410610481) | |
| 90324 | 90324 | 30582 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | |||
| 90650 | 90650 | 30584 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | |||
| 110478 | 110478 | 30583 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | |||
| 114236 | 114236 | 30585 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | |||
| 113645 | 113645 | 97286 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 80 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768450 | 5993053.0 | 2098535.0 | 37.7417782258334 | -122.466640790543 | (37.7417782258334, -122.466640790543) | |||
| 37113 | 37113 | 176939 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6012245.82216 | 2087941.3179099998 | 37.7137790697309 | -122.399534325569 | (37.7137790697309, -122.399534325569) | |||
| 148811 | 148811 | 247957 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6010434.9927199995 | 2098878.7541 | 37.743709870826 | -122.40656351750602 | (37.743709870826, -122.406563517506) | ||||
| 55800 | 55800 | 227661 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Addison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003680.16981 | 2096890.8857099998 | 37.7378714190205 | -122.42977831104099 | (37.7378714190205, -122.429778311041) | |||
| 45505 | 45505 | 176953 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 79 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012671.13481 | 2087736.7840599997 | 37.713241158228705 | -122.39804993876999 | (37.7132411582287, -122.39804993877) | |||
| 136250 | 136250 | 250532 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 79 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5987685.24066 | 2115481.63254 | 37.787997784513294 | -122.486444423174 | (37.7879977845133, -122.486444423174) | |||
| 83665 | 83665 | 89055 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 788 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990404.298780001 | 2110035.18225 | 37.773201459979404 | -122.476639007633 | (37.7732014599794, -122.476639007633) | ||
| 101833 | 101833 | 89054 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 788 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990404.14743 | 2110052.29751 | 37.773248445022 | -122.476640781805 | (37.773248445022, -122.476640781805) | ||
| 177180 | 177180 | 176930 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 78 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012665.081590001 | 2087756.9566900001 | 37.7132962111247 | -122.39807227523501 | (37.7132962111247, -122.398072275235) | |||
| 86108 | 86108 | 89056 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 774 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990401.329059999 | 2110113.1437 | 37.7734153485371 | -122.476654976983 | (37.7734153485371, -122.476654976983) | ||
| 60052 | 60052 | 207078 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 769 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5997019.6459099995 | 2094987.9782900002 | 37.73226707514829 | -122.452669575238 | (37.7322670751483, -122.452669575238) | |||
| 93338 | 93338 | 42428 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 769 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42578 | 5997011.02141138 | 2094977.36766372 | 37.7322374467316 | -122.45269862641099 | (37.7322374467316, -122.452698626411) | ||
| 103093 | 103093 | 89057 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 768 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990399.549819999 | 2110162.4742900003 | 37.773550693633 | -122.47666473627899 | (37.773550693633, -122.476664736279) | ||
| 88935 | 88935 | 89118 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 767 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990353.59701 | 2110151.97769 | 37.7735192073496 | -122.47682292511001 | (37.7735192073496, -122.47682292511) | ||
| 7288 | 7288 | 111098 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 754 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2015 12:00:00 AM | 3 | 3x3 | 6008536.0762 | 2114905.536 | 37.78760928190211 | -122.414263235869 | (37.7876092819021, -122.414263235869) | ||
| 137572 | 137572 | 129440 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 754 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008519.418319999 | 2114901.84945 | 37.7875982238142 | -122.414320608106 | (37.7875982238142, -122.414320608106) | |||
| 64760 | 64760 | 191282 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014441.41184 | 2110601.16162 | 37.77612039236389 | -122.393530413818 | (37.7761203923639, -122.393530413818) | |||
| 65427 | 65427 | 191281 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014459.12873 | 2110582.79031 | 37.776070933269 | -122.39346783987301 | (37.776070933269, -122.393467839873) | |||
| 134094 | 134094 | 191283 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6014423.24539 | 2110620.23478 | 37.7761717535676 | -122.39359459213999 | (37.7761717535676, -122.39359459214) | |||
| 172373 | 172373 | 191279 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6014488.651430001 | 2110553.2747 | 37.7759915303161 | -122.393363646226 | (37.7759915303161, -122.393363646226) | |||
| 173431 | 173431 | 191284 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014408.26812 | 2110636.4725 | 37.7762155064684 | -122.39364753972201 | (37.7762155064684, -122.393647539722) | |||
| 173577 | 173577 | 191280 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014475.48285 | 2110565.8320299997 | 37.776025278288294 | -122.393410079138 | (37.7760252782883, -122.393410079138) | |||
| 118583 | 118583 | 26205 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 750 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/20/2007 12:00:00 AM | 12 | 3X3 | 6005640.0872799 | 2098758.1364942 | 37.743109258996206 | -122.423134597972 | (37.7431092589962, -122.423134597972) | ||
| 38656 | 38656 | 176952 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 75 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012648.82319 | 2087733.77895 | 37.713231664082706 | -122.39812684519698 | (37.7132316640827, -122.398126845197) | |||
| 76698 | 76698 | 227631 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 75 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997896.0946 | 2104612.71078 | 37.758744422037395 | -122.450333060142 | (37.7587444220374, -122.450333060142) | |||
| 69112 | 69112 | 187585 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 748 University St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6008708.47344 | 2090752.4419999998 | 37.7213000235466 | -122.411959282496 | (37.7213000235466, -122.411959282496) | ||||
| 176194 | 176194 | 187582 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 747 University St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6008739.08909 | 2090759.6184900003 | 37.7213214463175 | -122.41185395930799 | (37.7213214463175, -122.411853959308) | ||||
| 111180 | 111180 | 89059 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 746 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990397.15719 | 2110267.75159 | 37.7738396174891 | -122.476680705622 | (37.7738396174891, -122.476680705622) | ||
| 113266 | 113266 | 89058 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 746 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990395.0930699995 | 2110255.0249900003 | 37.7738045540059 | -122.47668691568899 | (37.7738045540059, -122.476686915689) | ||
| 67213 | 67213 | 51275 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 744 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 3 | Permit Number 47650 | 5990394.326 | 2110291.56377 | 37.7739048349937 | -122.476692239116 | (37.7739048349937, -122.476692239116) | |
| 145001 | 145001 | 89060 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 744 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990392.548057 | 2110303.8535700003 | 37.7739384762903 | -122.476699287319 | (37.7739384762903, -122.476699287319) | ||
| 125055 | 125055 | 48453 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 5 | Permit Number 45822 | 5996008.37556 | 2113838.92432 | 37.7839689836389 | -122.45752914479601 | (37.7839689836389, -122.457529144796) | ||
| 146723 | 146723 | 48452 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5996026.36682 | 2113840.43033 | 37.7839741521628 | -122.457467011011 | (37.7839741521628, -122.457467011011) | ||
| 182969 | 182969 | 48451 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5995956.24653 | 2113838.6701 | 37.783965291128204 | -122.457709472605 | (37.7839652911282, -122.457709472605) | ||
| 84911 | 84911 | 89061 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990394.60611 | 2110329.10213 | 37.7740079212926 | -122.476694013266 | (37.7740079212926, -122.476694013266) | ||
| 39185 | 39185 | 191296 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6014597.305819999 | 2110326.98215 | 37.7753762177666 | -122.392971942918 | (37.7753762177666, -122.392971942918) | |||
| 44145 | 44145 | 191295 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6014582.55786 | 2110345.63689 | 37.7754266202868 | -122.393024265473 | (37.7754266202868, -122.393024265473) | |||
| 44547 | 44547 | 191291 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014507.50601 | 2110409.04953 | 37.7755965678638 | -122.39328832798701 | (37.7755965678638, -122.393288327987) | |||
| 61026 | 61026 | 191297 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6014617.26494 | 2110308.92783 | 37.7753277532976 | -122.39290163570101 | (37.7753277532976, -122.392901635701) | |||
| 149339 | 149339 | 191293 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014546.37169 | 2110379.31646 | 37.775517086679 | -122.393151800112 | (37.775517086679, -122.393151800112) | |||
| 163250 | 163250 | 191292 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014526.81372 | 2110393.83261 | 37.7755558582611 | -122.393220472347 | (37.7755558582611, -122.393220472347) | |||
| 167148 | 167148 | 191294 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6014564.69623 | 2110362.23682 | 37.775471207769606 | -122.393087215303 | (37.7754712077696, -122.393087215303) | |||
| 176903 | 176903 | 129458 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 731 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012131.08094 | 2118327.87745 | 37.7972074996935 | -122.40206584156401 | (37.7972074996935, -122.402065841564) | |||
| 20605 | 20605 | 23 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 729 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2011 12:00:00 AM | 3 | 4x4 | 6003875.846919999 | 2107718.3128400003 | 37.7676120683604 | -122.429873853201 | (37.7676120683604, -122.429873853201) | ||
| 131733 | 131733 | 191263 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 728 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012693.0382199995 | 2104091.70249 | 37.7581495726586 | -122.399121524154 | (37.7581495726586, -122.399121524154) | |||
| 83557 | 83557 | 89117 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 727 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5990344.4993 | 2110412.80162 | 37.774234830642705 | -122.476873456227 | (37.7742348306427, -122.476873456227) | ||
| 24787 | 24787 | 56080 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 723 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2011 12:00:00 AM | 2 | 3x3 | Permit Number 51743 | 5981333.03596 | 2110794.79787 | 37.774756814986794 | -122.50807353876199 | (37.7747568149868, -122.508073538762) | |
| 27568 | 27568 | 191287 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014360.2734 | 2110545.30097 | 37.7759625028975 | -122.393807184665 | (37.7759625028975, -122.393807184665) | |||
| 67551 | 67551 | 191285 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014337.49405 | 2110565.62241 | 37.776017035092 | -122.39388740780001 | (37.776017035092, -122.3938874078) | |||
| 74191 | 74191 | 191290 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014418.027919999 | 2110488.47672 | 37.7758096856109 | -122.393603417186 | (37.7758096856109, -122.393603417186) | |||
| 166600 | 166600 | 191288 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014381.59657 | 2110521.77598 | 37.7758990935001 | -122.39373177471 | (37.7758990935001, -122.39373177471) | |||
| 177153 | 177153 | 191286 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014348.90708 | 2110556.6159200002 | 37.7759929395558 | -122.39384729623801 | (37.7759929395558, -122.393847296238) | |||
| 179903 | 179903 | 191289 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014403.282380001 | 2110504.70975 | 37.7758534385095 | -122.393655562567 | (37.7758534385095, -122.393655562567) | |||
| 14017 | 14017 | 104025 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 716 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6012687.87968 | 2104149.7182 | 37.7583085835989 | -122.399143437016 | (37.7583085835989, -122.399143437016) | |||
| 134345 | 134345 | 32357 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 716 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 3 | Permit Number 36911 | 6011755.33078 | 2117880.08122 | 37.7959569797808 | -122.40333452058998 | (37.7959569797808, -122.40333452059) | ||
| 178956 | 178956 | 176921 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002409.56015 | 2089503.5863700002 | 37.717515532482096 | -122.43364361428301 | (37.7175155324821, -122.433643614283) | |||
| 56470 | 56470 | 129438 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010041.47641 | 2115755.35321 | 37.790027121797294 | -122.409114812309 | (37.7900271217973, -122.409114812309) | |||
| 151998 | 151998 | 129437 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010035.0094 | 2115756.1647799998 | 37.790028987884895 | -122.409137245009 | (37.7900289878849, -122.409137245009) | |||
| 171961 | 171961 | 129439 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010043.54378 | 2115756.3306400003 | 37.7900299214 | -122.409107728349 | (37.7900299214, -122.409107728349) | |||
| 182481 | 182481 | 129436 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010030.57511 | 2115756.25526 | 37.7900289879055 | -122.409152593735 | (37.7900289879055, -122.409152593735) | |||
| 103146 | 103146 | 89063 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 710 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990388.49369 | 2110501.1170799998 | 37.774479872644 | -122.476727727029 | (37.774479872644, -122.476727727029) | ||
| 25932 | 25932 | 207066 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 71 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993124.54928 | 2098622.04482 | 37.7420213577054 | -122.46639972369101 | (37.7420213577054, -122.466399723691) | |||
| 56432 | 56432 | 227632 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 71 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997905.871119999 | 2104612.50701 | 37.758744422044295 | -122.450299233916 | (37.7587444220443, -122.450299233916) | |||
| 178509 | 178509 | 106106 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 708 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6011765.54028 | 2117816.6633 | 37.7957834196109 | -122.403294730072 | (37.7957834196109, -122.403294730072) | ||||
| 118487 | 118487 | 89064 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 706 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990387.44621 | 2110524.3809 | 37.7745436879542 | -122.476733050457 | (37.7745436879542, -122.476733050457) | ||
| 92694 | 92694 | 89112 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 691 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990332.54501 | 2110711.2620900003 | 37.7750536277141 | -122.476936620369 | (37.7750536277141, -122.476936620369) | ||
| 106267 | 106267 | 89111 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 691 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990331.56334 | 2110745.46757 | 37.775147489618504 | -122.47694251603501 | (37.7751474896185, -122.476942516035) |
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");