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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 136346 | 136346 | 181603 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1314 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5981535.279 | 2106095.7698 | 37.761866563063606 | -122.507025301007 | (37.7618665630636, -122.507025301007) | |||
| 78512 | 78512 | 37091 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1322 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39691 | 5981539.4678591 | 2106068.94026925 | 37.7617931435706 | -122.507008823366 | (37.7617931435706, -122.507008823366) | ||
| 119503 | 119503 | 34705 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 636 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | 10 | Permit Number 45853 | 5981667.05169 | 2111389.6356900004 | 37.776409740900505 | -122.506962263473 | (37.7764097409005, -122.506962263473) | |
| 148654 | 148654 | 37097 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1519 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 6 | Permit Number 39697 | 5981538.3257 | 2104728.8582 | 37.7581135944315 | -122.506913367496 | (37.7581135944315, -122.506913367496) | |
| 43234 | 43234 | 92450 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1418 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52841 | 5981557.2817 | 2105400.2784 | 37.7599582387991 | -122.506897613129 | (37.7599582387991, -122.506897613129) |
| 146624 | 146624 | 119104 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 823 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5981668.33405 | 2110105.84883 | 37.7728849141057 | -122.50686258103201 | (37.7728849141057, -122.506862581032) | |||
| 95332 | 95332 | 109135 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 730 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773524 | 5981688.65422 | 2110759.10113 | 37.774679750310504 | -122.506840755547 | (37.7746797503105, -122.506840755547) |
| 45706 | 45706 | 183641 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1484 47th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5981572.5337 | 2105003.3239 | 37.7588692133791 | -122.50681542120701 | (37.7588692133791, -122.506815421207) | |||
| 99608 | 99608 | 83222 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1484 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50173 | 5981572.5337 | 2104980.0444 | 37.7588052945195 | -122.506813694508 | (37.7588052945195, -122.506813694508) | |
| 177021 | 177021 | 37098 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1526 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 6 | Permit Number 39698 | 5981582.6318 | 2104677.2186 | 37.757974415915704 | -122.506756310539 | (37.7579744159157, -122.506756310539) | |
| 66307 | 66307 | 118815 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 838 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5981714.73758 | 2110032.93267 | 37.7726874401676 | -122.506696659484 | (37.7726874401676, -122.506696659484) | |||
| 13020 | 13020 | 87559 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4135 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 3 | 3x3 | 5981638.7597 | 2105526.7098 | 37.7603101811501 | -122.506625202077 | (37.7603101811501, -122.506625202077) | ||
| 12025 | 12025 | 11599 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4136 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3X3 | 5981645.3397 | 2105589.2786 | 37.7604823646112 | -122.506607085828 | (37.7604823646112, -122.506607085828) | ||
| 68116 | 68116 | 184491 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1835 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981609.8362 | 2102589.8885 | 37.752244801429704 | -122.506507430856 | (37.7522448014297, -122.506507430856) | |||
| 66923 | 66923 | 184506 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1883 47th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5981616.9431 | 2102289.37 | 37.7514200808256 | -122.506460570212 | (37.7514200808256, -122.506460570212) | |||
| 100000 | 100000 | 88106 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1883 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51111 | 5981622.6 | 2102278.7 | 37.7513911170729 | -122.50644021712799 | (37.7513911170729, -122.506440217128) | |||
| 156361 | 156361 | 250992 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 401 45th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5981868.90383 | 2112895.86911 | 37.7805572993057 | -122.50637573525299 | (37.7805572993057, -122.506375735253) | |||
| 118837 | 118837 | 39826 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2050 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41151 | 5981707.40217045 | 2101129.10059865 | 37.74823963248679 | -122.50606173823999 | (37.7482396324868, -122.50606173824) | ||
| 27060 | 27060 | 92454 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2343 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52844 | 5981710.4 | 2099132.4 | 37.742757425745204 | -122.50590336010201 | (37.7427574257452, -122.505903360102) |
| 140914 | 140914 | 114321 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2118 47th Ave | 1 | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 01/14/2016 12:00:00 AM | 5x16 | Permit Number 777356 | 5981743.9 | 2100646.6 | 37.7469169691931 | -122.505899765145 | (37.7469169691931, -122.505899765145) | ||
| 160842 | 160842 | 92238 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 755 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52682 | 5981959.3415 | 2110617.2710599997 | 37.7743062629464 | -122.505893892632 | (37.7743062629464, -122.505893892632) | |
| 103440 | 103440 | 49299 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | Permit Number 46308 | 5981983.67174659 | 2111322.12522882 | 37.7762430181484 | -122.505861998148 | (37.7762430181484, -122.505861998148) | |||
| 20298 | 20298 | 115181 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2166 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775165 | 5981753.9 | 2100346.3 | 37.7460930178281 | -122.505842927008 | (37.7460930178281, -122.505842927008) | |||
| 112075 | 112075 | 109252 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2443 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773556 | 5981723.0 | 2098451.0 | 37.7408872317264 | -122.505809288749 | (37.7408872317264, -122.505809288749) |
| 60471 | 60471 | 118447 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5340 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5982007.49823 | 2111698.26933 | 37.7772772018239 | -122.50580746931401 | (37.7772772018239, -122.505807469314) | |||
| 139876 | 139876 | 31650 | Section 143 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3632 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2015 12:00:00 AM | 3 | Permit Number 35160 | 5981711.46236471 | 2097421.70961548 | 37.7380604052223 | -122.505772893936 | (37.7380604052223, -122.505772893936) | ||
| 183386 | 183386 | 47822 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 734 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/2002 12:00:00 AM | 8 | Permit Number 45586 | 5981999.5406599995 | 2110743.7888 | 37.7746560097186 | -122.50576421992201 | (37.7746560097186, -122.505764219922) | |
| 84869 | 84869 | 49400 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2491 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2003 12:00:00 AM | 3x3 | Permit Number 46353 | 5981758.62772089 | 2098146.5639461996 | 37.7400534313459 | -122.50566354107201 | (37.7400534313459, -122.505663541072) | ||
| 35025 | 35025 | 38349 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1675 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1998 12:00:00 AM | 7 | Permit Number 40416 | 5981884.0826 | 2103708.5586 | 37.7553324970038 | -122.505641978834 | (37.7553324970038, -122.505641978834) | |
| 44488 | 44488 | 118446 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5340 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5982058.186369999 | 2111701.32913 | 37.7772885863928 | -122.505632352598 | (37.7772885863928, -122.505632352598) | |||
| 149334 | 149334 | 92447 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1691 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52838 | 5981885.7633 | 2103607.1079 | 37.755054041014496 | -122.505628646518 | (37.7550540410145, -122.505628646518) |
| 62223 | 62223 | 92448 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2079 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52839 | 5981971.4399 | 2100959.3723 | 37.7477891451677 | -122.50513614233401 | (37.7477891451677, -122.505136142334) |
| 88836 | 88836 | 11585 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4016 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2015 01:17:00 PM | 3 | 3X3 | 5982093.476829 | 2105597.6230544 | 37.76053165282279 | -122.505057830402 | (37.7605316528228, -122.505057830402) | ||
| 24691 | 24691 | 184897 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3876 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982051.8151 | 2102884.4847 | 37.7530796928065 | -122.505000853838 | (37.7530796928065, -122.505000853838) | |||
| 90339 | 90339 | 100523 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4012 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5982110.0 | 2105587.0 | 37.760503457086394 | -122.504999898043 | (37.7605034570864, -122.504999898043) | ||||
| 60708 | 60708 | 183356 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1236 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5982135.7203 | 2106671.3636 | 37.763482322741794 | -122.504991303533 | (37.7634823227418, -122.504991303533) | |||
| 108281 | 108281 | 86828 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1236 45th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2007 12:00:00 AM | 3x3 | Permit Number 49772 | 5982170.1 | 2106680.3 | 37.7635088821672 | -122.50487305941601 | (37.7635088821672, -122.504873059416) | |||
| 184995 | 184995 | 34696 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 626 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 11 | Permit Number 38355 | 5982285.35898 | 2111475.04889 | 37.776680654232 | -122.504829731264 | (37.776680654232, -122.504829731264) | |
| 70533 | 70533 | 34697 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 626 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 14 | Permit Number 38355 | 5982286.66539 | 2111456.97442 | 37.7766311038854 | -122.504823872464 | (37.7766311038854, -122.504823872464) | |
| 27108 | 27108 | 47884 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1422 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2002 12:00:00 AM | 5 | Permit Number 45630 | 5982179.6052 | 2105409.3092 | 37.7600196636967 | -122.504746003202 | (37.7600196636967, -122.504746003202) | |
| 168222 | 168222 | 119024 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 829 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5982287.30871 | 2110123.0734200003 | 37.772968638986605 | -122.50472278774599 | (37.7729686389866, -122.504722787746) | |||
| 134647 | 134647 | 119022 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 829 44th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5982288.37392 | 2110096.02661 | 37.7728944389784 | -122.50471709870399 | (37.7728944389784, -122.504717098704) | |||
| 77088 | 77088 | 119017 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 853 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5982291.47826 | 2109946.6461099996 | 37.7724844661882 | -122.50469529028798 | (37.7724844661882, -122.504695290288) | |||
| 48569 | 48569 | 33851 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 869 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 1 | Permit Number 38356 | 5982297.1677 | 2109841.1575700003 | 37.7721951599998 | -122.504667792871 | (37.7721951599998, -122.504667792871) | |
| 164747 | 164747 | 79480 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 881 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 7 | 5982298.725380001 | 2109767.28551 | 37.7719924204152 | -122.50465693044599 | (37.7719924204152, -122.504656930446) | ||
| 41439 | 41439 | 183204 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2497 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5982070.7667 | 2098173.484 | 37.7401457120377 | -122.50458630492099 | (37.7401457120377, -122.504586304921) | |||
| 132676 | 132676 | 115852 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2519 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5982081.5962 | 2097932.5277 | 37.7394847493725 | -122.504531014038 | (37.7394847493725, -122.504531014038) | |||
| 51413 | 51413 | 118535 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7915 Geary Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5982438.45196 | 2112345.43604 | 37.7790794873063 | -122.50436464200199 | (37.7790794873063, -122.504364642002) | |||
| 186319 | 186319 | 92449 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2675 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52840 | 5982115.1 | 2096904.0638 | 37.7366628403304 | -122.504339004693 | (37.7366628403304, -122.504339004693) |
| 133215 | 133215 | 118534 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7915 Geary Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5982448.31014 | 2112345.83773 | 37.7790811700363 | -122.504330568895 | (37.7790811700363, -122.504330568895) | |||
| 54935 | 54935 | 35232 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5220 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1998 12:00:00 AM | 13 | Permit Number 38726 | 5982438.08488 | 2111717.1937700002 | 37.777354496722204 | -122.50431935881201 | (37.7773544967222, -122.504319358812) | ||
| 55482 | 55482 | 96112 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7909 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767767 | 5982473.14559 | 2112346.12315 | 37.7790834143652 | -122.504244675585 | (37.7790834143652, -122.504244675585) |
| 99216 | 99216 | 11580 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3940 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5982333.0 | 2105594.0 | 37.760535794591 | -122.504229174925 | (37.760535794591, -122.504229174925) | |||
| 110905 | 110905 | 115178 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2582 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775071 | 5982161.7 | 2097535.9 | 37.7384004300806 | -122.50422468152 | (37.7384004300806, -122.50422468152) | |||
| 155773 | 155773 | 34720 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5208 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2012 12:00:00 AM | 2 | Permit Number 768608 | 5982492.22615 | 2111717.77987 | 37.7773592900989 | -122.50413211310301 | (37.7773592900989, -122.504132113103) | |
| 104806 | 104806 | 11578 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3930 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | 4x10 | Permit Number 773955 | 5982364.0 | 2105595.0 | 37.760540363416 | -122.50412203598302 | (37.760540363416, -122.504122035983) | |
| 168008 | 168008 | 184395 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2051 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982278.8961 | 2101152.7804 | 37.7483382752973 | -122.504087316185 | (37.7483382752973, -122.504087316185) | |||
| 63453 | 63453 | 184393 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2067 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982283.9724 | 2101048.208 | 37.7480514471675 | -122.504062018098 | (37.7480514471675, -122.504062018098) | |||
| 61976 | 61976 | 34694 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4201 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 11 | Permit Number 38353 | 5982506.5012300005 | 2110978.55667 | 37.775330438700706 | -122.504027964223 | (37.7753304387007, -122.504027964223) | |
| 100808 | 100808 | 11569 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1391X 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 5982433.6200097 | 2105656.9427051996 | 37.760714534455204 | -122.503885844083 | (37.7607145344552, -122.503885844083) | |||
| 148725 | 148725 | 78560 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2214 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 3 | 5982364.6255 | 2099997.6781 | 37.7451717266117 | -122.503705339024 | (37.7451717266117, -122.503705339024) | ||
| 117107 | 117107 | 83280 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2214 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50749 | 5982366.31303644 | 2100025.86427415 | 37.7452492172532 | -122.503701590924 | (37.7452492172532, -122.503701590924) | ||
| 137019 | 137019 | 118981 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 829 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5982598.44932 | 2110129.84986 | 37.773005543342 | -122.50364703451 | (37.773005543342, -122.50364703451) | |||
| 50423 | 50423 | 118980 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 829 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5982602.23539 | 2110104.87447 | 37.772937190770705 | -122.503632088344 | (37.7729371907707, -122.503632088344) | |||
| 40419 | 40419 | 31625 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2479 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | 7 | Permit Number 35142 | 5982380.9303 | 2098242.6913 | 37.740353975903 | -122.503519026665 | (37.740353975903, -122.503519026665) | |
| 189088 | 189088 | 92444 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2643 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52835 | 5982411.0946 | 2097116.4843 | 37.737263493476 | -122.503331364341 | (37.737263493476, -122.503331364341) |
| 100095 | 100095 | 115275 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2474 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 774024 | 5982446.7 | 2098277.8 | 37.7404542411895 | -122.503294223796 | (37.7404542411895, -122.503294223796) | |||
| 188945 | 188945 | 69003 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2063 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 5 | Permit Number 33004 | 5982592.2747 | 2101083.7423 | 37.7481671399171 | -122.502998568536 | (37.7481671399171, -122.502998568536) | |
| 131051 | 131051 | 34821 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 420 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 9 | Permit Number 38709 | 5982850.46473 | 2112964.10634 | 37.7808023985461 | -122.50298515940399 | (37.7808023985461, -122.502985159404) | |
| 167640 | 167640 | 34822 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 420 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 4 | Permit Number 38709 | 5982851.81214 | 2112946.0180599997 | 37.780752812635896 | -122.50297915864901 | (37.7807528126359, -122.502979158649) | |
| 170016 | 170016 | 34823 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 456 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 9 | Permit Number 38710 | 5982857.51901 | 2112741.1167099997 | 37.780190549097 | -122.502944242938 | (37.780190549097, -122.502944242938) | |
| 163272 | 163272 | 44735 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 566 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 2 | 3x3 | Permit Number 43851 | 5982889.14575 | 2111926.60569 | 37.7779559990764 | -122.502774523335 | (37.7779559990764, -122.502774523335) |
| 130996 | 130996 | 83210 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2363 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50732 | 5982660.2975 | 2099043.5665 | 37.7425693794304 | -122.502612365401 | (37.7425693794304, -122.502612365401) | |
| 141854 | 141854 | 81731 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2371 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2015 12:00:00 AM | 3x3 | Permit Number 774678 | 5982660.98623523 | 2098988.34584031 | 37.7424177991727 | -122.502605897625 | (37.7424177991727, -122.502605897625) | ||
| 168634 | 168634 | 92438 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2290 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52828 | 5982689.0719 | 2099536.3342 | 37.7439240746075 | -122.502549337764 | (37.7439240746075, -122.502549337764) |
| 34950 | 34950 | 183357 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2401 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5982674.1728 | 2098736.2795 | 37.7417264692194 | -122.502541650734 | (37.7417264692194, -122.502541650734) | |||
| 66353 | 66353 | 117881 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 742 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982932.01686 | 2110709.95222 | 37.774617942415794 | -122.502536146409 | (37.7746179424158, -122.502536146409) | |||
| 159642 | 159642 | 183358 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2401 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5982675.8649 | 2098704.8062 | 37.7416401516196 | -122.50253347117399 | (37.7416401516196, -122.502533471174) | |||
| 182015 | 182015 | 183359 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2401 44th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5982675.5265 | 2098670.6256 | 37.7415462812002 | -122.502532111963 | (37.7415462812002, -122.502532111963) | |||
| 92585 | 92585 | 109274 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2471 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773741 | 5982670.2 | 2098312.5 | 37.7405626536351 | -122.502524028762 | (37.7405626536351, -122.502524028762) |
| 120230 | 120230 | 109273 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2471 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773741 | 5982670.2 | 2098312.5 | 37.7405626536351 | -122.502524028762 | (37.7405626536351, -122.502524028762) |
| 93866 | 93866 | 87361 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3401 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2008 12:00:00 AM | 3x3 | Permit Number 50345 | 5982691.0 | 2098770.0 | 37.741820045233396 | -122.502485963998 | (37.7418200452334, -122.502485963998) | ||
| 111404 | 111404 | 87362 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3401 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2008 12:00:00 AM | 3x3 | Permit Number 50345 | 5982691.0 | 2098770.0 | 37.741820045233396 | -122.502485963998 | (37.7418200452334, -122.502485963998) | ||
| 117914 | 117914 | 87360 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3401 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2008 12:00:00 AM | 3x3 | Permit Number 50345 | 5982691.0 | 2098770.0 | 37.741820045233396 | -122.502485963998 | (37.7418200452334, -122.502485963998) | ||
| 143987 | 143987 | 83994 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2346 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50989 | 5982707.54204511 | 2099147.52139682 | 37.7428575871403 | -122.502456702486 | (37.7428575871403, -122.502456702486) | ||
| 78982 | 78982 | 115236 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 742 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775515 | 5982957.8 | 2110723.0 | 37.7746552828593 | -122.502447924769 | (37.7746552828593, -122.502447924769) | |||
| 147467 | 147467 | 82811 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2362 44th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50731 | 5982709.1994 | 2099047.2891 | 37.742582474230396 | -122.502443555218 | (37.7425824742304, -122.502443555218) | |
| 99870 | 99870 | 86902 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2426 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49850 | 5982746.8 | 2098587.4 | 37.7413219544677 | -122.50227951888701 | (37.7413219544677, -122.502279518887) | ||
| 63404 | 63404 | 96078 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 442 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767702 | 5983166.63453 | 2112823.2290000003 | 37.7804341684029 | -122.50188096554501 | (37.7804341684029, -122.501880965545) |
| 53505 | 53505 | 96077 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 442 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767702 | 5983166.97254 | 2112802.17844 | 37.7803763895854 | -122.501878238244 | (37.7803763895854, -122.501878238244) |
| 159978 | 159978 | 37068 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1246 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 7 | Permit Number 39670 | 5983068.4485 | 2106652.21 | 37.763484564296 | -122.501763930735 | (37.763484564296, -122.501763930735) | |
| 18682 | 18682 | 87286 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1272 42nd Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/18/2007 12:00:00 AM | Permit Number 50303 | 5983096.8 | 2106514.6 | 37.7631083916796 | -122.501655692289 | (37.7631083916796, -122.501655692289) | ||||
| 155466 | 155466 | 37140 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1998 12:00:00 AM | 6 | Permit Number 39721 | 5983218.67012 | 2111364.16792 | 37.7764310689034 | -122.501592980917 | (37.7764310689034, -122.501592980917) | |
| 9578 | 9578 | 24736 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7630 Geary Blvd To Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774506 | 5983286.15671 | 2112505.7286099996 | 37.7795694254676 | -122.501443995349 | (37.7795694254676, -122.501443995349) | |
| 157628 | 157628 | 55027 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 778 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 1 | Permit Number 10905 | 5983249.97018 | 2110500.81552 | 37.7740623919664 | -122.501420826879 | (37.7740623919664, -122.501420826879) | ||
| 42020 | 42020 | 84029 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1683 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51102 | 5983124.4107 | 2103700.0852 | 37.755382150486895 | -122.501351994362 | (37.7553821504869, -122.501351994362) | |
| 161058 | 161058 | 88098 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1683 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51102 | 5983125.7585 | 2103683.911 | 37.7553378198225 | -122.50134613698098 | (37.7553378198225, -122.501346136981) | |
| 145719 | 145719 | 24795 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7623 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2015 10:36:00 AM | 3 | 3x3 | 5983335.39442 | 2112375.61281 | 37.77921505706129 | -122.501264036739 | (37.7792150570613, -122.501264036739) | ||
| 23979 | 23979 | 82809 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2466 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50725 | 5983047.875 | 2098352.5376 | 37.7406947715348 | -122.501221156521 | (37.7406947715348, -122.501221156521) | |
| 47814 | 47814 | 81738 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 551 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 10 | 3x3 | Permit Number 49967 | 5983457.8508 | 2112058.23753 | 37.778350827438004 | -122.500816939825 | (37.778350827438, -122.500816939825) |
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");