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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78926 | 78926 | 112621 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 226x HESTER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012667.0 | 2087636.0 | 37.712964194877294 | -122.398057164184 | (37.7129641948773, -122.398057164184) | ||||
| 82821 | 82821 | 102559 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 87060 | 87060 | 102564 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 88071 | 88071 | 99759 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4295x 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001974.5 | 2101167.2 | 37.7495164396885 | -122.43598153971399 | (37.7495164396885, -122.435981539714) | ||||
| 92389 | 92389 | 102561 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 94418 | 94418 | 112623 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 228 HESTER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 6012539.0 | 2087662.0 | 37.7130284556779 | -122.398501400627 | (37.7130284556779, -122.398501400627) | ||||
| 101687 | 101687 | 102565 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 102309 | 102309 | 99758 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4295x 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001974.5 | 2101167.2 | 37.7495164396885 | -122.43598153971399 | (37.7495164396885, -122.435981539714) | ||||
| 106668 | 106668 | 102554 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 108210 | 108210 | 122590 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 MacOndray Ln | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6008161.0 | 2119143.0 | 37.7992232381339 | -122.415861106147 | (37.7992232381339, -122.415861106147) | |||||
| 111006 | 111006 | 102566 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 120116 | 120116 | 102568 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 121400 | 121400 | 102560 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 127314 | 127314 | 102562 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 127598 | 127598 | 102563 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 127963 | 127963 | 102555 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 128253 | 128253 | 102557 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 144534 | 144534 | 102567 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2013 12:00:00 AM | 3x3 | Permit Number 769962 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||
| 144570 | 144570 | 102556 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 145327 | 145327 | 102558 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 37575 | 37575 | 176976 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6002487.993290001 | 2086859.8664400002 | 37.710260908397395 | -122.433183714473 | (37.7102609083974, -122.433183714473) | |||
| 39790 | 39790 | 79264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 180 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5989943.75827 | 2114181.74363 | 37.7845600440954 | -122.47853534669399 | (37.7845600440954, -122.478535346694) | |||
| 45384 | 45384 | 119342 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 450 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5985959.22989 | 2112860.79415 | 37.78070095968079 | -122.492222971302 | (37.7807009596808, -122.492222971302) | |||
| 47927 | 47927 | 227620 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005907.97007 | 2102264.4901400004 | 37.752752018913796 | -122.422457421298 | (37.7527520189138, -122.422457421298) | |||
| 51298 | 51298 | 200113 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1566 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014774.445 | 2092572.7944 | 37.7266368132033 | -122.391117932915 | (37.7266368132033, -122.391117932915) | |||
| 52001 | 52001 | 200104 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014963.9454 | 2092431.3459 | 37.726258938018 | -122.39045295200899 | (37.726258938018, -122.390452952009) | |||
| 52098 | 52098 | 207062 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993034.65386 | 2099189.08337 | 37.7435731145127 | -122.46675176060499 | (37.7435731145127, -122.466751760605) | |||
| 54047 | 54047 | 176922 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 298 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003957.47292 | 2089506.6993599997 | 37.7176117887305 | -122.42829341070801 | (37.7176117887305, -122.428293410708) | |||
| 54202 | 54202 | 117939 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6300 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5983833.6821099995 | 2109720.9042700003 | 37.7719552435785 | -122.49934405400101 | (37.7719552435785, -122.499344054001) | |||
| 56909 | 56909 | 200009 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1435 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6017676.8443 | 2092268.1534 | 37.72596096442079 | -122.381063162948 | (37.7259609644208, -122.381063162948) | |||
| 62276 | 62276 | 200097 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015067.4938 | 2092354.869 | 37.7260546913573 | -122.390089647295 | (37.7260546913573, -122.390089647295) | |||
| 62411 | 62411 | 176924 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 525 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002840.55904 | 2090695.62 | 37.720813038882206 | -122.43223893347799 | (37.7208130388822, -122.432238933478) | |||
| 64273 | 64273 | 176978 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Winding Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6002453.716630001 | 2086834.19677 | 37.7101884805901 | -122.433300348445 | (37.7101884805901, -122.433300348445) | |||
| 64313 | 64313 | 200002 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6017646.9261 | 2092314.6221 | 37.726086906985 | -122.381169818775 | (37.726086906985, -122.381169818775) | |||
| 64448 | 64448 | 200105 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014949.7328 | 2092444.2049 | 37.7262934578304 | -122.39050298275801 | (37.7262934578304, -122.390502982758) | |||
| 65837 | 65837 | 124124 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 61 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5996360.44357 | 2112557.14678 | 37.7804697796635 | -122.45621841836599 | (37.7804697796635, -122.456218418366) | |||
| 67199 | 67199 | 207064 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Taraval St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993028.0499599995 | 2099189.22218 | 37.743573114522206 | -122.466774605159 | (37.7435731145222, -122.466774605159) | |||
| 71134 | 71134 | 187130 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2600 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985156.874 | 2097417.7557 | 37.73825173359629 | -122.49386027578899 | (37.7382517335963, -122.493860275789) | |||
| 73740 | 73740 | 200018 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1008 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6018250.1161 | 2092086.6599 | 37.7254942451327 | -122.37906877917801 | (37.7254942451327, -122.379068779178) | |||
| 98308 | 98308 | 107371 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 448 BROADWAY | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011394.4 | 2118786.8 | 37.798426445485 | -122.404647279275 | (37.798426445485, -122.404647279275) | ||||
| 130451 | 130451 | 176925 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 17 Curtis St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 6000534.5551 | 2088493.30994 | 37.7146349724878 | -122.440052229032 | (37.7146349724878, -122.440052229032) | |||
| 131229 | 131229 | 200112 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1560 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014792.7183 | 2092559.9355 | 37.726602519263004 | -122.391053863847 | (37.726602519263, -122.391053863847) | |||
| 136471 | 136471 | 176966 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 327 Craut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 7ft | 6004069.61366 | 2093704.49695 | 37.7291443592041 | -122.42820479154301 | (37.7291443592041, -122.428204791543) | |||
| 147671 | 147671 | 207068 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 539 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991225.79939 | 2097692.69128 | 37.739359846476205 | -122.472897178881 | (37.7393598464762, -122.472897178881) | |||
| 148096 | 148096 | 176961 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 41 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011207.15899 | 2087778.71194 | 37.7132746363936 | -122.403112916852 | (37.7132746363936, -122.403112916852) | |||
| 148569 | 148569 | 200000 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 Griffith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6017688.3023 | 2092371.2757 | 37.726244750724 | -122.381030719301 | (37.726244750724, -122.381030719301) | |||
| 152536 | 152536 | 176979 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Winding Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6002427.23589 | 2086817.03836 | 37.7101398650242 | -122.433390645786 | (37.7101398650242, -122.433390645786) | |||
| 156333 | 156333 | 129391 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1851 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004117.78483 | 2119036.12679 | 37.798701658520706 | -122.42984439412399 | (37.7987016585207, -122.429844394124) | |||
| 156648 | 156648 | 182931 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2639 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982106.6394 | 2097122.6843 | 37.7372626147396 | -122.50438444730699 | (37.7372626147396, -122.504384447307) | |||
| 159060 | 159060 | 200098 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015053.9581 | 2092365.0208 | 37.726081815437205 | -122.39013714867201 | (37.7260818154372, -122.390137148672) | |||
| 162168 | 162168 | 176971 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20 Tulane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007468.11752 | 2093808.15267 | 37.7296206815304 | -122.416463191631 | (37.7296206815304, -122.416463191631) | |||
| 162509 | 162509 | 120374 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 433 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5988073.52579 | 2113031.79545 | 37.7812938539051 | -122.484921243675 | (37.7812938539051, -122.484921243675) | |||
| 162702 | 162702 | 129396 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3570 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5997759.42615 | 2115150.05593 | 37.7876694312425 | -122.451565786028 | (37.7876694312425, -122.451565786028) | |||
| 168739 | 168739 | 207051 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992092.816880001 | 2106815.43538 | 37.764458690039 | -122.47056370526899 | (37.764458690039, -122.470563705269) | |||
| 171684 | 171684 | 176974 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 15 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009262.49228 | 2094178.39386 | 37.730738031628704 | -122.410285956242 | (37.7307380316287, -122.410285956242) | |||
| 172420 | 172420 | 200111 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1552 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014807.6076 | 2092549.7837 | 37.726575470666106 | -122.39100168241998 | (37.7265754706661, -122.39100168242) | |||
| 173580 | 173580 | 176972 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 161 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008005.59306 | 2093164.83572 | 37.7278844827614 | -122.41455957148399 | (37.7278844827614, -122.414559571484) | |||
| 173778 | 173778 | 71255 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1392 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 1 | 6007494.44606 | 2117816.87319 | 37.795544530015604 | -122.418073553678 | (37.7955445300156, -122.418073553678) | ||
| 176268 | 176268 | 200103 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014982.2186 | 2092417.8102 | 37.72622278535071 | -122.390388836652 | (37.7262227853507, -122.390388836652) | |||
| 178142 | 178142 | 207065 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Taraval St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993024.9505900005 | 2099189.6741400003 | 37.743574176615894 | -122.46678535477301 | (37.7435741766159, -122.466785354773) | |||
| 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) | |||
| 181896 | 181896 | 176977 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6002472.369080001 | 2086850.07188 | 37.710233128335396 | -122.433237015483 | (37.7102331283354, -122.433237015483) | |||
| 182025 | 182025 | 200099 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015044.482999999 | 2092374.4958 | 37.7261073063636 | -122.390170565448 | (37.7261073063636, -122.390170565448) | |||
| 183793 | 183793 | 207061 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993037.74509 | 2099188.24411 | 37.7435709885186 | -122.466741010989 | (37.7435709885186, -122.466741010989) | |||
| 184269 | 184269 | 227602 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 54 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004494.61967 | 2096104.27773 | 37.735757657887994 | -122.426906353066 | (37.735757657888, -122.426906353066) | ||||
| 187479 | 187479 | 227589 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 23 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006036.6609 | 2100222.07218 | 37.7471512660344 | -122.42186731675 | (37.7471512660344, -122.42186731675) | |||
| 187926 | 187926 | 176923 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 298 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003940.88243 | 2089479.82592 | 37.7175370613599 | -122.42834884222201 | (37.7175370613599, -122.428348842222) | |||
| 26504 | 26504 | 227603 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 55 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004504.07862 | 2096101.1879099999 | 37.735749708773795 | -122.42687342978998 | (37.7357497087738, -122.42687342979) | ||||
| 28952 | 28952 | 176968 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Craut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004019.9865 | 2094083.3714700001 | 37.7301818557853 | -122.428403350153 | (37.7301818557853, -122.428403350153) | |||
| 34489 | 34489 | 183440 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2434 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989549.5958 | 2098754.1113 | 37.7421770482141 | -122.47877029228998 | (37.7421770482141, -122.47877029229) | |||
| 36009 | 36009 | 186909 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2700 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985192.0104 | 2096702.7177 | 37.7362904860675 | -122.49368611859501 | (37.7362904860675, -122.493686118595) | |||
| 36363 | 36363 | 207082 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1963 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992234.50744 | 2102126.7079 | 37.7515928656239 | -122.46973226583799 | (37.7515928656239, -122.469732265838) | |||
| 41237 | 41237 | 207083 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1959 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992235.15443 | 2102157.44312 | 37.7516772939722 | -122.469732265856 | (37.7516772939722, -122.469732265856) | |||
| 41440 | 41440 | 191311 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015151.76995 | 2107799.07376 | 37.76846592338129 | -122.39087719613501 | (37.7684659233813, -122.390877196135) | |||
| 43823 | 43823 | 191356 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015114.10558 | 2107443.69394 | 37.7674880383618 | -122.39098263356199 | (37.7674880383618, -122.390982633562) | |||
| 49816 | 49816 | 207050 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1287 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990781.88485 | 2106644.27108 | 37.7639128285243 | -122.475085316637 | (37.7639128285243, -122.475085316637) | |||
| 51341 | 51341 | 117943 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6300 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5983766.08421 | 2109717.4045599997 | 37.7719416683068 | -122.499577617773 | (37.7719416683068, -122.499577617773) | |||
| 52869 | 52869 | 176964 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 329 Craut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 7ft | 6004071.94661 | 2093622.05007 | 37.728918110483 | -122.42819085295099 | (37.728918110483, -122.428190852951) | |||
| 57672 | 57672 | 119485 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 5526 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5986205.51331 | 2109807.2757599996 | 37.772331260735605 | -122.49114618500799 | (37.7723312607356, -122.491146185008) | |||
| 59332 | 59332 | 200004 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 Griffith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6017626.5562 | 2092285.3405 | 37.7260053809224 | -122.38123820192101 | (37.7260053809224, -122.381238201921) | |||
| 59463 | 59463 | 207089 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1400 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991620.77866 | 2098444.2951599997 | 37.7414464175195 | -122.471586283874 | (37.7414464175195, -122.471586283874) | |||
| 60304 | 60304 | 191330 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1108 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014815.79386 | 2110104.2477700002 | 37.7747767728644 | -122.392200554832 | (37.7747767728644, -122.392200554832) | |||
| 62582 | 62582 | 207087 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1400 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991668.56365 | 2098444.306 | 37.7414492117217 | -122.471421062245 | (37.7414492117217, -122.471421062245) | |||
| 69047 | 69047 | 227628 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4222 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6001065.76771 | 2102912.44614 | 37.754256799634796 | -122.43924903191002 | (37.7542567996348, -122.43924903191) | |||
| 69337 | 69337 | 129433 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004155.37388 | 2116318.23991 | 37.791241164293496 | -122.429520390877 | (37.7912411642935, -122.429520390877) | |||
| 71664 | 71664 | 227629 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 62 Natick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003056.07384 | 2095532.6693400003 | 37.7341067067448 | -122.431839162348 | (37.7341067067448, -122.431839162348) | |||
| 74356 | 74356 | 186817 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1200 Sunset Blvd | 110 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984826.8059 | 2106810.865 | 37.7640233139964 | -122.49569412937599 | (37.7640233139964, -122.495694129376) | |||
| 77081 | 77081 | 207086 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2167 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990677.28316 | 2100628.1103 | 37.747387978366106 | -122.475007906598 | (37.7473879783661, -122.475007906598) | |||
| 109199 | 109199 | 122009 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2629 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990447.70869 | 2111948.34575 | 37.77845699894 | -122.476628645569 | (37.77845699894, -122.476628645569) | |||
| 131020 | 131020 | 117942 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6300 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5983781.64788 | 2109717.73118 | 37.7719434782971 | -122.499523806885 | (37.7719434782971, -122.499523806885) | |||
| 150746 | 150746 | 176967 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Craut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004019.42662 | 2094104.5358400003 | 37.7302399367234 | -122.428406793639 | (37.7302399367234, -122.428406793639) | |||
| 150887 | 150887 | 183441 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2434 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989549.5958 | 2098772.4148 | 37.742227304861395 | -122.47877163063801 | (37.7422273048614, -122.478771630638) | |||
| 156882 | 156882 | 191347 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015093.18746 | 2107823.28717 | 37.768529157422705 | -122.391081522115 | (37.7685291574227, -122.391081522115) | |||
| 156929 | 156929 | 217749 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 445 West Portal Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991783.05973 | 2096405.3403 | 37.7358573522267 | -122.470876685538 | (37.7358573522267, -122.470876685538) | |||
| 157008 | 157008 | 187077 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2600 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985155.4633 | 2096938.6014 | 37.736936021545 | -122.493829852855 | (37.736936021545, -122.493829852855) | |||
| 157316 | 157316 | 176970 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 146 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004341.61716 | 2094290.0126599998 | 37.7307674412459 | -122.42730614487301 | (37.7307674412459, -122.427306144873) | |||
| 159374 | 159374 | 129432 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004124.61142 | 2116315.60844 | 37.7912321971464 | -122.429626640374 | (37.7912321971464, -122.429626640374) | |||
| 159621 | 159621 | 186908 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2700 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985188.8014 | 2096694.9245 | 37.736268900285 | -122.493696639188 | (37.736268900285, -122.493696639188) | |||
| 163085 | 163085 | 183580 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2614 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988349.2799 | 2097484.0905 | 37.7386201346216 | -122.482827506776 | (37.7386201346216, -122.482827506776) | |||
| 164375 | 164375 | 207088 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1400 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991634.58199 | 2098444.51298 | 37.7414478141662 | -122.47153857305 | (37.7414478141662, -122.47153857305) |
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");