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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92887 | 92887 | 121667 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 243 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992346.75268289 | 2097836.73381964 | 37.7398201819052 | -122.469031933295 | (37.7398201819052, -122.469031933295) | |||||
| 92902 | 92902 | 85305 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 365 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2007 12:00:00 AM | Permit Number 49591 | 5995968.6 | 2095545.0 | 37.733736241833704 | -122.456343520233 | (37.7337362418337, -122.456343520233) | |||
| 92936 | 92936 | 34180 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1997 12:00:00 AM | Permit Number 38006 | 5998990.33122805 | 2116224.12146592 | 37.7906889445626 | -122.447384447462 | (37.7906889445626, -122.447384447462) | |||
| 93038 | 93038 | 42562 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51025 | 5992910.18577839 | 2095362.95085697 | 37.7330603317539 | -122.46690404336 | (37.7330603317539, -122.46690404336) | ||
| 93328 | 93328 | 24934 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/28/1999 12:00:00 AM | 24 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 93440 | 93440 | 50998 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2404 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | Permit Number 47480 | 6002104.70119173 | 2117406.84878453 | 37.7941138815303 | -122.43669360820499 | (37.7941138815303, -122.436693608205) | |||
| 93494 | 93494 | 12757 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1739 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 5990002.61461 | 2114703.0924299997 | 37.7859949384969 | -122.47836986084299 | (37.7859949384969, -122.478369860843) | |||
| 93502 | 93502 | 97262 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1994@ Octavia Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004661.4 | 2117107.1 | 37.7934358122691 | -122.427825787413 | (37.7934358122691, -122.427825787413) | |||||
| 93554 | 93554 | 87293 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 763 45th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | |||
| 93574 | 93574 | 100394 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1800X Lincoln Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | ||||
| 93820 | 93820 | 50105 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672002 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | ||
| 94246 | 94246 | 39249 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3168 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.41298280187401 | (37.7483859278404, -122.412982801874) | |||
| 94268 | 94268 | 50109 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1562 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.736989442757505 | -122.468964178249 | (37.7369894427575, -122.468964178249) | ||
| 94285 | 94285 | 38514 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2735 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1998 12:00:00 AM | Permit Number 40502 | 5999957.99990299 | 2117760.48412278 | 37.794962640323796 | -122.44414682155701 | (37.7949626403238, -122.444146821557) | |||
| 94339 | 94339 | 85503 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 94557 | 94557 | 38644 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2371 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/1998 12:00:00 AM | Permit Number 40569 | 5991667.78903268 | 2099298.30551377 | 37.7437940310181 | -122.47148595434099 | (37.7437940310181, -122.471485954341) | |||
| 94598 | 94598 | 50108 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1562 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.736989442757505 | -122.468964178249 | (37.7369894427575, -122.468964178249) | ||
| 95359 | 95359 | 32033 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3321 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | Permit Number 35417 | 6004720.37722217 | 2106583.67854581 | 37.7645444241082 | -122.42687191328999 | (37.7645444241082, -122.42687191329) | |||
| 95384 | 95384 | 87010 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 95715 | 95715 | 20475 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1203X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 96356 | 96356 | 12740 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1637 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 5990313.43665 | 2114711.3516599997 | 37.7860356551531 | -122.477295116444 | (37.7860356551531, -122.477295116444) | |||
| 96476 | 96476 | 30421 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 530 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/1956 12:00:00 AM | Permit Number 75 | 6009285.11323863 | 2120849.80325768 | 37.803972827810995 | -122.412091961384 | (37.803972827811, -122.412091961384) | |||
| 96683 | 96683 | 11823 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1299X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | |||
| 97092 | 97092 | 5467 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 600X Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||||
| 97219 | 97219 | 52877 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1801@ NORIEGA 08th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48888 | 5993719.57975271 | 2103223.93352011 | 37.7546912902093 | -122.464676406209 | (37.7546912902093, -122.464676406209) | ||||
| 97293 | 97293 | 55547 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 90- 92 CASELLI AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1972 12:00:00 AM | Permit Number 11515 | 6000515.5 | 2104940.8 | 37.759794835822 | -122.44129751840201 | (37.759794835822, -122.441297518402) | |||
| 97670 | 97670 | 49320 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 595 Marina Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | Permit Number 46320 | 6000116.71946789 | 2121594.09727993 | 37.805497772658704 | -122.443873196152 | (37.8054977726587, -122.443873196152) | |||
| 98074 | 98074 | 49016 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 San Marcos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46202 | 5993947.57587841 | 2100008.88350341 | 37.745876723459396 | -122.463654612612 | (37.7458767234594, -122.463654612612) | ||||
| 98077 | 98077 | 96646 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2350 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2011 12:00:00 AM | Permit Number 768028 | 5991735.4 | 2099423.9 | 37.7441427924065 | -122.471261322589 | (37.7441427924065, -122.471261322589) | |||
| 98425 | 98425 | 103283 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3195X Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998987.7 | 2116257.6 | 37.790780717413 | -122.44739596204201 | (37.790780717413, -122.447395962042) | ||||
| 98432 | 98432 | 87964 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 393 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895.0 | 2121449.0 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | ||
| 98768 | 98768 | 12732 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1619 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990481.52989 | 2114717.45643 | 37.7860621686584 | -122.476714011555 | (37.7860621686584, -122.476714011555) | |||
| 99271 | 99271 | 48968 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 420 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2002 12:00:00 AM | Permit Number 46156 | 5996812.82347571 | 2110321.29788885 | 37.77435668197629 | -122.454491869748 | (37.7743566819763, -122.454491869748) | |||
| 99323 | 99323 | 38645 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2371 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 40569 | 5991667.78903268 | 2099298.30551377 | 37.7437940310181 | -122.47148595434099 | (37.7437940310181, -122.471485954341) | ||||
| 99473 | 99473 | 3689 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 99503 | 99503 | 87963 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 393 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895.0 | 2121449.0 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | ||
| 99539 | 99539 | 6978 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 762 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003781.28082 | 2110436.25509 | 37.77506951805171 | -122.430394888902 | (37.7750695180517, -122.430394888902) | |||
| 99794 | 99794 | 99904 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 99850 | 99850 | 97888 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 30 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768367 | 6003432.2 | 2108510.8 | 37.7697629112822 | -122.431464951074 | (37.7697629112822, -122.431464951074) | ||||
| 100372 | 100372 | 30856 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 100425 | 100425 | 99855 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2900 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768992 | 5999541.6 | 2118827.3 | 37.7978680691774 | -122.44566437565099 | (37.7978680691774, -122.445664375651) | ||||
| 100701 | 100701 | 5321 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1861X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001005.43894 | 2114739.90905 | 37.7867286257608 | -122.440305813645 | (37.7867286257608, -122.440305813645) | |||
| 100857 | 100857 | 6573 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1329 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6017090.4856833 | 2097396.2206334 | 37.7400092370914 | -122.383447010551 | (37.7400092370914, -122.383447010551) | |||
| 100882 | 100882 | 99854 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 755 Marina Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x7 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.805088551244204 | -122.446400961387 | (37.8050885512442, -122.446400961387) | |||
| 101130 | 101130 | 32029 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3321 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | Permit Number 35417 | 6004720.37722217 | 2106583.67854581 | 37.7645444241082 | -122.42687191328999 | (37.7645444241082, -122.42687191329) | |||
| 101295 | 101295 | 51634 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 77 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47924 | 6005437.59121376 | 2109217.8235753 | 37.771817682613296 | -122.42457865203698 | (37.7718176826133, -122.424578652037) | |||
| 101444 | 101444 | 12809 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2112 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 5 | 5988863.55424 | 2114711.62184 | 37.7859521665696 | -122.482311278452 | (37.7859521665696, -122.482311278452) | |||
| 101445 | 101445 | 51666 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 444 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2005 12:00:00 AM | Permit Number 47943 | 5998559.54409269 | 2106579.38545488 | 37.7641823653154 | -122.44818016830799 | (37.7641823653154, -122.448180168308) | |||
| 101610 | 101610 | 20510 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1211X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 102341 | 102341 | 23450 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6006201.29445 | 2118123.14104 | 37.796312596515 | -122.422569862433 | (37.796312596515, -122.422569862433) | |||
| 102735 | 102735 | 100393 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1800X Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | ||||
| 102797 | 102797 | 50102 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1530 Portola Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.737221572040205 | -122.468657807095 | (37.7372215720402, -122.468657807095) | ||
| 102905 | 102905 | 88602 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 370 Parnassus Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51547 | 5996151.9 | 2106560.1 | 37.7639914803102 | -122.45650607155001 | (37.7639914803102, -122.45650607155) | |||
| 102978 | 102978 | 11789 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
| 103604 | 103604 | 99607 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2801X Buchanan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 43709 | 6003513.0 | 2117956.0 | 37.7957016423098 | -122.43185997681299 | (37.7957016423098, -122.431859976813) | |||
| 103709 | 103709 | 113061 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2775 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 776016 | 6000301.4 | 2117440.5 | 37.7941036326689 | -122.442935620895 | (37.7941036326689, -122.442935620895) | |||
| 103717 | 103717 | 12749 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1714 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3X3 | 5990095.47734 | 2114754.58354 | 37.7861417091128 | -122.478052350416 | (37.7861417091128, -122.478052350416) | |||
| 103795 | 103795 | 92788 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53006 | 6001506.4 | 2107657.3 | 37.7673100756575 | -122.438065079874 | (37.7673100756575, -122.438065079874) | |||
| 103798 | 103798 | 52660 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1596 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 5.5x6 | Permit Number 48740 | 5993413.6797412 | 2104632.19014775 | 37.7585403580185 | -122.465836598218 | (37.7585403580185, -122.465836598218) | ||
| 103801 | 103801 | 49319 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 595 Marina Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | Permit Number 46320 | 6000116.71946789 | 2121594.09727993 | 37.805497772658704 | -122.443873196152 | (37.8054977726587, -122.443873196152) | |||
| 104318 | 104318 | 58830 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 733 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1979 12:00:00 AM | 24 | Permit Number 18084 | 6007395.77559951 | 2095369.75005937 | 37.733904419549106 | -122.41682387668301 | (37.7339044195491, -122.416823876683) | ||
| 104591 | 104591 | 34161 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 679 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37994 | 5993148.74751892 | 2110862.72772908 | 37.7756324789651 | -122.46720585808399 | (37.7756324789651, -122.467205858084) | ||||
| 104646 | 104646 | 30855 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 104780 | 104780 | 95658 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 499@Cervantes Marina Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 104818 | 104818 | 51665 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 444 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2005 12:00:00 AM | Permit Number 47943 | 5998559.54409269 | 2106579.38545488 | 37.7641823653154 | -122.44818016830799 | (37.7641823653154, -122.448180168308) | |||
| 104949 | 104949 | 98318 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1811 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773893 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | |
| 105209 | 105209 | 30323 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 720 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1956 12:00:00 AM | Permit Number 16 | 6011772.9424544005 | 2117800.56968196 | 37.7957396438077 | -122.403267984357 | (37.7957396438077, -122.403267984357) | |||
| 105438 | 105438 | 53937 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 174 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1972 12:00:00 AM | 12 | 3x4 | Permit Number 9651 | 5993070.40109 | 2114326.65829 | 37.7851389689099 | -122.467728857293 | (37.7851389689099, -122.467728857293) | |
| 105523 | 105523 | 98600 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2195X Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1981 12:00:00 AM | 3x3 | Permit Number 768644 | 6002468.0 | 2118693.0 | 37.7976659583882 | -122.435528609991 | (37.7976659583882, -122.435528609991) | ||
| 105646 | 105646 | 99900 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 105979 | 105979 | 109048 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2146 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 774033 | 6000515.3 | 2120331.0 | 37.802052372900896 | -122.442403120222 | (37.8020523729009, -122.442403120222) | ||||
| 106304 | 106304 | 87292 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 763 45th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | |||
| 106622 | 106622 | 48778 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1144REVISED Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46034 | 6000652.0009049 | 2108954.44361468 | 37.770823081138296 | -122.441113390762 | (37.7708230811383, -122.441113390762) | ||||
| 107042 | 107042 | 24929 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 107152 | 107152 | 39257 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3168 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.41298280187401 | (37.7483859278404, -122.412982801874) | |||
| 107225 | 107225 | 41576 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/22/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53640 | 6004804.85382115 | 2107218.95663379 | 37.7662935218736 | -122.426624972491 | (37.7662935218736, -122.426624972491) | |
| 107434 | 107434 | 42535 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3800 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2005 12:00:00 AM | Permit Number 47852 | 5996586.74903344 | 2115641.8686237 | 37.788952592538706 | -122.455658560713 | (37.7889525925387, -122.455658560713) | |||
| 108115 | 108115 | 12747 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1711 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 5x5 | 5990137.03852 | 2114678.28277 | 37.7859346208741 | -122.47790298136299 | (37.7859346208741, -122.477902981363) | |||
| 108564 | 108564 | 12808 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2112 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5 | 5988878.34651 | 2114712.3148 | 37.7859549296707 | -122.482260152644 | (37.7859549296707, -122.482260152644) | |||
| 108852 | 108852 | 98702 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3150 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2012 12:00:00 AM | 4x4 | Permit Number 768335 | 5999122.2 | 2116336.3 | 37.79100449175579 | -122.446936266113 | (37.7910044917558, -122.446936266113) | ||
| 109013 | 109013 | 50104 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1530 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.737221572040205 | -122.468657807095 | (37.7372215720402, -122.468657807095) | ||
| 109092 | 109092 | 115175 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1899X 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x20 | Permit Number 775764 | 5993756.36006 | 2102907.65397 | 37.7538249882276 | -122.464526247261 | (37.7538249882276, -122.464526247261) | |||
| 109141 | 109141 | 50997 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2404 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | Permit Number 47480 | 6002104.70119173 | 2117406.84878453 | 37.7941138815303 | -122.43669360820499 | (37.7941138815303, -122.436693608205) | |||
| 109255 | 109255 | 92815 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 54 Cerritos Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/06/2009 12:00:00 AM | 3x3 | Permit Number 53023 | 5992579.4 | 2093009.1 | 37.72657814349439 | -122.46787650278 | (37.7265781434944, -122.46787650278) | ||
| 109489 | 109489 | 97259 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1994@ Octavia Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004661.4 | 2117107.1 | 37.7934358122691 | -122.427825787413 | (37.7934358122691, -122.427825787413) | |||||
| 110110 | 110110 | 30325 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 720 Montgomery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1956 12:00:00 AM | Permit Number 16 | 6011772.9424544005 | 2117800.56968196 | 37.7957396438077 | -122.403267984357 | (37.7957396438077, -122.403267984357) | |||
| 110704 | 110704 | 112490 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2690x Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 3x3 | Permit Number 774532 | 6007377.71104 | 2121658.59908 | 37.8060863706979 | -122.418750060411 | (37.8060863706979, -122.418750060411) | ||
| 110814 | 110814 | 98317 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1811 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773893 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | |
| 110820 | 110820 | 99600 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2801X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 43709 | 6003513.0 | 2117956.0 | 37.7957016423098 | -122.43185997681299 | (37.7957016423098, -122.431859976813) | |||
| 111033 | 111033 | 111337 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2178 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775561 | 5991058.1 | 2100603.7 | 37.7473430166558 | -122.47368930100001 | (37.7473430166558, -122.473689301) | |
| 111922 | 111922 | 44211 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1466 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43658 | 5990873.69248126 | 2105421.34105709 | 37.76056030978 | -122.474678523283 | (37.76056030978, -122.474678523283) | ||||
| 111936 | 111936 | 11787 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
| 112381 | 112381 | 99602 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2801X Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 43709 | 6003513.0 | 2117956.0 | 37.7957016423098 | -122.43185997681299 | (37.7957016423098, -122.431859976813) | |||
| 112455 | 112455 | 11817 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
| 112552 | 112552 | 109579 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 290x ARKANSAS ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6012903.0 | 2105890.0 | 37.7630990003622 | -122.398521567136 | (37.7630990003622, -122.398521567136) | |||
| 112583 | 112583 | 49595 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1442 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46465 | 6005191.43444841 | 2099927.58829524 | 37.7462949778276 | -122.42476909833599 | (37.7462949778276, -122.424769098336) | ||||
| 112652 | 112652 | 14999 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1459X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016235.7427248005 | 2097702.9858463 | 37.7408042749191 | -122.38642376985001 | (37.7408042749191, -122.38642376985) | |||
| 112687 | 112687 | 113989 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2249 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6001849.57530622 | 2114273.14459713 | 37.7854950354219 | -122.437351872267 | (37.7854950354219, -122.437351872267) | |||||
| 112725 | 112725 | 98808 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 399X 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994945.2 | 2112858.1 | 37.78121477611 | -122.461136198189 | (37.78121477611, -122.461136198189) | ||||
| 112742 | 112742 | 13155 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1871 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3x3 | 6003453.14477 | 2119540.71202 | 37.8000494585448 | -122.43218031398199 | (37.8000494585448, -122.432180313982) |
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");