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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 58867 | 58867 | 247173 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 141 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6001348.76723 | 2108505.96887 | 37.7696313440465 | -122.438671125768 | (37.7696313440465, -122.438671125768) | |||
| 58900 | 58900 | 191352 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015101.55033 | 2107682.6315900004 | 37.768143412117894 | -122.391042763138 | (37.7681434121179, -122.391042763138) | |||
| 59034 | 59034 | 129459 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 458 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011895.81451 | 2118092.21584 | 37.7965472956624 | -122.402863344166 | (37.7965472956624, -122.402863344166) | |||
| 59171 | 59171 | 207090 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1400 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991605.432 | 2098443.60055 | 37.741443622419894 | -122.47163929621 | (37.7414436224199, -122.47163929621) | |||
| 59281 | 59281 | 54994 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 685 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 7 | Permit Number 10872 | 5990951.59437 | 2110751.2702900004 | 37.77519937131321 | -122.47479813592301 | (37.7751993713132, -122.474798135923) | ||
| 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) | |||
| 59444 | 59444 | 80749 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 375 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52325 | 6004167.50654 | 2090267.3011900003 | 37.719712117607 | -122.42762157938101 | (37.719712117607, -122.427621579381) | |
| 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) | |||
| 59498 | 59498 | 227593 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005330.86399 | 2107797.8602 | 37.7679127764864 | -122.42484679046301 | (37.7679127764864, -122.424846790463) | |||
| 59549 | 59549 | 105029 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015077.74883 | 2108086.46133 | 37.769250919128 | -122.391153321267 | (37.769250919128, -122.391153321267) | |||
| 59805 | 59805 | 176969 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Craut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004020.786 | 2094067.71187 | 37.7301389032718 | -122.428399470475 | (37.7301389032718, -122.428399470475) | |||
| 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) | |||
| 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) | |||
| 60379 | 60379 | 191358 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015118.78707 | 2107382.7546599996 | 37.7673209722044 | -122.390962181167 | (37.7673209722044, -122.390962181167) | |||
| 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) | ||||
| 60958 | 60958 | 48733 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1235 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2002 12:00:00 AM | 2 | Permit Number 46013 | 5986739.234 | 2106838.4777 | 37.764210939174106 | -122.489081723593 | (37.7642109391741, -122.489081723593) | ||
| 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) | |||
| 61686 | 61686 | 105315 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2101 Laguna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | |||||
| 61696 | 61696 | 4545 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Cleary Ct | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | |||
| 61708 | 61708 | 227660 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 195 Beacon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6003113.10037 | 2097586.0775 | 37.73974812787179 | -122.43178856828101 | (37.7397481278718, -122.431788568281) | |||
| 62074 | 62074 | 94211 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 465 Missouri St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013546.79092 | 2104912.40006 | 37.760450569952205 | -122.39622637625799 | (37.7604505699522, -122.396226376258) | |
| 62217 | 62217 | 250619 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987113.722030001 | 2115192.60557 | 37.7871708695801 | -122.48840049988002 | (37.7871708695801, -122.48840049988) | |||
| 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) | |||
| 62414 | 62414 | 191272 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014208.1321 | 2110827.64494 | 37.776729299941394 | -122.394353258399 | (37.7767292999414, -122.394353258399) | |||
| 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) | |||
| 62772 | 62772 | 185051 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2715 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983667.0512 | 2096660.9577 | 37.736086492552 | -122.49895536756901 | (37.736086492552, -122.498955367569) | |||
| 62886 | 62886 | 227610 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 400 Prospect Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6006250.04952 | 2097648.9456700003 | 37.7400980729811 | -122.420946773391 | (37.7400980729811, -122.420946773391) | ||||
| 62932 | 62932 | 108753 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200x Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012766.4768 | 2087726.3545799998 | 37.713217830719294 | -122.397719670851 | (37.7132178307193, -122.397719670851) | |||
| 63792 | 63792 | 64471 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2332 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 4 | Permit Number 25341 | 6003518.39121 | 2116605.0137 | 37.7919924858215 | -122.431744816269 | (37.7919924858215, -122.431744816269) | ||
| 63865 | 63865 | 98154 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 466 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | Permit Number 768787 | 5991271.26635 | 2112266.2977400003 | 37.779377741026394 | -122.473802878969 | (37.7793777410264, -122.473802878969) | ||
| 64265 | 64265 | 129441 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6010109.81427 | 2114257.21673 | 37.7859174259901 | -122.40877263106199 | (37.7859174259901, -122.408772631062) | |||
| 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) | |||
| 64332 | 64332 | 227614 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 210 Holladay Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010810.25772 | 2099834.79777 | 37.746355946971605 | -122.405333247626 | (37.7463559469716, -122.405333247626) | |||
| 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) | |||
| 64660 | 64660 | 176932 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 56 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012552.9526 | 2087748.4178 | 37.7132665190974 | -122.39845923552299 | (37.7132665190974, -122.398459235523) | |||
| 64750 | 64750 | 129447 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1190 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008246.65377 | 2115911.69756 | 37.7903556945065 | -122.41533583927799 | (37.7903556945065, -122.415335839278) | |||
| 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) | |||
| 64764 | 64764 | 191274 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014170.53603 | 2110866.45323 | 37.7768337688053 | -122.394486033405 | (37.7768337688053, -122.394486033405) | |||
| 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) | |||
| 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) | |||
| 65596 | 65596 | 129426 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003248.10705 | 2117506.03033 | 37.7944511216749 | -122.432744393832 | (37.7944511216749, -122.432744393832) | |||
| 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) | |||
| 65976 | 65976 | 129416 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 218 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999044.58564 | 2115840.24858 | 37.789638031029206 | -122.44716909230301 | (37.7896380310292, -122.447169092303) | |||
| 66250 | 66250 | 31765 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990223.0095 | 2098395.3195 | 37.7412309773369 | -122.47641565864299 | (37.7412309773369, -122.476415658643) | ||
| 66258 | 66258 | 101283 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2001 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5989499.782000001 | 2106476.1919 | 37.7633769390525 | -122.479507377657 | (37.7633769390525, -122.479507377657) | |||
| 66308 | 66308 | 105031 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015081.19497 | 2108038.83155 | 37.7691203294602 | -122.391138071471 | (37.7691203294602, -122.391138071471) | |||
| 66851 | 66851 | 191268 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 538 Delancey St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6015150.51675 | 2113731.33336 | 37.7847545135408 | -122.391296270324 | (37.7847545135408, -122.391296270324) | ||||
| 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) | |||
| 67146 | 67146 | 105243 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 616 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2014 12:00:00 AM | 2 | 3x3 | Permit Number 770335 | 6007163.0512 | 2091665.3874599999 | 37.723719949895 | -122.417366048922 | (37.723719949895, -122.417366048922) | |
| 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) | |||
| 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) | |
| 67225 | 67225 | 247478 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 309 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002704.2967 | 2109689.8401 | 37.772958982719494 | -122.43406704066099 | (37.7729589827195, -122.434067040661) | |||
| 67462 | 67462 | 191307 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015158.98774 | 2107685.52339 | 37.76815453943829 | -122.390844293528 | (37.7681545394383, -122.390844293528) | |||
| 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) | |||
| 67555 | 67555 | 89658 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2849X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5989742.13076 | 2111923.12979 | 37.7783468130036 | -122.479067633531 | (37.7783468130036, -122.479067633531) | ||
| 68001 | 68001 | 191319 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015133.57873 | 2108141.42692 | 37.7694049406179 | -122.390964049067 | (37.7694049406179, -122.390964049067) | |||
| 68229 | 68229 | 101282 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2001 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5989468.7375 | 2106475.7724 | 37.7633739839128 | -122.479614718585 | (37.7633739839128, -122.479614718585) | |||
| 68569 | 68569 | 191348 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015095.009190001 | 2107795.26302 | 37.7684523103469 | -122.39107326184299 | (37.7684523103469, -122.391073261843) | |||
| 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) | |||
| 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) | ||||
| 69127 | 69127 | 191321 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015124.1638400005 | 2108316.2837099996 | 37.769884536484206 | -122.391008838006 | (37.7698845364842, -122.391008838006) | |||
| 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) | |||
| 69501 | 69501 | 227638 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 326 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6006175.20644 | 2101155.72627 | 37.7497226795546 | -122.421454532416 | (37.7497226795546, -122.421454532416) | |||
| 69520 | 69520 | 176931 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 68 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012597.15839 | 2087748.03583 | 37.713267932833794 | -122.398306417307 | (37.7132679328338, -122.398306417307) | |||
| 69654 | 69654 | 227617 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6009080.60999 | 2097991.13845 | 37.7411968070922 | -122.411183978775 | (37.7411968070922, -122.411183978775) | |||
| 69772 | 69772 | 207085 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2091 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993168.90781 | 2101284.1521799997 | 37.749333387335895 | -122.466439786693 | (37.7493333873359, -122.466439786693) | |||
| 69926 | 69926 | 227665 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 46 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006330.78292 | 2109566.87483 | 37.7728264958779 | -122.421513830121 | (37.7728264958779, -122.421513830121) | |||
| 70045 | 70045 | 191341 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015063.13507 | 2108364.25056 | 37.770012856238395 | -122.391223290338 | (37.7700128562384, -122.391223290338) | |||
| 70158 | 70158 | 98192 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1020 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6008091.62981 | 2118948.72517 | 37.7986859077751 | -122.41608738562799 | (37.7986859077751, -122.416087385628) | |||
| 70505 | 70505 | 227648 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 154 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999992.54639 | 2104934.00184 | 37.7597463657249 | -122.443105663906 | (37.7597463657249, -122.443105663906) | |||
| 70657 | 70657 | 129393 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3700 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5997126.155040001 | 2115061.06795 | 37.7873888086001 | -122.45375034092 | (37.7873888086001, -122.45375034092) | |||
| 70706 | 70706 | 105027 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6x6 | 6015075.4785400005 | 2108137.72551 | 37.7693915533068 | -122.391164757946 | (37.7693915533068, -122.391164757946) | |||
| 70774 | 70774 | 31727 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2460 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990175.918 | 2098661.7302 | 37.7419597410001 | -122.476597940821 | (37.7419597410001, -122.476597940821) |
| 70808 | 70808 | 176942 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 19 Lois Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012304.7570400005 | 2087878.1106900002 | 37.713608800166504 | -122.39932618916299 | (37.7136088001665, -122.399326189163) | |||
| 70856 | 70856 | 122542 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2233 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001449.1657 | 2113870.4558 | 37.784366584009206 | -122.43870830313499 | (37.7843665840092, -122.438708303135) | |||
| 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) | |||
| 71525 | 71525 | 97676 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2562 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6000785.23545 | 2117926.05562 | 37.7954644138979 | -122.441296359259 | (37.7954644138979, -122.441296359259) | ||||
| 71641 | 71641 | 191357 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015116.28501 | 2107414.99409 | 37.767409355789 | -122.390973089032 | (37.767409355789, -122.390973089032) | |||
| 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) | |||
| 71788 | 71788 | 191354 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015105.755890001 | 2107627.1199 | 37.7679912225533 | -122.39102433602899 | (37.7679912225533, -122.391024336029) | |||
| 71984 | 71984 | 191276 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014137.59227 | 2110902.38763 | 37.776930605110394 | -122.394602513603 | (37.7769306051104, -122.394602513603) | |||
| 72025 | 72025 | 191277 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014120.49796 | 2110919.7593900003 | 37.7769773536703 | -122.394662865301 | (37.7769773536703, -122.394662865301) | |||
| 72449 | 72449 | 227655 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003762.03013 | 2108315.13286 | 37.769244345078704 | -122.430310116133 | (37.7692443450787, -122.430310116133) | |||
| 72581 | 72581 | 89663 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2827 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5989854.97314 | 2111927.2213 | 37.7783645996222 | -122.47867757338301 | (37.7783645996222, -122.478677573383) | ||
| 73208 | 73208 | 49756 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1171 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 1 | Permit Number 46552 | 6011373.3818 | 2089351.75942 | 37.71760318852571 | -122.40264894398899 | (37.7176031885257, -122.402648943989) | |
| 73474 | 73474 | 191349 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015096.10016 | 2107767.4364 | 37.7683759650927 | -122.39106754304899 | (37.7683759650927, -122.391067543049) | |||
| 73709 | 73709 | 191332 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1108 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014847.27565 | 2110066.45331 | 37.774674745668996 | -122.392089008326 | (37.774674745669, -122.392089008326) | |||
| 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) | |||
| 74170 | 74170 | 129446 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1329 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008344.2402 | 2117236.00141 | 37.7939973921104 | -122.415091973713 | (37.7939973921104, -122.415091973713) | |||
| 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) | |||
| 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) | |||
| 74636 | 74636 | 227650 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 154 Danvers St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000006.33119 | 2104908.8667200003 | 37.759678136855996 | -122.443056184107 | (37.759678136856, -122.443056184107) | |||
| 74708 | 74708 | 129392 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 31 Casa Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001624.74168 | 2121508.73342 | 37.80534928880979 | -122.438648369353 | (37.8053492888098, -122.438648369353) | |||
| 74868 | 74868 | 121865 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 574 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990352.3789099995 | 2111462.4285 | 37.7771172745488 | -122.476922909403 | (37.7771172745488, -122.476922909403) | |||
| 75243 | 75243 | 129405 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3545 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000706.97602 | 2120551.39476 | 37.8026684412687 | -122.44175565829399 | (37.8026684412687, -122.441755658294) | |||
| 75435 | 75435 | 176937 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 18 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012312.20962 | 2087899.37244 | 37.7136675960583 | -122.399301921852 | (37.7136675960583, -122.399301921852) | |||
| 75466 | 75466 | 129435 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6004184.0136 | 2116319.13373 | 37.7912452400168 | -122.429421362005 | (37.7912452400168, -122.429421362005) | |||
| 75814 | 75814 | 191355 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015114.26665 | 2107471.16871 | 37.7675634870034 | -122.39098399692699 | (37.7675634870034, -122.390983996927) |
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");