Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3007 | 3007 | 253279 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10x10 | ROW IS 10' tree is street tree | ||||||||
| 114923 | 114923 | 54029 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 270 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1996 12:00:00 AM | Permit Number 9749 | 6004544.38660798 | 2103986.94623016 | 37.757404461657295 | -122.42729562792101 | (37.7574044616573, -122.427295627921) | ||
| 4401 | 4401 | 239088 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 3855 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3x3 | Permit Number 780732 | 6004794.15723 | 2100737.4007099997 | 37.748496089721996 | -122.426200479689 | (37.748496089722, -122.426200479689) | ||
| 9622 | 9622 | 122597 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9623 | 9623 | 75842 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9625 | 9625 | 122599 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9627 | 9627 | 122596 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9628 | 9628 | 122598 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9630 | 9630 | 72480 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9633 | 9633 | 75872 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9764 | 9764 | 122593 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 72 Townsend St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9765 | 9765 | 122594 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 72 Townsend St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 13567 | 13567 | 105276 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 64 Townsend St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015520.229280001 | 2112423.42174 | 37.7811837949483 | -122.38992578265699 | (37.7811837949483, -122.389925782657) | |
| 15001 | 15001 | 105275 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 64 Townsend St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015531.53579 | 2112438.89481 | 37.7812269075454 | -122.389887748547 | (37.7812269075454, -122.389887748547) | |
| 15264 | 15264 | 105277 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 64 Townsend St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015510.23316 | 2112419.2864900003 | 37.781171886114706 | -122.38996007562 | (37.7811718861147, -122.38996007562) | |
| 7371 | 7371 | 44106 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1242 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778937 | 6007599.34177 | 2118533.61268 | 37.797518421388205 | -122.41776142416401 | (37.7975184213882, -122.417761424164) | |
| 998 | 998 | 106624 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 156 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x6 | Permit Number 778450 | 5996579.9247 | 2113340.3647 | 37.78263288517989 | -122.455515759177 | (37.7826328851799, -122.455515759177) | ||
| 5608 | 5608 | 106622 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 156 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x6 | Permit Number 778450 | 5996579.2478 | 2113322.09 | 37.78258266885771 | -122.455516779687 | (37.7825826688577, -122.455516779687) | ||
| 906 | 906 | 238924 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1362 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2016 12:00:00 AM | 1 | Width 3ft | Permit Number 777634 | 6007680.96975 | 2101719.66165 | 37.751355903252 | -122.41628746589 | (37.751355903252, -122.41628746589) | |
| 79859 | 79859 | 93117 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2033 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2009 12:00:00 AM | 3x3 | Permit Number 777147 | 6000411.0 | 2115602.0 | 37.7890618407655 | -122.442424340369 | (37.7890618407655, -122.442424340369) | ||
| 13850 | 13850 | 98187 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1166 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777050 | 6009249.68117 | 2110819.91866 | 37.7764312088743 | -122.41150553135598 | (37.7764312088743, -122.411505531356) | |
| 16153 | 16153 | 98184 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1166 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777050 | 6009341.871809999 | 2110905.80719 | 37.7766722091935 | -122.41119268511001 | (37.7766722091935, -122.41119268511) | |
| 83606 | 83606 | 53980 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 314 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2016 12:00:00 AM | Permit Number 777049 | 5992334.38859686 | 2094817.59997169 | 37.731529684404 | -122.468855037458 | (37.731529684404, -122.468855037458) | |||
| 2634 | 2634 | 7336 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2100 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/22/2016 12:00:00 AM | 3 | 3X3 | Permit Number 777018 | 6002905.15105 | 2115557.99031 | 37.789082847149 | -122.43379176139601 | (37.789082847149, -122.433791761396) | |
| 5405 | 5405 | 24573 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2100 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/22/2016 12:00:00 AM | 3 | 3X3 | Permit Number 777018 | 6002899.36519 | 2115591.06429 | 37.789173331540006 | -122.43381414462799 | (37.78917333154, -122.433814144628) | |
| 107751 | 107751 | 114501 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 505 BRANNAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 776953 | 6013509.0 | 2111268.0 | 37.7778995269938 | -122.396802660196 | (37.7778995269938, -122.396802660196) | |||
| 87864 | 87864 | 115084 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 199X Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 776710 | 6014110.12135 | 2115859.25802 | 37.79053950816721 | -122.39504481844999 | (37.7905395081672, -122.39504481845) | |||
| 91585 | 91585 | 115083 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 199X Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 776710 | 6014110.12135 | 2115859.25802 | 37.79053950816721 | -122.39504481844999 | (37.7905395081672, -122.39504481845) | |||
| 105520 | 105520 | 115082 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 200 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 776710 | 6014455.603019999 | 2115753.90454 | 37.790269437366 | -122.393842085795 | (37.790269437366, -122.393842085795) | |||
| 93595 | 93595 | 38005 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2526 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 776097 | 5992081.33316725 | 2098238.92795225 | 37.7409091655778 | -122.46997891055099 | (37.7409091655778, -122.469978910551) | ||
| 140784 | 140784 | 38004 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2526 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 776097 | 5992081.33316725 | 2098238.92795225 | 37.7409091655778 | -122.46997891055099 | (37.7409091655778, -122.469978910551) | ||
| 57856 | 57856 | 114033 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 825 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2015 12:00:00 AM | 1 | 3x3 | Permit Number 775812 | 6011645.73419 | 2113018.5809299997 | 37.7826023306809 | -122.40337157173501 | (37.7826023306809, -122.403371571735) | |
| 11740 | 11740 | 108556 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 62 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773715 | 6001062.72482 | 2093636.21513 | 37.7287862806562 | -122.43859494063 | (37.7287862806562, -122.43859494063) |
| 14 | 14 | 196590 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | Permit Number 772992 | 6007565.6944699995 | 2109618.27361 | 37.773037177355796 | -122.41724576098301 | (37.7730371773558, -122.417245760983) | ||
| 15 | 15 | 196591 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | Permit Number 772992 | 6007555.65106 | 2109624.06249 | 37.7730525072055 | -122.417280912782 | (37.7730525072055, -122.417280912782) | ||
| 30 | 30 | 196592 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | Permit Number 772992 | 6007533.59843 | 2109642.31042 | 37.7731013709756 | -122.41735848920901 | (37.7731013709756, -122.417358489209) | ||
| 36688 | 36688 | 72131 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 975 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/2014 12:00:00 AM | 1 | Permit Number 772897 | 6012808.0555 | 2103001.2980400003 | 37.75516196906929 | -122.398647223515 | (37.7551619690693, -122.398647223515) | |
| 125529 | 125529 | 106710 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3869 19th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | Permit Number 772840 | 6003862.3 | 2104785.7 | 37.7595590509906 | -122.429711522366 | (37.7595590509906, -122.429711522366) | ||||
| 22939 | 22939 | 106926 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1630 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | 1 | Permit Number 772472 | 6006674.89128 | 2116548.04872 | 37.7920144933451 | -122.420819236116 | (37.7920144933451, -122.420819236116) | ||
| 83170 | 83170 | 107899 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101X Shields St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770994 | 5993727.26625 | 2089799.61042 | 37.717831878877796 | -122.46367556428301 | (37.7178318788778, -122.463675564283) | ||
| 86702 | 86702 | 107898 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101X Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770994 | 5993727.26625 | 2089799.61042 | 37.717831878877796 | -122.46367556428301 | (37.7178318788778, -122.463675564283) | ||
| 99389 | 99389 | 107901 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770994 | 5993727.26625 | 2089799.61042 | 37.717831878877796 | -122.46367556428301 | (37.7178318788778, -122.463675564283) | ||
| 112862 | 112862 | 107900 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101X Shields St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770994 | 5993727.26625 | 2089799.61042 | 37.717831878877796 | -122.46367556428301 | (37.7178318788778, -122.463675564283) | ||
| 139939 | 139939 | 105783 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 200 06th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770993 | 6010568.2 | 2111882.9 | 37.779423776156 | -122.40701932133999 | (37.779423776156, -122.40701932134) | |||
| 109866 | 109866 | 50464 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3861 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 770430 | 6004067.99679008 | 2101865.11785477 | 37.7515514669378 | -122.428791912654 | (37.7515514669378, -122.428791912654) | |||
| 93459 | 93459 | 22283 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4755X 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 6 | 3X3 | Permit Number 770204 | 6015037.5047362 | 2095657.5026115002 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | ||
| 109805 | 109805 | 22284 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4755X 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 6 | 3x3 | Permit Number 770204 | 6015037.5047362 | 2095657.5026115002 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | ||
| 175900 | 175900 | 105351 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 9 | 2040 Jackson St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/16/2014 12:00:00 AM | 3 | Permit Number 769933 | 6004399.13095 | 2117053.27366 | 37.7932731788779 | -122.428729419132 | (37.7932731788779, -122.428729419132) | ||
| 164033 | 164033 | 102491 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2001 McAllister St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2013 12:00:00 AM | 10 | 3x3 | Permit Number 769781 | 5999572.3 | 2111193.9 | 37.7769105000816 | -122.445009103471 | (37.7769105000816, -122.445009103471) | |
| 89922 | 89922 | 10245 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 99X Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2008 12:00:00 AM | 6 | 3X3 | Permit Number 769626 | 6005669.1162393 | 2109600.6288971 | 37.7728818463732 | -122.42380501439399 | (37.7728818463732, -122.423805014394) | |
| 112966 | 112966 | 102102 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 43-45 Pond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769434 | 6003182.0 | 2106269.0 | 37.7635932901021 | -122.43217026586399 | (37.7635932901021, -122.432170265864) | |||
| 15407 | 15407 | 101368 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 555 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2012 12:00:00 AM | 1 | 3x5 | Permit Number 769424 | 6009870.786169999 | 2111925.3371200003 | 37.77950124702579 | -122.40943497635901 | (37.7795012470258, -122.409434976359) | |
| 121029 | 121029 | 95865 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 495X Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/25/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769387 | 6010787.7 | 2111860.6 | 37.7793748261859 | -122.40625840277 | (37.7793748261859, -122.40625840277) |
| 140931 | 140931 | 50943 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 495X Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2004 12:00:00 AM | 5 | 3x3 | Permit Number 769387 | 6010718.64628694 | 2111838.4409772 | 37.7793101197955 | -122.406495727867 | (37.7793101197955, -122.406495727867) | |
| 56439 | 56439 | 100958 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1520 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769191 | 5999686.3 | 2114075.9 | 37.784830235107705 | -122.444821957123 | (37.7848302351077, -122.444821957123) | |
| 100428 | 100428 | 100961 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1520 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/2012 12:00:00 AM | 3x3 | Permit Number 769191 | 5999686.3 | 2114075.9 | 37.784830235107705 | -122.444821957123 | (37.7848302351077, -122.444821957123) | ||
| 134796 | 134796 | 100959 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1520 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/2012 12:00:00 AM | 9 | 3x3 | Permit Number 769191 | 5999686.3 | 2114075.9 | 37.784830235107705 | -122.444821957123 | (37.7848302351077, -122.444821957123) | |
| 178523 | 178523 | 100960 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1520 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/2012 12:00:00 AM | 6 | 3x3 | Permit Number 769191 | 5999686.3 | 2114075.9 | 37.784830235107705 | -122.444821957123 | (37.7848302351077, -122.444821957123) | |
| 60873 | 60873 | 100313 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1683 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769149 | 6015385.12474 | 2097976.75918 | 37.7415088772353 | -122.389384026569 | (37.7415088772353, -122.389384026569) | |
| 73846 | 73846 | 104571 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201X Channel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | Permit Number 769108 | 6011985.487369999 | 2113104.0493099997 | 37.7828559770513 | -122.402202175758 | (37.7828559770513, -122.402202175758) | |||
| 78713 | 78713 | 104578 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201X Channel St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | Permit Number 769108 | 6011985.487369999 | 2113104.0493099997 | 37.7828559770513 | -122.402202175758 | (37.7828559770513, -122.402202175758) | |||
| 83710 | 83710 | 104577 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201X Channel St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | Permit Number 769108 | 6011985.487369999 | 2113104.0493099997 | 37.7828559770513 | -122.402202175758 | (37.7828559770513, -122.402202175758) | |||
| 97145 | 97145 | 104582 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201X Channel St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | Permit Number 769108 | 6011985.487369999 | 2113104.0493099997 | 37.7828559770513 | -122.402202175758 | (37.7828559770513, -122.402202175758) | |||
| 98631 | 98631 | 104576 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201X Channel St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | Permit Number 769108 | 6011985.487369999 | 2113104.0493099997 | 37.7828559770513 | -122.402202175758 | (37.7828559770513, -122.402202175758) | |||
| 118056 | 118056 | 99734 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 9 | 145 Irving St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | |||
| 118375 | 118375 | 99733 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 9 | 145 Irving St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | |||
| 118863 | 118863 | 100464 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 9 | 145 Irving St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | |||
| 106402 | 106402 | 104595 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 600 York St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768703 | 6009795.0 | 2105479.0 | 37.7617968506256 | -122.409242130861 | (37.7617968506256, -122.409242130861) | |||
| 120098 | 120098 | 71514 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2619 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2012 12:00:00 AM | 2x3 | Permit Number 768322 | 5991090.80678191 | 2097577.58166717 | 37.739035968908205 | -122.47335552551 | (37.7390359689082, -122.47335552551) | ||
| 69147 | 69147 | 36158 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 124 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2011 12:00:00 AM | 5 | Permit Number 768284 | 5996572.4794 | 2113546.8019999997 | 37.7831992799989 | -122.455556442282 | (37.7831992799989, -122.455556442282) | |
| 177105 | 177105 | 36159 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 124 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2011 12:00:00 AM | 8 | Permit Number 768284 | 5996572.141 | 2113561.6926 | 37.7832401462145 | -122.455558689624 | (37.7832401462145, -122.455558689624) | |
| 95159 | 95159 | 96547 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 110127 | 110127 | 96546 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 110892 | 110892 | 96548 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 54814 | 54814 | 95915 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1900 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767613 | 5988090.4089 | 2102404.3375 | 37.7521147639454 | -122.484083263842 | (37.7521147639454, -122.484083263842) |
| 186874 | 186874 | 95891 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1691 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767599 | 5989637.9664 | 2103875.5933 | 37.7562444194269 | -122.478839232097 | (37.7562444194269, -122.478839232097) |
| 128453 | 128453 | 82740 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 705X Tehama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767578 | 6009380.46605511 | 2110537.73170402 | 37.7756637247842 | -122.41103317126499 | (37.7756637247842, -122.411033171265) | |
| 134729 | 134729 | 68259 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 325 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767439 | 6009656.71975 | 2092897.0157 | 37.7272417291967 | -122.408832675203 | (37.7272417291967, -122.408832675203) |
| 161390 | 161390 | 95557 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1333 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2011 12:00:00 AM | 3 | Permit Number 767350 | 6007169.60466 | 2115359.15301 | 37.788777950892 | -122.419023155908 | (37.788777950892, -122.419023155908) | ||
| 55715 | 55715 | 102680 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 77775 | 77775 | 102678 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 107377 | 107377 | 102675 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 107438 | 107438 | 102679 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 114786 | 114786 | 102677 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 122724 | 122724 | 102676 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 56602 | 56602 | 43984 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 547 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2012 12:00:00 AM | 7 | Permit Number 57029 | 6002992.49585 | 2090428.7998400002 | 37.7200890234651 | -122.431694694364 | (37.7200890234651, -122.431694694364) | ||
| 70563 | 70563 | 78353 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 168 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54052 | 6000350.309830001 | 2091388.3119599998 | 37.722573502235704 | -122.440896607905 | (37.7225735022357, -122.440896607905) |
| 159762 | 159762 | 95124 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 162 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54051 | 6000373.234540001 | 2091378.06199 | 37.722546663778 | -122.44081662760401 | (37.722546663778, -122.440816627604) |
| 86110 | 86110 | 22312 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5075 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | 07/08/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53643 | 6014763.8406325 | 2094744.5347125 | 37.7325993861716 | -122.39130633943701 | (37.7325993861716, -122.391306339437) | |
| 92333 | 92333 | 30751 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5075 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2013 12:00:00 AM | 3x3 | Permit Number 53643 | 6014764.79010723 | 2094744.21942808 | 37.7325985731591 | -122.391303034813 | (37.7325985731591, -122.391303034813) | ||
| 111556 | 111556 | 94586 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5075 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2013 12:00:00 AM | 3x3 | Permit Number 53643 | 6014754.3 | 2094747.4 | 37.7326067241724 | -122.39133952421801 | (37.7326067241724, -122.391339524218) | ||
| 124865 | 124865 | 30749 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5075 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | 03/08/2013 12:00:00 AM | 3 | 3x3 | Permit Number 53643 | 6014764.79010723 | 2094744.21942808 | 37.7325985731591 | -122.391303034813 | (37.7325985731591, -122.391303034813) | |
| 83982 | 83982 | 94337 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3600 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2010 12:00:00 AM | 3x3 | Permit Number 53630 | 6004357.0 | 2103675.0 | 37.7565373316099 | -122.42792145743401 | (37.7565373316099, -122.427921457434) | ||
| 85187 | 85187 | 94336 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3600 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2010 12:00:00 AM | 3x3 | Permit Number 53630 | 6004357.0 | 2103675.0 | 37.7565373316099 | -122.42792145743401 | (37.7565373316099, -122.427921457434) | ||
| 86428 | 86428 | 94338 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3600 21st St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2010 12:00:00 AM | 3x3 | Permit Number 53630 | 6004357.0 | 2103675.0 | 37.7565373316099 | -122.42792145743401 | (37.7565373316099, -122.427921457434) | ||
| 86451 | 86451 | 94335 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3600 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2010 12:00:00 AM | 3x3 | Permit Number 53630 | 6004357.0 | 2103675.0 | 37.7565373316099 | -122.42792145743401 | (37.7565373316099, -122.427921457434) | ||
| 91093 | 91093 | 94339 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3600 21st St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2010 12:00:00 AM | 3x3 | Permit Number 53630 | 6004357.0 | 2103675.0 | 37.7565373316099 | -122.42792145743401 | (37.7565373316099, -122.427921457434) | ||
| 106986 | 106986 | 94333 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3600 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2010 12:00:00 AM | 3x3 | Permit Number 53630 | 6004357.0 | 2103675.0 | 37.7565373316099 | -122.42792145743401 | (37.7565373316099, -122.427921457434) | ||
| 122191 | 122191 | 94334 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3600 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2010 12:00:00 AM | 3x3 | Permit Number 53630 | 6004357.0 | 2103675.0 | 37.7565373316099 | -122.42792145743401 | (37.7565373316099, -122.427921457434) | ||
| 15682 | 15682 | 92867 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4800 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53082 | 6014898.2926 | 2095492.3757 | 37.7346602666874 | -122.390893749601 | (37.7346602666874, -122.390893749601) |
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");