Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119134 | 119134 | 68399 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 10 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32230 | 5993170.65048654 | 2093114.37273837 | 37.7269013208382 | -122.465840234227 | (37.7269013208382, -122.465840234227) | ||
| 123800 | 123800 | 116680 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 100 Esmeralda Ave | 19 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 84138 | 84138 | 34388 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 100 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38136 | 6003730.56187145 | 2096520.40051304 | 37.736857004551794 | -122.429577666227 | (37.7368570045518, -122.429577666227) | ||
| 104525 | 104525 | 35745 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1005 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1998 12:00:00 AM | Permit Number 39018 | 6007884.66062501 | 2093417.72691387 | 37.728572072766 | -122.41499553105301 | (37.728572072766, -122.414995531053) | ||
| 128091 | 128091 | 36470 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 101 San Ramon Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39368 | 5995817.82622595 | 2092643.889646 | 37.725761835422794 | -122.456655052435 | (37.7257618354228, -122.456655052435) | ||
| 139667 | 139667 | 36471 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 101 San Ramon Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39368 | 5995817.82622595 | 2092643.889646 | 37.725761835422794 | -122.456655052435 | (37.7257618354228, -122.456655052435) | ||
| 94624 | 94624 | 31013 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1016 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34783 | 6002340.84086344 | 2087450.93520516 | 37.7118755052494 | -122.433734519918 | (37.7118755052494, -122.433734519918) | ||
| 120111 | 120111 | 39139 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1081 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40817 | 6007463.5839422 | 2101024.83737451 | 37.749435846729895 | -122.416989987658 | (37.7494358467299, -122.416989987658) | ||
| 120722 | 120722 | 39138 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1081 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40817 | 6007463.5839422 | 2101024.83737451 | 37.749435846729895 | -122.416989987658 | (37.7494358467299, -122.416989987658) | ||
| 123908 | 123908 | 34353 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 11 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38109 | 6004890.69932117 | 2098315.24737801 | 37.741850868129795 | -122.42569426656799 | (37.7418508681298, -122.425694266568) | ||
| 128395 | 128395 | 42023 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 110 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42346 | 5993552.23919225 | 2093678.6131862 | 37.7284725917152 | -122.464562053467 | (37.7284725917152, -122.464562053467) | ||
| 86006 | 86006 | 38036 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 111 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40238 | 5993036.05890767 | 2098279.23820641 | 37.7410749908436 | -122.466680779864 | (37.7410749908436, -122.466680779864) | ||
| 143552 | 143552 | 38035 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 111 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40238 | 5993036.05890767 | 2098279.23820641 | 37.7410749908436 | -122.466680779864 | (37.7410749908436, -122.466680779864) | ||
| 97168 | 97168 | 106921 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 112-118 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6007680.5 | 2107244.2 | 37.7665249882726 | -122.416680417976 | (37.7665249882726, -122.416680417976) | |||
| 81084 | 81084 | 37525 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1150 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | 3x3 | Permit Number 52992 | 6007323.510607299 | 2115257.61387493 | 37.788507814826204 | -122.41848345910499 | (37.7885078148262, -122.418483459105) | ||
| 106597 | 106597 | 37524 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1150 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | 3x3 | Permit Number 52992 | 6007323.510607299 | 2115257.61387493 | 37.788507814826204 | -122.41848345910499 | (37.7885078148262, -122.418483459105) | ||
| 140995 | 140995 | 37526 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1150 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39975 | 6007323.510607299 | 2115257.61387493 | 37.788507814826204 | -122.41848345910499 | (37.7885078148262, -122.418483459105) | ||
| 78301 | 78301 | 40037 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1190 Palou Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.729682546865604 | -122.383179660981 | (37.7296825468656, -122.383179660981) | |||
| 92413 | 92413 | 40035 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1190 Palou Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.729682546865604 | -122.383179660981 | (37.7296825468656, -122.383179660981) | |||
| 94806 | 94806 | 40036 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1190 Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.729682546865604 | -122.383179660981 | (37.7296825468656, -122.383179660981) | |||
| 104792 | 104792 | 40038 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1190 Palou Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.729682546865604 | -122.383179660981 | (37.7296825468656, -122.383179660981) | |||
| 116366 | 116366 | 40034 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1190 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.729682546865604 | -122.383179660981 | (37.7296825468656, -122.383179660981) | |||
| 37512 | 37512 | 38123 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1200 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 5 | Permit Number 40287 | 5985851.366 | 2107007.0192 | 37.7646218448258 | -122.49216497230199 | (37.7646218448258, -122.492164972302) | |
| 90972 | 90972 | 36820 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 91047 | 91047 | 36823 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 106343 | 106343 | 36826 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 117721 | 117721 | 36822 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 126247 | 126247 | 36821 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 138628 | 138628 | 36819 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 99717 | 99717 | 37426 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.43177398011801 | (37.7494863167503, -122.431773980118) | |||
| 104972 | 104972 | 37427 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.43177398011801 | (37.7494863167503, -122.431773980118) | |||
| 105863 | 105863 | 37423 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.43177398011801 | (37.7494863167503, -122.431773980118) | |||
| 128682 | 128682 | 37424 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Noe St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.43177398011801 | (37.7494863167503, -122.431773980118) | |||
| 1107 | 1107 | 52527 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 123 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 5 | 2x3 | Permit Number 779986 | 6001343.89555 | 2092234.3638799998 | 37.7249531074958 | -122.437522568322 | (37.7249531074958, -122.437522568322) |
| 123613 | 123613 | 47385 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1231 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45301 | 6001377.58877778 | 2100188.59270033 | 37.74679548873271 | -122.43797558503701 | (37.7467954887327, -122.437975585037) | |||
| 162759 | 162759 | 40610 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1234 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/1999 12:00:00 AM | 5 | Permit Number 41621 | 5983375.0645 | 2106732.8195 | 37.763723900700896 | -122.500709422357 | (37.7637239007009, -122.500709422357) | ||
| 99917 | 99917 | 37455 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 125 Gates St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39928 | 6008336.46582591 | 2098008.78903327 | 37.7412035106459 | -122.413758220259 | (37.7412035106459, -122.413758220259) | ||
| 105030 | 105030 | 37454 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 125 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39928 | 6008336.46582591 | 2098008.78903327 | 37.7412035106459 | -122.413758220259 | (37.7412035106459, -122.413758220259) | ||
| 113493 | 113493 | 38037 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 125 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40239 | 5992979.27513605 | 2098217.94646306 | 37.7409034220219 | -122.466872661258 | (37.7409034220219, -122.466872661258) | ||
| 85440 | 85440 | 14603 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 1265 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X3 | 5999439.61797 | 2108531.9802599996 | 37.7695939720606 | -122.44527665521002 | (37.7695939720606, -122.44527665521) | |||
| 1813 | 1813 | 246390 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 1267 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 0ft | 5999435.2691 | 2108467.7761 | 37.7694174354079 | -122.44528708087499 | (37.7694174354079, -122.445287080875) | |||
| 142292 | 142292 | 37749 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1271 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/1999 12:00:00 AM | Permit Number 40096 | 6009537.93489258 | 2101780.18844977 | 37.7516263413346 | -122.40987011119101 | (37.7516263413346, -122.409870111191) | ||
| 99963 | 99963 | 36111 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1290 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39208 | 5992413.02593495 | 2106678.51938145 | 37.7641012654702 | -122.469446232974 | (37.7641012654702, -122.469446232974) | ||
| 87203 | 87203 | 38622 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1295 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.727729298658296 | -122.385043230392 | (37.7277292986583, -122.385043230392) | ||
| 97472 | 97472 | 38619 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1295 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.727729298658296 | -122.385043230392 | (37.7277292986583, -122.385043230392) | ||
| 109923 | 109923 | 38620 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1295 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.727729298658296 | -122.385043230392 | (37.7277292986583, -122.385043230392) | ||
| 117991 | 117991 | 38621 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1295 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.727729298658296 | -122.385043230392 | (37.7277292986583, -122.385043230392) | ||
| 84291 | 84291 | 40058 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1298 Thomas Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.727259437575704 | -122.38557377869301 | (37.7272594375757, -122.385573778693) | ||
| 112672 | 112672 | 40061 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1298 Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.727259437575704 | -122.38557377869301 | (37.7272594375757, -122.385573778693) | ||
| 116635 | 116635 | 40060 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1298 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.727259437575704 | -122.38557377869301 | (37.7272594375757, -122.385573778693) | ||
| 124234 | 124234 | 40059 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1298 Thomas Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.727259437575704 | -122.38557377869301 | (37.7272594375757, -122.385573778693) | ||
| 17972 | 17972 | 38597 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 89321 | 89321 | 38593 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 91768 | 91768 | 38596 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 106822 | 106822 | 38594 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 126038 | 126038 | 38595 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 35901 | 35901 | 184740 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1301 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984699.9431 | 2106237.7689 | 37.762442323054294 | -122.49609061999399 | (37.7624423230543, -122.496090619994) | |||
| 68022 | 68022 | 184739 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1301 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984690.4501 | 2106251.0591 | 37.7624782581791 | -122.496124432854 | (37.7624782581791, -122.496124432854) | |||
| 39055 | 39055 | 246391 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1302 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999418.9163 | 2108430.2253 | 37.7693133969257 | -122.445340943975 | (37.7693133969257, -122.445340943975) | |||
| 157189 | 157189 | 246392 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1310 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999402.5635 | 2108427.4999 | 37.7693049801732 | -122.44539731131901 | (37.7693049801732, -122.445397311319) | |||
| 79109 | 79109 | 36453 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1315 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39355 | 5995842.07912733 | 2092771.30842103 | 37.7261130893774 | -122.45658042282 | (37.7261130893774, -122.45658042282) | ||
| 125375 | 125375 | 36454 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1315 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39355 | 5995842.07912733 | 2092771.30842103 | 37.7261130893774 | -122.45658042282 | (37.7261130893774, -122.45658042282) | ||
| 171936 | 171936 | 246393 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1318 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999383.4853 | 2108424.4716 | 37.769295576121394 | -122.445463083857 | (37.7692955761214, -122.445463083857) | |||
| 122597 | 122597 | 37845 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 132 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2005 12:00:00 AM | Permit Number 40137 | 6010294.81147281 | 2099208.35616527 | 37.744607042805704 | -122.40707146066002 | (37.7446070428057, -122.40707146066) | ||
| 71417 | 71417 | 246395 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999349.2656 | 2108419.0206 | 37.769278655482296 | -122.445581055639 | (37.7692786554823, -122.445581055639) | |||
| 123721 | 123721 | 246397 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999315.6516 | 2108414.4782 | 37.769264264092996 | -122.445696997639 | (37.769264264093, -122.445696997639) | |||
| 159169 | 159169 | 246396 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999332.61 | 2108417.5065 | 37.769273547251004 | -122.445638557414 | (37.769273547251, -122.445638557414) | |||
| 178672 | 178672 | 246394 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999365.9212 | 2108422.0489 | 37.769287921296204 | -122.44552366275299 | (37.7692879212962, -122.445523662753) | |||
| 112576 | 112576 | 38598 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1329 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40549 | 6016511.31684241 | 2093304.91013991 | 37.7287432904596 | -122.385164559023 | (37.7287432904596, -122.385164559023) | ||
| 123547 | 123547 | 38121 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1332 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40285 | 5986502.93855263 | 2106173.76895003 | 37.762372038386104 | -122.48985010087699 | (37.7623720383861, -122.489850100877) | ||
| 98980 | 98980 | 37870 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 135 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40155 | 5996120.55604725 | 2093902.0241843998 | 37.7292337486651 | -122.455699446357 | (37.7292337486651, -122.455699446357) | ||
| 110812 | 110812 | 37871 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 135 Colon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40155 | 5996120.55604725 | 2093902.0241843998 | 37.7292337486651 | -122.455699446357 | (37.7292337486651, -122.455699446357) | ||
| 111361 | 111361 | 37869 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 135 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/2002 12:00:00 AM | Permit Number 40155 | 5996120.55604725 | 2093902.0241843998 | 37.7292337486651 | -122.455699446357 | (37.7292337486651, -122.455699446357) | ||
| 164594 | 164594 | 248448 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 136 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998284.3672 | 2107976.1331 | 37.768001745714 | -122.449232557107 | (37.768001745714, -122.449232557107) | |||
| 18457 | 18457 | 38570 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 103548 | 103548 | 38571 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 109076 | 109076 | 38569 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 115620 | 115620 | 38567 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 117250 | 117250 | 38565 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 119849 | 119849 | 38568 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 123886 | 123886 | 38566 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 41814 | 41814 | 38626 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | ||
| 88362 | 88362 | 38629 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | ||
| 117173 | 117173 | 38627 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | ||
| 119355 | 119355 | 38628 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1998 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | |||
| 88116 | 88116 | 38642 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40567 | 6015859.80735798 | 2093156.47365065 | 37.7282996512663 | -122.38740653837 | (37.7282996512663, -122.38740653837) | ||
| 81385 | 81385 | 34111 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1398 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39363 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | ||
| 101426 | 101426 | 34110 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1398 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39363 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | ||
| 86438 | 86438 | 40067 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1400 Thomas Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2005 12:00:00 AM | Permit Number 41294 | 6015817.64770175 | 2093187.90304466 | 37.7283836150635 | -122.38755447920099 | (37.7283836150635, -122.387554479201) | ||
| 105358 | 105358 | 40066 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1400 Thomas Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2005 12:00:00 AM | Permit Number 41294 | 6015817.64770175 | 2093187.90304466 | 37.7283836150635 | -122.38755447920099 | (37.7283836150635, -122.387554479201) | ||
| 106615 | 106615 | 41829 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1406 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42215 | 5991820.03879919 | 2105845.80564429 | 37.761780567414206 | -122.47143650330601 | (37.7617805674142, -122.471436503306) | ||
| 114806 | 114806 | 34398 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2016 12:00:00 AM | 3 | Permit Number 38145 | 6002598.06465628 | 2096836.91119738 | 37.7376618812243 | -122.433515816831 | (37.7376618812243, -122.433515816831) | |
| 105548 | 105548 | 40069 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1410 Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41295 | 6015766.58727052 | 2093225.96783558 | 37.7284853051097 | -122.387733653848 | (37.7284853051097, -122.387733653848) | ||
| 113398 | 113398 | 40068 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1410 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41295 | 6015766.58727052 | 2093225.96783558 | 37.7284853051097 | -122.387733653848 | (37.7284853051097, -122.387733653848) | ||
| 140843 | 140843 | 40049 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1435 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41286 | 6015948.92421606 | 2093724.14562026 | 37.729863300942704 | -122.38713803351999 | (37.7298633009427, -122.38713803352) | ||
| 86678 | 86678 | 40051 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1439 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41287 | 6015928.43712332 | 2093739.41771764 | 37.729904100557 | -122.38720992526301 | (37.729904100557, -122.387209925263) | ||
| 126383 | 126383 | 40050 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1439 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41287 | 6015928.43712332 | 2093739.41771764 | 37.729904100557 | -122.38720992526301 | (37.729904100557, -122.387209925263) | ||
| 159923 | 159923 | 38864 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1442 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40691 | 5989006.457 | 2105496.048 | 37.7606570618134 | -122.48114183443701 | (37.7606570618134, -122.481141834437) | |
| 159867 | 159867 | 70368 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1442 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5983113.9936 | 2105313.3819 | 37.7598111971708 | -122.50150735953899 | (37.7598111971708, -122.501507359539) | ||
| 30105 | 30105 | 37213 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1443 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 6 | Permit Number 39778 | 5985860.9109 | 2105407.8744 | 37.7602315957486 | -122.49201421242701 | (37.7602315957486, -122.492014212427) |
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");