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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77729 | 77729 | 38342 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1550 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | Permit Number 40409 | 5982212.43055019 | 2104548.99515309 | 37.757659416739 | -122.504568736791 | (37.757659416739, -122.504568736791) | ||
| 77885 | 77885 | 93935 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 230 Seacliff Ave | 3 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 37x6 | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | ||
| 77952 | 77952 | 35672 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 526 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38981 | 5995332.07461936 | 2111959.28107373 | 37.77876911476079 | -122.459732689005 | (37.7787691147608, -122.459732689005) | ||||
| 77985 | 77985 | 63978 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 19 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1992 12:00:00 AM | Permit Number 24718 | 6005492.55213554 | 2104572.44995479 | 37.759065695045706 | -122.42405812838301 | (37.7590656950457, -122.424058128383) | ||
| 78012 | 78012 | 104735 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1499X 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 5982473.05016 | 2105245.16297 | 37.7595862228156 | -122.50371897878901 | (37.7595862228156, -122.503718978789) | ||||
| 78309 | 78309 | 101181 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 357 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994691.0 | 2106655.0 | 37.7641680705078 | -122.46156573588199 | (37.7641680705078, -122.461565735882) | ||||
| 78352 | 78352 | 66240 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 36 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29338 | 5995251.43113028 | 2091914.68057572 | 37.723727065785 | -122.458560261423 | (37.723727065785, -122.458560261423) | ||
| 78378 | 78378 | 93933 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 230 Seacliff Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 37x6 | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | ||
| 78407 | 78407 | 92764 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 78469 | 78469 | 67998 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 265 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31723 | 5994374.58269468 | 2088999.47480329 | 37.7156721755194 | -122.46138012219102 | (37.7156721755194, -122.461380122191) | ||
| 78587 | 78587 | 60823 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 66 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20502 | 6004686.95453469 | 2101655.43826245 | 37.751010748096206 | -122.426636548827 | (37.7510107480962, -122.426636548827) | ||
| 78600 | 78600 | 97647 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1844 Noriega St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988207.7 | 2103154.5 | 37.754181336878204 | -122.483732655057 | (37.7541813368782, -122.483732655057) | |||||
| 78747 | 78747 | 49403 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 288@ OCEAN Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2003 12:00:00 AM | Permit Number 46355 | 5999928.15335168 | 2091616.69162038 | 37.7231765280064 | -122.44237229181101 | (37.7231765280064, -122.442372291811) | |||
| 78849 | 78849 | 122772 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 86X Park Hill Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001171.0 | 2107689.0 | 37.7673780360046 | -122.43922745061899 | (37.7673780360046, -122.439227450619) | ||||
| 78854 | 78854 | 101901 | Property Tree 7 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1100 Ocean Ave | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 78863 | 78863 | 68484 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1045 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32358 | 6010008.09242785 | 2103121.68243357 | 37.7553361231749 | -122.408338849695 | (37.7553361231749, -122.408338849695) | ||
| 78891 | 78891 | 110923 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20x DE BOOM ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014792.0 | 2113102.0 | 37.783006604033204 | -122.392492594241 | (37.7830066040332, -122.392492594241) | ||||
| 78953 | 78953 | 43959 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2700 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2000 12:00:00 AM | Permit Number 43533 | 5982473.74529439 | 2096486.33377202 | 37.7355369547755 | -122.503068116639 | (37.7355369547755, -122.503068116639) | |||
| 78966 | 78966 | 51955 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1019 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2005 12:00:00 AM | Permit Number 48177 | 5996047.08051873 | 2098380.19637118 | 37.741525503636105 | -122.45627712083599 | (37.7415255036361, -122.456277120836) | |||
| 78999 | 78999 | 111938 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 78 SEACLIFF AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5987777.0 | 2115821.0 | 37.7889349383365 | -122.486151878662 | (37.7889349383365, -122.486151878662) | |||||
| 79004 | 79004 | 122550 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2211 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001584.0 | 2113871.0 | 37.784375747905706 | -122.43824186327299 | (37.7843757479057, -122.438241863273) | ||||
| 79118 | 79118 | 64867 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 251 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1989 12:00:00 AM | Permit Number 25886 | 6004902.96251692 | 2099861.61081762 | 37.7460975216007 | -122.425761905064 | (37.7460975216007, -122.425761905064) | ||
| 79211 | 79211 | 52705 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 950 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/31/2006 12:00:00 AM | Permit Number 48765 | 6009564.39642774 | 2116599.60561075 | 37.7923184964294 | -122.41082512613899 | (37.7923184964294, -122.410825126139) | ||
| 79315 | 79315 | 94358 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 501 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981570.8 | 2112285.9 | 37.7788649494867 | -122.50736173134199 | (37.7788649494867, -122.507361731342) | |||||
| 79543 | 79543 | 32186 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 439 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35518 | 5984780.78334223 | 2095663.00503944 | 37.7334116463821 | -122.49503123788 | (37.7334116463821, -122.49503123788) | ||
| 79572 | 79572 | 110924 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20x DE BOOM ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014792.0 | 2113102.0 | 37.783006604033204 | -122.392492594241 | (37.7830066040332, -122.392492594241) | ||||
| 79575 | 79575 | 65064 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 324 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1989 12:00:00 AM | Permit Number 27020 | 5981801.939732499 | 2112693.22065944 | 37.7799969439006 | -122.506592358164 | (37.7799969439006, -122.506592358164) | ||
| 79619 | 79619 | 42529 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 555 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | Permit Number 42639 | 6014073.47587821 | 2112271.482835 | 37.7806862654171 | -122.39492022473499 | (37.7806862654171, -122.394920224735) | |||
| 79675 | 79675 | 65067 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 336 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1989 12:00:00 AM | Permit Number 27023 | 5981751.83438142 | 2112699.38560853 | 37.7800109206625 | -122.506766149426 | (37.7800109206625, -122.506766149426) | ||
| 79800 | 79800 | 33713 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 111 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37780 | 6003684.10499818 | 2108803.26479984 | 37.770580222183 | -122.430614491306 | (37.770580222183, -122.430614491306) | |||
| 79806 | 79806 | 102978 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 555 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296001 | (37.7822098643106, -122.41823462296) | ||||
| 79872 | 79872 | 38359 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1536 Great Hwy | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | ||
| 79892 | 79892 | 61008 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 317 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1983 12:00:00 AM | Permit Number 20823 | 6001515.46921695 | 2096196.64014197 | 37.7358423628534 | -122.437213029713 | (37.7358423628534, -122.437213029713) | ||
| 79922 | 79922 | 38363 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1730 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/2004 12:00:00 AM | Permit Number 44741 | 5981045.1604602 | 2103280.47601246 | 37.7541076952376 | -122.50851139458099 | (37.7541076952376, -122.508511394581) | ||
| 79943 | 79943 | 122449 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 998x Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008865.0 | 2090425.0 | 37.72040971707629 | -122.411395091465 | (37.7204097170763, -122.411395091465) | ||||
| 79985 | 79985 | 67017 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 211 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30372 | 5994910.60415876 | 2088372.19453853 | 37.713980648067 | -122.459481996976 | (37.713980648067, -122.459481996976) | ||
| 80034 | 80034 | 122547 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2211 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001584.0 | 2113871.0 | 37.784375747905706 | -122.43824186327299 | (37.7843757479057, -122.438241863273) | ||||
| 80085 | 80085 | 65906 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 239 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1992 12:00:00 AM | Permit Number 28915 | 5993839.27700284 | 2105948.43912065 | 37.7621789770986 | -122.464460271923 | (37.7621789770986, -122.464460271923) | ||
| 80095 | 80095 | 38025 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1130 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40234 | 5992679.67115525 | 2098470.53882156 | 37.741579680289895 | -122.46792693970801 | (37.7415796802899, -122.467926939708) | ||
| 80113 | 80113 | 63126 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 53 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23640 | 6007136.23420587 | 2099195.53697782 | 37.7443945805058 | -122.41799231152399 | (37.7443945805058, -122.417992311524) | ||
| 80127 | 80127 | 111945 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 95 SEACLIFF AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5987570.0 | 2115773.0 | 37.7887910778243 | -122.48686453517901 | (37.7887910778243, -122.486864535179) | |||||
| 80131 | 80131 | 107758 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 126 HIGHLAND AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005605.1 | 2096623.0 | 37.7372446808015 | -122.42310384359101 | (37.7372446808015, -122.423103843591) | |||||
| 80144 | 80144 | 64192 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 40 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1987 12:00:00 AM | Permit Number 24978 | 5992669.11219149 | 2093049.31662857 | 37.72669374850361 | -122.467569297108 | (37.7266937485036, -122.467569297108) | ||
| 80245 | 80245 | 46937 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 29 Rockaway Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44982 | 5995921.53864707 | 2099025.2033151 | 37.7432893260314 | -122.456757836773 | (37.7432893260314, -122.456757836773) | |||
| 80336 | 80336 | 91183 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Polk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | |||
| 80422 | 80422 | 38462 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1160 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1998 12:00:00 AM | Permit Number 40473 | 6017581.82042544 | 2092920.99873262 | 37.7277483051936 | -122.381437035842 | (37.7277483051936, -122.381437035842) | |||
| 80433 | 80433 | 104262 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 199X Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065001 | (37.8083175458446, -122.41498343065) | |||||
| 80463 | 80463 | 98022 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1600 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988265.4 | 2098998.6 | 37.742773699634704 | -122.48322850460801 | (37.7427736996347, -122.483228504608) | ||||
| 80665 | 80665 | 105914 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 115 Steuart St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771767 | 6014820.9 | 2116826.5 | 37.7932348296087 | -122.39265323845699 | (37.7932348296087, -122.392653238457) | |||
| 80731 | 80731 | 48609 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601 Laguna Honda Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45913 | 5995627.89976884 | 2099973.91079987 | 37.7458773763018 | -122.457841793887 | (37.7458773763018, -122.457841793887) | ||
| 80844 | 80844 | 113156 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10x IRVING ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995755.0 | 2106778.0 | 37.7645669829926 | -122.457894591569 | (37.7645669829926, -122.457894591569) | ||||
| 81002 | 81002 | 86871 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2160 Green St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49804 | 6002705.0 | 2118187.0 | 37.796290071465 | -122.43467232535102 | (37.796290071465, -122.434672325351) | ||||
| 81028 | 81028 | 38735 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 222 Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | |||
| 81034 | 81034 | 46387 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2295 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | Permit Number 44622 | 5982642.85284032 | 2099514.23633708 | 37.7438606839213 | -122.50270751461001 | (37.7438606839213, -122.50270751461) | ||
| 81141 | 81141 | 38738 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 222 Schwerin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | |||
| 81164 | 81164 | 101193 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 390X Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994589.6 | 2106699.6 | 37.764284693418205 | -122.46191968102801 | (37.7642846934182, -122.461919681028) | ||||
| 81222 | 81222 | 38877 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 64 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40701 | 5995526.21364859 | 2115603.12418033 | 37.788785293558995 | -122.45932503947701 | (37.788785293559, -122.459325039477) | ||
| 81275 | 81275 | 99769 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 575 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001440.0 | 2101432.0 | 37.750213138216296 | -122.43784881669701 | (37.7502131382163, -122.437848816697) | ||||
| 81294 | 81294 | 106403 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600-698X BOWDOIN ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008958.0 | 2093051.0 | 37.7276253752452 | -122.411259027338 | (37.7276253752452, -122.411259027338) | |||||
| 81365 | 81365 | 116603 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3388 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6004272.63100633 | 2106610.91605823 | 37.7645938851901 | -122.42842248798901 | (37.7645938851901, -122.428422487989) | ||||
| 81396 | 81396 | 31787 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 156 Alpine Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35257 | 6001685.52281778 | 2107907.98384485 | 37.7680085767455 | -122.43746347404199 | (37.7680085767455, -122.437463474042) | |||
| 81415 | 81415 | 99731 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2601 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991009.5 | 2094863.7 | 37.731579630338395 | -122.47343874902599 | (37.7315796303384, -122.473438749026) | ||||
| 81496 | 81496 | 48617 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201 Ulloa St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45914 | 5996181.58703013 | 2099061.98037763 | 37.7434052350482 | -122.45586132044201 | (37.7434052350482, -122.455861320442) | ||
| 81574 | 81574 | 98009 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400@Taraval 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990522.5 | 2099005.4 | 37.742923465534794 | -122.47542467066401 | (37.7429234655348, -122.475424670664) | ||||
| 81654 | 81654 | 56636 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1921 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | Permit Number 20079 | 6001585.891537099 | 2112846.53403467 | 37.781562932959105 | -122.43816190592301 | (37.7815629329591, -122.438161905923) | ||
| 81697 | 81697 | 47681 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 57 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | Permit Number 45470 | 5996114.455132401 | 2089596.36116965 | 37.7174110701656 | -122.45540947913601 | (37.7174110701656, -122.455409479136) | ||
| 82034 | 82034 | 39217 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 242 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1998 12:00:00 AM | Permit Number 40859 | 5999782.97634669 | 2105543.22808774 | 37.761407198753794 | -122.443874232108 | (37.7614071987538, -122.443874232108) | |||
| 82116 | 82116 | 60160 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2026 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32058 | 5990694.00698191 | 2101593.62851431 | 37.7500400086591 | -122.475020546977 | (37.7500400086591, -122.475020546977) | ||
| 82139 | 82139 | 83316 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1516 Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50185 | 5980939.77097966 | 2104729.07463785 | 37.7580789214423 | -122.50898340594401 | (37.7580789214423, -122.508983405944) | ||
| 82148 | 82148 | 38736 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 222 Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | |||
| 82233 | 82233 | 63128 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23642 | 6007148.27103315 | 2099217.89521922 | 37.744456648669704 | -122.41795227521901 | (37.7444566486697, -122.417952275219) | ||
| 82250 | 82250 | 63493 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 253 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1992 12:00:00 AM | Permit Number 30455 | 5996997.27565809 | 2107004.91927315 | 37.7652613383897 | -122.453614304716 | (37.7652613383897, -122.453614304716) | ||
| 82269 | 82269 | 99872 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 194@Holloway Jules Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 20767 | 5994516.9 | 2091196.7 | 37.7217134214697 | -122.46104737723 | (37.7217134214697, -122.46104737723) | ||||
| 82279 | 82279 | 43946 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2700 Sloat Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2000 12:00:00 AM | Permit Number 43533 | 5982473.74529439 | 2096486.33377202 | 37.7355369547755 | -122.503068116639 | (37.7355369547755, -122.503068116639) | |||
| 82412 | 82412 | 61633 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3475 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1984 12:00:00 AM | Permit Number 21759 | 6003746.43412827 | 2106529.64099099 | 37.7643409332817 | -122.430236662479 | (37.7643409332817, -122.430236662479) | ||
| 82516 | 82516 | 49738 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 29 Park Hill Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46537 | 6001191.11608658 | 2107799.74836318 | 37.7676832682347 | -122.43916581055099 | (37.7676832682347, -122.439165810551) | ||||
| 82561 | 82561 | 60444 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | Permit Number 20028 | 5997483.83946465 | 2089883.9709991 | 37.7182792597053 | -122.45069689971001 | (37.7182792597053, -122.45069689971) | ||
| 82568 | 82568 | 65061 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 129 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1989 12:00:00 AM | Permit Number 27017 | 5982436.05662451 | 2112557.78774133 | 37.779662401782 | -122.504388664205 | (37.779662401782, -122.504388664205) | ||
| 82610 | 82610 | 46942 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 140 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | Permit Number 44983 | 5994983.4267195 | 2099568.1061956002 | 37.7447260918459 | -122.460040883484 | (37.7447260918459, -122.460040883484) | ||
| 82647 | 82647 | 61233 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 523 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1988 12:00:00 AM | Permit Number 25108 | 6002541.89946124 | 2099138.30339037 | 37.7439777833705 | -122.43387445629101 | (37.7439777833705, -122.433874456291) | ||
| 82660 | 82660 | 63998 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 551 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1987 12:00:00 AM | Permit Number 24745 | 6001623.24868042 | 2100849.27559995 | 37.7486235343136 | -122.437173414898 | (37.7486235343136, -122.437173414898) | ||
| 82734 | 82734 | 94497 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1600X Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9x7 | 5998899.3 | 2109049.0 | 37.770982719767794 | -122.44718280302601 | (37.7709827197678, -122.447182803026) | ||||
| 82826 | 82826 | 92763 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 82843 | 82843 | 122339 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994600.0 | 2112752.0 | 37.780903582725 | -122.462322713118 | (37.780903582725, -122.462322713118) | ||||
| 82861 | 82861 | 98007 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400@Taraval 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990522.5 | 2099005.4 | 37.742923465534794 | -122.47542467066401 | (37.7429234655348, -122.475424670664) | ||||
| 82868 | 82868 | 99785 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 803-805 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001281.6 | 2101711.5 | 37.750971569770705 | -122.43841659503799 | (37.7509715697707, -122.438416595038) | ||||
| 82896 | 82896 | 120960 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3250 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5985867.0 | 2098260.0 | 37.740605833831296 | -122.49146702188801 | (37.7406058338313, -122.491467021888) | ||||
| 82954 | 82954 | 88643 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2285 Jerrold Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51616 | 6011739.6 | 2099623.0 | 37.745826311758705 | -122.40210478451701 | (37.7458263117587, -122.402104784517) | |||
| 82976 | 82976 | 50091 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5 Lenox Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46820 | 5993639.14545893 | 2099165.59898138 | 37.7435435002865 | -122.464659889376 | (37.7435435002865, -122.464659889376) | ||
| 82992 | 82992 | 54189 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 75 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | Permit Number 20773 | 5994420.7037641 | 2090411.91546717 | 37.719553055235295 | -122.46132303819901 | (37.7195530552353, -122.461323038199) | ||
| 83074 | 83074 | 109632 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X GENEVA AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997165.4 | 2091482.5 | 37.7226502134341 | -122.45191286533199 | (37.7226502134341, -122.451912865332) | ||||
| 83084 | 83084 | 64323 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3984 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1993 12:00:00 AM | Permit Number 31928 | 6003988.0952513 | 2100739.18557481 | 37.7484553970649 | -122.428987955071 | (37.7484553970649, -122.428987955071) | ||
| 83131 | 83131 | 61482 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3426 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1984 12:00:00 AM | Permit Number 21427 | 6003968.8988858005 | 2106594.06405288 | 37.764530421547896 | -122.429471813902 | (37.7645304215479, -122.429471813902) | ||
| 83168 | 83168 | 65193 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 272 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 27177 | 6002881.7760748 | 2091863.26713189 | 37.7240214747375 | -122.432179803001 | (37.7240214747375, -122.432179803001) | ||
| 83199 | 83199 | 68537 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 758 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32419 | 5993840.36125998 | 2110344.94756796 | 37.774250692200496 | -122.46477580613501 | (37.7742506922005, -122.464775806135) | ||
| 83245 | 83245 | 32187 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 439 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35518 | 5984780.78334223 | 2095663.00503944 | 37.7334116463821 | -122.49503123788 | (37.7334116463821, -122.49503123788) | ||
| 83438 | 83438 | 60509 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 409 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1982 12:00:00 AM | Permit Number 20110 | 6003914.74089624 | 2098928.58901081 | 37.74347976582229 | -122.42911253365801 | (37.7434797658223, -122.429112533658) | ||
| 83452 | 83452 | 92762 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 83507 | 83507 | 61059 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 227 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1983 12:00:00 AM | Permit Number 20888 | 6000063.69141223 | 2094448.41929962 | 37.73095952298021 | -122.44210693195299 | (37.7309595229802, -122.442106931953) | ||
| 83721 | 83721 | 31623 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | Permit Number 35554 | 5992052.25118753 | 2099087.40328319 | 37.7432371814309 | -122.47014123306101 | (37.7432371814309, -122.470141233061) |
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");