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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45348 | 45348 | 123272 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 550 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5993787.321169999 | 2111737.84714 | 37.7780721632368 | -122.465060466509 | (37.7780721632368, -122.465060466509) | |||
| 46276 | 46276 | 68880 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3633 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 28 | Permit Number 32851 | 6000180.507069999 | 2120770.20455 | 37.8032392229736 | -122.44359322865299 | (37.8032392229736, -122.443593228653) | |
| 46344 | 46344 | 221789 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 3456 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6005341.04131 | 2103147.38287 | 37.7551442389361 | -122.424480760089 | (37.7551442389361, -122.424480760089) | |||
| 46801 | 46801 | 175192 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 63 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002620.39107 | 2094490.53041 | 37.731220523295896 | -122.433271011664 | (37.7312205232959, -122.433271011664) | |||
| 46828 | 46828 | 84740 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 143 Alhambra St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 13 | 4x6 | Permit Number 49254 | 6001588.49283 | 2120281.76365 | 37.8019782934262 | -122.438685839601 | (37.8019782934262, -122.438685839601) | |
| 46838 | 46838 | 70589 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 339 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1994 12:00:00 AM | 19 | 5989627.95381 | 2113064.98358 | 37.7814753940656 | -122.479546175065 | (37.7814753940656, -122.479546175065) | ||
| 47027 | 47027 | 221919 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 80 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6004080.1128 | 2102611.51792 | 37.75360159226479 | -122.428803219313 | (37.7536015922648, -122.428803219313) | |||
| 47341 | 47341 | 221868 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 30 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5997080.14125 | 2106419.81481 | 37.763659540782704 | -122.45328544896002 | (37.7636595407827, -122.45328544896) | |||
| 47394 | 47394 | 221804 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 266 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 39 | Width 4ft | 6004140.40735 | 2099573.26288 | 37.7452626636546 | -122.42837817451 | (37.7452626636546, -122.42837817451) | |||
| 47557 | 47557 | 203564 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 202 Elmwood Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5994856.42725 | 2092686.28381 | 37.7258229929193 | -122.459981583277 | (37.7258229929193, -122.459981583277) | |||
| 47586 | 47586 | 221882 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 36 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007355.35831 | 2099292.63872 | 37.744673530375294 | -122.417241503608 | (37.7446735303753, -122.417241503608) | |||
| 48037 | 48037 | 221888 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 192 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006128.60788 | 2102045.3239599997 | 37.75216268327579 | -122.42167884941799 | (37.7521626832758, -122.421678849418) | |||
| 48208 | 48208 | 70645 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 67 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 4 | 6002626.20323 | 2094469.32888 | 37.7311626384362 | -122.433249403638 | (37.7311626384362, -122.433249403638) | ||
| 48308 | 48308 | 221895 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 47 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003758.63244 | 2095404.32352 | 37.733794099719404 | -122.429401048121 | (37.7337940997194, -122.429401048121) | |||
| 48562 | 48562 | 95121 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 68 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54048 | 6002661.0 | 2094358.0 | 37.730858928558895 | -122.433121153797 | (37.7308589285589, -122.433121153797) | |
| 48862 | 48862 | 203590 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999238.54402 | 2093513.75556 | 37.728346095777205 | -122.444892431558 | (37.7283460957772, -122.444892431558) | |||
| 49330 | 49330 | 203542 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 518 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5997986.70851 | 2094410.2920099997 | 37.7307362500736 | -122.449284629593 | (37.7307362500736, -122.449284629593) | |||
| 49463 | 49463 | 221803 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 118 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6005068.887630001 | 2098748.30494 | 37.743050013041 | -122.42510895543 | (37.743050013041, -122.42510895543) | |||
| 50290 | 50290 | 37084 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1487 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 9 | Permit Number 39685 | 5982148.9004 | 2105004.528 | 37.7589064434103 | -122.504822200215 | (37.7589064434103, -122.504822200215) | |
| 50652 | 50652 | 221805 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1350 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003874.144859999 | 2100377.76702 | 37.747456575074395 | -122.429356224108 | (37.7474565750744, -122.429356224108) | |||
| 51470 | 51470 | 203521 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 54 Aloha Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991886.812609999 | 2104359.60659 | 37.757703719373005 | -122.471097283818 | (37.757703719373, -122.471097283818) | |||
| 52906 | 52906 | 221884 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 230 Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6007166.67292 | 2098807.97162 | 37.7433321258706 | -122.417859593245 | (37.7433321258706, -122.417859593245) | |||
| 52912 | 52912 | 247495 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 537 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003124.7415 | 2110167.9221 | 37.7742955303854 | -122.43264682899701 | (37.7742955303854, -122.432646828997) | |||
| 52993 | 52993 | 221924 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 651 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003063.5459900005 | 2104384.4479400003 | 37.7584120469841 | -122.432445349468 | (37.7584120469841, -122.432445349468) | |||
| 53079 | 53079 | 221837 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 109 Bartlett St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6006703.42014 | 2103074.3868400003 | 37.755020650507795 | -122.41976406777599 | (37.7550206505078, -122.419764067776) | |||
| 53295 | 53295 | 189219 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 902 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 51 | Width 4ft | 6015755.01178 | 2096440.4400900002 | 37.7373109588264 | -122.38799789070801 | (37.7373109588264, -122.387997890708) | |||
| 53333 | 53333 | 221827 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 529 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008328.717999999 | 2096529.8183400002 | 37.7371421461853 | -122.41368042573099 | (37.7371421461853, -122.413680425731) | |||
| 53413 | 53413 | 221902 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 7 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6004251.6155900005 | 2095453.80279 | 37.7339578572562 | -122.42770018193501 | (37.7339578572562, -122.427700181935) | |||
| 53664 | 53664 | 203513 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 112 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5993653.12973 | 2102595.20165 | 37.7529611229783 | -122.464860549271 | (37.7529611229783, -122.464860549271) | |||
| 54787 | 54787 | 221937 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 31 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005028.18878 | 2097255.91505 | 37.7389499498753 | -122.42514351368601 | (37.7389499498753, -122.425143513686) | |||
| 54811 | 54811 | 203512 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1742 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5993754.138180001 | 2103625.89987 | 37.7557969785536 | -122.46458608068701 | (37.7557969785536, -122.464586080687) | |||
| 55034 | 55034 | 203504 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1443 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991444.34023 | 2105597.09319 | 37.761075927938 | -122.472717747032 | (37.761075927938, -122.472717747032) | |||
| 55059 | 55059 | 247338 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 220 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002315.9732 | 2109334.9211 | 37.771962416997106 | -122.43538490361901 | (37.7719624169971, -122.435384903619) | |||
| 55095 | 55095 | 221838 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 115 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004035.0330300005 | 2095100.1710299999 | 37.732974610471395 | -122.42842377735 | (37.7329746104714, -122.42842377735) | |||
| 55437 | 55437 | 203580 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 5999938.98985 | 2094086.49898 | 37.7299586665457 | -122.442512069977 | (37.7299586665457, -122.442512069977) | |||
| 55768 | 55768 | 125552 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 22 Dashiell Hammett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 1ft | 6010384.14225 | 2116014.5877 | 37.7907581078366 | -122.407947500375 | (37.7907581078366, -122.407947500375) | |||
| 55935 | 55935 | 221928 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 3666 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002501.47722 | 2106518.4971 | 37.764239741096794 | -122.434541817574 | (37.7642397410968, -122.434541817574) | |||
| 56768 | 56768 | 37527 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1244 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 19 | Permit Number 39976 | 6007268.1881 | 2115618.13797 | 37.7894946107457 | -122.41870044408199 | (37.7894946107457, -122.418700444082) | |
| 56809 | 56809 | 203518 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 415 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5993563.6385 | 2105259.44911 | 37.7602712973034 | -122.46536354189399 | (37.7602712973034, -122.465363541894) | |||
| 56864 | 56864 | 42268 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1463 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 3 | Permit Number 42509 | 5987415.8588 | 2105330.3292 | 37.7601094468303 | -122.486630755953 | (37.7601094468303, -122.486630755953) | |
| 57694 | 57694 | 203553 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 259 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994715.67756 | 2090305.5088 | 37.7192778601644 | -122.46029572277 | (37.7192778601644, -122.46029572277) | |||
| 58934 | 58934 | 221815 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 3734 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008428.677619999 | 2097499.17078 | 37.739809388778205 | -122.413403351802 | (37.7398093887782, -122.413403351802) | |||
| 59020 | 59020 | 221873 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 253 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007019.01293 | 2097474.10434 | 37.739661312707206 | -122.41827561244499 | (37.7396613127072, -122.418275612445) | |||
| 59670 | 59670 | 221874 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 371 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 6006129.02794 | 2097974.50861 | 37.7409851732348 | -122.421388331502 | (37.7409851732348, -122.421388331502) | |||
| 59833 | 59833 | 138630 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1702 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6000078.3648 | 2114795.7207 | 37.786829042699296 | -122.443517270296 | (37.7868290426993, -122.443517270296) | |||
| 60188 | 60188 | 221858 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 677 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6002223.92198 | 2099714.60458 | 37.745542121680295 | -122.435015156842 | (37.7455421216803, -122.435015156842) | |||
| 61216 | 61216 | 124272 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2 03rd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5994894.056609999 | 2114999.9706 | 37.787092832167 | -122.46146845316002 | (37.787092832167, -122.46146845316) | ||||
| 61285 | 61285 | 40196 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 562 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 26 | Permit Number 41380 | 5983509.69459 | 2111981.18634 | 37.778142310971106 | -122.500631896768 | (37.7781423109711, -122.500631896768) | |
| 61512 | 61512 | 203533 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 149 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995336.831780001 | 2096965.96659 | 37.737601580145004 | -122.458630547087 | (37.737601580145, -122.458630547087) | |||
| 61939 | 61939 | 221906 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 879 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002491.822919999 | 2103096.81966 | 37.7548440920015 | -122.43433056233201 | (37.7548440920015, -122.434330562332) | |||
| 62373 | 62373 | 221809 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1216 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998224.25103 | 2106127.66613 | 37.762922884510104 | -122.449307297897 | (37.7629228845101, -122.449307297897) | |||
| 62442 | 62442 | 84402 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1852 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51006 | 6000688.3478 | 2111734.5053 | 37.778458498926 | -122.44118716032499 | (37.778458498926, -122.441187160325) | |
| 62535 | 62535 | 221854 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 4418 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6000475.0083099995 | 2102295.3821799997 | 37.752528856626206 | -122.441247749083 | (37.7525288566262, -122.441247749083) | |||
| 62848 | 62848 | 203505 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1219 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991724.86879 | 2107100.15924 | 37.7652191828301 | -122.471857076945 | (37.7652191828301, -122.471857076945) | |||
| 63088 | 63088 | 70176 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 307 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 14 | 3.5x4 to 3.5x7 | 6004287.81152 | 2091470.5320099997 | 37.7230227297861 | -122.42729139328999 | (37.7230227297861, -122.42729139329) | |
| 63823 | 63823 | 37604 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 775 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 24 | Permit Number 40032 | 5992242.46027 | 2110184.69167 | 37.773718418011 | -122.470291511842 | (37.773718418011, -122.470291511842) | |
| 64042 | 64042 | 120637 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 401 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | 3x3 | 6000628.4194 | 2110406.526 | 37.77480879071 | -122.441299165195 | (37.77480879071, -122.441299165195) | |||
| 64399 | 64399 | 96841 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 4426 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 54781 | 5981806.97545 | 2111010.8887 | 37.7753780521761 | -122.50645014202298 | (37.7753780521761, -122.506450142023) |
| 65242 | 65242 | 221828 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1070 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6008613.25764 | 2102303.67809 | 37.7530118609308 | -122.413104786776 | (37.7530118609308, -122.413104786776) | |||
| 65312 | 65312 | 69299 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1632 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1994 12:00:00 AM | 25 | Permit Number 33374 | 5999947.982999999 | 2110939.1774 | 37.7762325313103 | -122.44369120188499 | (37.7762325313103, -122.443691201885) | |
| 65965 | 65965 | 39931 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 175 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 16 | Permit Number 41202 | 6010293.703319999 | 2087956.6998299998 | 37.713712300459704 | -122.406282682604 | (37.7137123004597, -122.406282682604) | |
| 66104 | 66104 | 221832 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 573 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007293.28891 | 2103997.59658 | 37.7575887842104 | -122.41778956393499 | (37.7575887842104, -122.417789563935) | |||
| 66317 | 66317 | 221938 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 36 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002640.28984 | 2096352.5639099998 | 37.7363343706279 | -122.433335224139 | (37.7363343706279, -122.433335224139) | |||
| 66318 | 66318 | 65718 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 206 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1990 12:00:00 AM | 22 | Permit Number 28650 | 6000369.4893 | 2087691.53319 | 37.7124240746766 | -122.44056528958099 | (37.7124240746766, -122.440565289581) | |
| 66389 | 66389 | 175184 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 190 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001047.00422 | 2087602.25445 | 37.7122174923141 | -122.438217204682 | (37.7122174923141, -122.438217204682) | |||
| 66407 | 66407 | 221843 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 124 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 2ft | 6004594.79724 | 2095953.61848 | 37.735349645373894 | -122.426549275423 | (37.7353496453739, -122.426549275423) | |||
| 66449 | 66449 | 124123 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 83 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 5996382.54086 | 2112452.81509 | 37.7801845808517 | -122.456134428556 | (37.7801845808517, -122.456134428556) | |||
| 66861 | 66861 | 67245 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 4738 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 15 | Permit Number 30709 | 5983942.53029 | 2111768.1419599997 | 37.777582753336794 | -122.499118839179 | (37.7775827533368, -122.499118839179) | |
| 67605 | 67605 | 36190 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 181 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 8 | Permit Number 39257 | 5996902.2714 | 2113184.5215 | 37.7822234726194 | -122.45438932298201 | (37.7822234726194, -122.454389322982) | |
| 67664 | 67664 | 221844 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 127 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6004153.19016 | 2095736.3108599999 | 37.73472799260821 | -122.428060594226 | (37.7347279926082, -122.428060594226) | |||
| 68079 | 68079 | 203508 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 936 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5991919.73486 | 2105259.11564 | 37.7601754385635 | -122.471048955151 | (37.7601754385635, -122.471048955151) | |||
| 68403 | 68403 | 221799 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 430 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6004120.07608 | 2110306.19132 | 37.7747315801401 | -122.42921364562001 | (37.7747315801401, -122.42921364562) | |||
| 68419 | 68419 | 203554 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 209 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5994942.92929 | 2088379.09284 | 37.714001447791794 | -122.459370769157 | (37.7140014477918, -122.459370769157) | |||
| 68911 | 68911 | 175196 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 149 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6002904.026380001 | 2092823.59155 | 37.7266595719653 | -122.432171435767 | (37.7266595719653, -122.432171435767) | |||
| 68973 | 68973 | 203524 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2428 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992056.59882 | 2098873.80652 | 37.7426509505813 | -122.470110650206 | (37.7426509505813, -122.470110650206) | |||
| 69292 | 69292 | 73402 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1434 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 16 | 5982802.3301 | 2105339.2702 | 37.759863969648 | -122.502587148941 | (37.759863969648, -122.502587148941) | ||
| 69427 | 69427 | 64508 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 841 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 36 | Permit Number 25389 | 6000432.9415 | 2111897.9264 | 37.7788926598871 | -122.442082438032 | (37.7788926598871, -122.442082438032) | |
| 69963 | 69963 | 64114 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1270 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1987 12:00:00 AM | Permit Number 24882 | 5992718.32165221 | 2106821.08244246 | 37.764510344589894 | -122.46840068588101 | (37.7645103445899, -122.468400685881) | ||
| 70367 | 70367 | 221877 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 22 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006964.5888 | 2099612.44373 | 37.74552965077471 | -122.41861538531201 | (37.7455296507747, -122.418615385312) | |||
| 70374 | 70374 | 41233 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3725 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2014 12:00:00 AM | 3 | Permit Number 773159 | 6002526.96331 | 2121423.4126 | 37.80516630374971 | -122.435520011048 | (37.8051663037497, -122.435520011048) | |
| 70461 | 70461 | 203503 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1347 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5991430.943580001 | 2106235.13725 | 37.7628270518373 | -122.47281060475099 | (37.7628270518373, -122.472810604751) | |||
| 70503 | 70503 | 67419 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 507 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 21 | Permit Number 30920 | 5990601.19445 | 2111910.6145099998 | 37.7783623005847 | -122.476094929494 | (37.7783623005847, -122.476094929494) | |
| 70596 | 70596 | 203562 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1231 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5992350.0078300005 | 2107041.6701599997 | 37.765094739142704 | -122.469690631732 | (37.7650947391427, -122.469690631732) | |||
| 70667 | 70667 | 64185 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1801 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/07/1993 12:00:00 AM | 19 | 6x9 | Permit Number 24970 | 5993009.35743 | 2112040.6417799997 | 37.7788586655522 | -122.46777372723999 | (37.7788586655522, -122.46777372724) |
| 70674 | 70674 | 203574 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 32 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6001891.78226 | 2094951.9742400001 | 37.7324461814313 | -122.435822942293 | (37.7324461814313, -122.435822942293) | |||
| 70944 | 70944 | 175175 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 231 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 3ft | 5998599.64276 | 2088795.69735 | 37.71535491666071 | -122.446761792925 | (37.7153549166607, -122.446761792925) | |||
| 71728 | 71728 | 221886 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 121 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006322.71195 | 2097511.22057 | 37.7397240062552 | -122.420685761336 | (37.7397240062552, -122.420685761336) | |||
| 71829 | 71829 | 203532 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 935 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5996459.44919 | 2098104.63925 | 37.7407925546419 | -122.45483139437701 | (37.7407925546419, -122.454831394377) | |||
| 71989 | 71989 | 221879 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 43 Powers Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6006986.90322 | 2099718.335 | 37.745821660643 | -122.418545732803 | (37.745821660643, -122.418545732803) | |||
| 72499 | 72499 | 221921 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 474 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002945.55902 | 2105503.88006 | 37.76147904724721 | -122.432933374683 | (37.7614790472472, -122.432933374683) | |||
| 72731 | 72731 | 39936 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 262 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 11 | Permit Number 41207 | 6009779.3367800005 | 2088185.9421 | 37.7143129666441 | -122.40807668619499 | (37.7143129666441, -122.408076686195) | |
| 72972 | 72972 | 70491 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 26 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 18 | 6005035.0472800005 | 2091735.87999 | 37.723793548611496 | -122.424727215697 | (37.7237935486115, -122.424727215697) | ||
| 73518 | 73518 | 221788 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 67 Richland Ave | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6005032.772530001 | 2096203.58298 | 37.7360607419969 | -122.42505281075199 | (37.7360607419969, -122.425052810752) | |||
| 74013 | 74013 | 221862 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 252 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6004616.62035 | 2096933.09811 | 37.7380403090218 | -122.426543547661 | (37.7380403090218, -122.426543547661) | |||
| 74947 | 74947 | 43793 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 170 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 6 | Permit Number 43423 | 5989012.43621 | 2114211.91029 | 37.7845887590001 | -122.481759578125 | (37.7845887590001, -122.481759578125) | |
| 75174 | 75174 | 203585 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5999428.77785 | 2093578.76175 | 37.7285354426355 | -122.444239456297 | (37.7285354426355, -122.444239456297) | |||
| 75371 | 75371 | 70397 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 130 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 21 | 6006350.25387 | 2093285.0007900002 | 37.7281212922586 | -122.420290654116 | (37.7281212922586, -122.420290654116) | ||
| 75821 | 75821 | 68256 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 243 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 16 | Permit Number 32061 | 6009551.9423 | 2093241.4503 | 37.7281816043806 | -122.40921918673901 | (37.7281816043806, -122.409219186739) | |
| 75958 | 75958 | 117893 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 4126 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5982758.1361 | 2110364.1187299998 | 37.773658165069 | -122.50311201499599 | (37.773658165069, -122.503112014996) | |||
| 75996 | 75996 | 175203 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 655 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 52 | 6005189.8347 | 2092537.12043 | 37.7260023204239 | -122.424249099221 | (37.7260023204239, -122.424249099221) |
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");