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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
75888 | 75888 | 191302 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015174.0673 | 2107416.87345 | 37.767417722189705 | -122.390773357708 | (37.7674177221897, -122.390773357708) | |||
76125 | 76125 | 191361 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015122.97696 | 2107297.48765 | 37.767087080134395 | -122.39094172878401 | (37.7670870801344, -122.390941728784) | |||
76229 | 76229 | 31768 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990284.9407 | 2098399.3806 | 37.741245719618895 | -122.47620182139 | (37.7412457196189, -122.47620182139) | ||
76313 | 76313 | 227649 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 154 Danvers St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999999.59495 | 2104920.93401 | 37.7597108865789 | -122.44308034798901 | (37.7597108865789, -122.443080347989) | |||
76536 | 76536 | 247481 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 309 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002713.0909 | 2109626.0822 | 37.7727844183865 | -122.43403206203101 | (37.7727844183865, -122.434032062031) | |||
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) | |||
76702 | 76702 | 191322 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015122.40685 | 2108342.01647 | 37.769955095485 | -122.391016714258 | (37.769955095485, -122.391016714258) | |||
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) | |||
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) | |||
77131 | 77131 | 54664 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 360 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 1 | Permit Number 10488 | 6012252.975769999 | 2086866.6648099998 | 37.710828684568206 | -122.399434200424 | (37.7108286845682, -122.399434200424) | ||
77958 | 77958 | 31771 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
78213 | 78213 | 37034 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 266 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48449 | 6004870.65820445 | 2098448.14678483 | 37.7422146471398 | -122.42577301954901 | (37.7422146471398, -122.425773019549) | ||
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) | ||||
79949 | 79949 | 4516 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20X Cleary Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.42642640211099 | (37.7846101140023, -122.426426402111) | |||
80995 | 80995 | 81638 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 611 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52388 | 6011631.16657043 | 2091602.57917757 | 37.7237978701092 | -122.40191602971301 | (37.7237978701092, -122.401916029713) | ||
81513 | 81513 | 102256 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1933 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 58594 | 6000840.6 | 2115080.7 | 37.787654962994104 | -122.440900572101 | (37.7876549629941, -122.440900572101) | |
82228 | 82228 | 31734 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1900x ULLOA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35227 | 5990005.0 | 2098357.0 | 37.741113115877795 | -122.47716665025699 | (37.7411131158778, -122.477166650257) | ||
82615 | 82615 | 105316 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2101 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | ||||
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) | ||||
83118 | 83118 | 38678 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1377 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/02/1998 12:00:00 AM | Permit Number 40596 | 6001182.75800309 | 2111056.33200795 | 37.776624556634495 | -122.439428187036 | (37.7766245566345, -122.439428187036) | ||
83610 | 83610 | 105034 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | ||||
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) | ||||
87075 | 87075 | 52479 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 119POWHATTAN Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48589 | 6009084.88956475 | 2097947.60140706 | 37.7410775038925 | -122.411166106845 | (37.7410775038925, -122.411166106845) |
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");