Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1972 | 1972 | 252849 | Undocumented 2 | Tree(s) :: 17 | 200 Woodside Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996376.0 | 2100052.0 | 37.7461347404292 | -122.455260624993 | (37.7461347404292, -122.455260624993) | ||||
| 2006 | 2006 | 252850 | Undocumented 2 | Tree(s) :: 17 | 2 Hernandez Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996271.0 | 2100083.0 | 37.7462138338134 | -122.45562593978599 | (37.7462138338134, -122.455625939786) | ||||
| 13252 | 13252 | 115099 | Undocumented 2 | Tree(s) :: 17 | 1061X PACHECO ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/16/2017 12:00:00 AM | 3 | 3x10 | Permit Number 779333 | 5991641.0 | 2102174.0 | 37.7516883950984 | -122.47178811631599 | (37.7516883950984, -122.471788116316) | |
| 13300 | 13300 | 114607 | Undocumented 2 | Tree(s) :: 17 | 2399X 15TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | Permit Number 779471 | 5991654.0 | 2099150.0 | 37.7433860243849 | -122.471522828523 | (37.7433860243849, -122.471522828523) | |||
| 22894 | 22894 | 206842 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994803.1874 | 2087784.4983 | 37.712360795684 | -122.45981072288001 | (37.712360795684, -122.45981072288) | |
| 22897 | 22897 | 215094 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.2030900002 | 37.7123610457095 | -122.45974695827199 | (37.7123610457095, -122.459746958272) | |
| 42981 | 42981 | 106868 | Undocumented 2 | Tree(s) :: 17 | 1956 GREAT HWY | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5981193.7 | 2101737.6 | 37.749880147789895 | -122.507883225183 | (37.7498801477899, -122.507883225183) | ||||||
| 53187 | 53187 | 69218 | Permitted Site 1 | Tree(s) :: 17 | 1196 Treat Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/02/2015 12:00:00 AM | 3x3 | Permit Number 776894 | 6008647.40418625 | 2101585.3758574 | 37.7510414812393 | -122.412935918741 | (37.7510414812393, -122.412935918741) | ||
| 66023 | 66023 | 102260 | Undocumented 2 | Tree(s) :: 17 | 1350 46th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 24 | 4x6 | 5981875.8 | 2105892.8 | 37.761329314711105 | -122.505832545781 | (37.7613293147111, -122.505832545781) | |||
| 77546 | 77546 | 107912 | Permitted Site 1 | Tree(s) :: 17 | 65X Newburg St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770183 | 6002412.156690001 | 2099793.63341 | 37.7457698026645 | -122.434369920352 | (37.7457698026645, -122.434369920352) | ||
| 77967 | 77967 | 97518 | Permitted Site 1 | Tree(s) :: 17 | 2507 Pacific Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/18/2011 12:00:00 AM | Permit Number 768390 | 6002058.0 | 2116985.3 | 37.7929537637119 | -122.43682500768499 | (37.7929537637119, -122.436825007685) | |||
| 78882 | 78882 | 101964 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 79264 | 79264 | 94053 | Permitted Site 1 | Tree(s) :: 17 | 2495 33rd Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/25/2010 12:00:00 AM | Permit Number 53457 | 5986086.2 | 2098276.2 | 37.7406631217311 | -122.490710314749 | (37.7406631217311, -122.490710314749) | |||
| 80231 | 80231 | 107911 | Permitted Site 1 | Tree(s) :: 17 | 65X Newburg St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770183 | 6002412.156690001 | 2099793.63341 | 37.7457698026645 | -122.434369920352 | (37.7457698026645, -122.434369920352) | ||
| 80376 | 80376 | 101965 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 80721 | 80721 | 116839 | Undocumented 2 | Tree(s) :: 17 | 690 ROCKDALE DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5997625.0 | 2098222.0 | 37.741181588747104 | -122.45080983743 | (37.7411815887471, -122.45080983743) | ||||
| 80965 | 80965 | 96878 | Permitted Site 1 | Tree(s) :: 17 | 2200X San Jose Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | Permit Number 773235 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||
| 81042 | 81042 | 112562 | Permitted Site 1 | Tree(s) :: 17 | 1000X 17th Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/06/2015 12:00:00 AM | Permit Number 774340 | 5990959.97324 | 2102133.59106 | 37.7515380150924 | -122.47414022419301 | (37.7515380150924, -122.474140224193) | ||||
| 82017 | 82017 | 112740 | Undocumented 2 | Tree(s) :: 17 | 2514 CLAY ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/09/2015 12:00:00 AM | 3x3 | Permit Number 776637 | 6002696.0 | 2116178.0 | 37.7907733646004 | -122.43455974658 | (37.7907733646004, -122.43455974658) | ||
| 82026 | 82026 | 119268 | Permitted Site 1 | Tree(s) :: 17 | 109 Gates St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778717 | 6008342.0 | 2098018.0 | 37.741229112716105 | -122.41373973636001 | (37.7412291127161, -122.41373973636) | |
| 82320 | 82320 | 113769 | Significant Tree 6 | Tree(s) :: 17 | 2550 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6001418.65940389 | 2117313.19689891 | 37.7938177263924 | -122.439060665499 | (37.7938177263924, -122.439060665499) | |||||
| 82391 | 82391 | 105357 | Undocumented 2 | Tree(s) :: 17 | 171X Dorado Ter | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 18 | 3x9 | 5994283.2391 | 2093059.23457 | 37.7268140423665 | -122.461990071604 | (37.7268140423665, -122.461990071604) | |||
| 82648 | 82648 | 107952 | Permitted Site 1 | Tree(s) :: 17 | 2200 JERROLD AVE | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6012443.5 | 2099218.7 | 37.7447554536478 | -122.399642400815 | (37.7447554536478, -122.399642400815) | ||||
| 83391 | 83391 | 101966 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 83562 | 83562 | 112807 | Undocumented 2 | Tree(s) :: 17 | 85 LOMITA AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5991376.0 | 2104593.0 | 37.7583149976739 | -122.472880884893 | (37.7583149976739, -122.472880884893) | ||||
| 84297 | 84297 | 121446 | Significant Tree 6 | Tree(s) :: 17 | 500 Terry A Francois Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6016102.0 | 2110410.0 | 37.775687633053 | -122.38777260103399 | (37.775687633053, -122.387772601034) | ||||
| 86139 | 86139 | 89139 | Permitted Site 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373001 | (37.7541940143569, -122.41572017373) | ||||
| 86307 | 86307 | 93162 | Permitted Site 1 | Tree(s) :: 17 | 201 Upper Ter | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 3x3 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 87780 | 87780 | 97161 | Undocumented 2 | Tree(s) :: 17 | 3170 23rd St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 30 | 3x3 | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373001 | (37.7541940143569, -122.41572017373) | ||
| 88445 | 88445 | 122634 | Significant Tree 6 | Tree(s) :: 17 | 3680X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3 | 3x10 | Permit Number 779220 | 5990592.0 | 2091224.0 | 37.7215617409212 | -122.474616575991 | (37.7215617409212, -122.474616575991) | |
| 89426 | 89426 | 101699 | Undocumented 2 | Tree(s) :: 17 | 2700 18th St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/13/2012 12:00:00 AM | 2x3 | Permit Number 769052 | 6009810.4 | 2105505.4 | 37.7618702017999 | -122.409190731152 | (37.7618702017999, -122.409190731152) | ||
| 91444 | 91444 | 107078 | Undocumented 2 | Tree(s) :: 17 | 92 Homestead St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 07/25/2014 12:00:00 AM | 3x3.5 | Permit Number 773562 | 6000948.33481 | 2101213.46128 | 37.7495851129185 | -122.439533357227 | (37.7495851129185, -122.439533357227) | |||
| 92219 | 92219 | 96879 | Permitted Site 1 | Tree(s) :: 17 | 2200X San Jose Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | Permit Number 773235 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||
| 93666 | 93666 | 87151 | Permitted Site 1 | Tree(s) :: 17 | 4 Bellair Pl | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6010093.0 | 2120950.0 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | ||||
| 93998 | 93998 | 101963 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 94304 | 94304 | 94961 | Permitted Site 1 | Tree(s) :: 17 | 3098 PACIFIC AVE | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/25/2010 12:00:00 AM | 5999362.0 | 2116697.0 | 37.792008575714 | -122.446132526841 | (37.792008575714, -122.446132526841) | ||||
| 94906 | 94906 | 101731 | Permitted Site 1 | Tree(s) :: 17 | 1300X Lyon St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/25/2013 12:00:00 AM | 3x3 | Permit Number 770262 | 5999795.2 | 2113332.1 | 37.7827941670798 | -122.44439172751899 | (37.7827941670798, -122.444391727519) | ||
| 95948 | 95948 | 101961 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 96305 | 96305 | 95351 | Permitted Site 1 | Tree(s) :: 17 | 2316 Golden Gate Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/14/2011 12:00:00 AM | 2x2 | Permit Number 767218 | 5998391.3 | 2111446.7 | 37.777537148440004 | -122.44911274084801 | (37.77753714844, -122.449112740848) | ||
| 96353 | 96353 | 104459 | DPW Maintained 3 | Tree(s) :: 17 | 1601X Kansas St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011789.30586 | 2100707.09327 | 37.748805772054 | -122.402009105448 | (37.748805772054, -122.402009105448) | |||
| 96413 | 96413 | 107949 | Permitted Site 1 | Tree(s) :: 17 | 2200 JERROLD AVE | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6012443.5 | 2099218.7 | 37.7447554536478 | -122.399642400815 | (37.7447554536478, -122.399642400815) | ||||
| 96557 | 96557 | 107036 | Significant Tree 6 | Tree(s) :: 17 | 350 08th St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/23/2014 12:00:00 AM | 7x7 | Permit Number 772214 | 6009826.0 | 2110084.0 | 37.774442857676505 | -122.409459923405 | (37.7744428576765, -122.409459923405) | |||
| 97089 | 97089 | 102584 | Undocumented 2 | Tree(s) :: 17 | 22 Gennessee St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5997479.4 | 2093692.8 | 37.7287371564084 | -122.450986747444 | (37.7287371564084, -122.450986747444) | |||||
| 97540 | 97540 | 99295 | Permitted Site 1 | Tree(s) :: 17 | 947 Lincoln Way | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5992761.5 | 2107248.3 | 37.765685864903396 | -122.468282426864 | (37.7656858649034, -122.468282426864) | |||||
| 97574 | 97574 | 101967 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 98488 | 98488 | 94051 | Permitted Site 1 | Tree(s) :: 17 | 2495 33rd Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/25/2010 12:00:00 AM | Permit Number 53457 | 5986086.2 | 2098276.2 | 37.7406631217311 | -122.490710314749 | (37.7406631217311, -122.490710314749) | |||
| 99084 | 99084 | 107910 | Permitted Site 1 | Tree(s) :: 17 | 65X Newburg St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770183 | 6002412.156690001 | 2099793.63341 | 37.7457698026645 | -122.434369920352 | (37.7457698026645, -122.434369920352) | ||
| 100393 | 100393 | 106237 | Undocumented 2 | Tree(s) :: 17 | 607 BRUSSELS ST | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010922.6 | 2091903.6 | 37.724584840413996 | -122.404386617586 | (37.724584840414, -122.404386617586) | ||||||
| 101156 | 101156 | 111313 | Section 143 8 | Tree(s) :: 17 | 3400x Wawona St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.6213900002 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | ||
| 101223 | 101223 | 110309 | Permitted Site 1 | Tree(s) :: 17 | 899x Stanyan St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Dept of Real Estate 5 | 04/03/2015 12:00:00 AM | 3x3 | 5997166.64381 | 2107575.86009 | 37.7668387037649 | -122.45306972128999 | (37.7668387037649, -122.45306972129) | |||
| 101229 | 101229 | 85273 | Permitted Site 1 | Tree(s) :: 17 | 36 Santa Cruz Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 5993017.1 | 2086630.8 | 37.709090137513 | -122.465900153218 | (37.709090137513, -122.465900153218) | ||||||
| 102637 | 102637 | 107643 | DPW Maintained 3 | Tree(s) :: 17 | 455 ATHENS ST | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 4x4 | 6003769.0 | 2090659.8 | 37.720767283734105 | -122.429027043999 | (37.7207672837341, -122.429027043999) | ||||
| 103242 | 103242 | 94633 | Permitted Site 1 | Tree(s) :: 17 | 3600 16th St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/18/2010 12:00:00 AM | 3x3 | Permit Number 53781 | 6002902.0 | 2106490.0 | 37.764184223284396 | -122.433154488347 | (37.7641842232844, -122.433154488347) | ||
| 103827 | 103827 | 94049 | Permitted Site 1 | Tree(s) :: 17 | 2495 33rd Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/25/2010 12:00:00 AM | Permit Number 53457 | 5986086.2 | 2098276.2 | 37.7406631217311 | -122.490710314749 | (37.7406631217311, -122.490710314749) | |||
| 104108 | 104108 | 102007 | Undocumented 2 | Tree(s) :: 17 | 1703 Castro St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002624.0 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | ||||
| 105658 | 105658 | 112431 | Undocumented 2 | Tree(s) :: 17 | 19 Arguello Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2015 12:00:00 AM | 3x3 | Permit Number 774101 | 5995479.0 | 2115773.8 | 37.7892512085361 | -122.45950075691601 | (37.7892512085361, -122.459500756916) | ||
| 106512 | 106512 | 117420 | Permitted Site 1 | Tree(s) :: 17 | 77 Dorado Ter | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777175 | 5994584.4 | 2093084.8 | 37.7269015728644 | -122.46095082579399 | (37.7269015728644, -122.460950825794) | |
| 106757 | 106757 | 94050 | Permitted Site 1 | Tree(s) :: 17 | 2495 33rd Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/25/2010 12:00:00 AM | Permit Number 53457 | 5986086.2 | 2098276.2 | 37.7406631217311 | -122.490710314749 | (37.7406631217311, -122.490710314749) | |||
| 107922 | 107922 | 105358 | Undocumented 2 | Tree(s) :: 17 | 171X Dorado Ter | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 18 | 3x9 | 5994283.2391 | 2093059.23457 | 37.7268140423665 | -122.461990071604 | (37.7268140423665, -122.461990071604) | |||
| 108066 | 108066 | 114815 | Undocumented 2 | Tree(s) :: 17 | 160 BRENTWOOD AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/08/2016 12:00:00 AM | 3 | 4x15 | Permit Number 778944 | 5995496.0 | 2095622.0 | 37.7339205232551 | -122.457982998117 | (37.7339205232551, -122.457982998117) | |
| 109068 | 109068 | 112659 | Permitted Site 1 | Tree(s) :: 17 | 101 Quintara St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/14/2015 12:00:00 AM | Permit Number 775001 | 5993151.2 | 2101136.7 | 37.748927499569604 | -122.466490304373 | (37.7489274995696, -122.466490304373) | |||
| 109175 | 109175 | 105414 | Permitted Site 1 | Tree(s) :: 17 | 1496 Minnesota St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2014 12:00:00 AM | Permit Number 771011 | 6015346.4 | 2101668.2 | 37.751642657998296 | -122.389775701665 | (37.7516426579983, -122.389775701665) | |||
| 110920 | 110920 | 85195 | Permitted Site 1 | Tree(s) :: 17 | 333 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 5990168.0 | 2094689.0 | 37.731051182582604 | -122.47633519175501 | (37.7310511825826, -122.476335191755) | ||||||
| 112158 | 112158 | 111315 | Section 143 8 | Tree(s) :: 17 | 3400x Wawona St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.6213900002 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | ||
| 113824 | 113824 | 111316 | Section 143 8 | Tree(s) :: 17 | 3400x Wawona St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.6213900002 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | ||
| 114540 | 114540 | 117101 | Undocumented 2 | Tree(s) :: 17 | 677 ULLOA ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778379 | 5994251.0 | 2098113.0 | 37.7406885817292 | -122.46246793072201 | (37.7406885817292, -122.462467930722) | |
| 116057 | 116057 | 96347 | Permitted Site 1 | Tree(s) :: 17 | 2200X San Jose Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | Permit Number 773235 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||
| 116514 | 116514 | 101962 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 116802 | 116802 | 95350 | Permitted Site 1 | Tree(s) :: 17 | 2316 Golden Gate Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/14/2011 12:00:00 AM | 2x2 | Permit Number 767218 | 5998391.3 | 2111446.7 | 37.777537148440004 | -122.44911274084801 | (37.77753714844, -122.449112740848) | ||
| 117182 | 117182 | 111314 | Section 143 8 | Tree(s) :: 17 | 3400x Wawona St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.6213900002 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | ||
| 117259 | 117259 | 116463 | Undocumented 2 | Tree(s) :: 17 | 1898X FUNSTON AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 35 | 3x3 | Permit Number 777893 | 5992212.0 | 2102539.0 | 37.752723611861704 | -122.46984011316201 | (37.7527236118617, -122.469840113162) | ||
| 117600 | 117600 | 112563 | Permitted Site 1 | Tree(s) :: 17 | 1000X 17th Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/06/2015 12:00:00 AM | Permit Number 774340 | 5990959.97324 | 2102133.59106 | 37.7515380150924 | -122.47414022419301 | (37.7515380150924, -122.474140224193) | ||||
| 118587 | 118587 | 107947 | Permitted Site 1 | Tree(s) :: 17 | 2200 JERROLD AVE | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6012443.5 | 2099218.7 | 37.7447554536478 | -122.399642400815 | (37.7447554536478, -122.399642400815) | ||||
| 119246 | 119246 | 99296 | Permitted Site 1 | Tree(s) :: 17 | 947 Lincoln Way | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5992761.5 | 2107248.3 | 37.765685864903396 | -122.468282426864 | (37.7656858649034, -122.468282426864) | |||||
| 119888 | 119888 | 107369 | Undocumented 2 | Tree(s) :: 17 | 1990X LAGUNA ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/21/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774385 | 6004403.0 | 2115650.0 | 37.789420363641895 | -122.42861595649099 | (37.7894203636419, -122.428615956491) | |
| 121732 | 121732 | 94436 | Permitted Site 1 | Tree(s) :: 17 | 127 Grand View Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/02/2010 12:00:00 AM | 3x3 | Permit Number 53661 | 6000876.8 | 2103580.3 | 37.756079809385604 | -122.43995041119899 | (37.7560798093856, -122.439950411199) | |||
| 122453 | 122453 | 97519 | Permitted Site 1 | Tree(s) :: 17 | 2507 Pacific Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/18/2011 12:00:00 AM | Permit Number 768390 | 6002058.0 | 2116985.3 | 37.7929537637119 | -122.43682500768499 | (37.7929537637119, -122.436825007685) | |||
| 125875 | 125875 | 89140 | Permitted Site 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373001 | (37.7541940143569, -122.41572017373) | ||||
| 126079 | 126079 | 110307 | Permitted Site 1 | Tree(s) :: 17 | 899x Stanyan St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Dept of Real Estate 5 | 04/03/2015 12:00:00 AM | 3 | 4x11 | Permit Number 774992 | 5997166.64381 | 2107575.86009 | 37.7668387037649 | -122.45306972128999 | (37.7668387037649, -122.45306972129) | |
| 126648 | 126648 | 116460 | Undocumented 2 | Tree(s) :: 17 | 66 AERIAL WAY | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 30 | 3x3 | Permit Number 777893 | 5992280.0 | 2102576.0 | 37.7528291346084 | -122.469607652393 | (37.7528291346084, -122.469607652393) | ||
| 127684 | 127684 | 101960 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 127722 | 127722 | 101809 | Undocumented 2 | Tree(s) :: 17 | 370 Hermann St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003497.0 | 2108649.0 | 37.7701460471638 | -122.43125067595 | (37.7701460471638, -122.43125067595) | ||||
| 128373 | 128373 | 107595 | Undocumented 2 | Tree(s) :: 17 | 1846 POST ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 6003338.5 | 2114199.3 | 37.7853768084061 | -122.43219536019501 | (37.7853768084061, -122.432195360195) | |||
| 138317 | 138317 | 94634 | Permitted Site 1 | Tree(s) :: 17 | 3600 16th St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/18/2010 12:00:00 AM | 3x3 | Permit Number 53781 | 6002902.0 | 2106490.0 | 37.764184223284396 | -122.433154488347 | (37.7641842232844, -122.433154488347) | ||
| 140567 | 140567 | 94962 | Permitted Site 1 | Tree(s) :: 17 | 3098@Lyon Pacific Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/25/2010 12:00:00 AM | 5999362.0 | 2116697.3 | 37.7920093994348 | -122.44613254842899 | (37.7920093994348, -122.446132548429) | |||||
| 140884 | 140884 | 104457 | DPW Maintained 3 | Tree(s) :: 17 | 1601X Kansas St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011789.30586 | 2100707.09327 | 37.748805772054 | -122.402009105448 | (37.748805772054, -122.402009105448) | |||
| 141689 | 141689 | 75040 | DPW Maintained 3 | Tree(s) :: 17 | 499X Hearst Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 18 | 6x20 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 143329 | 143329 | 93161 | Permitted Site 1 | Tree(s) :: 17 | 201 Upper Ter | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 1x1 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 143915 | 143915 | 93160 | Permitted Site 1 | Tree(s) :: 17 | 201 Upper Ter | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 1x1 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 144173 | 144173 | 96099 | Undocumented 2 | Tree(s) :: 17 | 2780X Bryant St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6009802.0 | 2101146.0 | 37.749899795942504 | -122.408912195701 | (37.7498997959425, -122.408912195701) | ||||
| 144676 | 144676 | 122851 | Undocumented 2 | Tree(s) :: 17 | 742 Francisco St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6007760.0 | 2120975.0 | 37.8042308974981 | -122.417378607523 | (37.8042308974981, -122.417378607523) | ||||
| 145258 | 145258 | 96222 | Significant Tree 6 | Tree(s) :: 17 | 176 Holladay Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/18/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767739 | 6010842.9 | 2100101.6 | 37.7470903528282 | -122.405239158587 | (37.7470903528282, -122.405239158587) | |
| 145331 | 145331 | 101702 | Undocumented 2 | Tree(s) :: 17 | 2700 18th St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/13/2012 12:00:00 AM | 2x3 | Permit Number 769052 | 6009810.4 | 2105505.4 | 37.7618702017999 | -122.409190731152 | (37.7618702017999, -122.409190731152) | ||
| 145584 | 145584 | 102008 | Undocumented 2 | Tree(s) :: 17 | 1703 Castro St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002624.0 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | ||||
| 146074 | 146074 | 94447 | Significant Tree 6 | Tree(s) :: 17 | 1103 Gough St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/06/2010 12:00:00 AM | 3x3 | Permit Number 53668 | 6005549.7 | 2113553.5 | 37.7837287235103 | -122.424499312595 | (37.7837287235103, -122.424499312595) | ||
| 146273 | 146273 | 107913 | Permitted Site 1 | Tree(s) :: 17 | 65X Newburg St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770183 | 6002412.156690001 | 2099793.63341 | 37.7457698026645 | -122.434369920352 | (37.7457698026645, -122.434369920352) |
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");