Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79343 | 79343 | 34456 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 999x UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38200 | 6008246.0 | 2119227.0 | 37.7994586593975 | -122.415572926479 | (37.7994586593975, -122.415572926479) | ||
| 124171 | 124171 | 34457 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 999x UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 3x3 | Permit Number 38200 | 6008246.0 | 2119227.0 | 37.7994586593975 | -122.415572926479 | (37.7994586593975, -122.415572926479) | |
| 58122 | 58122 | 125707 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 987 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008244.72432 | 2119269.3091700003 | 37.7995747581204 | -122.415580337966 | (37.7995747581204, -122.415580337966) | |||
| 62837 | 62837 | 125708 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 987 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008267.41837 | 2119270.58084 | 37.7995795254212 | -122.41550189821001 | (37.7995795254212, -122.41550189821) | |||
| 100684 | 100684 | 66868 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 980 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | 3x3 | Permit Number 30175 | 6007892.40589298 | 2115166.96998046 | 37.7882909386851 | -122.416508740658 | (37.7882909386851, -122.416508740658) | |
| 133304 | 133304 | 125713 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 956 Vallejo St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6008845.05182 | 2118706.6905799997 | 37.7980636731514 | -122.41346316930799 | (37.7980636731514, -122.413463169308) | ||||
| 158306 | 158306 | 125712 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 956 Vallejo St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6008850.76057 | 2118710.67422 | 37.798074931775396 | -122.413443697187 | (37.7980749317754, -122.413443697187) | ||||
| 147647 | 147647 | 125711 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 954 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6008937.17158 | 2118714.51142 | 37.798090319168 | -122.413144960375 | (37.798090319168, -122.413144960375) | ||||
| 135028 | 135028 | 205570 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 95 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994005.55165 | 2097177.56666 | 37.7381059775051 | -122.463248730343 | (37.7381059775051, -122.463248730343) | |||
| 31337 | 31337 | 125710 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 944 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6009006.53902 | 2118723.89067 | 37.798119966232704 | -122.412905591427 | (37.7981199662327, -122.412905591427) | ||||
| 172627 | 172627 | 125709 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 944 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6009014.12735 | 2118712.39114 | 37.798088817308 | -122.412878520028 | (37.798088817308, -122.412878520028) | ||||
| 162353 | 162353 | 125714 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 941 Vallejo St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6008973.41059 | 2118698.11415 | 37.7980473306652 | -122.413018402384 | (37.7980473306652, -122.413018402384) | ||||
| 71231 | 71231 | 32716 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 930 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 3x3 | Permit Number 37111 | 6008229.60793 | 2115679.81731 | 37.7897180499914 | -122.41537839431801 | (37.7897180499914, -122.415378394318) |
| 171572 | 171572 | 32717 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 930 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 3x3 | Permit Number 37111 | 6008227.34815 | 2115705.62066 | 37.7897887726751 | -122.415388040436 | (37.7897887726751, -122.415388040436) |
| 52786 | 52786 | 204283 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 927 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991119.47646 | 2102448.17683 | 37.7524110238734 | -122.473611593125 | (37.7524110238734, -122.473611593125) | |||
| 155022 | 155022 | 204284 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 927 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991101.29307 | 2102443.5789 | 37.752397346083896 | -122.47367413827499 | (37.7523973460839, -122.473674138275) | |||
| 24810 | 24810 | 125700 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 900 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007433.50155 | 2114436.05545 | 37.786258207895706 | -122.418044641354 | (37.7862582078957, -122.418044641354) | |||
| 169215 | 169215 | 204243 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 90 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5993464.526880001 | 2093539.34009 | 37.7280851251272 | -122.46485516683201 | (37.7280851251272, -122.464855166832) | |||
| 100146 | 100146 | 40768 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 90 Entrada Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41731 | 5992535.95232782 | 2092083.0060810002 | 37.7240328083641 | -122.46795936676901 | (37.7240328083641, -122.467959366769) | ||
| 108527 | 108527 | 40769 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 90 Entrada Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41731 | 5992535.95232782 | 2092083.0060810002 | 37.7240328083641 | -122.46795936676901 | (37.7240328083641, -122.467959366769) | ||
| 34801 | 34801 | 205599 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 892 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998770.71845 | 2096149.0722599998 | 37.73555534369321 | -122.446699254987 | (37.7355553436932, -122.446699254987) | |||
| 3441 | 3441 | 32703 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 890 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37106 | 6007477.85623 | 2114415.95786 | 37.7862055211206 | -122.417889760126 | (37.7862055211206, -122.417889760126) |
| 40993 | 40993 | 221129 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 881 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007991.997330001 | 2102761.3547099996 | 37.754233641188705 | -122.415285627426 | (37.7542336411887, -122.415285627426) | |||
| 1069 | 1069 | 80004 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 881 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2017 12:00:00 AM | 3 | Permit Number 779791 | 5982299.17664 | 2109781.12407 | 37.772030443625795 | -122.504656395048 | (37.7720304436258, -122.504656395048) | |
| 170316 | 170316 | 34716 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 870 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38371 | 5981723.61752 | 2109806.49015 | 37.772066217995 | -122.506649145791 | (37.772066217995, -122.506649145791) | |
| 59585 | 59585 | 204281 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 855 Ortega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991371.23061 | 2102452.06513 | 37.752436276838104 | -122.472741277806 | (37.7524362768381, -122.472741277806) | |||
| 67082 | 67082 | 204282 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 855 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5991318.4935 | 2102451.26095 | 37.75243101579329 | -122.472923591054 | (37.7524310157933, -122.472923591054) | |||
| 56258 | 56258 | 205603 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 845 Detroit St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999427.00683 | 2095718.88382 | 37.7344116156036 | -122.44439931797501 | (37.7344116156036, -122.444399317975) | |||
| 83329 | 83329 | 44367 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 845 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2001 12:00:00 AM | Permit Number 43736 | 6002495.55510721 | 2088615.90278678 | 37.7150830283913 | -122.43328297514601 | (37.7150830283913, -122.433282975146) | |||
| 80899 | 80899 | 51734 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 834 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2005 12:00:00 AM | Permit Number 48014 | 6012117.32852637 | 2098230.03082929 | 37.7420225917964 | -122.40070080435301 | (37.7420225917964, -122.400700804353) | |||
| 126094 | 126094 | 51733 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 834 Toland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2005 12:00:00 AM | Permit Number 48014 | 6012117.32852637 | 2098230.03082929 | 37.7420225917964 | -122.40070080435301 | (37.7420225917964, -122.400700804353) | |||
| 169736 | 169736 | 40201 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 830 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 9 | Permit Number 41383 | 5983264.50092 | 2110118.09525 | 37.7730124061407 | -122.50134224763599 | (37.7730124061407, -122.501342247636) | |
| 35132 | 35132 | 40200 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 826 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 7 | Permit Number 41382 | 5983263.94969 | 2110159.75947 | 37.773126771678704 | -122.501347236887 | (37.7731267716787, -122.501347236887) | |
| 57169 | 57169 | 221130 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 825 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007982.122380001 | 2102911.62209 | 37.754645686273996 | -122.415330414592 | (37.754645686274, -122.415330414592) | |||
| 126856 | 126856 | 98969 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 825 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
| 26801 | 26801 | 221170 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 82 Hancock St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6003717.37028 | 2105106.00276 | 37.7604303181269 | -122.430235612701 | (37.7604303181269, -122.430235612701) | |||
| 34514 | 34514 | 34711 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 814 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38367 | 5981711.82187 | 2110159.4624900003 | 37.7730346823923 | -122.50671613138701 | (37.7730346823923, -122.506716131387) | |
| 98497 | 98497 | 34712 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 814 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38367 | 5981714.39581019 | 2110184.94689539 | 37.7731048066849 | -122.50670911846599 | (37.7731048066849, -122.506709118466) | ||
| 63444 | 63444 | 34710 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 810 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38366 | 5981708.71753 | 2110203.70271 | 37.7731559703061 | -122.50673015139499 | (37.7731559703061, -122.506730151395) | |
| 23955 | 23955 | 204246 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 81 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997506.8200199995 | 2099205.04953 | 37.7438740375718 | -122.45128934072399 | (37.7438740375718, -122.451289340724) | |||
| 25324 | 25324 | 204254 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 81 Elmhurst Dr | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5991110.1119800005 | 2094515.36236 | 37.7306290086229 | -122.473065523856 | (37.7306290086229, -122.473065523856) | |||
| 824 | 824 | 175557 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 80X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 3 | Width 3ft | 5991341.18573 | 2088991.3817 | 37.71547490063521 | -122.471864234655 | (37.7154749006352, -122.471864234655) | ||
| 467 | 467 | 85277 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 801 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49566 | ||||||||
| 36453 | 36453 | 221122 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 8 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6007401.99746 | 2099837.76455 | 37.7461729475405 | -122.41711885317 | (37.7461729475405, -122.41711885317) | |||
| 65712 | 65712 | 116889 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 799X Marina Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5999179.62484 | 2121450.57939 | 37.8050502147576 | -122.447105792604 | (37.8050502147576, -122.447105792604) | |||
| 57485 | 57485 | 73751 | Private 5 | Arbutus unedo :: Strawberry Tree 61 | 794-798 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 10 | 3x3 | 5990095.37972 | 2109981.17843 | 37.7730352575459 | -122.477703639701 | (37.7730352575459, -122.477703639701) | |
| 185734 | 185734 | 73761 | Private 5 | Arbutus unedo :: Strawberry Tree 61 | 794-798 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 7 | 3x3 | 5990097.66816 | 2109968.1044799997 | 37.772999492868706 | -122.47769476794599 | (37.7729994928687, -122.477694767946) | |
| 49323 | 49323 | 72425 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 791 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 13 | 5990048.49383 | 2110046.6556599997 | 37.7732123190088 | -122.47787060956101 | (37.7732123190088, -122.477870609561) | ||
| 145517 | 145517 | 39710 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 780 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41095 | 5996936.4012082005 | 2095030.50112432 | 37.7323790624539 | -122.45296043786999 | (37.7323790624539, -122.45296043787) | ||
| 137670 | 137670 | 70224 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 774 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 9 | 5991346.67049 | 2110134.70461 | 37.7735293356805 | -122.473386511602 | (37.7735293356805, -122.473386511602) | ||
| 149960 | 149960 | 175554 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 751 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6002038.05484 | 2089420.5116400002 | 37.7172663411433 | -122.434921798223 | (37.7172663411433, -122.434921798223) | |||
| 151267 | 151267 | 221150 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 75 Piedmont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999396.601840001 | 2106952.45088 | 37.7652545262116 | -122.445311861861 | (37.7652545262116, -122.445311861861) | |||
| 152761 | 152761 | 175555 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 744 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002240.95464 | 2089320.7382099999 | 37.7170039036857 | -122.434213341068 | (37.7170039036857, -122.434213341068) | |||
| 63509 | 63509 | 53408 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 732 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/2002 12:00:00 AM | 2 | Permit Number 6307 | 6011253.43466 | 2104717.71315 | 37.7597881275257 | -122.404144378963 | (37.7597881275257, -122.404144378963) | |
| 158553 | 158553 | 47683 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 730 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | 8 | Permit Number 45474 | 5991337.42645 | 2110428.10245 | 37.7743343910633 | -122.473439892203 | (37.7743343910633, -122.473439892203) | |
| 25859 | 25859 | 221159 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 72 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007370.31333 | 2098939.53779 | 37.743704835509796 | -122.417164776158 | (37.7437048355098, -122.417164776158) | |||
| 40154 | 40154 | 247360 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 717 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003117.4357 | 2109597.3047 | 37.7727283414985 | -122.432631332795 | (37.7727283414985, -122.432631332795) | |||
| 88109 | 88109 | 64811 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 714 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49823 | 6001902.40841481 | 2099743.14733631 | 37.745602232257 | -122.436128941313 | (37.745602232257, -122.436128941313) | ||
| 146580 | 146580 | 221148 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 71 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997071.8183 | 2106141.02353 | 37.7628935738126 | -122.453294106749 | (37.7628935738126, -122.453294106749) | |||
| 22144 | 22144 | 2049 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 701X Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001977.73953 | 2095412.31759 | 37.733715061000204 | -122.43555868909901 | (37.7337150610002, -122.435558689099) | |||
| 157132 | 157132 | 52677 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 700 REVISED 37th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 7 | Permit Number 48754 | 5984472.12802 | 2111009.36044 | 37.7755304106086 | -122.49723078434401 | (37.7755304106086, -122.497230784344) | ||
| 159448 | 159448 | 52683 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 700 REVISED 37th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 5 | Permit Number 48754 | 5984474.1727 | 2110997.72398 | 37.7754985800658 | -122.49722285223801 | (37.7754985800658, -122.497222852238) | ||
| 174075 | 174075 | 52673 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 700 REVISED 37th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 7 | Permit Number 48754 | 5984474.785130001 | 2110952.04196 | 37.7753731862643 | -122.497217360825 | (37.7753731862643, -122.497217360825) | ||
| 80281 | 80281 | 91063 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 70 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2008 12:00:00 AM | 3x3 | Permit Number 51971 | 6008176.0 | 2108000.0 | 37.768628094650204 | -122.415020067856 | (37.7686280946502, -122.415020067856) | ||
| 171337 | 171337 | 221107 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 70 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008195.73538 | 2108004.35672 | 37.7686411661776 | -122.41495211295401 | (37.7686411661776, -122.414952112954) | |||
| 32639 | 32639 | 205566 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 7 Locksley Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994170.44899 | 2104994.66764 | 37.759579252803505 | -122.463245671761 | (37.7595792528035, -122.463245671761) | |||
| 63357 | 63357 | 205567 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 7 Locksley Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994181.5204 | 2105002.6453 | 37.759601795201704 | -122.463207960474 | (37.7596017952017, -122.463207960474) | |||
| 185565 | 185565 | 205565 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 7 Locksley Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994158.07056 | 2104987.77665 | 37.7595596188099 | -122.463287982171 | (37.7595596188099, -122.463287982171) | |||
| 116949 | 116949 | 41673 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 69 Deming St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 778874 | 5999228.79012001 | 2105180.00479751 | 37.7603782511364 | -122.445764801622 | (37.7603782511364, -122.445764801622) | ||
| 42566 | 42566 | 188224 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 680 De Haro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6012059.12679 | 2105275.043 | 37.7613634169017 | -122.401397037349 | (37.7613634169017, -122.401397037349) | ||||
| 30304 | 30304 | 125706 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 68 Pleasant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008674.29968 | 2116820.86226 | 37.7928760643434 | -122.41392055009199 | (37.7928760643434, -122.413920550092) | |||
| 50257 | 50257 | 125705 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 68 Pleasant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008691.84445 | 2116822.80562 | 37.792882385661 | -122.41385998166001 | (37.792882385661, -122.41385998166) | |||
| 112815 | 112815 | 34708 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 678 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38364 | 5981680.40522934 | 2111119.17303473 | 37.7756679163326 | -122.506896004177 | (37.7756679163326, -122.506896004177) | ||
| 163553 | 163553 | 34707 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 678 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38364 | 5981677.4444 | 2111118.32695 | 37.7756654188698 | -122.506906183465 | (37.7756654188698, -122.506906183465) | |
| 163472 | 163472 | 175556 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 675 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002319.00588 | 2089864.96187 | 37.7185026508577 | -122.43398243563499 | (37.7185026508577, -122.433982435635) | |||
| 62510 | 62510 | 221173 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 671 Church St | 49 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 3ft | 6004295.52251 | 2105193.37392 | 37.760702948493204 | -122.428242277975 | (37.7607029484932, -122.428242277975) | |||
| 188486 | 188486 | 221147 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 67 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997069.00247 | 2106158.7586 | 37.762942108409796 | -122.453305126128 | (37.7629421084098, -122.453305126128) | |||
| 43319 | 43319 | 103461 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 666 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2013 12:00:00 AM | 0 | 3x3 | Permit Number 770172 | 6005398.7 | 2111581.8 | 37.77830639149621 | -122.42488139317899 | (37.7783063914962, -122.424881393179) | |
| 134148 | 134148 | 205600 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 651 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997690.37831 | 2098126.30275 | 37.7409225696214 | -122.45057688613501 | (37.7409225696214, -122.450576886135) | |||
| 43262 | 43262 | 205552 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 65 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5996574.8784300005 | 2094111.06623 | 37.729833790292396 | -122.454143915709 | (37.7298337902924, -122.454143915709) | |||
| 173549 | 173549 | 205553 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 65 Hazelwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5996579.09999 | 2094098.7113700002 | 37.7298001088785 | -122.454128429388 | (37.7298001088785, -122.454128429388) | |||
| 184672 | 184672 | 205591 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 64 Linares Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994060.21953 | 2102134.15413 | 37.7517186672821 | -122.463419311054 | (37.7517186672821, -122.463419311054) | |||
| 184170 | 184170 | 73750 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 638 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 4 | 5990680.77629 | 2111023.575 | 37.7759313483187 | -122.47575483630501 | (37.7759313483187, -122.475754836305) | ||
| 186023 | 186023 | 72370 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 638 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 3 | 5990680.359209999 | 2111038.5537900003 | 37.7759724517855 | -122.475757373153 | (37.7759724517855, -122.475757373153) | ||
| 43651 | 43651 | 204244 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 621 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995706.46368 | 2099903.31697 | 37.7456880564513 | -122.45756502581301 | (37.7456880564513, -122.457565025813) | |||
| 80749 | 80749 | 42426 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 620 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42577 | 5997972.86705556 | 2095014.83999466 | 37.7323954036406 | -122.449376022575 | (37.7323954036406, -122.449376022575) | ||
| 111162 | 111162 | 42427 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 620 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42577 | 5997972.86705556 | 2095014.83999466 | 37.7323954036406 | -122.449376022575 | (37.7323954036406, -122.449376022575) | ||
| 136625 | 136625 | 175549 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 62 Tomaso Ct | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 8ft | 6009261.65543 | 2086500.8991200002 | 37.709657184513 | -122.40974713551901 | (37.709657184513, -122.409747135519) | |||
| 151895 | 151895 | 31374 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 618 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 17 | Permit Number 34976 | 5991223.6620000005 | 2099114.89273 | 37.7432647234805 | -122.47300825323799 | (37.7432647234805, -122.473008253238) | |
| 50049 | 50049 | 72364 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 617 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 8 | 5991265.11371 | 2111180.08401 | 37.7763949395058 | -122.47374490167499 | (37.7763949395058, -122.473744901675) | ||
| 152340 | 152340 | 31373 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 616 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 17 | Permit Number 34975 | 5991252.30155 | 2099116.74406 | 37.743271464822705 | -122.47290936108801 | (37.7432714648227, -122.472909361088) | |
| 128964 | 128964 | 34704 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 615 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38361 | 5981612.97325 | 2111540.52057 | 37.7768208414608 | -122.50716052883699 | (37.7768208414608, -122.507160528837) | |
| 49426 | 49426 | 204335 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 609 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5994844.83776 | 2092360.94865 | 37.72492903443371 | -122.459998089438 | (37.7249290344337, -122.459998089438) | |||
| 66094 | 66094 | 204267 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 602 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992346.7328699995 | 2104590.8969900003 | 37.7583653730678 | -122.469523541303 | (37.7583653730678, -122.469523541303) | |||
| 146509 | 146509 | 204266 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 602 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5992373.65673 | 2104591.5484 | 37.758368717652004 | -122.46943047495701 | (37.758368717652, -122.469430474957) | |||
| 178883 | 178883 | 204268 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 602 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992330.82571 | 2104590.62293 | 37.7583637012301 | -122.469578534842 | (37.7583637012301, -122.469578534842) | |||
| 31851 | 31851 | 188228 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 602 Arthur Ave | 48 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015950.839319999 | 2099751.9631 | 37.746414570195704 | -122.387551780196 | (37.7464145701957, -122.387551780196) | ||||
| 36747 | 36747 | 188229 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 602 Arthur Ave | 49 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6015937.59243 | 2099752.45795 | 37.746415195218205 | -122.387597621357 | (37.7464151952182, -122.387597621357) | ||||
| 35434 | 35434 | 205594 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 600x Laguna Honda Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5995579.6801 | 2099892.46812 | 37.745650984616105 | -122.458002636835 | (37.7456509846161, -122.458002636835) | |||
| 51488 | 51488 | 205597 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 600x Laguna Honda Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5995496.70265 | 2099913.2188 | 37.7457031929561 | -122.45829106020001 | (37.7457031929561, -122.4582910602) |
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");