Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2538 | 2538 | 39950 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 2691 | 2691 | 253165 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 180 | 1451 Bay St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6003691.0 | 2120547.0 | 37.802825946660796 | -122.431429119577 | (37.8028259466608, -122.431429119577) | ||||
| 3107 | 3107 | 18939 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 2760 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6001611.94448 | 2115686.46462 | 37.78936213699829 | -122.438275289198 | (37.7893621369983, -122.438275289198) | |||
| 3506 | 3506 | 247939 | Planning Code 138.1 required 4 | Quercus agrifolia :: Coast Live Oak 180 | 29 Joy St | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 12 | Permit Number 775404 | 6010258.299769999 | 2098917.5156900003 | 37.7438064148349 | -122.40717721395 | (37.7438064148349, -122.40717721395) | |||
| 6380 | 6380 | 46722 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 6817 | 6817 | 39953 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 7518 | 7518 | 39946 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 7701 | 7701 | 18936 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 2721 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001590.13521 | 2115636.51425 | 37.7892237457171 | -122.43834716658199 | (37.7892237457171, -122.438347166582) | |||
| 8602 | 8602 | 18938 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 2730 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/2001 12:00:00 AM | 6 | 4X4 | 6001751.73398 | 2115704.11419 | 37.7894185478752 | -122.437792899137 | (37.7894185478752, -122.437792899137) | ||
| 8803 | 8803 | 39951 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 9553 | 9553 | 173610 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 344 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6001093.0 | 2097562.0 | 37.739567297515705 | -122.43877147759301 | (37.7395672975157, -122.438771477593) | |||
| 10494 | 10494 | 117130 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2671 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5988936.0754 | 2097168.6937 | 37.737788261480105 | -122.480775587362 | (37.7377882614801, -122.480775587362) | |||
| 10505 | 10505 | 39952 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 10598 | 10598 | 95755 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003450.901459999 | 2092257.0440599998 | 37.725134950402705 | -122.43024050589399 | (37.7251349504027, -122.430240505894) |
| 10637 | 10637 | 46729 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 10694 | 10694 | 95758 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003422.17585 | 2092210.8120900001 | 37.7250063806226 | -122.43033651031901 | (37.7250063806226, -122.430336510319) |
| 10839 | 10839 | 95753 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003478.85461 | 2092303.3656900001 | 37.7252637225375 | -122.430147177848 | (37.7252637225375, -122.430147177848) |
| 11117 | 11117 | 97240 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003400.64895 | 2092179.59067 | 37.7249194341684 | -122.430408699814 | (37.7249194341684, -122.430408699814) |
| 11296 | 11296 | 39947 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 11344 | 11344 | 46730 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 11480 | 11480 | 95754 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003464.56282 | 2092279.46461 | 37.7251972860232 | -122.43019487878999 | (37.7251972860232, -122.43019487879) |
| 11625 | 11625 | 46731 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 12446 | 12446 | 95750 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003564.18987 | 2092436.8443200001 | 37.7256350580097 | -122.429861698861 | (37.7256350580097, -122.429861698861) |
| 12724 | 12724 | 39945 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 12755 | 12755 | 39949 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 12923 | 12923 | 111444 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 14 | 6x12 | 5999970.3074 | 2091024.03837 | 37.721551640364396 | -122.442184051271 | (37.7215516403644, -122.442184051271) | ||
| 13635 | 13635 | 39944 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 14047 | 14047 | 6510 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 1200X Evans Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15 | 6017613.51756 | 2097076.90112 | 37.7391613427334 | -122.381616361724 | (37.7391613427334, -122.381616361724) | |||
| 14428 | 14428 | 51357 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 50 Pomona St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014147.24137 | 2094593.6145900001 | 37.732150750552 | -122.393427531355 | (37.732150750552, -122.393427531355) |
| 15467 | 15467 | 46732 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 15759 | 15759 | 39948 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 16318 | 16318 | 29651 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 1500X La Salle Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015684.3928 | 2096048.7707 | 37.7362316014874 | -122.388214728777 | (37.7362316014874, -122.388214728777) | ||
| 16765 | 16765 | 29652 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 1500X La Salle Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015669.3226 | 2096063.2130000002 | 37.7362704220955 | -122.38826784077101 | (37.7362704220955, -122.388267840771) | ||
| 19137 | 19137 | 29594 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 900X Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991181.08119 | 2091145.24325 | 37.7213796099522 | -122.472574562389 | (37.7213796099522, -122.472574562389) | ||
| 19833 | 19833 | 26915 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 10 Caine Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/26/1999 12:00:00 AM | 3 | 10 | 5997570.4467 | 2089598.1443599998 | 37.7174994031582 | -122.450376943463 | (37.7174994031582, -122.450376943463) | ||
| 19990 | 19990 | 10459 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 1569 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1994 12:00:00 AM | 25 | 3X3 | 5998651.396000001 | 2108625.3987 | 37.76980545066029 | -122.44800980256201 | (37.7698054506603, -122.448009802562) | ||
| 20652 | 20652 | 44154 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 22814 | 22814 | 184050 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1600 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984953.7413 | 2103846.6967 | 37.755891966793605 | -122.495036518918 | (37.7558919667936, -122.495036518918) | |||
| 22890 | 22890 | 247970 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 159 Faith St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 8ft | 6010298.66575 | 2099104.3209599997 | 37.744321600460296 | -122.407050801679 | (37.7443216004603, -122.407050801679) | |||
| 22891 | 22891 | 247616 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Bradford St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6009490.26965 | 2096786.7692099998 | 37.737912836413706 | -122.409682528235 | (37.7379128364137, -122.409682528235) | ||||
| 22906 | 22906 | 240229 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 116 Crescent Ave | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 10ft | 6006267.81246 | 2095797.32513 | 37.7350149365947 | -122.42075393896299 | (37.7350149365947, -122.420753938963) | |||
| 23389 | 23389 | 43452 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 10 | Permit Number 43162 | 5999577.25447 | 2091228.40825 | 37.7220903846374 | -122.44355739787599 | (37.7220903846374, -122.443557397876) | |
| 23449 | 23449 | 202104 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1828 Egbert Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 6012020.3729 | 2092885.5297599998 | 37.727342303098204 | -122.400660684147 | (37.7273423030982, -122.400660684147) | |||
| 23459 | 23459 | 240288 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 3980 22nd St | 2 | : 4 | Tree 1 | Private 1 | 20 | 6001954.916780001 | 2102957.6016 | 37.7544313427449 | -122.43617736779 | (37.7544313427449, -122.43617736779) | ||||
| 23743 | 23743 | 185183 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2500 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985128.0455 | 2097828.1066 | 37.7393767603936 | -122.493990182941 | (37.7393767603936, -122.493990182941) | |||
| 23907 | 23907 | 247195 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 900 Waller St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6001251.021869999 | 2108666.7471 | 37.7700672400275 | -122.43902074711201 | (37.7700672400275, -122.439020747112) | ||||
| 24401 | 24401 | 240280 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 691 29th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6002099.074659999 | 2098828.06304 | 37.7431007968732 | -122.435383453493 | (37.7431007968732, -122.435383453493) | ||||
| 24546 | 24546 | 200029 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1575 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015274.8561 | 2094571.5849 | 37.7321528483199 | -122.38952754545 | (37.7321528483199, -122.38952754545) | |||
| 24577 | 24577 | 43433 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 16 | Permit Number 43162 | 5999846.51913 | 2091089.02473 | 37.7217230223792 | -122.442616616172 | (37.7217230223792, -122.442616616172) | |
| 24892 | 24892 | 197177 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1900 23rd St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6012740.291540001 | 2102830.02856 | 37.7546879247201 | -122.39886955298599 | (37.7546879247201, -122.398869552986) | ||||
| 25422 | 25422 | 240306 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 134 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003388.16897 | 2105086.9505 | 37.7603593535203 | -122.43137280722901 | (37.7603593535203, -122.431372807229) | |||
| 25922 | 25922 | 197195 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 1700x Quesada Ave | 52 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6014229.96459 | 2095381.0032900001 | 37.734317354963395 | -122.393196613328 | (37.7343173549634, -122.393196613328) | ||||
| 26060 | 26060 | 43443 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 03/06/2004 12:00:00 AM | 6 | Permit Number 43162 | 5999469.30626 | 2091283.8759 | 37.722236528981206 | -122.44393453036999 | (37.7222365289812, -122.44393453037) | |
| 26361 | 26361 | 200031 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1575 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015313.8786 | 2094541.9059 | 37.732073519349896 | -122.389390563006 | (37.7320735193499, -122.389390563006) | |||
| 26728 | 26728 | 197173 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1900 23rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6012739.26156 | 2102864.49072 | 37.7547824929244 | -122.39887553350201 | (37.7547824929244, -122.398875533502) | ||||
| 26754 | 26754 | 197191 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 602 Arthur Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6015839.12005 | 2099880.54912 | 37.7467614521736 | -122.38794706729799 | (37.7467614521736, -122.387947067298) | ||||
| 26786 | 26786 | 118668 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 4240 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5982392.892440001 | 2111033.85887 | 37.7754756009165 | -122.504425054608 | (37.7754756009165, -122.504425054608) | |||
| 26939 | 26939 | 179341 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 100x Mansell St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6011434.8537800005 | 2090631.08875 | 37.7211193983363 | -122.40252637270599 | (37.7211193983363, -122.402526372706) | |||
| 27096 | 27096 | 240267 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 517 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6008465.29724 | 2098131.45059 | 37.7415475462934 | -122.413321437934 | (37.7415475462934, -122.413321437934) | ||||
| 27098 | 27098 | 249881 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 230 Greenwich St | 17 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 0ft | 6011514.20842 | 2120460.74576 | 37.803029388647104 | -122.404350588107 | (37.8030293886471, -122.404350588107) | |||
| 27927 | 27927 | 247528 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1101 Waller St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000060.08033 | 2108486.82414 | 37.7695053822964 | -122.443127261125 | (37.7695053822964, -122.443127261125) | ||||
| 28102 | 28102 | 187262 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2401 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984975.6548 | 2098407.337 | 37.7409582534083 | -122.494559764363 | (37.7409582534083, -122.494559764363) | |||
| 28166 | 28166 | 247620 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Bradford St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6009499.0149 | 2096845.5713799999 | 37.7380747845204 | -122.40965644069901 | (37.7380747845204, -122.409656440699) | ||||
| 28305 | 28305 | 247111 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2301 Castro St | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6002712.026930001 | 2098697.32849 | 37.7427766218445 | -122.43325469165899 | (37.7427766218445, -122.433254691659) | ||||
| 28535 | 28535 | 136276 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1927 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6004921.8107 | 2117075.88034 | 37.7933648188709 | -122.426922521966 | (37.7933648188709, -122.426922521966) | |||
| 28704 | 28704 | 43445 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999858.82768 | 2091082.35027 | 37.7217053974709 | -122.44257358990299 | (37.7217053974709, -122.442573589903) | |
| 29435 | 29435 | 186031 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1900 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985004.6307 | 2102018.5095 | 37.7508752473191 | -122.49472575020901 | (37.7508752473191, -122.494725750209) | |||
| 29707 | 29707 | 197189 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 602 Arthur Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6015936.19644 | 2099934.12978 | 37.7469139511226 | -122.387615121238 | (37.7469139511226, -122.387615121238) | ||||
| 30011 | 30011 | 247106 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2301 Castro St | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6002702.97811 | 2098815.3340000003 | 37.7431001241765 | -122.433294410209 | (37.7431001241765, -122.433294410209) | ||||
| 30168 | 30168 | 122242 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1628 Lake St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5990370.4799 | 2114772.2223799997 | 37.7862060986385 | -122.477102214032 | (37.7862060986385, -122.477102214032) | |||
| 30396 | 30396 | 136277 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2745 Larkin St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6006529.34062 | 2120636.08267 | 37.8032309995586 | -122.421613321221 | (37.8032309995586, -122.421613321221) | ||||
| 30625 | 30625 | 240316 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 310 Liberty St | 48 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003835.66179 | 2103919.1699900003 | 37.75717825719121 | -122.429741845306 | (37.7571782571912, -122.429741845306) | |||
| 30649 | 30649 | 240300 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Clipper St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002726.96622 | 2100956.54522 | 37.748980749680705 | -122.433364440431 | (37.7489807496807, -122.433364440431) | |||
| 30845 | 30845 | 197201 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2001 Revere Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6012348.821330001 | 2096403.61302 | 37.737020542553395 | -122.399772154858 | (37.7370205425534, -122.399772154858) | ||||
| 30995 | 30995 | 240260 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005682.645959999 | 2097069.8371299999 | 37.7384759711765 | -122.42286747885001 | (37.7384759711765, -122.42286747885) | |||
| 31046 | 31046 | 247622 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Bradford St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6009485.42402 | 2096845.0974 | 37.7380727214716 | -122.409703397886 | (37.7380727214716, -122.409703397886) | ||||
| 31175 | 31175 | 247826 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 96 Banks St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6008666.54857 | 2098148.46053 | 37.741605548963896 | -122.412626779128 | (37.7416055489639, -122.412626779128) | ||||
| 31284 | 31284 | 247949 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 7 Joy St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6010404.2439 | 2098872.53529 | 37.7436910749942 | -122.406669401896 | (37.7436910749942, -122.406669401896) | ||||
| 31469 | 31469 | 185640 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2100 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985051.8314 | 2100435.5567 | 37.746531653861204 | -122.494445852676 | (37.7465316538612, -122.494445852676) | |||
| 31609 | 31609 | 240284 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 687 29th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002190.93807 | 2098832.7894099997 | 37.743118991043204 | -122.435066152888 | (37.7431189910432, -122.435066152888) | ||||
| 31690 | 31690 | 186201 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1701 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984749.405 | 2103445.7422 | 37.7547790924201 | -122.49571359587799 | (37.7547790924201, -122.495713595878) | |||
| 31727 | 31727 | 197188 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1800 Illinois St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6016258.08648 | 2100618.43223 | 37.748810728335705 | -122.386549751994 | (37.7488107283357, -122.386549751994) | |||
| 31729 | 31729 | 240297 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Clipper St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002954.68882 | 2100970.7991299997 | 37.74903280421721 | -122.432577993181 | (37.7490328042172, -122.432577993181) | |||
| 32035 | 32035 | 247948 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 7 Joy St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6010393.64964 | 2098873.99577 | 37.7436944924075 | -122.406706137374 | (37.7436944924075, -122.406706137374) | ||||
| 32218 | 32218 | 240217 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 116 Crescent Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 10ft | 6006077.44236 | 2095815.2832099998 | 37.73505351389 | -122.42141339202298 | (37.73505351389, -122.421413392023) | |||
| 32440 | 32440 | 197209 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 91 Kiska Rd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6019354.09765 | 2093629.3399099999 | 37.729790960977205 | -122.375359249432 | (37.7297909609772, -122.375359249432) | ||||
| 33136 | 33136 | 240242 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 351 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006956.98547 | 2096047.9435299998 | 37.73574189906971 | -122.41838898186701 | (37.7357418990697, -122.418388981867) | |||
| 33278 | 33278 | 247842 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 74 Nevada St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 6009022.44109 | 2098193.5019099996 | 37.741749190479396 | -122.411399399688 | (37.7417491904794, -122.411399399688) | |||
| 33677 | 33677 | 43434 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999832.90051 | 2091096.8327900001 | 37.7217436851966 | -122.44266425237 | (37.7217436851966, -122.44266425237) | |
| 34358 | 34358 | 136279 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1151 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6006698.81265 | 2120089.55435 | 37.8017399263049 | -122.420988029784 | (37.8017399263049, -122.420988029784) | ||||
| 35074 | 35074 | 240231 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 116 Crescent Ave | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 10ft | 6006293.37748 | 2095794.5924900002 | 37.7350088742503 | -122.420665357522 | (37.7350088742503, -122.420665357522) | |||
| 35207 | 35207 | 240218 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 116 Crescent Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 10ft | 6006103.73166 | 2095810.88544 | 37.7350429207983 | -122.421322188175 | (37.7350429207983, -122.421322188175) | |||
| 35699 | 35699 | 117207 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1300x De Haro St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 13 | 6012255.77341 | 2102253.00873 | 37.753076544652 | -122.40050462841002 | (37.753076544652, -122.40050462841) | ||||
| 35717 | 35717 | 185687 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2101 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984902.932 | 2100564.5408 | 37.7468770936492 | -122.49497023200001 | (37.7468770936492, -122.494970232) | |||
| 35779 | 35779 | 136278 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2507 Larkin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006657.1862 | 2120015.9614 | 37.8015355122184 | -122.421126848223 | (37.8015355122184, -122.421126848223) | |||
| 35786 | 35786 | 52156 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 1771 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 11 | Permit Number 48348 | 6014341.22767 | 2095259.71993 | 37.733990516146996 | -122.392803455827 | (37.733990516147, -122.392803455827) | |
| 36356 | 36356 | 185174 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2500 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985128.7096 | 2097775.6475 | 37.7392327606429 | -122.49398402167401 | (37.7392327606429, -122.493984021674) | |||
| 36600 | 36600 | 246014 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1569 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998668.6573 | 2108626.9128 | 37.7698105946696 | -122.44795020544599 | (37.7698105946696, -122.447950205446) | |||
| 37017 | 37017 | 240304 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 4185 25th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002908.0812800005 | 2101214.2225599997 | 37.7496985444673 | -122.43275654908899 | (37.7496985444673, -122.432756549089) | |||
| 37334 | 37334 | 185718 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2101 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984903.2589 | 2100385.7239 | 37.7463861302867 | -122.494955918818 | (37.7463861302867, -122.494955918818) |
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");